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")
Answer: D
Computer Science & Information Technology
You might also like to view...
A(n) ________ chart groups selected data by rows so that the columns that represent each value in the row are side by side
Fill in the blank(s) with correct word
Computer Science & Information Technology
What problems are likely to arise if formalized program inspections are introduced in a company where some software is developed using agile methods.
What will be an ideal response?
Computer Science & Information Technology