به انگلیسی

Cells That Do the Math

Computing · Digital Literacy · ages 11-13

Name ______________________ Date ____________

A1 holds 4 and A2 holds 7. What does =A1+A2 show?
- 10
- 11
- 47
What does a formula always start with?
- An equals sign
- A full stop
- A smiley
A worksheet is a tab inside a workbook.
Circle one: True False
Which sign means multiply in a sheet?
- x
- .
- *
A1 holds 10 and A2 holds 7. Type what =A1+A2 shows.
Answer: ______________
Copying a formula down a column shifts its cell names to each new row.
Circle one: True False
A total shows 11 after A1 changed from 4 to 10, but A2 still holds 7. What is broken?
- The formula points at fixed numbers, not the cells
- The sheet needs paint
- The numbers are too small
B2 holds 3 and C2 holds 4. D2 holds =B2*C2+2. Type what D2 shows.
Answer: ______________

Answer key

For grown-ups. Fold this page away before handing over the rest.

11 · It adds the two cells: 4 plus 7 is 11.
An equals sign · The equals sign tells the sheet that maths follows.
True · A workbook holds many worksheet tabs.
* · Sheets use star for times, so =B2*C2 multiplies.
17 · Add the cells: 10 plus 7 is 17.
True · One copied rule serves every row with its own cells.
The formula points at fixed numbers, not the cells · A true formula would show 17, so this one never pointed at the cells.
14 · Times first: 3 times 4 is 12, plus 2 is 14.