Please briefly describe the DATE and NOW functions, including how the formula is written, any arguments involved, and a situation of when you would use that function: DATE and NOW.

What will be an ideal response?


- The DATE function:
How it is written: DATE(year,month,day):  The date specified in the year, month, and day arguments, which are entered as numbers.
When I would use it (Answers will vary): I would use the DATE function when I am filling in birthday data for employees.


- The NOW function:
How it is written: The NOW( ):  The current date and time based on the computer's date and time settings. This function has no arguments.
When I would use it (Answers will vary): I would use the NOW function when I always wanted an updated date and time on my worksheet.

Computer Science & Information Technology

You might also like to view...

A form’s ____ is the underlying object that provides the fields and data in the form.

A. data source B. view object C. base object D. record source

Computer Science & Information Technology

How many times should text be clicked in order to select all of the text in a text box?

A. three B. four C. five D. none of the above

Computer Science & Information Technology

Windows 8 will allow up to ________ characters in a file name

Fill in the blank(s) with correct word

Computer Science & Information Technology

As you develop your animation, the number of frames can grow very rapidly, as well as the number of layers.

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

Computer Science & Information Technology