MS excel set 11 Detailed Explanation And More Example

Question : 1

The Name box

a) Shows the location of the previously active cell

b) Appears t the left of the formula bar

c) Appears below the status bar

d) Appears below the menu bar

e) None of these

Question : 2

Excel displays the current cell address In the..........

a) Formula bar

b) Status Bar

c) Name Box

d) Title Bar

e) None of these

Question : 3

In Excel to hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

a) Unfreeze panes command on the window menu

b) Freeze panes command on the window menu

c) Hold titles command on the edit menu

d) Split command on the window menu

Question : 4

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

a) A.S

b) *

c) %

d) &

e) None of these

Question : 5

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

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