Multiple Choice
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")
Correct Answer:
Verified
Correct Answer:
Verified
Q37: Case-Based Critical Thinking Questions Case 8-2 Your
Q43: The _ function is used to change
Q49: You could test two or more conditions
Q50: You can use a _ function to
Q54: Each time you create a conditional format
Q63: When using VLOOKUP,the _argument is optional.<br>A)lookup_value<br>B)table_array<br>C)range_lookup<br>D)col_index
Q66: In most cases,when manually creating a
Q81: The _ function is a logical function
Q81: If you need to modify the formula
Q133: In a fully qualified structured reference the