A1 holds 4 and A2 holds 7. What does =A1+A2 show?
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?
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: ______________
Cells That Do the Math W1-mt_iWyPF0-Abz-s1
- 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.