🎯 Learning Objectives
- Use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /)
- Use the autofill tool to replicate cell data
💬 Key Vocabulary
- drag handle
- autofill
- formula
- cell reference
- row
- column
📝 Homework from last lesson
- Take out your homework from the last lesson and prepare to swap it with the person your teacher tells you to.
- Open up a new Excel spreadsheet and follow the instructions they have written down to create their flag.
📝 Lesson 2 Activity Spreadsheet
- Download the Lesson 2 Activity Spreadsheet below, all your level tasks for today will be done inside this spreadsheet.
- First of all, complete the Starter – Fill in the blanks sheet section to create the two times table.
- Your teacher will now show you some super spreadsheet tips and tricks to make your life much easier when working with numbers in Excel.
- You then need to complete all the level tasks shown in the sheet tabs at the bottom of Excel.
- There are some tips below if you missed them when your teacher told you about them.
How to make a formula
- Click in the cell you wish to make the formula.
- In the cell, type: =C20*E20
- Press Enter
Using a formula
- A formula always starts with the = symbol
- Symbol for multiplication: *
- Symbol for division: /
In this lesson, you…
- Basic formulas to perform calculations
- Autofill to quickly perform calculations
Next lesson, you will…
- Look at the difference between data and information
- Collect some data
🏅 Level up
🥇 Level 1
- Complete the Level 1 – Times tables sheet in the Lesson 2 Activity Spreadsheet and upload it to Teams.
🥈 Level 2
- Complete the Level 2 – Cake Recipes sheet in the Lesson 2 Activity Spreadsheet and upload it to Teams.
🥉 Level 3
- Complete the Level 3 – Party sheet in the Lesson 2 Activity Spreadsheet and upload it to Teams.