ROUND, ROUNDUP, ROUNDDOWN in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to round the number in cell A1 to 2 decimal places using the ROUND function.

Excel

=ROUND(A1, [1])

Drag options to blanks, or click blank then click option'

A1

B0

C3

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 instead of 2, which rounds to the nearest whole number.

Using 3 which rounds to three decimal places instead of two.

The ROUND function rounds a number to the specified number of decimal places. Here, 2 means rounding to two decimal places.

2fill in blank

medium

Complete the formula to always round the number in cell B2 up to 1 decimal place using the ROUNDUP function.

Excel

=ROUNDUP(B2, [1])

Drag options to blanks, or click blank then click option'

A1

B-1

C2

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 which rounds up to the nearest whole number.

Using negative numbers which round to the left of the decimal.

ROUNDUP rounds a number up, away from zero, to the specified number of decimal places. Here, 1 means one decimal place.

3fill in blank

hard

Fix the error in the formula to round down the value in C3 to the nearest whole number using ROUNDDOWN.

Excel

=ROUNDDOWN(C3, [1])

Drag options to blanks, or click blank then click option'

A0

B1

C-1

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 which rounds down to one decimal place instead of whole number.

Using negative numbers which round to tens or hundreds place.

To round down to the nearest whole number, use 0 as the number of decimal places.

4fill in blank

hard

Fill in the blank to create a formula that rounds the number in D4 up to the nearest 10 using ROUNDUP.

Excel

=ROUNDUP(D4, [1])

Drag options to blanks, or click blank then click option'

A1

B-1

C10

D-10

Attempts:

3 left

💡 Hint

Common Mistakes

Using positive decimal places which round to the right of the decimal point.

Using -10 which rounds to much larger multiples.

Using -1 rounds up to the nearest 10 (one digit left of the decimal point).

5fill in blank

hard

Fill in the blank to create a formula that rounds the number in E5 down to 3 decimal places using ROUNDDOWN.

Excel

=ROUNDDOWN(E5, [1])

Drag options to blanks, or click blank then click option'

A5

B0.001

C3

D0.01

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 or negative numbers which round to whole numbers or larger.

Using non-integer values like 0.001, which may not behave as expected.

ROUNDDOWN with 3 decimal places truncates to three digits after the decimal point.