Psst... there are a few Easter eggs hidden around this site. Can you find them?

Which Excel course is right for you?

Answer 15 quick questions and I will point you to the best starting point: Foundation, Intermediate or Advanced. Pick the answer you think is right, and do not worry about guessing.

Looking for Power BI instead? Take the Power BI quiz.

Two colleagues looking at a laptop and a printed report together

A computer training room with rows of desks and monitors

1. Which of the following is the correct way to start a basic formula in Excel? Type = followed by the calculation Type + followed by the calculation Type # before the calculation Type the formula and press Space

2. What is the quickest way to copy a formula down a column? Press Ctrl + C repeatedly Use the Fill Handle Right-click and choose "Repeat" Double-click any cell in the column

3. Which of these functions returns the highest value in a range? AVERAGE MAX SUM COUNT

4. What does the Format Painter tool do? Creates a new worksheet with the same layout Copies data and formulas Copies formatting from one cell to another Deletes formatting from selected cells

5. Which feature allows you to view header rows while scrolling through large datasets? Sort Filter Wrap Text Freeze Panes

6. Which of the following correctly describes an absolute cell reference? A reference that changes when copied to another cell A reference that stays fixed when copied, using $ symbols A reference that links to another worksheet A reference created only when using named ranges

7. Which of the following correctly describes what the COUNTIF function does? Counts all numbers in a range Counts only blank cells in a range Counts cells that meet a specific condition Counts the number of formulas in a range

8. What is the main advantage of converting a range into an Excel Table (Ctrl + T)? It locks the data so it cannot be edited It automatically applies formulas to new rows and enables structured references It prevents duplicate values from being entered It hides unused rows and columns

9. Which of the following is an example of a valid Data Validation rule? Automatically colouring cells based on values Restricting entries to a list of allowed values Splitting text into multiple columns Removing duplicate records

10. What does Conditional Formatting allow you to do? Create dropdown lists for data entry Apply formatting automatically based on cell values Lock cells to prevent editing Convert formulas into static values

11. Which of the following best describes the purpose of Power Query? Building the content for interactive dashboards Cleaning, transforming, and loading data from multiple sources Automating tasks using VBA Building PivotTables with calculated fields

12. In a Power PivotTable, what does a Calculated Field allow you to do? Add new rows of data directly into the PivotTable Create a custom formula based on fields in the PivotTable Apply conditional formatting to the PivotTable Change the data source of the PivotTable

13. Which of the following best describes the purpose of the TEXTAFTER function? Returns text before a specific delimiter Returns text after a specific delimiter Splits text into multiple columns automatically Removes all non-text characters from a cell

14. What is the purpose of a slicer in Excel? To filter data visually in PivotTables, PivotCharts, or Tables To split text into multiple columns To remove duplicate values from a dataset To create automated macros for filtering

15. Which statement correctly compares VLOOKUP, XLOOKUP, and INDEX + MATCH? VLOOKUP can look left, while XLOOKUP and INDEX + MATCH cannot XLOOKUP and INDEX + MATCH allow flexible lookups in any direction, unlike VLOOKUP INDEX + MATCH only works with sorted data, while VLOOKUP and XLOOKUP do not All three functions require the lookup column to be the first column in the table

Two monitors showing dashboards of charts, with a spreadsheet beside them

Looking for Power BI instead?

An Introduction to Power BI is for people with little or no experience. Further Power BI is for people who already have a solid understanding of it.

Intro to Power BI Further Power BI Take the Power BI quiz

Rachel, founder and trainer at The Blue Star Academy

Still not sure?

Talk to me. I will happily talk through what your team does with Excel and recommend the right level.

Get in touch with me

Think I can help? Contact me today

Tell me what your team needs and I will come back to you.