Super Sunday

Situation:

This coming weekend the Patriots and Giants will be playing in the Super Bowl. The above information gives the weekly statistics of both of the starting quarterbacks that will start in the Super Bowl.

 

Objective:

· Using the above information, you will create a chart in Microsoft Excel identifying: Week Number, Completions, Attempts, Percentage Completed, Yards and the Total for each of the Categories.

· Use a formulas to identify percent completed and totals for each category.

· Create an appropriate graph that compares both teams yards for each week and correctly titled.

· Create other graphs using the information provided

· Save the given charts and graphs

· Print at least one of the graphs that you created.

 

Help:

Formulas

· They are “equations the tell spreadsheet to compute certain information.

         Addition of given cells:   =sum(cell number: cell number)

         Division (percent) of two given cells: =cell number/cell number*100

         Average of given cells: =average(cell number: cell number)

 

Important:

 Don’t forget you may choose to use drag and fill to complete a formula in another cell.

 

Sample:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Creating a Chart

 

1) Choose the Data you would like to include in your graph/chart.

2) Highlight that data using the “ctrl” button and the mouse.

3) Click the “Chart Wizard” button on the toolbar.

4) Choose the type of graph that is appropriate  for your data set.

5) Click “Next”

6) Add Title and titles for the x and y axis.

7) Click “Next”

8) Select “As a New Sheet” button and then give your chart a new name.

9) Click “Finish”

 

Pasting Chart/Graph into another program

 

1) Click on chart on toolbar on the bottom.

2) Click on white part of chart/graph. Then right click on copy.

3) Open other program (Word).

4) Right Click “Paste”

5) Chart/Graph should be on your screen.