# Devry BIS 155 Week 5 Quiz

(TCO 9) Which of the following is a nested function? **(Points : 2)**

- =SUM(B6:B10)
- =IF(AND(B7>5),”Yes”,”No”)
- VLOOKUP(B8,A10:B20,2)
- HLOOKUP(B8,A10:B20,2)

**Question 2. 2.** (TCO 9) If there are three possible outcomes, how many logical tests are required? **(Points : 2)**

- Four
- Three
- Two
- One

**Question 3. 3.** (TCO 9) When using the MATCH function with an exact match lookup_value, the match type must be set to _____. **(Points : 2)**

- 1
- 0
- -1
- -2

**Question 4. 4.** (TCO 9) Which of the following functions will return the principal payment of a loan? **(Points : 2)**

- CUMPRINC
- PMT
- IPMT
- PPMT

**Question 5. 5.** (TCO 9) Which function will calculate the current value on an investment that will earn 5% interest on yearly payments of $100 over 10 years? **(Points : 2)**

- FV
- PV
- NPV
- PMT

**Question 6. 6.** (TCO 9) Which database function will return the smallest value from a dataset based on preset criteria? **(Points : 2)**

- DCOUNT
- DSUM
- DMIN
- DMAX

**Question 7. 7.** (TCO 9) Which of the following functions has the ability to copy all results to a new location? **(Points : 2)**

- Advanced Filter
- DSUM
- IPMT
- DMAX

**Question 8. 8.** =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n) _____. **(Points : 2)**

- database function
- nested IF function
- lookup function
- advanced filter

**Question 9. 9.** (TCO 9) Which of the following functions is best suited to count numbers based on multiple conditions? **(Points : 2)**

- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS

**Question 10. 10.** (TCO 9) Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present? **(Points : 2)**

- EQ
- RANK
- AVG
- PERCENTILE

**Question 11. 11.** (TCO 9) Which of the following will determine the variance of a population? **(Points : 2)**

- VARA
- P
- S
- VARPA

**Question 12. 12.** (TCO 9) The Analysis ToolPak can be activated in _____. **(Points : 2)**

- Review tab
- Developer tab
- Excel Options
- Formula tab

**Question 13. 13.** (TCO 9) When using the CORREL function, a value of .9187527 would indicate _____. **(Points : 2)**

- no relationship
- an inverse relationship
- a strong relationship
- a weak relationship

**Question 14. 14.** (TCO 9) Which of the following is not an Analysis Toolpak tool? **(Points : 2)**

- Standard deviation
- Histogram
- Analysis of variance
- Covariance

**Question 15. 15.** (TCO 9) The QUARTILE.EXC function returns values in the range _____. **(Points : 2)**

- 0 to 3
- 0 to 4
- 1 to 4
- 1 to 3