MS EXCEL Multiple Choice Questions and Answers

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