[Solved] If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?

Q.	If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
A.	mumbai
B.	mumbai
C.	b1
D.	b
Answer» B. mumbai

2.2k

Do you find this helpful?

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”)?
Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?
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 ________