Deck 49: Functions

Question 1

One purpose of the PMT function is to help you calculate the payment for a mortgage loan that has a fixed rate of interest.

Answer 1

True

Question 2

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.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

Which of the following is a valid SUM function?

A) =SUM(G7:G11)
B) =SUM(G7!G11)
C) =SUM{G7:G11}
D) =SUM

Question 5

An absolute reference doesn't change when the formula referencing it is copied to another cell.

Question 6

By default,the SUM function is applied when you click the AutoSum button in the Editing group.

Question 7

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

Question 8

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

Question 9

The VLOOKUP function refers to the same cell or range of cells on multiple worksheets.

Question 10

Only values can be copied from one cell to another.

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

A) FUNCTIONS
B) HOME
C) REFERENCES
D) FORMULAS

Question 16

It is possible to refer to the same cell reference in multiple worksheets.

Question 17

In an Excel calculation result,an expense will appear in red.

Question 18

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

Question 19

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

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

Question 20

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

Question 21

The first piece of information that the VLOOKUP function requires is the ____.

A) range of lookup cells
B) column that holds the desired value
C) value to look up
D) tab reference

Question 22

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 23

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

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

Question 24

In the function =VLOOKUP(C1,A1: B9,2,False),the A1: B9 assignment indicates the ____.

A) Lookup_Value
B) Table_Array
C) Col_Index_num
D) Range_lookup

Question 25

Which of the following functions determines the number of times the word "No" appears in a range of cells?

A) =COUNT(G7:G12,"No")
B) =COUNTIF(G7:G12,"No")
C) =COUNTA(G7:G12,"No")
D) =SUMIF(G7:G12,"No")

Question 26

Which of the following selections 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) =A1B1C1

Question 27

Which of the following selections 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) =A1B1C1

Question 28

When an auto loan's terms are an 8%-per-year interest rate,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 29

Which of the following items is NOT needed in order to calculate the cost of a car loan?

A) year of the auto
B) amount borrowed
C) annual interest rate
D) duration of loan

Question 30

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

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

Question 31

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

A) =SUMS(O14Anders:Zhang!)
B) =SUM(Anders:Zhang!O14)
C) =SUMOF'Zhang:Andrews'!
D) =SUMOF(Anders:Zhang!O14)

Question 32

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

A) choose Cut from the Clipboard
B) grab the fill handle and drag over the cells to which you want the content copied
C) move the cursor back onto the cell and drag to the new cell
D) choose Move from the Clipboard

Question 33

The ____ function examines whether a certain condition in a spreadsheet could be true or false.

A) SUM
B) MIN
C) MAX
D) IF

Question 34

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 ____.

A) A1
B) B1
C) C1
D) Z10

Question 35

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)____.

A) function
B) absolute reference
C) link
D) relative reference

Question 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

Question 37

Once you have completed a payment analysis calculation using the PMT function,you may want to perform a(n)____ analysis to predict future changes.

A) absolute
B) what if
C) VLOOKUP
D) 3-D references

Question 38

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 39

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

A) function
B) absolute reference
C) link
D) relative reference

Question 40

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

A) definite formula
B) absolute function
C) logical function
D) conditional function