Question 1

(TCO 9) Which of the following is a nested function?

• =SUM(B6:B10)

• =IF(AND(B7>5),"Yes","No")

• VLOOKUP(B8,A10:B20,2)

• HLOOKUP(B8,A10:B20,2)

Question 2

(TCO 9) If there are three possible outcomes, how many logical tests are required?

• Four

• Three

• Two

• One

Question 3

(TCO 9) When using the MATCH function looking for the largest value that is less than or equal to the match lookup_value, the match type must be set to _____.

• 1

• 0

• -1

• -2

Question 4

(TCO 9) Which of the following functions will calculate the total interest paid between select periods?

• CUMPRINC

• PMT

• IPMT

• CUMIPMT

Question 5

(TCO 9) Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

• FV

• PV

• NPV

• PMT

Question 6

(TCO 9) Which database function will return the largest value from a dataset based on preset criteria?

• DCOUNT

• DSUM

• DMIN

• DMAX

Question 7

(TCO 9) When using advanced filtering, empty cells in the criteria range will return which of the following?

• All records

• No records

• Select records

• Max records

Question 8

=IF(E5

• database function

• nested IF function

• lookup function

• advanced filter

Question 9

(TCO 9) Which of the following functions is best suited to count numbers based on multiple conditions?

• SUMIF

• SUMIFS

• COUNTIF

• COUNTIFS

Question 10

(TCO 9) Which of the following functions will rank two values evenly if there is a duplicate value present?

• RANK.EQ

• RANK

• RANK.AVG

• PERCENTILE

Question 11

(TCO 9) Which function is best suited to determine how the data set is spread around the mean?

• COVARIANCE

• CORREL

• STDEV.P

• VARA

Question 12

(TCO 9) Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?

• Correlation

• ANOVA

• Descriptive Statistics

• Histogram

Question 13

(TCO 9) When using the CORREL function, a value of .9187527 would indicate _____.

• no relationship

• an inverse relationship

• a strong relationship

• a weak relationship

Question 14

(TCO 9) The Analysis ToolPak is an add-in program that provides statistical analysis tools. Which of the following can be performed by the Analysis ToolPak for analyzing a dataset?

• SUM, SUMIF, Correlation

• NOV, RANK

• Correlation, F-Tests, T-Tests, Z-Tests and ANOVA

• All tests are automatic with the ToolPak.

Question 15

(TCO 9) The QUARTILE.EXC function returns values in the range _____.

• 0 to 3

• 0 to 4

• 1 to 4

• 1 to 3