1Baza de date "Editura" (A3:I60)

Data de distribuieNumr facturTitlu carteNume ClientOras distributieAgent vanzareCantitate vandutaPret carteValoare vnzariSat 27 Oct 2007383,746Visual Basic for ApplicationCompania de librriiBucuretiRadulescu S.40 buc38 lei1,520 leiFri 02 Nov 2007383,746Bazele InformaticiiCompania de librriiBucuretiRadulescu S.80 buc34 lei2,720 leiTue 06 Nov 2007383,747Visual Basic for ApplicationLibrria "Central"SibiuRadulescu S.800 buc38 lei30,400 leiSat 10 Nov 2007383,748Baze de DateVox 2000BucuretiPopescu M.400 buc42 lei16,800 leiThu 03 Jan 2008383,749Office 2007 - AplicaiiLibris StocConstanaIonescu L.900 buc31 lei27,900 leiSat 09 Feb 2008383,750Office 2007 - AplicaiiLibrria "Central"SibiuPlea C.850 buc31 lei26,350 leiWed 13 Feb 2008383,751Baze de dateABCN ServComBucuretiVasilescu D.900 buc42 lei37,800 leiWed 13 Feb 2008383,752Bazele InformaticiiABCN ServComBucuretiVasilescu D.1000 buc34 lei34,000 leiWed 13 Feb 2008383,752Office 2007 - AplicaiiABCN ServComBucuretiVasilescu D.30 buc31 lei930 leiWed 02 Apr 2008383,753Informatica utilizatoruluiVox 2000BucuretiMoisescu A.1400 buc40 lei56,000 leiSat 10 May 2008383,754Informatica utilizatoruluiCompania de librriiBucuretiRadulescu S.16 buc40 lei640 leiSat 10 May 2008383,754Office 2007 - AplicaiiCompania de librriiBucuretiRadulescu S.600 buc31 lei18,600 leiSat 10 May 2008383,755Informatica utilizatoruluiLibris StocConstanaIonescu L.650 buc40 lei26,000 leiWed 21 May 2008383,756Programarea calculatoarelorRolCrisBucuretiPopescu M.1050 buc37 lei38,850 leiWed 21 May 2008383,756Informatica utilizatoruluiRolCrisBucuretiPopescu M.800 buc40 lei32,000 leiWed 04 Jun 2008383,757Visual Basic for ApplicationLibrria "Central"SibiuPlea C.1300 buc38 lei49,400 leiFri 25 Jul 2008383,758Visual Basic for ApplicationCompania de librriiBucuretiAlbu M.1000 buc38 lei38,000 leiSat 18 Oct 2008383,759Programarea calculatoarelorVox 2000BucuretiIonescu L.750 buc37 lei27,750 leiMon 20 Oct 2008383,759Bazele InformaticiiVox 2000BucuretiIonescu L.60 buc34 lei2,040 leiWed 22 Oct 2008383,760Informatica utilizatoruluiLibris StocConstanaMoisescu A.125 buc40 lei5,000 leiSat 08 Nov 2008383,761Bazele InformaticiiLibrria "Central"SibiuPlea C.600 buc34 lei20,400 leiWed 12 Nov 2008383,762Informatica utilizatoruluiRolCrisBucuretiMoisescu A.100 buc40 lei4,000 leiWed 12 Nov 2008383,763Programarea calculatoarelorRolCrisBucuretiMoisescu A.250 buc37 lei9,250 leiThu 20 Nov 2008383,764Baze de DateABCN ServComBucuretiIonescu L.90 buc42 lei3,780 leiThu 20 Nov 2008383,764Birotic i MultimediaABCN ServComBucuretiIonescu L.100 buc29 lei2,900 leiTue 25 Nov 2008383,765Visual Basic for ApplicationLibris StocConstanaPlea C.100 buc38 lei3,800 leiSat 20 Dec 2008383,766Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.360 buc40 lei14,400 leiWed 14 Jan 2009383,767Baze de DateCompania de librriiBucuretiIonescu L.2000 buc42 lei84,000 leiTue 27 Jan 2009383,768Informatica utilizatoruluiLibrria "Central"SibiuAlbu M.20 buc40 lei800 leiThu 29 Jan 2009383,768Birotic i MultimediaLibrria "Central"SibiuAlbu M.30 buc29 lei870 leiThu 29 Jan 2009383,769Baze de DateLumina LibrisBraovPlea C.40 buc42 lei1,680 leiThu 29 Jan 2009383,769Office 2007 - AplicaiiLumina LibrisBraovPlea C.400 buc31 lei12,400 leiWed 11 Feb 2009383,769Birotic i MultimediaLumina LibrisBraovPlea C.200 buc29 lei5,800 leiFri 20 Feb 2009383,770Informatica utilizatoruluiABCN ServComBucuretiMoisescu A.280 buc40 lei11,200 leiSat 21 Feb 2009383,771Baze de DateLibris StocConstanaPlea C.300 buc42 lei12,600 leiSat 21 Feb 2009383,772Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.1200 buc40 lei48,000 leiMon 16 Feb 2009383,773Baze de DateVox 2000SibiuRadulescu S.1450 buc42 lei60,900 leiMon 09 Feb 2009383,774Informatica utilizatoruluiLibraria UPGConstanaAlbu M.50 buc40 lei2,000 leiThu 19 Feb 2009383,774Baze de DateLibraria UPGConstanaAlbu M.60 buc42 lei2,520 leiMon 02 Mar 2009383,775Baze de DateABCN ServComBucuretiRadulescu S.90 buc42 lei3,780 leiThu 12 Mar 2009383,776Office 2007 - AplicaiiVox 2000SibiuRadulescu S.900 buc31 lei27,900 leiMon 23 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.350 buc31 lei10,850 leiSun 29 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.250 buc31 lei7,750 leiWed 25 Mar 2009383,777Baze de DateCompania de librriiBucuretiPintilie L.360 buc42 lei15,120 leiMon 16 Mar 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.750 buc40 lei30,000 leiFri 03 Apr 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.45 buc40 lei1,800 leiThu 23 Apr 2009383,779Baze de DateLibraria "PlaCedo"BraovMoisescu A.75 buc42 lei3,150 leiMon 27 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.20 buc34 lei680 leiThu 30 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.10 buc34 lei340 leiTue 28 Apr 2009383,780Programarea calculatoarelorLumina LibrisBraovMoisescu A.40 buc37 lei1,480 leiTue 21 Apr 2009383,781Baze de DateVox 2000BucuretiPintilie L.500 buc42 lei21,000 leiSat 11 Apr 2009383,782Birotic i MultimediaLibraria "PlaCedo"BraovAlbu M.240 buc24 lei5,760 leiSat 25 Apr 2009383,783Programarea calculatoarelorCompania de librriiBucuretiIonescu L.800 buc37 lei29,600 leiMon 27 Apr 2009383,784Baze de DateLibraria UPGConstanaIonescu L.365 buc42 lei15,330 leiWed 15 Apr 2009383,784Informatica utilizatoruluiLibraria UPGConstantaIonescu L.125 buc40 lei5,000 leiMon 04 May 2009383,785Programarea calculatoarelorABCN ServComBucuretiAlbu M.180 buc37 lei6,660 leiWed 06 May 2009383,786Baze de DateLibrria "Central"SibiuMoisescu A.320 buc42 lei13,440 lei

