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:

Service Quality

The degree to which a delivered service meets or exceeds the expectations of customers, often a key competitive advantage in business.

Tangibility

Refers to the physical existence of products or items that can be seen, touched, and felt.

Service Failures

Instances when customer expectations are not met by service delivery, often leading to dissatisfaction.

Controllable Factor

An element or variable in a business or process that can be modified or adjusted according to the needs of the manager or operator.