ࡱ> ^   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]Root Entry( Jr@aMatOST`M8@aMMMN0 ND ( JrMicrosoft Works MSWorksWPDoc9q 5xD]@ 5`4]@`4^@ Name ________________ ________________Grade ____ Date ____ Spreadsheet Use Directions: Use your spreadsheet program and the file called Sameshee. Open the file called Sameshee n< !"#$%&'(*+,-./0123456789:;Root Entry!Fdy@Ole PRINT`%CompObjb  !FMicrosoft Excel ChartBiff8Excel.Chart.89qZOh+'0HPh Spreadsheet Use Mamie Strongse Mamie Strongse@Xl@k@slrB%  +   b''  Arial-Arial---Arial-"System-'- b-'- b-'- Q- "-  $ a6- $  $  aa  "- ao oa8 a ag ga/ a a^ ^a' a a "---'--- Q_2-   $a6 a "- $  $  aa ---'-- -  Q "- MM_2-   MMMM $EEVVE_2- SP "" 8 8 8 ɰ``=/d,t7ɰ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? 12 2. If the URBAN POPULATION % for Peru is increased by 13, about how many people would be living in cities in the twelve countries? 4,336,582 3. What does the formula in cell B18 calculate? It calculates the average area of the 12 countries listed. 4. Name the country with the highest population, and give the average income. Brazil, $6,300 Name the country with the lowest population, and give the average income. Suriname, $3,150 Mamie Strong Country Area Population Urban Population (%) People in Cities Per Capita GDP Argentina 1,056,637 36,100,000 25 1,444,000 $8,600 Bolivia 418,680 8,000,000 25 320,000 $3,000 Brazil 3,265,062 162,100,000 25 6,484,000 $63,000 Chile 289,112 14,800,000 25 592,000 $84,000 Columbia 401,042 38,600,000 25 1,544,000 $5,400 Ecuador 106,888 12,200,000 25 488,000 $4,100 Guyana 76,004 700,000 25 28,000 $2,490 Paraguay 135,398 5,200,000 25 208,000 $3,200 Peru 494,208 26,100,000 25 1,044,000 $3,800 Suriname 60,232 400,000 25 16,000 $3,150 Uruguay 67,494 3,200,000 25 128,000 $8,000 Venezuela 340,560 23,300,000 25 932,000 $9,000 12 Total 13,228,000 Average 559,276 27,558,333 1,102,333  Xc{wrnrnrernrernre\ (  djmrxDvqmvqmqmvdvq^XO(  DFhy{  *;=[jlypjypjypjypjypjypjyp 9HJjy{ysjysjysjysjysjysysyypjypjyfa](   CEVXSU`\^qqk]]]]     'QzF{ =lJ{yyyyDss than $5000, and I sorted the URBAN POPULATION % field in desceExcel.Chart.8~ࡱ> =   $EE-  ss_2-  ssss$EV#E "- M3_2-  M3M3$wwD7w3f_2-  3f$EEDwDwE-  s&M_2- s&Ms&M$wD7V7EDwD "-  f_2-  ff$cV_2-  $wwccw- _2- $cVVwcc "-  MM_2-  MMMM$((::(_2-  $((- ss_2- ssss$(:( "-  M3_2-  M3M3$[[~lql[3f_2-  3f$((~[~[(- s&M_2- s&Ms&M$[~lq:q(~[~ "-  f_2-  ff$cV_2-  $[[cc[- _2- $cVlV[cc "-  MM_2-  MMMM$   _2-  $  - ss_2- ssss$   "-  M3_2-  M3M3$?? PP?3f_2-  3f$   ? ? - s&M_2- s&Ms&M$? P  ?  "-  f_2-  ff$qqcVq_2-  $??cqcq?- _2- $qcVPV?cqc "-  MM_2-  MMMM$_2-  $- ss_2- ssss$ "-  M3_2-  M3M3$##f4Y4#3f_2-  3f$f#f#- s&M_2- s&Ms&M$#f4YYf#f "-  f_2-  ff$UUcfVfU_2-  $##cUcU#- _2- $UcfV4V#cUc "-  MM_2-  MMMM$_2-  $- ss_2- ssss$ "-  M3_2-  M3M3$B53f_2-  3f$BB- s&M_2- s&Ms&M$B55BB "-  f_2-  ff$99cJVJ9_2-  $c9c9- _2- $9cJVVc9c "-  MM_2-  MMMM$#_2-  $##- ss_2- ssss$### "-  M3_2-  M3M3$na3f_2-  3f$nn- s&M_2- s&Ms&M$naann "-  f_2-  ff$c.V._2-  $cc- _2- $c.VVcc- - "-88//''-  2 1 2 10 2 )100 2 1,000  2 x10,000  2 y100,000  2 e 1,000,000   2 pX 10,000,000   2 K 100,000,000   2 7 1,000,000,000    6nnRR662  Argentina  2 Bolivia   2 Brazil 2 Chile 2 Columbia  2 Ecuador   --'-- b-----'-- `' +2 /#Mamie Strong 12-22-2000      ---'-- b--'-- b--  ---'--- ---'---  "- _2-  V<  2 `Area---'---  ---'---   "-  3f_2-  3f V< 2 ` Population  ---'-- -  ---'-- -   "- _2-    Vf< 2 [`Urban Population    2 `(%)%---'-- - ---'-- - b---'-- - b-  -' b '  'ObjInfoWorkbook OlePres000)%SummaryInformation( A@\p Mamie Strong Ba=p=a&<X@"1Arial1Arial1Arial1Arial1Arial1sArial1Arial1sArial1Arial1 Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"#,##0;[Red]#,##0"$"#,##0;[Red]"$"#,##0 0;[Red]0                + ) , *     a" a)0 a+4 a+0     a)     Normal_Sheet1`l Chart17Sheet1Sheet2Sheet3`i Mamie StrongCountryArea PopulationUrban Population (%)People in CitiesPer Capita GDP ArgentinaBoliviaBrazilChileColumbiaEcuadorGuyanaParaguayPeruSurinameUruguay VenezuelaTotalAverageX   A@MHP DeskJet 660 (Color)@n,,@MSUD$HP DeskJet 660 (Color)b"d,,??3` 4#` 4#` 4# ?? 3d 3Q:  AreaQ ;Q ;Q3_ O   MM<4E4 3Q:  PopulationQ ;Q ;Q3_ O 3f  MM<4E4 3Q: ,Urban Population (%)Q ;Q ;Q3_ O   MM<4E4D$% M 3O&Q4$% M 3O&Q4FAF * 3OC $ 3 b#M&!  O43*@#M&! M! M NM43" :dd+ Tu3O+ Ti% M,3O&Q423 M NM4444%  PM3O& Q 4Mamie Strong 12-22-2000'44e Argentina Argentina ArgentinaBoliviaBoliviaBoliviaBrazilBrazilBrazilChileChileChileColumbiaColumbiaColumbiaEcuadorEcuadorEcuadore}0A6A9@A^A9@HA@RA9@`A:lA9@HzAgA9@@EgA9@e>  A@  dMbP?_*+%"d,,??U} }  } } m}  }      ,@        }@^9@"6A DD~ @ A^A9@"A DD~ p@  H̥&9@"XA DD~ @  `A:lA9@""A DD~ @  HzA3 9@"@7A DD~ @  @EgA9@"A DD~ @  @@\%A9@"X@  DD~ t@  0A SA9@" d A  D D ~ @  *A99@" @/A  D D ~ @  i@jA9@" @@  D D ~ @  `z@jHA9@" @@  D D ~ @@  @A9@" @q,A D D ~ @#(@ % B  #:iA %   #UUUX!A % B#UUUHzA % B#9@ % B#UUUU0A % B ~ 9@*h"T^^^^^^^^^^^^;S>@7 A@  dMbP?_*+%"??U>@7 A@  dMbP?_*+%"??U>@7 qB%$ e +   g''  ' g' g' b~- "-  $Q<_2 2<Q<- $Q<QD_:_2Q<$_2_: : 2_2~9 "-<Q2_2 !Q_ Q_ Q_ Q_ Q_ Q_ {Qq_q `QU_U DQ:_:  "--'-- b~_2-  $ 2<Q<_2 2 "-~9$Q<QD_:_2Q<$_2_: : 2_2--'-- b~ "-MM_2- MMMM $q9qww5q9_2- $a9aqq9a9-ss_2- ssss$qwgaq "-M3_2- M3M3$9ie593f_2- 3f$q9qii9q9-s&M_2- s&Ms&M$ieweqii "-f_2- ff$959_2- $999-_2- $ "-MM_2- MMMM$959_2- $999-ss_2- ssss$ "-M3_2- M3M3$9{w593f_2- 3f$9{{99-s&M_2- s&Ms&M${ww{{ "-f_2- ff$959_2- $999-_2- $ "-MM_2- MMMM$959_2- $999-ss_2- ssss$ "-M3_2- M3M3$9WS593f_2- 3f$9WW99-s&M_2- s&Ms&M$WSSWW "-f_2- ff$9%%59_2- $999-_2- $% "-MM_2- MMMM$G9GLL5G9_2- $797GG979-ss_2- ssss$GL=7G "-M3_2- M3M3$W9Ws\o\5W93f_2- 3f$G9GsWsW9G9-s&M_2- s&Ms&M$Ws\oLoGsWs "-f_2- ff$g9gll5g9_2- $W9Wgg9W9-_2- $gl\Wg "-MM_2- MMMM$959_2- $~9~9~9-ss_2- ssss$~ "-M3_2- M3M3$9hd593f_2- 3f$9hh99-s&M_2- s&Ms&M$hddhh "-f_2- ff$959_2- $999-_2- $ "-MM_2- MMMM$959_2- $999-ss_2- ssss$ "-M3_2- M3M3$9vr593f_2- 3f$9vv99-s&M_2- s&Ms&M$vrrvv "-f_2- ff$959_2- $999-_2- $-- "-<QDQ<Q<M!Q!MQMQMQMQMQM{Q{M`Q`MDQDMSmall Fonts-  2 7F1 2 A10 2 <1002 51,0002 010,0002 +100,0002 $ 1,000,0002 v 10,000,0002 [ 100,000,0002 ? 1,000,000,000<Q<<Q@Q<@<@<'@'<n@n<@<@2 Bd Argentina2 BBolivia2 BBrazil2 BBChile2 BColumbia2 BEcuador-"System-'-- gArial-----'-- !  +2 Mamie Strong 12-22-2000  ---'-- g--'-- gArial- -  ~9---'- -- }:---'- -- }: "- _2-  \T  2 OArea ---'- --  }:---'- --  }: "-  3f_2-  3f  2  Population ---'- - -  }:---'- - -  }: "- _2-     %2 Urban Population (%)   ---'- - - }:---'- - - g---'- - - g- -' g '  'DocumentSummaryInformation8,Z՜.+,0 PXd lt| 1 Sheet1Sheet2Sheet3Chart1  WorksheetsCharts METAFILEPICTqB$qB% e +   g''  ' g' g' b~- "-  $Q<_2 2<Q<- $Q<QD_:_2Q<$_2_: : 2_2~9 "-<Q2_2 !Q_ Q_ Q_ Q_ Q_ Q_ {Qq_q `QU_U DQ:_:  "--'-- b~_2-  $ 2<Q<_2 2 "-~9$Q<QD_:_2Q<$_2_: : 2_2--'-- b~ "-MM_2- MMMM $q9qww5q9_2- $a9aqq9a9-ss_2- ssss$qwgaq "-M3_2- M3M3$9ie593f_2- 3f$q9qii9q9-s&M_2- s&Ms&M$ieweqii "-f_2- ff$959_2- $999-_2- $ "-MM_2- MMMM$959_2- $999-ss_2- ssss$ "-M3_2- M3M3$9{w593f_2- 3f$9{{99-s&M_2- s&Ms&M${ww{{ "-f_2- ff$959_2- $999-_2- $ "-MM_2- MMMM$959_2- $999-ss_2- ssss$ "-M3_2- M3M3$9WS593f_2- 3f$9WW99-s&M_2- s&Ms&M$WSSWW "-f_2- ff$9%%59_2- $999-_2- $% "-MM_2- MMMM$G9GLL5G9_2- $797GG979-ss_2- ssss$GL=7G "-M3_2- M3M3$W9Ws\o\5W93f_2- 3f$G9GsWsW9G9-s&M_2- s&Ms&M$Ws\oLoGsWs "-f_2- ff$g9gll5g9_2- $W9Wgg9W9-_2- $gl\Wg "-MM_2- MMMM$959_2- $~9~9~9-ss_2- ssss$~ "-M3_2- M3M3$9hd593f_2- 3f$9hh99-s&M_2- s&Ms&M$hddhh "-f_2- ff$959_2- $999-_2- $ "-MM_2- MMMM$959_2- $999-ss_2- ssss$ "-M3_2- M3M3$9vr593f_2- 3f$9vv99-s&M_2- s&Ms&M$vrrvv "-f_2- ff$959_2- $999-_2- $-- "-<QDQ<Q<M!Q!MQMQMQMQMQM{Q{M`Q`MDQDMSmall Fonts-  2 7F1 2 A10 2 <1002 51,0002 010,0002 +100,0002 $ 1,000,0002 v 10,000,0002 [ 100,000,0002 ? 1,000,000,000<Q<<Q@Q<@<@<'@'<n@n<@<@2 Bd Argentina2 BBolivia2 BBrazil2 BBChile2 BColumbia2 BEcuador-"System-'-- gArial-----'-- !  +2 Mamie Strong 12-22-2000  ---'-- g--'-- gArial- -  ~9---'- -- }:---'- -- }: "- _2-  \T  2 OArea ---'- --  }:---'- --  }: "-  3f_2-  3f  2  Population ---'- - -  }:---'- - -  }: "- _2-     %2 Urban Population (%)   ---'- - - }:---'- - - g---'- - - g- -' g '  '% %  Times New Roman Arial ``=/``=/dCompObjU