i) Write the formula to calculate the Total Sales of North Zone.ii) Write the feature used for arranging the Sales from Lowest to the Highest.iii) To find the Maximum Sales in East Zone.iv) To find the differences between the sales in East Zone and West Zone in Apr-Jun.
Answers
1)Enter "=sum(B1:B#)" in the next empty cell in the B column, and replace "#" with the row number of the last filled cell in column B. In the example, you would enter "=sum(B1:B2)" in cell B3 to calculate the total sales of the two items. Type "=item_sales/total_sales" in the C column for each item row.
2)The feature used for arranging the price from the highest to the lowest is called SORT. The formula is =LARGE(data, ROWS(exp_rng)).
3)Sales represents the total units you sold, multiplied by the sale price per unit. The formula for net sales is (Gross sales) less (Sales returns, allowances and discounts
4)The sales in the east zone is higher as compared to the west zone in April to June in 2020. Explanation: This mainly includes the sale of automobiles and other items related to the iron and steel industry. This is because they contribute highly in the the economy of the country.
ANSWERS
i - =SUM(C4:F4)
iii - =MAX(C6:F6)
iv - AVERAGE (C4:C7)
v - =D6-D5
