• BIS 155 Week 5 | Quiz
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 _____.

BIS 155 Week 5 | Quiz

  • Institution(s): Devry
  • Year Published: 2021
  • Digital Download: Instant
  • $5.00

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.