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.

And, after we do that, you are telling your instructor to give us the
grade??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

Someone else in this forum deserves the credit for this but I forgot who€¦
Two students arrive just after the exam session is over, and plead they had
a flat tire and there was nothing they could have done to get to the exam on
time.
Professor says, no problem, gives each one an exam paper, and says your exam
is just one question: which tire?
Professor seats them in different rooms to finish the exam.

Dude! Do your homework...

"mpotla" wrote:

1. The _MAGIC____ function converts numbers to text.
2.The _WAZZUPWITHTHAT_____ functions allows you to check for a condition.
3.__FASHIONS________ are a list of predefined formats to make formatting all or part of a worksheet easier.
4. __MONITORS__________ give a spreadsheet a consistent appearance.
5. __PORNOGRAPHY_________cannot be inserted using normal keystrokes.
6. _WTF_________returns the most frequently occuring value from its arguments.
7. __UV-AB-SUNGLASSES_________ is used to shade cells in a worksheet.

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.