MS excel set 12 Detailed Explanation And More Example

Question : 1

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 : 2

In Excel which of these will not select all the cells in a document?

a) Clicking three times with the right mouse button in the spreadsheet

b) Using the Edit – Select All menu

c) Pressing Ctrl + A on the keyboard

d) Pressing Ctrl + A on the keyboard

Question : 3

In Excel AutoCalculate will quickly add selected cells if you

a) right click on the status bar and select Sum

b) click the AutoCalculate button on the toolbar

c) use the key combination Ctrl+$

d) double click the selection

Question : 4

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 : 5

In Excel you can print

a) A range of cells by range name

b) An entire worksheet

c) A single worksheet

d) All of the above

Question : 6

An excel workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and charts