Microsoft Excel Lesson 3 & 4

Pre-set settings that determine how Excel behaves when performing an action

• group

• default settings

• template

• tab

Commands on the default ribbon tabs that are related in functionality.

• tabs

• groups

• print options

• template

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.

• navigation pane

• tab

• print settings

• template

Several settings that enable you to change how a document prints

• default settings

• navigation pane

• tab

• print options

(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.

• template

• group

• tab

• formula

A file that includes formatting and formulas complete with designs, tools, and specific data types.

• scope

• cell reference

• named range

• template

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.

• named range

• nested parentheses

• absolute cell reference

• scope

Operators that specify the calculations to be performed

• variable

• calculation operator

• value

• mixed cell reference

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

• external reference

• operand

• formula

• cell reference

A number or text value entered directly into a formula.

• constant

• variable

• formula

• relative cell reference