Question

H
Section 0 : Long Answer
(S marks each)
1. Given the following Spreadsheet, write the approenzte l'ormula/ Expression/Furiction to be used for (al to ſet
D
1
Quarterly sales report,
Jan Mär
Oct Olec Toto
North
200
250
5
220
6
380
7
Te Write the formula to calculate e Totál sales of North Zane
(b) Write the feature used for arranging the sales from lowest to the Highest
(c) To find the Maximum Sales in ſnuzone
d) To find the Average Sales In Jan-Marin cell 07.
(e) To find the difference between the sales in East Zone arid West Yone lo Aprelun​

Answer 1

Answer:

bzbshwjhss

end.can

mfdm