ABS and MOD in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the absolute value of cell A1.

Excel

= [1](A1)

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

AMOD

BSUM

CABS

DROUND

Attempts:

3 left

💡 Hint

Common Mistakes

Using MOD instead of ABS

Using SUM which adds numbers

Using ROUND which rounds numbers

The ABS function returns the absolute value of a number, removing any negative sign.

2fill in blank

medium

Complete the formula to find the remainder when cell B1 is divided by 3.

Excel

= [1](B1, 3)

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

ASUM

BMOD

CROUND

DABS

Attempts:

3 left

💡 Hint

Common Mistakes

Using ABS which returns absolute value

Using ROUND which rounds numbers

Using SUM which adds numbers

The MOD function returns the remainder after division of one number by another.

3fill in blank

hard

Fix the error in the formula to correctly calculate the absolute value of cell C1.

Excel

= [1](C1)

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

AABS

BMOD

CSUM

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using MOD which returns remainder

Using SUM which adds numbers

Using AVERAGE which calculates mean

ABS is the correct function to get absolute value, not MOD or others.

4fill in blank

hard

Fill both blanks to create a formula that returns the absolute value of the remainder when D1 is divided by 4.

Excel

= [1]([2](D1, 4))

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

AABS

BMOD

CSUM

DROUND

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing ABS and MOD

Using SUM or ROUND instead of MOD

Not using ABS to remove negative sign

First, MOD(D1, 4) finds the remainder. Then ABS(...) makes sure the result is positive.

5fill in blank

hard

Fill all three blanks to create a formula that calculates the absolute value of the remainder when the sum of E1 and E2 is divided by 5.

Excel

= [1]([2](E1 [3] E2, 5))

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

AABS

BMOD

C+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' instead of '+'

Reversing ABS and MOD

Not using ABS to ensure positive result

First, add E1 and E2 with '+'. Then MOD(..., 5) finds remainder. Finally, ABS(...) makes it positive.