Matching
|
|
|
Jesse created a spreadsheet with the world’s population changes from 1950 to
2004.
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.
|
|
|
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.
|