Lista elevi Aplicati un filtru pe tabel astfel incat sa fie afisati elevii din clasa IXACod_elev Clasa Nume si prenume Media anuaBursa cu media mai mare sau egala cu 9.

10073 IXD DUMITROF C. ELENA-ROXANA 9.50 250000010002 IXA HARITON A. CRISTINA 9.31 250000010047 IXC POPA T. GEORGIANA VIOLETA 9.60 250000010000 IXA POPOV L. LIVIA 9.71 250000010001 IXA PREDA G. MIHAELA ELENA 9.62 250000010074 IXD VIJEA N. GEORGIANA 9.36 250000010048 IXC ALBU M. RALUCA ANDREEA 9.23 200000010003 IXA BELCIN T. DANIELA 9.18 200000010023 IXB BLINDA C. RALUCA MARIA 9.03 200000010075 IXD IOANA V.C. NICOLETA 9.26 200000010050 IXC MATULESCU I. CRISTINA TUDORA 9.20 200000010004 IXA MICU M. DANA 9.12 200000010022 IXB MUNTEANU M. CATALINA MAGNOLIA 9.09 200000010049 IXC OSMAN S. MELEK 9.23 200000010005 IXA SARAFU I. MARIUS 9.00 200000010051 IXC TUDORACHE M. MIHAELA 9.20 200000010052 IXC VLAD ST. ALINA ELENA 9.20 200000010062 IXC ABDULA F. AIDA 8.63 150000010057 IXC BIDILEAC N. IOANA 8.83 150000010080 IXD BOCOI F. MARIANA 8.50 150000010024 IXB BRATU I. ANCA 8.84 150000010076 IXD BUCIU I. IULIA 8.90 150000010078 IXD BUIUCA P. ALEXANDRU 8.70 150000010029 IXB CADAR I. OKSAN 8.53 150000010007 IXA CALOIAN C. ANAMARIA 8.93 150000010006 IXA CAPRITA N. VIVIANA 8.96 150000010061 IXC CICIOMAN GH. ANDREEA 8.71 150000010014 IXA CODREANU E. OANA IRINA 8.68 150000010070 IXC DARABAN C. COSTACHE MONICA 8.23 150000010016 IXA DEDU D. RARES ADOLF 8.56 150000010083 IXD DOBRE M. GIORGIAN DINU 8.10 150000010027 IXB EFTINOIU S. ALEXANDRU 8.59 150000010056 IXC ENACHE M. RALUCA 8.85 150000010009 IXA FILIP S. NICOLETA 8.84 150000010019 IXA FRATILA N. ANCA 8.36 150000010040 IXB FULINA D. MARIA 8.18 150000010037 IXB FURTUNA T. ANDREI 8.25 150000010035 IXB GADEI M. ANDRA MIHAELA 8.34 150000010060 IXC GHEORGHE N. NICOLETA 8.73 150000010082 IXD GHINEA M. LIVIU 8.13 150000010068 IXC GRASU P. PAULA CRISTINA 8.33 150000010071 IXC HOMOC N. NICOLETA ADINA 8.23 150000010065 IXC ISPAS N. VIORICA MARINELA 8.40 150000010058 IXC JOIAN A. ANDREEA ALEXANDRA 8.76 150000010055 IXC JURAVLE N. CATALINA 8.86 150000010039 IXB LATES D. SIMONA ELENA 8.21 150000010010 IXA LEFTER G. OLGA DELIA 8.78 150000010081 IXD MANOLE M. MIHAELA LUMINITA 8.50 150000010018 IXA MARESAL V. IRINA 8.40 150000010031 IXB MICU T. ANA MARIA 8.50 150000010059 IXC MUNTEANU A. SILVIA CORINA 8.76 150000010026 IXB NEACSU V. ROXANA ELENA 8.65 1500000

Filtrare - selectarea randurilor din tabel, care verifica una sau mai multe conditii.

Se pozitioneaza cursorul pe o culula a randului antet din tabel.Din meniul Data -> Filtrare -> Filtrare automata

Optiunea Particularizare permite construirea conditiilor (selectarea operatorului si a valorii cu care se va face comparatia).

10066 IXC NEGOITA C. IRINA 8.39 150000010030 IXB NICU V. ALEXANDRU 8.53 150000010054 IXC PIROJEC C. MONICA SANDA 8.90 150000010067 IXC POPA C. ANCA 8.36 150000010012 IXA POTOP D. GEORGIANA LAVINIA 8.75 150000010011 IXA PREDA G. IULIA MADALINA 8.78 150000010033 IXB PUFLENI S. COSTINA 8.37 150000010084 IXD RADU V. LILIANA - FLAVIA 8.10 150000010079 IXD ROMANESCU C. IULIA 8.70 150000010063 IXC RUSE A. MIRELA 8.56 150000010038 IXB RUSEN A. BOGDAN 8.25 150000010034 IXB SALOMEA C. DENISA STEFANIA 8.37 150000010015 IXA SAMATA D. ANDRA CRISTINA 8.65 150000010032 IXB SIMION D. MIRCEA 8.50 150000010085 IXD SIMION L. GIORGIANA 8.00 150000010077 IXD STAICU M. LAVINIA 8.76 150000010053 IXC SUCRII S. DENISA-ANDREEA 8.93 150000010008 IXA SURUGIU-BESLEAGA I. IULIANA 8.90 150000010028 IXB TOADER I. MIHAELA 8.59 150000010064 IXC UNGUREANU I. GEORGIANA 8.43 150000010017 IXA URITU G. LIVIU CONSTANTIN 8.43 150000010013 IXA VAJIALA D. SERGIU 8.75 150000010036 IXB VASILE P. DANIEL 8.28 150000010020 IXA VDOVI E. ELEXANDRA 8.31 150000010025 IXB VOAIDES G. ADELA MARIANA 8.78 150000010069 IXC ZAHARIA D. VLAD 8.33 150000010091 IXD BOGDAN E. COSMIN 7.20 50000010087 IXD CIOBANU N. ADRIAN - TUDOR 7.86 50000010088 IXD CIOTA M. ION 7.36 50000010021 IXA COMAN N. ANDREI GABRIEL 7.93 50000010045 IXB COSTICU N. GHEORGHE 7.00 50000010086 IXD ENE C. CIPRIAN ANDREI 7.93 50000010042 IXB MARIN S. ANDREI CRISTIAN 7.71 50000010092 IXD MOTOCU N. MIHAI IULIAN 7.20 50000010041 IXB OPREA V. CATALIN MIHAI 7.96 50000010044 IXB PASCU I. IONUT ANDREI 7.56 50000010043 IXB RACU ALEXANDRU 7.71 50000010089 IXD STRATON C.IONEL GABRIEL 7.33 50000010072 IXC TANELLARI OREST 7.63 50000010090 IXD VASILACHE P. IULIAN CRISTIAN 7.26 50000010046 IXB GUDAMU N. STELIAN 6.9010094 IXD POPESCU GEORGE 6.7610093 IXD RAICAN N. BOGDAN ANDREI 6.93

Aplicati un filtru pe tabel astfel incat sa fie afisati elevii din clasa IXAcu media mai mare sau egala cu 9.

Filtrare - selectarea randurilor din tabel, care verifica una sau mai multe conditii.

Se pozitioneaza cursorul pe o culula a randului antet din tabel.Din meniul Data -> Filtrare -> Filtrare automata

Optiunea Particularizare permite construirea conditiilor (selectarea operatorului si a valorii cu care se va face comparatia).

Lista elevi Aplicati un filtru pe tabel astfel incat sa fie afisati elevii din clasa IXACod_elev Clasa Nume si prenume Media anuaBursa cu media mai mare sau egala cu 9.

