{"id":5903,"date":"2020-12-15T22:47:04","date_gmt":"2020-12-15T18:47:04","guid":{"rendered":"https:\/\/yusif.az\/main\/?p=5903"},"modified":"2020-12-15T22:49:06","modified_gmt":"2020-12-15T18:49:06","slug":"excel-45-test-v%c9%99-cavablari-tqdk-kitabi-%c9%99sasinda","status":"publish","type":"post","link":"https:\/\/yusif.az\/main\/?p=5903","title":{"rendered":"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda)"},"content":{"rendered":"<blockquote>\n<h2 style=\"text-align: center;\"><span style=\"color: #993366;\"><strong>Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)<\/strong><\/span><\/h2>\n<p style=\"text-align: center;\"><span style=\"color: #ff00ff;\"><strong>(cavablar\u0131 sonda)<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong>1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?<\/strong><br \/>\nA) Name box, Formula bar, Cell<br \/>\nB) Palitra,Name box, Columns<br \/>\nC) Cell, Accessories, Modul<br \/>\nD) Status bar, Sazlama paneli, Translyator<br \/>\nE) Ribbon, Sazlama paneli, \u0130nterpretator<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?<\/strong><br \/>\nA) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F5<\/p>\n<p>&nbsp;<\/p>\n<p><strong>3) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5904\" src=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/3.png\" alt=\"\" width=\"274\" height=\"42\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?<\/strong><br \/>\nA) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olar<br \/>\nB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmaz<br \/>\nC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcr<br \/>\nD) Son s\u00fct\u00fcn XFE-dir<br \/>\nE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil<\/p>\n<p>&nbsp;<\/p>\n<p><strong>5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?<\/strong><br \/>\nA) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir<\/p>\n<p>&nbsp;<\/p>\n<p><strong>6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)<\/strong><br \/>\nA) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 2048<\/p>\n<p>&nbsp;<\/p>\n<p><strong>7) S\u00fctunlar hans\u0131 aral\u0131qda olur?<\/strong><br \/>\nA) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-65536<\/p>\n<p>&nbsp;<\/p>\n<p><strong>8) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda&#8230;<\/strong><br \/>\nA) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131r<br \/>\nB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131r<br \/>\nC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131r<br \/>\nD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131r<br \/>\nE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar<\/p>\n<p>&nbsp;<\/p>\n<p><strong>9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?<\/strong><br \/>\nA) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line<\/p>\n<p>&nbsp;<\/p>\n<p><strong>10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?<\/strong><br \/>\nA) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFD<br \/>\nD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V256<\/p>\n<p>&nbsp;<\/p>\n<p><strong>11) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?<\/strong><br \/>\nA) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passiv<br \/>\nC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, Ungrupe<br \/>\nE) 2- M\u00fctl\u0259q v\u0259 nisbi<\/p>\n<p>&nbsp;<\/p>\n<p><strong>12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?<\/strong><br \/>\nA) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinci<br \/>\nD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q<\/p>\n<p>&nbsp;<\/p>\n<p><strong>13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?<\/strong><br \/>\nA) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin<\/p>\n<p>&nbsp;<\/p>\n<p><strong>14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:<\/strong><br \/>\nA) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$<\/p>\n<p>&nbsp;<\/p>\n<p><strong>15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?<\/strong><br \/>\nA) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5<br \/>\nD) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *1<\/p>\n<p>&nbsp;<\/p>\n<p><strong>16) A4:F8 diapazonunda ne\u00e7\u0259 xana var?<\/strong><br \/>\nA) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 32<\/p>\n<p>&nbsp;<\/p>\n<p><strong>17) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?<\/strong><br \/>\nA) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 18<\/p>\n<p>&nbsp;<\/p>\n<p><strong>18) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?<\/strong><br \/>\nA) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F9<\/p>\n<p>&nbsp;<\/p>\n<p><strong>19) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?<\/strong><br \/>\nA) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock<\/p>\n<p>&nbsp;<\/p>\n<p><strong>20) Fill-Right se\u00e7il\u0259rs\u0259&#8230;<\/strong><br \/>\nA) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulur<br \/>\nB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcr<br \/>\nC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulur<br \/>\nD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcr<br \/>\nE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir<\/p>\n<p><strong>21)<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5906\" src=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/21.png\" alt=\"\" width=\"111\" height=\"78\" \/> <\/strong><\/p>\n<p><strong>G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?<\/strong><br \/>\nA) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review<\/p>\n<p>&nbsp;<\/p>\n<p><strong>22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?<\/strong><br \/>\nA) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt<\/p>\n<p>&nbsp;<\/p>\n<p><strong>23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?<\/strong><br \/>\nA) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 64<\/p>\n<p>&nbsp;<\/p>\n<p><strong>24) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:<\/strong><br \/>\nA) : \\ \/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * &amp; #<br \/>\nC) $ % ^ &amp; [ ]\u00a0 \u00a0 \u00a0 C) * ) \\ \/ { }<br \/>\nE) { } [ ] &amp; &lt; &gt;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?<\/strong><br \/>\nA) %\u00a0 \u00a0 \u00a0 B) &amp;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [<\/p>\n<p>&nbsp;<\/p>\n<p><strong>26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?<\/strong><br \/>\nA) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9<br \/>\nD) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F3<\/p>\n<p>&nbsp;<\/p>\n<p><strong>27) # Div\/0!&#8230;.<\/strong><br \/>\nA) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmir<br \/>\nB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131r<br \/>\nC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131r<br \/>\nD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131r<br \/>\nE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r<\/p>\n<p>&nbsp;<\/p>\n<p><strong>28)<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5905\" src=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/28-1.png\" alt=\"\" width=\"157\" height=\"82\" \/> <\/strong><\/p>\n<p><strong>\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?<\/strong><br \/>\nA) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas<\/p>\n<p>&nbsp;<\/p>\n<p><strong>29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:<\/strong><br \/>\nA) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardir<br \/>\nB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131r<br \/>\nC) Toplad\u0131qda cavab 11 ed\u0259c\u0259k<br \/>\nD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131r<br \/>\nE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir<\/p>\n<p>&nbsp;<\/p>\n<p><strong>30) =FACT (6) ne\u00e7\u0259 ed\u0259r?<\/strong><br \/>\nA) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 720<\/p>\n<p>&nbsp;<\/p>\n<p><strong>31) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:<\/strong><br \/>\nA) \/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @<\/p>\n<p>&nbsp;<\/p>\n<p><strong>32) =Product (2; 4; 8)<\/strong><br \/>\nA) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 34<\/p>\n<p>&nbsp;<\/p>\n<p><strong>33) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:<\/strong><br \/>\nA) C21+C22+C23+C24+C25<br \/>\nB) C21\/C22\/C23\/C24\/C25<br \/>\nC) C21+C25<br \/>\nD) C21-C22-C23-C24-C25<br \/>\nE) C21*C22*C23*C24*C25<\/p>\n<p>&nbsp;<\/p>\n<p><strong>34) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?<\/strong><br \/>\nA) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH<\/p>\n<p>&nbsp;<\/p>\n<p><strong>35) B1=20, D1=25<\/strong><br \/>\n<strong>Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?<\/strong><br \/>\nA)= B1&gt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35<br \/>\nD)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=500<\/p>\n<p>&nbsp;<\/p>\n<p><strong>36) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?<\/strong><br \/>\nA) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6<br \/>\nD) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F1<\/p>\n<p>&nbsp;<\/p>\n<p><strong>37) Ne\u00e7\u0259 diaqram tipi vard\u0131r?<\/strong><br \/>\nA) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 5<\/p>\n<p>&nbsp;<\/p>\n<p><strong>38) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?<\/strong><br \/>\nA) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 6<\/p>\n<p>&nbsp;<\/p>\n<p><strong>39) Hans\u0131 qabar\u0131q dioqram tipidir?<\/strong><br \/>\nA) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter<\/p>\n<p>&nbsp;<\/p>\n<p><strong>40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)<\/strong><br \/>\nA) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 13<\/p>\n<p>&nbsp;<\/p>\n<p><strong>41) Diaqramda Lagend n\u0259dir?<\/strong><br \/>\nA) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir<br \/>\nB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dir<br \/>\nC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131r<br \/>\nD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dir<br \/>\nE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir<\/p>\n<p>&nbsp;<\/p>\n<p><strong>42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?<\/strong><br \/>\nA) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F11<\/p>\n<p>&nbsp;<\/p>\n<p><strong>43) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?<\/strong><br \/>\nA) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsert<br \/>\nD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review<\/p>\n<p>&nbsp;<\/p>\n<p><strong>44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?<\/strong><br \/>\nA) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131<br \/>\nB) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131<br \/>\nC) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131<br \/>\nD) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131<br \/>\nE) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini<\/p>\n<p>&nbsp;<\/p>\n<p><strong>45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?<\/strong><br \/>\nA) \u015e\u0259rh yarad\u0131r<br \/>\nB) Ribbonlar\u0131 gizl\u0259dir<br \/>\nC) S\u0259hif\u0259nin format\u0131n\u0131 silir<br \/>\nD) \u0130ki s\u00fctunu birl\u0259\u015fdirir<br \/>\nE) Aktiv s\u00fctunlar\u0131 gizl\u0259dir<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td colspan=\"2\" width=\"236\">\n<h3 style=\"text-align: center;\"><span style=\"color: #ff0000;\"><strong>Cavablar<\/strong><\/span><\/h3>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>E<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>10.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>11.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>12.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>13.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>14.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>15.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>16.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>17.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>E<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>18.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>19.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>20.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>21.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>22.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>23.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>24.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>25.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>26.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>27.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>E<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>28.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>E<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>29.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>30.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>E<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>31.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>32.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>33.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>34.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>35.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>36.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>37.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>38.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>39.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>40.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>41.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>42.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>E<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>43.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>44.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>B<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"118\"><strong>45.\u00a0\u00a0\u00a0 <\/strong><strong>\u00a0<\/strong><\/td>\n<td width=\"118\"><strong>A<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4><\/h4>\n<h4 style=\"text-align: right;\"><span style=\"color: #ff0000;\"><strong>Niyam\u0259ddin \u015eahmarov<\/strong><\/span><\/h4>\n<h4 style=\"text-align: right;\"><span style=\"color: #ff0000;\"><strong>\u018flaq\u0259:( 051)9224229<\/strong><\/span><\/h4>\n<h4 style=\"text-align: right;\"><span style=\"color: #ff0000;\"><strong>E-mail: <\/strong><a style=\"color: #ff0000;\" href=\"mailto:niyameddinshahmarov86@gmail.com\"><strong>niyameddinshahmarov86<\/strong><strong>@gmail.com<\/strong><\/a><\/span><\/h4>\n<h4 style=\"text-align: right;\"><span style=\"color: #ff0000;\"><strong>Fb qrup: <\/strong><strong>informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov)<\/strong><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2019\/04\/p222-291x300.jpg\" width=\"88\" height=\"91\" \/><\/p><\/blockquote>\n<div style=\"margin: 20px 0;\"><div class=\"qrcswholewtapper\" style=\"text-align:left;\"><div class=\"qrcprowrapper\"  id=\"qrcwraa2leds\"><div class=\"qrc_canvass\" id=\"qrc_cuttenpages_2\" style=\"display:inline-block\" data-text=\"https:\/\/yusif.az\/main\/?p=5903\"><\/div><div><a download=\"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda).png\" class=\"qrcdownloads\" id=\"worign\">\r\n           <button type=\"button\" style=\"min-width:110px;background:#44d813;color:#000;font-weight: 600;border: 1px solid #44d813;border-radius:20px;font-size:12px;padding: 6px 0;\" class=\"uqr_code_btn\">QR kodu Y\u00fckl\u0259 \ud83e\udc0b<\/button>\r\n           <\/a><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov) (cavablar\u0131 sonda) &nbsp; 1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir? A) Name box, Formula bar, Cell B) Palitra,Name box, Columns C) Cell, Accessories, Modul D) Status bar, Sazlama paneli, Translyator E) Ribbon, Sazlama paneli, \u0130nterpretator &nbsp; 2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r? A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5907,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-5903","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-summativ"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda) - www.YUSIF.az \u0130nformatika<\/title>\n<meta name=\"description\" content=\"Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)(cavablar\u0131 sonda)1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?A) Name box, Formula bar, CellB) Palitra,Name box, ColumnsC) Cell, Accessories, ModulD) Status bar, Sazlama paneli, TranslyatorE) Ribbon, Sazlama paneli, \u0130nterpretator2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F53) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?A) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olarB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmazC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcrD) Son s\u00fct\u00fcn XFE-dirE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?A) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)A) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 20487) S\u00fctunlar hans\u0131 aral\u0131qda olur?A) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-655368) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda...A) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131rB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131rC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?A) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?A) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFDD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V25611) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?A) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passivC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, UngrupeE) 2- M\u00fctl\u0259q v\u0259 nisbi12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?A) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinciD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?A) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:A) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?A) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5D) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *116) A4:F8 diapazonunda ne\u00e7\u0259 xana var?A) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 3217) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?A) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 1818) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?A) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F919) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?A) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock20) Fill-Right se\u00e7il\u0259rs\u0259...A) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulurB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcrC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulurD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcrE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir21)G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?A) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?A) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 6424) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:A) :  \/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * &amp; #C) $ % ^ &amp; [ ]\u00a0 \u00a0 \u00a0 C) * )  \/ { }E) { } [ ] &amp; &lt; &gt;25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?A) %\u00a0 \u00a0 \u00a0 B) &amp;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?A) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9D) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F327) # Div\/0!....A) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmirB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131rC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131rD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131rE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r28)\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:A) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardirB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131rC) Toplad\u0131qda cavab 11 ed\u0259c\u0259kD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131rE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir30) =FACT (6) ne\u00e7\u0259 ed\u0259r?A) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 72031) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:A) \/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @32) =Product (2; 4; 8)A) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 3433) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:A) C21+C22+C23+C24+C25B) C21\/C22\/C23\/C24\/C25C) C21+C25D) C21-C22-C23-C24-C25E) C21*C22*C23*C24*C2534) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?A) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH35) B1=20, D1=25Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?A)= B1&gt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35D)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=50036) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?A) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6D) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F137) Ne\u00e7\u0259 diaqram tipi vard\u0131r?A) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 538) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?A) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 639) Hans\u0131 qabar\u0131q dioqram tipidir?A) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)A) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 1341) Diaqramda Lagend n\u0259dir?A) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dirB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131rD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?A) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F1143) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?A) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsertD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?A) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131B) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131C) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131D) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131E) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?A) \u015e\u0259rh yarad\u0131rB) Ribbonlar\u0131 gizl\u0259dirC) S\u0259hif\u0259nin format\u0131n\u0131 silirD) \u0130ki s\u00fctunu birl\u0259\u015fdirirE) Aktiv s\u00fctunlar\u0131 gizl\u0259dirCavablar1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 C6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D10.\u00a0\u00a0\u00a0 \u00a0 A11.\u00a0\u00a0\u00a0 \u00a0 B12.\u00a0\u00a0\u00a0 \u00a0 B13.\u00a0\u00a0\u00a0 \u00a0 B14.\u00a0\u00a0\u00a0 \u00a0 D15.\u00a0\u00a0\u00a0 \u00a0 D16.\u00a0\u00a0\u00a0 \u00a0 B17.\u00a0\u00a0\u00a0 \u00a0 E18.\u00a0\u00a0\u00a0 \u00a0 B19.\u00a0\u00a0\u00a0 \u00a0 A20.\u00a0\u00a0\u00a0 \u00a0 C21.\u00a0\u00a0\u00a0 \u00a0 D22.\u00a0\u00a0\u00a0 \u00a0 B23.\u00a0\u00a0\u00a0 \u00a0 D24.\u00a0\u00a0\u00a0 \u00a0 A25.\u00a0\u00a0\u00a0 \u00a0 B26.\u00a0\u00a0\u00a0 \u00a0 A27.\u00a0\u00a0\u00a0 \u00a0 E28.\u00a0\u00a0\u00a0 \u00a0 E29.\u00a0\u00a0\u00a0 \u00a0 A30.\u00a0\u00a0\u00a0 \u00a0 E31.\u00a0\u00a0\u00a0 \u00a0 C32.\u00a0\u00a0\u00a0 \u00a0 C33.\u00a0\u00a0\u00a0 \u00a0 A34.\u00a0\u00a0\u00a0 \u00a0 D35.\u00a0\u00a0\u00a0 \u00a0 B36.\u00a0\u00a0\u00a0 \u00a0 C37.\u00a0\u00a0\u00a0 \u00a0 B38.\u00a0\u00a0\u00a0 \u00a0 D39.\u00a0\u00a0\u00a0 \u00a0 A40.\u00a0\u00a0\u00a0 \u00a0 B41.\u00a0\u00a0\u00a0 \u00a0 A42.\u00a0\u00a0\u00a0 \u00a0 E43.\u00a0\u00a0\u00a0 \u00a0 A44.\u00a0\u00a0\u00a0 \u00a0 B45.\u00a0\u00a0\u00a0 \u00a0 ANiyam\u0259ddin \u015eahmarov\u018flaq\u0259:( 051)9224229E-mail: niyameddinshahmarov86@gmail.comFb qrup: informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov) %\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/yusif.az\/main\/?p=5903\" \/>\n<meta property=\"og:locale\" content=\"az_AZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda) - www.YUSIF.az \u0130nformatika\" \/>\n<meta property=\"og:description\" content=\"Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)(cavablar\u0131 sonda)1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?A) Name box, Formula bar, CellB) Palitra,Name box, ColumnsC) Cell, Accessories, ModulD) Status bar, Sazlama paneli, TranslyatorE) Ribbon, Sazlama paneli, \u0130nterpretator2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F53) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?A) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olarB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmazC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcrD) Son s\u00fct\u00fcn XFE-dirE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?A) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)A) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 20487) S\u00fctunlar hans\u0131 aral\u0131qda olur?A) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-655368) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda...A) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131rB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131rC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?A) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?A) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFDD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V25611) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?A) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passivC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, UngrupeE) 2- M\u00fctl\u0259q v\u0259 nisbi12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?A) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinciD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?A) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:A) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?A) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5D) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *116) A4:F8 diapazonunda ne\u00e7\u0259 xana var?A) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 3217) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?A) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 1818) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?A) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F919) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?A) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock20) Fill-Right se\u00e7il\u0259rs\u0259...A) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulurB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcrC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulurD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcrE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir21)G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?A) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?A) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 6424) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:A) :  \/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * &amp; #C) $ % ^ &amp; [ ]\u00a0 \u00a0 \u00a0 C) * )  \/ { }E) { } [ ] &amp; &lt; &gt;25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?A) %\u00a0 \u00a0 \u00a0 B) &amp;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?A) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9D) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F327) # Div\/0!....A) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmirB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131rC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131rD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131rE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r28)\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:A) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardirB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131rC) Toplad\u0131qda cavab 11 ed\u0259c\u0259kD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131rE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir30) =FACT (6) ne\u00e7\u0259 ed\u0259r?A) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 72031) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:A) \/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @32) =Product (2; 4; 8)A) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 3433) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:A) C21+C22+C23+C24+C25B) C21\/C22\/C23\/C24\/C25C) C21+C25D) C21-C22-C23-C24-C25E) C21*C22*C23*C24*C2534) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?A) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH35) B1=20, D1=25Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?A)= B1&gt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35D)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=50036) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?A) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6D) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F137) Ne\u00e7\u0259 diaqram tipi vard\u0131r?A) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 538) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?A) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 639) Hans\u0131 qabar\u0131q dioqram tipidir?A) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)A) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 1341) Diaqramda Lagend n\u0259dir?A) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dirB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131rD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?A) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F1143) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?A) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsertD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?A) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131B) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131C) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131D) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131E) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?A) \u015e\u0259rh yarad\u0131rB) Ribbonlar\u0131 gizl\u0259dirC) S\u0259hif\u0259nin format\u0131n\u0131 silirD) \u0130ki s\u00fctunu birl\u0259\u015fdirirE) Aktiv s\u00fctunlar\u0131 gizl\u0259dirCavablar1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 C6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D10.\u00a0\u00a0\u00a0 \u00a0 A11.\u00a0\u00a0\u00a0 \u00a0 B12.\u00a0\u00a0\u00a0 \u00a0 B13.\u00a0\u00a0\u00a0 \u00a0 B14.\u00a0\u00a0\u00a0 \u00a0 D15.\u00a0\u00a0\u00a0 \u00a0 D16.\u00a0\u00a0\u00a0 \u00a0 B17.\u00a0\u00a0\u00a0 \u00a0 E18.\u00a0\u00a0\u00a0 \u00a0 B19.\u00a0\u00a0\u00a0 \u00a0 A20.\u00a0\u00a0\u00a0 \u00a0 C21.\u00a0\u00a0\u00a0 \u00a0 D22.\u00a0\u00a0\u00a0 \u00a0 B23.\u00a0\u00a0\u00a0 \u00a0 D24.\u00a0\u00a0\u00a0 \u00a0 A25.\u00a0\u00a0\u00a0 \u00a0 B26.\u00a0\u00a0\u00a0 \u00a0 A27.\u00a0\u00a0\u00a0 \u00a0 E28.\u00a0\u00a0\u00a0 \u00a0 E29.\u00a0\u00a0\u00a0 \u00a0 A30.\u00a0\u00a0\u00a0 \u00a0 E31.\u00a0\u00a0\u00a0 \u00a0 C32.\u00a0\u00a0\u00a0 \u00a0 C33.\u00a0\u00a0\u00a0 \u00a0 A34.\u00a0\u00a0\u00a0 \u00a0 D35.\u00a0\u00a0\u00a0 \u00a0 B36.\u00a0\u00a0\u00a0 \u00a0 C37.\u00a0\u00a0\u00a0 \u00a0 B38.\u00a0\u00a0\u00a0 \u00a0 D39.\u00a0\u00a0\u00a0 \u00a0 A40.\u00a0\u00a0\u00a0 \u00a0 B41.\u00a0\u00a0\u00a0 \u00a0 A42.\u00a0\u00a0\u00a0 \u00a0 E43.\u00a0\u00a0\u00a0 \u00a0 A44.\u00a0\u00a0\u00a0 \u00a0 B45.\u00a0\u00a0\u00a0 \u00a0 ANiyam\u0259ddin \u015eahmarov\u018flaq\u0259:( 051)9224229E-mail: niyameddinshahmarov86@gmail.comFb qrup: informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov) %\" \/>\n<meta property=\"og:url\" content=\"https:\/\/yusif.az\/main\/?p=5903\" \/>\n<meta property=\"og:site_name\" content=\"www.YUSIF.az\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-15T18:47:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-15T18:49:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/ex.png\" \/>\n\t<meta property=\"og:image:width\" content=\"305\" \/>\n\t<meta property=\"og:image:height\" content=\"280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"auto61\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"auto61\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903\"},\"author\":{\"name\":\"auto61\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#\\\/schema\\\/person\\\/904da2c1a1bbe7e501df95c2bc38d146\"},\"headline\":\"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda)\",\"datePublished\":\"2020-12-15T18:47:04+00:00\",\"dateModified\":\"2020-12-15T18:49:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903\"},\"wordCount\":1436,\"publisher\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#\\\/schema\\\/person\\\/904da2c1a1bbe7e501df95c2bc38d146\"},\"image\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/ex.png\",\"articleSection\":[\"\u0130nformatika\"],\"inLanguage\":\"az\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903\",\"url\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903\",\"name\":\"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda) - www.YUSIF.az \u0130nformatika\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/ex.png\",\"datePublished\":\"2020-12-15T18:47:04+00:00\",\"dateModified\":\"2020-12-15T18:49:06+00:00\",\"description\":\"Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)(cavablar\u0131 sonda)1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?A) Name box, Formula bar, CellB) Palitra,Name box, ColumnsC) Cell, Accessories, ModulD) Status bar, Sazlama paneli, TranslyatorE) Ribbon, Sazlama paneli, \u0130nterpretator2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F53) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?A) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olarB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmazC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcrD) Son s\u00fct\u00fcn XFE-dirE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?A) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)A) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 20487) S\u00fctunlar hans\u0131 aral\u0131qda olur?A) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-655368) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda...A) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131rB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131rC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?A) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?A) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFDD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V25611) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?A) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passivC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, UngrupeE) 2- M\u00fctl\u0259q v\u0259 nisbi12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?A) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinciD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?A) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:A) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?A) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\\\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5D) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *116) A4:F8 diapazonunda ne\u00e7\u0259 xana var?A) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 3217) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?A) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 1818) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?A) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F919) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?A) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock20) Fill-Right se\u00e7il\u0259rs\u0259...A) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulurB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcrC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulurD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcrE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir21)G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?A) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?A) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 6424) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:A) : \\\\ \\\/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * & #C) $ % ^ & [ ]\u00a0 \u00a0 \u00a0 C) * ) \\\\ \\\/ { }E) { } [ ] & < >25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?A) %\u00a0 \u00a0 \u00a0 B) &\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?A) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9D) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F327) # Div\\\/0!....A) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmirB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131rC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131rD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131rE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r28)\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:A) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardirB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131rC) Toplad\u0131qda cavab 11 ed\u0259c\u0259kD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131rE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir30) =FACT (6) ne\u00e7\u0259 ed\u0259r?A) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 72031) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:A) \\\/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @32) =Product (2; 4; 8)A) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 3433) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:A) C21+C22+C23+C24+C25B) C21\\\/C22\\\/C23\\\/C24\\\/C25C) C21+C25D) C21-C22-C23-C24-C25E) C21*C22*C23*C24*C2534) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?A) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH35) B1=20, D1=25Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?A)= B1>D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35D)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=50036) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?A) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6D) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F137) Ne\u00e7\u0259 diaqram tipi vard\u0131r?A) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 538) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?A) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 639) Hans\u0131 qabar\u0131q dioqram tipidir?A) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)A) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 1341) Diaqramda Lagend n\u0259dir?A) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dirB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131rD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?A) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F1143) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?A) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsertD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?A) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131B) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131C) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131D) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131E) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?A) \u015e\u0259rh yarad\u0131rB) Ribbonlar\u0131 gizl\u0259dirC) S\u0259hif\u0259nin format\u0131n\u0131 silirD) \u0130ki s\u00fctunu birl\u0259\u015fdirirE) Aktiv s\u00fctunlar\u0131 gizl\u0259dirCavablar1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 C6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D10.\u00a0\u00a0\u00a0 \u00a0 A11.\u00a0\u00a0\u00a0 \u00a0 B12.\u00a0\u00a0\u00a0 \u00a0 B13.\u00a0\u00a0\u00a0 \u00a0 B14.\u00a0\u00a0\u00a0 \u00a0 D15.\u00a0\u00a0\u00a0 \u00a0 D16.\u00a0\u00a0\u00a0 \u00a0 B17.\u00a0\u00a0\u00a0 \u00a0 E18.\u00a0\u00a0\u00a0 \u00a0 B19.\u00a0\u00a0\u00a0 \u00a0 A20.\u00a0\u00a0\u00a0 \u00a0 C21.\u00a0\u00a0\u00a0 \u00a0 D22.\u00a0\u00a0\u00a0 \u00a0 B23.\u00a0\u00a0\u00a0 \u00a0 D24.\u00a0\u00a0\u00a0 \u00a0 A25.\u00a0\u00a0\u00a0 \u00a0 B26.\u00a0\u00a0\u00a0 \u00a0 A27.\u00a0\u00a0\u00a0 \u00a0 E28.\u00a0\u00a0\u00a0 \u00a0 E29.\u00a0\u00a0\u00a0 \u00a0 A30.\u00a0\u00a0\u00a0 \u00a0 E31.\u00a0\u00a0\u00a0 \u00a0 C32.\u00a0\u00a0\u00a0 \u00a0 C33.\u00a0\u00a0\u00a0 \u00a0 A34.\u00a0\u00a0\u00a0 \u00a0 D35.\u00a0\u00a0\u00a0 \u00a0 B36.\u00a0\u00a0\u00a0 \u00a0 C37.\u00a0\u00a0\u00a0 \u00a0 B38.\u00a0\u00a0\u00a0 \u00a0 D39.\u00a0\u00a0\u00a0 \u00a0 A40.\u00a0\u00a0\u00a0 \u00a0 B41.\u00a0\u00a0\u00a0 \u00a0 A42.\u00a0\u00a0\u00a0 \u00a0 E43.\u00a0\u00a0\u00a0 \u00a0 A44.\u00a0\u00a0\u00a0 \u00a0 B45.\u00a0\u00a0\u00a0 \u00a0 ANiyam\u0259ddin \u015eahmarov\u018flaq\u0259:( 051)9224229E-mail: niyameddinshahmarov86@gmail.comFb qrup: informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov) %\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#breadcrumb\"},\"inLanguage\":\"az\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"az\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#primaryimage\",\"url\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/ex.png\",\"contentUrl\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/ex.png\",\"width\":305,\"height\":280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=5903#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/yusif.az\\\/main\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#website\",\"url\":\"https:\\\/\\\/yusif.az\\\/main\\\/\",\"name\":\"www.YUSIF.az\",\"description\":\"Birlikd\u0259 Y\u00fcks\u0259li\u015f\u0259 Do\u011fru!!!\",\"publisher\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#\\\/schema\\\/person\\\/904da2c1a1bbe7e501df95c2bc38d146\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/yusif.az\\\/main\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"az\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#\\\/schema\\\/person\\\/904da2c1a1bbe7e501df95c2bc38d146\",\"name\":\"auto61\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"az\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g\",\"caption\":\"auto61\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda) - www.YUSIF.az \u0130nformatika","description":"Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)(cavablar\u0131 sonda)1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?A) Name box, Formula bar, CellB) Palitra,Name box, ColumnsC) Cell, Accessories, ModulD) Status bar, Sazlama paneli, TranslyatorE) Ribbon, Sazlama paneli, \u0130nterpretator2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F53) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?A) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olarB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmazC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcrD) Son s\u00fct\u00fcn XFE-dirE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?A) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)A) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 20487) S\u00fctunlar hans\u0131 aral\u0131qda olur?A) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-655368) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda...A) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131rB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131rC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?A) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?A) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFDD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V25611) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?A) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passivC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, UngrupeE) 2- M\u00fctl\u0259q v\u0259 nisbi12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?A) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinciD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?A) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:A) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?A) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5D) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *116) A4:F8 diapazonunda ne\u00e7\u0259 xana var?A) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 3217) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?A) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 1818) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?A) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F919) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?A) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock20) Fill-Right se\u00e7il\u0259rs\u0259...A) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulurB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcrC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulurD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcrE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir21)G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?A) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?A) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 6424) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:A) :  \/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * & #C) $ % ^ & [ ]\u00a0 \u00a0 \u00a0 C) * )  \/ { }E) { } [ ] & < >25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?A) %\u00a0 \u00a0 \u00a0 B) &\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?A) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9D) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F327) # Div\/0!....A) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmirB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131rC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131rD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131rE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r28)\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:A) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardirB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131rC) Toplad\u0131qda cavab 11 ed\u0259c\u0259kD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131rE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir30) =FACT (6) ne\u00e7\u0259 ed\u0259r?A) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 72031) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:A) \/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @32) =Product (2; 4; 8)A) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 3433) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:A) C21+C22+C23+C24+C25B) C21\/C22\/C23\/C24\/C25C) C21+C25D) C21-C22-C23-C24-C25E) C21*C22*C23*C24*C2534) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?A) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH35) B1=20, D1=25Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?A)= B1>D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35D)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=50036) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?A) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6D) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F137) Ne\u00e7\u0259 diaqram tipi vard\u0131r?A) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 538) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?A) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 639) Hans\u0131 qabar\u0131q dioqram tipidir?A) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)A) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 1341) Diaqramda Lagend n\u0259dir?A) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dirB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131rD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?A) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F1143) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?A) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsertD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?A) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131B) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131C) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131D) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131E) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?A) \u015e\u0259rh yarad\u0131rB) Ribbonlar\u0131 gizl\u0259dirC) S\u0259hif\u0259nin format\u0131n\u0131 silirD) \u0130ki s\u00fctunu birl\u0259\u015fdirirE) Aktiv s\u00fctunlar\u0131 gizl\u0259dirCavablar1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 C6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D10.\u00a0\u00a0\u00a0 \u00a0 A11.\u00a0\u00a0\u00a0 \u00a0 B12.\u00a0\u00a0\u00a0 \u00a0 B13.\u00a0\u00a0\u00a0 \u00a0 B14.\u00a0\u00a0\u00a0 \u00a0 D15.\u00a0\u00a0\u00a0 \u00a0 D16.\u00a0\u00a0\u00a0 \u00a0 B17.\u00a0\u00a0\u00a0 \u00a0 E18.\u00a0\u00a0\u00a0 \u00a0 B19.\u00a0\u00a0\u00a0 \u00a0 A20.\u00a0\u00a0\u00a0 \u00a0 C21.\u00a0\u00a0\u00a0 \u00a0 D22.\u00a0\u00a0\u00a0 \u00a0 B23.\u00a0\u00a0\u00a0 \u00a0 D24.\u00a0\u00a0\u00a0 \u00a0 A25.\u00a0\u00a0\u00a0 \u00a0 B26.\u00a0\u00a0\u00a0 \u00a0 A27.\u00a0\u00a0\u00a0 \u00a0 E28.\u00a0\u00a0\u00a0 \u00a0 E29.\u00a0\u00a0\u00a0 \u00a0 A30.\u00a0\u00a0\u00a0 \u00a0 E31.\u00a0\u00a0\u00a0 \u00a0 C32.\u00a0\u00a0\u00a0 \u00a0 C33.\u00a0\u00a0\u00a0 \u00a0 A34.\u00a0\u00a0\u00a0 \u00a0 D35.\u00a0\u00a0\u00a0 \u00a0 B36.\u00a0\u00a0\u00a0 \u00a0 C37.\u00a0\u00a0\u00a0 \u00a0 B38.\u00a0\u00a0\u00a0 \u00a0 D39.\u00a0\u00a0\u00a0 \u00a0 A40.\u00a0\u00a0\u00a0 \u00a0 B41.\u00a0\u00a0\u00a0 \u00a0 A42.\u00a0\u00a0\u00a0 \u00a0 E43.\u00a0\u00a0\u00a0 \u00a0 A44.\u00a0\u00a0\u00a0 \u00a0 B45.\u00a0\u00a0\u00a0 \u00a0 ANiyam\u0259ddin \u015eahmarov\u018flaq\u0259:( 051)9224229E-mail: niyameddinshahmarov86@gmail.comFb qrup: informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov) %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/yusif.az\/main\/?p=5903","og_locale":"az_AZ","og_type":"article","og_title":"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda) - www.YUSIF.az \u0130nformatika","og_description":"Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)(cavablar\u0131 sonda)1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?A) Name box, Formula bar, CellB) Palitra,Name box, ColumnsC) Cell, Accessories, ModulD) Status bar, Sazlama paneli, TranslyatorE) Ribbon, Sazlama paneli, \u0130nterpretator2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F53) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?A) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olarB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmazC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcrD) Son s\u00fct\u00fcn XFE-dirE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?A) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)A) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 20487) S\u00fctunlar hans\u0131 aral\u0131qda olur?A) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-655368) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda...A) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131rB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131rC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?A) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?A) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFDD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V25611) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?A) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passivC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, UngrupeE) 2- M\u00fctl\u0259q v\u0259 nisbi12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?A) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinciD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?A) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:A) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?A) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5D) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *116) A4:F8 diapazonunda ne\u00e7\u0259 xana var?A) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 3217) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?A) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 1818) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?A) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F919) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?A) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock20) Fill-Right se\u00e7il\u0259rs\u0259...A) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulurB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcrC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulurD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcrE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir21)G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?A) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?A) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 6424) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:A) :  \/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * & #C) $ % ^ & [ ]\u00a0 \u00a0 \u00a0 C) * )  \/ { }E) { } [ ] & < >25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?A) %\u00a0 \u00a0 \u00a0 B) &\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?A) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9D) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F327) # Div\/0!....A) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmirB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131rC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131rD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131rE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r28)\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:A) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardirB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131rC) Toplad\u0131qda cavab 11 ed\u0259c\u0259kD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131rE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir30) =FACT (6) ne\u00e7\u0259 ed\u0259r?A) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 72031) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:A) \/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @32) =Product (2; 4; 8)A) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 3433) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:A) C21+C22+C23+C24+C25B) C21\/C22\/C23\/C24\/C25C) C21+C25D) C21-C22-C23-C24-C25E) C21*C22*C23*C24*C2534) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?A) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH35) B1=20, D1=25Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?A)= B1>D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35D)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=50036) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?A) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6D) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F137) Ne\u00e7\u0259 diaqram tipi vard\u0131r?A) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 538) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?A) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 639) Hans\u0131 qabar\u0131q dioqram tipidir?A) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)A) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 1341) Diaqramda Lagend n\u0259dir?A) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dirB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131rD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?A) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F1143) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?A) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsertD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?A) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131B) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131C) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131D) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131E) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?A) \u015e\u0259rh yarad\u0131rB) Ribbonlar\u0131 gizl\u0259dirC) S\u0259hif\u0259nin format\u0131n\u0131 silirD) \u0130ki s\u00fctunu birl\u0259\u015fdirirE) Aktiv s\u00fctunlar\u0131 gizl\u0259dirCavablar1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 C6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D10.\u00a0\u00a0\u00a0 \u00a0 A11.\u00a0\u00a0\u00a0 \u00a0 B12.\u00a0\u00a0\u00a0 \u00a0 B13.\u00a0\u00a0\u00a0 \u00a0 B14.\u00a0\u00a0\u00a0 \u00a0 D15.\u00a0\u00a0\u00a0 \u00a0 D16.\u00a0\u00a0\u00a0 \u00a0 B17.\u00a0\u00a0\u00a0 \u00a0 E18.\u00a0\u00a0\u00a0 \u00a0 B19.\u00a0\u00a0\u00a0 \u00a0 A20.\u00a0\u00a0\u00a0 \u00a0 C21.\u00a0\u00a0\u00a0 \u00a0 D22.\u00a0\u00a0\u00a0 \u00a0 B23.\u00a0\u00a0\u00a0 \u00a0 D24.\u00a0\u00a0\u00a0 \u00a0 A25.\u00a0\u00a0\u00a0 \u00a0 B26.\u00a0\u00a0\u00a0 \u00a0 A27.\u00a0\u00a0\u00a0 \u00a0 E28.\u00a0\u00a0\u00a0 \u00a0 E29.\u00a0\u00a0\u00a0 \u00a0 A30.\u00a0\u00a0\u00a0 \u00a0 E31.\u00a0\u00a0\u00a0 \u00a0 C32.\u00a0\u00a0\u00a0 \u00a0 C33.\u00a0\u00a0\u00a0 \u00a0 A34.\u00a0\u00a0\u00a0 \u00a0 D35.\u00a0\u00a0\u00a0 \u00a0 B36.\u00a0\u00a0\u00a0 \u00a0 C37.\u00a0\u00a0\u00a0 \u00a0 B38.\u00a0\u00a0\u00a0 \u00a0 D39.\u00a0\u00a0\u00a0 \u00a0 A40.\u00a0\u00a0\u00a0 \u00a0 B41.\u00a0\u00a0\u00a0 \u00a0 A42.\u00a0\u00a0\u00a0 \u00a0 E43.\u00a0\u00a0\u00a0 \u00a0 A44.\u00a0\u00a0\u00a0 \u00a0 B45.\u00a0\u00a0\u00a0 \u00a0 ANiyam\u0259ddin \u015eahmarov\u018flaq\u0259:( 051)9224229E-mail: niyameddinshahmarov86@gmail.comFb qrup: informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov) %","og_url":"https:\/\/yusif.az\/main\/?p=5903","og_site_name":"www.YUSIF.az","article_published_time":"2020-12-15T18:47:04+00:00","article_modified_time":"2020-12-15T18:49:06+00:00","og_image":[{"width":305,"height":280,"url":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/ex.png","type":"image\/png"}],"author":"auto61","twitter_card":"summary_large_image","twitter_misc":{"Written by":"auto61","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/yusif.az\/main\/?p=5903#article","isPartOf":{"@id":"https:\/\/yusif.az\/main\/?p=5903"},"author":{"name":"auto61","@id":"https:\/\/yusif.az\/main\/#\/schema\/person\/904da2c1a1bbe7e501df95c2bc38d146"},"headline":"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda)","datePublished":"2020-12-15T18:47:04+00:00","dateModified":"2020-12-15T18:49:06+00:00","mainEntityOfPage":{"@id":"https:\/\/yusif.az\/main\/?p=5903"},"wordCount":1436,"publisher":{"@id":"https:\/\/yusif.az\/main\/#\/schema\/person\/904da2c1a1bbe7e501df95c2bc38d146"},"image":{"@id":"https:\/\/yusif.az\/main\/?p=5903#primaryimage"},"thumbnailUrl":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/ex.png","articleSection":["\u0130nformatika"],"inLanguage":"az"},{"@type":"WebPage","@id":"https:\/\/yusif.az\/main\/?p=5903","url":"https:\/\/yusif.az\/main\/?p=5903","name":"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda) - www.YUSIF.az \u0130nformatika","isPartOf":{"@id":"https:\/\/yusif.az\/main\/#website"},"primaryImageOfPage":{"@id":"https:\/\/yusif.az\/main\/?p=5903#primaryimage"},"image":{"@id":"https:\/\/yusif.az\/main\/?p=5903#primaryimage"},"thumbnailUrl":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/ex.png","datePublished":"2020-12-15T18:47:04+00:00","dateModified":"2020-12-15T18:49:06+00:00","description":"Excel-45 Test v\u0259 Cavablar\u0131 (Niyam\u0259ddin \u015eahmarov)(cavablar\u0131 sonda)1) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131lar Excel p\u0259nc\u0259r\u0259sin\u0259 aiddir?A) Name box, Formula bar, CellB) Palitra,Name box, ColumnsC) Cell, Accessories, ModulD) Status bar, Sazlama paneli, TranslyatorE) Ribbon, Sazlama paneli, \u0130nterpretator2) K\u00f6m\u0259k p\u0259nc\u0259r\u0259si hans\u0131 funksional d\u00fcym\u0259 il\u0259 a\u00e7\u0131l\u0131r?A) F1\u00a0 \u00a0 B) F2\u00a0 \u00a0 \u00a0C) F3\u00a0 \u00a0 \u00a0D) F4\u00a0 \u00a0 \u00a0E) F53) Formula bar hans\u0131 i\u015far\u0259 il\u0259 g\u00f6st\u0259rilir?4) A\u015fa\u011f\u0131dak\u0131lardan hans\u0131 do\u011frudur?A) Formula bar\u0131 \u0130nsert lent tab\u0131ndan itirib- g\u0259tirm\u0259k olarB) Excel proqram\u0131nda bir xanaya diapazon dem\u0259k olmazC) Shift+ Enter eyni xanada n\u00f6vb\u0259ti s\u0259tir\u0259 d\u00fc\u015f\u00fcrD) Son s\u00fct\u00fcn XFE-dirE) Sheet anlay\u0131\u015f\u0131 il\u0259 Pages anlay\u0131\u015f\u0131 eyni deyil5) Exceld\u0259 \u0259sas g\u00f6r\u00fcl\u0259n i\u015fl\u0259r n\u0259 il\u0259 ba\u011fl\u0131d\u0131r?A) Xana\u00a0 \u00a0 B) Diapazon\u00a0 \u00a0 \u00a0C) C\u0259dv\u0259l\u00a0 \u00a0 \u00a0D) S\u00fctun\u00a0 \u00a0 \u00a0E) S\u0259tir6) H\u0259r bir i\u015f\u00e7i v\u0259r\u0259qind\u0259 ne\u00e7\u0259 s\u00fctun olur? (2010)A) 1048576\u00a0 \u00a0 \u00a0B) 16384\u00a0 \u00a0 \u00a0C) 3\u00a0 \u00a0 \u00a0D) 1\u00a0 \u00a0 E) 20487) S\u00fctunlar hans\u0131 aral\u0131qda olur?A) 1-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) A-XFZ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) A-IV\u00a0 \u00a0 \u00a0 \u00a0 D) A-XFD\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) A-655368) Excel v\u0259r\u0259qin\u0259 h\u0259r hans\u0131 bir s\u00fctun v\u0259 s\u0259tir art\u0131rd\u0131qda...A) S\u00fctunv\u0259 s\u0259tir say\u0131 art\u0131rB) S\u00fctun v\u0259 s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z olaraq qal\u0131rC) S\u00fctun say\u0131 art\u0131r, s\u0259tir say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rD) S\u0259tir say\u0131 art\u0131r, s\u00fctun say\u0131 d\u0259yi\u015fm\u0259z qal\u0131rE) 3 s\u00fctun v\u0259 3 s\u0259tir\u0259 q\u0259d\u0259r \u0259lav\u0259 art\u0131rmaq olar9) Exdeld\u0259 \u0259n ki\u00e7ik obyekt n\u0259dir?A) Columns\u00a0 \u00a0 \u00a0 \u00a0B) Rows\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Table\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Cell\u00a0 \u00a0 \u00a0 \u00a0E) Line10) Sonuncu xananan\u0131n \u00fcnvan\u0131 hans\u0131d\u0131r?A) XFD1048576\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) \u0130V65536\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 65535XFDD) XFE2048\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) \u0130V25611) Exceld\u0259 ne\u00e7\u0259 n\u00f6v xana var v\u0259 hans\u0131lard\u0131r?A) 3-Aktiv, passiv, gizli\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) 2-Aktiv v\u0259 passivC) 3- Aktiv, Passiv, \u0259laq\u0259li\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 2-Grup, UngrupeE) 2- M\u00fctl\u0259q v\u0259 nisbi12) Xanalar t\u0259rkibin\u0259 g\u00f6r\u0259 hans\u0131 hiss\u0259l\u0259r\u0259 b\u00f6l\u00fcn\u00fcr?A) Aktiv v\u0259 passiv\u00a0 \u00a0 \u00a0 \u00a0B) \u0130lkin v\u0259 as\u0131l\u0131\u00a0 \u00a0 \u00a0 \u00a0 C) Birinci v\u0259 ikinciD) M\u00fctl\u0259q v\u0259 nisbi\u00a0 \u00a0 \u00a0 E) M\u00fctl\u0259q v\u0259 qar\u0131\u015f\u0131q13) D\u0259yi\u015f\u0259n \u00fcnvan nec\u0259 \u00fcnvan adlan\u0131r?A) M\u00fctl\u0259q\u00a0 \u00a0 \u00a0 B) Nisbi\u00a0 \u00a0 \u00a0 C) Qar\u0131\u015f\u0131q\u00a0 \u00a0 \u00a0D) As\u0131l\u0131\u00a0 \u00a0 \u00a0E) \u0130lkin14) Qar\u0131\u015f\u0131q \u00fcnvan\u0131 se\u00e7in:A) AB12\u00a0 \u00a0 \u00a0 B) $C$128\u00a0 \u00a0 \u00a0 \u00a0C) $103$D\u00a0 \u00a0 \u00a0D)$F17\u00a0 \u00a0 \u00a0 E) G$45$15) A2:E9 diapazonundak\u0131 xanalar\u0131n say\u0131n\u0131 tapmaq d\u00fcsturu a\u015fa\u011f\u0131dak\u0131lardan hans\u0131d\u0131r?A) 2+9-1*E\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) (9-2-1)\/5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) (9-1+2)*5D) (9-2+1)*5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) (9+2+1) *116) A4:F8 diapazonunda ne\u00e7\u0259 xana var?A) 6\u00a0 \u00a0 \u00a0 \u00a0B) 30\u00a0 \u00a0 \u00a0 C) 4\u00a0 \u00a0 \u00a0 D) 12\u00a0 \u00a0 \u00a0E) 3217) F18 veril\u0259nind\u0259 s\u0259tirin n\u00f6mr\u0259si ne\u00e7\u0259dir?A) 1\u00a0 \u00a0 \u00a0 B) 19\u00a0 \u00a0 \u00a0 C) 17\u00a0 \u00a0 \u00a0 D) 48\u00a0 \u00a0 \u00a0E) 1818) Xanadak\u0131 veril\u0259nl\u0259ri red\u0259kt\u0259 etm\u0259k \u00fc\u00e7\u00fcn fun ksional d\u00fcym\u0259l\u0259rd\u0259n hans\u0131ndan istifad\u0259 olunur?A) F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) F2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F919) M\u00fcxt\u0259lif yerl\u0259rd\u0259 olan xanalar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f s\u0131x\u0131l\u0131 saxlan\u0131lmal\u0131d\u0131r?A) Ctrl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Alt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) Space\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Numlock20) Fill-Right se\u00e7il\u0259rs\u0259...A) Se\u00e7ilmi\u015f xanalar\u0131n sa\u011f t\u0259r\u0259find\u0259 olan m\u0259lumatlar soldak\u0131 xanaya doldurulurB) Se\u00e7ilmi\u015f c\u0259dv\u0259l aktivc\u0259dv\u0259ld\u0259n sa\u011f t\u0259r\u0259f\u0259 s\u00fcr\u00fc\u015fd\u00fcr\u00fcl\u00fcrC) Se\u00e7ilmi\u015f xanalar\u0131n sol t\u0259r\u0259find\u0259 olan m\u0259lumatlar sa\u011fdak\u0131 xanalara doldurulurD) Se\u015filmi\u015f \u015f\u0259rhd\u0259 olan m\u0259lumat aktiv \u015f\u0259rhd\u0259n sonraya k\u00f6\u00e7\u00fcr\u00fcl\u00fcrE) Yaz\u0131lar yaz\u0131ld\u0131\u011f\u0131 xanada sa\u011f t\u0259r\u0259f\u0259 n\u0259z\u0259r\u0259n d\u00fczl\u0259ndirilir21)G\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Home\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) Review22) Standart halda s\u00fctunun eni hans\u0131 \u00f6l\u00e7\u00fcd\u0259 olur?A) 409 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 8.43 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 12.4 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) 0.7 pt\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) 11.3 pt23) \u0130\u015f\u00e7i v\u0259r\u0259qinin ad\u0131n\u0131n uzunlu\u011fu maksimum ne\u00e7\u0259 simvol ola bil\u0259r?A) 256\u00a0 \u00a0 \u00a0 B) 65536\u00a0 \u00a0 \u00a0 C) 16384\u00a0 \u00a0 \u00a0D) 31\u00a0 \u00a0 \u00a0E) 6424) V\u0259rqin ad\u0131na hans\u0131 simvollar\u0131 verm\u0259k olmaz:A) : \\ \/ ? * [ ]\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) ( ) * & #C) $ % ^ & [ ]\u00a0 \u00a0 \u00a0 C) * ) \\ \/ { }E) { } [ ] & < >25) Hans\u0131 operator m\u0259tnl\u0259rd\u0259n ibar\u0259t olan m\u0259zmunun v\u0259 ya d\u00fcsturlar\u0131n n\u0259tic\u0259l\u0259rinin birl\u0259\u015fdirilm\u0259sini icra edir?A) %\u00a0 \u00a0 \u00a0 B) &\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) #\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) @\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) [26) D\u0259yi\u015fikliyin apar\u0131lmas\u0131ndan as\u0131l\u0131 olmayaraq b\u00fct\u00fcn a\u00e7\u0131q kitablarda d\u00fcsturlar\u0131n hesablanmas\u0131 hans\u0131 klavi\u015f kombinasiyas\u0131 il\u0259 h\u0259yata ke\u00e7irilir?A) Ctrl+Alt+F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Ctrl+Alt+F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Shift+9D) Shift+Alt+F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Alt+Tab+F327) # Div\/0!....A) D\u00fcsturun uzunlu\u011fu xanaya yerl\u0259\u015fmirB) D\u00fcsturda s\u0131f\u0131rlar\u0131n say\u0131 art\u0131qd\u0131rC) D\u00fcsturda s\u0131f\u0131ra vurma vard\u0131rD) D\u00fcsturda bir s\u0131f\u0131r at\u0131lmal\u0131d\u0131rE) D\u00fcsturda s\u0131f\u0131ra b\u00f6lm\u0259 vard\u0131r28)\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259l\u0259r hans\u0131 lent tab\u0131na aiddir?A) \u0130nsert\u00a0 \u00a0 \u00a0 \u00a0B) Home\u00a0 \u00a0 \u00a0C) Data\u00a0 \u00a0 \u00a0 D)View\u00a0 \u00a0 \u00a0E) Formulas29)= ABS (5) v\u0259 = ABS (-5) \u00fc\u00e7\u00fcn d\u00fcz olan fikri se\u00e7in:A) \u0130kisinind\u0259 qiym\u0259ti 5-\u0259 b\u0259r\u0259bardirB) \u0130kisinid\u0259 q\u00fcvv\u0259ti hesablan\u0131rC) Toplad\u0131qda cavab 11 ed\u0259c\u0259kD) Birinci 5-in faktorial\u0131, ikinci 5-in faizi hesablan\u0131rE) Birincinin qiym\u0259ti -5-\u0259, ikincinin qiym\u0259ti 5-\u0259 b\u0259rab\u0259rdir30) =FACT (6) ne\u00e7\u0259 ed\u0259r?A) 6\u00a0 \u00a0 \u00a0 B) -6\u00a0 \u00a0 \u00a0 C) 36\u00a0 \u00a0 \u00a0 D) 1\u00a0 \u00a0 \u00a0E) 72031) Power funksiyas\u0131na uy\u011fun olan simvolu se\u00e7in:A) \/\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) *\u00a0 \u00a0 \u00a0 \u00a0C) ^\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) $\u00a0 \u00a0 \u00a0 \u00a0 E) @32) =Product (2; 4; 8)A) 48\u00a0 \u00a0 \u00a0 \u00a0 B) 16\u00a0 \u00a0 \u00a0 \u00a0 C) 64\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 3433) C21:C25 a\u00e7\u0131l\u0131\u015f\u0131n\u0131 se\u00e7in:A) C21+C22+C23+C24+C25B) C21\/C22\/C23\/C24\/C25C) C21+C25D) C21-C22-C23-C24-C25E) C21*C22*C23*C24*C2534) M\u00fc\u0259yy\u0259n \u015f\u0259rti \u00f6d\u0259y\u0259n \u0259d\u0259dl\u0259ri toplamaq \u00fc\u00e7\u00fcn hans\u0131 funksiyadan istifad\u0259 olunur?A) CAUNTA\u00a0 \u00a0 \u00a0 B) SUM\u00a0 \u00a0 \u00a0 C) ABS\u00a0 \u00a0 \u00a0 D) SUM\u0130F\u00a0 \u00a0 \u00a0 E) MATH35) B1=20, D1=25Hans\u0131 \u015f\u0259rt\u0259 g\u00f6r\u0259 cavab True olar?A)= B1>D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0B)= B1&lt;D1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) =B1+D1=35D)= D1-B1=10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) =B1+D1=50036) Exceld\u0259 a\u00e7\u0131lm\u0131\u015f kitab\u0131n birind\u0259n dig\u0259rin\u0259 s\u00fcr\u0259tli ke\u00e7id \u00fc\u00e7\u00fcn hans\u0131 klavi\u015f kombinasiyas\u0131ndan istifad\u0259 olunur?A) Shift+F5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) Shft+F1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Ctrl+F6D) Shift+F6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Tab+F137) Ne\u00e7\u0259 diaqram tipi vard\u0131r?A) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) 93\u00a0 \u00a0 \u00a0 \u00a0D) 6\u00a0 \u00a0 \u00a0 \u00a0E) 538) Diaqram tipin\u0259 aid olan ne\u00e7\u0259 alt tip vard\u0131r?A) 11\u00a0 \u00a0 \u00a0 \u00a0 B) 17\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 93\u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 73\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 639) Hans\u0131 qabar\u0131q dioqram tipidir?A) Buuble\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Radar\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) Surface\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) Area\u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Scatter40) Diaqram ne\u00e7\u0259y\u0259 q\u0259d\u0259r veril\u0259n s\u0131ras\u0131na malik ola bil\u0259r? ( Dair\u0259vi diaqram istisna olmaqla)A) 128\u00a0 \u00a0 \u00a0 \u00a0 \u00a0B) 255\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) 14\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0D) 7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) 1341) Diaqramda Lagend n\u0259dir?A) Veril\u0259nl\u0259r s\u0131ras\u0131n\u0131n adlar\u0131n\u0131n yerl\u0259\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dirB) Diaqram\u0131n ad\u0131n\u0131n yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirC) S\u00fctunlu diaqramda s\u00fctunun \u0130ngilis dilind\u0259 ad\u0131d\u0131rD) Diaqramda fazizin yaz\u0131ld\u0131\u011f\u0131 sah\u0259dirE) Oxlar\u0131n birl\u0131\u015fdiyi d\u00fczbucaql\u0131 sah\u0259dir42) Diaqram hans\u0131 funksional d\u00fcym\u0259 il\u0259 qurula bil\u0259r?A) F12\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) F8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 C) F9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 D) F7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 E) F1143) \u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz i\u015far\u0259 hans\u0131 lent tab\u0131na aiddir?A) Data\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 B) Formulas\u00a0 \u00a0 \u00a0 \u00a0 \u00a0C) \u0130nsertD) View\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0E) Review44) S\u0259hif\u0259 parametrl\u0259ri \u00fc\u00e7\u00fcn se\u00e7il\u0259n TOP 2 n\u0259yi bildirir?A) A\u015fa\u011f\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131B) Yuxar\u0131dan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131C) Soldan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131D) Sa\u011fdan m\u0259saf\u0259nin 2 pt olaca\u011f\u0131n\u0131E) C\u0259dv\u0259lin 2 pt yuxar\u0131 s\u00fcr\u00fc\u0259c\u0259yini45) Shift+F2 hans\u0131 funksiyan\u0131 yerin\u0259 yetirir?A) \u015e\u0259rh yarad\u0131rB) Ribbonlar\u0131 gizl\u0259dirC) S\u0259hif\u0259nin format\u0131n\u0131 silirD) \u0130ki s\u00fctunu birl\u0259\u015fdirirE) Aktiv s\u00fctunlar\u0131 gizl\u0259dirCavablar1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 A3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 C6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 D10.\u00a0\u00a0\u00a0 \u00a0 A11.\u00a0\u00a0\u00a0 \u00a0 B12.\u00a0\u00a0\u00a0 \u00a0 B13.\u00a0\u00a0\u00a0 \u00a0 B14.\u00a0\u00a0\u00a0 \u00a0 D15.\u00a0\u00a0\u00a0 \u00a0 D16.\u00a0\u00a0\u00a0 \u00a0 B17.\u00a0\u00a0\u00a0 \u00a0 E18.\u00a0\u00a0\u00a0 \u00a0 B19.\u00a0\u00a0\u00a0 \u00a0 A20.\u00a0\u00a0\u00a0 \u00a0 C21.\u00a0\u00a0\u00a0 \u00a0 D22.\u00a0\u00a0\u00a0 \u00a0 B23.\u00a0\u00a0\u00a0 \u00a0 D24.\u00a0\u00a0\u00a0 \u00a0 A25.\u00a0\u00a0\u00a0 \u00a0 B26.\u00a0\u00a0\u00a0 \u00a0 A27.\u00a0\u00a0\u00a0 \u00a0 E28.\u00a0\u00a0\u00a0 \u00a0 E29.\u00a0\u00a0\u00a0 \u00a0 A30.\u00a0\u00a0\u00a0 \u00a0 E31.\u00a0\u00a0\u00a0 \u00a0 C32.\u00a0\u00a0\u00a0 \u00a0 C33.\u00a0\u00a0\u00a0 \u00a0 A34.\u00a0\u00a0\u00a0 \u00a0 D35.\u00a0\u00a0\u00a0 \u00a0 B36.\u00a0\u00a0\u00a0 \u00a0 C37.\u00a0\u00a0\u00a0 \u00a0 B38.\u00a0\u00a0\u00a0 \u00a0 D39.\u00a0\u00a0\u00a0 \u00a0 A40.\u00a0\u00a0\u00a0 \u00a0 B41.\u00a0\u00a0\u00a0 \u00a0 A42.\u00a0\u00a0\u00a0 \u00a0 E43.\u00a0\u00a0\u00a0 \u00a0 A44.\u00a0\u00a0\u00a0 \u00a0 B45.\u00a0\u00a0\u00a0 \u00a0 ANiyam\u0259ddin \u015eahmarov\u018flaq\u0259:( 051)9224229E-mail: niyameddinshahmarov86@gmail.comFb qrup: informatika testl\u0259ri (niyam\u0259ddin \u015fahmarov) %","breadcrumb":{"@id":"https:\/\/yusif.az\/main\/?p=5903#breadcrumb"},"inLanguage":"az","potentialAction":[{"@type":"ReadAction","target":["https:\/\/yusif.az\/main\/?p=5903"]}]},{"@type":"ImageObject","inLanguage":"az","@id":"https:\/\/yusif.az\/main\/?p=5903#primaryimage","url":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/ex.png","contentUrl":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2020\/12\/ex.png","width":305,"height":280},{"@type":"BreadcrumbList","@id":"https:\/\/yusif.az\/main\/?p=5903#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/yusif.az\/main"},{"@type":"ListItem","position":2,"name":"Excel-45 Test v\u0259 Cavablar\u0131 (TQDK kitab\u0131 \u0259sas\u0131nda)"}]},{"@type":"WebSite","@id":"https:\/\/yusif.az\/main\/#website","url":"https:\/\/yusif.az\/main\/","name":"www.YUSIF.az","description":"Birlikd\u0259 Y\u00fcks\u0259li\u015f\u0259 Do\u011fru!!!","publisher":{"@id":"https:\/\/yusif.az\/main\/#\/schema\/person\/904da2c1a1bbe7e501df95c2bc38d146"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/yusif.az\/main\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"az"},{"@type":["Person","Organization"],"@id":"https:\/\/yusif.az\/main\/#\/schema\/person\/904da2c1a1bbe7e501df95c2bc38d146","name":"auto61","image":{"@type":"ImageObject","inLanguage":"az","@id":"https:\/\/secure.gravatar.com\/avatar\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g","caption":"auto61"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/206904355e04c426b5ca443938aabf7f3ee8e177abeb155e7567388fa9c208a3?s=96&d=wavatar&r=g"}}]}},"_links":{"self":[{"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/posts\/5903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5903"}],"version-history":[{"count":1,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/posts\/5903\/revisions"}],"predecessor-version":[{"id":5908,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/posts\/5903\/revisions\/5908"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/media\/5907"}],"wp:attachment":[{"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}