MS EXCEL Questions and Answers in Quiz Form 9 for Practice

121. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

1. calendar
2. photograph of rainfall
3. chart showing rainfall amounts
4. database of rainfall

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

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

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

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

124. Comments put in cells are called .....

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

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

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

126. B7:B9 indicates:

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

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

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

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

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

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

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

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

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

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

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

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

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

134. Which elements of a worksheet can be protected from accidental modification?

1. Contents
2. Objects
3. Scenarios
4. All of the above

135. In help menu of Excel, which of the following tabs are found?

1. Contents tab
2. Answer Wizard tab
3. Index tab
4. all of the above.