Case-Based Critical Thinking Questions Case 8-2 Your Boss in the Human

question 40

Multiple Choice

Case-Based Critical Thinking Questions Case 8-2 Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service. For one service recognition program, you need to calculate the length of service in complete months. What is the correct formula?

• A)=DATEDIF(C2, $AE$2, "m")
• B)=DATEDIF($AE$2, C2, "month")
• C)=DATEDIF($AE$2, C2, "mth")
• D)=DATEDIF(C2, $AE$2, "mon")

---

Definitions:

Groupthink

A psychological phenomenon in which the desire for harmony or conformity within a group leads to an irrational or dysfunctional decision-making outcome.

Diffusion of Responsibility

A phenomenon where individuals in a group are less likely to take action or feel accountable for actions because the responsibility is seen as being distributed among all members of the group.

Riskier Decisions

Choices or actions taken that involve a higher level of uncertainty and potential for negative outcomes compared to alternative options.

Group Members

Individuals who belong to a specific group or team, sharing common goals, tasks, or interests.