MS excel set 7 Detailed Explanation And More Example

Question : 1

A numeric value can be treated as label value If...... precedes It.

a) Apostrophe (')

b) Exclamation (!)

c) Hash (#)

d) Tilde(~)

e) None of these

Question : 2

The name box

a) Shows the location of the previously active cell

b) Appears to the left of the formula bar

c) Appears below the status bar

d) Appears below the menu bar

e) None of these

Question : 3

Which is not the function of "Edit, Clear" command?

a) Delete contents

b) Delete notes

c) Delete eel is

d) Delete formats

e) None of these

Question : 4

You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?

a) & (ampersand)

b) = (equal sign)

c) (space)

d) All of the above

e) None of these

Question : 5

To copy formatting from one area in a worksheet and apply it to another area you would use

a) The Edit>Copy Format and Edit>Paste Format commands form the menu.

b) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.

c) There is no way to copy and apply formatting in Excel – You have to do it manually

d) The Format Painter button on the standard toolbar

Question : 6

When you group worksheets

a) You can enter variable data on multiple worksheets at one time

b) You can print more than*one worksheet at a time

c) You can enter common data, formats, and formulas on multiple worksheets at one time

d) b, and c

e) None of these