# Download New BIS 155 Week 5: Lab Exercise, Quiz plus Discussion

\$3.99

Category:

## Download New BIS 155 Week 5 Lab Exercise Quiz plus Discussion

##### BIS-155 Week 5 Discussion Answer: Specialized and Statistical Functions
1. Discuss and compare the specialized and statistical functions in Excel. You may need to research your answer.
1. Under what circumstances would you use logical and lookup functions? What financial and statistical functions exist for use? Give examples of how each can be used.

##### BIS-155 Week 5 Excel’s Advanced Functions and Statistical Functions – Quiz
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 …?
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 … to determine if samples were … 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 _____.

## Need Assistance with the Quizzes / Discussions?

Are you looking for online exam help? Our take my online test experts will save you from all the stress you take to solve exams online. Our exam helper will guide you with the most accurate solution for your online exam preparations. We recommend you consult with our online exam helper to find the right direction for clearing your test. Our team has provided online exam help to many students in popular countries like the United States, Canada, Australia, and the United Kingdom, where students have received good grades. So, what are you waiting for? Take this golden opportunity to excel in your test. Chat with us today! Scott Belmont from NYC, USA
Hired a tutor to take programming class and final exam
40 minutes ago Ebony Nicole from Bronx, USA
Hired a tutor to take history and algebra final exams
2 hours ago Randy Wells from Texas, USA
Hired an expert to take chemistry proctored exam
1 hour ago Kurt LeBlanc from Iowa, USA
Hired an expert to take statistics online exam
1 hour ago