Case-Based Critical Thinking Questions

question 114

Multiple Choice

Case-Based Critical Thinking Questions
Case 7-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.
-Just 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:

Outliers

Values in a data set that are significantly higher or lower than the majority of the data, potentially indicating anomalies.

Skewness

A measure of the asymmetry of the probability distribution of a real-valued random variable about its mean.

Three Decimal Places

A numerical representation precise up to three digits to the right of the decimal point.

Three Decimal Places

A numerical precision or format in which a number is rounded or expressed to the third digit to the right of the decimal point.