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

question 40

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

Lengthens

It refers to the process of extending in length or duration.

Peristalsis

Muscular waves in a series that assist in moving food throughout the digestive tract.

Smooth Muscle

A type of muscle tissue which is not under voluntary control, found in the walls of internal organs and blood vessels.

Skeletal Muscle

Muscle tissue that is attached to bones, primarily responsible for voluntary movements through contraction.