Your Turn

Now you know how to make 2Calculate Spreadsheets, have a go at solving some problems.

Times Tabler

Watch this video of a “Times Table” spreadsheet. See if you can spot how it works so that you can choose which times table it calculates. Can you extend it to 12 x the chosen number (or further)?

Party Price Predictor

If you were having a party, it would be good to know how much it was going to cost. That depends on how many people are coming and what you are serving.

Watch the screen video of this party planner spreadsheet. Can you see what special character (letter-like object) is used to make the formula always use the number of guests?

  • Make your own party planner.
  • Add a cell that totals all the prices.