Post on 26-Oct-2014
description
transcript
Marca Nume Prenume Data nasterii Filiala
1000 POPESCU Viorel Tuesday, January 1, 1980 Ploiesti1001 MIHAI Carmen Tuesday, April 24, 1956 Bucuresti1002 POPA Florin Wednesday, May 30, 1984 Bucuresti1003 ALBU Constanta Thursday, March 19, 1981 Ploiesti1004 NEDELCU Mihai Sunday, January 23, 1972 Bucuresti1005 CHIRU Bianca Wednesday, November 25, 1959 Constanta1006 ALBITER Oana Sunday, March 3, 1985 Constanta1007 VLAD Petru Sunday, November 18, 1962 Bucuresti1008 CONSTANTIN Dan Wednesday, January 19, 1972 Ploiesti1009 MONDREA Laura Tuesday, November 2, 1982 Bucuresti1010 SAVU Cătălin Monday, November 21, 1960 Bucuresti1011 PANAIT Cornel Tuesday, November 13, 1962 Bucuresti1012 COMAN Aura Monday, May 23, 1977 Bucuresti1013 BLĂGESCU Mădălina Friday, August 24, 1973 Constanta1014 MIHAI Dinu Sunday, November 25, 1962 Ploiesti1015 DEDU Natalia Friday, January 6, 1984 Bucuresti1016 GANEA Pavel Wednesday, December 17, 1969 Bucuresti1017 SORESCU Liana Sunday, February 27, 1955 Constanta1018 PETRE Cristina Sunday, September 9, 1979 Ploiesti1019 MANESCU Andreea Friday, November 30, 1962 Bucuresti1020 VISAN Alexandra Monday, March 1, 1971 Constanta
A = 1,5p
(0,5p) 1. Sa se valideze departamentul (zona E3:E23) astfel incat sa permita introducerea doar a departamentelor din zona J3:J6
(1p) 2. Sa se valideze campul salariu incadrare care trebuie sa fie cuprinsa intre 1000 si 4000, cu mesaj de eroare
Departament Funcţia Data angajării
Marketing economist Wednesday, December 29, 2010 1234Marketing merceolog Thursday, December 8, 1988 1350Contabilitate contabil Wednesday, November 13, 1991 1700Marketing economist Saturday, February 25, 2006 3200IT analist Tuesday, February 2, 2010 3000IT analist Thursday, January 21, 1988 3800Marketing merceolog Monday, March 6, 1972 1500IT operator Friday, October 29, 1993 2100Marketing economist Wednesday, July 16, 1997 2900Contabilitate contabil Tuesday, February 2, 2010 1900IT economist Thursday, September 19, 2002 2000IT programator Thursday, December 9, 1993 3500IT programator Wednesday, February 9, 2005 3200Contabilitate merceolog Friday, January 15, 1993 1300Resurse umane contabil Monday, June 2, 2003 1900Contabilitate economist Monday, September 22, 1986 1500Marketing merceolog Tuesday, November 16, 1993 1700Marketing merceolog Monday, March 22, 2010 2000IT programator Saturday, December 5, 1998 3200Contabilitate economist Thursday, January 12, 2006 3400IT economist Friday, January 28, 2005 2800
1. Sa se valideze departamentul (zona E3:E23) astfel incat sa permita introducerea doar a departamentelor din zona J3:J6
2. Sa se valideze campul salariu incadrare care trebuie sa fie cuprinsa intre 1000 si 4000, cu mesaj de eroare
Salariu încadrare
Departament
MarketingITContabilitateResurse umane
Departament
MarketingContabilitateITResurse umane
Marca Nume Prenume Data nasterii Filiala
1000 POPESCU Viorel Tuesday, January 1, 1980 Ploiesti1001 MIHAI Carmen Tuesday, April 24, 1956 Bucuresti1002 POPA Florin Wednesday, May 30, 1984 Bucuresti1003 ALBU Constanta Thursday, March 19, 1981 Ploiesti1004 NEDELCU Mihai Sunday, January 23, 1972 Bucuresti1005 CHIRU Bianca Wednesday, November 25, 1959 Constanta1006 ALBITER Oana Sunday, March 3, 1985 Constanta1007 VLAD Petru Sunday, November 18, 1962 Bucuresti1008 CONSTANTIN Dan Wednesday, January 19, 1972 Ploiesti1009 MONDREA Laura Tuesday, November 2, 1982 Bucuresti1010 SAVU Cătălin Monday, November 21, 1960 Bucuresti1011 PANAIT Cornel Tuesday, November 13, 1962 Bucuresti1012 COMAN Aura Monday, May 23, 1977 Bucuresti1013 BLĂGESCU Mădălina Friday, August 24, 1973 Constanta1014 MIHAI Dinu Sunday, November 25, 1962 Ploiesti1015 DEDU Natalia Friday, January 6, 1984 Bucuresti1016 GANEA Pavel Wednesday, December 17, 1969 Bucuresti1017 SORESCU Liana Sunday, February 27, 1955 Constanta1018 PETRE Cristina Sunday, September 9, 1979 Ploiesti1019 MANESCU Andreea Friday, November 30, 1962 Bucuresti1020 VISAN Alexandra Monday, March 1, 1971 Constanta
B = 1,5p
(0,5p) 1. Sa se afiseze in celula I24 (prin functie statistica) numarul de salariati din departamentul IT(1p) 2. Sa se afiseze in celula H24(prin fuctie statistica) suma salariului de incadrare al angajatilor din departamentul Contabilitate, filiala Bucuresti
Departament Funcţia Data angajării Salariu încadrare
Marketing economist Tuesday, December 29, 1998 3,100 RONMarketing merceolog Thursday, December 8, 1988 1,350 RONContabilitate contabil Wednesday, November 13, 1991 1,700 RONMarketing economist Saturday, February 25, 2006 3,200 RONIT analist Wednesday, February 2, 2005 3,000 RONIT analist Thursday, January 21, 1988 3,800 RONMarketing merceolog Monday, March 6, 1972 1,500 RONIT operator Friday, October 29, 1993 2,100 RONMarketing economist Monday, July 16, 2007 2,900 RONContabilitate contabil Tuesday, February 2, 1988 1,900 RONIT economist Thursday, September 19, 2002 2,000 RONIT programator Thursday, December 9, 1993 3,500 RONIT programator Wednesday, February 9, 2005 3,200 RONContabilitate merceolog Friday, January 15, 1993 1,300 RONResurse umane contabil Monday, June 2, 2003 1,900 RONContabilitate economist Monday, September 22, 1986 1,500 RONMarketing merceolog Tuesday, November 16, 1993 1,700 RONMarketing merceolog Wednesday, March 22, 1995 2,000 RONIT programator Saturday, December 5, 1998 3,200 RONContabilitate economist Friday, January 12, 2007 3,400 RONIT economist Saturday, January 28, 2006 2,800 RON
85008500
1. Sa se afiseze in celula I24 (prin functie statistica) numarul de salariati din departamentul IT2. Sa se afiseze in celula H24(prin fuctie statistica) suma salariului de incadrare al angajatilor din departamentul Contabilitate, filiala Bucuresti
Vechime
24 ani34 ani31 ani17 ani18 ani35 ani51 ani29 ani16 ani35 ani21 ani29 ani18 ani30 ani20 ani37 ani29 ani28 ani24 ani16 ani17 ani
8
8
Spor vechime
Client 3 Client 2 Client 4 Client 1
Produs 2 36 buc. 7 buc. 193 buc. 7 buc.
C = 1,5p
Denumire Produs Produs 4 Produs 2
Cantitate Produs 51 193
`
Nume Client → Denumire produs
¯
Sa se recupereze din tabelul A3:F12 cantitatea livrata catre Client 4 dintr-un anumit produs care va fi ales din lista derulanta (B19).
Client 5
70 buc.
catre Client 4 dintr-un anumit produs care va fi ales din lista derulanta (B19).
Cod Client Nume Client Localitate Client Adresa Nr factură
100 Client1 Constanta Str. A 456,853
101 Client1 Constanta Str. A 456,854101 Client1 Constanta Str. A 456,856101 Client1 Constanta Str. A 456,858101 Client1 Constanta Str. A 456,859102 Client2 Bucuresti Str. B 456,855102 Client2 Bucuresti Str. B 456,861103 Client3 Brasov Str. C 456,852103 Client3 Brasov Str. C 456,857104 Client4 Cluj Str. D 456,860104 Client4 Cluj Str. D 456,862104 Client4 Cluj Str. D 456,864105 Client5 Arad Str. E 456,865105 Client5 Arad Str. E 456,866105 Client5 Arad Str. E 456,867106 Client6 Timisoara Str. F 456,868106 Client6 Timisoara Str. F 456,869107 Client7 Buzau Str. G 456,870107 Client7 Buzau Str. G 456,871107 Client7 Buzau Str. G 456,863
D = 1,5p
Să se afişeze valoarea medie a facturilor emise (prin functie baze de date) de Client1 care au fost plătite
Data facturii Data scadenţei Plătit Valoare
Wed 24 November 2004 20 zile Wed 22 December 2004 DA 5,200,100
Tue 3 February 2004 - Tue 3 February 2004 NU 10,000,000Mon 26 April 2004 20 zile Mon 24 May 2004 DA 3,600,000Mon 10 May 2004 10 zile Mon 24 May 2004 NU 2,300,000
Wed 23 March 2005 20 zile Wed 20 April 2005 NU 38,060,000Mon 21 February 2005 30 zile Mon 4 April 2005 NU 6,760,000
Sat 17 September 2005 15 zile Fri 7 October 2005 NU 23,000,000Fri 19 August 2005 15 zile Fri 9 September 2005 DA 14,000,000
Sat 14 May 2005 - Sat 14 May 2005 NU 7,000,000Sat 14 May 2005 - Sat 14 May 2005 DA 9,500,000
Fri 21 October 2005 8 zile Wed 2 November 2005 DA 12,500,000Tue 8 November 2005 3 zile Fri 11 November 2005 DA 8,650,000
Fri 9 December 2005 17 zile Tue 3 January 2006 NU 14,500,050Thu 5 January 2006 5 zile Thu 12 January 2006 DA 22,840,000Thu 5 January 2006 7 zile Mon 16 January 2006 NU 3,600,000
Fri 24 February 2006 - Fri 24 February 2006 NU 87,325,000Sat 4 March 2006 9 zile Thu 16 March 2006 NU 9,000,000
Mon 6 March 2006 14 zile Fri 24 March 2006 DA 4,780,000Tue 7 March 2006 6 zile Wed 15 March 2006 NU 1,000,000
Fri 2 June 2006 30 zile Fri 14 July 2006 NU 21,000,000
Nr zile graţie
emise (prin functie baze de date) de Client1 care au fost plătite
Plătit DA
Nume ClientClient1 Total Result
4,400,050 4,400,050
Data de distribuţie Număr factură Titlu carte
Mon 27 Oct 2003 383,746 Visual Basic for ApplicationSun 02 Nov 2003 383,746 Bazele InformaticiiThu 06 Nov 2003 383,747 Visual Basic for Application
Mon 10 Nov 2003 383,748 Baze de Date
Sat 03 Jan 2004 383,749 Office 2000 / XPTue 10 Feb 2004 383,750 Office 2000 / XPFri 13 Feb 2004 383,751 Baze de dateFri 13 Feb 2004 383,752 Bazele InformaticiiFri 13 Feb 2004 383,752 Office 2000 / XPFri 02 Apr 2004 383,753 Birotica 2000
Mon 10 May 2004 383,754 Birotica 2000Mon 10 May 2004 383,754 Office 2000 / XPMon 10 May 2004 383,755 Birotica 2000
Fri 21 May 2004 383,756 Programarea calculatoarelorFri 21 May 2004 383,756 Birotica 2000Fri 04 Jun 2004 383,757 Visual Basic for ApplicationSun 25 Jul 2004 383,758 Visual Basic for Application
Tue 19 Oct 2004 383,759 Programarea calculatoarelorTue 19 Oct 2004 383,759 Bazele InformaticiiFri 22 Oct 2004 383,760 Birotica 2000
Tue 09 Nov 2004 383,761 Bazele InformaticiiFri 12 Nov 2004 383,762 Birotica 2000Fri 12 Nov 2004 383,763 Programarea calculatoarelor
Tue 23 Nov 2004 383,764 Baze de DateTue 23 Nov 2004 383,764 Visual Fox ProTue 23 Nov 2004 383,765 Visual Basic for Application
Mon 20 Dec 2004 383,766 Birotica 2000
Fri 14 Jan 2005 383,767 Baze de DateTue 25 Jan 2005 383,768 Birotica 2000Tue 25 Jan 2005 383,768 Visual Fox ProSat 29 Jan 2005 383,769 Baze de DateSat 29 Jan 2005 383,769 Office 2000 / XPSat 29 Jan 2005 383,769 Birotică şi MultimediaSat 29 Jan 2005 383,770 Birotica profesionala
Sun 30 Jan 2005 383,771 Baze de DateMon 21 Feb 2005 383,772 Birotica 2000Sun 06 Mar 2005 383,773 Baze de Date
Wed 09 Mar 2005 383,774 Birotica 2000Wed 09 Mar 2005 383,774 Baze de Date
Fri 11 Mar 2005 383,775 Baze de DateSun 20 Mar 2005 383,776 Birotica profesionalaSun 20 Mar 2005 383,776 Baze de DateSun 20 Mar 2005 383,776 Birotica 2000Sun 20 Mar 2005 383,777 Baze de DateTue 05 Apr 2005 383,778 Birotica 2000
Tue 05 Apr 2005 383,778 Birotica profesionalaMon 18 Apr 2005 383,779 Baze de DateSun 08 May 2005 383,780 Baze de DateSun 08 May 2005 383,780 Bazele InformaticiiSun 08 May 2005 383,780 Birotica 2000Tue 10 May 2005 383,781 Baze de Date
Wed 11 May 2005 383,782 Bazele InformaticiiSat 25 Jun 2005 383,783 Bazele InformaticiiSat 25 Jun 2005 383,784 Baze de DateSat 25 Jun 2005 383,784 Birotica profesionalaSat 25 Jun 2005 383,785 Baze de Date
Sat 25 Jun 2005 383,786 Baze de Date
E = 1,5p
Agent vanzare Max of Valoare vânzariAlbu M. 180,000,000 lei Ionescu L. 550,000,000 lei Moisescu A. 371,000,000 lei Pintilie L. 318,000,000 lei Pleaşă C. 234,000,000 lei Popescu M. 341,250,000 lei Radulescu S. 398,750,000 lei Vasilescu D. 247,500,000 lei Total Result 550,000,000 lei
Să se genereze o subtotalizare, care să conţină maximul vanzarilor, pe agent vanzare
Albu M.
Ionescu L.
Moisescu
A.
Pintilie L.
Pleaşă
C.
Popescu M
.
Radules
cu S.
Vasiles
cu D.
Total
Result
0
100000000
200000000
300000000
400000000
500000000
600000000
Total
Max of Valoare vânzari
Nume Client Oras distributie Agent vanzare
Compania de librării Bucureşti Radulescu S.Compania de librării Bucureşti Radulescu S.Librăria "Central" Sibiu Radulescu S.
Vox 2000 Bucureşti Popescu M.
Libris Stoc Ploiesti Ionescu L.Librăria "Central" Sibiu Pleaşă C.ABCN ServCom Bucureşti Vasilescu D.ABCN ServCom Bucureşti Vasilescu D.ABCN ServCom Bucureşti Vasilescu D.Vox 2000 Bucureşti Moisescu A.Compania de librării Bucureşti Radulescu S.Compania de librării Bucureşti Radulescu S.Libris Stoc Ploiesti Ionescu L.RolCris Bucureşti Popescu M.RolCris Bucureşti Popescu M.Librăria "Central" Sibiu Pleaşă C.Compania de librării Bucureşti Albu M.Vox 2000 Bucureşti Ionescu L.Vox 2000 Bucureşti Ionescu L.Libris Stoc Ploiesti Moisescu A.Librăria "Central" Sibiu Pleaşă C.RolCris Bucureşti Moisescu A.RolCris Bucureşti Moisescu A.ABCN ServCom Bucureşti Ionescu L.ABCN ServCom Bucureşti Ionescu L.Libris Stoc Ploiesti Pleaşă C.
Compania de librării Bucureşti Pintilie L.
Compania de librării Bucureşti Ionescu L.Librăria "Central" Sibiu Albu M.Librăria "Central" Sibiu Albu M.Lumina Libris Buzău Pleaşă C.Lumina Libris Buzău Pleaşă C.Lumina Libris Buzău Pleaşă C.ABCN ServCom Bucureşti Moisescu A.Libris Stoc Ploiesti Pleaşă C.Compania de librării Bucureşti Pintilie L.Vox 2000 Bucureşti Radulescu S.Libraria UPG Ploiesti Albu M.Libraria UPG Ploiesti Albu M.ABCN ServCom Bucureşti Radulescu S.Vox 2000 Bucureşti Radulescu S.Lumina Libris Buzău Vasilescu D.Lumina Libris Buzău Vasilescu D.Compania de librării Bucureşti Pintilie L.ABCN ServCom Bucureşti Radulescu S.
ABCN ServCom Bucureşti Radulescu S.Libraria "PlaCedo" Buzău Moisescu A.Lumina Libris Buzău Moisescu A.Lumina Libris Buzău Moisescu A.Lumina Libris Buzău Moisescu A.Vox 2000 Bucureşti Pintilie L.Libraria "PlaCedo" Buzău Albu M.Compania de librării Bucureşti Ionescu L.Libraria UPG Ploiesti Ionescu L.Libraria UPG Constanta Ionescu L.ABCN ServCom Bucureşti Albu M.
Librăria "Central" Sibiu Moisescu A.
care să conţină maximul vanzarilor, pe agent vanzare
Albu M.
Ionescu L.
Moisescu
A.
Pintilie L.
Pleaşă
C.
Popescu M
.
Radules
cu S.
Vasiles
cu D.
Total
Result
0
100000000
200000000
300000000
400000000
500000000
600000000
Total
Max of Valoare vânzari
Cantitate vanduta Pret carte Valoare vânzari
40 180,000 lei 7,200,000 lei 80 240,000 lei 19,200,000 lei
800 180,000 lei 144,000,000 lei
400 275,000 lei 110,000,000 lei
900 230,000 lei 207,000,000 lei 850 230,000 lei 195,500,000 lei 900 275,000 lei 247,500,000 lei
1000 240,000 lei 240,000,000 lei 30 230,000 lei 6,900,000 lei
1400 265,000 lei 371,000,000 lei 16 265,000 lei 4,240,000 lei
600 230,000 lei 138,000,000 lei 650 265,000 lei 172,250,000 lei
1050 325,000 lei 341,250,000 lei 800 265,000 lei 212,000,000 lei
1300 180,000 lei 234,000,000 lei 1000 180,000 lei 180,000,000 lei 750 325,000 lei 243,750,000 lei
60 240,000 lei 14,400,000 lei 125 265,000 lei 33,125,000 lei 600 240,000 lei 144,000,000 lei 100 265,000 lei 26,500,000 lei 250 325,000 lei 81,250,000 lei
90 275,000 lei 24,750,000 lei 100 180,000 lei 18,000,000 lei 100 180,000 lei 18,000,000 lei
360 265,000 lei 95,400,000 lei
2000 275,000 lei 550,000,000 lei 20 265,000 lei 5,300,000 lei 30 180,000 lei 5,400,000 lei 40 275,000 lei 11,000,000 lei
400 230,000 lei 92,000,000 lei 200 265,000 lei 53,000,000 lei 280 245,000 lei 68,600,000 lei 300 275,000 lei 82,500,000 lei
1200 265,000 lei 318,000,000 lei 1450 275,000 lei 398,750,000 lei
50 265,000 lei 13,250,000 lei 60 275,000 lei 16,500,000 lei 90 275,000 lei 24,750,000 lei
900 245,000 lei 220,500,000 lei 350 275,000 lei 96,250,000 lei 250 265,000 lei 66,250,000 lei 360 275,000 lei 99,000,000 lei 750 265,000 lei 198,750,000 lei
45 245,000 lei 11,025,000 lei 75 275,000 lei 20,625,000 lei 20 275,000 lei 5,500,000 lei 10 240,000 lei 2,400,000 lei 40 265,000 lei 10,600,000 lei
500 275,000 lei 137,500,000 lei 240 240,000 lei 57,600,000 lei 800 240,000 lei 192,000,000 lei 365 275,000 lei 100,375,000 lei 125 245,000 lei 30,625,000 lei 180 275,000 lei 49,500,000 lei
320 275,000 lei 88,000,000 lei
Agent vanzare Max of Valoare vânzariAlbu M. 180,000,000 lei Ionescu L. 550,000,000 lei Moisescu A. 371,000,000 lei Pintilie L. 318,000,000 lei Pleaşă C. 234,000,000 lei Popescu M. 341,250,000 lei Radulescu S. 398,750,000 lei Vasilescu D. 247,500,000 lei Total Result 550,000,000 lei
Agent vanzare Max of Valoare vânzariAlbu M. 180,000,000 lei Ionescu L. 550,000,000 lei Moisescu A. 371,000,000 lei Pintilie L. 318,000,000 lei Pleaşă C. 234,000,000 lei Popescu M. 341,250,000 lei Radulescu S. 398,750,000 lei Vasilescu D. 247,500,000 lei Total Result 550,000,000 lei
Funcţia Departament Average of Salariu încadrareanalist 3,400
IT 3,400contabil 1,833
Contabilitate 1,800Resurse umane 1,900
economist 2,700Contabilitate 2,450IT 2,400Marketing 3,067
merceolog 1,570Contabilitate 1,300Marketing 1,638
operator 2,100IT 2,100
programator 3,300IT 3,300
Total Result 2,431
Marca Nume Prenume Data nasterii
1000 POPESCU Viorel Tuesday, January 1, 19801001 MIHAI Carmen Tuesday, April 24, 19561002 POPA Florin Wednesday, May 30, 19841003 ALBU Constanta Thursday, March 19, 19811004 NEDELCU Mihai Sunday, January 23, 19721005 CHIRU Bianca Wednesday, November 25, 19591006 ALBITER Oana Sunday, March 3, 19851007 VLAD Petru Sunday, November 18, 19621008 CONSTANTIN Dan Wednesday, January 19, 19721009 MONDREA Laura Tuesday, November 2, 19821010 SAVU Cătălin Monday, November 21, 19601011 PANAIT Cornel Tuesday, November 13, 19621012 COMAN Aura Monday, May 23, 19771013 BLĂGESCU Mădălina Friday, August 24, 19731014 MIHAI Dinu Sunday, November 25, 19621015 DEDU Natalia Friday, January 6, 19841016 GANEA Pavel Wednesday, December 17, 19691017 SORESCU Liana Sunday, February 27, 19551018 PETRE Cristina Sunday, September 9, 19791019 MANESCU Andreea Friday, November 30, 19621020 VISAN Alexandra Monday, March 1, 1971
F = 1,5p
Să se realizeze următoarea sintetizare a bazei de date (prin tabela pivot, plasata intr-o noua foaie de calcul) care sa calculeze media salariilor de incadrare pe functii si departamente
Filiala Departament Funcţia
Ploiesti Marketing economistBucuresti Marketing merceologBucuresti Contabilitate contabilPloiesti Marketing economistBucuresti IT analistConstanta IT analistConstanta Marketing merceologBucuresti IT operatorPloiesti Marketing economistBucuresti Contabilitate contabilBucuresti IT economistBucuresti IT programatorBucuresti IT programatorConstanta Contabilitate merceologPloiesti Resurse umane contabilBucuresti Contabilitate economistBucuresti Marketing merceologConstanta Marketing merceologPloiesti IT programatorBucuresti Contabilitate economistConstanta IT economist
a bazei de date (prin tabela pivot, plasata intr-o noua foaie de calcul) care sa calculeze media salariilor de incadrare pe functii si departamente
Data angajării Salariu încadrare
Tuesday, December 29, 1998 3,100Thursday, December 8, 1988 1,350
Wednesday, November 13, 1991 1,700Saturday, February 25, 2006 3,200
Wednesday, February 2, 2005 3,000Thursday, January 21, 1988 3,800
Monday, March 6, 1972 1,500Friday, October 29, 1993 2,100
Wednesday, July 16, 1997 2,900Tuesday, February 2, 1988 1,900
Thursday, September 19, 2002 2,000Thursday, December 9, 1993 3,500
Wednesday, February 9, 2005 3,200Friday, January 15, 1993 1,300
Monday, June 2, 2003 1,900Monday, September 22, 1986 1,500Tuesday, November 16, 1993 1,700Wednesday, March 22, 1995 2,000Saturday, December 5, 1998 3,200Thursday, January 12, 2006 3,400
Friday, January 28, 2005 2,800
obtinut enuntOficiu 1 1A 1.5B 1.5C 1.5D 1.5E 1.5F 1.5
1 10
Departament FuncţiaContabilitate ContabilitateITcontabil economist merceolog analist economi
1,800 2,450 1,300 1,960 3,400 2,400
IT Result Marketing Marketing ReResurse umaneoperator programator economismerceolog contabil
2,100 3,300 2,950 3,067 1,638 2,250 1,900
Resurse umane ResuTotal Result
1,900 2,431