MS excel set 6 Detailed Explanation And More Example

Question : 1

A constant is another name for this type of data:

a) number

b) equation

c) formula

d) description

e) None of these

Question : 2

In a worksheet you can select

a) Entire worksheet

b) Rows

c) Columns

d) a, b, and c

e) None of these

Question : 3

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 that the calculated results

e) None of these

Question : 4

When working in the page break preview, you can

a) view exactly where each page break occurs

b) add or remove page breaks

c) change the print area

d) all of above

e) None of these

Question : 5

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a) Pie chart

b) Row chart

c) Line chart

d) Column chart

e) None of these

Question : 6

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a) Unfreeze panes command on the window menu

b) Freeze panes command on the window menu

c) Hold titles command on the edit menu

d) Split command on the window menu

e) None of these