MS excel set 5 Detailed Explanation And More Example

Question : 1

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

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

a) Enter

b) Ctrl+Enter

c) Tab

d) Insert

Question : 3

Which of the following is not a valid data type in excel

a) Number

b) Character

c) Label

d) Date/time

e) None of these

Question : 4

When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?

a) Auto Complete

b) AutoFormat

c) Custom List

d) Calculation Automatic

e) None of these

Question : 5

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

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