Starter quiz
- Put these steps for dealing with data in the correct order.
- 1⇔Data is collected.
- 2⇔Data is organised.
- 3⇔Data is analysed.
- What symbol is used to start a formula in a spreadsheet?
- '=' ✓
- What do you call a group of cells used in a formula?
- 'range' ✓
- Write the formula to subtract cell A5 from B8.
- '=B8-A5' ✓
- What does the SUM function do in a spreadsheet?
- multiplies cells
- divides cells
- adds cells ✓
- subtracts cells
-
- What does the term 'replicate' mean in the context of spreadsheets?
- Copy a formula to other cells. ✓
- Delete a formula.
- Create a graph.
- Format text.
-
Exit quiz
- Match the terms with their definitions.
- replicate⇔copying formulas to other cells ✓
- SUM function⇔something that adds up numbers ✓
- cell reference⇔something that identifies a specific cell ✓
- budget⇔an amount of money planned to be spent ✓
- subtotal⇔a part of an overall total ✓
- formula⇔something that performs calculations ✓
- How do spreadsheets make planning an event easier?
- by making data entry more difficult
- by providing useful tools and allowing changes ✓
- by eliminating the need for budgets
- by automatically planning everything
-
- What is the smallest unit of data storage in a spreadsheet where you can enter information?
- 'cell' ✓
- What does it mean to replicate a formula in a spreadsheet?
- to delete the formula
- to create a graph from the formula
- to copy the formula to multiple cells, with cell references adjusting as needed ✓
- to change the font of the formula
-
- Why do people create budgets?
- to increase their income automatically
- to manage and control their spending ✓
- to avoid planning for future expenses
- to eliminate the need for financial records
-
- Order these steps for using a spreadsheet when budgeting.
- 1⇔Create a new spreadsheet.
- 2⇔Set goals for the budget.
- 3⇔Enter expenses.
- 4⇔Calculate subtotals and totals.
- 5⇔Analyse results.
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Video
Lesson Details
Key learning points
- Spreadsheets are useful as planning tools.
- A budget is a value of money that can be spent as part of a plan.
- Subtotals are used to work out overall totals in smaller steps.
Common misconception
Spreadsheets make planning an event more difficult as you have to enter data and use formulas.
Spreadsheets make planning an event easier as they have useful tools that save you work and allow you to make changes. You can use spreadsheets to model changes to the event and instantly recalulate all the important information.
Keywords
Budget - an amount of money planned to be spent
Subtotal - a part of an overall total based on some of the values
+