Basic Functions
Beginner
ROUND Function
Round numbers to specific decimal places.
Task:
You are preparing a financial report and need to format the numbers to two decimal places for clarity. Round the calculated values in column B to 2 decimal places in column C to ensure the report is clean and professional.
Learning Objectives:
- Master the ROUND function
- Understand decimal place control
- Practice number formatting
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Calculation | Result | Rounded |
| 2 | Division | 10.6666667 | |
| 3 | Multiplication | 15.8333333 | |
| 4 | Percentage | 33.3333333 | |
| 5 | Average | 87.142857 |
What this exercise teaches (contains the answer)
The ROUND function helps format numbers to a specific number of decimal places, which is useful for presentation and consistency.