MS excel set 2 Detailed Explanation And More Example

Question : 1

Which of the following is not an option in the spelling dialog box?

a) Edit

b) Ignore

c) Ignore all

d) Change

e) None of these

Question : 2

To copy formatting from one area in a worksheet and apply it to another area you would use :

a) The Edit > Copy Format and Edit>Paste Format commands form the menu.

b) The Copy and Apply Formatting dialog box, located under the Formats Copy and Apply menu.

c) There is no way to copy and apply formatting in Excel You have to do it manually

d) The Format Painter button on the standard toolbar

e) None of these

Question : 3

Which of the following formulas will Excel Not be able to calculate?

a) =SUM(Sales)-A3

b) =SUM(A1:A5)*.5

c) =SUM(A1:A5)/(10-10)

d) =SUM(A1:A5)-10

e) None of these

Question : 4

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

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

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