Quiz 5: Excel's Advanced Functions and Statistical Functions
1. Question:
(TCO 9)
Which of the following is a nested function?
2. Question:
(TCO 9)
If there are four possible outcomes, how many logical tests are required?
3. Question:
(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 _____.
4. Question:
(TCO 9)
Which of the following functions will return the interest payment of a loan?
5. Question:
(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?
6. Question:
(TCO 9)
Which database function will return the smallest value from a dataset based on
preset criteria?
7. Question:
(TCO 9)
When using advanced filtering, empty cells in the criteria range will return
which of the following?
8. Question:
=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n) _____.
9. Question:
(TCO 9)
Which of the following functions is best suited to count numbers based on
multiple conditions?
10. Question:
(TCO 9)
Identify the statistical function used if the rank value returned for duplicate
values was 8.5.
11. Question:
(TCO 9)
Which of the following functions will determine the standard deviation of a
sample?
12. Question:
(TCO 9)
Which feature of the Analysis ToolPak is best suited to determine if samples
were taken from the same population?
13. Question:
(TCO 9)
When using the CORREL function, a value of .9187527 would indicate _____.
14. Question:
(TCO 9)
Which of the following is not an Analysis Toolpak tool?
15. Question:
(TCO 9)
The QUARTILE.INC function returns values in the range _____.
Related Products
Tags: BIS 155 Week 5 Quiz, BIS155 Week5 Quiz, BIS155 Week 5 Quiz, BIS 155 Week5 Quiz, BIS 155 Week 5 Quiz 5.
Message
All members who signed up before 2023 are requested to register again.