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

by Admin · April 8, 2022

21.Number of changing cells for a Scenario is limited to ____
(a) 16
(b) 32
(c) 1
(d) 2

22. Number of changing cells for a Goal Seek is limited to ______
(a) 16
(b) 32
(c) 1
(d) 2

23. Solver Option is available under ____ Ribbon/Menu.
(a) Developer
(b) Data
(c) Insert
(d) Home

24. Record Macro option is available under ____ Ribbon/Menu.
(a) Developer
(b) Data
(c) Insert
(d) Home

25. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?
(a) A2
(b) A
(c) CO
(d) C

26. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(“A2”)?
(a) A2
(b) A
(c) CO
(d) C

27. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?
(a) A2
(b) ER
(c) CO
(d) COM

28. What will be the answer of =DAYS360(“1-Feb-2020”, “1-Mar-2020”)?
(a) 28
(b) 29
(c) 30
(d) 31

29. What will be the answer of =DATEVALUE(“1-Feb-1900”)?
(a) 1
(b) 32
(c) 30
(d) One

30. What will be the answer of =TIMEVALUE(“12:00 PM”)?
(a) 12.00
(b) 12
(c) 0.5
(d) 0.25

Answers: 21-b, 22-c, 23-b, 24-a, 25-d, 26-b, 27-d, 28-c, 29-b, 30-c