# Quiz S12.04: Functions

Computing

Free

True False

False

Free

True False

False

Free

True False

True

Q 4Q 4

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

Free

True False

Q 5Q 5

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

Free

True False

Q 6Q 6

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

Free

True False

Q 7Q 7

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.

Free

True False

Free

True False

Q 9Q 9

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

Free

True False

Q 10Q 10

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.

Free

True False

Free

True False

Free

True False

Q 13Q 13

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

Free

True False

Free

True False

Q 15Q 15

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

Free

True False

Q 16Q 16

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

Free

True False

Q 17Q 17

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)

Free

Multiple Choice

Q 18Q 18

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

Free

Multiple Choice

Q 19Q 19

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

Free

Multiple Choice

Q 20Q 20

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

Free

Multiple Choice

Q 21Q 21

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

Free

Multiple Choice

Q 22Q 22

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")

Free

Multiple Choice

Q 23Q 23

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

Free

Multiple Choice

Q 24Q 24

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

Free

Multiple Choice

Q 25Q 25

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

Free

Multiple Choice

Q 26Q 26

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

Free

Multiple Choice

Q 27Q 27

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

Free

Multiple Choice

Q 28Q 28

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

Free

Multiple Choice

Q 29Q 29

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

Free

Multiple Choice

Q 30Q 30

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

Free

Multiple Choice

Q 31Q 31

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

Free

Multiple Choice

Q 32Q 32

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

Free

Multiple Choice

Q 33Q 33

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

Free

Multiple Choice

Q 34Q 34

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

Free

Multiple Choice

Q 35Q 35

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

Free

Multiple Choice

Q 36Q 36

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

Free

Multiple Choice

Q 37Q 37

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

Free

Multiple Choice

Free

Short Answer

Q 39Q 39

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

Free

Short Answer

Q 40Q 40

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

Free

Short Answer

Q 41Q 41

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

Free

Short Answer

Q 42Q 42

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

Free

Short Answer

Q 43Q 43

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

Free

Short Answer

Q 44Q 44

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

Free

Short Answer

Q 45Q 45

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

Free

Short Answer

Q 46Q 46

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

Free

Short Answer

Q 47Q 47

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.

Free

Short Answer