Question

(d) hide ruler
1x4=4
8. On the basis of the worksheet given below, answer the questions that follow : 1x4=4
F
14
HER
35
12
1 Sales Data
2 Item Selling Price Quantity Sale Value
Notebook
4 Diary
5 Marker
18
6 Pen
12 150
7 Board
15
8 Total
22
3
SE FEEL
LLLLL
(a) Write a formula to display the sale value (Selling Price * Quantity) of the
first item in cell D3.
(b) Write the step(s) to copy the above formula to the cells D4 to D7.
(0) Write a formula to calculate total sale value in cell 08.
(d) Write down the steps to insert a column for serial number before column A.​

Answer 1

bro this question is tough

I was not able to understand

Answer 2

Answer:

on the basis of the given worksheet answers given at the end