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

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