Microsoft Excel Certification Practice Tests: 3 Practice Tests and 120 Questions
MO-210 / MO-211
120
MO-210: Manage worksheets and workbooks | Importing text and online data, navigation, page setup, views, print settings, inspecting and sharing workbooks (25–30%)
MO-210: Manage data cells and ranges | Paste Special, Auto Fill, SEQUENCE and RANDBETWEEN, cell formatting, named ranges, sparklines and conditional formatting (25–30%)
MO-210: Manage tables and table data | Creating and styling tables, total rows, converting to ranges, filtering and sorting (10–15%)
MO-210: Perform operations by using formulas and functions | References, structured references, SUM to COUNTBLANK, IF, SORT, UNIQUE and text functions (15–20%)
MO-210: Manage charts | Creating charts and chart sheets, data series, switching rows and columns, chart elements and alt text (15–20%)
MO-211: Manage workbook options and settings | Protection, calculation options, macros and versions (10–15%)
MO-211: Manage and format data | Flash Fill, RANDARRAY, custom number formats, data validation, subtotals, duplicates and formula-based conditional formatting (30–35%)
MO-211: Create advanced formulas and macros | IFS family, LET, XLOOKUP, FILTER, LAMBDA, date functions, what-if analysis, formula auditing and simple macros (25–30%)
MO-211: Manage advanced charts and tables | Combo, dual-axis, waterfall and box and whisker charts, PivotTables, slicers and PivotCharts (25–30%)
Interview extras | Power Query, Power Pivot and DAX, Solver, the Analysis ToolPak and financial functions, which are not on the MOS exams
MO-211: Create advanced formulas and macros
Which formula looks up the ID in E2 in A2:A100 and returns the matching price from C2:C100, showing Not found when there is no match?
XLOOKUP(E2, C2:C100, A2:A100, "Not found")
XLOOKUP(E2, A2:A100, C2:C100, "Not found")
VLOOKUP(E2, A2:A100, 3, "Not found")
MATCH(E2, A2:A100, "Not found")
B
XLOOKUP takes the lookup value, the array to search, the array to return from and an optional if_not_found value. It defaults to an exact match and can look in any direction. Swapping the arrays searches the price column instead of the IDs, VLOOKUP has no if_not_found argument, and MATCH returns a position, not a price.
https://exametics.com/product/microsoft-excel-certification-practice-tests/
Course Content
Supporting Resources
You don't currently have access to this content
Microsoft Excel Certification & Job Interview Prep – Practice Test #1
You don't currently have access to this content
Microsoft Excel Certification & Job Interview Prep – Practice Test #2
You don't currently have access to this content
Exam Mode: Microsoft Excel Certification & Job Interview Prep – Practice Test #3
You don't currently have access to this content
