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...

What is missing in the following data structure for the heap ADT?typedef struct{   void** heapAry;   int last;   int size;   int maxSize;} HEAP;

A. A data structure for the nodes. B. The position of the first element (int first;) C. A pointer to the equals function. D. A pointer to the compare function.

Computer Science & Information Technology

Which of the following is the general syntax of the function prototype to overload the pre-increment operator as a nonmember function?

A. className operator++(); B. friend className operator++(); C. className operator++(int); D. friend className operator++(className&);

Computer Science & Information Technology

A newspaper advertisement offers a $3,000 used car for nothing down and 36 easy monthly payments of $141.32. What is the total amount paid for the car, and what is the total finance charge? Round your answers to the nearest cent.The total amount paid for the car is $__________.The total finance charge is $__________.

What will be an ideal response?

Computer Science & Information Technology

An end-user license agreement is a legal contract between a vendor and a user that governs the use of a software package or information service.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology