MS excel set 2 Detailed Explanation And More Example

Question : 1

In Excel you can activate a cell by

a) Pressing the Tab key

b) Clicking the cell

c) Pressing an arrow key

d) All of above

Question : 2

You can move a sheet from one workbook into new book by

a) From Edit menu choose Move or Copy sheet mark the Create a copy and Click OK

b) From Edit menu choose Move of Copy then choose {Move to end) and click OK

c) From Edit menu choose Move or Copy then select {new book) from To Book list and click OK

d) All of above

e) None of these

Question : 3

You can automatically adjust the ! size of text in a cell if they do not fit in width by

a) Double clicking on the right border of column header

b) From Format choose Columns and then Autofit Selection

c) From Format Cells dialog box mark Shrink to fit check box

d) All of above

e) None of these

Question : 4

What does the VLOOKUP function do?

a) Looks up text that contain V

b) Checks whether text is the same in one cell as in the next

c) Finds related records

d) All of above

e) None of these

Question : 5

This type of software is similar to an accountant's worksheet

a) Word processing

b) Database

c) Spreadsheets

d) Graphics

e) None of these

Question : 6

Gridlines

a) May be turned off for display but turned on for printing

b) May be turned on or off for printing

c) The be turned off for display and printing

d) a, b and c

e) None of these