Matching
Match each of the following functions to its return:
Premises:
DAY
YEARFRAC
DAYS
YEAR
MONTH
Responses:
Returns the day of the month for a date value
Calculates the number of days between two dates
Returns the year for a date value
Returns the percentage of a year past between two dates
Returns the month number of a date value
Correct Answer:
Premises:
Responses:
DAY
YEARFRAC
DAYS
YEAR
MONTH
Premises:
DAY
YEARFRAC
DAYS
YEAR
MONTH
Responses:
Related Questions
Q9: The advanced filter tool can _.<br>A)delete duplicate
Q10: Which function returns a value at the
Q11: The real functionality of MATCH and INDEX
Q12: A(n)_ is a schedule that calculates the
Q13: The _ function calculates the total number
Q15: NPER calculates the periodic interest rate of
Q16: Which function calculates the Reduction in C2
Q17: Why would you nest MATCH in an
Q18: A(n)_ is a schedule that calculates the
Q19: The criteria range must contain _ at