MS excel set 11 Detailed Explanation And More Example

Question : 1

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

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

If you need a text to show vertically In a cell. How will you achieve this?

a) Choose Vertical on Text alignment In Format Cells dialog box

b) Choose 90 Degrees in Orientation of Format Cells dialog box

c) Choose Distributed from the Vertical drop down list of Format Cells dialog box

d) Choose Center Across Selection from Horizontal combo box In Format Cells dialog box

e) None of these

Question : 4

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

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

a) A.S

b) *

c) %

d) &

e) None of these

Question : 6

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