Your Boss in the Human Resources Department Asks You to Write

question 51

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.
-On a lark,for a year-end trivia contest,your boss wants you to calculate the length of service in complete days.What is the correct formula?

• A)=DATEDIF(C2, $AE$2, "today")
• B)=DATEDIF($AE$2, C2, "dy")
• C)=DATEDIF($AE$2, C2, "day")
• D)=DATEDIF(C2, $AE$2, "d")

---

Definitions:

Medicare Patients

Individuals who receive healthcare benefits under Medicare, a federal program providing health insurance to people over 65 and some younger individuals with disabilities.

Clinic

A healthcare facility that is primarily focused on the care of outpatients, offering services such as diagnosis, treatment, and patient consultation.

Public Service Announcement

A public service announcement (PSA) is a message broadcasted to the public to inform about and promote awareness on important social, health, or safety issues.

Smokey the Bear

An advertising mascot created to educate the public about the dangers of forest fires and promote forest fire prevention in the United States.