Com S Ch. 2 Key terms/ Mult. Choice
Terms in this set (27)
Absolute Cell Reference
Indicates cell(s) specific location, does not change when formula is copied.
An input, such as a cell reference or value needed to complete a function
Calculates arithmetic mean, or average of values in range
Tallies number of cells in a range containing values
Evaluates condition and returns one value if condition is true, has different value if false
An expression that evaluates to true or false
Range containing data for basis of the lookup function and data to be retrieved.
Identifies highest value in a range
Identifies midpoint value in set of values
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
Displays current date and time.
Calculates periodic payment for a loan with a fixed interest rate and fixed term.
Calculates total of values contained in two or more cells
Set of rules that govern the structure and components for properly entering a function.
Displays current date
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?
What function would most efficiently accomplish the same thing as =(B5+c5+d5+e5+f5)/5?
When you state to type =AV what feature displays a list of functions and defined names?
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?
Which function should be used to insert current date and time in cell?
What isn't a argument of the IF function?
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?
What is the keyboard shortcut to create an absolute reference?