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.
-Julia wants to take a count of all employees who are participating in exactly one committee. The correct formula would be ____.
Definitions:
Architect
A professional who designs buildings and in many cases also supervises their construction.
Multiple Intelligences
A theory by Howard Gardner suggesting individuals possess various forms of intelligence, including linguistic, logical-mathematical, musical, spatial, bodily-kinesthetic, interpersonal, intrapersonal, and naturalistic.
Spatial Intelligence
The cognitive ability to visualize and manipulate objects and their spatial relations in the mind, important for solving spatial problems and navigating environments.
IQ Score
A measure of a person's intellectual abilities in relation to an average score for a large population, usually determined by an intelligence test.
Q2: Assuming that cell D4 contains the date
Q31: You can only use a LOOKUP function
Q37: To create a forward forecast in Excel,
Q47: The _ function looks up the greatest
Q69: _ are symbols that you can use
Q102: Excel formulas can contain _.<br>A) constants<br>B) cell
Q129: To specify that a value should be
Q131: The rules programmed into the function are
Q142: #3<br>A)Data series<br>B)Chart title<br>C)Data table<br>D)X-axis labels<br>E)X-axis<br>F)Legend<br>G)Y-axis<br>H)Y-axis labels<br>I)Gridlines<br>J)Data point
Q145: B3:B7 represents _.<br>A) noncontiguous cells and/or constants<br>B)