MS EXCEL MCQ Questions and Answers Quiz

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
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....