27 terms

Absolute Cell Reference

Indicates cell(s) specific location, does not change when formula is copied.

Argument

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

AVERAGE function

Calculates arithmetic mean, or average of values in range

COUNT function

Tallies number of cells in a range containing values

IF function

Evaluates condition and returns one value if condition is true, has different value if false

Logical test

An expression that evaluates to true or false

Lookup table

Range containing data for basis of the lookup function and data to be retrieved.

MAX function

Identifies highest value in a range

MEDIAN function

Identifies midpoint value in set of values

MIN function

Displays lowest value in range

Mixed cell reference

Contains both absolute and relative cell reference in formula, absolute doesn't change but relative part does when formula is copied

NOW function

Displays current date and time.

PMT function

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

SUM function

Calculates total of values contained in two or more cells

Syntax

Set of rules that govern the structure and components for properly entering a function.

TODAY function

Displays current date

VLOOKUP function

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

If cell E15 contains formula =$c$5*j$15, what type of cell reference is J$15 in formula?

Mixed reference

What function would most efficiently accomplish the same thing as =(B5+c5+d5+e5+f5)/5?

=AVERAGE(b5:f5)

When you state to type =AV what feature displays a list of functions and defined names?

Formula AutoComplete

Formula containing entry =$b3 is copied to a cell one column to the right and two rows down, how will the entry appear in new location?

=$b5

Which function should be used to insert current date and time in cell?

=NOW()

What isn't a argument of the IF function?

lookup_value

what isn't true about VLOOKUP function?

Lookup table must be in descending order

Function =PMT(c5,c7,-c3) is stored in cell c15, what must be stored in cell c5

Number of payment periods

What isn't an appropriate use of the SUM function?

=SUM(d15-c15)

What is the keyboard shortcut to create an absolute reference?

Ctrl+F4