MS excel set 5 Detailed Explanation And More Example

Question : 1

In a worksheet you can select

a) The entire worksheet

b) Rows

c) Columns

d) All of the above

e) None of these

Question : 2

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

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

What symbol is used before a number to make it a label?

a) "(quote)

b) = (equal)

c) _ (underscore)

d) * (apostrophe)

e) None of these

Question : 5

Which is used to perform what if analysis?

a) Solver

b) Goal seek

c) Scenario Manager

d) Allof above

e) None of these

Question : 6

In Excel which menu option can be sued to split windows into two

a) Format > window

b) View > window > split

c) Window > split

d) View > split