10073 IXD DUMITROF C. ELENA-ROXANA 9.50 250000010002 IXA HARITON A. CRISTINA 9.31 2500000 Data / Filter10047 IXC POPA T. GEORGIANA VIOLETA 9.60 250000010000 IXA POPOV L. LIVIA 9.71 250000010001 IXA PREDA G. MIHAELA ELENA 9.62 250000010074 IXD VIJEA N. GEORGIANA 9.36 250000010048 IXC ALBU M. RALUCA ANDREEA 9.23 200000010003 IXA BELCIN T. DANIELA 9.18 200000010023 IXB BLINDA C. RALUCA MARIA 9.03 200000010075 IXD IOANA V.C. NICOLETA 9.26 200000010050 IXC MATULESCU I. CRISTINA TUDORA 9.20 200000010004 IXA MICU M. DANA 9.12 200000010022 IXB MUNTEANU M. CATALINA MAGNOLIA 9.09 200000010049 IXC OSMAN S. MELEK 9.23 200000010005 IXA SARAFU I. MARIUS 9.00 200000010051 IXC TUDORACHE M. MIHAELA 9.20 200000010052 IXC VLAD ST. ALINA ELENA 9.20 200000010062 IXC ABDULA F. AIDA 8.63 150000010057 IXC BIDILEAC N. IOANA 8.83 150000010080 IXD BOCOI F. MARIANA 8.50 150000010024 IXB BRATU I. ANCA 8.84 150000010076 IXD BUCIU I. IULIA 8.90 150000010078 IXD BUIUCA P. ALEXANDRU 8.70 150000010029 IXB CADAR I. OKSAN 8.53 150000010007 IXA CALOIAN C. ANAMARIA 8.93 150000010006 IXA CAPRITA N. VIVIANA 8.96 150000010061 IXC CICIOMAN GH. ANDREEA 8.71 150000010014 IXA CODREANU E. OANA IRINA 8.68 150000010070 IXC DARABAN C. COSTACHE MONICA 8.23 150000010016 IXA DEDU D. RARES ADOLF 8.56 150000010083 IXD DOBRE M. GIORGIAN DINU 8.10 150000010027 IXB EFTINOIU S. ALEXANDRU 8.59 150000010056 IXC ENACHE M. RALUCA 8.85 150000010009 IXA FILIP S. NICOLETA 8.84 150000010019 IXA FRATILA N. ANCA 8.36 150000010040 IXB FULINA D. MARIA 8.18 150000010037 IXB FURTUNA T. ANDREI 8.25 150000010035 IXB GADEI M. ANDRA MIHAELA 8.34 150000010060 IXC GHEORGHE N. NICOLETA 8.73 150000010082 IXD GHINEA M. LIVIU 8.13 150000010068 IXC GRASU P. PAULA CRISTINA 8.33 150000010071 IXC HOMOC N. NICOLETA ADINA 8.23 150000010065 IXC ISPAS N. VIORICA MARINELA 8.40 150000010058 IXC JOIAN A. ANDREEA ALEXANDRA 8.76 150000010055 IXC JURAVLE N. CATALINA 8.86 150000010039 IXB LATES D. SIMONA ELENA 8.21 150000010010 IXA LEFTER G. OLGA DELIA 8.78 150000010081 IXD MANOLE M. MIHAELA LUMINITA 8.50 150000010018 IXA MARESAL V. IRINA 8.40 150000010031 IXB MICU T. ANA MARIA 8.50 150000010059 IXC MUNTEANU A. SILVIA CORINA 8.76 150000010026 IXB NEACSU V. ROXANA ELENA 8.65 1500000

10066 IXC NEGOITA C. IRINA 8.39 150000010030 IXB NICU V. ALEXANDRU 8.53 150000010054 IXC PIROJEC C. MONICA SANDA 8.90 150000010067 IXC POPA C. ANCA 8.36 150000010012 IXA POTOP D. GEORGIANA LAVINIA 8.75 150000010011 IXA PREDA G. IULIA MADALINA 8.78 150000010033 IXB PUFLENI S. COSTINA 8.37 150000010084 IXD RADU V. LILIANA - FLAVIA 8.10 150000010079 IXD ROMANESCU C. IULIA 8.70 150000010063 IXC RUSE A. MIRELA 8.56 150000010038 IXB RUSEN A. BOGDAN 8.25 150000010034 IXB SALOMEA C. DENISA STEFANIA 8.37 150000010015 IXA SAMATA D. ANDRA CRISTINA 8.65 150000010032 IXB SIMION D. MIRCEA 8.50 150000010085 IXD SIMION L. GIORGIANA 8.00 150000010077 IXD STAICU M. LAVINIA 8.76 150000010053 IXC SUCRII S. DENISA-ANDREEA 8.93 150000010008 IXA SURUGIU-BESLEAGA I. IULIANA 8.90 150000010028 IXB TOADER I. MIHAELA 8.59 150000010064 IXC UNGUREANU I. GEORGIANA 8.43 150000010017 IXA URITU G. LIVIU CONSTANTIN 8.43 150000010013 IXA VAJIALA D. SERGIU 8.75 150000010036 IXB VASILE P. DANIEL 8.28 150000010020 IXA VDOVI E. ELEXANDRA 8.31 150000010025 IXB VOAIDES G. ADELA MARIANA 8.78 150000010069 IXC ZAHARIA D. VLAD 8.33 150000010091 IXD BOGDAN E. COSMIN 7.20 50000010087 IXD CIOBANU N. ADRIAN - TUDOR 7.86 50000010088 IXD CIOTA M. ION 7.36 50000010021 IXA COMAN N. ANDREI GABRIEL 7.93 50000010045 IXB COSTICU N. GHEORGHE 7.00 50000010086 IXD ENE C. CIPRIAN ANDREI 7.93 50000010042 IXB MARIN S. ANDREI CRISTIAN 7.71 50000010092 IXD MOTOCU N. MIHAI IULIAN 7.20 50000010041 IXB OPREA V. CATALIN MIHAI 7.96 50000010044 IXB PASCU I. IONUT ANDREI 7.56 50000010043 IXB RACU ALEXANDRU 7.71 50000010089 IXD STRATON C.IONEL GABRIEL 7.33 50000010072 IXC TANELLARI OREST 7.63 50000010090 IXD VASILACHE P. IULIAN CRISTIAN 7.26 50000010046 IXB GUDAMU N. STELIAN 6.9010094 IXD POPESCU GEORGE 6.7610093 IXD RAICAN N. BOGDAN ANDREI 6.93

Aplicati un filtru pe tabel astfel incat sa fie afisati elevii din clasa IXAcu media mai mare sau egala cu 9.

Data / Filter

Valoare vanzariModel Producator 2001 2002 2003 2004

Sempron 2200+ AMD 6,347,200 3,096,800 3,243,600 4,361,428 Athlon XP 1800+ AMD 10,223,700 1,548,400 2,485,100 2,992,000 Athlon AMD 6,719,100 6,719,100 3,933,700 2,992,000 Sempron 2300+ AMD 7,118,100 2,475,136 2,485,100 2,154,100 Celeron Intel 6,347,200 2,593,000 3,400,000 2,154,100 Aplicati un filtru pentru tabel pentru a afisa vanzarile producatorului Intel

Athlon XP 2000+ AMD 6,347,200 2,197,800 7,760,724 8,461,920 Sempron 2400+ AMD 5,676,700 2,383,600 4,423,479 5,879,875 Copiati rezultatul filtrarii in foaia de lucru INTELAthlon XP 2200+ AMD 5,374,700 1,841,873 4,092,762 5,215,411 Celeron Intel 4,828,900 2,197,800 5,303,261 3,073,832 Celeron Intel 5,418,668 2,197,800 5,281,350 3,503,831 Athlon XP 2100+ AMD 6,719,100 3,243,600 6,692,920 2,756,375 Celeron Intel 6,719,100 2,009,091 5,781,291 4,453,500 Athlon XP 2400+ AMD 3,243,600 2,707,600 9,335,403 3,794,280

