50+ MCQ’s On MS-Excel | Computer Systems and Applications

by Admin · April 8, 2022

31. What will be the answer of =MONTH(32)?
(a) 2
(b) 3
(c) 8
(d) 9

32. What will be the answer of =DAY(32)?
(a) 1
(b) 2
(c) 3
(d) 4

33. What will be the answer of =YEAR(32)?
(a) 1932
(b) 2032
(c) 1990
(d) 1900

34. If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
(a) Mumbai
(b) mumbai
(c) b1
(d) b

35. What will be the answer of =PROPER(“verus d’sa”)?
(a) Verus d’sa
(b) Verus D’sa
(c) Verus D’Sa
(d) VERUS D’SA

36. What will be the answer of =MID(“COMMERCE”,3,2)?
(a) OMM
(b) MME
(c) MM
(d) ER

37. Excel formula cannot start with ____
(a) +
(b) –
(c) *
(d) =

38. Which of the following is an invalid arithmetic operator?
(a) +
(b) –
(c) 
(d) ^

39. Which of the following is an invalid comparison operator?
(a) >
(b) <
(c) <>
(d) 

40. If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?
(a) 90
(b) 110
(c) 190
(d) 210

Answers: 31-a, 32-a, 33-d, 34-b, 35-c, 36-c, 37-c, 38-c, 39-d, 40-b