[Solved] Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?

Q.	Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?
A.	a2
B.	a
C.	co
D.	c
Answer» D. c

View all MCQs in

Discussion

No comments yet

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)?
If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?
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 =YEAR(“15-Aug-20”) will be
Answer of =TIMEVALUE(“6:00 PM”) will be ________