| 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 Bowl-a-Rama)
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 full-time 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 |