MOD & EXACT practice exercises
5 graded problems with realistic data, from easy to medium.
MOD returns what's left over after division; EXACT checks whether two bits of text match exactly, case included. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the MOD & EXACT guide first: syntax, a worked example and the mistakes people make.
In this set
- Find how many items are left over after packing full boxes
- Flag every 5th customer for a free sample
- Find how many full weeks and leftover days a project spans
- Check whether two SKU codes match exactly, including case
- Check whether a retyped password matches exactly
The exercises
A warehouse is packing 134 items into boxes of 12. Find how many items are left over once every full box is packed.
| A | B | |
|---|---|---|
| 1 | Total items | 134 |
| 2 | Items per box | 12 |
| 3 | ? |
Enter a formula in A3.
Show a hint
MOD(number, divisor) returns the remainder after division: =MOD(B1,B2).
MOD is how a formula finds a remainder instead of a full quotient: leftover stock, a rotation slot, or any "every Nth one" pattern starts here.
A promotion gives a free sample to every 5th customer in line. Check whether customer number 40 should get one.
| A | B | |
|---|---|---|
| 1 | Customer number | 40 |
| 2 | ? |
Enter a formula in A2.
Show a hint
MOD(B1,5)=0 is true exactly when B1 is a multiple of 5: =IF(MOD(B1,5)=0,"Yes","No").
Wrapping MOD in an IF is the standard way to catch "every Nth row": alternating shading, periodic bonuses, batch cutoffs.
A project called "Redesign" runs for 23 days. Find how many days are left over once every full 7-day week is counted.
| A | B | |
|---|---|---|
| 1 | Project | Redesign |
| 2 | Total days | 23 |
| 3 | Days per week | 7 |
| 4 | ? |
Enter a formula in A4.
Show a hint
Same pattern as a leftover-items problem, just with a 7-day cycle instead of a box size: =MOD(B2,B3).
Any fixed-length cycle (a week, a billing period, a rotation of shifts) turns into a MOD problem the moment you need to know what is left over after the full cycles.
Excel's own "=" comparison ignores letter case, but this inventory system treats "SKU-100" and "sku-100" as different codes. Check whether these two SKUs really match.
| A | B | |
|---|---|---|
| 1 | SKU (system) | SKU-100 |
| 2 | SKU (scanned) | sku-100 |
| 3 | ? |
Enter a formula in A3.
Show a hint
EXACT(text1, text2) is case-sensitive, unlike a plain "=" comparison: =EXACT(B1,B2).
EXACT is the one place Excel actually cares about uppercase versus lowercase: useful whenever case carries real meaning, like product codes, passwords, or serial numbers.
A signup form for user "jdoe92" asks them to retype their password to confirm it. Check whether the two entries match exactly, case included.
| A | B | |
|---|---|---|
| 1 | Username | jdoe92 |
| 2 | Password | Harbor42! |
| 3 | Retyped | Harbor42! |
| 4 | ? |
Enter a formula in A4.
Show a hint
EXACT(text1, text2) returns TRUE only when every character matches, case included: =EXACT(B2,B3).
A password confirmation check is exactly the kind of place a case-insensitive "=" would quietly accept the wrong thing; EXACT is the right tool whenever case must count.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the MOD & EXACT exercises →