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 one service recognition program, you need to calculate the length of service in complete months. What is the correct formula?
A. =DATEDIF(C2, $AE$2, "m")
B. =DATEDIF($AE$2, C2, "month")
C. =DATEDIF($AE$2, C2, "mth")
D. =DATEDIF(C2, $AE$2, "mon")
Answer: A
Computer Science & Information Technology
You might also like to view...
The chief advantage of web-based applications is:
a. Client-side software updates are unnecessary b. Built-in SSL encryption c. Ease of use d. Better security
Computer Science & Information Technology
In a report, a list is typically indented 0.5 inch on the left, and a hanging indent of ________ is set for the first line
A) 0.25 inch B) 0.5 inch C) 0.75 inch D) 1 inch
Computer Science & Information Technology
Which of the following is true about public cloud computing
a. It is expensive. b. Itis less secure. c. It is relatively slow. d. It is less agile.
Computer Science & Information Technology
It is possible to hide color samplers.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology