Sample exam

Part I - Grauer:
do the end of chapter exercises, ch 1 - 4

Part II - excel formulas and VBA (up to ifs)
(ch 2, about relative and absolute, and mixed refs.)
(ch 3, about names)
(ch 5, about text functions)
1. Names:
a. Name a 2 x 4 area, as an absolute reference. Call it data.

b. Name a relative reference to 3 cells up and 2 cells to the right. Call it fred.

c. Print out all the names in your workbook.

d. Make separate TaxRates on each worksheet, by limiting the scope.

e. Name an array containing the months of the year.

2. Ch 5, text function.
a. Pig latin.
I love speaking Pig Latin
Iway ovelay eakingspay igPay atinLay  

Take a word and turn it into its Pig Latin equivalent.

3. VBA question.
Do the same thing in VBA