MS excel set 12 Detailed Explanation And More Example

Question : 1

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

The Trace Dependence in auditing shows

a) Which cells are used in current formula

b) In which formula the current cell is used

c) Which cells are used in this formula and in which formula this cell is used

d) All of above

e) None of these

Question : 3

You can use the formula palette to

a) format cells containing numbers

b) create and edit formulas containing functions

c) entered assumptions data

d) copy a range of cells

e) None of these

Question : 4

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

Comments can be added to cells using

a) Edit > Comments

b) Insert > Comments

c) File > Comments

d) View > Comments

e) None of these

Question : 6

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