microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 41

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

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

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

In Excel worksheet range is a

a) A command used for data modeling

b) A range of values such as from 23 to 234

c) A group of cells

d) A group of worksheets

Question : 45

You can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on the shortcut menu

c) With buttons on the standard toolbars

d) All of the above

e) None of these