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

Wait.... Hire Me To Get 100% Original Help In . With No Upfront Fees. Watch The Video Below For More Information & How It Works!

Play Video

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

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