[Solved] Answer of =YEAR(“15-Aug-20”) will be

McqMate

1.7k

Do you find this helpful?

View all MCQs in

Discussion

What other functions can be used in conjunction with YEAR() to retrieve specific date information?

15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____
15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________
15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________
Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________
Answer of =TIMEVALUE(“6:00 PM”) will be ________
Answer of =DAYS360(“31-Dec-2020”, “1-Jan-2020”) will be ________
Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?
Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(“A2”)?
Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?
What will be the answer of =DAYS360(“1-Feb-2020”, “1-Mar-2020”)?