If you need to find out how many days between two dates, which function would you use?
A) DAY
B) DAYS
C) DAYSBETWEEN
D) EDATE
Correct Answer:
Verified
Q5: Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?
A)MAX(B2:B5)
B)MATCH(MAX(B2:B5),B2:B5,0)
C)1
D)A2:B5
Q6: The YEARFRAC calculates _.
A)the year 2018 from
Q7: Why would you nest MATCH in an
Q8: IF you use the function, =MATCH(66, A1:A4,0),
Q9: If 9/3/2021 is the contents of B3,
Q11: Which function returns a value at the
Q12: What type of match would the following
Q13: Which function returns the relative position of
Q14: When formated as a date, the results
Q15: If you need to find the day
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents