Math & trig › QUOTIENT, MOD13 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeQUOTIENTMOD

QUOTIENT & MOD: eggs per tray

Mr. Slamet owns a layer chicken farm in Blitar. Every day the eggs are packed into trays of 30. He wants to know how many full trays he can ship and how many eggs are left over.

Task

For each day, fill C2:C6 with the number of full trays using QUOTIENT, and D2:D6 with the leftover eggs using MOD. One tray holds 30 eggs.

Cells to fillC2:C6D2:D6

Required functionsQUOTIENTMOD

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
QUOTIENT(numerator, denominator) returns the whole-number result of a division, while MOD(number, divisor) returns the remainder.
Hint 2
Example: 65 eggs divided by 30 = 2 full trays with 5 eggs left over.
Hint 3
Both functions use the egg count in B2 as the first argument and 30 as the divisor.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C6

=QUOTIENT(B2,30)

Write it in C2, then fill down to C6.

D2:D6

=MOD(B2,30)

Write it in D2, then fill down to D6.

Explanation

=QUOTIENT(B2,30) throws away the remainder, so 1,245 eggs become 41 trays. =MOD(B2,30) returns that remainder, 15 eggs. Quick check: trays × 30 + leftover must equal the total eggs. The same pair is handy for turning minutes into hours and minutes, or days into weeks and days.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Day	Total eggs	Full trays	Leftover eggs
2	Monday	1,245
3	Tuesday	980
4	Wednesday	1,320
5	Thursday	1,107
6	Friday	1,050
7
8
9
10
11
12
13
14

Fill in the requested cells, then press Check answer.

Validation result