MS EXCEL MCQ Questions and Answers Quiz

41. The box on the chart that contains the name of each individual record is called the

  1. cell
  2. title
  3. axis
  4. legend

42. The basic unit of a worksheet into which you enter data in Excel is called a

  1. cell
  2. table
  3. box
  4. column

43. Comments put in cells are called .....

  1. Cell Tip
  2. Smart Tip
  3. Soft Tip
  4. None of the above

44. Which of the following is not a term of MS-Excel?

  1. Cells
  2. Rows
  3. Columns
  4. Document

45. B7:B9 indicates:

  1. Cells B7 through B9
  2. Cells B7 and cell B9 only
  3. Cell B8 only
  4. Cell B9 only

46. What is the quickest way to select entire worksheet?

  1. Choose Edit -> Select all from the Menu
  2. Click on the first column, press Ctrl, and then click on the last column
  3. Click on the first column, press Shift, and then click on the last column
  4. Click on the rectangle box on the upper left corner where column headings and row headings meet

47. If you want all of the white cats grouped together in the database, you need to sort by

  1. Color, then Gender
  2. Pet Type, then Color
  3. Pet Type, then Gender
  4. Color, then Pet Name

48. What is the intersection of a column and a row on a worksheet called ?

  1. Column
  2. Value
  3. Address
  4. Cell

49. How will you graphically represent expenditure in different departments ?

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

50. What type of chart is good for single series of data ?

  1. Column Chart
  2. Line Chart
  3. Pie Chart
  4. Cone Chart
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....