Excel is a program used to make graphs and do calculations and interpret data.

Each box on the spreadsheet is the intersection of a row and a column and is called a cell.
Each cell is named by the letter of the column and the number of the row, such as cell D4.
You can enter words, numbers, or formulas into the cells.
Than you can graph the data in charts such as pie, bar, line, or column graphs.
Work with me to do the following spreadsheets:

Excel Stats:

  1. Pretend you are figuring your football/powderpuff stats.
  2. Make a spreadsheet to show your stats as listed in the 1st chart.
  3. Make the columns wider as needed.
  4. Bold the title and subtitles
  5. Merge and center the main title.
  6. Add formulas to find the Totals.
  7. Copy the entire table and place it below the 1st table on the spreadsheet.
  8. Change the numbers as they appear in the second spreadsheet below. Watch how the Totals change.
  9. Use your data on the top table to make line graphs to compare your Yards Rushing and Yards Passing.

Priscilla Taylor's Football Stats


5-Nov
12-Nov
19-Nov
26-Nov
3-Dec
Totals

Yards Rushing
125
115
137
155
175


Yards Passing
115
130
150
125
155


Tackles
12
10
15
11
15


Interceptions
1
2
3
0
2


Blocked Kicks
0
1
2
1
1


Touchdowns
2
1
3
2
3










Priscilla Taylor's Football Stats

5-Nov
12-Nov
19-Nov
26-Nov
3-Dec
Totals

Yards Rushing
115
145
155
145
175


Yards Passing
125
135
125
115
150


Tackles
11
15
12
10
14


Interceptions
0
2
2
1
1


Blocked Kicks
0
2
1
0
0


Touchdowns
1
2
2
3
4



Excel Grades:

  1. Pretend you are averaging your grades.
  2. Make a spreadsheet to show your grades as listed in the 1st chart.
  3. Make the columns wider as needed.
  4. Bold the title, subtitles, and the word Average.
  5. Merge and center the main title.
  6. Add a bottom border below the subtitles.
  7. Add a top and bottom border on the Average line.
  8. Add formulas to find the averages.
  9. Round the averages to 2 decimal places.
  10. Copy the entire table and place it below the 1st table on the spreadsheet.
  11. Change the numbers as they appear in the second spreadsheet below. Watch how the averages change.
  12. Use your data on the top table to make a column graph to show your averages.


Priscilla Taylor's Grades ||

Math
English
Science
History
Computers
Bible

88
95
96
85
75
67

75
95
100
62
75
79

67
54
87
95
67
95

78
65
98
45
67
96

96
95
75
85
98
100

98
96
97
95
85
97
Average













Priscilla Taylor's Grades

Math
English
Science
History
Computers
Bible

98
75
67
75
100
99

97
78
77
100
97
87

96
85
85
95
85
79

85
95
53
85
97
98

74
79
95
79
98
95

57
84
85
65
85
96
Average