MS excel set 11 Detailed Explanation And More Example

Question : 1

In Excel, a Data Series is defined as what?

a) A type of chart.

b) A eel I reference.

c) A collection of related data

d) Division of results

e) None of these

Question : 2

To hold row and column titles in place 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

e) None of these

Question : 3

Which of the following action removes a sheet from workbook?

a) Select the sheet, then choose Edit > > Delete Sheet

b) Select the sheet then choose Format » Sheet » Hide

c) Press Insert

d) All of above

e) None of these

Question : 4

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

Question : 5

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

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