MS EXCEL Multiple Choice Questions and Answers

111. Which of the following function will return a value of 8?

1. ROUNDUP(8.4999, 0)
2. ROUNDDOWN(8.4999, 0)
3. ROUND(8.4999, 0)
4. Only B and C

112. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use ?

1. Save
2. Save As
3. Both (A) and (B)
4. None of the above

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

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

114. The Software which contains rows and columns is called

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

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

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

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

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

117. Excel displays the current cell address in the

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

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

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

119. Hyperlinks can be

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

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

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