Case-Based Critical Thinking Questions

question 25

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.
-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 ____.

• A) =COUNTIF(E3:E13,"<>1")
• B) =COUNTIF(E3:E13,"=1")
• C) =COUNTIF(E3:E13,">=1")
• D) =COUNTIF(E3:E13,"<1")

---

Definitions:

Annual Dividends

The total amount of dividend payments a company distributes to its shareholders over a year.

Annual Dividend

The total amount of dividend payments distributed to shareholders over a single fiscal year, usually expressed per share.

Rate of Return

An investment's profit or loss accrued over a particular time frame, calculated as a percentage of the cost at which the investment was acquired.

Dividend Increase

An action taken by a company to raise the amount of money paid to shareholders in dividends, signaling potential financial health and profitability.