Model Examen TAO - ASE

download Model Examen TAO - ASE

of 28

  • date post

    26-Oct-2014
  • Category

    Documents

  • view

    77
  • download

    21

Embed Size (px)

description

Model examen TAO.

Transcript of Model Examen TAO - ASE

Marca

Nume Prenume

Data nasterii

Filiala

Departament

1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020

POPESCU Viorel MIHAI Carmen POPA Florin ALBU Constanta NEDELCU Mihai CHIRU Bianca ALBITER Oana VLAD Petru CONSTANTIN Dan MONDREA Laura SAVU Ctlin PANAIT Cornel COMAN Aura BLGESCU Mdlina MIHAI Dinu DEDU Natalia GANEA Pavel SORESCU Liana PETRE Cristina MANESCU Andreea VISAN Alexandra A = 1,5p

Tuesday, January 01, 1980 Tuesday, April 24, 1956 Wednesday, May 30, 1984 Thursday, March 19, 1981 Sunday, January 23, 1972 Wednesday, November 25, 1959 Sunday, March 03, 1985 Sunday, November 18, 1962 Wednesday, January 19, 1972 Tuesday, November 02, 1982 Monday, November 21, 1960 Tuesday, November 13, 1962 Monday, May 23, 1977 Friday, August 24, 1973 Sunday, November 25, 1962 Friday, January 06, 1984 Wednesday, December 17, 1969 Sunday, February 27, 1955 Sunday, September 09, 1979 Friday, November 30, 1962 Monday, March 01, 1971

Ploiesti Bucuresti Bucuresti Ploiesti Bucuresti Constanta Constanta Bucuresti Ploiesti Bucuresti Bucuresti Bucuresti Bucuresti Constanta Ploiesti Bucuresti Bucuresti Constanta Ploiesti Bucuresti Constanta

Marketing Marketing Contabilitate Marketing IT IT Marketing IT Marketing Contabilitate IT IT IT Contabilitate Resurse umane Contabilitate Marketing Marketing IT Contabilitate IT

(0,5p) (1p)

1. Sa se valideze departamentul (zona E3:E23) astfel incat sa permita introducerea doar a departamente 2. Sa se valideze campul salariu incadrare care trebuie sa fie cuprinsa intre 1000 si 4000, cu mesaj de e

Funcia

Data angajrii

Salariu ncadrare

Departament

economist merceolog contabil economist analist analist merceolog operator economist contabil economist programator programator merceolog contabil economist merceolog merceolog programator economist economist

Wednesday, December 29, 2010 Thursday, December 08, 1988 Wednesday, November 13, 1991 Saturday, February 25, 2006 Tuesday, February 02, 2010 Thursday, January 21, 1988 Monday, March 06, 1972 Friday, October 29, 1993 Wednesday, July 16, 1997 Tuesday, February 02, 2010 Thursday, September 19, 2002 Thursday, December 09, 1993 Wednesday, February 09, 2005 Friday, January 15, 1993 Monday, June 02, 2003 Monday, September 22, 1986 Tuesday, November 16, 1993 Monday, March 22, 2010 Saturday, December 05, 1998 Thursday, January 12, 2006 Friday, January 28, 2005

1234

1350 1700 3200 3000 3800 1500 2100 2900 1900 2000 3500 3200 1300 1900 1500 1700 2000 3200 3400 2800

Marketing IT Contabilitate Resurse umane

Departament

Marketing Contabilitate IT Resurse umane

a doar a departamentelor din zona J3:J6 si 4000, cu mesaj de eroare

Marca

Nume Prenume

Data nasterii

Filiala

1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020

POPESCU Viorel MIHAI Carmen POPA Florin ALBU Constanta NEDELCU Mihai CHIRU Bianca ALBITER Oana VLAD Petru CONSTANTIN Dan MONDREA Laura SAVU Ctlin PANAIT Cornel COMAN Aura BLGESCU Mdlina MIHAI Dinu DEDU Natalia GANEA Pavel SORESCU Liana PETRE Cristina MANESCU Andreea VISAN Alexandra

