Exam 49: Functions

The ____ tab contains an entire group dedicated to Excel's library of functions.

The Function Library group on the FORMULAS tab provides access to a number of data tools such as the If function.

A Logical_test function is any value or expression that can be evaluated as TRUE or FALSE.

Which of the following formulas is an example of a 3-D reference?

The ____ function calculates the highest value found in its list of cell references.

When you copy and paste a formula one cell below its current spreadsheet location,the cell range in the formula does not change to reflect its new location.This is an example of a(n)____.

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

Functions are the fastest and most accurate way to include formulas in a spreadsheet.

Which of the following selections is a valid formula using absolute references?

To copy the content of one cell to another,click on the cell content,the use Copy & Paste,or ____.

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.

Which of the following is a valid SUM function?

An "error" and a "bug" in a calculation are the same thing.

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

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

Typing an equal sign in a cell,then "A","V","E" will automatically bring up the AVERAGE function for selection.

The COUNTA function counts the number of cells in a range that are not empty.

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

A(n)____ incorporates decision making into your spreadsheet by testing a condition that can either be true or false.

The PMT function is useful when you need to ____.