Computer Science Illuminated

eLearning
Interactive Review

Animated Flashcards
Live Wire
Cryptic Crossword Puzzles
Ethical Issues
Biographical Sketches
Did You Know?
Goin Live
Digital Lab Manual
Online Glossary
The Learning Store
Language Library
Download PEP/7
Instructor Resources
Student Resources

eLearning Home
Spreadsheet Practice

Spreadsheet Practice

Download the Cover Sheet for this lab as an Adobe PDF. This can be used to record your answers to the questions in the lab.

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.


 
Educators: More Information About This Text Other Computer Science Titles at Jones and Bartlett
Copyright 2019 Jones and Bartlett PublishersContact webmaster