Name: 
 

Try It Out -- Chapter 3, Lesson 4: Using a Spreadsheet



Matching
 
 
Jesse created a spreadsheet with the world’s population changes from 1950 to 2004.

gr7_ch3_les4-edited_files/i0020000.jpg
A.
Canada’s population over time
E.
population of countries in 1985
B.
Spain’s population over time
F.
population of countries in 1990
C.
Indonesia’s population in 2004
G.
Russia’s population in 1990
D.
population of countries in 2000
H.
Russia’s population in 1995
 

 1. 

What is shown in column F?
 

 2. 

What is shown in row 9?
 

 3. 

What is shown in cell D6?
 

 4. 

What is shown in cell B4?
 

 5. 

What is shown in row 8?
 

 6. 

What is shown in column C?
 

Numeric Response
 
 
Ming’s employer uses the following spreadsheet to schedule her employees.

gr7_ch3_les4-edited_files/i0100000.jpg
 

 7. 

What cell calculates the total number of hours worked by Anna?

 

 8. 

What cell calculates the total number of hours worked on Thursday?

 

 9. 

What formula would be entered to calculate the total number of hours worked by David?

 

True/False
Indicate whether the statement is true or false.
 

 10. 

If you change the number of hours worked by Madelyn on Monday, you do not need to change any other cell in the spreadsheet to update the total number of hours worked by all employees all week.
 



 
Check Your Work     Reset Help