MS EXCEL MCQ Questions and Answers Quiz

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

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

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

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

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

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

104. What do you use to create a chart?

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

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

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

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

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

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

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

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

  1. Re-format the spreadsheet
  2. Insert a row
  3. Increase the column width
  4. Use the spacebar

109. Text formula:

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

110. 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
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF

MS EXCEL Question and Answer

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