Excel: final assessment

This covers the whole course. Take it after the last module.

Final quiz

1. Which file type keeps formulas and formatting?
2. What does =SUM(A1:A3) add?
3. Which shortcut saves a workbook on Windows?
4. Which function returns the largest value?
5. What does #NAME? usually mean?
6. What does F4 do while a reference is selected in a formula?
7. Which XLOOKUP argument gives a value when nothing is found?
8. Which total respects a filter?
9. Which format shows 30 hours as 30:00?
10. What is a slicer?
11. Which chart suits parts of one whole with three parts?
12. Why do nested IFs test the highest grade threshold first?
13. What does FILTER return when nothing matches and no third argument is given?
14. Why build a PivotTable from an Excel Table rather than a fixed range?
15. Why can one cell of a data table not be edited?
16. Which tool repeats the same cleaning of a new monthly export with one click?

Practical assessment: Analyse a sales list

In your own Excel, without the lessons open, turn a list of a few hundred sales into a short analysis.

Final project

A monthly sales dashboard: Turn a raw sales export into a one-page dashboard that refreshes each month: totals by region and product, the trend, the top sellers and targets.

How it is evaluated

To complete this course