S se calculeze volumul total al vnzrilor pentru crile distribuite n ultima decad a lunii precedente, pe ageni de vnzare. *ultima decad reprezint intervalul (variabil) de zile ntre 20 i ultima zi a lunii respective.

Agent vanzareUltima decad a lunii precedenteAgent vanzare71,580.00 leiFALSERadulescu S.0.0Popescu M.0.0Ionescu L.44,930.00 leiPlea C.0.0Vasilescu D.0.0Moisescu A.5,650.00 leiAlbu M.0.0Pintilie L.21,000.00 lei

2FunciaBaza de date "Personal" (A4:H25)economistagent vnzriMarcaNume PrenumeData nateriiFilialaDepartamentFunciaData angajriiSalariu ncadrarecontabil1000POPESCU ViorelTuesday, January 01, 1980BraovMarketingeconomistTuesday, December 29, 19983,177 leianalist1001MIHAI CarmenTuesday, April 24, 1956BucuretiMarketingagent vnzriThursday, December 08, 19881,350 leioperator1002POPA FlorinWednesday, May 30, 1984BucuretiContabilitatecontabilWednesday, November 13, 19911,712 leiprogramator1003ALBU ConstantaThursday, March 19, 1981BucuretiMarketingeconomistSaturday, February 25, 20063,225 lei1004NEDELCU MihaiSunday, January 23, 1972BucuretiITanalistWednesday, February 02, 20053,000 lei1005CHIRU BiancaWednesday, November 25, 1959ConstantaITanalistThursday, January 21, 19883,820 lei1006ALBITER OanaSunday, March 03, 1985ConstantaMarketingagent vnzriMonday, March 06, 19721,590 lei1007VLAD PetruSunday, November 18, 1962BucuretiIToperatorFriday, October 29, 19932,133 lei1008CONSTANTIN DanWednesday, January 19, 1972BraovMarketingeconomistWednesday, July 16, 19972,900 lei1009MONDREA LauraTuesday, November 02, 1982BucuretiContabilitatecontabilTuesday, February 02, 19881,989 lei1010SAVU CtlinMonday, November 21, 1960BucuretiITeconomistThursday, September 19, 20022,031 lei1011PANAIT CornelTuesday, November 13, 1962BucuretiITprogramatorThursday, December 09, 19933,500 lei1012COMAN AuraMonday, May 23, 1977BucuretiITprogramatorWednesday, February 09, 20053,270 lei1013BLGESCU MdlinaFriday, August 24, 1973ConstantaContabilitateagent vnzriFriday, January 15, 19931,355 lei1014MIHAI DinuSunday, November 25, 1962BraovResurse umanecontabilMonday, June 02, 20031,900 lei1015DEDU NataliaFriday, January 06, 1984BucuretiContabilitateeconomistMonday, September 22, 19861,558 lei1016GANEA PavelWednesday, December 17, 1969BucuretiMarketingagent vnzriTuesday, November 16, 19931,743 lei1017SORESCU LianaSunday, February 27, 1955ConstantaMarketingagent vnzriWednesday, March 22, 19952,000 lei1018PETRE CristinaSunday, September 09, 1979BraovITprogramatorSaturday, December 05, 19983,240 lei1019MANESCU AndreeaFriday, November 30, 1962ConstantaContabilitateeconomistSaturday, January 12, 20083,411 lei1020VISAN AlexandraMonday, March 01, 1971ConstantaITeconomistSunday, January 28, 20072,880 lei

S se calculeze suma salariilor pentru o funcie selectat dintr-o list derulant, precum i numrul total de salariai care au fost angajati n ultimii 10 ani, pe fiecare filial n parte.

FunciaFilialaUltimii 10 ani10,010.00 lei7 salariaiprogramatorFALSEBraov3,240.00 lei1 salariaiBucureti6,770.00 lei4 salariaiConstanta0.02 salariai

3S se calculeze mrimea plilor lunare aferente unui credit de 58.500 lei, contractat pe o perioad de 5 ani, pentru mai multe variante de rata a dobnzii (12%-20%) i de perioade de rambursare (1-5 ani):

Sumele reprezentnd mrimea plilor lunare n diferite variante vor fi rotunjite la un multiplu de rotunjire, n funcie de ordinul de mrime al acestora, astfel:*de ordinul sutelor - rotunjirea opereaz la un multiplu de 1 leu*de ordinul miilor - rotunjirea opereaz la un multiplu de 10 lei*de ordinul zecilor de mii - rotunjirea opereaz la un multiplu de 100 lei

Rata anual a dobnzii15%Durata mprumutului3 aniSuma mprumutat58,500 lei

2,030 lei1 an2 ani3 ani4 ani5 ani12%5,200 lei2,750 lei1,940 lei1,540 lei1,300 lei13%5,230 lei2,780 lei1,970 lei1,570 lei1,330 lei14%5,250 lei2,810 lei2,000 lei1,600 lei1,360 lei15%5,280 lei2,840 lei2,030 lei1,630 lei1,390 lei16%5,310 lei2,860 lei2,060 lei1,660 lei1,420 lei17%5,340 lei2,890 lei2,090 lei1,690 lei1,450 lei18%5,360 lei2,920 lei2,110 lei1,720 lei1,490 lei19%5,390 lei2,950 lei2,140 lei1,750 lei1,520 lei20%5,420 lei2,980 lei2,170 lei1,780 lei1,550 lei

4Baza de date "Editura" (A3:I60)

Data de distribuieNumr facturTitlu carteNume ClientOras distributieAgent vanzareCantitate vandutaPret carteValoare vnzariSat 27 Oct 2007383,746Visual Basic for ApplicationCompania de librriiBucuretiRadulescu S.40 buc38 lei1,520 leiFri 02 Nov 2007383,746Bazele InformaticiiCompania de librriiBucuretiRadulescu S.80 buc34 lei2,720 leiTue 06 Nov 2007383,747Visual Basic for ApplicationLibrria "Central"SibiuRadulescu S.800 buc38 lei30,400 leiSat 10 Nov 2007383,748Baze de DateVox 2000BucuretiPopescu M.400 buc42 lei16,800 leiThu 03 Jan 2008383,749Office 2007 - AplicaiiLibris StocConstanaIonescu L.900 buc31 lei27,900 leiSat 09 Feb 2008383,750Office 2007 - AplicaiiLibrria "Central"SibiuPlea C.850 buc31 lei26,350 leiWed 13 Feb 2008383,751Baze de dateABCN ServComBucuretiVasilescu D.900 buc42 lei37,800 leiWed 13 Feb 2008383,752Bazele InformaticiiABCN ServComBucuretiVasilescu D.1000 buc34 lei34,000 leiWed 13 Feb 2008383,752Office 2007 - AplicaiiABCN ServComBucuretiVasilescu D.30 buc31 lei930 leiWed 02 Apr 2008383,753Informatica utilizatoruluiVox 2000BucuretiMoisescu A.1400 buc40 lei56,000 leiSat 10 May 2008383,754Informatica utilizatoruluiCompania de librriiBucuretiRadulescu S.16 buc40 lei640 leiSat 10 May 2008383,754Office 2007 - AplicaiiCompania de librriiBucuretiRadulescu S.600 buc31 lei18,600 leiSat 10 May 2008383,755Informatica utilizatoruluiLibris StocConstanaIonescu L.650 buc40 lei26,000 leiWed 21 May 2008383,756Programarea calculatoarelorRolCrisBucuretiPopescu M.1050 buc37 lei38,850 leiWed 21 May 2008383,756Informatica utilizatoruluiRolCrisBucuretiPopescu M.800 buc40 lei32,000 leiWed 04 Jun 2008383,757Visual Basic for ApplicationLibrria "Central"SibiuPlea C.1300 buc38 lei49,400 leiFri 25 Jul 2008383,758Visual Basic for ApplicationCompania de librriiBucuretiAlbu M.1000 buc38 lei38,000 leiSat 18 Oct 2008383,759Programarea calculatoarelorVox 2000BucuretiIonescu L.750 buc37 lei27,750 leiMon 20 Oct 2008383,759Bazele InformaticiiVox 2000BucuretiIonescu L.60 buc34 lei2,040 leiWed 22 Oct 2008383,760Informatica utilizatoruluiLibris StocConstanaMoisescu A.125 buc40 lei5,000 leiSat 08 Nov 2008383,761Bazele InformaticiiLibrria "Central"SibiuPlea C.600 buc34 lei20,400 leiWed 12 Nov 2008383,762Informatica utilizatoruluiRolCrisBucuretiMoisescu A.100 buc40 lei4,000 leiWed 12 Nov 2008383,763Programarea calculatoarelorRolCrisBucuretiMoisescu A.250 buc37 lei9,250 leiThu 20 Nov 2008383,764Baze de DateABCN ServComBucuretiIonescu L.90 buc42 lei3,780 leiThu 20 Nov 2008383,764Birotic i MultimediaABCN ServComBucuretiIonescu L.100 buc29 lei2,900 leiTue 25 Nov 2008383,765Visual Basic for ApplicationLibris StocConstanaPlea C.100 buc38 lei3,800 leiSat 20 Dec 2008383,766Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.360 buc40 lei14,400 leiWed 14 Jan 2009383,767Baze de DateCompania de librriiBucuretiIonescu L.2000 buc42 lei84,000 leiTue 27 Jan 2009383,768Informatica utilizatoruluiLibrria "Central"SibiuAlbu M.20 buc40 lei800 leiThu 29 Jan 2009383,768Birotic i MultimediaLibrria "Central"SibiuAlbu M.30 buc29 lei870 leiThu 29 Jan 2009383,769Baze de DateLumina LibrisBraovPlea C.40 buc42 lei1,680 leiThu 29 Jan 2009383,769Office 2007 - AplicaiiLumina LibrisBraovPlea C.400 buc31 lei12,400 leiWed 11 Feb 2009383,769Birotic i MultimediaLumina LibrisBraovPlea C.200 buc29 lei5,800 leiFri 20 Feb 2009383,770Informatica utilizatoruluiABCN ServComBucuretiMoisescu A.280 buc40 lei11,200 leiSat 21 Feb 2009383,771Baze de DateLibris StocConstanaPlea C.300 buc42 lei12,600 leiSat 21 Feb 2009383,772Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.1200 buc40 lei48,000 leiMon 16 Feb 2009383,773Baze de DateVox 2000SibiuRadulescu S.1450 buc42 lei60,900 leiMon 09 Feb 2009383,774Informatica utilizatoruluiLibraria UPGConstanaAlbu M.50 buc40 lei2,000 leiThu 19 Feb 2009383,774Baze de DateLibraria UPGConstanaAlbu M.60 buc42 lei2,520 leiMon 02 Mar 2009383,775Baze de DateABCN ServComBucuretiRadulescu S.90 buc42 lei3,780 leiThu 12 Mar 2009383,776Office 2007 - AplicaiiVox 2000SibiuRadulescu S.900 buc31 lei27,900 leiMon 23 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.350 buc31 lei10,850 leiSun 29 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.250 buc31 lei7,750 leiWed 25 Mar 2009383,777Baze de DateCompania de librriiBucuretiPintilie L.360 buc42 lei15,120 leiMon 16 Mar 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.750 buc40 lei30,000 leiFri 03 Apr 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.45 buc40 lei1,800 leiThu 23 Apr 2009383,779Baze de DateLibraria "PlaCedo"BraovMoisescu A.75 buc42 lei3,150 leiMon 27 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.20 buc34 lei680 leiThu 30 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.10 buc34 lei340 leiTue 28 Apr 2009383,780Programarea calculatoarelorLumina LibrisBraovMoisescu A.40 buc37 lei1,480 leiTue 21 Apr 2009383,781Baze de DateVox 2000BucuretiPintilie L.500 buc42 lei21,000 leiSat 11 Apr 2009383,782Birotic i MultimediaLibraria "PlaCedo"BraovAlbu M.240 buc24 lei5,760 leiSat 25 Apr 2009383,783Programarea calculatoarelorCompania de librriiBucuretiIonescu L.800 buc37 lei29,600 leiMon 27 Apr 2009383,784Baze de DateLibraria UPGConstanaIonescu L.365 buc42 lei15,330 leiWed 15 Apr 2009383,784Informatica utilizatoruluiLibraria UPGConstantaIonescu L.125 buc40 lei5,000 leiMon 04 May 2009383,785Programarea calculatoarelorABCN ServComBucuretiAlbu M.180 buc37 lei6,660 leiWed 06 May 2009383,786Baze de DateLibrria "Central"SibiuMoisescu A.320 buc42 lei13,440 lei

