Exam 2: Formulas and Functions

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

Which status bar statistic can you not enable?

The TODAY()and NOW()functions are updated every time you open or ________ the spreadsheet.

Which of the following will not return the system clock's date?

There are rare occasions when both the second and third argument of an IF function are executed.

The ROUND function requires how many arguments?

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

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

What keyboard shortcut will automatically update any formulas using =TODAY()or =NOW()?

FV is a required argument in the PMT function.

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

What does Excel use to indicate optional arguments in a function?

Functions can be nested inside the arguments in the various lookup functions.

Functions can be selected by using the ________.

The two optional arguments in the PMT function allows the function to be used with variable loans.

It is called a(n)________ function when a function is used inside of another function.

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

If A9>B7 is the test in an IF function,________ would result in the same results as long as the value if true and the value if false arguments are switched.

Using ________ simplifies adding complex mathematical formulas to a cell.