MS excel set 5 Detailed Explanation And More Example

Question : 1

In Excel what symbol is used before a number to make it a label?

a) “ (quote)

b) = (equal)

c) _ (underscore)

d) ‘ (apostrophe)

Question : 2

In Excel to select a column the easiest method is to

a) Double click any cell in the column

b) Drag from the top cell in the column to the last cell in the column

c) Click the column heading

d) Click the column label

Question : 3

In Excel data can be arranged in a worksheet in a easy to understand manner using

a) Auto formatting

b) Applying styles

c) Changing fonts

d) All of above

Question : 4

In Excel you can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells

Question : 5

Bookl is an example of how …... are numbered and named during each work session

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

e) None of these

Question : 6

In Excel which of the following options is not located in the Page Setup dialog box?

a) Page Break Preview.

b) Page Orientation

c) Margins

d) Headers and Footers