MS EXCEL MCQ Multiple Choice Questions Answers - Page 3 for Practice
61. In Excel ……………………………….may not contain in Formula
Correct Answer is: Circular Reference
62. Clear the contents by pressing “DELETE” key from a keyboard will clear
Correct Answer is: Contents Only
63. You can group noncontiguous worksheets with
Correct Answer is: The ctrl key and mouse
64. A smart tag will be removed from a cell when
Correct Answer is: the data in the cell is changed or deleted
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 Data -> Validation
66. The Cancel and Enter buttons appear in the:
Correct Answer is: Formula bar
67. In Excel, the Fill Color button on the Formatting toolbar is used for what?
Correct Answer is: To add shading or color to a cell range.
68. What is entered by the function =today()
Correct Answer is: The date value for the day according to system clock
69. A…………………….is a grid with labeled columns and rows.
Correct Answer is: Worksheet
70. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Correct Answer is: Apply Conditional Formatting command on Home Tab
71. The default header for a worksheet is
Correct Answer is: None
72. To create a formula, you can use:
Correct Answer is: Value and cell references
73. In order to perform a calculation in a spreadsheet, you need to use a:
Correct Answer is: table
74. Which language is used to create macros in Excel?
Correct Answer is: Visual Basic
75. MS-EXCEL is based on
Correct Answer is: WINDOWS
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: spreadsheet
77. Microsoft Excel is a powerful
Correct Answer is: Spreadsheet package
78. MS Excel is a
Correct Answer is: Spreadsheet Program
79. An Excel Workbook is a collection of
Correct Answer is: Both (A) and (B)
80. We can save and protect the workbook by
Correct Answer is: Any of the above
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: Pie Chart
82. How many sheets are there, by default, when we create a new Excel file ?
Correct Answer is: 3
83. How many worksheets can a workbook have?
Correct Answer is: none of above
84. What value will display if the formula = “$55.00″+5 is entered into a cell?
Correct Answer is: 60
85. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?
Correct Answer is: 5436.80
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: $
89. What is the symbol for multiplying?
Correct Answer is: *
90. How to specify cell range from A9 to A99 in Excel?
