Excel practice · Basics

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

  1. Find how many items are left over after packing full boxes
  2. Flag every 5th customer for a free sample
  3. Find how many full weeks and leftover days a project spans
  4. Check whether two SKU codes match exactly, including case
  5. Check whether a retyped password matches exactly

The exercises

1. Find how many items are left over after packing full boxes Easy

A warehouse is packing 134 items into boxes of 12. Find how many items are left over once every full box is packed.

AB
1Total items134
2Items per box12
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.

2. Flag every 5th customer for a free sample Medium

A promotion gives a free sample to every 5th customer in line. Check whether customer number 40 should get one.

AB
1Customer number40
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.

3. Find how many full weeks and leftover days a project spans Medium

A project called "Redesign" runs for 23 days. Find how many days are left over once every full 7-day week is counted.

AB
1ProjectRedesign
2Total days23
3Days per week7
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.

4. Check whether two SKU codes match exactly, including case Medium

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.

AB
1SKU (system)SKU-100
2SKU (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.

5. Check whether a retyped password matches exactly Easy

A signup form for user "jdoe92" asks them to retype their password to confirm it. Check whether the two entries match exactly, case included.

AB
1Usernamejdoe92
2PasswordHarbor42!
3RetypedHarbor42!
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 →

More basics practice

All Excel practice exercises · Excel test prep