MS excel set 5 Detailed Explanation And More Example

Question : 1

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

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

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

You can use the format painter multiple times before you turn it off by

a) You can use the format painter button only one time when you click it

b) Double clicking the format painter button

c) Pressing the Ctrl key and clicking the format painter button

d) Pressing the Alt key and clicking the format painter button

e) None of these

Question : 5

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

Which is used to perform what if analysis?

a) Solver

b) Goal seek

c) Scenario Manager

d) Allof above

e) None of these