Formula used to find the maximum sales in East Zone
Answers
Answered by
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