Answer:
In C3, you would enter the formula:
Explanation:
Let's assume the first row is 1 and it contains the titles of the columns. For instance, the content of the cellss A1:C1 could be:
Also, assume the second row is empty and the cells on the first column, A, contain the names of four regions. For instance, North, South, East, and West:
The cells B3:B6 contain the sales for the four regions. For instance:
Then, you must calculate the percent sales for every region, in the cells <em>C3:C6.</em>
That means, you must divide the sale of every region by the total of sales and multiply by 100.
To do that in the worksheet you do this:
<u>1. Sum the sales for the regions:</u>
- In cell B7 introduce: =SUM(B3:B6)
<u>2. Calculate the percent sale for the first region:</u>
- In cell C3 introduce: =B3/$B$7%
That means that the reference B3 is relative: when you copy that formula, the column (B) and the row (3) will change accordingly to the cell where you will copy it.
Thus, by using the Autofill into C4 through C6, the column wil remain unchanged (C) and the row will change to 4, 5, and 6, respectively.
The symbol $ used in $B$7 make the reference absolute. That means that they will not change. The symbol % makes that the result is multiplied by 100.
<u>3. When you use Autofull into C4 through C6, you obtain:</u>
