Ledger DrillBeta
Log inJoin for free

Everyday functions

The functions an office uses every day: averages, counts, totals by name, rounding and percentages.

Premium5 rooms41 questions40 min
See the first roomAVERAGE, MIN and MAX

Rooms in this module

  1. AVERAGE, MIN and MAX7 min, easyPremium
  2. COUNT, COUNTA and COUNTIF8 min, easyPremium
  3. How to use SUMIF8 min, easyPremium
  4. ROUND, ROUNDUP and ROUNDDOWN8 min, easyPremium
  5. How to work out a percentage in a spreadsheet9 min, easyPremium

How this works

Each room answers one problem. A task is a few lines of reading, then questions you answer in the books: post to an account, type a figure, sort, match or write a journal. Every answer is marked at once, with the rule behind it. There are no videos.

Questions

How many rooms and questions are in Everyday functions?

5 rooms and 41 questions. Every question is marked at once.

How long does it take?

About 40 minutes in all. A room takes 7 to 9 minutes, so you can do one at a time.

Is it free?

No. These rooms need Premium. Each room shows the start of its first task before you pay.

What should I do first?

Cells and formulas. It is the module before this one in Spreadsheets for the office.