Quick Reference Guides
for MO-211/TestOut
Expert Excel Exam
Embedded Files
Download the Guides (PDFs):
Download the Guides (PDFs):
QR-01 Number, Custom Number, Date & Time Formatting
Number formats, custom formats, dates, times, colors, units
Highlight rules, Top/Bottom rules, Data Bars, Color Scales, Icon Sets, formula rules
Validation rules, drop-down lists, input messages, error alerts, custom formulas
QR-04 Tables, Sorting & Filtering
Excel Tables, structured references, sorting, filtering, Total Row
XLOOKUP, VLOOKUP (legacy), HLOOKUP (awareness), lookup strategies
QR-06 Logical & RACON Functions
IF, IFS, AND, OR, NOT, SUMIF(S), COUNTIF(S), AVERAGEIF(S)
FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, spill ranges
PivotTable creation, field placement, grouping, calculations, refresh
Chart selection, chart elements, PivotCharts, Sparklines, best practices
Integrated review of Excel Expert skills, troubleshooting, function selection
Together, the series covers:
Together, the series covers:
Data Preparation
QR-01 — Formatting
QR-02 — Conditional Formatting
QR-03 — Data Validation
QR-04 — Tables
Formula Development
QR-05 — Lookup Functions
QR-06 — Logical & RACON Functions
QR-07 — Dynamic Arrays
Analysis & Reporting
QR-08 — PivotTables
QR-09 — Charts & PivotCharts
Certification Review
QR-10 — Advanced Formula Review
MO-211/TestOut Skills Covered
MO-211/TestOut Skills Covered
Custom number formats
Conditional Formatting
Data Validation
Excel Tables
Sorting and Filtering
XLOOKUP
Logical functions
RACON functions (SUMIF(S), COUNTIF(S), AVERAGEIF(S))
Dynamic Arrays
PivotTables
PivotCharts
Professional chart design
Advanced formula construction
Formula troubleshooting
Structured references
Business-oriented spreadsheet analysis
Page updated
Google Sites
Report abuse