MS EXCEL MCQ Questions and Answers Quiz

121. Clear the contents by pressing “DELETE” key from a keyboard will clear

  1. Text Only
  2. Format Only
  3. Contents Only
  4. Both Contents and Format

122. You can group noncontiguous worksheets with

  1. The alt+enter key
  2. The ctrl key and mouse
  3. The shift key and the mouse
  4. The group button on the standard toolbar

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

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

124. 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 Format -> Cells
  2. The Settings tab under the menu Data -> Validation
  3. The Settings tab under the menu Data -> Filter -> Advanced Filter
  4. the Settings tab under the menu Format -> Conditional Formatting

125. The Cancel and Enter buttons appear in the:

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

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

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

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

  1. Today’s date as Text format
  2. The time value according to system clock
  3. The date value for the day according to system clock
  4. None of the above

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

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

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

  1. Use =if() function to format the required numbers red
  2. Apply Conditional Formatting command on Home Tab
  3. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  4. None of the above

130. The default header for a worksheet is

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

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF

MS EXCEL Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....