WorksheetsExcel 2019 Core Vocab
Total questions: 20
Worksheet time: 10mins
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
An option which allows the user to set an area of a spreadsheet to print.
Restrict Editing
Slicer
Print Area
Page Layout View
A tool used to create an Excel workbook from a preset workbook that already has defined styles, themes, colors, and fonts.
Template
PivotChart
Sparkline
Macro
A function that performs a horizontal lookup by searching for a value in the top row of the table and returns the value in the same column.
INDEX Function
MATCH Function
Nested Function
HLOOKUP Function
A function that counts the number of cells in a range that meets one or more criteria.
HLOOKUP Function
COUNTIFS Function
GETPIVOTDATA Function
AVERAGEIFS Function
A function that returns the average of all numbers in a range of cells, based on multiple user-specified criteria.
COUNTIFS Function
Financial Functions
HLOOKUP Function
AVERAGEIFS Function
A function that extracts data from specified fields in a PivotTable.
Nested Function
GETPIVOTDATA Function
MATCH Function
INDEX Function
A function that returns a value or the reference to a value from within a table or range.
HLOOKUP Function
Nested Function
MATCH Function
INDEX Function
A function used in a formula within another function.
NOT Function
OR Function
NOW Function
Nested Function
A set of keystrokes or a group of commands recorded or written in code and used to execute multiple commands with a single command.
Macro
Goal Seek
INDEX Function
PivotChart
A function that searches for a specified item in a range of cells and returns the relative position of that item in the range.
MATCH Function
SUMIF Function
TODAY Function
NOW Function
