MS-Excel - MS-Excel MCQ

11:  

In MS-Excel the auto calculate feature

A.

Can add values in a range of cells

B.

Provides a quick way to view the results of an arithmetic operation on a range of cells

C.

Automatically creates formula and adds them to a worksheet

D.

All of these

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



12:  

In MS-Excel you can use the format painter multiple times before you turn it off by

A.

You can use the format painter button only one time when you click it

B.

Double clicking the format painter button

C.

Pressing the Ctrl key and clicking the format painter button

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



13:  

In MS-Excel you can quickly change the appearance of your work by choosing Auto Format from the .......... Menu

A.

Edit

B.

View

C.

Format

D.

All of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



14:  

In MS-Excel which of the following is not a worksheet design criterion

A.

Efficiency

B.

Auditability

C.

Description

D.

Both (b) & (c)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



15:  

In MS-Excel to copy cell contents using drag and drop, press the

A.

End key

B.

Shift+End key

C.

Esc key

D.

None of above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: