Excel 2019 Core Vocab

Cell references that remain constant throughout spreadsheet shape or size changes, or are copied or moved to another cell or sheet.

• Controlled Reference

• Relative Reference

• Cube Functions

• Absolute Reference

A function that allows you to check for multiple conditions and returns true if all conditions are met and false if one or more conditions are not met.

• COUNTIFS Function

• AVERAGEIFS Function

• AutoFill

• AND Function

A feature that automatically fills in cells with patterned values.

• Cell Style

• Fill Series

• AutoFill

• Form Controls

An option that will format a cell to a user-defined format.

• Cell Style

• Page Layout View

• Normal View

• Freeze Rows and Columns

A common separator between text to identify what text will be in what field when importing into Excel.

• Macro

• Common Delimiter

• Fill Series

• Data Validation

An option which gives the user the ability to establish a pattern of data and use it to AutoFill across a row or column.

• Print Area

• Form Controls

• Fill Series

• INDEX Function

A group of functions that executes a variety of financial calculations, including calculations of yield, investment valuations, interest rates, internal rate of return, asset depreciation, and payments.

• Formula Calculation

• MATCH Function

• SUMIF Function

• Financial Functions

In this view, Excel maximizes the number of visible cells on the screen by keeping the row numbers and column letters minimal in size and close to the rows and columns.

• Page Layout View

• Page Break Preview View

• Print Area

• Normal View

In this view, blue lines indicate where the page breaks are in a sheet.

• Page Break Preview View

• Page Layout View

• Normal View

• Scenic View

In this view, Excel displays where pages begin and end and enable easier editing of header and footer data.

• Restricted View

• Page Layout View

• Page Break Preview View

• Normal View