MS EXCEL MCQ Multiple Choice Questions Answers - Page 5

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

Correct Answer is: database of rainfall

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

Correct Answer is: None of the above

Q: 126. B7:B9 indicates:

Correct Answer is: Cell B9 only

Q: 127. What is the quickest way to select entire worksheet?

Correct Answer is: Click on the first column, press Shift, and then click on the last column

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

Correct Answer is: Color, then Pet Name

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

Correct Answer is: Both A and B

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

Correct Answer is: None of the above

Q: 136. What does COUNTA () function do ?

Correct Answer is: counts empty cells

Q: 139. What is the short cut key to replace a data with another in sheet ?

Correct Answer is: All of the above

Q: 140. What is the shortcut key to hide entire column ?

Correct Answer is: None of the above

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

calendar
photograph of rainfall
chart showing rainfall amounts
database of rainfall

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

cell
title
axis
legend

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

cell
table
box
column

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

Cell Tip
Smart Tip
Soft Tip
None of the above

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

Cells
Rows
Columns
Document

126. B7:B9 indicates:

Cells B7 through B9
Cells B7 and cell B9 only
Cell B8 only
Cell B9 only

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

Choose Edit -> Select all from the Menu
Click on the first column, press Ctrl, and then click on the last column
Click on the first column, press Shift, and then click on the last column
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

Color, then Gender
Pet Type, then Color
Pet Type, then Gender
Color, then Pet Name

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

Column
Value
Address
Cell

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

Column Chart
Line Chart
Pie Chart
Dot Chart

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

Column Chart
Line Chart
Pie Chart
Cone Chart

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

Column Chart
Line Chart
Pie Chart
Both A and B

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

Complex Formulas
Array Formula
Standard Formulas
None of the above

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

Contents
Objects
Scenarios
All of the above

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

Contents tab
Answer Wizard tab
Index tab
all of the above.

136. What does COUNTA () function do ?

counts cells having alphabets
counts selected cells
counts empty cells
counts non-empty cells

137. What is the shortcut key to insert current date in a cell ?

CTRL + ;
CTRL + T
CTRL + D
CTRL + '

138. To select an entire column in MS-EXCEL, press?

CTRL + C
CTRL + Arrow key
CTRL + S
None of the above

139. What is the short cut key to replace a data with another in sheet ?

Ctrl + H
Ctrl + Shift + R
Ctrl + R
All of the above

140. What is the shortcut key to hide entire column ?

CTRL + H
CTRL + 0
CTRL + -
None of the above

MS EXCEL MCQ Multiple Choice Questions Answers - Page 5 | Quiz for Practice

MS EXCEL MCQ Questions 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

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

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

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

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

126. B7:B9 indicates:

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

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

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

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

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

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

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

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

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

136. What does COUNTA () function do ?

137. What is the shortcut key to insert current date in a cell ?

138. To select an entire column in MS-EXCEL, press?

139. What is the short cut key to replace a data with another in sheet ?

140. What is the shortcut key to hide entire column ?

Your Score

Related Quiz Topics

Recent Articles

Looking to post on our portal?

MS EXCEL MCQ Multiple Choice Questions Answers - Page 5 | Quiz for Practice

MS EXCEL MCQ Questions 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

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

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

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

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

126. B7:B9 indicates:

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

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

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

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

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

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

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

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

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

136. What does COUNTA () function do ?

137. What is the shortcut key to insert current date in a cell ?

138. To select an entire column in MS-EXCEL, press?

139. What is the short cut key to replace a data with another in sheet ?

140. What is the shortcut key to hide entire column ?

Your Score

Related Quiz Topics

Recent Articles

Login at Quizforum