Classical

MS-Excel - MS-Excel MCQ

46:  

In MS-Excel which is not an advantage of using computerized spreadsheets?

A.

Flexibility of moving entries

B.

Speed of calculation

C.

Ability of generate tables

D.

Cost of initial setup

 
 

Option: D

Explanation :


47:  

In MS-Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A.

Unfreeze panes command on the window menu

B.

Freeze panes command on the window menu

C.

Hold titles command on the edit menu

D.

None of these

 
 

Option: B

Explanation :


48:  

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 :


49:  

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 :


50:  

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 :




Suggest an improvement