MS excel set 11 Detailed Explanation And More Example

Question : 1

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

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

a) Create names

b) Define name

c) Paste name

d) Format cells

Question : 3

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

In Excel Text formulas

a) Replace cell references

b) Return ASCII values of characters

c) Concatenate and manipulate text

d) Show formula error value

Question : 5

In Excel In a worksheet you can select

a) The entire worksheet

b) Rows

c) Columns

d) All of the above

Question : 6

In Excel what does SUMIF function do?

a) Adds up cell values based on a condition

b) Adds all the numbers in a range of cells

c) Returns a subtotal in a list or database

d) All of above