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

question 62

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

Nuclear Membranes

The double-layered membrane surrounding a cell's nucleus, controlling the passage of substances in and out of the nucleus.

Cytoplasm

The jelly-like substance within a cell, excluding the nucleus, that contains organelles and is the site of most cellular processes.

Food And Drug Administration

A federal agency of the United States responsible for regulating and supervising the safety of foods, dietary supplements, drugs, cosmetics, and medical devices.

Positively Charged Particle

An atom or molecule with more protons than electrons, giving it a net positive charge.