MS-Excel - MS-Excel MCQ

66:  

In MS-Excel to center worksheet titles across a range of cells, you must

A.

Select the cells containing the title text plus the range over which the title text is to be centered and click on ' merge and center ' option from formatting bar

B.

Widen the columns

C.

Both (a) & (b)

D.

Format the cells with the comma style

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



67:  

In MS-Excel Text formulas

A.

Replace cell references

B.

Return ASCII values of characters

C.

Concatenate and manipulate text

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



68:  

In MS-Excel how do you delete a column?

A.

Select the column heading you want to delete and select the Delete Row button on the standard toolbar

B.

Select the column heading you want to delete and select Insert Delete from the menu

C.

Select the row heading you want to delete and select Edit>Delete from the menu

D.

Right click the column heading you want to delete and select delete from the shortcut menu

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



69:  

In MS-Excel how do you insert a row?

A.

Right-click the row heading where you want to insert the new row and select insert from the shortcut menu

B.

Select the row heading where you want to insert the new row and select Edit >Row from the menu

C.

Select the row heading where you want to insert the new row and click the insert Row button on the standard toolbar

D.

All of the above

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



70:  

In MS-Excel the following is not a basic step in creating a worksheet

A.

Save workbook

B.

Modifiy the worksheet

C.

Copy the worksheet

 

D.

Both (b) & (c)

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: