Exam 6: Excel : Formulas and Functions

Which of the following is not a category of functions?

What two functions compute the central tendency of values?

What punctuation is used to separate the two cell references in a range?

Match the example with the function or feature: I. 1,2,3,4,5 II. Winona Lake, Winchester, Perrysburg, Clear Spring III. Return 52 from the list: 29, 47, 21, 52, 1 IV. Return 30 from the list: 29, 47, 21, 52, 1 V. Return 29 from the list: 29, 47, 21, 52, 1 A. MAX B. Sort descending C. MEDIAN D. Sort ascending E. AVERAGE

Match the result with the function using the following numbers, 21, 42, 97, 1, 14, 199 [to two decimal places]: I. 31.50 II. 62.33 III. 1 IV. 6 V. 199 A. MIN B. MEDIAN C. MAX D. COUNT E. AVERAGE

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

The ________ feature in Excel displays various options when you type an equal (=)sign and then begin typing a function name.

What actually changes the value Excel stores to a user determined number of decimal places?

Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

The ________ function finds the largest value in a range.

The VLOOKUP function has four required arguments.

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

________ is a set of analytical tools that appears when you select a range.

Which of the following does not comply with the preferred way of using the SUM function?

A function's ________ defines the rules by which the function operates.

In a lookup table, the number of the column which contains the return values is called the ________.

What does the AVERAGE function not ignore?

In the PMT function, the PV argument refers to the ________ of the loan.

The PMT function uses three required arguments and no optional arguments.

Using ________ simplifies adding complex mathematical formulas to a cell.