Question 1

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

Accepted Answer

The first piece of information that the VLOOKUP function requires is the value to look up. This is the basis for the lookup process and helps the function determine which column to retrieve the corresponding value from. The range of lookup cells, column that holds the desired value, and tab reference are all additional pieces of information that are necessary for the function to work properly, but they come after the value to look up.

Question 2

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

Accepted Answer

The PMT function is used to calculate the payment amount for a loan based on constant payments and a constant interest rate. It is commonly used to calculate car loan payments, mortgage payments, and other types of loans.

Question 3

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

Accepted Answer

The AVERAGE function is specifically designed to calculate the mean, or average, of a set of numerical values. It is the most appropriate function to use when defining the average score in a range of test scores. The MEDIAN function would give the middle value, which isn't necessarily the same as the average. The functions MIDDLE and COUNTAVER don't exist in Excel, so they are not relevant options.

Question 4

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

Accepted Answer

The A1:B9 assignment in the VLOOKUP function indicates the table array. The table array is the range of cells that contains the data to be searched, and it includes both the lookup value column and the result column.

Question 5

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

Accepted Answer

The COUNTIF function is used to count the number of times a specific value appears in a range of cells. In this case, the specific value we are looking for is "No", so the correct formula is =COUNTIF(G7:G12,"No").

Question 6

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

Accepted Answer

A1, B1, and C1 are relative references, meaning that they will adjust based on their position if copied to other cells.

Answer: C
 A1 is a relative reference, but M6$2 and S$4$ are not valid references as they contain both absolute and relative references.

So, the best choice is A.

Question 7

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

Accepted Answer

The formula in option B uses absolute references ($A$20, $B$20, $C$20) which means that when the formula is copied to other cells, it will always refer to those specific cells. This is useful when we want to lock specific cells in a formula and prevent them from changing their reference when the formula is copied. Options A, C, and D contain invalid references or incorrect syntax.

Question 8

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

Accepted Answer

The rate field requires the monthly interest rate, not the annual interest rate. To convert an annual interest rate to a monthly rate, you need to divide it by 12. Therefore, the correct answer is 0.08/12 or 0.0067.

Question 9

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

Accepted Answer

The year of the auto is not necessary to calculate the cost of the car loan. The amount borrowed, annual interest rate, and duration of the loan are the key factors in determining the total cost of the loan.

Question 10

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

Accepted Answer

The COUNT function counts the number of cells in a range that contain numbers. This makes it the best choice to calculate the number of cells in a range of test scores. The AVERAGE function would give you the average score, the MEDIAN function would give you the middle score, and there is no such function as COUNTAVER.

Question 11

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)

Accepted Answer

Option B includes a reference to a range of cells across multiple worksheets, which makes it a 3-D reference. Option A is not a valid formula as there is no function called "SUMS". Option C and D are not valid formulas as there is no function called "SUMOF".

Question 12

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

Accepted Answer

By grabbing the fill handle (the small square in the bottom right corner of the selected cell), you can drag it over the cells where you want the content to be copied, saving time and effort compared to using Copy & Paste or Cut & Paste.

Question 13

The ____ function examines whether a certain condition in a spreadsheet could be true or false.
A) SUM
B) MIN
C) MAX
D) IF

Accepted Answer

The IF function is used to evaluate a logical test or condition and return a value if the condition is true or another value if the condition is false. It is commonly used in spreadsheets to make decisions based on certain criteria.

Question 14

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

Accepted Answer

DTrace Dependents shows which cells depend on the currently selected cell. Since the cursor is in C1, it will show arrows from C1 to any cells that depend on it, which includes Z10. A1 and B1 are not directly affected by the action because the cursor is not in those cells.

Question 15

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

Accepted Answer

This behavior is characteristic of an absolute reference in spreadsheet formulas, where the cell reference does not change when the formula is copied to a new location.

Question 16

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

Accepted Answer

The Trace Precedents feature in Excel shows arrows from cells that provide data to the selected cell. Since Z10 is the cell with the formula referencing A1, B1, and C1, the arrows would point from A1, B1, and C1 to Z10, indicating that Z10 is dependent on these cells.

Question 17

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

Accepted Answer

A "what if" analysis allows you to assess the impact of hypothetical scenarios on future payment calculations. This is often useful in financial planning and decision-making. Choices A, C, and D are not relevant to this particular task.

Question 18

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

Accepted Answer

A 3-D reference refers to the same range of cells on more than one worksheet, allowing users to perform calculations or apply formatting to multiple worksheets at once.

Question 19

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

Accepted Answer

When a formula is copied and pasted to a new location in a spreadsheet, the cell range in the formula updates to reflect the new location. This is an example of a relative reference in Excel. This means that the formula is relative to the cell it is located in, and will adjust accordingly when copied to a new location.

Question 20

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

Accepted Answer

A logical function incorporates decision making into a spreadsheet by testing a condition that can either be true or false. Examples of logical functions include IF, AND, and OR functions. Definite formula and absolute function are not terms commonly used to describe functions in spreadsheets. Conditional function is not a standard term used in Excel, although it may refer to the IF function or a function that depends on certain conditions.

Quiz 49: Functions

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

The PMT function is useful when you need to ____.

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

In Excel,a 3-D reference refers to ____ on more than one worksheet.

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(n) ____ incorporates decision making into your spreadsheet by testing a condition that can either be true or false.