Case-Based Critical Thinking Questions
Case 2-1
Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems.
-After showing her boss the data, he asked her to run one more COUNTIF to determine who is on one or more committees. The correct formula would be ____.
Definitions:
Presentations
This term refers to the act of showing and explaining the content of a topic to an audience, often using visual aids.
Word "I"
The use of the first-person singular pronoun in communication, indicating self-reference by the speaker.
Scope of Practice
The range of services that a professional is qualified and authorized to perform based on their training, certification, or licensure.
Nutrition
The study of nutrients in food, how the body uses them, and the relationship between diet, health, and disease.
Q1: #3<br>A)Counts all Inspector IDs that contain the
Q13: In the formula =B2=C2, the second equal
Q29: Input<br>A)Cell D7<br>B)Cell D16<br>C)Cells C12:D16<br>D)Cell A7<br>E)Cells D5:D8
Q46: To split an Excel window vertically, click
Q58: A range can be used in a
Q64: 25<br>A)=ROUND(25.449,0)<br>B)=ROUND(SUM(10.33,10.44),0)<br>C)=ROUND(25.33%,2)<br>D)=INT(-4.3)<br>E)=ROUND(103234,-2)<br>F)=ROUND(23.75%,2)<br>G)=ROUNDDOWN(9.99,0)<br>H)=EVEN(2.23)
Q77: With _, you can specify your own
Q84: The INDEX function argument _ refers to
Q113: The _ function returns a random value
Q148: The formula =_(3.432,1) rounds the value 3.432