Mr Job's Maths Class

Lessons

Spreadsheets #1

Topics:

a:14:{s:16:"6gRnX1suslp0M23S";a:3:{s:12:"element_type";s:7:"heading";s:16:"element_settings";s:240:"YToyOntzOjQ6InR5cGUiO3M6NzoiaGVhZGluZyI7czo4OiJzZXR0aW5ncyI7YTo2OntzOjU6InRpdGxlIjtzOjc6IkhlYWRpbmciO3M6MjoiaDMiO3M6MToiMSI7czoyOiJoNCI7czoxOiIxIjtzOjI6Img1IjtzOjE6IjEiO3M6MjoiaDYiO3M6MToiMSI7czozOiJlaWQiO3M6MTY6InY1dE9MVFNxZHFXNTBvcUIiO319";s:4:"data";s:136:"a🔢{s:10:"heading_id";s:16:"6gRnX1suslp0M23S";s:12:"heading_data";a🔢{s:7:"heading";s🔢"h3";s:7:"content";s:17:"Changing the look";}}”;}s:16:“VUa0HfG4Ap6f54Ai”;a:3:{s:12:"element_type";s:6:"wygwam";s:16:"element_settings";s:204:"YToyOntzOjQ6InR5cGUiO3M6Njoid3lnd2FtIjtzOjg6InNldHRpbmdzIjthOjQ6e3M6NjoiY29uZmlnIjtzOjE6IjYiO3M6NToiZGVmZXIiO3M6MToibiI7czozOiJlaWQiO3M6MTY6InhUbGsydEJUd2huME5jUnQiO3M6NToidGl0bGUiO3M6NjoiV3lnd2FtIjt9fQ==";s:4:"data";s:236:"

For this spreadsheet (download):

  1. Centre the numbers in columns B, C and D.
  2. Move the position of the 'Total' label.
  3. Make the column A wider to fit the 'Orange Juice' label.
";}s:16:“6Lqk2rbzIx5VoncW”;a:3:{s:12:"element_type";s:6:"assets";s:16:"element_settings";s:380:"YToyOntzOjQ6InR5cGUiO3M6NjoiYXNzZXRzIjtzOjg6InNldHRpbmdzIjthOjg6e3M6ODoiZmlsZWRpcnMiO2E6MTp7aTowO3M6NDoiZWU6OCI7fXM6NDoidmlldyI7czo0OiJsaXN0IjtzOjEwOiJ0aHVtYl9zaXplIjtzOjU6InNtYWxsIjtzOjE0OiJzaG93X2ZpbGVuYW1lcyI7czoxOiJuIjtzOjk6InNob3dfY29scyI7YToxOntpOjA7czo0OiJuYW1lIjt9czo1OiJtdWx0aSI7czoxOiJ5IjtzOjM6ImVpZCI7czoxNjoibG1nMVVRTE1GSEc2VXp3NiI7czo1OiJ0aXRsZSI7czo0OiJGaWxlIjt9fQ==";s:4:"data";s:11:"canteen.xls";}s:16:“zCNO87LpZyuVt7ay”;a:3:{s:12:"element_type";s:7:"heading";s:16:"element_settings";s:240:"YToyOntzOjQ6InR5cGUiO3M6NzoiaGVhZGluZyI7czo4OiJzZXR0aW5ncyI7YTo2OntzOjU6InRpdGxlIjtzOjc6IkhlYWRpbmciO3M6MjoiaDMiO3M6MToiMSI7czoyOiJoNCI7czoxOiIxIjtzOjI6Img1IjtzOjE6IjEiO3M6MjoiaDYiO3M6MToiMSI7czozOiJlaWQiO3M6MTY6InY1dE9MVFNxZHFXNTBvcUIiO319";s:4:"data";s:136:"a🔢{s:10:"heading_id";s:16:"zCNO87LpZyuVt7ay";s:12:"heading_data";a🔢{s:7:"heading";s🔢"h3";s:7:"content";s:17:"Entering Formulas";}}”;}s:16:“WIurgSwa69Zs31Hw”;a:3:{s:12:"element_type";s:6:"wygwam";s:16:"element_settings";s:204:"YToyOntzOjQ6InR5cGUiO3M6Njoid3lnd2FtIjtzOjg6InNldHRpbmdzIjthOjQ6e3M6NjoiY29uZmlnIjtzOjE6IjYiO3M6NToiZGVmZXIiO3M6MToibiI7czozOiJlaWQiO3M6MTY6InhUbGsydEJUd2huME5jUnQiO3M6NToidGl0bGUiO3M6NjoiV3lnd2FtIjt9fQ==";s:4:"data";s:743:"

Formulas are entered into spreadsheets by starting with an = sign.

The five basic mathematical operations used in formulas are:

+ addition
- subtraction
* multiplication (* is shift 8 on the keyboard)
/ division (bottom row of keys, right-hand side)
^ power (shift 6)

Basic Operations Animated GIF

Addition: =B1+B2

Subtraction: =B1-B2

Multiplication: =B1*B2

Division: =B1/B2

”;}s:16:“1Iq4myWKzWVkCDpe”;a:3:{s:12:"element_type";s:7:"heading";s:16:"element_settings";s:240:"YToyOntzOjQ6InR5cGUiO3M6NzoiaGVhZGluZyI7czo4OiJzZXR0aW5ncyI7YTo2OntzOjU6InRpdGxlIjtzOjc6IkhlYWRpbmciO3M6MjoiaDMiO3M6MToiMSI7czoyOiJoNCI7czoxOiIxIjtzOjI6Img1IjtzOjE6IjEiO3M6MjoiaDYiO3M6MToiMSI7czozOiJlaWQiO3M6MTY6InY1dE9MVFNxZHFXNTBvcUIiO319";s:4:"data";s:147:"a🔢{s:10:"heading_id";s:16:"1Iq4myWKzWVkCDpe";s:12:"heading_data";a🔢{s:7:"heading";s🔢"h3";s:7:"content";s:28:"Exercise 1: Entering Formula";}}”;}s:16:“P3WbTSCQgd7Tl8zp”;a:3:{s:12:"element_type";s:10:"text_field";s:16:"element_settings";s:232:"YToyOntzOjQ6InR5cGUiO3M6MTA6InRleHRfZmllbGQiO3M6ODoic2V0dGluZ3MiO2E6NDp7czo1OiJ0aXRsZSI7czo0OiJUZXh0IjtzOjEyOiJjb250ZW50X3R5cGUiO3M6MDoiIjtzOjE0OiJjb250ZW50X2Zvcm1hdCI7czo0OiJub25lIjtzOjM6ImVpZCI7czoxNjoib0FhMFB4UTg5cnlFNTNsaCI7fX0=";s:4:"data";s:22:"Download and complete:";}s:16:“JWXo2asSA2qy4t4X”;a:3:{s:12:"element_type";s:6:"assets";s:16:"element_settings";s:380:"YToyOntzOjQ6InR5cGUiO3M6NjoiYXNzZXRzIjtzOjg6InNldHRpbmdzIjthOjg6e3M6ODoiZmlsZWRpcnMiO2E6MTp7aTowO3M6NDoiZWU6OCI7fXM6NDoidmlldyI7czo0OiJsaXN0IjtzOjEwOiJ0aHVtYl9zaXplIjtzOjU6InNtYWxsIjtzOjE0OiJzaG93X2ZpbGVuYW1lcyI7czoxOiJuIjtzOjk6InNob3dfY29scyI7YToxOntpOjA7czo0OiJuYW1lIjt9czo1OiJtdWx0aSI7czoxOiJ5IjtzOjM6ImVpZCI7czoxNjoibG1nMVVRTE1GSEc2VXp3NiI7czo1OiJ0aXRsZSI7czo0OiJGaWxlIjt9fQ==";s:4:"data";s:21:"entering-formula.xlsx";}s:16:“EhLIcOVNWfWi7dFK”;a:3:{s:12:"element_type";s:7:"heading";s:16:"element_settings";s:240:"YToyOntzOjQ6InR5cGUiO3M6NzoiaGVhZGluZyI7czo4OiJzZXR0aW5ncyI7YTo2OntzOjU6InRpdGxlIjtzOjc6IkhlYWRpbmciO3M6MjoiaDMiO3M6MToiMSI7czoyOiJoNCI7czoxOiIxIjtzOjI6Img1IjtzOjE6IjEiO3M6MjoiaDYiO3M6MToiMSI7czozOiJlaWQiO3M6MTY6InY1dE9MVFNxZHFXNTBvcUIiO319";s:4:"data";s:125:"a🔢{s:10:"heading_id";s:16:"EhLIcOVNWfWi7dFK";s:12:"heading_data";a🔢{s:7:"heading";s🔢"h3";s:7:"content";s:7:"Canteen";}}”;}s:16:“07qx8mXoAPWS3aRM”;a:3:{s:12:"element_type";s:6:"wygwam";s:16:"element_settings";s:204:"YToyOntzOjQ6InR5cGUiO3M6Njoid3lnd2FtIjtzOjg6InNldHRpbmdzIjthOjQ6e3M6NjoiY29uZmlnIjtzOjE6IjYiO3M6NToiZGVmZXIiO3M6MToibiI7czozOiJlaWQiO3M6MTY6InhUbGsydEJUd2huME5jUnQiO3M6NToidGl0bGUiO3M6NjoiV3lnd2FtIjt9fQ==";s:4:"data";s:1325:"

Use the Canteen Sales spreadsheet from above.

  1. Enter the week 1 prices into column C for week 2.
    • Enter a formula into cell D12 that multiplies the values in cells B12 and C12.
    • What amount is showing now in cell D12?
    • What does the amount in cell D12 represent?

  3. The formula in cell D12 multiplies the number of drinks sold by the price per drink. The same formula is required in cells D13 to D15.

    To put this formula into cells D13 to D15 use Fill Down (see picture).

  4. Find the total number of drinks sold in Week 2.

    • Click on cell B17.

    • Type =SUM(B12:B15) and press Enter.

    • How many drinks were sold at the canteen during week 2?

  5. Enter a formula in cell D17 to calculate the total value of the drinks sold in week 2.

Animated screenshot

”;}s:16:“7za5zKgpa8zk78HM”;a:3:{s:12:"element_type";s:7:"heading";s:16:"element_settings";s:240:"YToyOntzOjQ6InR5cGUiO3M6NzoiaGVhZGluZyI7czo4OiJzZXR0aW5ncyI7YTo2OntzOjU6InRpdGxlIjtzOjc6IkhlYWRpbmciO3M6MjoiaDMiO3M6MToiMSI7czoyOiJoNCI7czoxOiIxIjtzOjI6Img1IjtzOjE6IjEiO3M6MjoiaDYiO3M6MToiMSI7czozOiJlaWQiO3M6MTY6InY1dE9MVFNxZHFXNTBvcUIiO319";s:4:"data";s:135:"a🔢{s:10:"heading_id";s:16:"7za5zKgpa8zk78HM";s:12:"heading_data";a🔢{s:7:"heading";s🔢"h3";s:7:"content";s:16:"Formatting cells";}}”;}s:16:“womka0SaX1qSQRQS”;a:3:{s:12:"element_type";s:6:"wygwam";s:16:"element_settings";s:204:"YToyOntzOjQ6InR5cGUiO3M6Njoid3lnd2FtIjtzOjg6InNldHRpbmdzIjthOjQ6e3M6NjoiY29uZmlnIjtzOjE6IjYiO3M6NToiZGVmZXIiO3M6MToibiI7czozOiJlaWQiO3M6MTY6InhUbGsydEJUd2huME5jUnQiO3M6NToidGl0bGUiO3M6NjoiV3lnd2FtIjt9fQ==";s:4:"data";s:193:"

Format cells D12 to D17 to be currency.

”;}s:16:“XH3e07DmswDQdqnO”;a:3:{s:12:"element_type";s:7:"heading";s:16:"element_settings";s:240:"YToyOntzOjQ6InR5cGUiO3M6NzoiaGVhZGluZyI7czo4OiJzZXR0aW5ncyI7YTo2OntzOjU6InRpdGxlIjtzOjc6IkhlYWRpbmciO3M6MjoiaDMiO3M6MToiMSI7czoyOiJoNCI7czoxOiIxIjtzOjI6Img1IjtzOjE6IjEiO3M6MjoiaDYiO3M6MToiMSI7czozOiJlaWQiO3M6MTY6InY1dE9MVFNxZHFXNTBvcUIiO319";s:4:"data";s:142:"a🔢{s:10:"heading_id";s:16:"XH3e07DmswDQdqnO";s:12:"heading_data";a🔢{s:7:"heading";s🔢"h3";s:7:"content";s:23:"Calculating Percentages";}}”;}s:16:“qdgkQ1gN0R6UbBkf”;a:3:{s:12:"element_type";s:6:"wygwam";s:16:"element_settings";s:204:"YToyOntzOjQ6InR5cGUiO3M6Njoid3lnd2FtIjtzOjg6InNldHRpbmdzIjthOjQ6e3M6NjoiY29uZmlnIjtzOjE6IjYiO3M6NToiZGVmZXIiO3M6MToibiI7czozOiJlaWQiO3M6MTY6InhUbGsydEJUd2huME5jUnQiO3M6NToidGl0bGUiO3M6NjoiV3lnd2FtIjt9fQ==";s:4:"data";s:253:"

Complete the steps in the image to calculate the percentage of each drink sold compared with the total number of drinks sold.

“;}}



http://gomaths.net/4277 | show



Wolfram Alpha can do many maths questions.

Scientific Calculator