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 Question and Answer