Microsoft Excel Skill Assessment

Written by Coursera • Updated on

Test your Excel skills with this quick assessment. Answer 10 multiple-choice questions to get your score, then check the Scoring Guide to find your level and recommended learning path.

Microsoft Excel Skill Assessment

Excel Quiz

1. What does the VLOOKUP function primarily do?

Looks for data vertically in a spreadsheet
Searches for a value in the leftmost column and returns a value in the same row from a specified column
Validates data in a lookup table
Creates vertical charts

2. Which of these formulas will calculate the average of cells A1 through A10, excluding the highest and lowest values?

AVERAGE(A1:A10)
TRIMMEAN(A1:A10)
AVERAGEIF(A1:A10)
=(SUM(A1:A10)-MAX(A1:A10)-MIN(A1:A10))/8

3. What is a Pivot Table used for?

To rotate data in cells
To summarize and analyze large amounts of data
To create charts only
To sort data alphabetically

4. Which keyboard shortcut creates absolute cell references when writing a formula?

Ctrl + A
F4
Shift + Enter
Alt + Enter

5. What does the INDEX-MATCH combination do that VLOOKUP cannot?

Look up values faster
Look up values to the left of the lookup column
Sort data automatically
Create dynamic ranges

6. In Power Query, what is the primary purpose of the 'Transform' tab?

To create charts
To modify and clean data before loading it into Excel
To create pivot tables
To format cells

7. What feature would you use to create a dynamic range that automatically includes new data?

Auto Filter
Data Validation
Table
Conditional Formatting

8. Which formula returns the number of unique values in a range (A1:A10)?

UNIQUE(A1:A10)
COUNT(A1:A10)
COUNTA(A1:A10)
=SUM(1/COUNTIF(A1:A10,A1:A10))

9. What is the purpose of a Macro?

To format cells automatically
To automate repetitive tasks
To create charts quickly
To validate data entry

10. How can you use Excel to predict future values based on historical data?

Using VLOOKUP
Using Forecast Sheet or FORECAST functions
Using Pivot Tables
Using Charts

Scoring Guide & Course Recommendations

0-30: Beginner Level

40-70: Intermediate Level

80-100 Correct: Advanced Level

Skills Covered by Level

Beginner Level Skills

  • Basic formulas (SUM, AVERAGE, COUNT)

  • Cell formatting

  • Basic charts

  • Data sorting and filtering

  • Simple functions

Intermediate Level Skills

  • VLOOKUP and HLOOKUP

  • Pivot Tables

  • Conditional formatting

  • Advanced charts

  • Data validation

  • IF statements and nested functions

Advanced Level Skills

  • Power Query and Power Pivot

  • VBA Macros

  • Advanced functions (INDEX-MATCH, OFFSET)

  • Data modeling

  • Dashboard creation

  • Advanced analytics and forecasting

Career Applications

Updated on
Written by:

Coursera

Writer

Coursera is the global online learning platform that offers anyone, anywhere access to online course...

This content has been made available for informational purposes only. Learners are advised to conduct additional research to ensure that courses and other credentials pursued meet their personal, professional, and financial goals.