I would upper the answer not attempt to exclude an upper letter, just in
case the case is not correct.

Are the questions numbered? Or just in order?

Where is the answer key located? Is it in table form? Is a column included
that identifies the question? By number?

Will there be a need to change the answers and key for future use of the
worksheet?

Will there be a need to have history kept for various "tests?"

More than one person per test?

And so on.

"Amber12321" wrote in message
...
I have a question about Excel:

The answers for the 20 questions are listed below. Use this information to
write functions that will grade each answer, giving 1 point for a correct
answer and 0 otherwise. Assume that all answers are in lowercase letters;
therefore, the function that tests the answer to the first question should
check for a "c" rather than a "C"

If there's any help to that, please write back