MS excel set 12 Detailed Explanation And More Example

Question : 1

In Excel Weight refers to

a) The print density of characters

b) The height of the printed character

c) Upright or slanted shape

d) The design and appearance of characters

Question : 2

Which of the following is invalid statement?

a) Sheet tabs can be colored

b) Some picture can be applied as a background of a sheet

c) You can set the column width automatically fit the amount of text

d) The width of a row and be specified manually or fit automatically

e) None of these

Question : 3

In Excel divide symbol is

a) /

b) D

c) \

d) )

Question : 4

In Excel you can enter which types of data into worksheet cells?

a) Labels, values, and formulas

b) Labels and values but not formulas

c) Values and formulas but not labels

d) Formulas only

Question : 5

In Excel using the AutoSum button will replace in the selected cell

a) the sum of values in the cell’s column

b) nothing until you select a range of cells

c) the sum of the cell’s row unless you change the range

d) a formula which will add values in the range Excel guesses you want to add

Question : 6

The default and maximum number of sheets for a new workbook in Excel 2003 is

a) 3 and 255

b) 3 and 256

c) 1 and 255

d) 1 and 256

e) None of these