Quiz › Formulas & Functions › Rounding numbers

Rounding numbers: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

What will this formula return?
=ROUND(2.567,1)
- A. 2.5
- B. 2.57
- C. 3
- D. 2.6
Show the answer
D — 2.6. ROUND to 1 decimal place: 2.567 becomes 2.6.
What will this formula return?
=ROUND(1234,-2)
- A. 1300
- B. 1230
- C. 12.34
- D. 1200
Show the answer
D — 1200. -2 rounds to the nearest hundred: 1200.
What will this formula return?
=ROUNDUP(2.1,0)
- A. 3
- B. 2
- C. 2.5
- D. 2.1
Show the answer
A — 3. ROUNDUP always goes up, so 2.1 becomes 3.
What will this formula return?
=INT(7.9)
- A. 7
- B. 7.9
- C. 79
- D. 8
Show the answer
A — 7. INT drops the decimal part. It does not round up.
What will this formula return?
=MOD(10,3)
- A. 1
- B. 0
- C. 3.33
- D. 3
Show the answer
A — 1. MOD gives what is left over: 10 divided by 3 is 3, with 1 left.