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.
-On a separate project, the head of Human Resources is looking for a list of people who do not have 100% attendance. In the database, the number 1 means 100% attendance; all other numbers indicate that some work was missed (for example, .75 is 75% attendance) . The data is listed in column E of a worksheet. The correct COUNTIF formula would be ____.
Definitions:
Economic Centers
Key urban or regional areas that serve as hubs of financial and commercial activity, influencing local and global economies.
French Immigrants
Individuals from France who relocate to another country.
Survival Chance
A term referring to the likelihood or probability of an individual or entity to continue existence or operation in the face of adverse conditions.
French Monarchy
The historical system of government in France, headed by kings and queens, which was abolished during the French Revolution and briefly restored before the establishment of the French Republic.
Q57: In business, charts are typically used to
Q62: Violet is not sure if the Sales
Q63: The _ function counts the number of
Q80: No answer<br>A)######<br>B)#N/A<br>C)#VALUE!<br>D)#DIV/0!<br>E)#NAME?<br>F)#REF!<br>G)#NUM!<br>
Q111: With the INDEX function, if you specify
Q122: When using the CHOOSE function, if the
Q136: Relational operators can be used to evaluate
Q142: A lookup table in which the data
Q144: Performing a _ analysis means, simply, to
Q147: Which chart does a better job of