Computer Science, asked by zzzzzzzzzzz7085, 1 month ago

Formula used to find the maximum sales in East Zone

Answers

Answered by dapushree
4

Answer:

(a) Write the formula to calculate the Total sales of North Zone. =SUM(C4:F4)

(b) Write the feature used for arranging the Sales from Lowest to the Highest.

(c) To find the Maximum Sales in East Zone. =MAX(C6:F6)

(d) To find the Average Sales in Jan-Mar in cell C7. =AVERAGE(C4:C7)

(e) To find the difference between the sales in East Zone and West Zone in Apr-Jun. =D6-D5

Explanation:

hope it's helpful

Similar questions