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