You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations.
Your spreadsheet contains a list of dates and you need to determine the intervals between the dates in the list. Which set of functions should you use to determine how many days have passed?

What will be an ideal response?


You should use the Date & Time functions in Excel to determine the difference, in days, between two dates.

Computer Science & Information Technology

You might also like to view...

The precondition(s) for a function describe:

a. What is true after the function is executed b. What the function does c. How to call the function d. What must be true before the function executes

Computer Science & Information Technology

What are the two ingredients for dynamic programming?

a. Optimal substructure and overlapping subproblems b. Optimal substructure and recursion c. Overlapping sub-problems and recursion d. Memoization and recursion

Computer Science & Information Technology

The class implementing the properties of a B-tree must, among others, implement the search, traversal, insertion, and deletion algorithms.

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

Computer Science & Information Technology

A technician needs to install an OS patch on a virtual server. Which of the following backup types should the technician perform prior to the patch installation that will allow the server to be restored the FASTEST?

A. Snapshot B. Incremental C. Differential D. Full

Computer Science & Information Technology