MS excel set 3 Detailed Explanation And More Example

Question : 1

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

You can print

a) A range of cells by range name

b) An entire worksheet

c) A single worksheet

d) All of the above

e) None of these

Question : 3

In Excel advantage of using a spreadsheet is

a) calculations can be done automatically.

b) changing data automatically updates calculations

c) more flexibility

d) all of the above

Question : 4

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

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

e) None of these

Question : 6

Concatenation of text can be done using

a) Apostrophe (')

b) Exclamation (!)

c) Hash(#)

d) Ampersand (&)

e) None of these