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:

Frictional Unemployment

A type of unemployment that occurs when individuals are temporarily unemployed while moving between jobs, entering the workforce for the first time, or re-entering the workforce.

Discouraged Workers

Individuals not actively seeking employment due to believing no jobs are available for them or they would not qualify for the jobs that are available.

Full Employment

A situation in an economy where all available labor resources are being used in the most efficient way possible, typically associated with low unemployment rates.

Inflation

The tempo at which the collective cost of goods and services rises, impairing the purchasing potential.