MS-Excel - MS-Excel MCQ

31:  

In MS-Excel scrolling button at the bottom of screen  

A.

Allow you to view a different worksheet

B.

Allow you to view additional worksheet rows down

C.

Allow you to view additional worksheet columns to the right

D.

Allow you to view additional sheets tabs

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



32:  

In MS-Excel which of the following formulas will not be calculated?

A.

=SUM(Sales)-A3

B.

=SUM(A1:A5)*.5

C.

+SUM(A1:A5)/(10-10)

D.

Both (a) & (c)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



33:  

In MS-Excel numeric value can be treated as a label value if it precedes with

A.

Apostrophe (')

B.

Exclamation (!)

C.

Hash (#)

D.

None of these

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



34:  

In MS-Excel typical worksheet has .... Number of columns

A.

128

B.

256

C.

512

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



35:  

In MS-Excel concatenation of text can be done using

A.

Apostrophe (')

B.

Exclamation (!)

C.

Both (a) & (b)

D.

Ampersand (&)

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: