As you can see by now, no one around here respects anyone who doesn't try
themselves.

If you had posted the fact that you're taking a test, and you could use some
help to answer some questions that might be ambiguous, and perhaps be
interpreted in more then one way, you would probably be surprised at how
many folks would jump in and give their opinion as to what the question
might mean and what the answer might be.

For instance, the first question ... you might have asked:
There's a Fixed() function that changes numbers to text and rounds them,
there's also a Text() function that formats numbers and changes them to
text,
and also a Left(), Right(), and Mid() function that can return a certain
number of digits from different locations in a number and changes them to
text,
SO folks, which do you think I should use as the answer?

You would definitely have gotten responses to that!

All these functions are listed in the Help files under TEXT.

You should have at least started there ... don't ya think?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mpotla" wrote in message
...
1. The _____ function converts numbers to text.
2.The ______ functions allows you to check for a condition.
3.__________ are a list of predefined formats to make formatting all or
part
of a worksheet easier.
4. ____________ give a spreadsheet a consistent appearance.
5. ___________cannot be inserted using normal keystrokes.
6. __________returns the most frequently occuring value from its
arguments.
7. ___________ is used to shade cells in a worksheet.