Pro lesson · 5 exercises · first one free
Remainders and multiples: MOD, INT, ABS and CEILING
About this lesson
Small math functions that solve everyday problems: odd or even, whole parts, differences and packing sizes.
Statistics, charts and tables · 5 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Finding the remainder after division
- Cutting off the decimals with INT
- Measuring a difference without its sign
- Rounding up to the next multiple
- Telling odd and even numbers apart
Functions you'll use
- MOD
- INT
- ABS
- CEILING
- FLOOR
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.