MS-Excel - Advanced MS-Excel

11:  

In MS-Excel which elements of worksheet can be protected from accidental modification?

A.

Contents

B.

Objects

C.

Scenarios

D.

All of above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



12:  

In MS-Excel comments can be added to cells using

A.

Edit > Comments

B.

Insert > Comments

C.

File > Comments

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



13:  

In MS-Excel how can you delete a record?

A.

Delete the column from the worksheet

B.

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

C.

Select Data > Delete Record from the menu

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



14:  

In MS-Excel which of the following is an absolute cell reference?

A.

!A!1

B.

$A$1

C.

#a#1

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



15:  

In MS-Excel Documentation should include

A.

Destination and users of the output data

B.

Source of input data

C.

Information on the purpose of the workbook

D.

All of the above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: