MS EXCEL MCQ Multiple Choice Questions Answers - Page 3 | Quiz for Practice
MS EXCEL MCQ Questions for Practice
61. In Excel ……………………………….may not contain in Formula
Correct Answer is: All of the above
62. Clear the contents by pressing “DELETE” key from a keyboard will clear
Correct Answer is: Both Contents and Format
63. You can group noncontiguous worksheets with
Correct Answer is: The group button on the standard toolbar
64. A smart tag will be removed from a cell when
Correct Answer is: None of the above
65. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Correct Answer is: the Settings tab under the menu Format -> Conditional Formatting
66. The Cancel and Enter buttons appear in the:
Correct Answer is: Sheet tabs
67. In Excel, the Fill Color button on the Formatting toolbar is used for what?
Correct Answer is: To select a distribution of figures.
68. What is entered by the function =today()
Correct Answer is: None of the above
69. A…………………….is a grid with labeled columns and rows.
Correct Answer is: Clipboard
70. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Correct Answer is: None of the above
71. The default header for a worksheet is
Correct Answer is: Sheet tab Name
72. To create a formula, you can use:
Correct Answer is: None of the above
73. In order to perform a calculation in a spreadsheet, you need to use a:
Correct Answer is: None of the above
74. Which language is used to create macros in Excel?
Correct Answer is: Java
75. MS-EXCEL is based on
Correct Answer is: OS/2
76. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:
Correct Answer is: graphics
77. Microsoft Excel is a powerful
Correct Answer is: DBMS package
78. MS Excel is a
Correct Answer is: None of the above
79. An Excel Workbook is a collection of
Correct Answer is: Charts
80. We can save and protect the workbook by
Correct Answer is: Protection Password
81. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
Correct Answer is: Column Chart
82. How many sheets are there, by default, when we create a new Excel file ?
Correct Answer is: 10
83. How many worksheets can a workbook have?
Correct Answer is: 255
84. What value will display if the formula = “$55.00″+5 is entered into a cell?
Correct Answer is: $60.00
85. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
Correct Answer is: 6.8
86. The cell reference for cell range of G2 to M12 is
Correct Answer is: G2-M12
87. Formulas in Excel start with
Correct Answer is: +
88. In the formula, which symbol specifies the fixed columns or rows ?
Correct Answer is: All of the above
89. What is the symbol for multiplying?
Correct Answer is: !
90. How to specify cell range from A9 to A99 in Excel?
