Basic Functions
Intermediate
MOD Function
Find remainders using the MOD function.
Task:
You are managing inventory and need to determine how many items can be fully packed into boxes and what remains. Calculate the remainder when dividing by 3 in column C to find out how many items are left over after packing items into boxes of 3.
Learning Objectives:
- Learn the MOD function
- Understand remainder calculations
- Practice modular arithmetic
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 | Number | Divide by 3 (for info) | Remainder |
| 2 | 10 | 3.33 | |
| 3 | 15 | 5 | |
| 4 | 22 | 7.33 | |
| 5 | 18 | 6 |
What this exercise teaches (contains the answer)
The MOD function is useful for finding remainders, which can be applied in scenarios like packaging, scheduling, or pattern detection.