Question

merge
b) Given the following Spreadsheet , write the appropriate Formula Expressio
used for a to e
А
B
с
D
E
F
G
1
Quarterly sales report
2
Zone Jan Apr Jul-Sep Jan-
Total
Mar Jun
Mar
3
North
500 420 290 400
4
West 150 130 400 250
5
East 400 270 320 350
6
South 540 530 457 380
7
a) Write the formula to Calculate the total sales of West zone
b) Name the feature used in the second row from A to H column
2) Why is it better to view any information on a graph rather than on a spreadsheet
1) To find Average sales Jul-Sep in cell D7
e) To find the difference between the sales in East Zone and West Zone in Apr-June​

Answer 1

Answer:

to understand and answer on spreadsheet you must know all the formula of spreadsheet. if you know let me I will tell you. please mark me as brilliant