MS excel set 12 Detailed Explanation And More Example

Question : 1

In 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

Question : 2

Comments can be added to cells using

a) Edit > Comments

b) Insert > Comments

c) File > Comments

d) View > Comments

e) None of these

Question : 3

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

a) From Edit menu choose Clear and then Formats

b) From Edit menu choose Delete

c) Click on Remove Formatting tool on Standard Toolbar

d) Double click the Format Painter and then press Esc key in keyboard

e) None of these

Question : 4

An excel workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and charts

Question : 5

In Excel you can use drag-and-drop to embed excel worksheet data in a word document

a) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

b) By dragging a range of excel data to the word button on the taskbar while pressing Shift key

c) By dragging a range of excel data to the word button on the taskbar while pressing Alt key

d) None of above

Question : 6

In 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

b) Widen the columns

c) Select the cells containing the title text plus the range over which the title text is to be enfettered

d) Format the cells with the comma style