Tuesday, January 01, 1980 Tuesday, April 24, 1956 Wednesday, May 30, 1984 Thursday, March 19, 1981 Sunday, January 23, 1972 Wednesday, November 25, 1959 Sunday, March 03, 1985 Sunday, November 18, 1962 Wednesday, January 19, 1972 Tuesday, November 02, 1982 Monday, November 21, 1960 Tuesday, November 13, 1962 Monday, May 23, 1977 Friday, August 24, 1973 Sunday, November 25, 1962 Friday, January 06, 1984 Wednesday, December 17, 1969 Sunday, February 27, 1955 Sunday, September 09, 1979 Friday, November 30, 1962 Monday, March 01, 1971 B = 1,5p

Ploiesti Bucuresti Bucuresti Ploiesti Bucuresti Constanta Constanta Bucuresti Ploiesti Bucuresti Bucuresti Bucuresti Bucuresti Constanta Ploiesti Bucuresti Bucuresti Constanta Ploiesti Bucuresti Constanta

(0,5p) (1p)

1. Sa se afiseze in celula I24 (prin functie statistica) numarul de salariati din departamentul IT 2. Sa se afiseze in celula H24(prin fuctie statistica) suma salariului de incadrare al angajatilor din departamentul Con

Departament

Funcia

Data angajrii

Salariu ncadrare

Vechime

Marketing Marketing Contabilitate Marketing IT IT Marketing IT Marketing Contabilitate IT IT IT Contabilitate Resurse umane Contabilitate Marketing Marketing IT Contabilitate IT

economist merceolog contabil economist analist analist merceolog operator economist contabil economist programator programator merceolog contabil economist merceolog merceolog programator economist economist

Tuesday, December 29, 1998 Thursday, December 08, 1988 Wednesday, November 13, 1991 Saturday, February 25, 2006 Wednesday, February 02, 2005 Thursday, January 21, 1988 Monday, March 06, 1972 Friday, October 29, 1993 Monday, July 16, 2007 Tuesday, February 02, 1988 Thursday, September 19, 2002 Thursday, December 09, 1993 Wednesday, February 09, 2005 Friday, January 15, 1993 Monday, June 02, 2003 Monday, September 22, 1986 Tuesday, November 16, 1993 Wednesday, March 22, 1995 Saturday, December 05, 1998 Friday, January 12, 2007 Saturday, January 28, 2006

3,100 RON 1,350 RON 1,700 RON 3,200 RON 3,000 RON 3,800 RON 1,500 RON 2,100 RON 2,900 RON 1,900 RON 2,000 RON 3,500 RON 3,200 RON 1,300 RON 1,900 RON 1,500 RON 1,700 RON 2,000 RON 3,200 RON 3,400 RON 2,800 RON8500 8500

14 ani 24 ani 21 ani 6 ani 7 ani 24 ani 40 ani 19 ani 5 ani 24 ani 10 ani 19 ani 7 ani 19 ani 9 ani 26 ani 19 ani 17 ani 14 ani 5 ani 6 ani8 8

n departamentul IT drare al angajatilor din departamentul Contabilitate, filiala Bucuresti

Spor vechime

Nume Client Denumire produs Produs 2 C = 1,5p

Client 3 36 buc.

Client 2 7 buc.

Client 4 193 buc.

Client 1 7 buc.

Sa se recupereze din tabelul A3:F12 cantitatea livrata catre Client 4 dintr-un anumit produs care va fi al

Denumire Produs Produs 4 Cantitate Produs 51

Produs 2 193

