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