Case-Based Critical Thinking Questions

question 44

Multiple Choice

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 more than one committee. The data is listed in column F of a worksheet. The correct formula would be ____.

• A) =COUNTIF(F3:F13,"<1")
• B) =COUNTIF(F3:F13,">1")
• C) =COUNTIF(F3:F13,">=1")
• D) =COUNTIF(F3:F13,"=1")

---

Definitions:

Pension Funds

Financial programs that accumulate resources during an employee's working years and pay out retirement benefits upon reaching retirement age.

Short-term Securities

Financial instruments, such as bonds or Treasury bills, that mature or are redeemable within a short period, typically less than one year.

Long-term Securities

Financial instruments that have a maturity period exceeding one year and include bonds, debentures, and other investment vehicles.

Credit Union

A member-owned financial cooperative that provides traditional banking services.