MS-Excel - MS-Excel MCQ

41:  

In MS-Excel to view a cell comment

A.

Click the edit comment commands on the Insert menu

B.

Click the Display comment command on the window menu

C.

Position the mouse pointer over the cell

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



42:  

In MS-Excel worksheet range is a

A.

A command used for data modeling

B.

A range of values such as from 23 to 234

C.

A group of cells

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



43:  

In MS-Excel say that you want to paste a formula result - but not the underlying formula - to another cell. The procdure is to first copy the cell with the formula, then place the insertion point in the cell where you want to copy to. Then next step is to 

A.

Click the Paste button on the standard toolbar

B.

Click the arrow on the paste button on the standard toolbar, then click formulas

C.

Click the arrow on the paste button on the standard toolbar, then click values.

D.

Both (a) & (c)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



44:  

In MS-Excel on a sheet the active cell is indicated by

A.

A dark wide border

B.

A dotted border

C.

A blinking border

D.

None of above

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



45:  

In MS-Excel you can select a single range of cells by

A.

Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B.

Dragging over the desired cells

C.

Pressing the Shift key and an arrow key

D.

All of the above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: