MS EXCEL Quiz Question with Answer

51. To return the remainder after a number is divided by a divisor in EXCEL we use the function ?

  1. ROUND()
  2. MOD ( )
  3. FACT ( )
  4. None of the above

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

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

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

55. The Software which contains rows and columns is called

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

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

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

58. Excel displays the current cell address in the

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

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

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

60. Hyperlinks can be

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

Tags :

Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Multiple Choice Questions and Answers

MS EXCEL Trivia Quiz

MS EXCEL Question and Answer PDF Online

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....