MS excel set 6 Detailed Explanation And More Example

Question : 1

In Excel on an Excel sheet the active cell in indicated by

a) A dark wide border

b) A dotted border

c) A blinking border

d) None of above

Question : 2

Which of the following is not true regarding Conditional Formatting?

a) You can add more than one condition to check

b) You can set condition to look for Bold and apply Italics on them.

c) You can apply Font, border and pattern formats that meets the specified conditions

d) You can delete any condition from Conditional Formatting dialog box if it is not required

e) None of these

Question : 3

In Excel when you see a cell with a red triangle in the top right corner, what does this signify?

a) There is an error in the cell

b) There is a comment associated with the cell

c) The font color for text in the cell is red

d) A formula cannot be entered into the cell

Question : 4

In a worksheet you can select

a) Entire worksheet

b) Rows

c) Columns

d) a, b, and c

e) None of these

Question : 5

A constant is another name for this type of data:

a) number

b) equation

c) formula

d) description

e) None of these

Question : 6

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