📊 Excel Skills Assessment

Answer all 20 questions to determine your Excel proficiency level

⏱ Tijd over: 10:00

Uw naam:

Uw e-mailadres:

Beginner

1. Which keyboard shortcut quickly inserts the SUM of a selected cell range?

Ctrl + S Alt + = (AutoSum) Ctrl + F Shift + Enter

Beginner

2. Which formula correctly adds up the values in cells A1 through A10?

=ADD(A1:A10) =SUM(A1+A10) =SUM(A1:A10) =TOTAL(A1,A10)

Beginner

3. How do you lock a cell reference so it does not change when copying a formula?

Place an asterisk before the reference Place a $ sign before the row and/or column (e.g. $A$1) Lock via the Edit menu Place a hash before the reference

Intermediate

4. Which function looks up a value in the first column of a table and returns a value in the same row?

HLOOKUP VLOOKUP LOOKUP INDEX

Intermediate

5. What does the IF function do in Excel?

Counts cells meeting a condition Performs a logical test returning one value if TRUE and another if FALSE Calculates the average of a range Searches for a value in a table

Intermediate

6. What is a PivotTable in Excel?

A table that auto-sorts alphabetically An interactive tool to summarize, analyze, and visualize large datasets A special 3D chart type A protected table

Intermediate

7. Which combination is more flexible than VLOOKUP for looking up values in any column?

LOOKUP + IF INDEX + MATCH VLOOKUP + HLOOKUP SUMIF + AVERAGEIF

Advanced

8. What does the INDIRECT() function do in Excel?

Calculates indirect costs in a budget Returns the reference specified by a text string allowing dynamic cell references Searches across multiple sheets Converts a number to text

Advanced

9. What is Power Query in Excel?

An add-in for advanced charts A macro programming language A tool to import, transform, and load (ETL) data from various sources A security feature for worksheets

Advanced

10. Which Excel 365 functions return multiple results as a dynamic array?

VLOOKUP with array mode FILTER() or SORT() as dynamic array functions AUTOSUM with extended selection INDIRECT with multiple parameters

Beginner

11. What does conditional formatting do in Excel?

Applies a fixed color to all cells Sorts data automatically Formats cells based on their values or rules Removes duplicates from a range

Beginner

12. Which function counts the number of cells that meet a specific condition?

COUNT COUNTIF SUMIF COUNTA

Beginner

13. How do you freeze rows and columns in Excel so they stay visible while scrolling?

View > Freeze Panes Home > Lock Cells Format > Pin Rows Data > Freeze

Intermediate

14. Which function sums values based on multiple conditions?

SUMIF COUNTIFS SUMIFS AVERAGEIF

Intermediate

15. What is a named range in Excel?

A range with colored borders A descriptive name assigned to a cell or range for easier reference in formulas A range that auto-expands when data is added A protected range that cannot be edited

Intermediate

16. What does Flash Fill do in Excel?

Automatically fills a column based on a detected pattern from adjacent data Highlights cells with the same value Copies formatting from one cell to another Fills a selected range with the same formula

Intermediate

17. What is the purpose of Data Validation in Excel?

It checks spelling in cells It removes invalid data automatically It restricts what type or range of data can be entered into a cell It validates formulas before saving

Advanced

18. What does the IFERROR function do?

Checks if a cell contains an error and deletes it Returns a specified value if a formula results in an error, otherwise returns the formula result Highlights error cells in red Converts error values to zero

Advanced

19. What is a Slicer in Excel used for?

To cut unwanted rows from a dataset To visually filter data in a PivotTable or table with a single click To slice a workbook into multiple sheets To split text in a cell into multiple columns

Advanced

20. What is Power Pivot in Excel?

A tool to create advanced 3D pivot charts A macro tool for automating PivotTables An in-memory data model allowing analysis of large datasets from multiple sources using DAX A feature to auto-refresh PivotTables

Your Excel Proficiency Level

0/10