MS EXCEL Multiple Choice Questions and Answers

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