MS excel set 11 Detailed Explanation And More Example

Question : 1

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

You can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.

a) Edit

b) Insert

c) Format

d) Tools

e) None of these

Question : 3

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

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

Question : 5

Which of the following is a popular DOS based spreadsheet package?

a) Word

b) Smart cell

c) Excel

d) Lotus 1-2-3

e) None of these

Question : 6

To center worksheet titles across a range of cell, you must

a) Select the cells containing the title text and use the fill handle to center the text across a range of cells

b) Widen the columns

c) Select the cells containing the title text and use the fill handle to center the text across a range of cells

d) Widen the column

e) None of these