Exam 96: Functions

You can create an absolute cell reference by adding dollar signs to the column and row references in a formula.

To change the PMT function's result to a positive number,place a plus operator before the function name in the formula bar.

In Excel,to calculate the cost of any loan,three pieces of information are needed.

Copying a(n)____________________ from one cell to another is accomplished in the same manner as copying a value or number.

When an auto loan's terms are 8% per year interest,seven years in length,and a purchase price of $20,000,what value should be entered in the PV field?

The PMT function is useful when you need to ____.

The first piece of information the VLOOKUP function requires is the ____.

In Excel,all formulas are functions.

The PMT function requires the duration of an auto loan to be entered as payment periods per ____________________.

A formula in cell Z10 references values found in cells A1,B1,and C1.The cursor is situated in cell Z10.Clicking Excel's Trace Precedents button creates blue arrows pointing from cell ____ to all of the other cells mentioned above.

The Insert tool on the Formulas tab includes the Logical category,which gives you access to a variety of logical functions.

In Excel,a 3-D reference refers to ____ on more than one worksheet.

The VLOOKUP function requires four pieces of information to perform its operations.

In Excel,the ____________________ function adds the cells directly above it by default.

If an annual interest rate is 9%,the monthly interest rate is expressed as ____.

When an auto loan's terms are 8% per year interest,seven years in length,and a purchase price of $20,000,what value should be entered in the Rate field?

In the formula =IF(B4=120,B3,B2),the second part of the function is B3 and it is called the value if ____________________.

To determine the number of cells in a range of test scores,you should use the ____ function.

Which of the following choices is a valid SUM function?

The MIN function is an example of a Database function.