Quiz S12.04: Functions

In Excel,all formulas are functions.

The MIN function is an example of a Database function.

Excel provides five different counting functions.

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

Given the formula =IF(X4="NO","CHARGE","FREE"),when the value of X4 is NO,the formula result is FREE.

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

When creating a VLOOKUP formula,the table range entry should be based on relative references so the formula produces correct results when copied to a new location.

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

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

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.

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

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

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

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

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

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

Which of the following choices is a valid SUM function? A) =SUM(G7:G11) B) =SUM(G7-G11) C) =SUMS(G7:G11) D) =SUMS(G7-G11)

The ____ tab contains an entire group dedicated to Excel's library of functions. A) Functions B) Home C) References D) Formulas

The ____ function calculates the highest value found in its list of cell references. A) COUNTA B) SUM C) MAX D) HIGHEST

To determine the average score in a range of test scores,you should use the ____ function. A) AVERAGE B) MEDIAN C) COUNT D) COUNTAVER

To determine the number of cells in a range of test scores,you should use the ____ function. A) AVERAGE B) MEDIAN C) COUNT D) COUNTAVER

From the choices listed below,which function determines the number of times the word "YES" appears in a range of cells? A) =COUNT(G7:G12,"YES") B) =COUNTIF(G7:G12,"YES") C) =COUNTA(G7:G12,"YES") D) =SUMIF(G7:G12,"YES")

In Excel,a 3-D reference refers to ____ on more than one worksheet. A) a different range of cells B) the same formula found C) the same function found D) the same range of cells

When you copy and paste a formula one cell below its current spreadsheet location,the cells referenced in the formula change to reflect its new location.This is an example of a(n)____. A) function B) absolute reference C) link D) relative reference

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)____. A) function B) absolute reference C) link D) relative reference

Which of the selections below is a valid formula using relative references? A) =A1+B1+C1 B) =$A$20+$B$20+$C$20 C) =A1+M6$2+S$4$ D) =$4+Z55+D7

Which of the selections below is a valid formula using absolute references? A) =A1+B1+C1 B) =$A$20+$B$20+$C$20 C) =A1+M6$2+S$4$ D) =$4+Z55+D7

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. A) formula B) function C) logical function D) conditional function

The ____ function returns one value if the condition is true,and another if the condition is false. A) SUM B) MIN C) MAX D) IF

The first piece of information the VLOOKUP function requires is the ____. A) range of lookup cells B) column that holds the desired value C) value to look up D) none of the above

The PMT function is useful when you need to ____. A) compute sales tax on an item purchased B) calculate a car loan payment C) compare one number against another number D) compute the payment due at a cash register

If an annual interest rate is 9%,the monthly interest rate is expressed as ____. A) .09/12 B) 12/9% C) 12*9% D) .09*12

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? A) 7 B) 7*12 C) .08/12 D) 20,000

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? A) 7 B) 7*12 C) .08/12 D) 20,000

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? A) 8% B) .08*12 C) .08/12 D) 8%-12

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. A) A1 B) B1 C) C1 D) Z10

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. A) A1 B) B1 C) C1 D) Z10

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

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

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

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

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

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

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

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

The result of the PMT function returns a(n)____________________ number that displays in a red font on the screen.

You are reviewing the screen results after clicking the Trace Precedents button in Excel.To hide the arrows appearing on the screen,you should click the ____________________ button on the Formulas tab.