Question

Consider the following data given below and write the formulas:

(a) Write the formula to calculate the total sale in north Zone (b) Write the feature used for arranging the sales from lowest to highest. (c) Write the formula to find the maximum sales in across all zones all quarters. (d) Find the average sales Jan-Mar , July-Sept and Oct-Dec of South zone. ( e) Find the difference of sales in July Sept between North and South.



Addile

Back

Submit


​

Answer 1

Answer:

a) total revenue = (average price per units sold) x (number of units sold)

total revenue = (average price per services sold) x (number of services sold)

total revenue = (total number of goods sold) x (average price per good sold)

b) To sort the numbers in ascending or descending order, we use the formulas “LARGE”, “SMALL” and “ROW” in Microsoft Excel. To sort in ascending order use the “SMALL” function along with the “ROW” function