| |
Exercise 3 |
| |
Create a new worksheet and rename it Exercise3
|
| |
Now it's time to calculate the values.
|
| 1 |
The formula for E3 is: =sum(C3*d3) The asterisk is the Excel times command.
|
| |
Now for each row you do not have to do the formula over and over again.
|
| 2 |
Instead select E3 and fill down. The command will copy the formual and give the answers.
|
| 3 |
Then use the formula: =sum(D3:D14)
|
