27 terms

# Com S Ch. 2 Key terms/ Mult. Choice

#### Terms in this set (...)

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