50+ MCQ’s On MS-Excel | Computer Systems and Applications
MCQ’s On MS-Excel
1. 15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____
(a) Saturday
(b) Sat
(c) 7
(d) 6
2. 15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________
(a) August
(b) Aug
(c) 8
(d) 7
3. 15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________
(a) 2020
(b)1920
(c) 20
(d) 2200
4. Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________
(a) 365
(b) 366
(c) 360
(d) 364
5. Answer of =YEAR(“15-Aug-20”) will be
(a) 20
(b) 2020
(c) 1920
(d) 2200
6. Answer of =TIMEVALUE(“6:00 PM”) will be ________
(a) 6:00
(b) 6:00 AM
(c) 18:00
(d) 0.75
7. TODAY( ) returns current ______
(a) Date
(b) Time
(c) Day
(d) Date & Time
8. Answer of =DAYS360(“31-Dec-2020”, “1-Jan-2020”) will be ________
(a) 365
(b) 366
(c) 360
(d) -360
9. To extract 3 characters starting from 2nd character of a string “EXCEL” we use _______
(a) =MID(“EXCEL”,3,2)
(b) =MID(“EXCEL”,2,3)
(c) =MID(“EXCEL”,2,5)
(d) =MID(“EXCEL”,5,2)
10. To convert uppercase alphabets to lowercase we use _____
(a) LCASE( )
(b) LOWER( )
(c) UPPER( )
(d) UCASE( )
| Answers: 1-c, 2-c, 3-a, 4-c, 5-b, 6-d, 7-a, 8-d, 9-b, 10-b |
11. To find number of characters in a string we use _____
(a) COUNT( )
(b) LEN( )
(c) LENGTH( )
(d) SUM( )
12. To search a value in the leftmost column of a given range, we use _______
(a) VLOOKUP( )
(b) HLOOKUP( )
(c) SEARCH( )
(d) LOCATE( )
13. To search a value in the first row of a given range, we use _______.
(a)VLLOKUP( )
(b) HLOOKUP( )
(c) SEARCH( )
(d) LOCATE( )
14. To count non blank cells, we use _____.
(a) COUNT( )
(b) COUNTA( )
(c) COUNTBLANK( )
(d) COUNTNONBLANK( )
15. To count number of cells that contains numbers, we use _____.
(a) COUNT( )
(b) COUNTA( )
(c) SUM( )
(d) COUNTIF( )
16. Which of the following is not a valid chart type in Excel.
(a) Line
(b) Bar
(c) Pie
(d) Graph
17. Axis Title is not allowed in this type of graphs.
(a) Line
(b) Bar
(c) Column
(d) Pie
18. Select odd man out from the following graph types.
(a) Line
(b) Bar
(c) Column
(d) Pie
19. Charts are available under _______ Ribbon/Menu.
(a) Home
(b) Insert
(c) Data
(d) View
20. Goal Seek Option is available under ____ Ribbon/Menu.
(a) Home
(b) Insert
(c) Data
(d) View
| Answers: 11-b, 12-a, 13-b, 14-b, 15-a, 16-d, 17-d, 18-d, 19-b, 20-c |
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 |
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 |
41. When we want to hide the records which are not satisfying a given condition, then we use________ command.
(a) Sort
(b) Filter
(c) Goal Seek
(d) Solver
42. We can add constraints while using __________ command.
(a) Goal Seek
(b) Solver
(c) Scenario Manager
(d) Data Table
43. By default extension for template file is _______
(a) .temp
(b) .xltx
(c) .tem
(d). xlsx
44. Excel macros can be edited using _______ editor.
(a) Visual Basic
(b) Excel
(c) C
(d) Java
45. To make data interesting, attractive and easy to read and evaluate, we use ______
(a) Graphs
(b) Filter
(c) Scenario
(d) Solver
46. _____ graph allows only one range of values.
(a) Bar
(b) Line
(c) Column
(d) Pie
47. Gridlines are not allowed for ___ type of graphs.
(a) Bar
(b) Line
(c) Column
(d) Pie
48. With Numeric Filters ______ operation is not allowed.
(a) Top 10
(b) Above Average
(c) Greater Than
(d) Begins With
49. With Text Filters _____ operation is not allowed.
(a) Begins With
(b) Ends With
(c) Above Average
(d) Contains
50. Which of the following function is invalid.
(a) SUMIF( )
(b) AVGIF( )
(c) COUNTIF( )
(d) IF( )
| Answers: 41-b, 42-b, 43-b, 44-a, 45-a, 46-d, 47-d, 48-d, 49-c, 50-b |
