MS excel set 6 Detailed Explanation And More Example

Question : 1

Can you set 0,5 Inch left Indentation for a cell in Excel?

a) Excel does not have 1 ^Indentation feature

b) \fybu can specify Indentation only If you turn the rulers on

c) Indentation can be set from Format Cells dialog box

d) The Indentation can be specified only when printing

e) None of these

Question : 2

A constant is another name for this type of data:

a) number

b) equation

c) formula

d) description

e) None of these

Question : 3

In a worksheet you can select

a) Entire worksheet

b) Rows

c) Columns

d) a, b, and c

e) None of these

Question : 4

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a) Pie chart

b) Row chart

c) Line chart

d) Column chart

e) None of these

Question : 5

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

To return the remainder after a number Is divided by a divisor In EXCEL we use the function?

a) ROUND ( )

b) FACTQ

c) MODQ

d) DIV()

e) None of these