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:

Fair Value

Fair value is the estimated price at which an asset or liability could be exchanged between knowledgeable, willing parties in an arm's length transaction.

Contingent Consideration

Future payment obligations in a business combination or other arrangements that depend on specific outcomes or achievements.

Goodwill

The intangible asset that arises when a company acquires another company for a price higher than the fair value of its net identifiable assets.

Share Issue Costs

The expenses associated with issuing new shares of stock, including legal, accounting, and underwriting fees.