Question

Qs 3. Given the following Spreadsheet, write the
appropriate Formula/ Expression/Function to be used
for (a) to (d) :
D
F
G
H
1
2
Quarterly sales report
Zone Jan-Mar Apr Jun Jul-Sep Oct-Dec Total
North 500 420 290 400
3
4
West
160
130
400
250
s
3
East
400
270
320
350
6
South
540
530
457
380
7
(a) Write the formula to calculate the Total sales of
North Zone.
(b) To find the Maximum Sales in East Zone.
(c) To find the Average Sales in Jan-Mar in cell 07.
s
(d) To find the difference between the sales in East
Zone and West Zone in Apr-Jun.​

Answer 1

SKDJDJEPEIJEKWKSJSJ

Explanation:

HEIEHENKWKEURHRJ