MS excel set 9 Detailed Explanation And More Example

Question : 1

In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

a) B1-G10

b) B1.G10

c) B1;G10

d) B1:G10*

Question : 2

In Excel the following is not a basic step in creating a worksheet

a) Save workbook

b) Modifiy the worksheet

c) Enter text and data

d) Copy the worksheet

Question : 3

When you work with large worksheets, you may need to

a) size the worksheet to fit on the specific number of pages

b) add and remove page breaks

c) specify only certain print areas

d) all of above

e) None of these

Question : 4

Excel files have a default extension of

a) Xls

b) Xlw

c) Wkl

d) 123

e) None of these

Question : 5

You can not link Excel worksheet data to a Word document

a) With the right drag method

b) With a hyperlink

c) With the copy and paste -special commands

d) With the copy and paste buttons on the standard toolbar

e) None of these

Question : 6

In Excel you can use the drag and drop method to

a) Copy cell contents

b) Delete cells contents

c) Add cell contents

d) All of above