MS EXCEL MCQ Multiple Choice Questions Answers - Page 5 for Practice
121. Clear the contents by pressing “DELETE” key from a keyboard will clear
Correct Answer is: Contents Only
122. You can group noncontiguous worksheets with
Correct Answer is: The ctrl key and mouse
123. A smart tag will be removed from a cell when
Correct Answer is: the data in the cell is changed or deleted
124. 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
125. The Cancel and Enter buttons appear in the:
Correct Answer is: Formula bar
126. 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.
127. What is entered by the function =today()
Correct Answer is: The date value for the day according to system clock
128. A…………………….is a grid with labeled columns and rows.
Correct Answer is: Worksheet
129. 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
130. The default header for a worksheet is
Correct Answer is: None
131. To create a formula, you can use:
Correct Answer is: Value and cell references
132. In order to perform a calculation in a spreadsheet, you need to use a:
Correct Answer is: table
133. Which language is used to create macros in Excel?
Correct Answer is: Visual Basic
134. MS-EXCEL is based on
Correct Answer is: WINDOWS
135. 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
136. Microsoft Excel is a powerful
Correct Answer is: Spreadsheet package
137. MS Excel is a
Correct Answer is: Spreadsheet Program
138. An Excel Workbook is a collection of
Correct Answer is: Both (A) and (B)
139. We can save and protect the workbook by
Correct Answer is: Any of the above
140. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
