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:
Q23: The _ symbol(s) insert(s) a comma as
Q37: AND(A1,NOT(OR(A1:A4)))<br>A)#1<br>B)#2<br>C)#3<br>D)#4<br>E)#5<br>F)#6<br>G)#7<br>H)#8
Q44: The function =_(index_num,value1,value2,…) can return up to
Q61: The Description options on the Chart Elements
Q62: The syntax of the NOT function evaluates
Q73: Text labels<br>A)Cell D7<br>B)Cell D16<br>C)Cells C12:D16<br>D)Cell A7<br>E)Cells D5:D8
Q89: Peter has updated the production and cost
Q104: The function inputs are referred to as
Q114: What formula would you write to find
Q121: If 5% is displayed in a cell,