S se afieze numrul de cri (total cantitate vndut) i media valoric a acestora, pe titluri de carte i pe ageni de distribuie, restricionnd interactiv tabela pe ani de distribuie i, n cadrul acestora, pe trimestre. Observaie: raportul de sintez va releva numai distribuiile pentru Baze de date i Informatica utilizatorului.

Ani distribuie2009Trimestre distribuieQtr2Sum of Cantitate vandutaAverage of Valoare vnzariTotal Sum of Cantitate vandutaTotal Average of Valoare vnzariBaze de DateInformatica utilizatoruluiBaze de DateInformatica utilizatoruluiIonescu L.36512515330500049010165Moisescu A.39582953958295Pintilie L.5002100050021000Radulescu S.451800451800Grand Total126017013230340014309953.3333333333

5S se realizeze o analiz de senzitivitate care s releve modul n care cheltuielile fixe (valoarea minimal 75.000 lei, valoarea maximal 150.000 lei, pasul de incrementare 5.000 lei) i cheltuielile variabile (de la 175.000 lei, pn la 250.000 lei, increment 5.000 lei) pot afecta rentabilitatea degajat de comercializarea unui produs.Pre produs4 leiNumr produse100,000 bucCheltuieli fixe75,000 leiCheltuieli variabile175,000 leiVenituri estimate400,000 leiCheltuieli totale250,000 leiProfit150,000 lei

Rentabilitate 38%75,00080,00085,00090,00095,000100,000105,000110,000115,000120,000125,000130,000135,000140,000145,000150,000175,000 lei37.50%36.25%35.00%33.75%32.50%31.25%30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%180,000 lei36.25%35.00%33.75%32.50%31.25%30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%185,000 lei35.00%33.75%32.50%31.25%30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%190,000 lei33.75%32.50%31.25%30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%195,000 lei32.50%31.25%30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%200,000 lei31.25%30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%205,000 lei30.00%28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%210,000 lei28.75%27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%215,000 lei27.50%26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%220,000 lei26.25%25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%7.50%225,000 lei25.00%23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%7.50%6.25%230,000 lei23.75%22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%7.50%6.25%5.00%235,000 lei22.50%21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%7.50%6.25%5.00%3.75%240,000 lei21.25%20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%7.50%6.25%5.00%3.75%2.50%245,000 lei20.00%18.75%17.50%16.25%15.00%13.75%12.50%11.25%10.00%8.75%7.50%6.25%5.00%3.75%2.50%1.25%

6Baza de date "Personal" (A4:H25)

MarcaNume PrenumeData nateriiFilialaDepartamentFunciaData angajriiSalariu ncadrare1000POPESCU ViorelTuesday, January 01, 1980PloiestiMarketingeconomistTuesday, December 29, 19983,177 lei1001MIHAI CarmenTuesday, April 24, 1956BucurestiMarketingagent vnzriSunday, March 08, 20091,350 lei1002POPA FlorinWednesday, May 30, 1984BucurestiContabilitatecontabilWednesday, November 13, 19911,712 lei1003ALBU ConstantaThursday, March 19, 1981PloiestiMarketingeconomistWednesday, February 25, 20093,225 lei1004NEDELCU MihaiSunday, January 23, 1972BucurestiITanalistWednesday, February 02, 20053,000 lei1005CHIRU BiancaWednesday, November 25, 1959ConstantaITanalistThursday, January 21, 19883,820 lei1006ALBITER OanaSunday, March 03, 1985ConstantaMarketingagent vnzriMonday, March 06, 19721,590 lei1007VLAD PetruSunday, November 18, 1962BucurestiIToperatorFriday, October 29, 19932,133 lei1008CONSTANTIN DanWednesday, January 19, 1972PloiestiMarketingeconomistWednesday, July 16, 19972,900 lei1009MONDREA LauraTuesday, November 02, 1982BucurestiContabilitatecontabilTuesday, February 02, 19881,989 lei1010SAVU CtlinMonday, November 21, 1960BucurestiITeconomistThursday, September 19, 20022,031 lei1011PANAIT CornelTuesday, November 13, 1962BucurestiITprogramatorThursday, December 09, 19933,500 lei1012COMAN AuraMonday, May 23, 1977BucurestiITprogramatorWednesday, February 09, 20053,270 lei1013BLGESCU MdlinaFriday, August 24, 1973ConstantaContabilitateagent vnzriFriday, January 15, 19931,355 lei1014MIHAI DinuSunday, November 25, 1962PloiestiResurse umanecontabilThursday, April 02, 20091,900 lei1015DEDU NataliaFriday, January 06, 1984BucurestiContabilitateeconomistMonday, September 22, 19861,558 lei1016GANEA PavelWednesday, December 17, 1969BucurestiMarketingagent vnzriTuesday, November 16, 19931,743 lei1017SORESCU LianaSunday, February 27, 1955ConstantaMarketingagent vnzriWednesday, March 22, 19952,000 lei1018PETRE CristinaSunday, September 09, 1979PloiestiITprogramatorSaturday, December 05, 19983,240 lei1019MANESCU AndreeaFriday, November 30, 1962BucurestiContabilitateeconomistMonday, January 12, 20093,411 lei1020VISAN AlexandraMonday, March 01, 1971ConstantaITeconomistSunday, January 28, 20072,880 lei

