Excel student needs help!!!!

[Belinda]

Hi, I'm an excel student who is just learning the basics.
I have an assignment to hand up that asks the following
questions:
1 What are some of the limiatations of VLOOKUP in Excel?
2 Recommend some other opperations that could be automated
by macros for this application (which was a workbook that
recorded exam marks and overall grades for students) OR
from your professional area(my major is graphic design).
3 Discuss the pros and cons of using password protection
on spreadsheets in a business environment?

I have found some answers to the first question on the
internet, but am having trouble with the others. No. 2 is
asking what other ways I could use macros for
recording/manipulating data regarding student info/grades,
or what ways I could use macros in the graphic design
profession. I can't find any info regarding this anywhere,
and I can't really think of anything off the top of my
head. CAN ANYONE HELP???

For question 3, I figure that the security is the pro -
info can't be sabotaged, accidently changed or written over
and cons- passwords easily forgotten and then no one can
access, it slows things down when changes do need to be
made.
But I'm wondering if it is a little more in depth than
this, since quite a few marks are allocated to the
question.

I'M NOT SURE IF THIS IS THE RIGHT PLACE TO BE ASKING, BUT
I'VE HAD NO LUCK ANYWHERE ELSE. ANY HELP WOULD BE MUCH
APPRECIATED!!!!!
Thanks.

 

[J.E. McGimpsey]

for number 2, try checking the archives:

http://google.com/advanced_group_search?q=group:*excel*

using "student grade macro" (without quotes) as your search terms.


For number 3, you might want to look here:

http://www.mcgimpsey.com/excel/removepwords.html

for some of the cons of using protection for security.