Pro lesson · 8 exercises · first one free
Skills check: a repair shop's job log
About this lesson
A mixed review of sums, counts, lookups, text, rounding and logic on one realistic log.
Case studies · 8 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
- Summing hours for one customer
- Counting jobs with a Yes or No flag
- Counting with two conditions and a wildcard
- Looking up a rate with a fallback message
- Multiplying hours by a looked-up rate
- Splitting a first name from a full name
- Choosing the test that needs both conditions
- Averaging a filtered list and rounding it
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 8, 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.