BM20: Excel 2016 1.03-1.05 Vocab Quiz

a reference to a specific cell or range of cells regardless of where the formula is located in a worksheet.

• relative cell reference

• absolute cell reference

• mixed cell reference

a group of cells, and occasionally a single cell, with a designated name

• named range

• calculation operator

• nested parentheses

a cell reference that adjusts the cell identifier automatically

• relative cell reference

• absolute cell reference

• mixed cell reference

a cell or range in a worksheet in another Excel workbook, or a defined name in another workbook

• cell reference

• external reference

• relative cell reference

parentheses inside parentheses

• double parentheses

• operator

• nested parentheses

function that determines how many cells in a range contain a number

• =COUNTA

• =SUM

• =COUNT

a function that counts how many cells in a range contain text or a value

• =COUNTA

• =SUM

• =COUNT

two or more cells combined into a single cell

• AutoSum

• merged cells

• format

a pane found on the left side of Backstage View; provides access to workbook and file-related commands

• default settings

• print options

• navigation pane

a reference that identifies a cell's location in the worksheet based on its row number and column letter

• external reference

• cell reference

• mixed cell reference