{"id":3400,"date":"2018-12-17T17:29:03","date_gmt":"2018-12-17T13:29:03","guid":{"rendered":"http:\/\/yusif.az\/main\/?p=3400"},"modified":"2018-12-17T17:29:03","modified_gmt":"2018-12-17T13:29:03","slug":"microsoft-excel-proqrami-uzr%c9%99-d%c9%99rslik","status":"publish","type":"post","link":"https:\/\/yusif.az\/main\/?p=3400","title":{"rendered":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik"},"content":{"rendered":"<blockquote>\n<h2 style=\"text-align: center;\"><span style=\"color: #ff00ff;\"><strong>Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik<\/strong><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>\u0130\u015f\u0259 ba\u015flamaq \u00fc\u00e7\u00fcn Start menyusunun Programs hiss\u0259sind\u0259n Microsoft Excel s\u0259trini se\u00e7in. Excel proqram\u0131n\u0131n p\u0259nc\u0259r\u0259sin\u0259 n\u0259z\u0259r yetir\u0259k.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"407\" height=\"279\" class=\"wp-image-3405\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1012.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1012.jpeg 407w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1012-300x206.jpeg 300w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>G\u00f6rd\u00fcy\u00fcn\u00fcz kimi Excel\u2019in b\u0259zi d\u00fcym\u0259l\u0259ri ba\u015fqa proqramlar\u0131n\u0131n d\u00fcym\u0259l\u0259rin\u0259 b\u0259nz\u0259yir. Y\u0259ni, bu o dem\u0259kdir ki, ba\u015fqa proqramlar kimi \u00f6z s\u0259n\u0259dini Save d\u00fcym\u0259si il\u0259 yadda\u015fa verm\u0259y\u0259 imkan verir v\u0259 s. Birc\u0259 onu da qeyd etm\u0259k laz\u0131md\u0131 ki, burada s\u0259n\u0259d\u0259 kitab (Book) deyilir.<\/p>\n<p>Excel\u2019in kitab\u0131 bir ne\u00e7\u0259 s\u0259hif\u0259d\u0259n ibar\u0259t ola bil\u0259r. H\u0259r s\u0259hif\u0259d\u0259 is\u0259 256 s\u00fctun v\u0259 65536 s\u0259tir var. S\u0259tir v\u0259 sutunun k\u0259si\u015fm\u0259si biz\u0259 bir i\u015f sah\u0259si verir ki, h\u0259min i\u015f sah\u0259sind\u0259 r\u0259q\u0259m, m\u0259tn v\u0259 ya tarix yazmaq m\u00fcmk\u00fcnd\u00fc. H\u0259r bir i\u015f sah\u0259sinin \u00f6z \u00fcnvan\u0131 var; i\u015f sah\u0259sinin \u00fcnvan\u0131 onun yerl\u0259\u015fdiyi s\u00fctun v\u0259 s\u0259tr adlar\u0131ndan ibar\u0259tdi. M\u0259s., f s\u00fctununda yerl\u0259\u015f\u0259n 1-ci s\u0259trin \u00fcnvan\u0131 A1 olur.<\/p>\n<p>M\u0259lumat\u0131n daxil edilm\u0259sinin qaydalar\u0131.<\/p>\n<ol>\n<li>M\u0259tni v\u0259 ya r\u0259q\u0259mi daxil etdikd\u0259n sonra Enter bas\u0131l\u0131r v\u0259 ya ba\u015fqa bir \u00fcnvanda d\u00fcym\u0259 bas\u0131l\u0131r.<\/li>\n<li>Art\u0131q m\u0259lumat olan \u00fcnvanda yeni m\u0259lumat yazmaq \u00fc\u00e7\u00fcn sad\u0259c\u0259 \u00fcz\u0259rind\u0259 mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n v\u0259 yeni m\u0259lumat\u0131 daxil edin.<\/li>\n<li>Art\u0131q m\u0259lumat olan \u00fcnvanda d\u0259yi\u015fiklik etm\u0259k \u00fc\u00e7\u00fcn \u00fcz\u0259rind\u0259 mausun d\u00fcym\u0259sini iki d\u0259f\u0259 bas\u0131n.<\/li>\n<\/ol>\n<p><strong>M\u0259tn il\u0259 r\u0259q\u0259ml\u0259rin f\u0259rqi<\/strong><\/p>\n<p>G\u0259l\u0259n d\u0259rsl\u0259rimizd\u0259 biz Excel\u2019in r\u0259q\u0259ml\u0259rl\u0259 etdiyi hesablamalarla i\u015fl\u0259y\u0259c\u0259yik, amma r\u0259q\u0259ml\u0259 \u0259m\u0259liyyat\u0131 d\u00fczg\u00fcn yerin\u0259 yetirilm\u0259si \u00fc\u00e7\u00fcn r\u0259q\u0259mi x\u00fcsusi qaydalar il\u0259 yazmaq vacibdi.<\/p>\n<ol>\n<li>R\u0259q\u0259m yazd\u0131qda onunla yana\u015f\u0131 he\u00e7 bir ba\u015fqa i\u015far\u0259 qoymaq olmaz (m\u0259s., verg\u00fcl v\u0259 ya dollar i\u015far\u0259si.<\/li>\n<li>K\u0259miyy\u0259tin tam v\u0259 onluq hiss\u0259sini ay\u0131rmaq \u00fc\u00e7\u00fcn n\u00f6qt\u0259d\u0259n istifad\u0259 edin.<\/li>\n<li>R\u0259q\u0259ml\u0259ri daxil etdikd\u0259n sonra (m\u0259s. Enter basd\u0131qdan sonra) onun sa\u011f t\u0259r\u0259f\u0259 yaz\u0131lmas\u0131 r\u0259q\u0259min d\u00fcz yaz\u0131ld\u0131\u011f\u0131n\u0131 bildirir.<\/li>\n<\/ol>\n<p>D\u0259rsd\u0259 \u00f6yr\u0259ndiyimizi t\u0259krar etm\u0259k m\u0259qs\u0259di il\u0259 bir sad\u0259 c\u0259dv\u0259l yaradaq. Bu c\u0259dv\u0259li yaratd\u0131qdan sonra onu m\u00fctl\u0259q yadda\u015fa verin v\u0259 \u00e7al\u0131\u015f\u0131n ki, onu itirm\u0259y\u0259siz; bu c\u0259dv\u0259ld\u0259n g\u0259l\u0259c\u0259k d\u0259rsl\u0259rd\u0259 istifad\u0259 ed\u0259c\u0259yik.<\/p>\n<ol>\n<li>A1 \u00fcnvan\u0131nda mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n. \u015erifti d\u0259yi\u015fin v\u0259 \u00ab\u018fm\u0259k haqq\u0131 c\u0259dv\u0259li\u00bb \u00e7ap edin.<\/li>\n<li>A2 \u00fcnvan\u0131nda \u00abAd\u0131, soyad\u0131, atas\u0131n\u0131n ad\u0131\u00bb \u00e7ap edin.<\/li>\n<\/ol>\n<p>Siz\u0259, y\u0259qin ki, s\u00fctunun enini d\u0259yi\u015fm\u0259k laz\u0131m olacaq. Bunu etm\u0259k \u00fc\u00e7\u00fcn oxu f v\u0259 d s\u00fctununun ba\u015fl\u0131qlar\u0131 s\u0259rh\u0259ddin\u0259 g\u0259tirin v\u0259 d\u00fcym\u0259ni bas\u0131l\u0131 saxlayaraq eni d\u0259yi\u015fin.<\/p>\n<p>B\u00fct\u00fcn s\u0259n\u0259din \u015friftini d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn A s\u00fctunundan solda olan ads\u0131z d\u00fcym\u0259d\u0259 mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n v\u0259 \u015frifti d\u0259yi\u015fin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"247\" height=\"128\" class=\"wp-image-3406\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1013.jpeg\" \/><\/p>\n<ol>\n<li>A s\u00fctununa 10 ad daxil edin<\/li>\n<li>V2 \u00fcnvan\u0131na \u00ab\u018fm\u0259k haqq\u0131\u00bb daxil edin.<\/li>\n<li>Adlara m\u00fcvafiq olaraq 100-500 aras\u0131nda k\u0259miyy\u0259tl\u0259r daxil edin.<\/li>\n<\/ol>\n<p>Yeni s\u0259tir \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn Insert menyusundan Rows se\u00e7in.<\/p>\n<p>Yeni s\u00fctun \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn Insert menyusundan Columns se\u00e7in.<\/p>\n<ol>\n<li>A v\u0259 d s\u00fctunlar aras\u0131na yeni s\u00fctun \u0259lav\u0259 edin. Onun ba\u015fl\u0131\u011f\u0131na \u00abV\u0259zif\u0259\u00bb daxil edin v\u0259 adlara m\u00fcvafiq v\u0259zif\u0259l\u0259r yaz\u0131n.<\/li>\n<\/ol>\n<p>\u00c7\u0259r\u00e7iv\u0259 n\u00f6vl\u0259rini Borders siyah\u0131s\u0131ndan se\u00e7\u0259 bil\u0259rsiz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"186\" height=\"157\" class=\"wp-image-3407\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1014.jpeg\" \/><\/p>\n<p><strong>D\u0259rs 2. S\u0259tir v\u0259 s\u00fctunlar il\u0259 \u0259m\u0259liyyatlar. &#8211; &#8212;<\/strong><\/p>\n<p><strong>S\u0259hif\u0259d\u0259 yaz\u0131lm\u0131\u015f c\u0259dv\u0259liniz\u0259 yeni s\u0259tir \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn:<\/strong><\/p>\n<ol>\n<li>\u00fcsul.\n<ol>\n<li>Yeni s\u0259trin yerini m\u00fc\u0259yy\u0259n etm\u0259k \u00fc\u00e7\u00fcn bir \u00fcnvan se\u00e7in (yeni s\u0259tir se\u00e7diyinizd\u0259n <strong><em>\u0259vv\u0259l <\/em><\/strong>yaranacaq).<\/li>\n<li>Insert menyusundan Rows se\u00e7in.<\/li>\n<\/ol>\n<\/li>\n<li>\u00fcsul.\n<ol>\n<li>Yeni s\u0259trin yerini m\u00fc\u0259yy\u0259n etm\u0259k \u00fc\u00e7\u00fcn bir* s\u0259tir se\u00e7in (s\u0259tri se\u00e7m\u0259k \u00fc\u00e7\u00fcn onu ba\u015fl\u0131\u011f\u0131nda d\u00fcym\u0259ni basmaq kifay\u0259tdir).<\/li>\n<li>Se\u00e7diyiniz s\u0259trin \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131n v\u0259 Insert se\u00e7in.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"164\" height=\"49\" class=\"wp-image-3408\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1015.jpeg\" \/><\/p>\n<ul>\n<li>Bir s\u0259tir deyil bir ne\u00e7\u0259 s\u0259tir se\u00e7dikd\u0259 yeni s\u0259tirl\u0259rin say\u0131 da d\u0259yi\u015fir( m\u0259s., iki s\u0259tir se\u00e7ib v\u0259 onlar\u0131n \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131b Insert se\u00e7dikd\u0259 iki yeni s\u0259tir daxil edirsiniz).<\/li>\n<\/ul>\n<p><strong>S\u0259hif\u0259d\u0259 yaz\u0131lm\u0131\u015f c\u0259dv\u0259liniz\u0259 yeni s\u00fctun \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn:<\/strong><\/p>\n<ol>\n<li>\u00fcsul.\n<ol>\n<li>Yeni s\u00fctunun yerini m\u00fc\u0259yy\u0259n etm\u0259k \u00fc\u00e7\u00fcn bir \u00fcnvan se\u00e7in (yeni s\u00fctun se\u00e7diyinizd\u0259n <strong><em>\u0259vv\u0259l<\/em><\/strong> yaranacaq).<\/li>\n<li>Insert menyusundan Columns se\u00e7in.<\/li>\n<\/ol>\n<\/li>\n<li>\u00fcsul.\n<ol>\n<li>Yeni s\u00fctunun yerini m\u00fc\u0259yy\u0259n etm\u0259k \u00fc\u00e7\u00fcn bir* s\u00fctun se\u00e7in (s\u00fctunu se\u00e7m\u0259k \u00fc\u00e7\u00fcn onu ba\u015fl\u0131\u011f\u0131nda d\u00fcym\u0259ni basmaq kifay\u0259tdir).<\/li>\n<li>Se\u00e7diyiniz s\u00fctunun \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131n v\u0259 Insert se\u00e7in.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"136\" height=\"81\" class=\"wp-image-3409\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1016.jpeg\" \/><\/p>\n<ul>\n<li>Bir s\u00fctun deyil bir ne\u00e7\u0259 s\u00fctun se\u00e7dikd\u0259 yeni s\u00fctunl\u0259rin say\u0131 da d\u0259yi\u015fir( m\u0259s., iki s\u00fctun se\u00e7ib v\u0259 onlar\u0131n \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131b Insert se\u00e7dikd\u0259 iki yeni s\u00fctun daxil edirsiniz).<\/li>\n<\/ul>\n<p><strong>S\u0259hif\u0259d\u0259 yaz\u0131lm\u0131\u015f c\u0259dv\u0259linizd\u0259n bir s\u0259tir l\u0259\u011fv etm\u0259k \u00fc\u00e7\u00fcn:<\/strong><\/p>\n<ol>\n<li>Bir v\u0259 ya bir ne\u00e7\u0259 s\u0259tir se\u00e7in (s\u0259tri se\u00e7m\u0259k \u00fc\u00e7\u00fcn onu ba\u015fl\u0131\u011f\u0131nda d\u00fcym\u0259ni basmaq kifay\u0259tdir).<\/li>\n<li>Se\u00e7diyiniz s\u0259trin \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131n v\u0259 Delete se\u00e7in.<\/li>\n<\/ol>\n<p>S\u0259hif\u0259d\u0259 yaz\u0131lm\u0131\u015f c\u0259dv\u0259linizd\u0259n bir s\u00fctun l\u0259\u011fv etm\u0259k \u00fc\u00e7\u00fcn:<\/p>\n<ol>\n<li>Bir v\u0259 ya bir ne\u00e7\u0259 s\u00fctun se\u00e7in (s\u00fctunu se\u00e7m\u0259k \u00fc\u00e7\u00fcn onu ba\u015fl\u0131\u011f\u0131nda d\u00fcym\u0259ni basmaq kifay\u0259tdir).<\/li>\n<li>Se\u00e7diyiniz s\u00fctunun \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131n v\u0259 Delete se\u00e7in.<\/li>\n<\/ol>\n<p><strong>S\u0259hif\u0259l\u0259r il\u0259 \u0259m\u0259liyyatlar.<\/strong><\/p>\n<p>Ad\u0259t\u0259n Excel il\u0259 i\u015fi ba\u015flayanda Sheet1, Sheet2 v\u0259 Sheet3 adl\u0131 s\u0259hif\u0259l\u0259r olur. Bu s\u0259hif\u0259l\u0259rin say\u0131n\u0131 art\u0131rmaq v\u0259 azaltmaq olur. Yeni s\u0259hif\u0259 \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn Insert menyusunda olan Worksheet se\u00e7m\u0259k kifay\u0259tdir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"135\" class=\"wp-image-3410\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1017.jpeg\" \/><\/p>\n<p>S\u0259hif\u0259l\u0259rd\u0259n h\u0259r hans\u0131 birini l\u0259\u011fv etm\u0259k \u00fc\u00e7\u00fcn onun ad\u0131 \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni basaraq Delete v\u0259 ya Edit menyusundan Delete Sheet se\u00e7in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"195\" height=\"151\" class=\"wp-image-3411\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1018.jpeg\" \/><\/p>\n<p>S\u0259hif\u0259nin ad\u0131n\u0131 d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn h\u0259min ad\u0131n \u00fcz\u0259rind\u0259 iki d\u0259f\u0259 d\u00fcym\u0259ni basaraq v\u0259 ya sa\u011f d\u00fcym\u0259ni bas\u0131b Rename se\u00e7\u0259r\u0259k yeni ad daxil edin.<\/p>\n<p>S\u0259hif\u0259l\u0259r m\u00fc\u0259yy\u0259n ard\u0131c\u0131ll\u0131q il\u0259 d\u00fcz\u00fcl\u00fcb. Bu ard\u0131c\u0131ll\u0131\u011f\u0131 d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn (y\u0259ni m\u0259s., Sheet1 s\u0259hif\u0259sini ax\u0131ra ke\u00e7irm\u0259k \u00fc\u00e7\u00fcn) h\u0259min s\u0259hif\u0259nin ad\u0131 \u00fcz\u0259rin\u0259 mausun oxunu y\u00f6n\u0259ldin v\u0259 d\u00fcym\u0259ni bas\u0131l\u0131 saxlayaraq s\u0259hif\u0259nin yerini d\u0259yi\u015fin. Bu \u0259m\u0259liyyat\u0131 Ctrl d\u00fcym\u0259sini bas\u0131l\u0131 saxlayaraq yerin\u0259 yetirs\u0259z, h\u0259min s\u0259hif\u0259nin ikinci n\u00fcsx\u0259sini ala bil\u0259rsiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"71\" class=\"wp-image-3412\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1019.jpeg\" \/><\/p>\n<p>S\u0259hif\u0259l\u0259rin say\u0131 \u00e7ox olduqda onlar\u0131n ham\u0131s\u0131n\u0131n ad\u0131n\u0131 ekranda g\u00f6rm\u0259k olmur. Bunu etm\u0259k \u00fc\u00e7\u00fcn S\u0259hif\u0259 adlar\u0131ndan solda yerl\u0259\u015f\u0259n ki\u00e7ik d\u00fcym\u0259cikl\u0259rd\u0259n istifad\u0259 etm\u0259k olur.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"169\" class=\"wp-image-3413\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1020.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1020.jpeg 486w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1020-300x104.jpeg 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/p>\n<p><strong>D\u0259rs 3. M\u0259&#8217;lumat\u0131n format\u0131. &#8211; &#8212;<\/strong><\/p>\n<p>Daxil etdiyiniz r\u0259q\u0259ml\u0259r m\u00fcxt\u0259lif formatda ola bil\u0259r. M\u0259s\u0259l\u0259n c\u0259dv\u0259limiz\u0259 daxil etdiyimiz \u0259m\u0259k haqq\u0131 k\u0259miyy\u0259tl\u0259rini dollar format\u0131na ke\u00e7ir\u0259 bil\u0259rik. Bunu etm\u0259k \u00fc\u00e7\u00fcn h\u0259min r\u0259q\u0259ml\u0259ri se\u00e7in v\u0259 x\u00fcsusi dollar i\u015far\u0259si olan d\u00fcym\u0259ni bas\u0131n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"61\" height=\"50\" class=\"wp-image-3414\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1021.jpeg\" \/><\/p>\n<p>Bir ne\u00e7\u0259 \u00fcnvan\u0131 se\u00e7dikd\u0259 etdiyimiz d\u0259yi\u015fiklikl\u0259ri onlara t\u0259tbiq ed\u0259 bil\u0259rik. Bir ne\u00e7\u0259 \u00fcnvan se\u00e7m\u0259k \u00fc\u00e7\u00fcn mausun g\u00f6st\u0259ricisi a\u015fa\u011f\u0131dak\u0131 kimi olarsa mausun d\u00fcym\u0259sini bas\u0131l\u0131 saxlayaraq bir diapazon se\u00e7in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"110\" height=\"102\" class=\"wp-image-3415\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1022.jpeg\" \/><\/p>\n<p>Qon\u015fu olmayan \u00fcnvanlar\u0131 se\u00e7m\u0259k \u00fc\u00e7\u00fcn Ctrl d\u00fcym\u0259sini bas\u0131l\u0131 saxlay\u0131n.<\/p>\n<p>S\u0259hif\u0259d\u0259 olan b\u00fct\u00fcn \u00fcnvanlara bir \u0259m\u0259liyyat t\u0259tbiq etm\u0259k \u00fc\u00e7\u00fcn s\u00fctun adlar\u0131ndan solda s\u0259tir adlar\u0131ndan yuxar\u0131 yerl\u0259\u015f\u0259n ads\u0131z d\u00fcym\u0259ni basmaq olar. Bunu etdikd\u0259n sonra b\u00fct\u00fcn s\u0259hif\u0259 se\u00e7ilir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"131\" height=\"124\" class=\"wp-image-3416\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1023.jpeg\" \/><\/p>\n<p>N\u00f6qt\u0259d\u0259n sonra duran r\u0259q\u0259ml\u0259rin say\u0131n\u0131 d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn Increase Decimals v\u0259 Decrease Decimals d\u00fcym\u0259l\u0259rind\u0259n istifad\u0259 edin. Decrease Decimals k\u0259miyy\u0259ti yuvarlamaq \u00fc\u00e7\u00fcn d\u0259 istifad\u0259 edil\u0259 bil\u0259r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"71\" height=\"37\" class=\"wp-image-3417\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1024.jpeg\" \/><\/p>\n<p>M\u0259tnin v\u0259 ya r\u0259q\u0259ml\u0259ri r\u0259ngini d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn Font Color d\u00fcym\u0259sind\u0259n istifad\u0259 edin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"169\" height=\"172\" class=\"wp-image-3418\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1025.jpeg\" \/><\/p>\n<p>Fonun r\u0259ngini d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn Fill Color d\u00fcym\u0259sind\u0259n istifad\u0259 edin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"175\" height=\"168\" class=\"wp-image-3419\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1026.jpeg\" \/><\/p>\n<p>Bir \u00fcnvan\u0131n format\u0131n\u0131 ba\u015fqas\u0131na k\u00f6\u00e7\u00fcrm\u0259k \u00fc\u00e7\u00fcn Format Painter d\u00fcym\u0259si istifad\u0259 olunur:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"57\" height=\"37\" class=\"wp-image-3420\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1027.jpeg\" \/><\/p>\n<ol>\n<li>Format\u0131n\u0131 ba\u015fqas\u0131na k\u00f6\u00e7\u00fcrm\u0259k ist\u0259diyiniz \u00fcnvan \u00fcz\u0259rind\u0259 d\u00fcym\u0259ni bas\u0131n<\/li>\n<li>Format Painter d\u00fcym\u0259sini bas\u0131n<\/li>\n<li>Ba\u015fqa \u00fcnvanda d\u00fcym\u0259ni bas\u0131n<\/li>\n<\/ol>\n<p><strong>D\u0259rs 4. M\u0259tn il\u0259 \u0259m\u0259liyyatlar &#8211; &#8212;<\/strong><\/p>\n<p>M\u0259tni c\u0259dv\u0259ld\u0259 bir ne\u00e7\u0259 variantlarla yerl\u0259\u015fdirm\u0259k olar<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>V\u0259zif\u0259<\/td>\n<td>\u018fm\u0259k haqq\u0131<\/td>\n<td>S\u0131\u011forta<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>G\u00f6rd\u00fcy\u00fcn\u00fcz bu c\u0259dv\u0259l hiss\u0259sind\u0259 m\u0259tn 3 m\u00fcxt\u0259lif v\u0259zziyy\u0259td\u0259 yerl\u0259\u015fdirilib. Bunu m\u00fcvafiq olaraq Left, Center v\u0259 Right d\u00fcym\u0259l\u0259ri il\u0259 etm\u0259k olar. Bu d\u00fcym\u0259l\u0259rd\u0259n he\u00e7 biri bas\u0131lmay\u0131bsa m\u0259tn avtomatik olaraq solda yerl\u0259\u015fir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"84\" height=\"40\" class=\"wp-image-3421\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1028.jpeg\" \/><\/p>\n<p>M\u0259tnin vertikal \u015f\u0259kild\u0259 yerl\u0259\u015fdirm\u0259sini d\u0259 d\u0259yi\u015fm\u0259k olur.<\/p>\n<p>Bu variantlar\u0131 t\u0259dbiq etm\u0259k \u00fc\u00e7\u00fcn Format meyusunun Cells s\u0259trini se\u00e7ib a\u00e7\u0131lan p\u0259nc\u0259r\u0259nin Alignment hiss\u0259sini se\u00e7irik v\u0259 buradan Vertical siyah\u0131s\u0131ndan bir variant se\u00e7irik.<\/p>\n<p>Burada Top s\u0259tri se\u00e7diyiniz diapazonda m\u0259tni yuxar\u0131da, Center m\u0259rk\u0259zd\u0259, Bottom is\u0259 a\u015fa\u011f\u0131da yerl\u0259\u015fdirir. M\u0259tn bir ne\u00e7\u0259 s\u0259tird\u0259n ibar\u0259tdirs\u0259 Justify s\u0259tirl\u0259ri b\u0259rab\u0259r yerl\u0259\u015fdir\u0259 bil\u0259r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"182\" height=\"191\" class=\"wp-image-3422\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1029.jpeg\" \/><\/p>\n<p>M\u0259tni bir ne\u00e7\u0259 s\u0259tird\u0259 yazmaq \u00fc\u00e7\u00fcn iki \u0259sas \u00fcsul var. Birincisi: m\u0259tni daxil etdiyiniz zaman onun ikinci s\u0259trini yaratmaq \u00fc\u00e7\u00fcn Alt+Enter bas\u0131l\u0131r. Art\u0131q daxil edilmi\u015f m\u0259tni bir ne\u00e7\u0259 s\u0259tird\u0259 yerl\u0259\u015fdirm\u0259k laz\u0131m olsa Format meyusunun Cells s\u0259trini se\u00e7ib a\u00e7\u0131lan p\u0259nc\u0259r\u0259nin Alignment hiss\u0259sini se\u00e7irik v\u0259 Wrap Text\u2019in \u00fcz\u0259rid\u0259 i\u015far\u0259 qoyuruq.<\/p>\n<p>M\u0259tnin ba\u015fqa yaz\u0131l\u0131\u015f formalar\u0131n\u0131 Format meyusunun Cells s\u0259trini se\u00e7ib a\u00e7\u0131lan p\u0259nc\u0259r\u0259nin Alignment hiss\u0259sind\u0259 Orientation il\u0259 m\u00fc\u0259yy\u0259n etm\u0259k olar, burada m\u0259tni yuxar\u0131dan a\u015fa\u011f\u0131 v\u0259 buca\u011f alt\u0131nda yerl\u0259\u015fdirm\u0259k olar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"132\" height=\"211\" class=\"wp-image-3423\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1030.jpeg\" \/><\/p>\n<p>Word proqram\u0131nda oldu\u011fu kimi burada m\u0259tn il\u0259 i\u015fl\u0259m\u0259k \u00fc\u00e7\u00fcn AutoCorrect, Replace v\u0259 c imkanlar var.<\/p>\n<p>M\u0259lumat\u0131n k\u00f6\u00e7\u00fcr\u00fclm\u0259si<\/p>\n<p>H\u0259r hans\u0131 bir \u00fcnvan\u0131 se\u00e7in (v\u0259 ya \u00fcnvan diapazonunu) v\u0259 mausun g\u00f6st\u0259ricisini onun k\u0259nar\u0131na g\u0259tirin v\u0259 k\u00f6st\u0259rici oxa \u00e7evril\u0259nd\u0259 mausun d\u00fcym\u0259sini bas\u0131l\u0131 saxlayaraq onun yerini d\u0259yi\u015fin. Bu \u0259m\u0259liyyat\u0131 etdikd\u0259 Ctrl d\u00fcym\u0259sini bas\u0131l\u0131 saxlasaz m\u0259lumat\u0131n ikinci n\u00fcsx\u0259sini yaratmaq olar. M\u0259lumat\u0131 ba\u015fqa s\u0259hif\u0259y\u0259 ke\u00e7irm\u0259k \u00fc\u00e7\u00fcn Alt d\u00fcym\u0259sini bas\u0131l\u0131 saxlamaq laz\u0131md\u0131.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"218\" height=\"176\" class=\"wp-image-3424\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1031.jpeg\" \/><\/p>\n<p>Cut, Copy v\u0259 Paste d\u00fcym\u0259l\u0259rind\u0259n istifad\u0259 ed\u0259r\u0259k yuxar\u0131dak\u0131 \u0259m\u0259liyyatlar\u0131 etm\u0259k \u00fc\u00e7\u00fcn:<\/p>\n<ol>\n<li>K\u00f6\u00e7\u00fcrm\u0259k ist\u0259diyiniz \u00fcnvan \u00fcz\u0259rind\u0259 Copy d\u00fcym\u0259nsini bas\u0131n. Yerini d\u0259yi\u015fm\u0259k<\/li>\n<\/ol>\n<p>ist\u0259diyiniz \u00fcnvan \u00fcz\u0259rind\u0259 Cut d\u00fcym\u0259sini bas\u0131n<\/p>\n<ul>\n<li>\n<ul>\n<li>\n<ol>\n<li>Yeni yeri t\u0259yin edin<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<ol>\n<li>Paste v\u0259 ya Enter\u2019i bas\u0131n.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"194\" height=\"108\" class=\"wp-image-3425\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1032.jpeg\" \/><\/p>\n<p>M\u0259lumat\u0131 ard\u0131c\u0131l k\u00f6\u00e7\u00fcrm\u0259k \u00fc\u00e7\u00fcn:<\/p>\n<p>H\u0259r hans\u0131 bir \u00fcnvan\u0131 se\u00e7in (v\u0259 ya \u00fcnvan diapazonunu) v\u0259 mausun g\u00f6st\u0259ricisini onun k\u0259nar\u0131na g\u0259tirin v\u0259 k\u00f6st\u0259rici qara xa\u00e7 i\u015far\u0259sin\u0259 \u00e7evril\u0259nd\u0259 mausun d\u00fcym\u0259sini bas\u0131l\u0131 saxlayaraq onun yerini d\u0259yi\u015fin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"154\" height=\"148\" class=\"wp-image-3426\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1033.jpeg\" \/><\/p>\n<p><strong>D\u0259rs 5. Sad\u0259 d\u00fcsturlar. &#8211; &#8212;<\/strong><\/p>\n<p>D\u00fczg\u00fcn yaz\u0131lm\u0131\u015f r\u0259q\u0259ml\u0259r il\u0259 Excel m\u00fcxt\u0259lif \u0259m\u0259liyyatlar (hesablamalar) apara bil\u0259r. M\u0259s\u0259l\u0259n, yaratd\u0131\u011f\u0131mz c\u0259dv\u0259ld\u0259 \u0259m\u0259k haqq\u0131ndan 1 % tutulmas\u0131 laz\u0131md\u0131 ( m\u0259s. s\u0131\u011forta \u00fc\u00e7\u00fcn ).<\/p>\n<p>\u00ab\u018fm\u0259k haqq\u0131\u00bb s\u00fctunundan sonra \u00abS\u0131\u011forta\u00bb adl\u0131 ba\u015fl\u0131q \u0259lav\u0259 edin. Ba\u015fl\u0131\u011f\u0131n alt\u0131nda mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n. D\u00fcstur yaz\u0131l\u0131\u015f\u0131n birinci qaydas\u0131 d\u00fcsturun \u00ab=\u00bb i\u015far\u0259sind\u0259n ba\u015flanmas\u0131d\u0131. H\u0259min i\u015far\u0259ni daxil edin. Sonra \u0259m\u0259k haqq\u0131n\u0131n \u00fcnvan\u0131n\u0131 y\u0259ni S3 daxil edin v\u0259 ya h\u0259min \u00fcnvan\u0131n \u00fcz\u0259rind\u0259 mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n. Sonra vurma i\u015far\u0259sini \u2013\u00ab*\u00bb- daxil edin v\u0259 1% (%- Shift+5) \u0259lav\u0259 etdikd\u0259n sonra Enter d\u00fcym\u0259sini bas\u0131n. Siz d\u0259rhal hesablaman\u0131n n\u0259tic\u0259sini g\u00f6r\u0259c\u0259ksininz. D\u00fcsturun \u00f6z\u00fcn\u00fc g\u00f6rm\u0259k v\u0259 ya d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn h\u0259min \u00fcnvan\u0131 se\u00e7in v\u0259 Formula Bar\u2019a n\u0259z\u0259r yetirin; v\u0259 ya mausun d\u00fcym\u0259sini iki d\u0259f\u0259 bas\u0131n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"502\" height=\"185\" class=\"wp-image-3427\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1034.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1034.jpeg 502w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1034-300x111.jpeg 300w\" sizes=\"auto, (max-width: 502px) 100vw, 502px\" \/><\/p>\n<p>D\u00fcsturu birinci s\u0259tir \u00fc\u00e7\u00fcn yaratd\u0131qdan sonra onu ard\u0131c\u0131l k\u00f6\u00e7\u00fcrm\u0259 \u00fcsulu il\u0259 ba\u015fqa s\u0259tirl\u0259r\u0259 ke\u00e7irm\u0259k olar. Bunu etdikd\u0259 d\u00fcsturlar m\u00fcvafiq olaraq d\u0259yi\u015fir, y\u0259ni m\u0259s. D3 s\u0259trind\u0259ki d\u00fcstur \u00ab=S3*1%\u00bb olarsa, D5 s\u0259trind\u0259ki d\u00fcstur \u00ab=S5*1%\u00bb olar.<\/p>\n<p>S\u0259d\u0259 \u0259m\u0259liyyatlar\u0131 Excel d\u0259 a\u015fa\u011f\u0131dak\u0131 i\u015far\u0259l\u0259r \u0259v\u0259z edir.<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u018fm\u0259liyyat<\/td>\n<td><\/td>\n<td>Riyaziyyatda<\/td>\n<td>Excel\u2019d\u0259<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Vurma<\/td>\n<td><\/td>\n<td>x<\/td>\n<td>*<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Toplama<\/td>\n<td><\/td>\n<td>+<\/td>\n<td>+<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>B\u00f6lm\u0259<\/td>\n<td><\/td>\n<td>:<\/td>\n<td>\/<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u00c7\u0131xma<\/td>\n<td><\/td>\n<td>&#8211;<\/td>\n<td>&#8211;<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Q\u00fcvv\u0259y\u0259 y\u00fcks\u0259ltm\u0259<\/td>\n<td><\/td>\n<td>3<sup>2<\/sup><\/td>\n<td>^<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Sad\u0259 funksiyalar<\/p>\n<p>\u018fm\u0259liyyatla b\u0259rab\u0259r Excel funksiyalardan da istifad\u0259 edir. M\u0259s., bir b\u00f6y\u00fck diapazonda olan r\u0259q\u0259ml\u0259ri toplamaq \u00fc\u00e7\u00fcn \u00ab+\u00bb \u00fcs\u00fclu \u00e7ox vaxt apar\u0131r v\u0259 bu m\u0259qs\u0259dl\u0259 SUM funksiyas\u0131 istifad\u0259 olunur. M\u0259s., bizim c\u0259dv\u0259ld\u0259 olan b\u00fct\u00fcn \u0259m\u0259k haqqlar\u0131n c\u0259mini tapmaq \u00fc\u00e7\u00fcn \u0259m\u0259k haqq\u0131 c\u0259dv\u0259linin ax\u0131r\u0131nc\u0131 s\u0259trind\u0259n sonra y\u0259ni S14 \u00fcnvan\u0131nda bel\u0259 bir d\u00fcstur daxil edin \u00ab=SUM(C3:C13)\u00bb v\u0259 Enter d\u00fcym\u0259sini bas\u0131n. D\u00fcstur funksiyan\u0131n ad\u0131ndan v\u0259 diapazon \u00fcnvan\u0131ndan ibar\u0259tdir. Diapazon bir ne\u00e7\u0259 \u00fcnvan v\u0259 \u00fcnvanlar qrupundan ibar\u0259t ola bil\u0259r. M\u0259s., g\u00f6rd\u00fcy\u00fcn\u00fcz c\u0259dv\u0259ld\u0259 daxil olunmu\u015f r\u0259q\u0259ml\u0259rin c\u0259mini veril\u0259n d\u00fcstur il\u0259 tapmaq olar.<\/p>\n<p><strong>=SUM(A2:A3,B3,C3:C4,B6,A8)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"271\" height=\"196\" class=\"wp-image-3428\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1035.jpeg\" \/><\/p>\n<p>G\u00f6rd\u00fcy\u00fcn\u00fcz bu d\u00fcsturda bir ne\u00e7\u0259 \u00fcnvan il\u0259 hesablamalar apar\u0131l\u0131r. Burada qon\u015fu olan \u00fcnvanlar \u00ab:\u00bb i\u015far\u0259si il\u0259, qon\u015fu olmayan \u00fcnvanlar is\u0259 \u00ab,\u00bb i\u015far\u0259si il\u0259 ayr\u0131l\u0131r. Bu c\u0259dv\u0259li yarad\u0131n v\u0259 d\u00fcsturu daxil edib n\u0259tic\u0259ni yoxlay\u0131n; bu r\u0259q\u0259ml\u0259rin c\u0259mi 298 b\u0259rab\u0259r olmal\u0131d\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"48\" height=\"32\" class=\"wp-image-3429\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1036.jpeg\" \/><\/p>\n<p>SUM funksiyas\u0131n\u0131 SUM d\u00fcym\u0259si il\u0259 daha tez daxil etm\u0259k olar. Bunu etm\u0259k \u00fc\u00e7\u00fcn diapazonu se\u00e7in v\u0259 AutoSum d\u00fcym\u0259sini bas\u0131n.<\/p>\n<p><strong>D\u0259rs 6. Daha bir ne\u00e7\u0259 funksiya. &#8211; &#8212;<\/strong><\/p>\n<p>Funksiya yaz\u0131l\u0131\u015f\u0131n\u0131n \u00fcmumi qaydalar\u0131<\/p>\n<p>=_funksiyan\u0131n ad\u0131_(_i\u015f diapazonu_)_<\/p>\n<p>Yaz\u0131l\u0131\u015f\u0131 buna ox\u015far olan bir ne\u00e7\u0259 \u0259lav\u0259 funksiyalar:<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u018fm\u0259liyyat<\/td>\n<td><\/td>\n<td>Funksiyan\u0131n ad\u0131<\/td>\n<td>N\u00fcmun\u0259<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Orta c\u0259min<\/td>\n<td><\/td>\n<td>AVERAGE<\/td>\n<td>=AVERAGE(C1:C2)<\/td>\n<\/tr>\n<tr>\n<td>hesablanmas\u0131<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Maksimum r\u0259q\u0259min<\/td>\n<td><\/td>\n<td>MAX<\/td>\n<td>=MAX(C1:D5)<\/td>\n<\/tr>\n<tr>\n<td>tap\u0131lmas\u0131<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Minimum r\u0259q\u0259min<\/td>\n<td><\/td>\n<td>MIN<\/td>\n<td>=MIN(C1:D5)<\/td>\n<\/tr>\n<tr>\n<td>tap\u0131lmas\u0131<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Diapazonda olan<\/td>\n<td><\/td>\n<td>COUNT<\/td>\n<td>=COUNT(C1:D5)<\/td>\n<\/tr>\n<tr>\n<td>r\u0259q\u0259ml\u0259rin say\u0131<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Excel\u2019in fuksiyalar\u0131n\u0131n say\u0131 300 yax\u0131nd\u0131 v\u0259 biz yaln\u0131z \u0259saslar\u0131 il\u0259 i\u015fl\u0259y\u0259c\u0259yik<\/p>\n<p>G\u0259lin yaratd\u0131\u011f\u0131m\u0131z c\u0259dv\u0259ld\u0259n orta \u0259m\u0259k haqq\u0131 m\u00fc\u0259yy\u0259n ed\u0259k \/ A\u015fa\u011f\u0131dak\u0131 \u0259m\u0259liyyatlar\u0131 ard\u0131c\u0131l yerin\u0259 yetirin.<\/p>\n<ol>\n<li>A14 \u00fcnvan\u0131na \u00ab orta \u0259m\u0259k haqq\u0131\u00bb daxil edin<\/li>\n<li>V14 bu d\u00fcsturu yaz\u0131n =AVERAGE(C3:C12)<\/li>\n<li>Enter d\u00fcym\u0259sini bas\u0131n.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"157\" class=\"wp-image-3430\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1037.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1037.jpeg 393w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1037-300x120.jpeg 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/p>\n<p>M\u00fcxt\u0259lif ard\u0131c\u0131ll\u0131qlar yaratmaq \u00fc\u00e7\u00fcn Excel\u2019in bir ne\u00e7\u0259 avtomatik imkanlar\u0131 var. M\u0259s., n\u00f6mr\u0259l\u0259nm\u0259 \u00fc\u00e7\u00fcn 1,2,3,4,\u2026 s\u0131ras\u0131n\u0131 avtomatik olaraq yaratmaq \u00fc\u00e7\u00fcn sad\u0259c\u0259 olaraq 1 v\u0259 sonra 2 r\u0259q\u0259mini daxil edin, sonra h\u0259r ikisini se\u00e7in v\u0259 ard\u0131c\u0131l k\u00f6\u00e7\u00fcrd\u00fcn. M\u0259\u015fq etm\u0259k \u00fc\u00e7\u00fcn bizim c\u0259dv\u0259l\u0259 bir s\u00fctun \u0259lav\u0259 edin v\u0259 orada adlara m\u00fcvafiq n\u00f6mr\u0259l\u0259nm\u0259 d\u00fcz\u0259ldin. Ard\u0131c\u0131ll\u0131qlar yaratmaq \u00fc\u00e7\u00fcn Edit men\u00fcusunda olan Fill&gt;Series p\u0259nc\u0259r\u0259si istifad\u0259 olunur.<\/p>\n<p>Ard\u0131c\u0131ll\u0131\u011f\u0131n birinci \u00fczv\u00fcn\u00fc daxil etdikd\u0259n sonra Edit menyusundan olan Fill&gt;Series se\u00e7in. Ard\u0131c\u0131ll\u0131\u011f\u0131n s\u00fctun v\u0259 ya s\u0259tirl\u0259r \u00fczr\u0259 d\u00fcz\u00fclm\u0259sini Series In hi\u0259ss\u0259sind\u0259n se\u00e7in. Type hiss\u0259sind\u0259 ard\u0131c\u0131ll\u0131\u011f\u0131n n\u00f6v\u00fcn\u00fc se\u00e7in.<\/p>\n<p>N\u00fcmun\u0259l\u0259r:<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Linear<\/td>\n<td>Sad\u0259<\/td>\n<td>1,2,3,4,5 v\u0259 ya 2,4,6,8<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Growth<\/td>\n<td>H\u0259nd\u0259si<\/td>\n<td>2,4,8,16,32,64,128\u2026<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Date<\/td>\n<td>Tarix<\/td>\n<td>1\/1\/99,2\/1\/99,3\/1\/99\u2026<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Autofill<\/td>\n<td>Avtomatik<\/td>\n<td>1,2,1,2,1,2,1,2,1,2,\u2026<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Step value s\u0259trind\u0259 ard\u0131c\u0131ll\u0131\u011f\u0131n add\u0131m\u0131n\u0131 daxil edin, Stop value s\u0259trind\u0259 ax\u0131r \u00fczv\u00fc daxil ed\u0259 bil\u0259rsiz.<\/p>\n<p>Tarix n\u00f6vl\u00fc ard\u0131c\u0131ll\u0131qdan istifad\u0259 etdikd\u0259 Date Unit siyah\u0131s\u0131nda olan Workday variant\u0131n\u0131 se\u00e7s\u0259z tarix n\u00f6vl\u00fc ard\u0131c\u0131ll\u0131qdan istirah\u0259t g\u00fcnl\u0259ri avtomatik olaraq xaric edil\u0259c\u0259k.<\/p>\n<p><strong>Avtomatik hesablama zonas\u0131.<\/strong><\/p>\n<p>Bir diapazonu se\u00e7dikd\u0259 h\u0259min diapazonun c\u0259mi p\u0259nc\u0259r\u0259nin a\u015fa\u011f\u0131 hiss\u0259sind\u0259 d\u0259rhal yaz\u0131l\u0131r. Bu veril\u0259nl\u0259ri biz ancaq g\u00f6r\u0259 bilirik v\u0259 istifad\u0259 ed\u0259 bilm\u0259rik.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"522\" height=\"248\" class=\"wp-image-3431\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1038.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1038.jpeg 522w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1038-300x143.jpeg 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/p>\n<p>\u015e\u0259kild\u0259 g\u00f6rd\u00fcy\u00fcn\u00fcz AutoCalculate zonas\u0131nda sa\u011f d\u00fcym\u0259ni basaraq orada i\u015fl\u0259y\u0259n aktiv funksiyan\u0131 d\u0259yi\u015fm\u0259k m\u00fcmk\u00fcnd\u00fc.<\/p>\n<p><strong>D\u0259rs 7. C\u0259dv\u0259lin d\u00fczl\u0259nm\u0259si. &#8211; &#8212;<\/strong><\/p>\n<p>B\u0259&#8217;z\u0259n c\u0259dv\u0259li h\u0259r hans\u0131 bir amil il\u0259 d\u00fczl\u0259ndirm\u0259k laz\u0131m olur. M\u0259s., c\u0259dv\u0259ld\u0259 olan ad v\u0259 soyadlar\u0131n\u0131n \u0259lifba s\u0131ras\u0131 il\u0259, v\u0259 ya \u0259m\u0259k haqq\u0131n\u0131n ki\u00e7ikd\u0259n b\u00f6y\u00fcy\u0259 v\u0259 s.Bunu iki \u00fcsul il\u0259 etm\u0259k olar. M\u0259s\u0259l\u0259n bir veril\u0259nl\u0259r s\u0131ras\u0131n\u0131 ba\u015fqa m\u00fcvafiq s\u0131ralar\u0131 d\u0259yi\u015fm\u0259d\u0259n d\u00fczl\u0259ndirm\u0259k \u00fc\u00e7\u00fcn Sort d\u00fcym\u0259l\u0259rind\u0259n istifad\u0259 etm\u0259k olar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"55\" height=\"37\" class=\"wp-image-3432\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1039.jpeg\" \/><\/p>\n<p>Sad\u0259c\u0259 olaraq diapazonu se\u00e7ib d\u00fcym\u0259l\u0259rd\u0259n birini basmaq kifay\u0259tdir.<\/p>\n<p>D\u00fczl\u0259nm\u0259ni b\u00fct\u00fcn c\u0259dv\u0259l il\u0259 etm\u0259k \u00fc\u00e7\u00fcn Data menyusunda olan Sort \u0259mri istifad\u0259 olunur. M\u00fctl\u0259q olaraq b\u00fct\u00fcn c\u0259dv\u0259li se\u00e7in v\u0259 Data&gt;Sort se\u00e7in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"273\" height=\"284\" class=\"wp-image-3433\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1040.jpeg\" \/><\/p>\n<p>Burada Sort By s\u0259trind\u0259 c\u0259dv\u0259l ba\u015fl\u0131qlar\u0131ndan biri g\u00f6st\u0259rilm\u0259lidir.Orada ba\u015fqa m\u0259lumat\u0131<\/p>\n<p>g\u00f6rs\u0259z p\u0259nc\u0259r\u0259nin a\u015fa\u011f\u0131 hiss\u0259sind\u0259 olan My List has variantlar\u0131ndan Header Row se\u00e7in,<\/p>\n<p>bu \u0259m\u0259liyyat da g\u00f6m\u0259k etm\u0259s\u0259 c\u0259dv\u0259li yenid\u0259n se\u00e7m\u0259lisiniz (bu d\u0259f\u0259 d\u00fczg\u00fcn<\/p>\n<p>se\u00e7in).Burada g\u00f6rd\u00fcy\u00fcn\u00fcz Ascending variant\u0131 m\u0259tn \u00fc\u00e7\u00fcn A-dan \u018f-h\u0259rfin\u0259 (A-Z) r\u0259q\u0259ml\u0259r<\/p>\n<p>\u00fc\u00e7\u00fcn is\u0259 0-dan b\u00f6y\u00fck r\u0259q\u0259m\u0259 d\u00fczl\u0259ndirir, Descending variant\u0131 is\u0259 \u0259ksin\u0259.i\u015fl\u0259yir.<\/p>\n<p>\u00dcnvanlara k\u00f6m\u0259k\u00e7i m\u0259lumatlar.(Comments)<\/p>\n<p>Kifay\u0259t q\u0259d\u0259r yer olmad\u0131\u011f\u0131na g\u00f6r\u0259 v\u0259 ya ba\u015fqa s\u0259b\u0259bl\u0259r\u0259 g\u00f6r\u0259 ba\u015fl\u0131qda yaz\u0131lan m\u0259lumat b\u0259&#8217;z\u0259n laz\u0131m olan q\u0259d\u0259r dol\u011fun yaz\u0131lm\u0131r. Buna g\u00f6r\u0259 d\u0259 h\u0259min ba\u015fl\u0131qlara k\u00f6m\u0259k\u00e7i m\u0259lumatlar \u0259lav\u0259 etm\u0259k m\u0259qs\u0259d\u0259 uy\u011fun olar.<\/p>\n<ol>\n<li>K\u00f6m\u0259k\u00e7i m\u0259lumatlar \u0259lav\u0259 etm\u0259k ist\u0259diyiniz \u00fcnvan\u0131 se\u00e7in<\/li>\n<li>Insert menyusundan Comments se\u00e7in.<\/li>\n<li>M\u0259lumat\u0131 daxil edin, laz\u0131m olan \u015frifti se\u00e7in, r\u0259ngi se\u00e7in v\u0259 s.<\/li>\n<li>Ba\u015fqa bir yerd\u0259 mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n .<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"299\" height=\"107\" class=\"wp-image-3434\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1041.jpeg\" \/><\/p>\n<p>K\u00f6m\u0259k\u00e7i m\u0259lumatlar \u0259lav\u0259 etdiyniz \u00fcnvan\u0131n yuxar\u0131 sa\u011f k\u00fcnc\u00fc q\u0131rm\u0131z\u0131 r\u0259ngl\u0259 i\u015far\u0259 olunur v\u0259 mausun oxunu yax\u0131nla\u015fd\u0131rd\u0131qda k\u00f6m\u0259k\u00e7i m\u0259lumat\u0131 g\u00f6r\u0259 bil\u0259rsiniz.<\/p>\n<p>K\u00f6m\u0259k\u00e7i m\u0259lumatlar\u0131 silm\u0259k \u00fc\u00e7\u00fcn:<\/p>\n<ol>\n<li>K\u00f6m\u0259k\u00e7i m\u0259lumatlar \u0259lav\u0259 etdiyiniz \u00fcnvan\u0131 se\u00e7in<\/li>\n<li>\u00dcz\u0259rind\u0259 mausun sa\u011f d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n<\/li>\n<li>Delete Comments se\u00e7in.<\/li>\n<\/ol>\n<p>K\u00f6m\u0259k\u00e7i m\u0259lumatlar\u0131n m\u0259zmununu d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn \u00fc\u00e7\u00fcn:<\/p>\n<ol>\n<li>K\u00f6m\u0259k\u00e7i m\u0259lumatlar \u0259lav\u0259 etdiyiniz \u00fcnvan\u0131 se\u00e7in<\/li>\n<li>\u00dcz\u0259rind\u0259 mausun sa\u011f d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n<\/li>\n<li>Edit Comments se\u00e7in.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"209\" height=\"292\" class=\"wp-image-3435\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1042.jpeg\" \/><\/p>\n<p><strong>D\u0259rs 8. Diaqram. &#8211; &#8212;<\/strong><\/p>\n<p>Veril\u0259nl\u0259ri diaqram (qrafik) \u015f\u0259kilind\u0259 t\u0259svir etm\u0259k tez-tez laz\u0131m olur. M\u0259s\u0259l\u0259n a\u015fa\u011f\u0131da g\u00f6rd\u00fcy\u00fcn\u00fcz diaqram biz yaratd\u0131\u011f\u0131m\u0131z c\u0259dv\u0259ld\u0259n<\/p>\n<p>yarad\u0131l\u0131b. <img loading=\"lazy\" decoding=\"async\" width=\"309\" height=\"234\" class=\"wp-image-3436\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1043.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1043.jpeg 309w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1043-300x227.jpeg 300w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/p>\n<p>Bel\u0259 bir diaqram yaratmaq \u00fc\u00e7\u00fcn Chart Wizard dan istifad\u0259 edirik.<\/p>\n<p>C\u0259dv\u0259lin ad v\u0259 soyadlar yerl\u0259\u015f\u0259n diapazonunu se\u00e7irik. Sonra Ctrl d\u00fcym\u0259sini bas\u0131l\u0131 saxlayaraq \u0259m\u0259k haqq\u0131 s\u00fctununu se\u00e7irik. Insert menyusundan Chart se\u00e7irik v\u0259 ya Chart Wizard d\u00fcym\u0259sini bas\u0131r\u0131q.Bunu etdikd\u0259n sonra Chart Wizard proqram\u0131 i\u015f\u0259 d\u00fc\u015f\u00fcr. Bu proqram\u0131n birinci sual\u0131 diaqram\u0131n n\u00f6v\u00fcn\u0259 aid olacaq.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"324\" class=\"wp-image-3437\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1044.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1044.jpeg 190w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1044-176x300.jpeg 176w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/p>\n<p>Diaqram n\u00f6v\u00fcn\u00fc se\u00e7\u0259r\u0259k Press and hold to view sample d\u00fcym\u0259si il\u0259 c\u0259dv\u0259liniz\u0259 t\u0259dbiq olunmu\u015f diaqrama baxa bil\u0259rsiz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"407\" class=\"wp-image-3438\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1045.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1045.jpeg 416w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1045-300x294.jpeg 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/p>\n<p>Laz\u0131m olan n\u00f6v\u00fc se\u00e7dikd\u0259n sonra Next d\u00fcym\u0259sini bas\u0131n. \u0130kinci a\u00e7\u0131lan p\u0259nc\u0259r\u0259d\u0259 Data Range s\u0259trind\u0259 se\u00e7diyiniz diapazonu yoxlay\u0131n, s\u0259hf olars\u0259 \u0259m\u0259liyyat\u0131 yenid\u0259n yerir\u0259 yetirin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"195\" class=\"wp-image-3439\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1046.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1046.jpeg 400w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1046-300x146.jpeg 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<p>\u00dc\u00e7\u00fcnc\u00fc add\u0131mda diaqrama ba\u015fl\u0131q ver\u0259 bil\u0259rsiz. \u015eriftin i\u015fl\u0259m\u0259m\u0259yin\u0259 narahat olmay\u0131n \u2013 onu sonradan d\u0259yi\u015f\u0259rik.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"315\" class=\"wp-image-3440\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1047.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1047.jpeg 477w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1047-300x198.jpeg 300w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/p>\n<p>V\u0259 n\u0259hay\u0259t ax\u0131r\u0131nc\u0131 add\u0131mda diaqram\u0131n ayr\u0131ca s\u0259hif\u0259d\u0259 (As new sheet) v\u0259 ya \u0259sas c\u0259dv\u0259lin yan\u0131nda (As object in) yerl\u0259\u015fm\u0259sini se\u00e7in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"192\" class=\"wp-image-3441\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1048.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1048.jpeg 445w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1048-300x129.jpeg 300w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/p>\n<p>Diaqram haz\u0131r olduqdan sonra onun \u00fcz\u0259rind\u0259 bir ne\u00e7\u0259 d\u0259yi\u015fiklik etm\u0259k laz\u0131md\u0131.<\/p>\n<ol>\n<li>Diaqram\u0131n \u00f6l\u00e7\u00fcs\u00fc \u015f\u0259kill\u0259rin \u00f6\u00e7\u00fcs\u00fc kimi d\u0259yi\u015filir<\/li>\n<li>\u015erifti d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn m\u0259tnin \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131n Format \u2026 se\u00e7in v\u0259 Font p\u0259nc\u0259r\u0259sind\u0259 \u015frifti d\u0259yi\u015fin<\/li>\n<\/ol>\n<p>3. .R\u0259ngi d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn m\u0259tnin \u00fcz\u0259rind\u0259 sa\u011f d\u00fcym\u0259ni bas\u0131n Format \u2026 se\u00e7in v\u0259 Pattern p\u0259nc\u0259r\u0259sind\u0259 Color siyah\u0131s\u0131nda r\u0259ngi d\u0259yi\u015fin<\/p>\n<p><strong>D\u0259rs 9. Avtomatik s\u00fczg\u0259c (AutoFilter) &#8211; &#8212;<\/strong><\/p>\n<p>C\u0259dv\u0259ld\u0259 olan m\u0259lumat\u0131 h\u0259r hans\u0131 bir parametr il\u0259 \u00abs\u00fczg\u0259cd\u0259n\u00bb ke\u00e7irm\u0259k tez-tez laz\u0131m olur. M\u0259s., c\u0259dv\u0259ld\u0259n \u0259m\u0259k haqq\u0131 100-d\u0259n yuxar\u0131 olan \u0259m\u0259kda\u015flar\u0131n siyah\u0131s\u0131 laz\u0131m ola bil\u0259r.<\/p>\n<p>Avtomatik s\u00fczg\u0259ci i\u015f\u0259 salmaq \u00fc\u00e7\u00fcn c\u0259dv\u0259lin ba\u015fl\u0131\u011flar s\u0259trini se\u00e7in (y\u0259ni \u00abAd\u0131, soyad\u0131\u2026\u00bb v\u0259 s.) v\u0259 sonra Data menyusundan Filter &gt;AutoFilter se\u00e7in. \u018fm\u0259liyyat d\u00fczg\u00fcn edilibs\u0259 ba\u015fl\u0131qlar\u0131n yan\u0131nda siyah\u0131 d\u00fcym\u0259l\u0259ri yaranmal\u0131d\u0131.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"107\" height=\"46\" class=\"wp-image-3442\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1049.jpeg\" \/><\/p>\n<p>H\u0259min d\u00fcym\u0259ni basd\u0131qda s\u00fctunda olan b\u00fct\u00fcn veril\u0259nl\u0259rin siyah\u0131s\u0131 \u00e7\u0131x\u0131r v\u0259 h\u0259min siyah\u0131dan bir s\u0259tri se\u00e7dikd\u0259 c\u0259dv\u0259ld\u0259 yaln\u0131z se\u00e7diyiniz r\u0259q\u0259m olan s\u0259tirl\u0259ri g\u00f6r\u0259c\u0259ksiz. M\u0259s.,\u0259m\u0259k haqq\u0131 siyah\u0131s\u0131ndan 100 se\u00e7\u0259nd\u0259 orada yaln\u0131z \u0259m\u0259k haqq\u0131100 olan s\u0259tirl\u0259ri g\u00f6r\u0259c\u0259ksiz.<\/p>\n<p>\u015e\u0259rt il\u0259 s\u00fczg\u0259c<\/p>\n<p>M\u0259s., c\u0259dv\u0259ld\u0259n \u0259m\u0259k haqq\u0131 100-d\u0259n yuxar\u0131 olan \u0259m\u0259kda\u015flar\u0131n siyah\u0131s\u0131n\u0131 se\u00e7\u0259k.<\/p>\n<ol>\n<li>Avtomatik s\u00fczg\u0259ci i\u015f\u0259 salmaq \u00fc\u00e7\u00fcn c\u0259dv\u0259lin ba\u015fl\u0131\u011f\u0131nda mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n sonra Data menyusundan Filter &gt;AutoFilter se\u00e7in.<\/li>\n<li>\u018fm\u0259k haqq\u0131 siyah\u0131s\u0131ndan (Custom \u2026)se\u00e7in.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"496\" height=\"191\" class=\"wp-image-3443\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1050.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1050.jpeg 496w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1050-300x116.jpeg 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/p>\n<ol>\n<li>Birinci siyah\u0131dan Is Greater Than (b\u00f6y\u00fckd\u00fc) \u015f\u0259rtini se\u00e7in.<\/li>\n<li>Sa\u011fda olan s\u0259tr\u0259 is\u0259 100 daxil edin.<\/li>\n<li>OK d\u00fcym\u0259sini bas\u0131n<\/li>\n<\/ol>\n<p>Tam c\u0259dv\u0259l\u0259 qay\u0131tmaq \u00fc\u00e7\u00fcn h\u0259min siyah\u0131dan (All) se\u00e7in.<\/p>\n<p>Birinci siyah\u0131dan Is Greater Than s\u0259tri \u015f\u0259rtl\u0259rd\u0259n biridi. Bu siyah\u0131da bir ne\u00e7\u0259 ba\u015fqa \u015f\u0259rt var :<\/p>\n<p>Equals \u2013 b\u0259rab\u0259rdi<\/p>\n<p>Does not equal \u2013 qeyrib\u0259rab\u0259rdi<\/p>\n<p>Is greater than \u2013 b\u00f6y\u00fckd\u00fc<\/p>\n<p>Is greater than or equal to \u2013 b\u00f6y\u00fck v\u0259 ya b\u0259rab\u0259rdi<\/p>\n<p>Is less than \u2013 ki\u00e7ikdi<\/p>\n<p>Is less than or equal to &#8211; ki\u00e7ik v\u0259 ya b\u0259rab\u0259rdi<\/p>\n<p>Birinci onluq<\/p>\n<p>S\u00fczg\u0259cin ba\u015fqa bir n\u00f6v\u00fc olan \u00abbirinci onluq\u00bb \u0259n b\u00f6y\u00fck v\u0259 ya \u0259n ki\u00e7ik 10 s\u0259tri se\u00e7m\u0259k \u00fc\u00e7\u00fcn istifad\u0259 olunur. S\u0259tirl\u0259rin say\u0131 10 deyil az v\u0259 ya \u00e7ox ola bil\u0259r. M\u0259s., \u0259n \u00e7ox \u0259m\u0259k haqq\u0131 alan 5 n\u0259f\u0259rin siyah\u0131s\u0131n\u0131 yaradaq.<\/p>\n<ol>\n<li>Avtomatik s\u00fczg\u0259ci i\u015f\u0259 salmaq \u00fc\u00e7\u00fcn c\u0259dv\u0259lin ba\u015fl\u0131\u011f\u0131nda mausun d\u00fcym\u0259sini bir d\u0259f\u0259 bas\u0131n sonra Data menyusundan Filter &gt;AutoFilter se\u00e7in.<\/li>\n<li>\u018fm\u0259k haqq\u0131 siyah\u0131s\u0131ndan (Top 10\u2026)se\u00e7in.<\/li>\n<li>Orta s\u0259tird\u0259 5 daxil edin v\u0259 OK bas\u0131n.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"432\" height=\"96\" class=\"wp-image-3444\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1051.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1051.jpeg 432w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1051-300x67.jpeg 300w\" sizes=\"auto, (max-width: 432px) 100vw, 432px\" \/><\/p>\n<p>AutoFilter\u2019d\u0259n \u00e7\u0131xmaq \u00fc\u00e7\u00fcn Data menyusundan Filter &gt;AutoFilter se\u00e7in.<\/p>\n<p><strong>D\u0259rs 10. C\u0259dv\u0259l formas\u0131. &#8211; &#8212;<\/strong><\/p>\n<p>Yaratd\u0131\u011f\u0131m\u0131z c\u0259dv\u0259li yeni m\u0259lumuatlarla doldurmaq b\u0259&#8217;zi \u00e7\u0259tinlikl\u0259r t\u00f6&#8217;r\u0259d\u0259 bil\u0259r. M\u0259s., \u00e7\u0259dv\u0259l \u00e7ox b\u00f6y\u00fck olarsa onun ax\u0131r\u0131nc\u0131 s\u0259trind\u0259 i\u015fl\u0259y\u0259n zaman ba\u015fl\u0131qlar g\u00f6r\u00fcnm\u00fcr. Ba\u015fl\u0131qlar\u0131 ekranda \u00abdondurmaq\u00bb da olur. Bunu etm\u0259k \u00fc\u00e7\u00fcn Window menyusundan Split se\u00e7in. Yaranan x\u0259ttl\u0259r il\u0259 ekran\u0131 ba\u015fl\u0131q v\u0259 m\u0259lumat hiss\u0259l\u0259rin\u0259 ay\u0131r\u0131n. Bunu etdikd\u0259n sonra Window menyusundan Freeze Panes se\u00e7in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"227\" height=\"312\" class=\"wp-image-3445\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1052.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1052.jpeg 227w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1052-218x300.jpeg 218w\" sizes=\"auto, (max-width: 227px) 100vw, 227px\" \/><\/p>\n<p>C\u0259dv\u0259l\u0259 yeni s\u0259tirl\u0259rin \u0259lav\u0259si \u00fc\u00e7\u00fcn, h\u0259m\u00e7inin c\u0259dv\u0259ld\u0259 axtar\u0131\u015f v\u0259 d\u0259yi\u015fiklik etm\u0259k \u00fc\u00e7\u00fcn Data Form p\u0259nc\u0259r\u0259sind\u0259n istifad\u0259 etm\u0259k olar. C\u0259dv\u0259li se\u00e7ib Data menyusundan Form se\u00e7in.<\/p>\n<p>S\u0259tirl\u0259r\u0259 bir-bir baxmaq \u00fc\u00e7\u00fcn Scroll d\u00fcym\u0259l\u0259rind\u0259n (\u00fcz\u0259rind\u0259 qara \u00fc\u00e7bucaqlar olan ki\u00e7ik d\u00fcym\u0259cikl\u0259r) istifad\u0259 edin.<\/p>\n<p>Yaz\u0131larda d\u0259yi\u015fiklik ed\u0259 bil\u0259rsiz; yaz\u0131lar\u0131 b\u0259rpa etm\u0259k \u00fc\u00e7\u00fcn Restore d\u00fcym\u0259sind\u0259n istifad\u0259 edin. S\u0259tri silm\u0259k \u00fc\u00e7\u00fcn Delete d\u00fcym\u0259sini bas\u0131n, bu \u0259m\u0259liyyat\u0131 geri qaytarmaq olmur, ehtiyatl\u0131 olun.<\/p>\n<p>Yeni s\u0259tir \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn New d\u00fcym\u0259sini bas\u0131n v\u0259 m\u0259lumat\u0131 daxil edin.<\/p>\n<p>Criteria d\u00fcym\u0259si yaz\u0131lar \u00fczr\u0259 s\u0259tir axtar\u0131\u015f\u0131 etm\u0259k \u00fc\u00e7\u00fcn isifad\u0259 olunur. D\u00fcym\u0259ni bas\u0131n v\u0259 axtar\u0131\u015f \u015f\u0259rtini daxil edin. M\u0259s., \u0259m\u0259k haqq\u0131 s\u0259trind\u0259 &lt;200, v\u0259 ya =200, yaxud &gt;=150 daxil edin. Bunu etdikd\u0259n sonra Find Next v\u0259 ya Find Prev d\u00fcym\u0259l\u0259ri il\u0259 h\u0259min s\u0259tirl\u0259r\u0259 baxa bil\u0259rsiniz.<\/p>\n<p>M\u0259tnin bir ne\u00e7\u0259 s\u00fctunlara ayr\u0131lmas\u0131.<\/p>\n<p><strong>D\u0259rs 11. Adlar il\u0259 hesablamalar. &#8211; &#8212;<\/strong><\/p>\n<p>Yaratd\u0131q\u0131m\u0131z c\u0259dv\u0259ld\u0259 \u0259m\u0259k haqq\u0131n\u0131n dollar il\u0259 olma\u011f\u0131n\u0131 t\u0259s\u0259vv\u00fcr edin. M\u0259s., h\u0259min dollar il\u0259 olan m\u0259bl\u0259\u011fl\u0259ri manat ekvivalentin\u0259 \u00e7evirm\u0259k laz\u0131md\u0131r.<\/p>\n<p>\u00ab\u018fm\u0259k haqq\u0131\u00bb s\u00fctunundan sonra yeni s\u00fctun \u0259lav\u0259 edin v\u0259 onu \u00abManat il\u0259\u00bb adland\u0131r\u0131n. Bu s\u00fctunda dollar il\u0259 olan m\u0259bl\u0259\u011fi manata \u00e7evir\u0259n d\u00fcstur daxil olunmal\u0131d\u0131. D\u00fcstur \u00e7ox sad\u0259dir: m\u0259bl\u0259\u011fi dollar\u0131n m\u0259z\u0259nn\u0259sin\u0259 (kursuna) vurmaq laz\u0131md\u0131. Y\u0259ni orada bel\u0259 bir d\u00fcstur yazmaq olar:<\/p>\n<p>=C3*4180<\/p>\n<p>Bu d\u00fcsturda C3- \u0259m\u0259k haqq\u0131 m\u0259bl\u0259\u011fi , 4180 is\u0259 m\u0259z\u0259nn\u0259dir. \u018flb\u0259tt\u0259 ki, bu r\u0259q\u0259m h\u0259r g\u00fcn d\u0259yi\u015fil\u0259 bil\u0259r (v\u0259 d\u0259yi\u015filir), ona g\u00f6r\u0259 d\u0259 d\u00fcsturu h\u0259r d\u0259f\u0259 d\u0259yi\u015fm\u0259k laz\u0131m olur. Bu \u0259m\u0259liyyat\u0131 sad\u0259l\u0259\u015fdirm\u0259k \u00fc\u00e7\u00fcn dollar m\u0259z\u0259nn\u0259sini ayr\u0131ca bir \u00fcnvanda yaz\u0131b onu d\u00fcsturda istifad\u0259 etm\u0259k olar. Bunu etm\u0259k \u00fc\u00e7\u00fcn ba\u015fqa bir s\u0259hif\u0259y\u0259 ke\u00e7in v\u0259 A1 \u00fcnvan\u0131n\u0131da dollar\u0131n m\u0259z\u0259nn\u0259sini daxil edin. Sonra h\u0259min \u00fcnvana ad verm\u0259k laz\u0131md\u0131r (bu ad\u0131 biz g\u0259l\u0259c\u0259k d\u00fcsturlarda istifad\u0259 ed\u0259c\u0259yik). Ad verm\u0259k \u00fc\u00e7\u00fcn Insert menyusundan Name &gt;Define se\u00e7irik.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"404\" height=\"246\" class=\"wp-image-3446\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1053.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1053.jpeg 404w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1053-300x183.jpeg 300w\" sizes=\"auto, (max-width: 404px) 100vw, 404px\" \/><\/p>\n<p>Names in workbook s\u0259trind\u0259 ad\u0131 daxil edib OK d\u00fcym\u0259sini bas\u0131r\u0131q. Adlar\u0131n yaz\u0131l\u0131\u015f qaydalar\u0131 bel\u0259dir ki, real \u00fcnvan\u0131n ad\u0131na ox\u015famas\u0131n v\u0259 r\u0259q\u0259ml\u0259rd\u0259n ibar\u0259t olmas\u0131n, ad iki s\u00f6zd\u0259n ibar\u0259t olsa aras\u0131 bo\u015f olmamal\u0131d\u0131, m\u0259s. \u00ab_\u00bb i\u015far\u0259si qoyulmal\u0131d\u0131.<\/p>\n<p>Define Name p\u0259nc\u0259r\u0259si adlar\u0131 silm\u0259k \u00fc\u00e7\u00fcn d\u0259 istifad\u0259 olunur (Delete d\u00fcym\u0259si).<\/p>\n<p>Ad qoyduqdan sonra \u0259sas c\u0259dv\u0259lin \u00abManat il\u0259\u00bb s\u00fctununda olan d\u00fcsturu a\u015fa\u011f\u0131dak\u0131 il\u0259 \u0259v\u0259z edirik.<\/p>\n<p>=C3*dollar<\/p>\n<p>\u0130ndi dollar\u0131n m\u0259z\u0259nn\u0259sini d\u0259yi\u015fdikd\u0259 bu d\u00fcsturun n\u0259tic\u0259si d\u0259 avtomatik olaraq d\u0259yi\u015fir.<\/p>\n<p><strong>D\u0259rs 12.IF funksiyas\u0131. &#8211; &#8212;<\/strong><\/p>\n<p>\u018fm\u0259k haqq\u0131n\u0131n vergisini hesablamaq \u00fc\u00e7\u00fcn IF funksiyas\u0131ndan istifad\u0259 etm\u0259liyik.<\/p>\n<p>IF funksiyas\u0131 h\u0259r hans\u0131 bir \u015f\u0259rt\u0259 \u0259saslanaraq \u015f\u0259rt d\u00fcz olarsa bir, s\u0259hf olarsa ba\u015fqa bir \u0259m\u0259liyyat\u0131 yerin\u0259 yetirir.<\/p>\n<p>M\u0259s\u0259l\u0259n, A1 \u00fcnvan\u0131nda 1 v\u0259 ya 2 yaz\u0131la bil\u0259r. A2 \u00fcnvan\u0131nda is\u0259 A1 d\u0259 1 olarsa \u00abone\u00bb 2 olarsa \u00abtwo\u00bb yaz\u0131lmal\u0131d\u0131r. A2 \u00fcnvan\u0131nda bel\u0259 bir d\u00fcstur yaz\u0131l\u0131r:<\/p>\n<p>=IF(A1=1,&#8221;one&#8221;,&#8221;two&#8221;)<\/p>\n<p>\u0130kinci \u0259m\u0259liyyat\u0131n yerin\u0259 yenid\u0259n IF funksiyas\u0131ndan istifad\u0259 etm\u0259k olar m\u0259s.:<\/p>\n<p>=IF(A1=1,&#8221;one&#8221;, IF(A1=2,&#8221;two&#8221;,IF(A1=3\\,&#8221;three)))<\/p>\n<p>IF funsiyas\u0131n\u0131n daxilind\u0259 9-a q\u0259d\u0259r IF funksiyas\u0131ndan istifad\u0259 etm\u0259k olar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"528\" height=\"123\" class=\"wp-image-3447\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1054.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1054.jpeg 528w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1054-300x70.jpeg 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/p>\n<p>\u018fm\u0259k haqq\u0131 vergisi a\u015fa\u011f\u0131dak\u0131 qaydalar il\u0259 hesablan\u0131r.<\/p>\n<table>\n<tbody>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>\u015e\u0259rt*<\/td>\n<td colspan=\"2\">Vergi<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td colspan=\"2\"><\/td>\n<\/tr>\n<tr>\n<td>100000-d\u0259n az<\/td>\n<td colspan=\"2\">Hesablanm\u0131r (0)<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>100001-d\u0259n 600000-d\u0259k<\/td>\n<td>12%<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>600001-d\u0259n 1400000-d\u0259k<\/td>\n<td>20%<\/td>\n<td>+ 60000<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>1400000-d\u0259n 3000000-d\u0259k<\/td>\n<td>25%<\/td>\n<td>+ 220000<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>3000001-d\u0259n 5000000-d\u0259k<\/td>\n<td>30%<\/td>\n<td>+ 620000<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>5000000-d\u0259n yuxar\u0131<\/td>\n<td>35%<\/td>\n<td>+ 1220000<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>* Yaln\u0131z n\u00fcmun\u0259<\/p>\n<p><strong>=IF(E3&lt;10000,0,IF(E3&lt;600000,E3*12%,IF(E3&lt;1400000,E3*20%+60000,IF(E3&lt;300000 0,E3*25%+220000,IF(E3&lt;5000000,E3* 30%+620000,E3*35%+1220000)))))<\/strong><\/p>\n<p><strong>D\u0259rs 13. C\u0259dv\u0259lin \u00e7ap\u0131. &#8211; &#8212;<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"34\" height=\"34\" class=\"wp-image-3448\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1055.jpeg\" \/><\/p>\n<p>Word proqram\u0131ndan f\u0259rqli olaraq Excel in c\u0259dv\u0259li ekranda g\u00f6r\u00fcnd\u00fcy\u00fc kimi \u00e7ap edilmir. Bunu g\u00f6rm\u0259k \u00fc\u00e7\u00fcn x\u00fcsusi \u00e7apdan\u0259vv\u0259lki bax\u0131\u015f rejimin\u0259 ke\u00e7m\u0259k laz\u0131md\u0131r. File menyusundan Print Preview se\u00e7in v\u0259 ya Print Preview d\u00fcym\u0259sini bas\u0131n. Bunu etdikd\u0259n sonra g\u00f6rd\u00fcy\u00fcn\u00fcz \u015f\u0259kil c\u0259dv\u0259lin ka\u011f\u0131zda g\u0259l\u0259c\u0259k g\u00f6r\u00fcn\u00fc\u015f\u00fcn\u00fc \u0259ks etdirir. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, c\u0259dv\u0259lin boz r\u0259ngd\u0259 olan \u00e7\u0259r\u00e7iv\u0259l\u0259ri ka\u011f\u0131za \u00e7ap olunmur, ona g\u00f6r\u0259d\u0259 c\u0259dv\u0259lin \u00e7\u0259r\u00e7iv\u0259sini qurmaq \u00fc\u00e7\u00fcn m\u00fctl\u0259q borders d\u00fcym\u0259sind\u0259n istfad\u0259 edin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"46\" height=\"39\" class=\"wp-image-3449\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1056.jpeg\" \/><\/p>\n<p>Print Preview rejimind\u0259 \u00e7apa aid m\u00fcxt\u0259lif \u0259m\u0259liyyatlar ed\u0259 bil\u0259rik.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"282\" height=\"212\" class=\"wp-image-3450\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1057.jpeg\" \/><\/p>\n<p>Next d\u00fcym\u0259si n\u00f6vb\u0259ti s\u0259hif\u0259y\u0259 ke\u00e7m\u0259k \u00fc\u00e7\u00fcn Previous \u0259vv\u0259lki s\u0259hif\u0259y\u0259 ke\u00e7m\u0259k \u00fc\u00e7\u00fcn<\/p>\n<p>Zoom g\u00f6r\u00fcn\u00fc\u015f\u00fcn miqyas\u0131n\u0131 art\u0131r\u0131r\/azald\u0131r. Print d\u00fcym\u0259si c\u0259dv\u0259li \u00e7apa verir.<\/p>\n<p>Setup bir ne\u00e7\u0259 parametri d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"360\" class=\"wp-image-3451\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1058.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1058.jpeg 468w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1058-300x231.jpeg 300w\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" \/><\/p>\n<p>Setup p\u0259nc\u0259r\u0259sinin Page hiss\u0259sind\u0259<\/p>\n<ol>\n<li>Orientation- S\u0259hif\u0259ni eni v\u0259 ya uzunlu\u011fu \u00fczr\u0259 yerl\u0259\u015fdirm\u0259k olar (Portrait v\u0259 ya Lanscape).<\/li>\n<li>Scaling- c\u0259dv\u0259lin \u00e7ap miqyas\u0131n\u0131 d\u0259yi\u015fir.<\/li>\n<li>Paper Size- \u00c7ap qur\u011fusunun ka\u011f\u0131z format\u0131n\u0131 d\u0259yi\u015fm\u0259k olar.(ad\u0259t\u0259n A4 format\u0131 istifad\u0259 olunur).<\/li>\n<li>Print Quality- \u00c7ap keyfiyy\u0259tini d\u0259yi\u015fm\u0259k olar.<\/li>\n<\/ol>\n<p>Setup p\u0259nc\u0259r\u0259sinin Margins hiss\u0259sind\u0259<\/p>\n<ol>\n<li>S\u0259hif\u0259nin k\u0259narlar\u0131nda bo\u015f yer qoymaq olar.( Top &#8211; yuxar\u0131dan, Bottom &#8211; a\u015fa\u011f\u0131dan,Right- sa\u011fdan,Left &#8211; soldan)<\/li>\n<li>C\u0259dv\u0259li s\u0259hif\u0259 \u00fcz\u0259rind\u0259 m\u0259rk\u0259zl\u0259\u015fdirm\u0259k (horizontal v\u0259 vertikal)<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"201\" height=\"52\" class=\"wp-image-3452\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1059.jpeg\" \/><\/p>\n<p>Setup p\u0259nc\u0259r\u0259sinin Header\/Footer hiss\u0259sind\u0259 s\u0259hif\u0259nin yuxar\u0131 v\u0259 a\u015fa\u011f\u0131 hiss\u0259sind\u0259 m\u00fcxt\u0259lif \u0259lav\u0259 m\u0259lumat \u0259ks etdirm\u0259k olar. Header v\u0259 Footer siyah\u0131lar\u0131nda standart m\u0259lumatlardan se\u00e7m\u0259k olar, v\u0259 ya. Custom Header v\u0259 Custom Footer d\u00fcym\u0259l\u0259ri il\u0259 yenisini yaratmaq olar:<\/p>\n<p>Yeni Header yaradanda \u0259lav\u0259 m\u0259lumat\u0131 soldan, sa\u011fdan v\u0259 m\u0259rk\u0259zd\u0259n yerl\u0259\u015fdirm\u0259k olar, bunu p\u0259nc\u0259r\u0259d\u0259 olan Left, Right, Center hiss\u0259l\u0259rini se\u00e7m\u0259kl\u0259 bildirm\u0259k laz\u0131md\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"238\" class=\"wp-image-3453\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1060.jpeg\" srcset=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1060.jpeg 605w, https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1060-300x118.jpeg 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>Burada siz ist\u0259diyiniz m\u0259tn daxil ed\u0259 bil\u0259rsiz, m\u0259tnin \u015friftini x\u00fcsusi Font d\u00fcym\u0259si d\u0259yi\u015fir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"49\" height=\"50\" class=\"wp-image-3454\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1061.jpeg\" \/><\/p>\n<p>Ba\u015fqa d\u00fcym\u0259l\u0259r:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"34\" height=\"33\" class=\"wp-image-3455\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1062.jpeg\" \/> S\u0259hif\u0259nin n\u00f6mr\u0259si<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"37\" height=\"35\" class=\"wp-image-3456\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1063.jpeg\" \/> S\u0259hif\u0259l\u0259rin say\u0131<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"34\" height=\"34\" class=\"wp-image-3457\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1064.jpeg\" \/> \u00c7ap olundu\u011fu tarix<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"36\" height=\"32\" class=\"wp-image-3458\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1065.jpeg\" \/> \u00c7ap olundu\u011fu vaxt<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"35\" height=\"31\" class=\"wp-image-3459\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1066.jpeg\" \/> S\u0259n\u0259din ad\u0131<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"38\" height=\"34\" class=\"wp-image-3460\" src=\"http:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/word-image-1067.jpeg\" \/> S\u0259hif\u0259nin ad\u0131.<\/p>\n<p>Daxil etdikd\u0259n sonra OK d\u00fcym\u0259sini bas\u0131n.<\/p>\n<p>Print Preview rejimind\u0259n \u00e7\u0131xmaq \u00fc\u00e7\u00fcn Close d\u00fcym\u0259sini bas\u0131n.<\/p>\n<p>&nbsp;<\/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=3400\"><\/div><div><a download=\"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik.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>Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik &nbsp; \u0130\u015f\u0259 ba\u015flamaq \u00fc\u00e7\u00fcn Start menyusunun Programs hiss\u0259sind\u0259n Microsoft Excel s\u0259trini se\u00e7in. Excel proqram\u0131n\u0131n p\u0259nc\u0259r\u0259sin\u0259 n\u0259z\u0259r yetir\u0259k. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi Excel\u2019in b\u0259zi d\u00fcym\u0259l\u0259ri ba\u015fqa proqramlar\u0131n\u0131n d\u00fcym\u0259l\u0259rin\u0259 b\u0259nz\u0259yir. Y\u0259ni, bu o dem\u0259kdir ki, ba\u015fqa proqramlar kimi \u00f6z s\u0259n\u0259dini Save d\u00fcym\u0259si il\u0259 yadda\u015fa verm\u0259y\u0259 imkan verir v\u0259 s. Birc\u0259 onu da qeyd etm\u0259k [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3461,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3400","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-komputerlr"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik - www.YUSIF.az<\/title>\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=3400\" \/>\n<meta property=\"og:locale\" content=\"az_AZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik - www.YUSIF.az\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik &nbsp; \u0130\u015f\u0259 ba\u015flamaq \u00fc\u00e7\u00fcn Start menyusunun Programs hiss\u0259sind\u0259n Microsoft Excel s\u0259trini se\u00e7in. Excel proqram\u0131n\u0131n p\u0259nc\u0259r\u0259sin\u0259 n\u0259z\u0259r yetir\u0259k. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi Excel\u2019in b\u0259zi d\u00fcym\u0259l\u0259ri ba\u015fqa proqramlar\u0131n\u0131n d\u00fcym\u0259l\u0259rin\u0259 b\u0259nz\u0259yir. Y\u0259ni, bu o dem\u0259kdir ki, ba\u015fqa proqramlar kimi \u00f6z s\u0259n\u0259dini Save d\u00fcym\u0259si il\u0259 yadda\u015fa verm\u0259y\u0259 imkan verir v\u0259 s. Birc\u0259 onu da qeyd etm\u0259k [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/yusif.az\/main\/?p=3400\" \/>\n<meta property=\"og:site_name\" content=\"www.YUSIF.az\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-17T13:29:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"474\" \/>\n\t<meta property=\"og:image:height\" content=\"455\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"29 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400\"},\"author\":{\"name\":\"auto61\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#\\\/schema\\\/person\\\/904da2c1a1bbe7e501df95c2bc38d146\"},\"headline\":\"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik\",\"datePublished\":\"2018-12-17T13:29:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400\"},\"wordCount\":5789,\"publisher\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#\\\/schema\\\/person\\\/904da2c1a1bbe7e501df95c2bc38d146\"},\"image\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg\",\"articleSection\":[\"M\u00dcXT\u018fL\u0130F \\\/ \u0130NFORMAT\u0130KA\"],\"inLanguage\":\"az\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400\",\"url\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400\",\"name\":\"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik - www.YUSIF.az\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg\",\"datePublished\":\"2018-12-17T13:29:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#breadcrumb\"},\"inLanguage\":\"az\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"az\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#primaryimage\",\"url\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg\",\"contentUrl\":\"https:\\\/\\\/yusif.az\\\/main\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg\",\"width\":474,\"height\":455},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/yusif.az\\\/main\\\/?p=3400#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/yusif.az\\\/main\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik\"}]},{\"@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":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik - www.YUSIF.az","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=3400","og_locale":"az_AZ","og_type":"article","og_title":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik - www.YUSIF.az","og_description":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik &nbsp; \u0130\u015f\u0259 ba\u015flamaq \u00fc\u00e7\u00fcn Start menyusunun Programs hiss\u0259sind\u0259n Microsoft Excel s\u0259trini se\u00e7in. Excel proqram\u0131n\u0131n p\u0259nc\u0259r\u0259sin\u0259 n\u0259z\u0259r yetir\u0259k. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi Excel\u2019in b\u0259zi d\u00fcym\u0259l\u0259ri ba\u015fqa proqramlar\u0131n\u0131n d\u00fcym\u0259l\u0259rin\u0259 b\u0259nz\u0259yir. Y\u0259ni, bu o dem\u0259kdir ki, ba\u015fqa proqramlar kimi \u00f6z s\u0259n\u0259dini Save d\u00fcym\u0259si il\u0259 yadda\u015fa verm\u0259y\u0259 imkan verir v\u0259 s. Birc\u0259 onu da qeyd etm\u0259k [&hellip;]","og_url":"https:\/\/yusif.az\/main\/?p=3400","og_site_name":"www.YUSIF.az","article_published_time":"2018-12-17T13:29:03+00:00","og_image":[{"width":474,"height":455,"url":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg","type":"image\/jpeg"}],"author":"auto61","twitter_card":"summary_large_image","twitter_misc":{"Written by":"auto61","Est. reading time":"29 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/yusif.az\/main\/?p=3400#article","isPartOf":{"@id":"https:\/\/yusif.az\/main\/?p=3400"},"author":{"name":"auto61","@id":"https:\/\/yusif.az\/main\/#\/schema\/person\/904da2c1a1bbe7e501df95c2bc38d146"},"headline":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik","datePublished":"2018-12-17T13:29:03+00:00","mainEntityOfPage":{"@id":"https:\/\/yusif.az\/main\/?p=3400"},"wordCount":5789,"publisher":{"@id":"https:\/\/yusif.az\/main\/#\/schema\/person\/904da2c1a1bbe7e501df95c2bc38d146"},"image":{"@id":"https:\/\/yusif.az\/main\/?p=3400#primaryimage"},"thumbnailUrl":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg","articleSection":["M\u00dcXT\u018fL\u0130F \/ \u0130NFORMAT\u0130KA"],"inLanguage":"az"},{"@type":"WebPage","@id":"https:\/\/yusif.az\/main\/?p=3400","url":"https:\/\/yusif.az\/main\/?p=3400","name":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik - www.YUSIF.az","isPartOf":{"@id":"https:\/\/yusif.az\/main\/#website"},"primaryImageOfPage":{"@id":"https:\/\/yusif.az\/main\/?p=3400#primaryimage"},"image":{"@id":"https:\/\/yusif.az\/main\/?p=3400#primaryimage"},"thumbnailUrl":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg","datePublished":"2018-12-17T13:29:03+00:00","breadcrumb":{"@id":"https:\/\/yusif.az\/main\/?p=3400#breadcrumb"},"inLanguage":"az","potentialAction":[{"@type":"ReadAction","target":["https:\/\/yusif.az\/main\/?p=3400"]}]},{"@type":"ImageObject","inLanguage":"az","@id":"https:\/\/yusif.az\/main\/?p=3400#primaryimage","url":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg","contentUrl":"https:\/\/yusif.az\/main\/wp-content\/uploads\/2018\/12\/ILFKd3MhpA_4sCtkDoAoKgHaHH.jpg","width":474,"height":455},{"@type":"BreadcrumbList","@id":"https:\/\/yusif.az\/main\/?p=3400#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/yusif.az\/main"},{"@type":"ListItem","position":2,"name":"Microsoft Excel proqram\u0131 \u00fczr\u0259 d\u0259rslik"}]},{"@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\/3400","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=3400"}],"version-history":[{"count":1,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/posts\/3400\/revisions"}],"predecessor-version":[{"id":3462,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/posts\/3400\/revisions\/3462"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=\/wp\/v2\/media\/3461"}],"wp:attachment":[{"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yusif.az\/main\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}