MS excel set 11 Detailed Explanation And More Example

Question : 1

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

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

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

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

Question : 5

A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button......

a) nothing will print because some cells with data have been omitted

b) only the cells with gray back-ground will print

c) the whole sheet will print

d) only the cells with white background will print

e) None of these

Question : 6

In Excel to view a cell comment

a) Click the edit comment command on the insert menu

b) Click the display comment command on the window menu

c) Position the mouse pointer over the cell

d) Click the comment command on the view menu