Exam 2: Formulas and Functions

Which of the following is not a category of functions?

What is not a direct option on the AutoSum drop down menu?

If a cell containing =B$14 is copy and pasted three columns over and two rows down, what would the resultant cell reference become?

After you type a function and its opening parenthesis "(" the ________ appears and displays the function's arguments.

The ROUND function requires how many arguments?

If you omit the fourth argument in a VLOOKUP function, Excel will assume you intend the fourth argument to be False.

The HLOOKUP function can only be used to find exact matches.

All IF functions have three arguments.

If you wanted to count the number of entries in a list that contained numbers, text, and blank cells, but ignore the text and blank cells, which function would you use?

What two functions compute the central tendency of values?

If the annual interest rate is 12% and payments are made monthly, then you would enter ________ in the RATE argument in the PMT function.

The ________ function counts the number of calculable values, but ignores cells that have text or are empty.

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?

The COUNTA function only counts text entries.It does not count calculable values or blank cells.

Which keyboard shortcut toggles through the types of reference options?

What is the default method of referencing cells in formulas?

You could use both A3>b9 or B9<A3 as the test in an IF function and get the same results.You would just switch the second and third arguments.

A good practice when entering function names is to type them in lowercase and see if Excel converts them to upper case.

The inputs in a function are specified by its ________.