S se realizeze o analiz a numrului de salariai (pe filiale ale societii) angajai n urmtoarele intervale de timp:* nainte de anul 1996* n perioada 1996-2001* n perioada 2002-2008* n cursul anului curent (2009)Observaie: criteriile (intervalele de timp pe care se realizeaz analiza) vor fi selectate dintr-o list derulant

Filialan cursul anului curent4 salariaiFALSEPloiesti2 salariaiBucuresti2 salariaiConstanta0.0

7Baza de date "Editura" (A3:I60)

Data de distribuieNumr facturTitlu carteNume ClientOras distributieAgent vanzareCantitate vandutaPret carteValoare vnzariSat 27 Oct 2007383,746Visual Basic for ApplicationCompania de librriiBucuretiRadulescu S.40 buc38 lei1,520 leiFri 02 Nov 2007383,746Bazele InformaticiiCompania de librriiBucuretiRadulescu S.80 buc34 lei2,720 leiTue 06 Nov 2007383,747Visual Basic for ApplicationLibrria "Central"SibiuRadulescu S.800 buc38 lei30,400 leiSat 10 Nov 2007383,748Baze de DateVox 2000BucuretiPopescu M.400 buc42 lei16,800 leiThu 03 Jan 2008383,749Office 2007 - AplicaiiLibris StocConstanaIonescu L.900 buc31 lei27,900 leiSat 09 Feb 2008383,750Office 2007 - AplicaiiLibrria "Central"SibiuPlea C.850 buc31 lei26,350 leiWed 13 Feb 2008383,751Baze de dateABCN ServComBucuretiVasilescu D.900 buc42 lei37,800 leiWed 13 Feb 2008383,752Bazele InformaticiiABCN ServComBucuretiVasilescu D.1000 buc34 lei34,000 leiWed 13 Feb 2008383,752Office 2007 - AplicaiiABCN ServComBucuretiVasilescu D.30 buc31 lei930 leiWed 02 Apr 2008383,753Informatica utilizatoruluiVox 2000BucuretiMoisescu A.1400 buc40 lei56,000 leiSat 10 May 2008383,754Informatica utilizatoruluiCompania de librriiBucuretiRadulescu S.16 buc40 lei640 leiSat 10 May 2008383,754Office 2007 - AplicaiiCompania de librriiBucuretiRadulescu S.600 buc31 lei18,600 leiSat 10 May 2008383,755Informatica utilizatoruluiLibris StocConstanaIonescu L.650 buc40 lei26,000 leiWed 21 May 2008383,756Programarea calculatoarelorRolCrisBucuretiPopescu M.1050 buc37 lei38,850 leiWed 21 May 2008383,756Informatica utilizatoruluiRolCrisBucuretiPopescu M.800 buc40 lei32,000 leiWed 04 Jun 2008383,757Visual Basic for ApplicationLibrria "Central"SibiuPlea C.1300 buc38 lei49,400 leiFri 25 Jul 2008383,758Visual Basic for ApplicationCompania de librriiBucuretiAlbu M.1000 buc38 lei38,000 leiSat 18 Oct 2008383,759Programarea calculatoarelorVox 2000BucuretiIonescu L.750 buc37 lei27,750 leiMon 20 Oct 2008383,759Bazele InformaticiiVox 2000BucuretiIonescu L.60 buc34 lei2,040 leiWed 22 Oct 2008383,760Informatica utilizatoruluiLibris StocConstanaMoisescu A.125 buc40 lei5,000 leiSat 08 Nov 2008383,761Bazele InformaticiiLibrria "Central"SibiuPlea C.600 buc34 lei20,400 leiWed 12 Nov 2008383,762Informatica utilizatoruluiRolCrisBucuretiMoisescu A.100 buc40 lei4,000 leiWed 12 Nov 2008383,763Programarea calculatoarelorRolCrisBucuretiMoisescu A.250 buc37 lei9,250 leiThu 20 Nov 2008383,764Baze de DateABCN ServComBucuretiIonescu L.90 buc42 lei3,780 leiThu 20 Nov 2008383,764Birotic i MultimediaABCN ServComBucuretiIonescu L.100 buc29 lei2,900 leiTue 25 Nov 2008383,765Visual Basic for ApplicationLibris StocConstanaPlea C.100 buc38 lei3,800 leiSat 20 Dec 2008383,766Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.360 buc40 lei14,400 leiWed 14 Jan 2009383,767Baze de DateCompania de librriiBucuretiIonescu L.2000 buc42 lei84,000 leiTue 27 Jan 2009383,768Informatica utilizatoruluiLibrria "Central"SibiuAlbu M.20 buc40 lei800 leiThu 29 Jan 2009383,768Birotic i MultimediaLibrria "Central"SibiuAlbu M.30 buc29 lei870 leiThu 29 Jan 2009383,769Baze de DateLumina LibrisBraovPlea C.40 buc42 lei1,680 leiThu 29 Jan 2009383,769Office 2007 - AplicaiiLumina LibrisBraovPlea C.400 buc31 lei12,400 leiWed 11 Feb 2009383,769Birotic i MultimediaLumina LibrisBraovPlea C.200 buc29 lei5,800 leiFri 20 Feb 2009383,770Informatica utilizatoruluiABCN ServComBucuretiMoisescu A.280 buc40 lei11,200 leiSat 21 Feb 2009383,771Baze de DateLibris StocConstanaPlea C.300 buc42 lei12,600 leiSat 21 Feb 2009383,772Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.1200 buc40 lei48,000 leiMon 16 Feb 2009383,773Baze de DateVox 2000SibiuRadulescu S.1450 buc42 lei60,900 leiMon 09 Feb 2009383,774Informatica utilizatoruluiLibraria UPGConstanaAlbu M.50 buc40 lei2,000 leiThu 19 Feb 2009383,774Baze de DateLibraria UPGConstanaAlbu M.60 buc42 lei2,520 leiMon 02 Mar 2009383,775Baze de DateABCN ServComBucuretiRadulescu S.90 buc42 lei3,780 leiThu 12 Mar 2009383,776Office 2007 - AplicaiiVox 2000SibiuRadulescu S.900 buc31 lei27,900 leiMon 23 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.350 buc31 lei10,850 leiSun 29 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.250 buc31 lei7,750 leiWed 25 Mar 2009383,777Baze de DateCompania de librriiBucuretiPintilie L.360 buc42 lei15,120 leiMon 16 Mar 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.750 buc40 lei30,000 leiFri 03 Apr 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.45 buc40 lei1,800 leiThu 23 Apr 2009383,779Baze de DateLibraria "PlaCedo"BraovMoisescu A.75 buc42 lei3,150 leiMon 27 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.20 buc34 lei680 leiThu 30 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.10 buc34 lei340 leiTue 28 Apr 2009383,780Programarea calculatoarelorLumina LibrisBraovMoisescu A.40 buc37 lei1,480 leiTue 21 Apr 2009383,781Baze de DateVox 2000BucuretiPintilie L.500 buc42 lei21,000 leiSat 11 Apr 2009383,782Birotic i MultimediaLibraria "PlaCedo"BraovAlbu M.240 buc24 lei5,760 leiSat 25 Apr 2009383,783Programarea calculatoarelorCompania de librriiBucuretiIonescu L.800 buc37 lei29,600 leiMon 27 Apr 2009383,784Baze de DateLibraria UPGConstanaIonescu L.365 buc42 lei15,330 leiWed 15 Apr 2009383,784Informatica utilizatoruluiLibraria UPGConstantaIonescu L.125 buc40 lei5,000 leiMon 04 May 2009383,785Programarea calculatoarelorABCN ServComBucuretiAlbu M.180 buc37 lei6,660 leiWed 06 May 2009383,786Baze de DateLibrria "Central"SibiuMoisescu A.320 buc42 lei13,440 lei

