Starter quiz
- What is the main purpose of using a table to organise data?
- to confuse people
- to hide data
- to delete data
- to make data easier to understand ✓
-
- What does 'replicate' mean in the context of spreadsheets?
- delete data
- copy formulas ✓
- create a new spreadsheet
- format data
-
- What is a rectangular box in a spreadsheet called?
- 'cell' ✓
- What is used to perform calculations in a spreadsheet?
- 'formula' ✓
- Type the formula to add cell A1 to B3:
- '=A1+B3' ✓
- Type the formula to divide B1 by C1:
- '=B1/C1' ✓
Exit quiz
- What does a range of cells refer to in a spreadsheet?
- a single cell
- a group of cells which are not touching
- a collection of cells that are next to each other ✓
- a single column
-
- How would you type in the range of cells that include A1, A2, A3, B1, B2 and B3.
- 'A1:B3' ✓
- Which of the following is NOT a benefit of using spreadsheet functions?
- simplifying complex calculations
- reducing manual errors
- saving time
- making data entry more difficult ✓
-
- What should you do if a pre-built function exists for your calculation needs?
- ignore it
- use it to save time and reduce errors ✓
- create a new formula
- Avoid using it
-
- How do you calculate the average of values in cells A1 to A5 using a spreadsheet function?
- '=Average(A1:A5)' ✓
- Match the term to its definition:
- formula⇔A mathematical expression that calculates a value. ✓
- function⇔An operation that performs calculations on a range of data. ✓
- sum⇔The total of a group of numbers. ✓
- count⇔The number of items in a range. ✓
- average⇔The mean value of a group of numbers. ✓
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Video
Lesson Details
Key learning points
- A range of cells is a collection of cells located directly next to each other.
- A function in a spreadsheet performs a preset formula to a cell using any number of other cells.
- Use of pre-built functions in spreadsheets makes it easier to perform complex calculations.
Common misconception
You should create a formula in a spreadsheet yourself even if a pre-built function already exisits that does what you need your formula to do.
Use pre-built spreadsheet functions whenever possible to save time and avoid mistakes. Use of technology should help you find ways to assist in what you need to do.
Keywords
Function - a ready-made instruction that performs a specific mathematical job
Range - a group of cells that are next to each other
+