`

Client 5 70 buc.

umit produs care va fi ales din lista derulanta (B19).

Cod Client

Nume Client

Localitate ClientConstanta Constanta Constanta Constanta Constanta Bucuresti Bucuresti Brasov Brasov Cluj Cluj Cluj Arad Arad Arad Timisoara Timisoara Buzau Buzau Buzau

AdresaStr. A Str. A Str. A Str. A Str. A Str. B Str. B Str. C Str. C Str. D Str. D Str. D Str. E Str. E Str. E Str. F Str. F Str. G Str. G Str. G

Nr factur456,853 456,854 456,856 456,858 456,859 456,855 456,861 456,852 456,857 456,860 456,862 456,864 456,865 456,866 456,867 456,868 456,869 456,870 456,871 456,863

100 Client1 101 101 101 101 102 102 103 103 104 104 104 105 105 105 106 106 107 107 107 Client1 Client1 Client1 Client1 Client2 Client2 Client3 Client3 Client4 Client4 Client4 Client5 Client5 Client5 Client6 Client6 Client7 Client7 Client7

D = 1,5pS se afieze valoarea medie a facturilor emise (prin functie baze de date) de Client1 care au fost pltite

Data facturiiWed 24 November 2004 Tue 3 February 2004 Mon 26 April 2004 Mon 10 May 2004 Wed 23 March 2005 Mon 21 February 2005 Sat 17 September 2005 Fri 19 August 2005 Sat 14 May 2005 Sat 14 May 2005 Fri 21 October 2005 Tue 8 November 2005 Fri 9 December 2005 Thu 5 January 2006 Thu 5 January 2006 Fri 24 February 2006 Sat 4 March 2006 Mon 6 March 2006 Tue 7 March 2006 Fri 2 June 2006

Nr zile graie20 zile 20 zile 10 zile 20 zile 30 zile 15 zile 15 zile 8 zile 3 zile 17 zile 5 zile 7 zile 9 zile 14 zile 6 zile 30 zile

Data scadeneiWed 22 December 2004 Tue 3 February 2004 Mon 24 May 2004 Mon 24 May 2004 Wed 20 April 2005 Mon 4 April 2005 Fri 7 October 2005 Fri 9 September 2005 Sat 14 May 2005 Sat 14 May 2005 Wed 2 November 2005 Fri 11 November 2005 Tue 3 January 2006 Thu 12 January 2006 Mon 16 January 2006 Fri 24 February 2006 Thu 16 March 2006 Fri 24 March 2006 Wed 15 March 2006 Fri 14 July 2006

Pltit DA NU DA NU NU NU NU DA NU DA DA DA NU DA NU NU NU DA NU NU

Valoare 5,200,100 10,000,000 3,600,000 2,300,000 38,060,000 6,760,000 23,000,000 14,000,000 7,000,000 9,500,000 12,500,000 8,650,000 14,500,050 22,840,000 3,600,000 87,325,000 9,000,000 4,780,000 1,000,000 21,000,000

ate) de Client1 care au fost pltite

Pltit

DA Column Labels Client1 Grand Total 4400050 4400050

Medie Valoare

Data de distribuie Mon 27 Oct 2003 Sun 02 Nov 2003 Thu 06 Nov 2003 Mon 10 Nov 2003 Sat 03 Jan 2004 Tue 10 Feb 2004 Fri 13 Feb 2004 Fri 13 Feb 2004 Fri 13 Feb 2004 Fri 02 Apr 2004 Mon 10 May 2004 Mon 10 May 2004 Mon 10 May 2004 Fri 21 May 2004 Fri 21 May 2004 Fri 04 Jun 2004 Sun 25 Jul 2004 Tue 19 Oct 2004 Tue 19 Oct 2004 Fri 22 Oct 2004 Tue 09 Nov 2004 Fri 12 Nov 2004 Fri 12 Nov 2004 Tue 23 Nov 2004 Tue 23 Nov 2004 Tue 23 Nov 2004 Mon 20 Dec 2004 Fri 14 Jan 2005 Tue 25 Jan 2005 Tue 25 Jan 2005 Sat 29 Jan 2005 Sat 29 Jan 2005 Sat 29 Jan 2005 Sat 29 Jan 2005 Sun 30 Jan 2005 Mon 21 Feb 2005 Sun 06 Mar 2005 Wed 09 Mar 2005 Wed 09 Mar 2005 Fri 11 Mar 2005 Sun 20 Mar 2005 Sun 20 Mar 2005 Sun 20 Mar 2005

Numr factur 383,746 383,746 383,747 383,748 383,749 383,750 383,751 383,752 383,752 383,753 383,754 383,754 383,755 383,756 383,756 383,757 383,758 383,759 383,759 383,760 383,761 383,762 383,763 383,764 383,764 383,765 383,766 383,767 383,768 383,768 383,769 383,769 383,769 383,770 383,771 383,772 383,773 383,774 383,774 383,775 383,776 383,776 383,776

Titlu carte Visual Basic for Application Bazele Informaticii Visual Basic for Application Baze de Date Office 2000 / XP Office 2000 / XP Baze de date Bazele Informaticii Office 2000 / XP Birotica 2000 Birotica 2000 Office 2000 / XP Birotica 2000 Programarea calculatoa