7/21/2019 Excel Intermedio - 4 Div

1/7

WAOZQA]T

ARMAC

7/21/2019 Excel Intermedio - 4 Div

2/7

Djths da cj WaoZuast0

Khnora dac Juthr0 @hrga Jca`jkdrh Mruz Barkkdaz Ldlhnj0 Aspjhc

Klvac Adumjtlvh0 Dlvarslelmjdh - Lktarnadlhraj da Mhkhmlnlakth0 Lkehrntlmj Vjs0 Gujtanjcj

Lktrhdummlk0

Ns Axmac as ukj jpclmjmlk qua puada rajclzjr dlvarsjs tjrajs, ak shcumlk da prhocanjs mhtldljkhs sa rashcvark da njkarj sakmHptlnlzjkdh ac tlanph ak ac trjtjnlakth, jkclsls y prasaktjmlk lkehrnjmlk. Ak astj jmtlvldjd dasjrrhccjranhs tanjs mhnh0 Tgrelmjs dlknlmjs, elctrhs, clstjs, njmrhs, eukmlhkas, aktra htrhs

7/21/2019 Excel Intermedio - 4 Div

3/7

Tjraj0

Ac ho`atlvh da astj Waoquast as qua cjs y chs astudljktas dasjrrhccak mhnpatakmljs oslmjs ak ac elctrhs, njmrhs, eukmlhkas, aktra htrhs, qua parnltjk rajclzjr mcmuchs, jkclsls y prasaktjmlk da prhm

ukj anprasj rajc h lnjglkjrlj.

_ajclzj ch slgulakta0

:.- Njpj lktarjmtlvh0 Jc djr mclmi ak jcgk pjs da Maktrhjnrlmj, daoa daspcagjr lkehrnjmlk gahph

?.- Ejmturj0 Cj tlakdj cj Oakdlmlk kamasltj qua acjohras uk dhmunakth ak Ns. Axmac, qua mprhdumths y cj utlclmas jc nhnakth da ccakjr cj ejmturj. Ac Kh. mhrracjtlvh da cj ejmturj daoa lkmraanlslk da ejmturj y j cj vaz daoa ohrrjr thdhs chs djths pjrj axtakdar ukj kuavj. ]agk tu mrltada axmac pjrj daspcagjr lkehrnjmlk, jdans gakarjr tjocjs dlknlmjs pjrj prasaktjr lkehrna dac lk

7/21/2019 Excel Intermedio - 4 Div

4/7

Vrhmash0

:) Ak cj bh`j Kh. : da Axmac dasjrrhccj ch slgulakta0

j. Daelklr qua as ukj njmrh

o. Mnh sa grjoj ukj njmrh8(asmrlolr chs pjshs)m. Axpclqua cjs dhs ehrnjs ak qua puada utlclzjr cj hpmlk clstj ak Ns. Axmac8d. Vjrj qu slrvak cjs mhnlccjs y ac pukth y mhnj ak ukj eukmlk8a. Axpclqua cjs eukmlhkas qua daoa utlclzjr pjrj lksartjr ukj clstje. Mujcas shk cjs vaktj`js da cjs tjocjs y grelmjs dlknlmjs8

g. Axpclqua y a`anpclelqua cjs slgulaktas eukmlhkas0 ]L, OQ]MJ_Ub. Mnh sa lksartj ac snohch da Zuatzjc8

?) Ak cj bh`j Kh. ? da Axmac raglstrj ac lkvaktjrlh

=) Ak cj bh`j Kh. = da Axmac dlsaj cj ejmturj.

7/21/2019 Excel Intermedio - 4 Div

5/7

_amurshs0

Ulsujclzj h Dasmjrgj chs slgulaktas vldahs y prjmtlmjrchs.

:.- bttps0//drlva.ghhgca.mhn/elca/d/6O45QC:sbjrlkg

?.- bttps0//drlva.ghhgca.mhn/elca/d/6O45QC:

7/21/2019 Excel Intermedio - 4 Div

6/7

Avjcujmlk0

Mrltarlhs j Avjcujr Ujchr VuktahDlsah0 Mhchr, Astlch,Mrajtlvldjd, Aspjmlh.

? pts.

Thdjs cjs eukmlhkas,hparjmlhkas, aktra htrhs,

mhrramtjnakta

1 pts.

Vrasaktj cjs dhs jmtlvldjdaselkjclzjdjs da njkarj dlgltjc alnprash

= pts.

Thtjc :6 pts.

7/21/2019 Excel Intermedio - 4 Div

7/7

Mhkmcuslk

Mrdlths0

_ajclz0 Clm. NJ. @hrga Jca`jkdrh Mruz Barkkdaz.

:.- Cjs tjocjs dlknlmjskhs parnltak mrajr dlearaktas vlstjs da chs djths da jmuardh j cjs vjrljocas qua datjocj dlknlmj takdranhs ukj grjk mjktldjd da phslolcldjdas da mhnpjrjmlk da njkarj qua phdranhs bjmar uda cj lkehrnjmlk slk kamasldjd da astjr mrajkdh raphrtas lkdlvldujcas.

?.- Cj eukmlkOQ]MJ_Uparnlta lktrhdumlr ac vjchr da ukj macdj pjrj ousmjr ac vjchr da ukj macdj mhrrasphkdlah rakgck.

=.- Cj eukmlk ]L ak Axmacas pjrta dac gruph da eukmlhkas Cglmjs y khs parnlta avjcujr ukj mhkdlmlk pjrjvardjdarj. Cj eukmlk ]L as da grjk jyudj pjrj thnjr damlslhkas ak ojsa jc rasuctjdh hotakldh ak cj pruaoj cglm