MO-211 flashcards

32 cards. Read the term and the definition here. The deck at the top of this page is optional.

Iterative calculation

Excel option that resolves circular references by recalculating a limited number of times until values change by less than a specified maximum amount.

Manual calculation mode

Workbook setting where Excel recalculates only when you press F9 or click Calculate Now; Shift+F9 recalculates only the active worksheet.

Mark as Final

Workbook command that sets the file to read-only and displays a message; it does not encrypt or password-protect the workbook.

Trust Center macro settings

Area controlling whether macros run; the default disables macros with notification, and macro-enabled files use the .xlsm extension.

Protect Workbook structure

Option that prevents adding, deleting, renaming, moving, hiding, or unhiding worksheets; it can be set with a password.

Compatibility Checker

Excel feature that reports features unsupported in earlier Excel versions before saving; accessed via File > Info > Check for Issues.

Custom document property

Metadata field you define in Advanced Properties; it can be linked to a named cell so its value updates with the workbook.

AutoRecover interval

Setting in File > Options > Save that determines how often Excel saves recovery information for unsaved changes; default is 10 minutes.

Stop If True

Conditional formatting rule option that stops evaluation of lower-priority rules when the current rule's condition is true.

Data validation Stop alert

Error alert style that prevents users from entering invalid data; Warning allows override and Information only displays a message.

Remove Duplicates

Data tool that deletes rows with duplicate values in selected columns while keeping the first occurrence; it permanently removes data.

Advanced Filter criteria range

Range where columns match list headers; conditions on one row are AND, conditions on separate rows are OR.

Custom number format sections

Format code with up to four sections separated by semicolons: positive, negative, zero, and text, applied in that order.

Flash Fill

Excel feature (Ctrl+E) that fills a column by recognizing patterns from adjacent data; it works without formulas.

Subtotal command

Data tool that inserts summary rows for groups after sorting; each change in the selected column starts a new group.

Table total row

Structured table feature that adds a summary row with functions such as SUM, AVERAGE, or COUNT for each column.

XLOOKUP arguments

Function syntax: lookup_value, lookup_array, return_array, optional if_not_found, match_mode, and search_mode; it replaces VLOOKUP and HLOOKUP.

INDEX MATCH pattern

Formula =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) that returns a value from any column without left-lookup limits.

SUMIFS criteria syntax

Criteria strings use operators and wildcards, for example '>=100' or 'A*'; each criteria_range must match the sum_range size.

Spill range operator

The # symbol after a dynamic array formula references the entire spilled range, such as A1#.

LET function

Assigns names to calculation results inside a formula, reducing repetition and improving readability: =LET(name, value, calculation).

LAMBDA function

Creates a custom reusable function from a formula; parameters are listed before the calculation, and it can be named in Name Manager.

IFERROR versus IFNA

IFERROR returns a fallback for any error; IFNA returns a fallback only for the #N/A error.

Array constant separators

In array constants, commas separate columns and semicolons separate rows, as in {1,2;3,4}.

PivotTable Values area

Area that summarizes data; numeric fields default to SUM and text fields default to COUNT, but you can change the summary function.

Calculated field

PivotTable item that uses a formula with existing fields; it adds a new data field rather than a new category.

Slicer connection

Slicer filter that can be connected to multiple PivotTables so one selection filters all connected tables.

Combo chart secondary axis

Chart that plots one or more series on a secondary value axis, useful when series have very different scales.

Trendline moving average

Chart trendline that smooths fluctuations by averaging a specified number of periods; it requires a period setting.

Sparkline types

In-cell mini charts available as Line, Column, and Win/Loss; they show trends without occupying a full chart area.

Calculated item

PivotTable item that creates a new category from existing items within a single field using a formula.

Chart template

Saved chart formatting file with .crtx extension that can be applied to new charts via Change Chart Type > Templates.