The ROUND function
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which formula rounds the average of B2:B9 to 1 decimal place?
2. What does =ROUND(7.68,0) give?
3. Which one is true about ROUND?
4. Choose the correct way to write ROUND.
5. Ava's average is 81.6667. What does =ROUND(81.6667,1) show?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1=ROUND(AVERAGE(B2:B9),1) | A=ROUND(AVERAGE(B2:B9),2) | |
| 2=ROUND(D2,0) | BThe formula does not start with =, so the cell shows text instead of working it out. It should be =ROUND(B2,0). | |
| 3Round the Maths average to 2 decimal places so the value itself is changed | CRounds the number in D2 to a whole number | |
| 4Round the price in C2 to the nearest whole dollar | D=ROUND(C2,0) | |
| 5=ROUND(AVERAGE(B2:B9)) | EFinds the average of the Maths marks and rounds it to 1 decimal place | |
| 6ROUND(B2,0) | FThe digits argument is missing. ROUND needs a comma and a number of decimal places, such as =ROUND(AVERAGE(B2:B9),1). |
C
Definitions
=ROUND(number, digits)
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
=_____(AVERAGE(B2:B9),1)
2.
=ROUND(AVERAGE(B2:B9),_)
3.
=ROUND(AVERAGE(C2:C9),_)
4.
=ROUND(_______(D2:D9),1)
5.
=ROUND(B2/C2,_)
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
A11: Maths average
B
B11: =AVERAGE(B2:B9)
C
C11: =ROUND(B11)
Question 2
A
Goal: English average, 1 dp
B
Cell B12 holds the result
C
B12: =ROUND(AVERAGE(B2:B9),1)
Question 3
A
Goal: whole-number Maths mean
B
B12: =ROUND(AVERAGE(B2:B9),1)
C
Result shows a whole number
Question 4
A
Formatting only changes looks
B
B2 holds 2.346 and shows 2.3
C
Stored value is still 2.346
D
=ROUND(B2,1) makes it 2.35
Question 5
A
Average item price, 2 dp
B
E2: =ROUND(2,AVERAGE(C2:C9))
C
Result: 22.75
Answer Key
The ROUND function
Section A: Quick Questions
Q1
B — =ROUND(AVERAGE(B2:B9),1)
Q2
A — 8
Q3
B — It changes the value stored in the cell.
Q4
A — =ROUND(A2,1)
Q5
A — 81.7
Section B: Match the Pairs
Q1
=ROUND(AVERAGE(B2:B9),1) → Finds the average of the Maths marks and rounds it to 1 decimal place
Q2
=ROUND(D2,0) → Rounds the number in D2 to a whole number
Q3
Round the Maths average to 2 decimal places so the value itself is changed → =ROUND(AVERAGE(B2:B9),2)
Q4
Round the price in C2 to the nearest whole dollar → =ROUND(C2,0)
Q5
=ROUND(AVERAGE(B2:B9)) → The digits argument is missing. ROUND needs a comma and a number of decimal places, such as =ROUND(AVERAGE(B2:B9),1).
Q6
ROUND(B2,0) → The formula does not start with =, so the cell shows text instead of working it out. It should be =ROUND(B2,0).
Section C: Definitions
Q1
=ROUND(number, digits) — Rounds a number to a set number of decimal places. Use 1 for one decimal place or 0 for a whole number, e.g. =ROUND(AVERAGE(B2:B9),1). It changes the value itself, not just how it looks.Section D: Fill in the Blanks
Q1
=ROUND(AVERAGE(B2:B9),1)Q2
=ROUND(AVERAGE(B2:B9),1)Q3
=ROUND(AVERAGE(C2:C9),0)Q4
=ROUND(AVERAGE(D2:D9),1)Q5
=ROUND(B2/C2,2)Section E: Spot the Error
Q1
C — ROUND needs two arguments: the number and the digits. The digits argument is missing. It should be =ROUND(B11,1).
Q2
C — Column B holds the Maths marks. English is in column C, so the range should be C2:C9.
Q3
B — Using 1 keeps one decimal place. To get a whole number the digits argument must be 0.
Q4
D — Rounding 2.346 to 1 decimal place gives 2.3. The value 2.35 would need 2 decimal places, =ROUND(B2,2).
Q5
B — The arguments are swapped. The number (or calculation) comes first and the digits come second: =ROUND(AVERAGE(C2:C9),2).