Question

given the following spreadsheet write the appropriate formula to be used for
A) write the formula to calculate the total sales of north zone
B) write the feature used for arranging the sales from lowest to the highest

Answer 1

The formula are given below.

Explanation:

(a) Select the cell B3+C3+D3+E3 and then click on the auto sum button.

We can follow this rule: =sum(B3+C3+D3+E3)

(b) Select the cells of the total then click on the Data tab.

Then go on sort and filtering group and click on short z to an icon.

Answer 2

ᗩᑎՏᗯᗴᖇ:-

(a) Select the cell B3+C3+D3+E3 and then click on the auto sum button.

• We can follow this rule: =sum(B3+C3+D3+E3)

(b) Select the cells of the total then click on the Data tab.

• Then go on sort and filtering group and click on short z to an icon.