MS EXCEL MCQ Questions and Answers Quiz

101. What type of chart is useful for showing trends or changes over time ?

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

102. What do you use to create a chart?

  1. Excel Wizard
  2. Data Wizard
  3. Chart Wizard
  4. 4

103. Which function is not available in the Consolidate dialog box?

  1. Average
  2. Max
  3. Sum
  4. 1

104. Which of the following methods will not enter data in a cell?

  1. Pressing an arrow key
  2. Pressing the tab key
  3. Clicking the enter button to the formula bar
  4. 1

105. Getting data from a cell located in a different sheet is called.....................

  1. Accessing
  2. Functioning
  3. None of the above
  4. 1

106. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

  1. Insert a row
  2. Increase the column width
  3. Use the spacebar
  4. 2

107. Text formula:

  1. Return ASCII value of chracters
  2. Concatenate and manipulate text
  3. None of the above
  4. 3

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

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

109. Which of the following function will return a value of 8?

  1. ROUNDDOWN(8.4999, 0)
  2. ROUND(8.4999, 0)
  3. Only B and C
  4. 4

110. 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 As
  2. Both (A) and (B)
  3. None of the above
  4. 1
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer