Matching
Match each of the following functions to its return:
Premises:
YEAR
DAYS
MONTH
DAY
YEARFRAC
Responses:
Returns the day of the month for a date value
Returns the year for a date value
Returns the month number of a date value
Returns the percentage of a year past between two dates
Calculates the number of days between two dates
Correct Answer:
Premises:
Responses:
YEAR
DAYS
MONTH
DAY
YEARFRAC
Premises:
YEAR
DAYS
MONTH
DAY
YEARFRAC
Responses:
Related Questions
Q5: If 9/3/2021 is the contents of B3,
Q6: A(n)_is a matrix that provides the results
Q8: Match each of the following functions its
Q14: Which function calculates the Reduction in C2
Q34: The YEARFRAC function returns the number of
Q42: When formated as a date, the results
Q44: A NOT function reverses the truth of
Q54: The EOMONTH function returns the last day
Q58: You can nest AND, OR and NOT
Q62: The _ function returns the position of