MO-211 key terms

A folder path registered in the Trust Center that Excel treats as safe, so workbooks stored there open without Protected View and can run macros with fewer security prompts.

Trust Center options that decide whether VBA macros may run, whether a warning bar appears first, and whether only macros carrying a digital signature are enabled.

A read-only, restricted window in which Excel opens files from the internet, email attachments or other unsafe sources until the user chooses to enable editing.

A working state shown when a workbook is kept in an older file format; newer features are disabled so the file still opens correctly in earlier Excel versions.

A workbook setting that determines whether formulas recalculate automatically after each change or only when the user forces a recalculation, such as by pressing F9.

A review tool that finds hidden content in a workbook, including comments, personal information and invisible metadata, and lets you strip it out before sharing.

A formatting rule whose condition is a logical formula returning TRUE or FALSE, allowing highlights that built-in rule types such as greater-than or top-values cannot express.

A restriction on what a cell will accept, such as a list of values, a numeric range or a custom formula, often paired with an input message and an error alert.

A filter command that reads conditions from a separate criteria range, supports complex AND/OR logic, and can copy matching rows to another location instead of hiding them.

A feature that detects a pattern from examples typed in an adjacent column and fills the remaining cells automatically, for example splitting or joining names.

A wizard that splits the text held in one column into several columns, using a delimiter such as a comma or tab, or fixed character widths.

A command that deletes rows whose values repeat an earlier row across the selected columns, leaving only the first occurrence of each record.

A code of placeholders and optional sections that controls how numbers appear, including separators, colours, conditions and different displays for positive, negative, zero and text values.

A set of paste options that applies only chosen attributes of copied data, such as values, formulas or formats, and can transpose rows into columns.

Excel's data connection and shaping tool; it imports from files, databases or the web, records each cleaning step, and loads the result to a sheet or the data model.

Formula syntax that names table parts instead of cell addresses, such as Table1[Sales], so formulas grow automatically when rows are added to the table.

A descriptive name given to a cell, range or formula result, which can then be used in calculations, charts and navigation instead of a cell address.

A lookup function that searches one range or array for a value and returns the corresponding item from a second range, with built-in handling for missing matches.

A paired approach where MATCH returns the position of a lookup value within a list and INDEX returns the item at that same position in another list.

A function that totals only the values meeting every one of several conditions, which are supplied as pairs of criteria ranges and criteria values.

The block of neighbouring cells that a single modern formula fills automatically; the spilled range is referenced by adding the # operator to the formula's cell address.

A function that gives names to intermediate results inside a formula, calculating each value once and making long formulas easier to read and faster to compute.

A function used to define a reusable custom calculation with its own parameters, usually stored in a defined name, without writing any VBA code.

A function that turns a text string into a live cell or range reference, so a formula can point at an address assembled from other cells.

A reference that covers the same cell or range on several worksheets at once, written like Sheet1:Sheet3!A1, and used to consolidate sheets with matching layouts.

A recorded or hand-written sequence of VBA instructions that Excel replays on demand to automate repetitive work such as formatting, filtering or importing data.

The programming language built into Office applications in which macros are written and edited, using the Visual Basic Editor and code modules.

A hidden workbook called PERSONAL.XLSB that stores macros so they remain available in every workbook opened on that computer.

A what-if tool that changes one input cell repeatedly until a formula depending on it produces a target value that you set.

A worksheet range that recalculates one formula for many alternative input values at once, producing one-variable or two-variable sensitivity results.

A what-if tool that saves several named sets of input values and switches between them to compare the results the model produces.

An interactive summary that groups and aggregates a large data range by placing fields into row, column, value and filter areas.

A chart tied to a PivotTable that shares the table's filters and field layout, so the picture updates whenever the summary changes.

A floating panel of buttons that filters a PivotTable, PivotChart or table by clicking values, while showing which items are currently selected.

A date-based filter control for PivotTables that lets users drag through or click periods such as months, quarters and years.

A new PivotTable value defined by a formula that uses existing fields, and evaluated for every source row before the summary aggregates the results.

A PivotTable display option that presents numbers as percentages of a total, running totals, rank, or differences from a previous item instead of raw sums.

A chart that combines two chart types, such as columns and a line, and usually adds a second value axis so series with very different scales stay readable.

A miniature chart drawn inside a single cell that shows the trend of a row or column of values without needing a full chart object.