Chapter 6 Quiz
Which function category splits, joins, or converts labels and values in a
worksheet? - CORRECT ANSWER-Text
Which of the following shows the correct syntax for the NPV function? -
CORRECT ANSWER-=NPV(rate,value1,value2,...)
In OR functions and AND functions, how many LogicalN arguments can you
use? - CORRECT ANSWER-255
Which of the following text functions combines strings of text, values, or
characters? - CORRECT ANSWER-TEXTJOIN
Which of the following database functions averages the values of cells in the field
that meet the criteria? - CORRECT ANSWER-DAVERAGE
Which of the following error values indicates that the formula divides by zero (0)
or an empty cell? - CORRECT ANSWER-#DIV/0!
Which of the following functions joins or combines data strings? - CORRECT
ANSWER-CONCAT function
Which of the following keystrokes are considered completion keys when
executing functions as array formulas? - CORRECT ANSWER-Ctrl+Shift+Enter
Which of the following functions assumes that cash flows occur at the end of
each period? - CORRECT ANSWER-NPV function
Which of the following calculates the average deviation of the absolute values in
a range? - CORRECT ANSWER-AVEDEV
Which of the following is not a TEXT function? - CORRECT ANSWER-MATCH
Which of the following shows the correct syntax for the REPLACE function? -
CORRECT ANSWER-=REPLACE(old_text,start_num,num_chars,new_text)
, Which of the following is not true when building date and time calculations? -
CORRECT ANSWER-Excel uses a 12-hour day in time calculations
Which of the following financial function arguments is the total number of
payments? - CORRECT ANSWER-nper
Which of the following calculates where a particular value falls relative to all the
other values? - CORRECT ANSWER-RANK.EQ
Which of the following calculates the standard deviation for an entire population
instead of a sample? - CORRECT ANSWER-STDEV.P
Which of the following functions displays a custom error message? - CORRECT
ANSWER-IFERROR
Using the PV function, if the interest rate is an annual rate and the payments are
quarterly, what should you type after the cell address? - CORRECT ANSWER-/4
Which function displays columnar data in rows and vice versa? - CORRECT
ANSWER-Transpose
Which of the following database functions counts cells with values in the field that
meet the criteria? - CORRECT ANSWER-DCOUNT
Which of the following measures how spread out a set of values is from the
average? - CORRECT ANSWER-Mean Absolute Deviation (MAD)
Which of the following shows the correct syntax for the AND function? -
CORRECT ANSWER-=AND(LogicalN)
Which of the following measures how broadly values differ from the mean or
average value in a range of numbers? - CORRECT ANSWER-Standard
Deviation
Which of the following functions determines the future value of a series of
payments at the same interest rate for a specified period of time? - CORRECT
ANSWER-FV function
Which function category splits, joins, or converts labels and values in a
worksheet? - CORRECT ANSWER-Text
Which of the following shows the correct syntax for the NPV function? -
CORRECT ANSWER-=NPV(rate,value1,value2,...)
In OR functions and AND functions, how many LogicalN arguments can you
use? - CORRECT ANSWER-255
Which of the following text functions combines strings of text, values, or
characters? - CORRECT ANSWER-TEXTJOIN
Which of the following database functions averages the values of cells in the field
that meet the criteria? - CORRECT ANSWER-DAVERAGE
Which of the following error values indicates that the formula divides by zero (0)
or an empty cell? - CORRECT ANSWER-#DIV/0!
Which of the following functions joins or combines data strings? - CORRECT
ANSWER-CONCAT function
Which of the following keystrokes are considered completion keys when
executing functions as array formulas? - CORRECT ANSWER-Ctrl+Shift+Enter
Which of the following functions assumes that cash flows occur at the end of
each period? - CORRECT ANSWER-NPV function
Which of the following calculates the average deviation of the absolute values in
a range? - CORRECT ANSWER-AVEDEV
Which of the following is not a TEXT function? - CORRECT ANSWER-MATCH
Which of the following shows the correct syntax for the REPLACE function? -
CORRECT ANSWER-=REPLACE(old_text,start_num,num_chars,new_text)
, Which of the following is not true when building date and time calculations? -
CORRECT ANSWER-Excel uses a 12-hour day in time calculations
Which of the following financial function arguments is the total number of
payments? - CORRECT ANSWER-nper
Which of the following calculates where a particular value falls relative to all the
other values? - CORRECT ANSWER-RANK.EQ
Which of the following calculates the standard deviation for an entire population
instead of a sample? - CORRECT ANSWER-STDEV.P
Which of the following functions displays a custom error message? - CORRECT
ANSWER-IFERROR
Using the PV function, if the interest rate is an annual rate and the payments are
quarterly, what should you type after the cell address? - CORRECT ANSWER-/4
Which function displays columnar data in rows and vice versa? - CORRECT
ANSWER-Transpose
Which of the following database functions counts cells with values in the field that
meet the criteria? - CORRECT ANSWER-DCOUNT
Which of the following measures how spread out a set of values is from the
average? - CORRECT ANSWER-Mean Absolute Deviation (MAD)
Which of the following shows the correct syntax for the AND function? -
CORRECT ANSWER-=AND(LogicalN)
Which of the following measures how broadly values differ from the mean or
average value in a range of numbers? - CORRECT ANSWER-Standard
Deviation
Which of the following functions determines the future value of a series of
payments at the same interest rate for a specified period of time? - CORRECT
ANSWER-FV function
