MOAC Lesson 4

Question 0

Value

Answer 0

Can be a number, cell address, date, text, Boolean data

Question 1

Formula

Answer 1

Equation that performs calculations

Question 2

Operands

Answer 2

Identify the values that need to be used in an operation

Question 3

Constant

Answer 3

A number or text value that is entered directly into a formula

Question 4

Variable

Answer 4

Symbol or name that represents something else

Question 5

Calculation operators

Answer 5

Specify the calculations to be performed

Question 6

Order of operations

Answer 6

To calculate the formula

Question 7

Nested parentheses

Answer 7

Parentheses inside of themselves

Question 8

Cell reference

Answer 8

Identifies a cells reference

Question 9

Relative cell reference

Answer 9

One that adjusts the cell identifier automatically

Question 10

Absolute cell reference

Answer 10

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

Question 11

Mixed cell reference

Answer 11

A cell reference that uses an absolute column or row reference, but not both

Question 12

External reference

Answer 12

Refers to a cell or a range in a worksheet in another Excel workbook

Question 13

Named range

Answer 13

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

Question 14

Scope

Answer 14

The location within which Excel recognizes the name without qualification