AMD 7,118,100 2,197,800 5,864,282 2,649,780 Athlon XP 2400+ AMD 8,501,900 2,197,800 5,186,473 2,273,375 Athlon XP 2400+ AMD 4,582,400 5,606,859 2,506,441 Celeron Box Intel 5,374,700 4,351,800 4,712,988 6,408,150 Celeron D 320 Intel 5,374,700 3,933,700 5,911,429 2,356,200 Sempron 2500+ AMD 3,472,159 2,593,000 5,733,063 3,511,420 Celeron D 325 Intel 5,092,500 4,135,800 5,515,054 Athlon XP 2500+ AMD 3,933,700 2,707,600 2,816,580 6,191,424 Celeron Box Intel 4,135,800 4,351,800 12,249,508 8,682,121 Celeron D 320 Box Intel 3,400,000 3,744,300 3,972,743 8,998,520

AMD 3,243,600 4,861,023 3,753,885 7,005,316 Pentium 4 Intel 235,727 4,153,991 4,139,000 8,972,679 Athlon XP 2600+ AMD 4,582,400 1,885,900 4,139,000 10,007,313 Athlon XP 2600+ AMD 3,933,700 3,566,600 4,322,260 4,785,569 Celeron Intel 4,828,900 3,400,000 2,431,800 8,324,512 Celeron D 330 Intel 3,933,700 4,153,991 8,532,906 Celeron Box Intel 5,374,700 3,243,600 3,286,030 8,279,810

AMD 4,582,400 3,243,600 5,512,810 6,534,183 Sempron 2600+ AMD 3,400,000 3,243,600 3,256,865 12,409,650 Athlon XP 2600+ AMD 3,096,164 4,351,800 3,969,000 6,273,930

AMD 2,112,900 3,511,927 4,309,000 6,298,405 Celeron D 325 Box Intel 2,829,400 4,678,920 6,216,965 Celeron Intel 2,959,000 4,351,800 4,309,000 4,921,000 Celeron D 335 Intel 3,096,800 4,351,800 4,011,382 4,346,920 Celeron D 330 Box Intel 2,829,400 4,135,800 4,068,094 4,340,066

AMD 3,096,800 3,933,700 5,156,420 4,234,238 Celeron Box Intel 4,828,900 4,582,400 4,390,894 3,378,500

AMD 3,933,700 2,956,036 3,264,731 9,671,358 Pentium 4 Intel 2,707,600 3,243,600 2,940,000 3,464,457

Sempron 2400+ Box

Athlon XP 2200+ Box

Sempron 2500+ Box

Athlon XP 2400+ Box

Sempron 2600+ Box

Athlon XP 2400+ Box

Pentium 4 Intel 3,933,700 2,707,600 3,775,620 4,390,406 Pentium III Intel 2,383,600 9,034,100 2,828,835

AMD 3,400,000 1,083,455 3,935,750 5,904,378

Intel 2,593,000 3,933,700 2,607,941 2,447,922 Athlon XP 2800+ AMD 2,383,600 3,448,200 3,181,618 Pentium III Intel 2,485,100 2,593,000 4,926,584 2,349,296 Pentium 4 Intel 3,096,800 1,548,400 3,358,000 3,316,215 Athlon MP 2600+ AMD 2,383,600 4,135,800 4,292,420 2,156,830 Celeron D 335 Box Intel 2,383,600 2,584,527 4,857,250 2,895,138 Sempron 2800+ AMD 6,347,200 8,007,100 3,399,488 4,231,589 Athlon XP 2700+ AMD 1,548,400 2,485,100 4,270,000 2,806,500 Athlon XP 3000+ AMD 4,582,400 2,485,100 3,075,003 3,624,380

AMD 2,707,600 3,400,000 3,966,960 4,119,763 Celeron Box Intel 2,383,600 3,400,000 4,678,920 2,842,775 Pentium 4 Intel 2,959,000 3,566,600 2,814,429 3,607,682

Intel 2,824,500 2,032,800 2,718,388 2,572,998

Athlon XP 2500+ BoxPentium III Tualatin 256

