MS excel set 9 Detailed Explanation And More Example

Question : 1

A data map is helpful

a) When you have too much data to chart

b) To show a geographic distribution of data

c) To compare data points

d) To show changes in data over-time

e) None of these

Question : 2

In Excel you can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on a shortcut menu

c) With buttons on the standard toolbar

d) All of the above

Question : 3

Using the AutoSum button will replace in the selected cell......

a) the sum of values in the cell's column.

b) nothing until you select a range of cells

c) the sum of the cell's row unless you change the range

d) None of these

Question : 4

In Excel the following displays the contents of the active cell

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

Question : 5

An excel workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and charts

e) None of these

Question : 6

In Excel to copy cell contents using drag and drop, press the

a) End key

b) Shift key

c) Esc key

d) None of above