Starter quiz
- Match the term with its definition.
- spreadsheet⇔organises data in rows and columns ✓
- row⇔a line of data in a table that runs from left to right ✓
- column⇔a group of data in a table that runs from top to bottom ✓
- data⇔facts and figures in their raw form ✓
- How can you tell where things are kept in the classroom?
- there are labels ✓
- the colour of the item
- the time of day
- where the doors and windows are in the room
-
- What do we use spreadsheets for?
- writing stories
- drawing pictures
- organising and analysing data ✓
- playing music
-
- Which of these things is data?
- a painting
- a list of temperatures ✓
- a music album
- a novel
-
- In a spreadsheet, what is used to organise data in a group running from the top to the bottom?
- 'column' ✓
- What is a line of data in a spreadsheet that runs from left to right?
- 'row' ✓
Exit quiz
- What is a rectangular box in a spreadsheet used to store data called?
- 'cell' ✓
- What does a cell reference consist of?
- a colour and a shape
- a column letter and a row number ✓
- a word and a sentence
- a picture and a sound
-
- Which of these is a cell reference?
- 1
- A
- 1A
- A1 ✓
-
- Why is it important to format cells in a spreadsheet?
- to make the spreadsheet look colourful
- to ensure that data is displayed correctly ✓
- to hide the data
- to print the spreadsheet
-
- What should you do if spreadsheet software doesn't format data correctly?
- ignore the data
- delete the data
- manually format the cells ✓
- print the spreadsheet
-
- Order these steps for formatting a cell in a spreadsheet.
- 1⇔Select the cell.
- 2⇔Choose the 'Format' menu.
- 3⇔Select the data format you want.
- 4⇔Apply the data format.
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Video
Lesson Details
Key learning points
- An individual item of data is recorded in a spreadsheet cell.
- Cell references combine the column letter and row number to individually identify every cell in a spreadsheet.
- Data formats are applied to cells of a spreadsheet so that it is clear what the data entered represents.
Common misconception
Spreadsheet software is so good now that you don't need to spend time formatting cells for the expected data as it will do it automatically.
Spreadsheet software can help, but you still need to format cells correctly to make sure the data will be displayed in the exact way you need it to be. Software doesn't always get this right.
Keywords
Cell - a rectangular box in a spreadsheet used to store data
Data format - the way in which data is arranged and presented in a spreadsheet
+