Classical

MS-Excel - MS-Excel MCQ

21:  

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 :


22:  

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

A.

128

B.

256

C.

512

D.

None of these

 
 

Option: B

Explanation :


23:  

In MS-Excel concatenation of text can be done using

A.

Apostrophe (')

B.

Exclamation (!)

C.

Both (a) & (b)

D.

Ampersand (&)

 
 

Option: D

Explanation :


24:  

In MS-Excel how many characters can be typed in a single cell?

A.

25600

B.

10240

C.

32,000

D.

65,535

 
 

Option: D

Explanation :


25:  

In MS-Excel data can be arranged in a worksheet in a easy to understand manner using

A.

Auto formatting

B.

Applying styles

C.

Changing fonts

D.

All of above

 
 

Option: D

Explanation :




Suggest an improvement