Recall
Set 1: Quick Check
Match essential functions to their purposes and distinguish numeric counts from all nonblank records.
Core Functions
Essential Summary Functions
Build practical skills in core functions.
Start Chapter PracticeChapter plan
What you will be able to do
- Apply core functions concepts in realistic spreadsheet work.
- Study time
- 25–30 minutes, self-paced
- Course
- Excel for Work (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Choose minimums and maximums, count nonblank cells, and round a calculated result correctly.
Hands-on
Set 3: Workplace Task
Build workplace summaries for total sales and average order value in the spreadsheet workspace.
Independent check
Set 4: Mastery Check
Complete a multi-function summary and audit whether every formula uses the full data range.