MIS Chapter 1 and 2 KeyTerms

A set of rules that governs the structure and components for properly entering a function.

Syntax

Displays the current date

TODAY Function

Indicates a cell’s specific location; the cell reference does not change when you copy the formula

Absolute Reference

An input, such as a cell reference or value, needed to complete a function

Argument

Identifies the highest value in range

MAX Function

Tallies the number of cells in a range that contain values

COUNT Function

Looks up a value in a vertical lookup table and returns a related result from the lookup table

VLOOKUP

A range that contains data for the basis of the lookup and data to be retrieved

Lookup Table

Calculates the arithmetic mean, or average, of values in a range

AVERAGE Function

Identifies the midpoint value in a set of values

MEDIAN Function

Displays the current date and time

NOW Function

Evaluates a condition and returns one value if the condition is true and a different value if the conditions is false

IF Function

Calculates the total of values contained in one or more cells

SUM Function

Calculates the periodic payment for a loan with a fixed interest rate and fixed term

PMT Function

Indicates a cell’s location from the cell containing the formula; the cell reference changes when the formula is copied

Relative Reference

Contains both an absolute and a relative cell reference in a formula; the absolute part does not change, but the relative part does when you copy the formula

Mixed Reference

An expression that evaluates to true or false

Logical Test

Displays the lowest value in a range

MIN Function

Rounds a number to a specified number of digits

ROUND Function

Can be used a return value regardless of the location of the return array

XLOOKUP Function

A spreadsheet that contains formulas, functions, values, text, and visual aid

Worksheet

A file containing related worksheets

Workbook

Identifies the address of the current cell

Name Box

Displays the content (text, value, date, or formula) in the active cell

Formula Bar

Displays the name of worksheet within a workbook

Sheet Tab

The intersection of a column and row

Cell

A range of cells containing results based on manipulating the variable

Output

A range of cells containing values for variables use in formula

Input

Includes letters, numbers, symbols, and spaces

Text

Enables you to copy the contents of cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cell

Autofill

A small green square at the bottom right corner of cell

Fill Handle

A number that represents a quantity or amount

Values

A combination of cell references, operators, values, and/or functions used to perform a calculation

Formulas

Rules that control the sequence in which Excel performs arithmetic operations

Order of Operations

The horizontal measurement of a column

Column Width

The vertical measurement of a row

Row Height

A rectangular group of cells

Range

The position of data between the cell margins

Alignment

Formatting that enables a label to appear on multiple lines within the current cell

Merge Cells

The background color appearing behind the data in a cell.

Fill Color