MS EXCEL MCQ Questions and Answers Quiz

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

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

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

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

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

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

44. 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

45. What do you use to create a chart?

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

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

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

47. 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

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

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

49. 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

50. Text formula:

  1. Replace cell references
  2. Return ASCII value of chracters
  3. Concatenate and manipulate text
  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....