{"id":1516,"date":"2020-08-21T00:46:47","date_gmt":"2020-08-20T22:46:47","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=1516"},"modified":"2026-06-18T19:20:51","modified_gmt":"2026-06-18T17:20:51","slug":"matura-xiv","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=1516","title":{"rendered":"Maturski test &#8211; XIV"},"content":{"rendered":"<p>1.\u00a0 Dekadni broj 82<sub>(10)<\/sub> u sistemu binarnih brojeva je:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>1100110<\/li>\n<li>0100101<\/li>\n<li>1010010 *<\/li>\n<li>1110111<\/li>\n<\/ol>\n<p>2. Hardverska komponenta kompjutera prikazana na donjoj slici je:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1517\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A1.png\" alt=\"Matura - A1\" width=\"183\" height=\"163\" \/><\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Procesor (CPU) *<\/li>\n<li>Hard Disk<\/li>\n<li>Mati\u010dna plo\u010da (Motherboard)<\/li>\n<li>Memorija (RAM)<\/li>\n<\/ol>\n<p>3. Ulazna jedinica sa kojom se ru\u010dno upravlja, koja omogu\u0107ava direktno pozicioniranje na fajlu ili objekat ekrana kompjutera je:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Projektor<\/li>\n<li>Altoparlant<\/li>\n<li>Mi\u0161 (mouse) *<\/li>\n<li>Modem<\/li>\n<\/ol>\n<p>4. Izraz hardver u kompjuterskom sistemu podrazumeva:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Programske jezike<\/li>\n<li>Fizi\u010dku komponentu kompjutera *<\/li>\n<li>Prava autora<\/li>\n<li>Kompjuterske programe<\/li>\n<\/ol>\n<p>5. Zatvaranje svih aplikacija i ponovo startovanje kompjutera u Windows-u vr\u0161i se biranjem opcija:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Log off<\/li>\n<li>Sleep<\/li>\n<li>Shut down<\/li>\n<li>Restart *<\/li>\n<\/ol>\n<p>6. Menad\u017eiranje (upravljanje) hardverom, memorijom kompjutera, perifernom opremom kompjutera i svim instaliranim aplikativnim programima u kompjuteru omogu\u0107ava nam:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Operativni sistem *<\/li>\n<li>Aplikativni programi<\/li>\n<li>Informativni sistemi<\/li>\n<li>Sistem baze podataka<\/li>\n<\/ol>\n<p>7. Programi koji su kreirani da bi dozvolili hakerima pristup sa udaljenosti u inficiranim kompjuterskim sistemima zovu se:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Domain<\/li>\n<li>Trojan *<\/li>\n<li>Toolbar<\/li>\n<li>Mainframe<\/li>\n<\/ol>\n<p>8. Mali prozori reklama koji se otvaraju automatski i dolaze u direktan kontakt sa va\u017enim sadr\u017eajem Web stranica poznati su kao:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>VoIP<\/li>\n<li>Firewall<\/li>\n<li>Pop-ups *<\/li>\n<li>Phishing<\/li>\n<\/ol>\n<p>9. Ure\u0111aj koji slu\u017ei kao centralna jedinica mre\u017ee, koja menad\u017eira (upravlja) sa svim kompjuterima i sa svom opremom povezanoj na mre\u017ei je:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Server *<\/li>\n<li>IP Address<\/li>\n<li>Domain<\/li>\n<li>VoIP<\/li>\n<\/ol>\n<p>10. 172.16.122.204 je:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>MAC Adresa<\/li>\n<li>Po\u0161tanska adresa<\/li>\n<li>Adresa stanovanja<\/li>\n<li>IP Adresa *<\/li>\n<\/ol>\n<p>11. U tabeli prikazanoj kao dole, nakon izvr\u0161enja funkcije u Excel-u =IF(B2&gt;=90,&#8221;5&#8221;,IF(B2&gt;=80,&#8221;4&#8221;,IF(B2&gt;=60,&#8221;3&#8221;,IF(B2&gt;=40,&#8221;2&#8221;,&#8221; 1&#8221;)))), ocjena Adema Murti\u0107a je:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1519\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A2.png\" alt=\"Matura - A2\" width=\"241\" height=\"188\" \/><\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>2 *<\/li>\n<li>3<\/li>\n<li>4<\/li>\n<li>5<\/li>\n<\/ol>\n<p>12. U tabeli prikazanoj kao dole, nakon izvr\u0161enja funkcije u Excel =SUMIF(A1 :A5,&#8221;&gt;5&#8221;), rezultat je:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1520\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A3.png\" alt=\"Matura - A3\" width=\"164\" height=\"217\" \/><\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>11<\/li>\n<li>14 *<\/li>\n<li>19<\/li>\n<li>25<\/li>\n<\/ol>\n<p>13. Numeri\u010dke vrijednosti ili tekstovi koji ne mijenjaju vrijednost, u Excel su:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Konstante *<\/li>\n<li>Operatori<\/li>\n<li>Funkcije<\/li>\n<li>Adrese<\/li>\n<\/ol>\n<p>14. U tabeli prikazanoj kao dole, koja od funkcija u Excel vr\u0161i ra\u010dunanje srednje ocjene Merite:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1521\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A4.png\" alt=\"Matura - A4\" width=\"807\" height=\"221\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A4.png 807w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A4-300x82.png 300w\" sizes=\"auto, (max-width: 807px) 100vw, 807px\" \/><\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>=AVERAGE(A3: J3)<\/li>\n<li>=AVERAGE(A1: A5)<\/li>\n<li>=AVERAGE(B4:J4) *<\/li>\n<li>=AVERAGE(B5:J5)<\/li>\n<\/ol>\n<p>15. Predstavljanje teksta sa lijeve strane, uzimaju\u0107i samo toliko simbola koliko je definisano u funkciji, u Excel omogu\u0107ava se pomo\u0107u funkcije:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>=TRIM(&#8220;tekst&#8221;,br_simb)<\/li>\n<li>=LEFT(&#8220;tekst&#8221;,br_simb) *<\/li>\n<li>=RIGHT(&#8220;tekst&#8221;,br_simb)<\/li>\n<li>=UPPER(&#8220;tekst&#8221;,br_simb)<\/li>\n<\/ol>\n<p>16. Predstavljanje ograni\u010denih podataka na radnom listu i skrivanje njenih odre\u0111enih djelova, u Excel-u poznato je kao:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Zamjena<\/li>\n<li>Sortiranje<\/li>\n<li>Filtriranje *<\/li>\n<li>Orjentacija<\/li>\n<\/ol>\n<p>17. Profesor matematike prikazuje rezultate testova u\u010denika sa dijagramom u obliku vertikalnih stubova, kao na donjoj slici. On u Excel-u koristi dijagram:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1522\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A5.png\" alt=\"Matura - A5\" width=\"328\" height=\"231\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A5.png 328w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A5-300x211.png 300w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2019\/06\/Matura-A5-120x85.png 120w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Pie<\/li>\n<li>Area<\/li>\n<li>Bar<\/li>\n<li>Column *<\/li>\n<\/ol>\n<p>18. Polje podataka vrste Memo, u Access koristi se za:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>\u010cuvanje valutnih vrijednosti<\/li>\n<li>\u010cuvanje alfanumeri\u010dkih podataka *<\/li>\n<li>Stvaranje jedne veze sa nekim fajlom ili Web adresom<\/li>\n<li>Izdvajanje jednog spoljneg objekta<\/li>\n<\/ol>\n<p>19. Ako svaka osoba ima samo jedan paso\u0161 i paso\u0161 se daje samo za jednu osobu. Racionalna veza koju treba uspostaviti izme\u0111u tabele osobe i paso\u0161a, u Access treba da se koristi:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>Veza jedan-sa-jedan (1:1) *<\/li>\n<li>Veza mnogo-sa-mnogos (n:m)<\/li>\n<li>Veza malo-sa-malo (x:y)<\/li>\n<li>Veza jedan-sa-mnogo (l:n)<\/li>\n<\/ol>\n<p>20. Koji kriterij je ta\u010dan u bazi podataka u Access, koji slu\u017ei za iznala\u017eenje svih cijena u polju cijena koje su manje od 10:<\/p>\n<ol style=\"list-style-type: upper-alpha;\">\n<li>&lt;10&gt;<\/li>\n<li>&lt;10 *<\/li>\n<li>Less than 10<\/li>\n<li>10&lt;<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"1.\u00a0 Dekadni broj 82(10) u sistemu binarnih brojeva je: 1100110 0100101 1010010<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=1516\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":1553,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-1516","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-za-maturante"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/1516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1516"}],"version-history":[{"count":6,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/1516\/revisions"}],"predecessor-version":[{"id":1527,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/1516\/revisions\/1527"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/1553"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}