MS excel set 3 Detailed Explanation And More Example

Question : 1

When you link data maintained in an excel workbook to a word document

a) The word document can not be edit

b) The word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

e) None of these

Question : 2

In Excel you can use the format painter multiple times before you turn it off by

a) You can use the format painter button only one time when you click it

b) Double clicking the format painter button

c) Pressing the Ctrl key and clicking the format painter button

d) Pressing Alt key and clicking the format painter button

Question : 3

Graphics objects on a chart are used to

a) Add emphasis to chart data

b) Add interest to a chart

c) Help explain the chart data

d) a, b, and c

e) None of these

Question : 4

Concatenation of text can be done using

a) Apostrophe (')

b) Exclamation (!)

c) Hash(#)

d) Ampersand (&)

e) None of these

Question : 5

In 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

Question : 6

Which of the cell pointer indicate that you can move the content to other cell?

a) Doctor's symbol (Big Plus)

b) small thin plus icon

c) Mouse Pointer with anchor at the tip

d) All of above

e) None of these