MS EXCEL MCQ Questions and Answers Quiz

121. A smart tag will be removed from a cell when

  1. the cell is hidden
  2. the data in the cell is changed or deleted
  3. None of the above
  4. 3

122. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

  1. The Settings tab under the menu Data -> Validation
  2. The Settings tab under the menu Data -> Filter -> Advanced Filter
  3. the Settings tab under the menu Format -> Conditional Formatting
  4. 2

123. The Cancel and Enter buttons appear in the:

  1. Formula bar
  2. Menu bar
  3. Sheet tabs
  4. 2

124. In Excel, the Fill Color button on the Formatting toolbar is used for what?

  1. To add borders.
  2. To select a distribution of figures.
  3. To add shading or color to a cell range.
  4. 4

125. What is entered by the function =today()

  1. The time value according to system clock
  2. The date value for the day according to system clock
  3. None of the above
  4. 3

126. A ……………………………….is a grid with labeled columns and rows.

  1. Formula bar
  2. Clipboard
  3. Worksheet
  4. 4

127. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

  1. Apply Conditional Formatting command on Home Tab
  2. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  3. None of the above
  4. 2

128. The default header for a worksheet is

  1. Date and Time
  2. Sheet tab Name
  3. None
  4. 4

129. To create a formula, you can use:

  1. Values but not cell references
  2. Cell references but not values
  3. None of the above
  4. 1

130. In order to perform a calculation in a spreadsheet, you need to use a:

  1. formula
  2. table
  3. None of the above
  4. 3
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer