Exam 7: Excell: Formulas and Functions

This is a valid way to use the MAX function: =MAX(a4:d11, f1:f2)

Which keyboard shortcut toggles through the types of reference options?

When working with dates, Excel actually assigns ________ numbers to each date.

Which of the following is not an argument associated with the IF function?

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

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

Which status bar statistic can you not enable?

Which Excel function changes the value to a desired number of decimal places?

The MIN and MAX functions can be used with ________ as well as numbers.

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

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

When you use the VLOOKUP function, the ________ column in the array is used to look up the value.

To look up an exact match, what should you enter in the range_lookup argument?

The default calculation using the PMT function will produce a negative number.

The ROUND function requires how many arguments?

What will you see if you enter the TODAY function without the parenthesis?

The test in an IF function must evaluate to either a True or a False.

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?

When entering functions, the square brackets, [], indicate required values.

Functions can be selected by using the ________.