Multiple Choice
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")
Correct Answer:
Verified
Correct Answer:
Verified
Q25: When you want to reference an entire
Q47: With the DATEDIF function,the _ interval code
Q48: You have been using a variety of
Q49: MATCHING<br>Identify the letter of the choice that
Q50: You can use a _ function to
Q52: A(n)_ match lookup occurs when the lookup
Q54: The Conditional Formatting button provides access to
Q55: MATCHING<br>Identify the letter of the choice that
Q96: The _ function searches vertically down a
Q110: _ formatting changes a cell's formatting when