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 a separate service recognition program, you need to calculate the length of service in complete years. What is the correct formula?
A. =DATEDIF(C2, $AE$2, "yr")
B. =DATEDIF($AE$2, C2, "year")
C. =DATEDIF($AE$2, C2, "yr")
D. =DATEDIF(C2, $AE$2, "y")
Answer: D
Computer Science & Information Technology
You might also like to view...
You can establish connections to the external data so that you can automatically ________ your Excel workbook from the original data
Fill in the blank(s) with correct word
Computer Science & Information Technology
Which of the following adapter cards connects to musical instruments?
A. MIDI B. modem C. sound D. tuner
Computer Science & Information Technology