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. |
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. |
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. |
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. |