model test - tehnologia aplicatiilor ofice

7/23/2019 Model test - Tehnologia aplicatiilor ofice

1/10

122B

GRUPA

obtinut enunt

Ofciu 1 1

A 3

B 4

C 2

total 1 10


2/10

NUME PRENUME

Salvati: grupa_nume_prenume_bilet_1


3/10

Marca Nume Prenume Data nasterii

1000 POPESCU Viorel Tuesday, January 01, 1980

1001 MIHAI Carmen Tuesday, Aril !", 19#$

100! POPA %lorin &ednesday, May '0, 198"100' A()U Cons*an*a T+ursday, Mar+ 19, 1981

100" -E.E(CU Mi+ai Sunday, January !', 19/!

100# CHIU )iana &ednesday, -oem2er !#, 19#9

100$ A()ITE Oana Sunday, Mar+ 0', 198#

100/ V(A. Pe*ru Sunday, -oem2er 18, 19$!

1008 CO-STA-TI- .an &ednesday, January 19, 19/!

1009 MO-.EA (aura Tuesday, -oem2er 0!, 198!

1010 SAVU C3*3lin Monday, -oem2er !1, 19$0

1011 PA-AIT Cornel Tuesday, -oem2er 1', 19$!101! COMA- Aura Monday, May !', 19//

101' )(45ESCU M3d3lina %riday, Au6us* !", 19/'

101" MIHAI .inu Sunday, -oem2er !#, 19$!

101# .E.U -a*alia %riday, January 0$, 198"

101$ 5A-EA Pael &ednesday, .eem2er 1/, 19$9

101/ SOESCU (iana Sunday, %e2ruary !/, 19##

1018 PETE Cris*ina Sunday, Se*em2er 09, 19/9

1019 MA-ESCU Andreea %riday, -oem2er '0, 19$!

10!0 VISA- Ale7andra Monday, Mar+ 01, 19/1

A = 3p

(1p) 1. In celula H24 sa se calculeze (prin functie statistica) media salariului de i

(2p) 2. Sa se scoata in evidenta prin text de culoare rosie Numele persoanelor


4/10

Filiala Departament Funcia

Ploies*i Mare*in6 eonomis*

)uures*i Mare*in6 mereolo6

)uures*i Con*a2ili*a*e on*a2ilPloies*i Mare*in6 eonomis*

)uures*i IT analis*

Cons*an*a IT analis*

Cons*an*a Mare*in6 mereolo6

)uures*i IT oera*or

Ploies*i Mare*in6 eonomis*

)uures*i Con*a2ili*a*e on*a2il

)uures*i IT eonomis*

)uures*i IT ro6rama*or )uures*i IT ro6rama*or

Cons*an*a Con*a2ili*a*e mereolo6

Ploies*i esurse umane on*a2il

)uures*i Con*a2ili*a*e eonomis*

)uures*i Mare*in6 mereolo6

Cons*an*a Mare*in6 mereolo6

Ploies*i IT ro6rama*or

)uures*i Con*a2ili*a*e eonomis*

Cons*an*a IT eonomis*

ncadrare al angajatilor economisti.

in departamentul I cu functia de analist.


5/10

Data angajrii Salariu ncadrare

&ednesday, .eem2er !9, !010 '100

T+ursday, .eem2er 08, 1988 1'#0

&ednesday, -oem2er 1', 1991 1/00Sa*urday, %e2ruary !#, !00$ '!00

Tuesday, %e2ruary 0!, !010 '000

T+ursday, January !1, 1988 '800

Monday, Mar+ 0$, 19/! 1#00

%riday, O*o2er !9, 199' !100

&ednesday, July 1$, 199/ !900

Tuesday, %e2ruary 0!, !010 1900

T+ursday, Se*em2er 19, !00! !000

T+ursday, .eem2er 09, 199' '#00&ednesday, %e2ruary 09, !00# '!00

%riday, January 1#, 199' 1'00

Monday, June 0!, !00' 1900

Monday, Se*em2er !!, 198$ 1#00

Tuesday, -oem2er 1$, 199' 1/00

Monday, Mar+ !!, !010 !000

Sa*urday, .eem2er 0#, 1998 '!00

T+ursday, January 1!, !00$ '"00

%riday, January !8, !00# !800


6/10

Marca Nume Prenume Data nasterii

1000 POPESCU Viorel Tuesday, January 01, 19801001 MIHAI Carmen Tuesday, Aril !", 19#$100! POPA %lorin &ednesday, May '0, 198"100' A()U Cons*an*a T+ursday, Mar+ 19, 1981100" -E.E(CU Mi+ai Sunday, January !', 19/!100# CHIU )iana &ednesday, -oem2er !#, 19#9100$ A()ITE Oana Sunday, Mar+ 0', 198#100/ V(A. Pe*ru Sunday, -oem2er 18, 19$!1008 CO-STA-TI- .an &ednesday, January 19, 19/!1009 MO-.EA (aura Tuesday, -oem2er 0!, 198!1010 SAVU C3*3lin Monday, -oem2er !1, 19$01011 PA-AIT Cornel Tuesday, -oem2er 1', 19$!

