Question

87. (a) (b) (c) (d) (e) (b) Explain Client-Server architecture and Peer-to-Peer Architecture Given the following Spreadsheet, write the appropriate Formula Expression/Function to be used for (a) to (e) : 400 West 6 Quarterly sales report Zone Jan-Mar Apr-Jun Jul-Sep Oct-Dec Total North 500 420 290 East 150 130 400 250 400 270 320 350 South 540530457380 Write the formula to calculate the Total sales of North Zone. Write the feature used for arranging the Sales from Lowest to the Highest. To find the Maximum Sales in East Zone. To find the Average Sales in Jan-Mar in cell C7. To find the difference between the sales in East Zone and West Zone in Apr-Jun.

Answer 1

Answer: =sum(b3:e5)

Sort

=Max(b5:e5)

=Sum(b3:b6)

=Difference(b5:b4)

Explanation:ko

Answer 2

Heyyour answer is in the given attachment

HOPE IT IS HELPFUL.

❤@thank you@❤