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

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