S se realizeze o extragere tip baz de date, plecnd de la o sintetizare prin tabela pivot care s releve toate informaiile privind vnzrile realizate de agentul de distribuie Rdulescu, n oraul Sibiu.Data de distribuieNumr facturTitlu carteNume ClientOras distributieAgent vanzareCantitate vandutaPret carteValoare vnzari3/12/09383776Office 2007 - AplicaiiVox 2000SibiuRadulescu S.90031279002/16/09383773Baze de DateVox 2000SibiuRadulescu S.1450426090011/6/07383747Visual Basic for ApplicationLibrria "Central"SibiuRadulescu S.8003830400

8FunciaBaza de date "Personal" (A4:H25)economistagent vnzriMarcaNume PrenumeData nateriiFilialaDepartamentFunciaData angajriiSalariu ncadrarecontabil1000POPESCU ViorelTuesday, January 01, 1980BraovMarketingeconomistTuesday, December 29, 19983,177 leianalist1001MIHAI CarmenTuesday, April 24, 1956BucuretiMarketingagent vnzriThursday, December 08, 19881,350 leioperator1002POPA FlorinWednesday, May 30, 1984BucuretiContabilitatecontabilWednesday, November 13, 19911,712 leiprogramator1003ALBU ConstantaThursday, March 19, 1981BucuretiMarketingeconomistSaturday, February 25, 20063,225 lei1004NEDELCU MihaiSunday, January 23, 1972BucuretiITanalistWednesday, February 02, 20053,000 lei1005CHIRU BiancaWednesday, November 25, 1959ConstantaITanalistThursday, January 21, 19883,820 lei1006ALBITER OanaSunday, March 03, 1985ConstantaMarketingagent vnzriMonday, March 06, 19721,590 lei1007VLAD PetruSunday, November 18, 1962BucuretiIToperatorFriday, October 29, 19932,133 lei1008CONSTANTIN DanWednesday, January 19, 1972BraovMarketingeconomistWednesday, July 16, 19972,900 lei1009MONDREA LauraTuesday, November 02, 1982BucuretiContabilitatecontabilTuesday, February 02, 19881,989 lei1010SAVU CtlinMonday, November 21, 1960BucuretiITeconomistThursday, September 19, 20022,031 lei1011PANAIT CornelTuesday, November 13, 1962BucuretiITprogramatorThursday, December 09, 19933,500 lei1012COMAN AuraMonday, May 23, 1977BucuretiITprogramatorWednesday, February 09, 20053,270 lei1013BLGESCU MdlinaFriday, August 24, 1973ConstantaContabilitateagent vnzriFriday, January 15, 19931,355 lei1014MIHAI DinuSunday, November 25, 1962BraovResurse umanecontabilMonday, June 02, 20031,900 lei1015DEDU NataliaFriday, January 06, 1984BucuretiContabilitateeconomistMonday, September 22, 19861,558 lei1016GANEA PavelWednesday, December 17, 1969BucuretiMarketingagent vnzriTuesday, November 16, 19931,743 lei1017SORESCU LianaSunday, February 27, 1955ConstantaMarketingagent vnzriWednesday, March 22, 19952,000 lei1018PETRE CristinaSunday, September 09, 1979BraovITprogramatorSaturday, December 05, 19983,240 lei1019MANESCU AndreeaFriday, November 30, 1962ConstantaContabilitateeconomistSaturday, January 12, 20083,411 lei1020VISAN AlexandraMonday, March 01, 1971ConstantaITeconomistSunday, January 28, 20072,880 lei

