← ACARA Digital Technologies Years 7–8

The ROUND function

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.

Part of: ACARA Digital Technologies Years 7–8 — Analysing and Visualising Data — Module 21, ACARA Digital Technologies Years 9–10 — Analysing and Visualising Data — Module 26

Understanding The ROUND function in ACARA Digital Technologies Years 7–8

What it does: The 2 at the end keeps two decimal places, and the ROUND function changes the stored value, not just how it looks. A digits value of 0 gives a whole number, which is the nearest dollar. Both the number and the digits go inside the brackets, separated by a comma. The second decimal digit is 6, so 81.6 rounds up to 81.7. Rounding is not the same as chopping digits off. The 2 means two decimal places, so the answer is 3.14. 3.1 would come from using 1. ROUND wraps around AVERAGE, and the 1 tells it to keep one decimal place, so the average is rounded.

Common mistakes: ROUND needs two arguments: the number and the digits. The digits argument is missing. It should be =ROUND(B11,1). Column B holds the Maths marks. English is in column C, so the range should be C2:C9.

Class: _____________________ · Name: _____________________ · Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add The ROUND function to a class →

This module's key terms are also in a printable crossword (Modules 261–300) and word search (Modules 261–324).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning

Duo

Which formula rounds the average of B2:B9 to 1 decimal place?

=ROUND(AVERAGE(B2:B9),1)=ROUND(AVERAGE(B2:B9),0)

Matches

=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).

Applying

Meanings

Term

=ROUND(number, digits)

Meaning

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.

Practice

=ROUND(AVERAGE(B2:B9),1)

Testing

Gaps

=(AVERAGE(B2:B9),1)

Check Answer

Spots

2B11: =AVERAGE(B2:B9)

3C11: =ROUND(B11)

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy

Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games

Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print

Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. Which formula rounds the average of B2:B9 to 1 decimal place?

A. =ROUND(AVERAGE(B2:B9),0)

B. =ROUND(AVERAGE(B2:B9),1) ✓

The second part of ROUND is the number of decimal places. Use 1 for one decimal place. Using 0 gives a whole number.

2. What does =ROUND(7.68,0) give?

A. 8 ✓

B. 7.7

0 digits means a whole number, so 7.68 rounds up to 8. 7.7 would need 1 digit.

3. Which one is true about ROUND?

A. It only changes how the number looks.

B. It changes the value stored in the cell. ✓

ROUND changes the actual value. Formatting a cell only changes what you see, and the full number is still stored behind it.

4. Choose the correct way to write ROUND.

A. =ROUND(A2,1) ✓

B. =ROUND(A2)1

Both the number and the digits go inside the brackets, separated by a comma.

5. Ava's average is 81.6667. What does =ROUND(81.6667,1) show?

A. 81.7 ✓

B. 81.6

The second decimal digit is 6, so 81.6 rounds up to 81.7. Rounding is not the same as chopping digits off.

Match the Pairs

=ROUND(AVERAGE(B2:B9),1) → Finds the average of the Maths marks and rounds it to 1 decimal place

=ROUND(D2,0) → Rounds the number in D2 to a whole number

Round the Maths average to 2 decimal places so the value itself is changed → =ROUND(AVERAGE(B2:B9),2)

Round the price in C2 to the nearest whole dollar → =ROUND(C2,0)

=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).

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).

Key Term

=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.

Fill in the Blanks

1. =ROUND(AVERAGE(B2:B9),1)

Hint: Type the function name that rounds a number to a set number of decimal places.

2. =ROUND(AVERAGE(B2:B9),1)

Hint: Type the digits value that keeps just one decimal place.

3. =ROUND(AVERAGE(C2:C9),0)

Hint: Type the digits value that gives a whole number with no decimals.

4. =ROUND(AVERAGE(D2:D9),1)

Hint: Type the function that finds the mean of the range, placed inside ROUND.

5. =ROUND(B2/C2,2)

Hint: Type the digits value that keeps two decimal places, like cents in a price.

Spot the Error

Question 1

A A11: Maths average

B B11: =AVERAGE(B2:B9)

C C11: =ROUND(B11)

Line C — ROUND needs two arguments: the number and the digits. The digits argument is missing. It should be =ROUND(B11,1).

Question 2

A Goal: English average, 1 dp

B Cell B12 holds the result

C B12: =ROUND(AVERAGE(B2:B9),1)

Line C — Column B holds the Maths marks. English is in column C, so the range should be C2:C9.

Question 3

A Goal: whole-number Maths mean

B B12: =ROUND(AVERAGE(B2:B9),1)

C Result shows a whole number

Line B — Using 1 keeps one decimal place. To get a whole number the digits argument must be 0.

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

Line D — Rounding 2.346 to 1 decimal place gives 2.3. The value 2.35 would need 2 decimal places, =ROUND(B2,2).

Question 5

A Average item price, 2 dp

B E2: =ROUND(2,AVERAGE(C2:C9))

C Result: 22.75

Line B — The arguments are swapped. The number (or calculation) comes first and the digits come second: =ROUND(AVERAGE(C2:C9),2).

Student with a class code? Join your class →