MS excel set 5 Detailed Explanation And More Example

Question : 1

Which of the following will not set text in selected cells to italics?

a) Pressing Ctrl + I on the keyboard

b) Using the Tools - Wizard -Web Form menu item

c) Using the Format - Cells -Font menu item

d) All of the above

e) None of these

Question : 2

When the formula bar is activated, you can see

a) The Edit Formula button

b) The Cancel button

c) The Enter button

d) All of above

e) None of these

Question : 3

In Excel if you press ……, the cell accepts your typing as its contents.

a) Enter

b) Ctrl+Enter

c) Tab

d) Insert

Question : 4

Which of the following option is not available in Paste Speciat dialog box?

a) Add

b) Subtract

c) Divide

d) SORT

e) None of these

Question : 5

Which of the following is a correct order of precedence in a formula calculation?

a) Multiplication and division, exponential positive and negative value

b) Multiplication and division, positive and negative values, addition and subtraction

c) Addition and subtraction, positive and negative values, exponentiation

d) All of above

e) None of these

Question : 6

In a worksheet you can select

a) The entire worksheet

b) Rows

c) Columns

d) All of the above

e) None of these