Manage Workbook Options
The address of a Row is denoted by a...
Number
Provides an option to autofill data across a row or column using a user-established pattern.
Fill Series
A list of commands that are recorded or coded with the purpose of executing the commands using a single command.
Macro
A function that allows the user to check multiple IF conditions.
IFS
A type of chart used to plot more than one data series using a second axis.
Dual-Axis Chart
The address of a Column is denoted by a...
Letter
A feature that creates rows and columns based on values in the selected cells.
AutoFill
A function that adds up all of the numbers in a range of cells based on a criterion that the user specifies.
SUMIF
A function that returns the opposite of a result.
NOT
A tool that allows the user to view different scenarios based on the changes they make to the input and output data.
Scenario Manager
A tool that provides options on the amount of editing the user will allow other users to make, within the worksheet.
Restrict Editing
A tool that allows a user to establish the format of data that is entered into cells.
Data Validation
A function that returns the average in a range of cells based on multiple specified criteria.
A function that allows the user to check for multiple conditions and returns true if all conditions are met and false if any of the conditions are not met.
AND
A tool used within a PivotTable to filter selected data.
Slicer
This option allows the user to set a password to protect the structure of the workbook from being changed.
Workbook Protection
A setting that allows data to be formatted a certain way if the user-defined conditions are met.
Conditional Formatting
A function that counts the number of cells in a range that meets one or more criteria.
COUNTIFS
A function that looks at multiple conditions and returns true if at least one condition is met and false if no conditions are met.
OR
A tool that visually represents the data in a PivotTable.
This option allows a user to set protection settings on a worksheet with a password.
Worksheet Protection
This reference type makes $ure it is always referenced even when autofill is used.
A function that returns the largest value in a range of cells that meet one or more criteria.
MAXIFS
A function used in a formula within another function.
Nested Function
A table that summarizes data from a larger table by providing the user with alternative ways to group the data.
PivotTable