Performing Calculations in a Spreadsheet

A spreadsheet's real power in in crunching-numbers - and doing it very, very quickly, no matter how many calculations are to be done.

You will do calculations involving additions, subtraction, multiplication and division and will use formulae to carry out these calculations. The spreadsheet will dot he calculation you ask it to do correctly. However, whether an addition or a subtraction etc. is required will be up to you. if you get it wrong, the answer will be wrong. So always think before you complete a formula.

To Do

5.View the movie file Totals.

b. Download the file totals and complete the exercise as shown.

Not all formulae involve additions. For instance, calculations can involve subtractions.

To Do

6.View the movie file Car Sale.

b. Download the file cars and complete the exercise as shown.

Some multiplication.

To Do

7.View the movie file Tuck Shop.

b. Download the file tuck shop and complete the exercise as shown.

Remember to tick off your progress grids.

Continue to Calculating a Percentage