BIS 155 Week 5 Quiz
Question 1
2 / 2 pts
(TCO 9) Which of the following is a nested function?
Question 2
0 / 2 pts
(TCO 9) If there are two possible outcomes, how many logical tests are required?
Question 3
2 / 2 pts
(TCO 9) When using the MATCH function with an exact match lookup_value, the match type must be set to _____.
Question 4
2 / 2 pts
(TCO 9) Which of the following functions will return the interest payment of a loan?
Question 5
2 / 2 pts
(TCO 9) Which function will calculate the periodic interest rate of a loan with a $500 payment on a $20,000 loan paid back over 5 years?
Question 6
2 / 2 pts
(TCO 9) Which database function will return the smallest value from a dataset based on preset criteria?
Question 7
2 / 2 pts
(TCO 9) When using advanced filtering, < > is the equivalent of _____.
Question 8
2 / 2 pts
What is the maximum number of IF statements in a formula?
Question 9
2 / 2 pts
(TCO 9) Which of the following functions is best suited to count numbers based on multiple conditions?
Question 10
2 / 2 pts
(TCO 9) Identify the statistical function used if the rank value returned for duplicate values was 8.5.
Question 11
2 / 2 pts
(TCO 9) Which of the following will determine the variance of a population?
Question 12
2 / 2 pts
(TCO 9) Which of the following is not an ANOVA calculation that can be performed?
Question 13
2 / 2 pts
(TCO 9) What function is best suited to determine how often a set of numbers appears within a dataset?
Question 14
0 / 2 pts
(TCO 9) Which of the following is not an Analysis Toolpak tool?
Question 15
2 / 2 pts
(TCO 9) When manually typing criteria such as a date in a function, you must enclose the criteria with _____.