MCQ

Top 100 MS-Excel MCQ

81. The first cell is Excel worksheet is labeled as ……

a) AA
b) A1
c) Aa
d) A0

Answer – [B]


82. What is the shortcut key to show or hide Ribbon in MS-Excel?

a) Shift + F1
b) Ctrl + F1
c) Shift + F2
d) Ctrl + F3

Answer – [B]


83. How many sheets are there in Excel workbook by default?

a) 1
b) 2
c) 3
d) 4

Answer – [C]


84. Which chart can be created in Excel?

a) Pie Chart
b) Line Chart
c) Area Chart
d) All of these

Answer – [D]


85. Which key is used to make multiple line in a single cell?

a) Alt + Enter
b) Tab + Enter
c) Ctrl + Enter
d) Shift + Enter

Answer – [A]


86. Minimum zoom size in MS-Excel is ………

a) 5%
b) 10%
c) 20%
d) 30%

Answer – [B]


87. Maximum zoom size in MS-Excel is …….

a) 50%
b) 100%
c) 200%
d) 400%

Answer – [D]


88. Default font size in Excel is ……..

a) 11p (point)
b) 12p (point)
c) 14p (point)
d) 15p (point)

Answer – [A]


89. Where we find the WordArt option in MS-Excel 2010?

a) Insert Tab
b) Home Tab
c) Page Layout Tab
d) Data Tab

Answer – [A]


90. In MS-Excel …………. shortcut key is used for hiding rows.

a) Ctrl + H
b) Ctrl + 7
c) Ctrl + 9
d) None of the above

Answer – [C]