Excel 2016 Lessons 3-5 Vocabulary Quiz

A pane found on the left side of the Backstage view that provides you access to workbook and file related commands

• navigation pane
• default settings
• print options
• templates

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

• template
• wookbook
• command
• group

Commands on the default ribbon tabs that are related in functionality

• range

• tabs

• groups

• templates

An area on the ribbon that contains groups of related commands

• templates

• range

• groups

• tabs

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

• Absolute cell reference
• Relative cell reference
• External reference
• Mixed cell reference

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

• Cell reference
• Named range
• Operand
• Scope

An equation that performs calculations such as addition, subtraction, multiplication, and division on values in a worksheet

• Formula
• Operand
• Scope
• Variable

A group or cells and occasionally a single cell with a designated name

• Named range
• Value
• Variable
• Operand

A cell reference that adjusts the cell identifier automatically  if you insert or delete column or row or if  you copy the formula to another cell

• Relative cell reference
• Absolute cell reference
• Mixed cell reference
• External reference

A number, a cell address, a date, text, or Boolean data in Excel

• Value
• Variable
• Constant
• Scope