Overview
Zakup samochoduKlasa - funkcje
części PC
Ludność Polski
Wykres z parametrem
Lokata
Ameryka
Sheet 1: Zakup samochodu
| Raty na zakup samochodu | ||||||
| Nazwa | kwota pożyczki | ilość lat spłaty | wysokość raty mies. | ilość miesięcy | całkowita spłata | odsetki |
| WBK | 10,000.00 zł | 5 | 200.00 zł | 60 | 12,000.00 zł | 2,000.00 zł |
| TTT | 15,000.00 zł | 6 | 220.00 zł | 72 | 15,840.00 zł | 840.00 zł |
| PTL | 20,000.00 zł | 7 | 245.00 zł | 84 | 20,580.00 zł | 580.00 zł |
| PTFil | 2,000.00 zł | 4 | 55.00 zł | 48 | 2,640.00 zł | 640.00 zł |
|
||||||
Sheet 2: Klasa - funkcje
| Imię | Nazwisko | Klasa | Polski | Angielski | Niemiecki | Matematyka | Fizyka | Chemia | Biologia | Geografia | Historia | Informatyka | WF | Religia | Średnia | ||||||||||
| Szymon | Peres | O | 4.0 | 3.5 | 4.0 | 3.0 | 6.0 | 2.5 | 5.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.83 | ||||||||||
| Icchak | Rabin | O | 4.0 | 4.5 | 2.0 | 3.0 | 6.0 | 2.5 | 5.5 | 5.0 | 6.0 | 3.0 | 1.5 | 2.5 | 3.79 | 
|
|||||||||
| Samuel | Rotszwanc | O | 5.0 | 3.5 | 4.0 | 2.0 | 5.0 | 1.5 | 4.5 | 3.5 | 3.5 | 3.5 | 3.5 | 4.0 | 3.63 | ||||||||||
| Lejzorek | Apfelbaum | O | 5.5 | 4.5 | 3.0 | 1.5 | 3.5 | 4.5 | 1.5 | 4.5 | 5.0 | 3.0 | 2.5 | 4.0 | 3.58 | ||||||||||
| Jakub | Berman | O | 3.0 | 3.5 | 4.0 | 1.0 | 3.0 | 4.0 | 1.5 | 5.0 | 4.5 | 4.5 | 5.0 | 1.5 | 3.38 | ||||||||||
| Marian | Spychalski | O | 3.0 | 1.0 | 3.0 | 1.5 | 3.5 | 4.5 | 2.0 | 6.0 | 5.0 | 6.0 | 2.5 | 1.0 | 3.25 | ||||||||||
| Hilary | Minc | O | 2.5 | 2.0 | 1.0 | 2.5 | 5.5 | 2.0 | 5.0 | 4.0 | 5.5 | 2.0 | 1.5 | 2.0 | 2.96 | ||||||||||
| Benon | Tejkowski | O | 2.0 | 3.0 | 5.5 | 4.5 | 2.5 | 3.5 | 1.0 | 2.5 | 4.0 | 1.0 | 4.5 | 1.0 | 2.92 | ||||||||||
| Ben | Bella | O | 2.0 | 3.0 | 5.0 | 4.0 | 2.5 | 3.0 | 2.0 | 3.5 | 2.5 | 1.0 | 4.0 | 2.0 | 2.88 | ||||||||||
| Saddam | Husajn | O | 1.0 | 5.0 | 2.0 | 2.0 | 3.5 | 5.0 | 2.0 | 3.0 | 3.0 | 3.0 | 3.0 | 2.0 | 2.88 | ||||||||||
| Huari | Bumedien | O | 2.0 | 2.5 | 4.0 | 1.0 | 2.5 | 4.0 | 1.0 | 4.5 | 4.0 | 2.5 | 4.0 | 2.0 | 2.83 | ||||||||||
| Menachem | Begin | O | 4.0 | 3.0 | 1.0 | 5.0 | 2.5 | 4.5 | 2.0 | 3.5 | 2.5 | 1.0 | 3.0 | 1.5 | 2.79 | ||||||||||
| Artur | Rubinstein | O | 3.0 | 5.0 | 3.5 | 2.5 | 2.5 | 1.5 | 1.0 | 2.5 | 4.0 | 1.0 | 2.5 | 3.5 | 2.71 | ||||||||||
| Golda | Meier | O | 3.0 | 4.0 | 2.0 | 1.5 | 4.5 | 1.0 | 4.0 | 2.0 | 4.5 | 1.5 | 2.5 | 2.0 | 2.71 | ||||||||||
| Hafez | Assad | O | 2.0 | 2.5 | 1.0 | 2.0 | 5.0 | 1.5 | 4.5 | 3.0 | 5.0 | 1.0 | 1.5 | 2.0 | 2.58 | ||||||||||
| Muammar | Kaddafi | O | 1.0 | 1.0 | 3.5 | 1.5 | 3.5 | 4.5 | 2.0 | 1.5 | 5.0 | 2.5 | 3.0 | 1.0 | 2.50 | ||||||||||
| Yehudi | Menuhin | O | 2.0 | 1.5 | 5.5 | 2.0 | 4.0 | 5.0 | 2.5 | 1.0 | 1.0 | 1.0 | 1.0 | 3.0 | 2.46 | ||||||||||
| Gamal | Naser | O | 1.0 | 1.0 | 5.0 | 1.0 | 2.5 | 4.0 | 1.0 | 1.5 | 4.0 | 1.5 | 2.0 | 2.0 | 2.21 | ||||||||||
| Arcymistrz | Tartakower | O | 2.0 | 3.0 | 3.0 | 2.0 | 1.0 | 1.0 | 1.0 | 3.0 | 1.5 | 1.0 | 2.0 | 2.0 | 1.88 | ||||||||||
| Wiesław | Walendziak | P | 3.5 | 2.5 | 4.5 | 2.0 | 4.0 | 5.0 | 2.5 | 5.5 | 5.5 | 5.5 | 5.5 | 5.0 | 4.25 | ||||||||||
| Włodzimierz | Cimoszewicz | P | 4.0 | 2.0 | 5.0 | 2.0 | 4.0 | 5.0 | 2.5 | 6.0 | 6.0 | 6.0 | 6.0 | 1.0 | 4.13 | ||||||||||
| Jan | Olszewski | P | 5.0 | 4.5 | 4.0 | 1.0 | 3.0 | 4.0 | 1.5 | 5.5 | 4.5 | 5.5 | 5.5 | 5.0 | 4.08 | ||||||||||
| Lech | Falandysz | P | 6.0 | 5.0 | 3.0 | 3.0 | 6.0 | 2.5 | 5.5 | 3.0 | 6.0 | 2.5 | 2.5 | 4.0 | 4.08 | ||||||||||
| Jerzy | Buzek | P | 4.0 | 4.5 | 5.5 | 6.0 | 3.5 | 5.5 | 3.0 | 3.0 | 3.5 | 3.0 | 2.0 | 4.0 | 3.96 | ||||||||||
| Tadeusz | Mazowiecki | P | 4.5 | 3.5 | 3.5 | 2.0 | 4.0 | 5.0 | 2.0 | 4.5 | 4.5 | 4.5 | 4.5 | 5.0 | 3.96 | ||||||||||
| Jan Maria | Rokita | P | 5.0 | 3.5 | 4.0 | 1.0 | 3.0 | 4.0 | 1.5 | 6.0 | 4.5 | 6.0 | 2.0 | 5.5 | 3.83 | ||||||||||
| Stefan | Niesiołowski | P | 4.0 | 3.5 | 4.0 | 2.5 | 5.5 | 2.0 | 5.0 | 3.5 | 3.5 | 3.5 | 3.5 | 5.5 | 3.83 | ||||||||||
| Marek | Borowski | P | 5.0 | 5.0 | 3.0 | 1.5 | 3.5 | 4.5 | 2.0 | 5.5 | 5.0 | 5.0 | 2.5 | 2.5 | 3.75 | ||||||||||
| Józef | Oleksy | P | 4.0 | 4.0 | 4.0 | 2.0 | 5.0 | 1.5 | 4.5 | 3.0 | 5.0 | 6.0 | 2.0 | 3.5 | 3.71 | ||||||||||
| Jan Maria | Jackowski | P | 5.0 | 4.0 | 4.0 | 4.5 | 2.0 | 4.0 | 1.5 | 2.5 | 2.0 | 6.0 | 1.5 | 6.0 | 3.58 | ||||||||||
| Mieczysław | Wachowski | P | 4.0 | 1.0 | 6.0 | 5.5 | 3.0 | 5.0 | 2.5 | 3.5 | 3.0 | 2.0 | 3.0 | 4.0 | 3.54 | ||||||||||
| Wojciech | Jaruzelski | P | 4.0 | 3.5 | 4.0 | 5.0 | 2.5 | 4.5 | 2.0 | 4.0 | 4.0 | 4.0 | 4.0 | 1.0 | 3.54 | ||||||||||
| Janusz | Korwin-Mikke | P | 6.0 | 4.0 | 5.0 | 5.0 | 2.5 | 4.5 | 2.0 | 3.0 | 2.5 | 1.0 | 2.0 | 4.5 | 3.50 | ||||||||||
| Danuta | Waniek | P | 4.0 | 3.0 | 6.0 | 5.0 | 3.0 | 4.0 | 2.5 | 4.0 | 3.0 | 1.0 | 5.0 | 1.0 | 3.46 | ||||||||||
| Marek | Jurek | P | 5.0 | 3.5 | 1.5 | 4.5 | 2.0 | 4.0 | 1.5 | 3.0 | 2.0 | 5.5 | 2.5 | 6.0 | 3.42 | ||||||||||
| Jacek | Kuroń | P | 5.0 | 3.0 | 2.0 | 3.5 | 1.0 | 3.0 | 6.0 | 6.0 | 1.0 | 4.0 | 1.5 | 4.5 | 3.38 | ||||||||||
| Izabela | Sierakowska | P | 4.5 | 3.5 | 4.0 | 1.0 | 3.0 | 4.0 | 1.0 | 5.5 | 4.5 | 3.5 | 4.5 | 1.0 | 3.33 | ||||||||||
| Włodzimierz | Messner | P | 4.0 | 3.5 | 4.0 | 4.5 | 2.0 | 4.0 | 1.5 | 3.5 | 3.5 | 3.5 | 3.5 | 2.5 | 3.33 | ||||||||||
| Hanna | Suchocka | P | 4.5 | 5.0 | 4.0 | 1.0 | 2.5 | 4.0 | 1.0 | 3.5 | 4.0 | 1.5 | 3.5 | 5.0 | 3.29 | ||||||||||
| Lech | Wałęsa | P | 6.0 | 1.0 | 3.0 | 1.5 | 3.0 | 4.5 | 1.5 | 4.0 | 4.5 | 2.0 | 2.5 | 6.0 | 3.29 | ||||||||||
| Aleksander | Kwaśniewski | P | 5.0 | 3.5 | 1.5 | 3.0 | 3.0 | 3.0 | 3.5 | 2.5 | 5.0 | 2.0 | 5.0 | 2.0 | 3.25 | ||||||||||
| Jarosław | Kalinowski | P | 3.0 | 1.0 | 6.0 | 5.5 | 3.0 | 5.0 | 2.5 | 3.0 | 3.0 | 2.0 | 2.0 | 3.0 | 3.25 | ||||||||||
| Leszek | Balcerowicz | P | 4.5 | 4.5 | 2.5 | 3.5 | 1.0 | 3.0 | 6.0 | 3.0 | 1.0 | 3.5 | 2.5 | 3.5 | 3.21 | ||||||||||
| Leszek | Bubel | P | 3.0 | 2.0 | 3.0 | 1.5 | 3.5 | 4.5 | 2.0 | 5.0 | 5.0 | 4.0 | 2.5 | 2.0 | 3.17 | ||||||||||
| Józef | Cyrankiewicz | P | 2.0 | 3.5 | 4.5 | 1.5 | 4.5 | 1.0 | 4.0 | 3.0 | 4.5 | 5.0 | 2.0 | 2.0 | 3.13 | ||||||||||
| Grzegorz | Kołodko | P | 4.5 | 4.5 | 5.0 | 1.0 | 2.5 | 4.0 | 1.0 | 2.5 | 4.0 | 1.5 | 3.0 | 3.5 | 3.08 | ||||||||||
| Józef | Pińkowski | P | 2.0 | 4.5 | 3.0 | 1.5 | 3.0 | 4.5 | 1.5 | 3.0 | 4.5 | 5.5 | 2.0 | 2.0 | 3.08 | ||||||||||
| Waldemar | Pawlak | P | 2.0 | 3.5 | 4.0 | 4.0 | 1.5 | 3.5 | 1.0 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.08 | ||||||||||
| Jan | Bielecki | P | 5.0 | 4.5 | 3.0 | 4.0 | 1.5 | 3.5 | 1.0 | 2.5 | 1.5 | 5.0 | 1.5 | 3.5 | 3.04 | ||||||||||
| Edward | Osóbka-Morawski | P | 5.0 | 2.0 | 3.0 | 1.0 | 4.0 | 6.0 | 3.5 | 1.0 | 4.0 | 1.5 | 1.5 | 3.5 | 3.00 | ||||||||||
| Barbara | Labuda | P | 4.0 | 3.0 | 4.5 | 3.5 | 2.5 | 2.5 | 1.0 | 2.5 | 4.0 | 1.0 | 3.5 | 2.5 | 2.88 | ||||||||||
| Marek | Belka | P | 4.0 | 5.0 | 2.0 | 4.0 | 1.5 | 3.5 | 1.0 | 3.0 | 1.5 | 4.5 | 2.5 | 2.0 | 2.88 | ||||||||||
| Jarosław | Kaczyński | P | 4.0 | 3.5 | 4.0 | 1.0 | 3.0 | 4.0 | 1.5 | 1.0 | 4.5 | 1.5 | 2.0 | 3.5 | 2.79 | ||||||||||
| Mieczysław | Rakowski | P | 4.0 | 2.0 | 3.5 | 1.5 | 3.5 | 4.5 | 2.0 | 1.0 | 5.0 | 1.5 | 3.0 | 2.0 | 2.79 | ||||||||||
| Piotr | Jaroszewicz | P | 3.0 | 6.0 | 1.0 | 2.0 | 3.5 | 4.5 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.67 | ||||||||||
| Edward | Babiuch | P | 3.0 | 1.0 | 5.0 | 1.0 | 2.5 | 5.5 | 1.0 | 2.5 | 4.0 | 1.5 | 1.0 | 1.0 | 2.42 | ||||||||||
| Andrzej | Lepper | P | 2.0 | 1.0 | 2.5 | 1.5 | 2.5 | 4.0 | 1.0 | 2.5 | 4.0 | 1.0 | 1.5 | 3.5 | 2.25 | ||||||||||
| David | Robinson | S | 2.0 | 5.0 | 4.0 | 6.0 | 3.5 | 5.0 | 3.0 | 4.5 | 3.5 | 1.0 | 6.0 | 4.0 | 3.96 | ||||||||||
| Vytautas | Gerulaitis | S | 1.0 | 3.0 | 4.0 | 2.0 | 4.0 | 5.0 | 2.5 | 5.0 | 5.0 | 5.0 | 5.0 | 4.0 | 3.79 | ||||||||||
| Patrick | Ewing | S | 2.0 | 3.5 | 4.0 | 6.0 | 3.5 | 5.5 | 3.0 | 3.5 | 3.5 | 3.5 | 3.5 | 2.0 | 3.63 | ||||||||||
| Joe | Ctvrtlik | S | 2.0 | 5.0 | 5.0 | 1.0 | 4.0 | 6.0 | 3.5 | 3.0 | 4.0 | 4.0 | 2.0 | 2.5 | 3.50 | ||||||||||
| Darius | Kaparaitis | S | 2.0 | 4.5 | 5.0 | 5.5 | 2.5 | 4.5 | 1.0 | 2.5 | 4.0 | 1.0 | 5.5 | 3.5 | 3.46 | ||||||||||
| Raimonds | Miglinieks | S | 2.0 | 3.5 | 4.0 | 1.0 | 4.0 | 6.0 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.46 | ||||||||||
| Steve | Kerr | S | 2.0 | 4.0 | 3.0 | 2.0 | 3.5 | 5.0 | 2.0 | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | 3.46 | ||||||||||
| Tim | Duncan | S | 1.0 | 3.5 | 4.0 | 3.5 | 1.0 | 3.0 | 6.0 | 3.5 | 3.5 | 3.5 | 3.5 | 4.5 | 3.38 | ||||||||||
| Zyndrunas | Ilgauskas | S | 1.0 | 3.5 | 1.0 | 5.5 | 3.0 | 5.0 | 2.5 | 4.0 | 4.0 | 4.0 | 4.0 | 3.0 | 3.38 | ||||||||||
| Kobe | Bryant | S | 2.0 | 4.0 | 3.5 | 2.5 | 5.5 | 2.0 | 5.0 | 3.0 | 5.5 | 1.5 | 2.5 | 3.0 | 3.33 | ||||||||||
| Shaquille | O'Neill | S | 2.0 | 4.5 | 2.5 | 2.0 | 3.5 | 5.0 | 2.0 | 3.5 | 3.5 | 3.5 | 3.5 | 4.5 | 3.33 | ||||||||||
| Ronnie | Ftorek | S | 2.5 | 3.5 | 4.0 | 1.5 | 4.5 | 1.0 | 4.0 | 3.5 | 3.5 | 3.5 | 3.5 | 4.0 | 3.25 | ||||||||||
| John | Stockton | S | 2.0 | 5.0 | 3.0 | 1.5 | 3.0 | 4.5 | 1.5 | 2.5 | 4.5 | 4.5 | 2.0 | 3.5 | 3.13 | ||||||||||
| Ainards | Bagatskis | S | 2.0 | 4.0 | 1.0 | 2.0 | 3.5 | 4.0 | 2.5 | 5.0 | 1.0 | 1.0 | 5.0 | 4.0 | 2.92 | ||||||||||
| Joe | Nieuwendyk | S | 2.0 | 4.5 | 3.0 | 1.5 | 3.0 | 4.0 | 1.5 | 2.0 | 4.5 | 3.5 | 2.0 | 3.5 | 2.92 | ||||||||||
| Karl | Malone | S | 2.0 | 5.0 | 3.0 | 1.5 | 3.0 | 4.5 | 1.5 | 3.5 | 4.5 | 1.0 | 2.5 | 3.0 | 2.92 | ||||||||||
| Roberts | Stelmahers | S | 2.0 | 5.5 | 1.5 | 2.0 | 3.5 | 5.0 | 2.0 | 2.5 | 2.5 | 2.5 | 2.5 | 3.5 | 2.92 | ||||||||||
| Allan | Iverson | S | 1.0 | 5.0 | 2.0 | 1.0 | 2.5 | 1.5 | 4.0 | 2.5 | 3.5 | 1.0 | 6.0 | 3.0 | 2.75 | ||||||||||
| Jeff | Hornacek | S | 2.0 | 5.0 | 3.0 | 1.0 | 3.0 | 4.0 | 1.5 | 1.5 | 4.5 | 2.5 | 2.0 | 2.0 | 2.67 | ||||||||||
| Avery | Johnson | S | 2.0 | 5.0 | 4.0 | 3.0 | 2.0 | 2.0 | 1.5 | 3.0 | 2.0 | 1.0 | 3.0 | 3.0 | 2.63 | ||||||||||
| Średnia | |||||||||||||||||||||||||
| Klasy | O | P | S | 3.22 | |||||||||||||||||||||
| Średnia | 2.93 | 3.35 | 3.24 | ||||||||||||||||||||||
Sheet 3: części PC
| Kalkulacja zakupu PC | |||||||||||||
| Obniżka cen wszystkich elementów: | 15% | ||||||||||||
| Nazwa elementu | Ilość zakupionych sztuk | Cena bez obniżki | Cena elementu po obniżce | Wartość zakupu | Udział pozycji w wydatku | 
|
|||||||
| pamięć RAM | 4 | 357.00 zł | 303.45 zł | 1,213.80 zł | 46% | ||||||||
| procesor | 1 | 525.00 zł | 446.25 zł | 446.25 zł | 17% | ||||||||
| płyta główna | 1 | 212.00 zł | 180.20 zł | 180.20 zł | 7% | ||||||||
| dysk twardy | 2 | 385.00 zł | 327.25 zł | 654.50 zł | 25% | ||||||||
| CD ROM | 2 | 85.00 zł | 72.25 zł | 144.50 zł | 6% | ||||||||
| DVD | 1 | 163.00 zł | 138.55 zł | 138.55 zł | 5% | ||||||||
| obudowa | 1 | 125.00 zł | 106.25 zł | 106.25 zł | 4% | ||||||||
| złączka | 8 | 0.15 zł | 0.13 zł | 1.02 zł | 0% | ||||||||
| wkręt | 14 | 0.07 zł | 0.06 zł | 0.83 zł | 0% | ||||||||
| podkładki | 32 | 0.20 zł | 0.17 zł | 5.44 zł | 0% | ||||||||
| kabel | 12 | 3.50 zł | 2.98 zł | 35.70 zł | 1% | ||||||||
| monitor | 1 | 773.00 zł | 657.05 zł | 657.05 zł | 25% | ||||||||
| drukarka | 1 | 458.00 zł | 389.30 zł | 389.30 zł | 15% | ||||||||
| Suma do zapłacenia: | 2,623.88 zł | 3,973.39 zł | |||||||||||
|
|||||||||||||
Sheet 4: Ludność Polski
| POLSKA - podział, powierzchnia, ludność | ||||||
| Województwo | Powierzchnia w km2 | Ludność (1999 r.) | ||||
| w tys. | Liczba osób na 1 km2 | Ludność w miastach - % | Ludność w miastach - w tys. | Procent wszystkich obywateli | ||
| Dolnośląskie | 19948 | 2978 | 149 | 72 | 214416 | 7.70% |
| Kujawsko-pomorskie | 17970 | 2101 | 117 | 62 | 130262 | 5.44% |
| Lubelskie | 25114 | 2235 | 89 | 46 | 102810 | 5.78% |
| Lubuskie | 13984 | 1024 | 73 | 65 | 66560 | 2.65% |
| Łódzkie | 18219 | 2653 | 146 | 65 | 172445 | 6.86% |
| Małopolskie | 15144 | 3223 | 213 | 51 | 164373 | 8.34% |
| Mazowieckie | 35598 | 5070 | 142 | 64 | 324480 | 13.12% |
| Opolskie | 9412 | 1088 | 116 | 53 | 57664 | 2.81% |
| Podkarpackie | 17926 | 2126 | 119 | 41 | 87166 | 5.50% |
| Podlaskie | 20180 | 1223 | 61 | 58 | 70934 | 3.16% |
| Pomorskie | 18293 | 2191 | 120 | 69 | 151179 | 5.67% |
| Śląskie | 12294 | 4866 | 396 | 80 | 389280 | 12.59% |
| Świętokrzyskie | 11672 | 1323 | 113 | 46 | 60858 | 3.42% |
| Warmińsko-mazurskie | 24203 | 1466 | 61 | 60 | 87960 | 3.79% |
| Wielkopolskie | 29826 | 3355 | 112 | 58 | 194590 | 8.68% |
| Zachodniopomorskie | 22902 | 1733 | 76 | 70 | 121310 | 4.48% |
| Razem | 312685 | 38655 | 2396287 | 100.00% | ||
| Źródło: Świat w liczbach 2000/2001, WSiP, Warszawa 1999. | ||||||
Sheet 5: Wykres z parametrem
| Przedstaw szablon do wykreślania funkcji z parametrem n postaci: | |||||||||||||||||||||
| y = x^n - nx^2+3 | dla x z przedziału <-4;4> | ||||||||||||||||||||
| zaprezentuj wykres dla n=1 i wyznacz miejsca zerowe | |||||||||||||||||||||
| dla wartości x od 0 do 3 narysuj wykres kolumnowy | |||||||||||||||||||||
| n= | 1 | ||||||||||||||||||||
| x | y | 
|
|
||||||||||||||||||
| -3 | -9 | ||||||||||||||||||||
| -1 | 1 | ||||||||||||||||||||
| 1 | 3 | ||||||||||||||||||||
| 3 | -3 | ||||||||||||||||||||
| 5 | -17 | ||||||||||||||||||||
| 7 | -39 | ||||||||||||||||||||
| 9 | -69 | ||||||||||||||||||||
| 11 | -107 | ||||||||||||||||||||
| 13 | -153 | ||||||||||||||||||||
| 15 | -207 | ||||||||||||||||||||
| 17 | -269 | ||||||||||||||||||||
| 19 | -339 | ||||||||||||||||||||
| 21 | -417 | ||||||||||||||||||||
| 23 | -503 | ||||||||||||||||||||
| 25 | -597 | ||||||||||||||||||||
| 27 | -699 | ||||||||||||||||||||
| 29 | -809 | ||||||||||||||||||||
|
|||||||||||||||||||||
Sheet 6: Lokata
| 1) Wpłacamy w banku na lokatę 1000 złotych. | |||||
| Każdego roku dopisywane są odsetki w wysokości 8% (parametr). | |||||
| 2) Przedstaw symulację kwoty lokaty po 1-roku, 2-latach, 3-latach, ... 10-latach. | |||||
| 3) Wstaw formuły do liczenia odsetek dla dowolnego oprocentowania w F7 | |||||
| Kwota: | 1000 | % odsetek | 8 | ||
| rok | kwota | odsetki | |||
| 1 | 1,080.00 zł | 80.00 zł | |||
| 2 | 1,166.40 zł | 166.40 zł | |||
| 3 | 1,259.71 zł | 259.71 zł | |||
| 4 | 1,360.49 zł | 360.49 zł | |||
| 5 | 1,469.33 zł | 469.33 zł | |||
| 6 | 1,586.87 zł | 586.87 zł | |||
| 7 | 1,713.82 zł | 713.82 zł | |||
| 8 | 1,850.93 zł | 850.93 zł | |||
| 9 | 1,999.00 zł | 999.00 zł | |||
| 10 | 2,158.92 zł | 1,158.92 zł |
Sheet 7: Ameryka
| Dane statystyczne krajów Ameryk | ||||||||||||||||
| "Świat w liczbach 1996/1997", W-wa 1997 WSiP | ||||||||||||||||
| Ameryka Północna i Środkowa | ||||||||||||||||
| Kraj | powierzchnia w tys. km kw. |
ludność w tys. | ilość osób na 1 km kw. | stolica (główne miasto) | ludność stolicy w tys. | % ludności stolicy | dochód / mieszk. w $ USA |
razem PKB | Udział procentowy powierzchni kraju do powierzchni całego kontynentu | 
|
||||||
| Antigua i Barbuda | 0.44 | 68 | 155 | Saint John's | 22 | 32% | 6000 | 408000 | 0.002% | |||||||
| Bahamy | 13.9 | 276 | 20 | Nassau | 172 | 62% | 12100 | 3339600 | 0.062% | |||||||
| Barbados | 0.43 | 262 | 609 | Bridgetown | 7 | 3% | 6550 | 1716100 | 0.002% | |||||||
| Belize | 227 | 215 | 1 | Belmopan | 4 | 2% | 2200 | 473000 | 1.020% | |||||||
| Dominika | 0.8 | 78 | 98 | Roseau | 16 | 21% | 2500 | 195000 | 0.004% | |||||||
| Dominikana | 48.5 | 7823 | 161 | Santo Santiago | 2412 | 31% | 1050 | 8214150 | 0.218% | |||||||
| Grenada | 0.34 | 92 | 271 | Saint George's | 36 | 39% | 2300 | 211600 | 0.002% | |||||||
| Gwatemala | 109.9 | 10621 | 97 | Gwatemala | 2018 | 19% | 1000 | 10621000 | 0.494% | |||||||
| Haiti | 27.8 | 7180 | 258 | Port-au-Prince | 1255 | 17% | 400 | 2872000 | 0.125% | |||||||
| Honduras | 112.1 | 5950 | 53 | Tegucigalpa | 800 | 13% | 600 | 3570000 | 0.504% | |||||||
| Jamajka | 11 | 2530 | 230 | Kingston | 588 | 23% | 1350 | 3415500 | 0.049% | |||||||
| Kanada | 9976.1 | 29610 | 3 | Ottawa | 921 | 3% | 19010 | 562886100 | 44.829% | |||||||
| Kostaryka | 51.1 | 3424 | 67 | San Jose | 922 | 27% | 2000 | 6848000 | 0.230% | |||||||
| Kuba | 110.9 | 11041 | 100 | Hawana | 2176 | 20% | 800 | 8832800 | 0.498% | |||||||
| Meksyk | 1958.2 | 94780 | 48 | Meksyk | 20200 | 21% | 2600 | 246428000 | 8.799% | |||||||
| Nikaragua | 130 | 4540 | 35 | Managua | 625 | 14% | 350 | 1589000 | 0.584% | |||||||
| Panama | 75.5 | 2631 | 35 | Panama | 541 | 21% | 2400 | 6314400 | 0.339% | |||||||
| Portoryko | 8.9 | 3690 | 415 | San Juan | 1086 | 29% | 6600 | 24354000 | 0.040% | |||||||
| Saint Kitts i Nevis | 0.3 | 41 | 137 | Basseterre | 15 | 37% | 3900 | 159900 | 0.001% | |||||||
| Saint Lucia | 0.6 | 142 | 237 | Castries | 54 | 38% | 2900 | 411800 | 0.003% | |||||||
| Saint Vincent i Grenadyny | 0.4 | 112 | 280 | Kingston | 27 | 24% | 2000 | 224000 | 0.002% | |||||||
| Salwador | 21 | 5768 | 275 | San Salwador | 1522 | 26% | 1200 | 6921600 | 0.094% | |||||||
| Stany Zjedn. Ameryki | 9363.5 | 263030 | 28 | Waszyngton | 4474 | 2% | 26430 | 6951882900 | 42.076% | |||||||
| Trynidad i Tobago | 5.1 | 1306 | 256 | Port of Spain | 150 | 11% | 3950 | 5158700 | 0.023% | |||||||
| razem | 22253.81 | 455210 | 3867 | 40043 | 110190 | 100.000% | ||||||||||
| Ameryka Południowa | ||||||||||||||||
| powierzchnia w tys. km kw. |
ludność | ludność na 1 km kw. | stolica (główne miasto) | ludność w tys. | dochód/mieszk. w $ USA | razem PKB | Udział procentowy powierzchni kraju do powierzchni całego kontynentu | |||||||||
| Argentyna | 2766.9 | 34587 | 13 | Buenos Aires | 11662 | 34% | 2600 | 89926200 | 15.617% | |||||||
| Boliwia | 1098.6 | 7414 | 7 | La Paz | 2100 | 28% | 700 | 5189800 | 6.201% | |||||||
| Brazylia | 8512 | 161790 | 19 | Brasilia | 1598 | 1% | 2800 | 453012000 | 48.045% | |||||||
| Chile | 756.9 | 14210 | 19 | Santiago | 5181 | 36% | 2750 | 39077500 | 4.272% | |||||||
| Ekwador | 283.6 | 11460 | 40 | Quito | 1101 | 10% | 1100 | 12606000 | 1.601% | |||||||
| Guana | 215 | 835 | 4 | Georgtown | 236 | 28% | 330 | 275550 | 1.214% | |||||||
| Kolumbia | 1138.9 | 35101 | 31 | Bogota | 5132 | 15% | 1330 | 46684330 | 6.428% | |||||||
| Paragwaj | 406.8 | 4960 | 12 | Asuncion | 638 | 13% | 1400 | 6944000 | 2.296% | |||||||
| Peru | 1285.23 | 23532 | 18 | Lima | 6484 | 28% | 950 | 22355400 | 7.254% | |||||||
| Surinam | 163.3 | 423 | 3 | Paramaribo | 211 | 50% | 4300 | 1818900 | 0.922% | |||||||
| Urugwaj | 177.4 | 3186 | 18 | Montevideo | 1384 | 43% | 3340 | 10641240 | 1.001% | |||||||
| Wenezuela | 912.1 | 21844 | 24 | Caracas | 3188 | 15% | 2910 | 63566040 | 5.148% | |||||||
| razem | 17716.73 | 319342 | 207 | 38915 | 24510 | 752096960 | 100.000% | |||||||||
Wyszukiwarka
Podobne podstrony:
past continuous exc
KTM 250 525 SX MXC EXC 2003 Repair Manual
ĆW 1 EXC
ćw 1 exc
EXC 01 r
EXC 02 r
EXC 04 r
EXC 02
EXC 01
EXC 04
EXC 05
exc cw5b
EXC 05 r
oddana exc
exc cw3a
exc cw3
exc cw3b
exc cw4
więcej podobnych podstron