8.5 Chapter Assessment

The following are sample questions to test whether you know, understand, and are able to apply concepts from this chapter BASED ON THE CHAPTER 8.1, 8.2, 8.3 WALKTHROUGH PROBLEMS and the 8.4 practice quizlet.

 

1. The _____ function allows you to make a _______ comparison between a value and what you expect by testing for a condition and returning a result if True or False.
a) IF, Logical
b) THEN, Conditional
c) WHATIF, Conditional
d) IF, Conditional
2. The _____ function determines if ALL conditions in a logical test are TRUE.
a) IF
b) AND
c) OR
d) NOT
3. You can place multiple AND functions inside an IF function.
True/False

4. The following formula has a _____ function IF([@PCIP52]>0.15,”High”,IF([@PCIP52]>0,”Some”,”None”)).

a) Conditional
b) Criteria-based
c) Nested
d) Statistical
5. The following formula will output _____ for 0.0683 in the PCIP 52 field. IF([@PCIP52]>0.15,”High”,IF([@PCIP52]>0,”Some”,”None”)).
a) TRUE
b) FALSE
c) High
d) Some
6. Which function will allow you to return the number of colleges in Texas?
a) COUNTIF
b) COUNTIFS
c) SUMIF
d) SUMIFS
7. How many undergraduates are there in Houston, TX in 2-year-degree programs? Use a conditional function to calculate, use an Excel table or a PivotTable to confirm your answer.
a) 4472
b) 47763
c) 60639
d) 145204
8. How many students are there in Texas enrolled in 2-year-degree programs? Use a conditional function to calculate, use an Excel table or a PivotTable to confirm your answer.
a) 4472
b) 47763
c) 606845
d) 145204
9. What is the average % students enrolled in Business programs in Texas? Use a conditional function to calculate, use an Excel table or a PivotTable to confirm your answer.
a) 8.15%
b) 12.45%
c) 15.75%
d) 30%
10. How many criteria are you evaluating in a conditional function in order to answer the following question? “What is the average % students enrolled in Business programs in Houston, Texas, in 2-year-degree programs?”
a) 1
b) 2
c) 3
d) 4

 


Solutions: 1a, 2b, 3True, 4c, 5d, 6a, 7c, 8c, 9a, 10c

Attribution

Practice problems by Robert McCarn, Emese Felvégi, Bauer Tutoring Services based on chapter content and chapter practice files.  CC BY-NC-SA 3.0.

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Excel For Decision Making by Emese Felvegi, Noreen Brown, Barbara Lave, Julie Romey, Mary Schatz, Diane Shingledecker, and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.