Your Boss in the Human Resources Department Asks You to Write

question 8

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 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:

Affective Forecasting

The process by which individuals predict their future emotional states or how they will feel in response to future events.

Ego Depletion

The theory that self-control or willpower draws upon a limited pool of mental resources that can be used up.

Physical Arousal

Pertains to the physiological responses of the body that prepare an individual for action, often associated with emotions, exercise, or sexual interest.

Ironic Processing

The psychological process where attempts to suppress certain thoughts make them more likely to surface.