ࡱ>  Root Entry( Jr }튰MatOST`U튰 }튰MMMN0 ND ( JrMicrosoft Works MSWorksWPDoc9q =/=/dCompObjUXc{wrnrnrnrnrnrnjnjnjn( .0FH]_vx FN{w{w{w{w{w{w{w{w{wrwrw( SP #=/d t)T Name ________________ ________________Grade ____ Date ____ Spreadsheet Use Directions: Use your spreadsheet program and the file called Sameshee. Open the file called Sameshee now, and create a header with your name grade and date. 1. Read the scenario. 2. Use the spreadsheet file to respond to the questions below. Scenario: Students at your school have been asked to study the area and population of twelve countries in South America. Use your technology resources to determine the average income level of the most and least populated countries. Type your name in cell A1. 1. Select cell A16, and type the formula =COUNT(B3:B14) to count the number of records in this database. What number did the formula provide? 2. If the URBAN POPULATION % for Peru is increased by 13, about how many people would be living in cities in the twelve countries? 3. What does the formula in cell B18 calculate? 4. To the right of the "People in Cities" column on the spreadsheet, label a new column "Per Capita GDP." In the rows under "Per Capita GDP," enter the following monetary values for each country: $8,600 (for Argentina) $3,000 (for Bolivia) $6,3000 (for Brazil) $8,4000 (for Chile) $5,400 (for Columbia) $4,100 (for Ecuador) $2,490 (for Guyana) $3,200 (for Paraguay) $3,800 (for Peru) $3,150 (for Suriname) $8,000 (for Uruguay) $9,000 (for Venezuela) 5. Which country has the highest average income? Which country has the lowest average income? What conclusion can you draw about urban population and income? 6. In rows 3 through 14 under the "D" column, enter 25 for each cell. Save your file as Same along with your initials. (Example: Samems if your name is Mamie Strong) 7. Using the spreadsheet you have saved, create a chart (graph) containing the following information: Column labels (Country, Area, Population, and Urban Population %). Include the names of only the first six countries listed. Data in all columns from cells A2 through D8. Do not include any other information from your spreadsheet in your chart. Include a title for the chart that includes your name and date. Your chart should be displayed and printed as a separate sheet. Change the page setup to landscape if necessary to make sure all information is on one page. 7. Print your final spreadsheet and chart (graph). Xc{wrnrnrnrnrnrnjnjnjn( .0FH]_vx FN{w{w{w{w{w{w{w{w{wrwrw(   K M | ~  O Q zvzvrvrvrvrvrvrvrvn( CEVXSU`\^qqkcUUUU     H$O.F]vnnnnnnnnnnnnN\^ K | O nnnnnnn   Times New Roman ArialSymbol