Your Boss in the Human Resources Department Asks You to Write

question 98

Multiple Choice

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:

Psychosexual Development

Freud's theory on the stages of psychological development from infancy to adulthood, focusing on how early life sexual urges shape personality.

Oral Trait

A characteristic of personality development associated with the oral stage of psychosexual development, focusing on behaviors related to the mouth such as dependency, eating, and verbal communication.

Perfectionism

A personality trait characterized by a person's striving for flawlessness and setting excessively high performance standards, accompanied by critical self-evaluations and concerns regarding others' evaluations.

Heritability

The degree to which the variations in a trait from one person to another can be attributed to, or explained by, genetic factors.