Sempron 2800+ Box

Pentium III Tualatin 256

Aplicati un filtru pentru tabel pentru a afisa vanzarile producatorului Intel

Copiati rezultatul filtrarii in foaia de lucru INTEL

Valoare vanzariModel Producator 2001 2002 2003 2004

Celeron Intel 6,347,200 2,593,000 3,400,000 2,154,100 Celeron Intel 4,828,900 2,197,800 5,303,261 3,073,832 Celeron Intel 5,418,668 2,197,800 5,281,350 3,503,831 Celeron Intel 6,719,100 2,009,091 5,781,291 4,453,500 Celeron Box Intel 5,374,700 4,351,800 4,712,988 6,408,150 Celeron D 320 Intel 5,374,700 3,933,700 5,911,429 2,356,200 Celeron D 325 Intel 5,092,500 4,135,800 5,515,054 Celeron Box Intel 4,135,800 4,351,800 12,249,508 8,682,121 Celeron D 320 Box Intel 3,400,000 3,744,300 3,972,743 8,998,520 Pentium 4 Intel 235,727 4,153,991 4,139,000 8,972,679 Celeron Intel 4,828,900 3,400,000 2,431,800 8,324,512 Celeron D 330 Intel 3,933,700 4,153,991 8,532,906 Celeron Box Intel 5,374,700 3,243,600 3,286,030 8,279,810 Celeron D 325 Box Intel 2,829,400 4,678,920 6,216,965 Celeron Intel 2,959,000 4,351,800 4,309,000 4,921,000 Celeron D 335 Intel 3,096,800 4,351,800 4,011,382 4,346,920 Celeron D 330 Box Intel 2,829,400 4,135,800 4,068,094 4,340,066 Celeron Box Intel 4,828,900 4,582,400 4,390,894 3,378,500 Pentium 4 Intel 2,707,600 3,243,600 2,940,000 3,464,457 Pentium 4 Intel 3,933,700 2,707,600 3,775,620 4,390,406 Pentium III Intel 2,383,600 9,034,100 2,828,835

Intel 2,593,000 3,933,700 2,607,941 2,447,922 Pentium III Intel 2,485,100 2,593,000 4,926,584 2,349,296 Pentium 4 Intel 3,096,800 1,548,400 3,358,000 3,316,215 Celeron D 335 Box Intel 2,383,600 2,584,527 4,857,250 2,895,138 Celeron Box Intel 2,383,600 3,400,000 4,678,920 2,842,775 Pentium 4 Intel 2,959,000 3,566,600 2,814,429 3,607,682

Intel 2,824,500 2,032,800 2,718,388 2,572,998

Pentium III Tualatin 256

Pentium III Tualatin 256

Aplicati un filtru pentru tabel pentru a afisa vanzarile producatorului IntelData / Filter

Pret Data

Vand Birou (Containere birou/multifunctiional) vanzari Arad 1 11/21/2004

Vand Birou (Ghica Tei) vanzari Bucuresti 67,000 11/23/2004

Vand Birou (Ghica Tei) cumparare Bucuresti 67,000 11/18/2004

Vand Birou (PIATA VICTORIEI) vanzari Bucuresti 1,000,000 9/20/2004

Vand Birou (DACIA) vanzari Bucuresti 1,350,000 11/19/2004

Vand Birou (FOISORUL DE FOC) vanzari Bucuresti 1,520,000 11/20/2004

