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

question 37

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 a separate service recognition program, you need to calculate the length of service in complete years. What is the correct formula?

• A)=DATEDIF(C2, $AE$2, "yr")
• B)=DATEDIF($AE$2, C2, "year")
• C)=DATEDIF($AE$2, C2, "yr")
• D)=DATEDIF(C2, $AE$2, "y")

---

Definitions:

Intimacy Level

The degree of closeness and emotional bond shared between individuals, often reflecting the depth of a personal relationship.

Sexual Tension

Describes the psychological and physical anticipation and excitement between two people who are attracted to each other but have not expressed it.

Consummate Love

A term from Sternberg's Triangular Theory of Love that describes a complete form of love consisting of intimacy, passion, and commitment.

Companionate

Refers to a type of love characterized by deep affection and long-term commitment, often seen in long-standing romantic relationships without the intensity of passionate love.