MS excel set 2 Detailed Explanation And More Example

Question : 1

Long text can be broken down into many lines within a cell. You can do this through We have 83

a) Wrap Text in Format > > Cells guests online

b) Justify in Edit > > Cells

c) Text Wrapping in Format » Cells, Layout tab

d) All of above

e) None of these

Question : 2

In help menu of Excel, which of the following tabs are found?

a) Contents tab

b) Answer Wizard tab

c) Index tab

d) all of the above

e) None of these

Question : 3

What happens when dollar signs (S) are entered In a cell address?

a) An absolute eel I address is created.

b) Cell address will change when it is copied to another cell.

c) The sheet tab is changed.

d) The status bar does not display the eel I address.

e) None of these

Question : 4

In Excel typical worksheet has …. Number of columns

a) 512

b) 256

c) 1024

d) 16,384

Question : 5

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

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