Skills Measured

Skills Measured in the Microsoft Exam

Please note that the questions may test on, but will not be limited to, the topics described below.

Links to Microsoft videos and articles are provided below for many of the exam topics. Some of these articles have different instructions depending on the version of Excel being used. If multiple sets of instructions are listed, make sure to select Windows rather than MacOS or Web, and/or Office 365/2019 or Newer Versions rather than Office 2016 or earlier.

Links in the See Also section at the bottom of each skillset group may also be helpful.

Manage worksheets and workbooks (10-15%)

Import data into workbooks

Navigate within workbooks

Format worksheets and workbooks

Customize options and views

Configure content for collaboration

Set a print area
Save workbooks in alternative file formats
Configure print settings
Inspect workbooks for issues

Manage data cells and ranges (20-25%)

Manipulate data in worksheets

Format cells and ranges

Define and reference named ranges

Define a named range
Name a table (also, Name Manager)

Summarize data visually

Manage tables and table data (15-20%)

Create and format tables

Modify tables

Filter and sort table data

Perform operations by using formulas and functions (20-25%)

Insert references

Create formulas (formula basics, about the formula bar)

Calculate and transform datas

Perform calculations by using these functions:
- AVERAGE()
- MAX()
- MIN()
- SUM()
Count cells by using these functions:
Perform conditional operations by using the IF() function

Format and modify text

Format text using functions:
- RIGHT()
- LEFT()
- MID()
- UPPER()
- LOWER()
- PROPER()
- LEN()
Format text by using the CONCAT() and TEXTJOIN() functions