MS excel set 11 Detailed Explanation And More Example

Question : 1

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

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

a) A.S

b) *

c) %

d) &

e) None of these

Question : 3

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

a) Rows and columns

b) Headings

c) Speed

d) All of above

e) None of these

Question : 4

In Excel to name a constant, you use the …… dialog box

a) Create names

b) Define name

c) Paste name

d) Format cells

Question : 5

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

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