MS excel set 5 Detailed Explanation And More Example

Question : 1

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

Question : 2

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

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

A ______is a grid with labeled columns and rows.

a) Dialog box

b) Worksheet

c) Clipboard

d) Toolbar

e) None of these

Question : 5

Getting data from a cell located in a different sheet is called

a) Accessing

b) Referencing

c) Updating

d) Functioning

e) None of these

Question : 6

Files created with Lotus 1-2-3 have an extension

a) DOC

b) XLS

c) 123

d) WK1

e) None of these