If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1) ?
A) mumbai
B) mumbai.
C) b1
D) b
Correct Answer:
Verified
Q2: What will be the answer of =DATEVALUE("1-Feb-1900")?
A)1
B)32
C)30
D)one
Q3: What will be the answer of =TIMEVALUE("12:00
Q4: What will be the answer of =MONTH(32)?
A)2
B)3
C)8
D)9
Q5: What will be the answer of =DAY(32)?
A)1
B)2
C)3
D)4
Q6: What will be the answer of =YEAR(32)?
A)1932
B)2032
C)1990
D)1900
Q8: What will be the answer of =PROPER("verus
Q9: What will be the answer of =MID("COMMERCE",3,2)?
A)omm
B)mme
C)mm
D)er
Q10: Excel formula cannot start with _
A)+
B)-
C)*
D)=
Q11: If cell A1 contains a number 100,
Q12: When we want to hide the records
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