MS EXCEL MCQ Questions and Answers Quiz

71. Which of the following is the oldest spreadsheet package ?

  1. StarCalc
  2. VisiCalc
  3. None of the above
  4. 3

72. Which key do you press to check spelling?

  1. F5
  2. F7
  3. F9
  4. 3

73. What is the keyboard shortcut for creating a chart from the selected cell range ?

  1. F10
  2. F11
  3. F12
  4. 3

74. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

  1. Statistical
  2. Logical
  3. None of the above
  4. 1

75. MS-EXCEL can be used to automate

  1. Transaction registers, inventory control
  2. Accounts receivable, accounts payable
  3. Any of the above
  4. 4

76. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

  1. Number format
  2. Border format
  3. All of the above
  4. 4

77. Which menu option can be used to split windows into two?

  1. View -> Window-> Split
  2. Window -> Split
  3. View –> Split
  4. 3

78. How do you wrap the text in a cell?

  1. Format, cells, protection
  2. format, cells, number
  3. Format, cells, alignment
  4. 4

79. Which of the following you can paste selectively using Paste Special command ?

  1. Validation
  2. Formulas
  3. All of the above
  4. 4

80. You can check the conditions against …………………………….when applying conditional formatting

  1. Cell value
  2. Both (A) and (B)
  3. None of the above
  4. 3
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF

MS EXCEL Question and Answer

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