MS excel set 7 Detailed Explanation And More Example

Question : 1

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

The spelling dialog box can be involved by choosing spelling from ___ menu.

a) Insert

b) file

c) tools

d) view

e) None of these

Question : 3

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

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

Question : 5

In Excel Chart wizard term data categories refers to

a) A chart plot area

b) A horizontal axis

c) The organization of individual values with a chart’s data series

d) The data range that supply chart data

Question : 6

In Excel which of the following is an absolute cell reference?

a) !A!1

b) $A$1

c) #a#1

d) A1