MS EXCEL Multiple Choice Questions and Answers

41. Comments put in cells are called .....

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

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

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

43. B7:B9 indicates:

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

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

1. Click on the first column, press Ctrl, and then click on the last column
2. Click on the first column, press Shift, and then click on the last column
3. Click on the rectangle box on the upper left corner where column headings and row headings meet
4. 4

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

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

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

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

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

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

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

1. Line Chart
2. Pie Chart
3. Cone Chart
4. 3

49. What type of chart will you use to compare performance of sales of two products ?

1. Line Chart
2. Pie Chart
3. Both A and B
4. 1

50. Multiple calculations can be made in a single formula using.......

1. Array Formula
2. Standard Formulas
3. None of the above
4. 2