MS excel set 6 Detailed Explanation And More Example

Question : 1

In Excel how many characters can be typed in a single cell?

a) 256

b) 1024

c) 32,000

d) 65,535

Question : 2

You can use the format painter , multiple times before you turn it offby

a) You can use the format painter button only one time when you click it

b) Double clicking the format painter button

c) Pressing the Ctrl key and clicking the format painter button

d) Pressing Alt key and clicking the format painter button

e) None of these

Question : 3

How should you print a selected area of a worksheet, if you'll want to print a different area next time?

a) On the file menu, point to print area, and then click set print are

b) On the file menu, click print, j and then click selection under print what

c) On the view menu, click custom views, then click add

d) All of above

e) None of these

Question : 4

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

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

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