Exam 6: Excel : Formulas and Functions

Which keyboard shortcut toggles through the types of reference options?

The range that contains the lookup table is called the ________.

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

What do you use to separate arguments in a function?

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

What is the default method of referencing cells in formulas?

In a mixed reference you can put the dollar sign ($)in front of the column or row indicator.

The ________ function is similar to the TODAY()function, except that it also returns the system time.

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

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

What error will you get if you type a function name incorrectly?

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

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

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

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell.

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.

________ references change when formulas are copy and pasted.

Which of the following is not a valid lookup function?

If a cell contains =$N$21 and two new columns are inserted in front of column N and three rows are inserted above row 21, what happens to the =$N$21?

A lookup table should contain at least two rows and two columns, not counting headings.