MS excel set 9 Detailed Explanation And More Example

Question : 1

Excel is a

a) Graphic program

b) A spreadsheet

c) Word processor

d) All of Above

e) None of these

Question : 2

Except for the .......function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

a) IF

b) AND

c) OR

d) NOT

e) None of these

Question : 3

By default the cell pointer moves down when you press Enter. From where can you change this setting?

a) Tools > > Options » View tab

b) Tools » Options » Calculation tab

c) Tools » Options » Edit tab

d) Tools » Options » Transition tab

e) None of these

Question : 4

On an Excel sheet the active cell in indicated by

a) A dark wide border

b) A dotted border

c) A blinking border

d) All of above

e) None of these

Question : 5

Which function Is used to calculate depreciation, rates of return, future values and loan payment amounts?

a) Logical

b) Math & Trigonometry

c) Statistical

d) Financial

e) None of these

Question : 6

Formatting a cell In Number format you can't set

a) Decimal Places

b) Use 1000 separator

c) Negative numbers

d) Currency Symbol

e) None of these