Pls answer the following question for me for my assignment.

M

mpotla

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

Ted M H

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

Ragdyer

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?
 
Top