MS excel set 11 Detailed Explanation And More Example

Question : 1

You can quickly change the appearance of your work by choosing Auto Format from the .... Menu

a) Edit

b) View

c) Format

d) Tools

e) None of these

Question : 2

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

a) Square

b) Percentage

c) Goal Seek

d) Divide

e) None of these

Question : 3

In the formula, which symbol specifies the fixed columns or rows?

a) A.S

b) *

c) %

d) &

e) None of these

Question : 4

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

a) Multiplication and division exponentiation positive and negative values

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

Excel is a good application for What IF analysis. Which of the following tool help you for this?

a) Formula Auditing

b) Research

c) Track Change

d) Goal Seek

e) None of these

Question : 6

In Excel Text formulas

a) Replace cell references

b) Return ASCII values of characters

c) Concatenate and manipulate text

d) Show formula error value