101! COMA- Aura Monday, May !', 19//101' )(45ESCU M3d3lina %riday, Au6us* !", 19/'101" MIHAI .inu Sunday, -oem2er !#, 19$!101# .E.U -a*alia %riday, January 0$, 198"101$ 5A-EA Pael &ednesday, .eem2er 1/, 19$9101/ SOESCU (iana Sunday, %e2ruary !/, 19##1018 PETE Cris*ina Sunday, Se*em2er 09, 19/91019 MA-ESCU Andreea %riday, -oem2er '0, 19$!

10!0 VISA- Ale7andra Monday, Mar+ 01, 19/1

B = 4p

(2p) 1. Sa se afseze in celula I24, nua!ul "e an#a$ati ca!e au sala!iul "e

(2p)

Pen*ru salariu : 1#00 ;< imo=i*ul es*e 1!> din s

Pen*ru salariu urins ?n*re 1#01 @i !000 ;< imo

Pen*ru salariu urins ?n*re !001 @i '800 ;< i

Pen*ru salariu inadrare es*e '801 ;< i

2. Sa se calculeze vec!imea si impoitul pe salariu! astfel"


7/10

Filiala Departament Funcia

Ploies*i Mare*in6 eonomis*)uures*i Mare*in6 mereolo6)uures*i Con*a2ili*a*e on*a2ilPloies*i Mare*in6 eonomis*)uures*i IT analis*Cons*an*a IT analis*Cons*an*a Mare*in6 mereolo6)uures*i IT oera*or Ploies*i Mare*in6 eonomis*)uures*i Con*a2ili*a*e on*a2il)uures*i IT eonomis*)uures*i IT ro6rama*or

)uures*i IT ro6rama*or Cons*an*a Con*a2ili*a*e mereolo6Ploies*i esurse umane on*a2il)uures*i Con*a2ili*a*e eonomis*)uures*i Mare*in6 mereolo6Cons*an*a Mare*in6 mereolo6Ploies*i IT ro6rama*or )uures*i Con*a2ili*a*e eonomis*

Cons*an*a IT eonomis*

inca"!a!e cup!ins int!e 2000 si 3300

lariu inadrare

=i*ul es*e 18>

mo=i*ul es*e !1>

o=i*ul es*e !#>


8/10

Data angajrii Salariu ncadrare "ec#ime $mpoit

Tuesday, .eem2er !9, 1998 ',100 O-T+ursday, .eem2er 08, 1988 1,'#0 O-

&ednesday, -oem2er 1', 1991 1,/00 O-Sa*urday, %e2ruary !#, !00$ ',!00 O-

&ednesday, %e2ruary 0!, !00# ',000 O-T+ursday, January !1, 1988 ',800 O-

Monday, Mar+ 0$, 19/! 1,#00 O-%riday, O*o2er !9, 199' !,100 O-

Monday, July 1$, !00/ !,900 O-Tuesday, %e2ruary 0!, 1988 1,900 O-

T+ursday, Se*em2er 19, !00! !,000 O-T+ursday, .eem2er 09, 199' ',#00 O-

&ednesday, %e2ruary 09, !00# ',!00 O-%riday, January 1#, 199' 1,'00 O-

Monday, June 0!, !00' 1,900 O-Monday, Se*em2er !!, 198$ 1,#00 O-Tuesday, -oem2er 1$, 199' 1,/00 O-&ednesday, Mar+ !!, 199# !,000 O-

Sa*urday, .eem2er 0#, 1998 ',!00 O-%riday, January 1!, !00/ ',"00 O-

Sa*urday, January !8, !00$ !,800 O-


9/10

Denumire mijloc %i& Data punerii n %unciune

#4$% &&& aaa !ursda' 12 eruar' 1**%

#4$* +++ Saturda' 1% ,ul' 1**%

#4%- ccc !ursda' -/ Septemer 1**%

#4%1 000 ddd onda' 2# ,anuar' 1***#4%2 eee Sunda' -3 ,une 1***

#4%/ fff onda' -% Novemer 1***

#4%4 ggg 5ednesda' 12 &pril 2---

#4%# HHH !!! !ursda' 14 ,une 2--1

#4%3 ,,, jjj onda' -4 eruar' 2--2

#4%$ 666 777 uesda' -3 &ugust 2--2

#4%% 888 lll onda' 1$ arc! 2--/

#4%* mmm Saturda' 1* &pril 2--/

#4*- NNN nnn Saturda' -# &pril 2--/

#4*1 999 ooo onda' -% Septemer 2--/#4*2 ::: ppp 5ednesda' 1* Novemer 2--/

#4*/ ;;; > uuu onda' 14 eruar' 2--#

#4*% ??? vvv Saturda' 12 arc! 2--#

#4** @@@ ''' rida' 1# &pril 2--#

##-- AAA zzz Saturda' 21 a' 2--#

' = (p

Celula B32 !ep!ezinta o lista "e!ulanta cu eleentele "e la A2 la A24

SB se extragB Cn celula /2 locul de folosinta al mijlocului fixD prin consultarea N

Numr in)entar *oc %olosin

Numrin)entar


10/10

*oc %olosin

&provizionare

ar7eting

I

inanciar&telier ontaj

Sectia S0?

ontailitate

I

ar7eting

inanciar

Sectia S0?

ontailitate

0esfacere

Sectia ecanicaI

Sectia ecanica

&provizionare

ontailitate

Sectia ecanica

&telier ontaj

Sectia S0?

&telier ontaj

inanciar

mBrului de inventar.

model test - tehnologia aplicatiilor ofice

Documents