Skip to main content
10.7: Chapter Review - Key Terms
-
-
Last updated
-
-
Save as PDF
-
Key Terms
-
absolute cell reference
-
one in which the cell reference is fixed, regardless of where you copy the formula
-
array
-
selection of rows or columns that do not have to be contiguous
-
auditing formulas
-
process of using Excel tools to monitor and fix errors in worksheets
-
average
-
number found by adding up a group of values, and then dividing it by the number of values you added up; also called the mean
-
background
-
canvas that is displayed behind the cell contents of a worksheet
-
basic financial functions
-
main functions used for calculating loan installments, investment returns, net present value of capital investments, mortgage payment comparisons, and many more real-world applications
-
cell range
-
selection of rows or columns that is given a name to make it easier for the worksheet designer to find that specific group of cells later
-
Cell Style
-
tool that lets you select other font sizes and background colors
-
comparison operators
-
inequality symbols used in math; includes <, >,
,
, =, and <>
-
complex formula
-
one that uses several operators to calculate an output
-
Data Table
-
scenario-building tool in Excel that lets users choose a set of cells on the spreadsheet, and then outputs different solutions or forecasts depending on different scenarios
-
filter
-
tool in Excel that lets the user select certain criteria so that only data with that criteria is shown
-
Format Painter
-
tool that lets you copy a certain range’s formatting and apply it to a new range
-
logical functions
-
long formulas with embedded logical tests that often use comparison operators to search for delimited data
-
MAX
-
function that finds the highest value in a dataset
-
MIN
-
function that finds the lowest value in a dataset
-
mixed cell reference
-
one that uses a combination of both relative and absolute cell references
-
order of operations
-
universal law of math used to prescribe the order of doing each calculation in an equation
-
PivotTable
-
tool in Excel that lets users create interactive charts and tables from raw datasets
-
relative cell reference
-
one in which the cell reference in a formula or function updates automatically to reference an adjacent cell when you copy that formula or function to another cell
-
standard deviation
-
common statistical tool used by many data analysts that calculates the variability of the figures in a dataset from the arithmetic mean
-
tracing dependent functions
-
finding the source of an error in a formula by finding any cells affected by the active cell
-
tracing precedent functions
-
finding the source of an error in a formula by locating the cells that provide the data to perform the calculation in the active cell