MS EXCEL MCQ Questions and Answers Quiz

91. Long text can be broken down into many lines within a cell. You can do this through

  1. Wrap Text
  2. Conditional Formatting
  3. None of the above
  4. 2

92. In Excel, by default Numeric Values appears in.

  1. Right aligned
  2. Center aligned
  3. Justify aligned
  4. 2

93. What are the tabs that appear at the bottom of each workbook called ?

  1. Sheet tabs
  2. Reference tabs
  3. None of the above
  4. 2

94. To record a sequence of keystrokes and mouse actions to play back later we use:

  1. Sound Recorder
  2. Calculator
  3. Macro Recorder
  4. 4

95. A function inside another function is called……………………………

  1. Round function
  2. Inner function
  3. None of the above
  4. 1

96. Which functionin Excel tells how many numeric entries are there ?

  1. COUNT
  2. SUM
  3. CHKNUM
  4. 2

97. Which of the following is not a valid data type in Excel ?

  1. Character
  2. Label
  3. None of the above
  4. 2

98. Which setting you must modify to print a worksheet using letterhead?

  1. Margin
  2. Layout
  3. Orientation
  4. 2

99. What type of chart is useful for comparing parts of a whole ?

  1. Column Chart
  2. Line Chart
  3. Dot Graph
  4. 1

100. What type of chart is useful for comparing vaues over categories ?

  1. Column Chart
  2. Line Chart
  3. Dot Graph
  4. 2
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer