Arithmetic operators + - * /
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which symbol multiplies two numbers in a spreadsheet formula?
2. Which symbol divides in a spreadsheet formula?
3. Which formula adds the numbers in A1 and B1?
4. What does =10-4 show in a cell?
5. What does =6*3 show in a cell?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1=A1*B1 | ADivides the number in C2 by 4 | |
| 2=C2/4 | B=A1-B1 | |
| 3Add 3 to the score in B2, then multiply the answer by 2 | CThe letter x was used to multiply. A formula needs the * symbol, so it should be =A1*3. | |
| 4Subtract the money spent in B1 from the money saved in A1 | D=(B2+3)*2 | |
| 5=A1x3 | EWithout brackets, B1*2 is worked out first. It should be =(A1+B1)*2 to add first. | |
| 6=A1+B1*2 (to add first, then multiply) | FMultiplies the number in A1 by the number in B1 |
C
Definitions
+ - * /
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
=A1_B1
2.
=A1_B1
3.
=_A1+B1)*2
4.
=C2_D2
5.
=(A1+B1)_2
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
A1: 12
B
B1: 4
C
C1: =A1+B1
D
D1: =A1xB1
Question 2
A
A1: 20
B
B1: 3
C
C1: =A1+B1
D
# A1 is price, B1 is how many
Question 3
A
# Add 4 to A1, then double it
B
B1: =(A1+4)2
C
A1: 6
Question 4
A
A1: 30
B
B1: 5
C
C1: =A1\B1
D
# C1 shares 30 among 5 kids
Question 5
A
A1: 9
B
B1: A1*3
C
C1: =B1-A1
Answer Key
Arithmetic operators + - * /
Section A: Quick Questions
Q1
B — *
Q2
A — /
Q3
A — =A1+B1
Q4
B — 6
Q5
A — 18
Section B: Match the Pairs
Q1
=A1*B1 → Multiplies the number in A1 by the number in B1
Q2
=C2/4 → Divides the number in C2 by 4
Q3
Add 3 to the score in B2, then multiply the answer by 2 → =(B2+3)*2
Q4
Subtract the money spent in B1 from the money saved in A1 → =A1-B1
Q5
=A1x3 → The letter x was used to multiply. A formula needs the * symbol, so it should be =A1*3.
Q6
=A1+B1*2 (to add first, then multiply) → Without brackets, B1*2 is worked out first. It should be =(A1+B1)*2 to add first.
Section C: Definitions
Q1
+ - * / — The symbols + - * / add, subtract, multiply and divide numbers in a formula. Use brackets ( ) to choose which part is worked out first, like =(A1+B1)*2.Section D: Fill in the Blanks
Q1
=A1*B1Q2
=A1/B1Q3
=(A1+B1)*2Q4
=C2-D2Q5
=(A1+B1)/2Section E: Spot the Error
Q1
D — The letter x is not a maths symbol in a formula. To divide, use /, so it should be =A1/B1.
Q2
C — The total cost is price times number of items, so it needs * to multiply. It should be =A1*B1.
Q3
B — There is no operator between the brackets and the 2. A formula needs * to multiply, so it should be =(A1+4)*2.
Q4
C — A backslash \ does not divide. Division uses the forward slash /, so it should be =A1/B1.
Q5
B — Every formula must start with =. Without it the cell shows plain text. It should be =A1*3.