📊 Excel Skills Assessment

Answer all 10 questions to determine your Excel proficiency level

⏱ Tijd over: 5:00

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

Your Excel Proficiency Level

0/10