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...
In order to connect your network to the Internet, you need to get an Internet connection from a(n) ________
Fill in the blank(s) with correct word
Computer Science & Information Technology
?Normally, user accounts operate in ____ user mode.
A. ?basic B. ?normal C. ?standard D. ?administrative
Computer Science & Information Technology
What components make up an object's distinguished name (DN)?
What will be an ideal response?
Computer Science & Information Technology
A 16?bit CPU has a cache with 32 lines, each of 16 bytes. The CPU accesses a byte at the decimal address 3210. This results in a miss and a line is loaded. Where is the line loaded in the cache?
What will be an ideal response?
Computer Science & Information Technology