Exam 96: Functions

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

The ____ function returns one value if the condition is true,and another if the condition is false.

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

When you require a formula to refer to a specific cell,regardless of the formula's location in the spreadsheet,you should use ____________________ references.

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 Nper field?

The ____________________ function calculates the lowest value found in its list of cell references.

In the Error Checking dialog box,clicking the "Help on this error" button requires an Internet connection so that you can access Microsoft's online help.

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

A ____ is a formula that tests a condition that can be either true or false,and then returns a value based on the result of the condition.

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

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

Which of the selections below is a valid formula using relative references?

When using a 3-D reference in a formula,first select the tabs for the source worksheets,then begin typing the formula.

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

From the choices listed below,which function determines the number of times the word "YES" appears in a range of cells?

A formula in cell Z10 references values found in cells A1,B1,and C1.The cursor is situated in cell C1.Clicking Excel's Trace Dependents button creates red arrows pointing from cell ____ to all cells that reference that cell in a formula or function.

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

A function is a pre-made formula that computes a value.

To access the PMT function,click the Formulas tab,then in the Function group,click the Insert button,then click Financial.

The VLOOKUP function looks up values in a table and then inserts those values in another location in a spreadsheet.