MS excel set 10 Detailed Explanation And More Example

Question : 1

In Excel when creating a vertical page break

a) The active cell must be A1

b) The active cell can be anywhere in the worksheet

c) The active cell must be in row 1

d) The active cell must be in column A

Question : 2

The autofill feature

a) Extends a sequential series of data

b) Automatically adds a range of cell values

c) Applies a boarder around selected cells

d) All of above

e) None of these

Question : 3

Where can you set the shedding color for a range of cells in Excel?

a) Choose required color form Patterns tab of Format Cells dialog box

b) Choose required color on Fill Color tool in Formatting toolbar

c) Choose required color on Fill Color tool in Drawing toolbar

d) All of above

e) None of these

Question : 4

In Excel to create a formula, you can use

a) Values but not cell references

b) Cell references but not values

c) Values or cell references although not both at the same time

d) Value and cell references

Question : 5

Which area in an excel window allows entering values and formulas

a) Title bar

b) Menu bar

c) Formula bar

d) Standard toolbar

e) None of these

Question : 6

In Excel Status indicators are located on the

a) Vertical scroll bar

b) Horizontal scroll bar

c) Formula bar

d) Standard toolbar