MS excel set 5 Detailed Explanation And More Example

Question : 1

Hounding 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

e) None of these

Question : 2

In Excel got functions? No? You need the insert function dialog box. How do you get it?

a) Right click a cell and then click insert

b) Click the insert menu and then click function

c) Type = in a cell

d) All of the above

Question : 3

The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the control field change.

a) ADD

b) SUM

c) TOTAL

d) LIST

e) None of these

Question : 4

In Excel to select a column the easiest method is to

a) Double click any cell in the column

b) Drag from the top cell in the column to the last cell in the column

c) Click the column heading

d) Click the column label

Question : 5

In Excel what symbol is used before a number to make it a label?

a) “ (quote)

b) = (equal)

c) _ (underscore)

d) ‘ (apostrophe)

Question : 6

Which of the following format you can decide to apply or not In AutoFormat dialog box?

a) Number format

b) Border format

c) Font format

d) All of above

e) None of these