MS EXCEL MCQ Questions and Answers Quiz

111. What is the correct way to refer the cell A10 on sheet3 from sheet1?

  1. sheet1!A10
  2. Sheet3.A10
  3. A10
  4. 1

112. The Software which contains rows and columns is called…………………………………….

  1. Word processing
  2. Database
  3. None of the above
  4. 1

113. It is a collection of data that is stored electronically as a series of records in a table.

  1. presentation
  2. database
  3. MS Word
  4. 3

114. Which area in an Excel window allows entering values and formulas ?

  1. Title Bar
  2. Formula Bar
  3. None of the above
  4. 3

115. Excel displays the current cell address in the ....

  1. Name Box
  2. Formula bar
  3. None of the above
  4. 2

116. Which one is not a Function in MS Excel ?

  1. AVG
  2. MAX
  3. MIN
  4. 2

117. Hyperlinks can be

  1. Drawing
  2. Picture
  3. All of the above
  4. 4

118. In Excel ……………………………….may not contain in Formula

  1. Number Constant
  2. Circular Reference
  3. All of the above
  4. 3

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

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

120. You can group noncontiguous worksheets with

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

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer