EXCEL 2016 LESSON 4 USING BASIC FORMULAS Vocabulary

  • Slides: 16
Download presentation
EXCEL 2016 LESSON 4 USING BASIC FORMULAS Vocabulary

EXCEL 2016 LESSON 4 USING BASIC FORMULAS Vocabulary

 A reference to a specific cell or range of cells regardless of where

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. ABSOLUTE CELL REFERENCE

 Operators that specify the calculations to be performed. CALCULATION OPERATOR

Operators that specify the calculations to be performed. CALCULATION OPERATOR

 A reference that identifies a cell’s location in the worksheet based on its

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

 A number or text value entered directly into a formula CONSTANT

A number or text value entered directly into a formula CONSTANT

 A cell or range in a worksheet in another Excel workbook or defined

A cell or range in a worksheet in another Excel workbook or defined name in another workbook. EXTERNAL REFERENCE

 An equation that performs calculations such as addition, subtraction, multiplication, and division on

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

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

A cell reference that uses an absolute column or row reference but not both. MIXED CELL REFERENCE

 A group of cells, and occasionally a single cell, with a designated name.

A group of cells, and occasionally a single cell, with a designated name. NAMED RANGE

 Parentheses inside of parentheses within a formula NESTED PARENTHESES

Parentheses inside of parentheses within a formula NESTED PARENTHESES

 An element that identifies the values to be used in a calculation. OPERAND

An element that identifies the values to be used in a calculation. OPERAND

 The rules Excel follows to calculate any formula that contains two or more

The rules Excel follows to calculate any formula that contains two or more operators. ORDER OF OPERATIONS

 A cell reference that adjusts the cell identifier automatically if you insert or

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. RELATIVE CELL REFERENCE

 Location within which Excel recognizes a named range, which is either a specific

Location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. SCOPE

 A number, cell address, date, text or Boolean data in Excel. Regarding formulas,

A number, cell address, date, text or Boolean data in Excel. Regarding formulas, it is usually a number or cell address. VALUE

 A symbol or name that represents something else. It can be a cell

A symbol or name that represents something else. It can be a cell address, a range of cells, etc. VARIABLE