Final Excel Project

(1) Open your spreadsheet in Google Classroom

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.

 

(2) Go to SHEET 2.

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:

         

 

 

 

(3) On SHEET 3 make a column chart for the following data.

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