Microsoft Excel
Extra Problems
Instructions:
There are a total of 3 additional spreadsheet exercises
contained below. You can do them all in one worksheet if you like, or
individually. At this point, we may or may not provide data sets for these
problems; in any case, you should feel free to experiment with values of
your own choosing.
Exercises:
- This first exercise is a worksheet which will calculate peoples' ages.
There should be a place to enter the current date, two columns to enter the
person's name and their birthdate. The third column should display the
age of each person. Hint: You will
need to
fiddle around with cell formats to do this. Also, you may not be able to
make it display the age of a person over the age of 75.
- This exercise will print what age group a person falls into based on
his or her age. There should be columns for each person's name and age,
respectively. The third column should print out if the person is a child
(12 or under), a teenager (13-19), an adult (20-59), or a senior citizen
(60 or older). If you have done the first exercise, it is easy to see
how these two can be combined. You will need to play around with the
if statement for this.
- This last worksheet is not very practical, but uses some very useful
functions. You should have 4 columns. The first column should contain
names, and the second should contain where that person lives. You should
be able to type a name in the third column and have the spreadsheet fill
in the brithplace of that person in the fourth column. The functions you
will need to do this are found under Lookup & Reference.
Notes:
In these exercises, there are some data which will be too large to fit
into a standard column. Feel free to reformat your columns to
allow your data to fit. These can be printed out with the formulas.
(Look under Tools - Options - View and add a check mark next to
the formulas).
Return to 1001 Home Page