Excel_1B Terms

A block of adjacent cells in a worksheet is called a ________.

• Contiguous Range

• Noncontiguous Range

• Cell Reference

• Worksheet

Cells in a worksheet that act as a block, but are not necessarily adjacent to each other, are called ________.

• Noncontiguous Range

• Contiguous Range

• Merged Cells

• Active Cells

A block of cells in an Excel worksheet is called a ________.

• Range

• Sheet

• Formula

• Chart

Symbols used in mathematical operations, such as + for addition, - for subtraction, * for multiplication, / for division, and ^ for exponentiation, are called ________.

• Arithmetic (Mathematical) Operators

• Logical Connectives

• Programming Keywords

• Data Types

An instruction Excel uses to calculate a result is called a ________.

• Formula

• Cell

• Chart

• Range

The order in which Excel performs the mathematical operations specified in a formula, based on the types of mathematical operators used, is called ________.

• Order of Precedence

• Order of Execution

• Calculation Sequence

• Formula Hierarchy

A built-in calculation used to add a range of values together in Excel is called the ________.

• SUM Function

• AVERAGE Function

• COUNT Function

• MIN Function

A cell address in a formula that will not change when you copy the formula to another location is called an ________.

• Absolute Reference

• Relative Reference

• Mixed Reference

• Dynamic Reference

A Windows feature that holds data or graphics you cut or copy prior to pasting to another location is called the ________.

• Clipboard

• Recycle Bin

• Taskbar

• Start Menu

The command used to place a copy of data from the selected cell or range on the Clipboard is called ________.

• Copy

• Paste

• Cut

• Delete