Foundations
Band 1 · FoundationsEssentials exam 1 of 4
The Foundations exam
Questions from every Foundations module, none of them seen in a lesson. Pass it for the Foundations certificate, a record of what you can do.
- Every question is worked on its own module's workbook, like real work.
- Marked on the result, so any correct formula counts.
- Nothing teaches during it. Trust what you have practised.
One moment...
What it covers
5 modules. One paper.
01
The WorksheetWorkbook, worksheet, cell: how Excel stores what you see · Entering, editing and filling data · Data types: text, number, date, boolean · Navigating and selecting at speed
Workbook, worksheet, cell: how Excel stores what you see · Entering, editing and filling data · Data types: text, number, date, boolean · Navigating and selecting at speed4 lessons02
Formula FoundationsWriting your first formulas · Order of operations and parentheses · Relative references and copying · Absolute and mixed references
Writing your first formulas · Order of operations and parentheses · Relative references and copying · Absolute and mixed references4 lessons03
Named ReferencesCreating and scoping names · Using names in formulas · Name Manager and auditing names · Table names and structured references
Creating and scoping names · Using names in formulas · Name Manager and auditing names · Table names and structured references4 lessons04
PresentationNumber and date formatting · Worksheet formatting and cell styles · Custom number formats · Printing and page setup
Number and date formatting · Worksheet formatting and cell styles · Custom number formats · Printing and page setup4 lessons05
Structure and SafetyConverting ranges to Tables · Data validation rules · Protecting cells and sheets · Workbook design: inputs, calculations, outputs
Converting ranges to Tables · Data validation rules · Protecting cells and sheets · Workbook design: inputs, calculations, outputs4 lessonsF1Foundations
What a pass gets you
A Foundations certificate with your name, score and date.
It is one of 4. Pass all 4 Essentials exams and you get the Essentials Certificate.
See your certificates