Vand Birou (Investitie - Foisorul De Foc cumparare Bucuresti 1,520,000 11/21/2004

Vand Birou (FOISORUL DE FOC) vanzari Bucuresti 1,520,000 11/19/2004

Vand Birou (BARBU VACARESCU) vanzari Bucuresti 1,700,000 11/19/2004

Vand Birou (Primaverii) vanzari Bucuresti 1,800,000 11/20/2004

Vand Birou (CISMIGIU) cumparare Bucuresti 2,000,000 11/21/2004

Vand Birou (Barbu Vacarescu) vanzari Bucuresti 2,000,000 11/22/2004

Vand Birou (CISMIGIU) vanzari Bucuresti 2,000,000 11/18/2004

Vand Birou (Unirii, Alba Iulia) cumparare Bucuresti 2,300,000 11/5/2004

Vand Birou (Alba Iulia) vanzari Bucuresti 2,300,000 11/19/2004

Vand Birou (Stirbei Voda) vanzari Bucuresti 2,900,000 11/20/2004

Vand Birou (Floreasca) cumparare Bucuresti 2,920,000 11/21/2004

Vand Birou (Floreasca) vanzari Bucuresti 3,000,000 11/22/2004

Vand Birou (HANUL LUI MANUC) vanzari Bucuresti 3,300,000 11/23/2004

Vand Birou (Victoriei) vanzari Bucuresti 3,500,000 11/4/2004

Vand Birou (Piata Unirii Bucuresti) cumparare Bucuresti 3,500,000 11/5/2004

Vand Birou (Unirii Hanul lui Mnuc) vanzari Bucuresti 3,500,000 11/6/2004

Vand Birou (CALEA VICTORIEI) cumparare Bucuresti 3,500,000 11/7/2004

Vand Birou (CENTRU) vanzari Bucuresti 6 10/21/2004

Vand Birou (Bucuresti) vanzari Bucuresti 7 9/7/2004

Vand Birou (EX) vanzari Bucuresti 90 8/15/2004

Vand Birou (Pod`) vanzari Bucuresti 900 10/13/2004

Vand Birou (Victoriei Buzesti) vanzari Bucuresti 1,200 18 Iul 2004

Vand Birou (Primaverii Beller) vanzari Bucuresti 1,200 18 Iul 2004

Vand Birou (Primaverii Beller) vanzari Bucuresti 1,200 18 Iul 2004

Vand Birou (Piata Victoriei) vanzari Bucuresti 1,500 18 Iul 2004

Vand Birou (Florida USA) vanzari Bucuresti 10,000 11/20/2004

Vand Birou (Iasi - 12) vanzari Iasi 40,000 11/14/2004Vand Birou (Valcea) vanzari Iasi 54,000 3/11/2004

Vand Birou (Istorica) cumparare Sibiu 41,000 11/15/2004

Vand Birou (Storica) vanzari Sibiu 41,000 11/16/2004

Vand Birou (Piata Mare) vanzari Sibiu 51,000 11/15/2004

Vand Birou (PIAZZA GRANDE) cumparare Sibiu 51,000 11/16/2004

Vand Birou (DN1) vanzari Sinaia 23,000 4/28/2004

Vand Birou (OPEREI-ULTRACENTRAL) cumparare Timisoara 19,000 11/24/2003

 Titlu  Categorie  Oras

A B C D E F1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

Aplicati un filtru pentru a afisa numai vanzarile din Bucuresti

G H I J K1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

Pret Data

Vand Birou (Ghica Tei) vanzari Bucuresti 67,000 11/23/2004

Vand Birou (PIATA VICTORIEI) vanzari Bucuresti 1,000,000 9/20/2004

Vand Birou (DACIA) vanzari Bucuresti 1,350,000 11/19/2004

Vand Birou (FOISORUL DE FOC) vanzari Bucuresti 1,520,000 11/20/2004

Vand Birou (FOISORUL DE FOC) vanzari Bucuresti 1,520,000 11/19/2004

Vand Birou (BARBU VACARESCU) vanzari Bucuresti 1,700,000 11/19/2004

Vand Birou (Primaverii) vanzari Bucuresti 1,800,000 11/20/2004

Vand Birou (Barbu Vacarescu) vanzari Bucuresti 2,000,000 11/22/2004

Vand Birou (CISMIGIU) vanzari Bucuresti 2,000,000 11/18/2004

Vand Birou (Alba Iulia) vanzari Bucuresti 2,300,000 11/19/2004

Vand Birou (Stirbei Voda) vanzari Bucuresti 2,900,000 11/20/2004

Vand Birou (Floreasca) vanzari Bucuresti 3,000,000 11/22/2004

Vand Birou (HANUL LUI MANUC) vanzari Bucuresti 3,300,000 11/23/2004

Vand Birou (Victoriei) vanzari Bucuresti 3,500,000 11/4/2004

Vand Birou (Unirii Hanul lui Mnuc) vanzari Bucuresti 3,500,000 11/6/2004

Vand Birou (CENTRU) vanzari Bucuresti 6 10/21/2004

Vand Birou (Bucuresti) vanzari Bucuresti 7 9/7/2004

Vand Birou (EX) vanzari Bucuresti 90 8/15/2004

Vand Birou (Pod`) vanzari Bucuresti 900 10/13/2004

Vand Birou (Victoriei Buzesti) vanzari Bucuresti 1,200 18 Iul 2004

Vand Birou (Primaverii Beller) vanzari Bucuresti 1,200 18 Iul 2004

Vand Birou (Primaverii Beller) vanzari Bucuresti 1,200 18 Iul 2004

Vand Birou (Piata Victoriei) vanzari Bucuresti 1,500 18 Iul 2004

Vand Birou (Florida USA) vanzari Bucuresti 10,000 11/20/2004

 Titlu  Categorie  Oras

A B C D E F1

2

4

6

7

8

10

11

12

14

15

17

18

20

21

22

24

26

27

28

29

30

31

32

33

34

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

A B C D E F61

62

63

64

65

Aplicati un filtru pentru a afisa numai vanzarile din Bucuresti

Data / Filter

La Categorie lasam selectate doar vanzarile:

La Oras lasam selectat doar Bucuresti:

G H I J K1

2

4

6

7

8

10

11

12

14

15

17

18

20

21

22

24

26

27

28

29

30

31

32

33

34

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

G H I J K61

62

63

64

65

Marca Nume Prenume Data nasteriSectie Vechime Salariu

1001 Dumitru Maria 3/1/1957 1 25 30001200 Marin Alina 10/4/1969 2 20 29001205 GrigorescuDan 3/5/1970 1 12 21001235 Mihala Dorin 3/20/1978 3 21 25001302 Stanciu Alexandru 2/9/1975 2 10 20001320 Iordache Livia 6/5/1980 1 2 15001380 Pintilie Ion 10/6/1950 3 35 35001420 Ionescu Dan 4/29/1970 3 15 25001450 Stefan Elena 10/7/1972 2 15 27001500 Savu Gheorghe 10/10/1979 1 3 1800

Se cere afisarea informatiilor referitoare la salariatii cu numerelede marca 1200 si 1500, folosind Custom Filter

Marca Nume Prenume Data nasterii Sectie Vechime Salariu

1001 Dumitru Maria 3/1/1957 1 25 30001200 Marin Alina 10/4/1969 2 20 29001205 GrigorescuDan 3/5/1970 1 12 21001235 Mihala Dorin 3/20/1978 3 21 25001302 Stanciu Alexandru 2/9/1975 2 10 20001320 Iordache Livia 6/5/1980 1 2 15001380 Pintilie Ion 10/6/1950 3 35 35001420 Ionescu Dan 4/29/1970 3 15 25001450 Stefan Elena 10/7/1972 2 15 27001500 Savu Gheorghe 10/10/1979 1 3 1800

Se cere afisarea informatiilor referitoare la salariatii cu numerelede marca 1200 si 1500, folosind Custom Filter

In fereastra care se deschide se creeaza filtrul. Pentru aceasta folosim functia logica OR (sau):

Se inchide fereastra, iar rezultatul filtrarii va fi afisat pe ecran:

Marca Nume Prenume Data nasterii Sectie Vechime Salariu1200 Marin Alina 10/4/1969 2 20 29001500 Savu Gheorghe 10/10/1979 1 3 1800

Data / Filter. Apar butoanele de filtrare. Deschidem butonul de filtrare corespunzator marcii si selectam comanda Custom Filter: