Modular Arithmetic Practice Questions with Solutions

Introduction

Excel mathematical functions are useful when working with prices, measurements, quantities, percentages, calculations and business data. In this chapter, you will practice ROUND, INT, MOD, ABS, PRODUCT, POWER, SQRT, CEILING, FLOOR, and related mathematical functions. Each question uses a different situation so you can test your practical Excel skills and understand how these functions behave with different types of numbers. Modular Arithmetic Practice questions with solutions to help you understand the concepts.

Question 1: Round Product Prices to Two Decimal Places

Problem Statement

A company has product prices containing more decimal places than required. Round each price to 2 decimal places.

Excel Data

Solution

In C2, enter:

=ROUND(B2,2)

Copy the formula down.

Expected Output

Question 2: Round Sales Amounts to the Nearest Thousand

Problem Statement

A company wants to display large sales figures in rounded form. Round each sales amount to the nearest thousand.

Excel Data

Solution

In C2, enter:

=ROUND(B2,-3)

Copy the formula down.

Expected Output

A negative number of digits tells ROUND to round to the left of the decimal point.

Question 3: Use INT to Get the Whole Number

Problem Statement

A delivery system records distances with decimal values. Use INT to remove the decimal portion and return the integer part.

Excel Data

Solution

In C2, enter:

=INT(B2)

Copy the formula down.

Expected Output

Question 4: Find Remaining Items Using MOD

Problem Statement

A warehouse packs products into boxes containing 12 items each. Use MOD to calculate how many items remain after making complete boxes.

Excel Data

Solution

In C2, enter:

=MOD(B2,12)

Copy the formula down.

Expected Output

MOD returns the remainder after division.

Question 5: Calculate Total Cost Using PRODUCT

Problem Statement

A store sells multiple products. Calculate the total cost using the PRODUCT function.

Excel Data

Solution

In D2, enter:

=PRODUCT(B2,C2)

Copy the formula down.

Expected Output

You could also calculate the same result using =B2*C2.

Question 6: Calculate Absolute Differences Using ABS

Problem Statement

A company compares expected sales with actual sales. Calculate the absolute difference between the two values.

Excel Data

Solution

In D2, enter:

=ABS(C2-B2)

Copy the formula down.

Expected Output

ABS converts a negative result into its positive value.

Question 7: Calculate Powers and Square Roots

Problem Statement

Use POWER and SQRT to perform mathematical calculations.

Excel Data

Solution

In C2, calculate the power:

=POWER(A2,B2)

In D2, calculate the square root:

=SQRT(A2)

Copy both formulas down.

Expected Output

Question 8: Round Prices Up Using CEILING

Problem Statement

A company wants prices to be rounded up to the nearest ₹100 for billing purposes.

Excel Data

Solution

In C2, enter:

=CEILING(B2,100)

Copy the formula down.

Expected Output

CEILING rounds a number upward to the specified multiple.

Question 9: Round Inventory Down Using FLOOR

Problem Statement

A warehouse stores products in packages of 10 units. Find the largest multiple of 10 that does not exceed the available stock.

Excel Data

Solution

In D2, enter:

=FLOOR(B2,C2)

Copy the formula down.

Expected Output

Question 10: Create a Practical Invoice Calculation

Problem Statement

Create an invoice calculation that combines several mathematical functions.

A store sells products in different quantities. Calculate:

• Subtotal
• Rounded subtotal
• Discount amount
• Final amount

Use a 10% discount.

Excel Data

Solution

Step 1: Calculate Subtotal

In D2, enter:

=B2*C2

Copy down.

Step 2: Round the Subtotal

In E2, enter:

=ROUND(D2,0)

Copy down.

Step 3: Calculate Discount

In F2, enter:

=E2*10%

Copy down.

Step 4: Calculate Final Amount

In G2, enter:

=E2-F2

Copy down.

Expected Output

This question combines multiplication, ROUND, percentage calculation and subtraction in one practical example.

Key Takeaways

• ROUND rounds a number to a specified number of digits.
• INT returns the integer portion of a number by rounding down toward negative infinity.
• MOD returns the remainder after division.
• PRODUCT multiplies numbers together.
• ABS returns the absolute value of a number.
• POWER calculates a number raised to a specified power.
• SQRT calculates the square root of a number.
• CEILING rounds a number up to a specified multiple.
• FLOOR rounds a number down to a specified multiple.
• Mathematical functions can be combined with normal formulas to solve practical business calculations.
• Always check the required rounding rule before choosing between ROUND, CEILING, and FLOOR.

FAQs

1. What is the ROUND function in Excel?

ROUND rounds a number to the specified number of digits.

=ROUND(125.678,2)

The result is 125.68.

2. What is the difference between ROUND and INT?

ROUND lets you specify how many digits to keep, while INT returns the integer portion by rounding down.

3. What does MOD do in Excel?

MOD returns the remainder after dividing one number by another.

=MOD(17,5)

The result is 2.

4. What is the ABS function used for?

ABS returns the positive value of a number, regardless of whether the original number is positive or negative.

5. What is the PRODUCT function in Excel?

PRODUCT multiplies multiple numbers or cell references.

=PRODUCT(A1:A4)

6. What is the difference between CEILING and FLOOR?

CEILING rounds a number upward to a specified multiple, while FLOOR rounds it downward to a specified multiple.

7. What does POWER do in Excel?

POWER raises a number to a specified power.

=POWER(5,2)

The result is 25.

8. How do I calculate a square root in Excel?

Use the SQRT function:

=SQRT(144)

The result is 12.

9. Can mathematical functions be combined with other Excel formulas?

Yes. For example, you can calculate a product amount, round it, apply a discount and calculate the final amount using multiple formulas.

10. Why should I use Excel mathematical functions instead of calculating values manually?

Functions make calculations faster, repeatable and easier to update. When source values change, Excel can automatically recalculate the results.

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Rishabh Kumar