Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.
Shade in the A or B circle for each question.
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1age = 11 | ANumeric data: a number you can add, subtract or average | |
| 2name = "Mia" | Bphone = "0412 345 678" | |
| 3A phone number is text data because you never add or average it | Cdays = "2025-03-10" - "2025-03-05" | |
| 4A date like 5 March is stored as a date, so you can work out the days between two dates | DPhone numbers are text data, not numeric data, so averaging them is meaningless. | |
| 5=SUM(A2:A4) where A2:A4 are "cat", "dog", "fish" | EText data: letters in quote marks that you cannot add up | |
| 6average_phone = AVERAGE(0412345678, 0498765432) | FSUM only works on numeric data. Pet names are text, so there is nothing to add up. |
Complete each line of code by filling in the missing parts.
Shade in the letter of the line that contains an error.
numeric data vs text data — Numeric data is numbers you can calculate with, like 12 or 3.5. Text data is words and characters, like cat or a phone number, which you never add up or average.Age: 12
This is numeric data we can add upPhone: "0412 345 678"
This is text data, not for addingScores in B2 to B4 are numbers
=SUM(B2:B4)Today = 20, Test = 25
Days left = 25 - 20Numbers: 4 and 6
Average = (4 + 6) / 2