Name  Average  Proj. 1  Proj. 2  Proj. 3  Proj. 4 
Tyler, Trevor  80  80  62  66  
Bochco, Steven  89  90  80  
Baimey, Amy  79  61  62  87  
Stevens, Cletus  75  86  99  70  
Sushi, Susie  70  98  80  
Zero, Mark  88  77  62  71  
Foote, Amir  97  71  60  99  
Drier, Bee  97  64  62  97  
Average Grade  
Highest Grade 
Every cell that is green needs a formula in it.
A) Insert a formula in column B that will calculate each student's average grade. Use the average function (like in BowlaRama)
B) Adjust all column widths so that they're just wide enought to handle the data.
C) Format the numbers in column B so that they have zero decimal places.
D) Put a formula in cell B11 that will calculate the average of all the averages. Use the average function.
E )Put a formula in cell B12 that will calculate the highest grade. (use the Max function)
F) Use conditional formatting to show any project score below 70 in red.
G) Sort the names to they're alphabetical.
H) Put a border above and below the title row (ROW 1)
I) Make names and titles bold.
Money Matters  Exercise 1  Using an Expense Record  
Name:  Date:  
John is a student at the local junior college. He has a fulltime job to pay for his living expenses.  
Listed below are John’s expenses for one month. Use the chart to answer the questions.  
DO NOT do the math in your head or on a calculator  USE FORMULAS in all cells shaded GREEN!  


WEEK 1  WEEK 2  WEEK 3  WEEK 4 
Totals 

Rent 
$400.00 
$0.00 
$0.00 
$0.00 

Food 
$50.00 
$43.00 
$29.00 
$48.00 

Clothing 
$0.00 
$74.50 
$29.25 
$0.00 

Car 
$0.00 
$195.00 
$0.00 
$0.00 

Gasoline 
$18.00 
$12.00 
$14.00 
$15.00 

Insurance 
$0.00 
$0.00 
$0.00 
$78.00 

Telephone 
$0.00 
$37.55 
$0.00 
$0.00 

Utilities 
$0.00 
$0.00 
$42.75 
$0.00 

Savings 
$25.00 
$75.00 
$100.00 
$100.00 

Other 
$62.50 
$48.95 
$38.43 
$26.25 

Totals: 

1. How much money was John able to put in his savings account this month?  
ANS: 

2. What was John’s largest expense for the month?  
ANS: 

3. How much did John average per week on gasoline?  
ANS: 

4. What was the greatest amount John spent on food?  
ANS: 

5. Find the difference between the highest and lowest week’s amount spent on groceries.  
ANS: 

6. How much money did John need to earn this month to cover his expenses?  
ANS: 

7. Which week was the most expensive for John?  
ANS: 
Make sure that it has a title. Make sure that the bars are labeled. No legend.
Chart Title:Ergonomic Enhancers Sales Revenue Projection for '09
Corporate accounts  50,000 
Other businesses  25,000 
Individuals  18,000 