Deck 96: Functions

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

A) COUNTA
B) SUM
C) MAX
D) HIGHEST

Answer 3

C

Question 4

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

Question 5

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

A) Functions
B) Home
C) References
D) Formulas

Question 6

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

Question 7

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

Question 8

The MIN function is an example of a Database function.

Question 9

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

Question 10

In Excel,all formulas are functions.

Question 11

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

Question 12

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

Question 13

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)

Question 14

Excel provides five different counting functions.

Question 15

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.

Question 16

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

Question 17

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.

Question 18

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

A) AVERAGE
B) MEDIAN
C) COUNT
D) COUNTAVER

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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.

Question 46

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

Question 47

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