MS excel set 11 Detailed Explanation And More Example

Question : 1

In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?

a) Pie chart

b) Row chart

c) Line chart

d) Column chart

Question : 2

What function displays row data in a column or column data in a row?

a) Hyperlink

b) Index

c) Transpose

d) Rows

e) None of these

Question : 3

Give me an example of a cell address.

a) 1125

b) 911

c) 41A

d) A21

e) None of these

Question : 4

In Excel Rounding errors can occur

a) When you use multiplication, division or exponentiation in a formula

b) When you use addition and subtraction in a formula

c) Because Excel uses hidden decimal places in computation

d) When you show the results of formulas with different decimal places than the calculated results

Question : 5

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

a) A dark wide boarder

b) A dotted border

c) A blinking border

d) None of above

Question : 6

In Excel to delete an embedded objects, first

a) Double click the object

b) Select the object by clicking it

c) Press the Shift + Delete keys

d) Select it and then press the delete key