Spreadsheet Practice

This table contains data on absences by day of the week.

Day of the week	Week 1	Week2	Week3	Week4	Week5	Week6
Monday	9	5	6	4	8	7
Tuesday	8	4	4	3	3	3
Wednesday	6	2	2	4	4	3
Thursday	5	3	2	1	3	2
Friday	7	7	4	3	4	6

---

Enter the data in the table into a spreadsheet and perform the following calculations:

• Sum the absences for each week.
• Sum the absences for each day.
• Average the absences for each week.
• Average the absences for each day.
• Average the absences over the entire six weeks.

---

Add an additional week of data as follows: 4, 5, 2, 3, 2. How many cells did you have to change to add this new week's worth of data?

Delete the third week of data. How many cells did you have to change?

---

Go in and create a circular reference by making the sum of absences for week 1 include the cell containing the sum. Describe what happens.

---