MS-Excel - MS-Excel MCQ

91:  

In MS-Excel you can enter which types of data into worksheet cells?

A.

Labels, values, and formulas

B.

Labels and values but not formulas

C.

Values and formulas but not labels

D.

Values only

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



92:  

In MS-Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?

A.

Pie chart

B.

Row chart

C.

Line chart

D.

Both (b) & (c)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



93:  

In MS-Excel which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell

A.

Count

B.

Average

C.

Sum

D.

None of above

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



94:  

In MS-Excel if you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

A.

Press the Erase key

B.

Press Esc

C.

Press the Enter button

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



95:  

In MS-Excel default style for new data keyed in a new workbook is

A.

Comma

B.

Currency

C.

General

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here: