Classical

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 :


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 :


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 :


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 :


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 :




Suggest an improvement