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.

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

Insert references

Create formulas (formula basics, about the formula bar)

Calculate and transform datas

Format and modify text

See also

Excel formulas and functions tutorials

Alphabetical list of all Excel functions