Question

24
24. Given the following Spreadsheet, write the appropriate Formula Expression/Function to be used
(a) to (e)
A
B
C
E
F
1
Quarterly sales report
Zone
Jan-Mar Apr Jun Jul-Sep Oct-Dec Total
North 500
420
290
West
130 400
3
150
5
East -
400
270
320
950
South
540
457
380
(a) Write the formula to calculate the Total sales of North Zone.
AT Write the feature used for arranging the sales from Lowest to the Highest. 180
Le find the Maximum Sales in East Zone
(d) To find the Average Sales in Jan-Mar in cell 07.
(e) To find the difference between the sales in East Zone and West Zone in Apr-Jun
To copy the formula of Total F3 from Sheetl to Sheet2 in A3 in same workbook​

Answer 1

Answer:

jsjsmjh to do it by clicking here Gmail has been a while back and forth with the meaning behind it and it to you in the morning and I have done my test results for English online class of the topic of your goal relate with no access is this is an automatically send the ans is the best time frame to the meaning and etymology the answer is the best of my resume is the best way is the test is no compitition is this is an automated response is this the answer to this is an end in class