S se calculeze media salariilor, pe funcii i departamente funcionale, n anul n care s-au fcut cele mai multe angajri.(media va fi rotunjit prin adaos la un multiplu de 5 lei, iar mesajul de eroare #DIV/0! va fi nlocuit cu spaiu)

FunciaDepartamentAnul cel mai frecvent2,185.00 leiMarketingContabilitateITResurse umaneFALSEeconomistagent vnzri1,745.00 lei1,355.00 leicontabilanalistoperator2,135.00 leiprogramator3,500.00 lei

9Baza de date "Editura" (A3:I60)

Data de distribuieNumr facturTitlu carteNume ClientOras distributieAgent vanzareCantitate vandutaPret carteValoare vnzariSat 27 Oct 2007383,746Visual Basic for ApplicationCompania de librriiBucuretiRadulescu S.40 buc38 lei1,520 leiFri 02 Nov 2007383,746Bazele InformaticiiCompania de librriiBucuretiRadulescu S.80 buc34 lei2,720 leiTue 06 Nov 2007383,747Visual Basic for ApplicationLibrria "Central"SibiuRadulescu S.800 buc38 lei30,400 leiSat 10 Nov 2007383,748Baze de DateVox 2000BucuretiPopescu M.400 buc42 lei16,800 leiThu 03 Jan 2008383,749Office 2007 - AplicaiiLibris StocConstanaIonescu L.900 buc31 lei27,900 leiSat 09 Feb 2008383,750Office 2007 - AplicaiiLibrria "Central"SibiuPlea C.850 buc31 lei26,350 leiWed 13 Feb 2008383,751Baze de dateABCN ServComBucuretiVasilescu D.900 buc42 lei37,800 leiWed 13 Feb 2008383,752Bazele InformaticiiABCN ServComBucuretiVasilescu D.1000 buc34 lei34,000 leiWed 13 Feb 2008383,752Office 2007 - AplicaiiABCN ServComBucuretiVasilescu D.30 buc31 lei930 leiWed 02 Apr 2008383,753Informatica utilizatoruluiVox 2000BucuretiMoisescu A.1400 buc40 lei56,000 leiSat 10 May 2008383,754Informatica utilizatoruluiCompania de librriiBucuretiRadulescu S.16 buc40 lei640 leiSat 10 May 2008383,754Office 2007 - AplicaiiCompania de librriiBucuretiRadulescu S.600 buc31 lei18,600 leiSat 10 May 2008383,755Informatica utilizatoruluiLibris StocConstanaIonescu L.650 buc40 lei26,000 leiWed 21 May 2008383,756Programarea calculatoarelorRolCrisBucuretiPopescu M.1050 buc37 lei38,850 leiWed 21 May 2008383,756Informatica utilizatoruluiRolCrisBucuretiPopescu M.800 buc40 lei32,000 leiWed 04 Jun 2008383,757Visual Basic for ApplicationLibrria "Central"SibiuPlea C.1300 buc38 lei49,400 leiFri 25 Jul 2008383,758Visual Basic for ApplicationCompania de librriiBucuretiAlbu M.1000 buc38 lei38,000 leiSat 18 Oct 2008383,759Programarea calculatoarelorVox 2000BucuretiIonescu L.750 buc37 lei27,750 leiMon 20 Oct 2008383,759Bazele InformaticiiVox 2000BucuretiIonescu L.60 buc34 lei2,040 leiWed 22 Oct 2008383,760Informatica utilizatoruluiLibris StocConstanaMoisescu A.125 buc40 lei5,000 leiSat 08 Nov 2008383,761Bazele InformaticiiLibrria "Central"SibiuPlea C.600 buc34 lei20,400 leiWed 12 Nov 2008383,762Informatica utilizatoruluiRolCrisBucuretiMoisescu A.100 buc40 lei4,000 leiWed 12 Nov 2008383,763Programarea calculatoarelorRolCrisBucuretiMoisescu A.250 buc37 lei9,250 leiThu 20 Nov 2008383,764Baze de DateABCN ServComBucuretiIonescu L.90 buc42 lei3,780 leiThu 20 Nov 2008383,764Birotic i MultimediaABCN ServComBucuretiIonescu L.100 buc29 lei2,900 leiTue 25 Nov 2008383,765Visual Basic for ApplicationLibris StocConstanaPlea C.100 buc38 lei3,800 leiSat 20 Dec 2008383,766Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.360 buc40 lei14,400 leiWed 14 Jan 2009383,767Baze de DateCompania de librriiBucuretiIonescu L.2000 buc42 lei84,000 leiTue 27 Jan 2009383,768Informatica utilizatoruluiLibrria "Central"SibiuAlbu M.20 buc40 lei800 leiThu 29 Jan 2009383,768Birotic i MultimediaLibrria "Central"SibiuAlbu M.30 buc29 lei870 leiThu 29 Jan 2009383,769Baze de DateLumina LibrisBraovPlea C.40 buc42 lei1,680 leiThu 29 Jan 2009383,769Office 2007 - AplicaiiLumina LibrisBraovPlea C.400 buc31 lei12,400 leiWed 11 Feb 2009383,769Birotic i MultimediaLumina LibrisBraovPlea C.200 buc29 lei5,800 leiFri 20 Feb 2009383,770Informatica utilizatoruluiABCN ServComBucuretiMoisescu A.280 buc40 lei11,200 leiSat 21 Feb 2009383,771Baze de DateLibris StocConstanaPlea C.300 buc42 lei12,600 leiSat 21 Feb 2009383,772Informatica utilizatoruluiCompania de librriiBucuretiPintilie L.1200 buc40 lei48,000 leiMon 16 Feb 2009383,773Baze de DateVox 2000SibiuRadulescu S.1450 buc42 lei60,900 leiMon 09 Feb 2009383,774Informatica utilizatoruluiLibraria UPGConstanaAlbu M.50 buc40 lei2,000 leiThu 19 Feb 2009383,774Baze de DateLibraria UPGConstanaAlbu M.60 buc42 lei2,520 leiMon 02 Mar 2009383,775Baze de DateABCN ServComBucuretiRadulescu S.90 buc42 lei3,780 leiThu 12 Mar 2009383,776Office 2007 - AplicaiiVox 2000SibiuRadulescu S.900 buc31 lei27,900 leiMon 23 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.350 buc31 lei10,850 leiSun 29 Mar 2009383,776Office 2007 - AplicaiiLumina LibrisBraovVasilescu D.250 buc31 lei7,750 leiWed 25 Mar 2009383,777Baze de DateCompania de librriiBucuretiPintilie L.360 buc42 lei15,120 leiMon 16 Mar 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.750 buc40 lei30,000 leiFri 03 Apr 2009383,778Informatica utilizatoruluiABCN ServComBucuretiRadulescu S.45 buc40 lei1,800 leiThu 23 Apr 2009383,779Baze de DateLibraria "PlaCedo"BraovMoisescu A.75 buc42 lei3,150 leiMon 27 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.20 buc34 lei680 leiThu 30 Apr 2009383,780Bazele InformaticiiLumina LibrisBraovMoisescu A.10 buc34 lei340 leiTue 28 Apr 2009383,780Programarea calculatoarelorLumina LibrisBraovMoisescu A.40 buc37 lei1,480 leiTue 21 Apr 2009383,781Baze de DateVox 2000BucuretiPintilie L.500 buc42 lei21,000 leiSat 11 Apr 2009383,782Birotic i MultimediaLibraria "PlaCedo"BraovAlbu M.240 buc24 lei5,760 leiSat 25 Apr 2009383,783Programarea calculatoarelorCompania de librriiBucuretiIonescu L.800 buc37 lei29,600 leiMon 27 Apr 2009383,784Baze de DateLibraria UPGConstanaIonescu L.365 buc42 lei15,330 leiWed 15 Apr 2009383,784Informatica utilizatoruluiLibraria UPGConstantaIonescu L.125 buc40 lei5,000 leiMon 04 May 2009383,785Programarea calculatoarelorABCN ServComBucuretiAlbu M.180 buc37 lei6,660 leiWed 06 May 2009383,786Baze de DateLibrria "Central"SibiuMoisescu A.320 buc42 lei13,440 lei

S se calculeze volumul total al vnzrilor (pe clieni) n anul 2008, prin diferen fa de 2007 i 2009.

Sum of Valoare vnzariData de distribuieNume Client200720082009Grand TotalABCN ServCom-79410-25970Compania de librrii-67400105080Libraria "PlaCedo"08910Libraria UPG024850Librria "Central"-65750-81040Libris Stoc-62700-50100Lumina Libris040980RolCris-84100-84100Vox 2000-6899024010Grand Total-428350-37380

10FunciaBaza de date "Personal" (A4:H25)economistagent vnzriMarcaNume PrenumeData nateriiFilialaDepartamentFunciaData angajriiSalariu ncadrarecontabil1000POPESCU ViorelTuesday, January 01, 1980BraovMarketingeconomistTuesday, December 29, 19983,177 leianalist1001MIHAI CarmenTuesday, April 24, 1956BucuretiMarketingagent vnzriThursday, December 08, 19881,350 leioperator1002POPA FlorinWednesday, May 30, 1984BucuretiContabilitatecontabilWednesday, November 13, 19911,712 leiprogramator1003ALBU ConstantaThursday, March 19, 1981BraovMarketingeconomistSaturday, February 25, 20063,225 lei1004NEDELCU MihaiSunday, January 23, 1972BucuretiITanalistWednesday, February 02, 20053,000 lei1005CHIRU BiancaWednesday, November 25, 1959ConstantaITanalistThursday, January 21, 19883,820 lei1006ALBITER OanaSunday, March 03, 1985ConstantaMarketingagent vnzriMonday, March 06, 19721,590 lei1007VLAD PetruSunday, November 18, 1962BucuretiIToperatorFriday, October 29, 19932,133 lei1008CONSTANTIN DanWednesday, January 19, 1972BraovMarketingeconomistWednesday, July 16, 19972,900 lei1009MONDREA LauraTuesday, November 02, 1982BucuretiContabilitatecontabilTuesday, February 02, 19881,989 lei1010SAVU CtlinMonday, November 21, 1960BucuretiITeconomistThursday, September 19, 20022,031 lei1011PANAIT CornelTuesday, November 13, 1962BucuretiITprogramatorThursday, December 09, 19933,500 lei1012COMAN AuraFriday, May 23, 1986BraovITprogramatorWednesday, February 09, 20053,370 lei1013BLGESCU MdlinaFriday, August 24, 1973ConstantaContabilitateagent vnzriFriday, January 15, 19931,355 lei1014MIHAI DinuSunday, November 25, 1962BraovResurse umanecontabilMonday, June 02, 20031,900 lei1015DEDU NataliaFriday, January 06, 1984BucuretiContabilitateeconomistMonday, September 22, 19861,558 lei1016GANEA PavelWednesday, December 17, 1969BucuretiMarketingagent vnzriTuesday, November 16, 19931,743 lei1017SORESCU LianaSunday, February 27, 1955ConstantaMarketingagent vnzriWednesday, March 22, 19952,000 lei1018PETRE CristinaSunday, September 09, 1979BraovITprogramatorSaturday, December 05, 19983,240 lei1019MANESCU AndreeaTuesday, November 30, 1982ConstantaMarketingeconomistSaturday, January 12, 20083,411 lei1020VISAN AlexandraMonday, March 01, 1971ConstantaITeconomistSunday, January 28, 20072,880 lei

S se calculeze salariul minim i cel maxim, pe filiale si pe departamente functionale, rezultatele sintetizrii fiind afisate n acelasi cmp de ipoteze (sub forma: salariu minim/salariu maxim).Raportul de sintez va conine informaii numai pentru salariaii care au o vrst pn n 30 de ani.

FilialaDepartamentVrsta pn n 30 de aniERROR:#VALUE!MarketingContabilitateITResurse umaneTRUEBraovERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!BucuretiERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ConstantaERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

Sheet1