MS excel set 13 Detailed Explanation And More Example

Question : 1

The cell reference for a range of cells that starts in cell Bl and goes over to column G and down to row 10 is ....

a) G1-G10

b) B1.G10

c) B1;G10

d) B1:G10

e) None of these

Question : 2

When creating a vertical page break

a) The active cell must be A1

b) The active cell can be anywhere in the worksheet

c) The active cell must be in row 1

d) The active cell must be in column A

e) None of these

Question : 3

In Excel to delete and embedded object, first

a) Double click the object

b) Select the object by clicking it

c) Press the Shift + Delete keys

d) Select it and then press Delete key

Question : 4

Each excel file is called a workbook because

a) It can contain text and data

b) It can be modified

c) It can contain many sheets including worksheets and chart sheets

d) You have to work hard to create it

e) None of these

Question : 5

In Excel how can you print three copies of a workbook?

a) Select File>Properties form the menu and type 3 in the Copies to print text box.

b) Select File >Print from the menu and type 3 in the Number of copies text box.

c) Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

d) Press Ctrl+P+3

Question : 6

Each excel file is called a work-book because

a) It can contain text and data

b) It can be modified

c) It can contain many sheets including worksheets and chart sheets

d) You have to work hard to create it

e) None of these