Excel Lesson 3 4 Vocabulary Review Question Preview (ID: 34976)


Excel Lesson 3 4 Vocabulary Review.

A number or text value entered directly into a formula.
a) value
b) variable
c) constant
d) formula

Operators that specify the calculations to be performed.
a) absolute cell reference
b) calculation operator
c) cell reference
d) constant

A reference that identifies a cell’s location in the worksheet based on its row number and column letter.
a) constant
b) cell
c) cell reference
d) named range

A file that includes formatting and formulas complete with designs, tools, and specific data types.
a) tab
b) template
c) group
d) print options

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
a) absolute cell reference
b) calculation operator
c) cell reference
d) constant

(1) An area on the ribbon that contains groups of related commands. See command tab. (2) An area of the Backstage navigation pane that contains groups of related commands.
a) tab
b) print options
c) group
d) default settings

Several settings that enable you to change how a document prints.
a) default settings
b) group
c) navigation pane
d) print options

Commands on the default ribbon tabs that are related in functionality.
a) default settings
b) group
c) navigation pane
d) print options

A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.
a) default settings
b) group
c) navigation pane
d) print options

Pre-set settings that determine how Excel behaves when performing an action.
a) default settings
b) group
c) navigation pane
d) print options

A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
a) formula
b) cell
c) scope
d) external reference

An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
a) formula
b) mixed cell reference
c) named image
d) operand

A cell reference that uses an absolute column or row reference, but not both.
a) formula
b) mixed cell reference
c) named range
d) scope

A group of cells, and occasionally a single cell, with a designated name.
a) scope
b) value
c) variable
d) named range

Parentheses inside of parentheses within a formula.
a) operand
b) nested parenthesis
c) scope
d) value

An element that identifies the values to be used in a calculation.
a) scope
b) value
c) variable
d) operand

The rules Excel follows to calculate any formula that contains two or more operators.
a) named range
b) operand
c) order of operations
d) value

A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
a) mixed cell reference
b) absolute cell reference
c) relative cell reference
d) constant

A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
a) variable value
b) constant
c) value
d) formula

A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
a) constant
b) scope
c) variable
d) value

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 34976 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register