Match the date/time function syntax to their descriptions:
I. =EOMONTH(start_date,months) A. Identifies the last day of the
month, a specified number of
months from a serial number
representing a date
II. =MONTH(serial_number) B. Returns the month (1 to 12 ) for
a serial number
III. =NETWORKDAYS
(start_date,end_date,[holidays]) C. Calculates a serial number of a
date
IV. =WEEKDAY(serial_number,return_type) D. Calculates the number of
workdays excluding weekends
and specified holidays) between
two dates
V. =WORKDAY(start_date,days,[holidays]) E. Identifies the weekday (1-7 ) for
a serial number
A, B, D, E, C
You might also like to view...
The icon used on the Sum function button is the Greek letter ________
A) sigma (?) B) Omega (?) C) Lambda (?) D) Phi (?)
An understanding of the business needs is required in order to determine what related tables need to be constructed
Indicate whether the statement is true or false