{"id":3563,"date":"2019-01-24T12:20:59","date_gmt":"2019-01-24T08:20:59","guid":{"rendered":"http:\/\/yusif.az\/main\/?p=3563"},"modified":"2019-01-24T12:33:14","modified_gmt":"2019-01-24T08:33:14","slug":"excel-programi","status":"publish","type":"post","link":"https:\/\/yusif.az\/main\/?p=3563","title":{"rendered":"Excel Program\u0131"},"content":{"rendered":"
\n

Excel p\u0259nc\u0259r\u0259sinin \u00fcmumi g\u00f6r\u00fcn\u00fc\u015f\u00fc.<\/h2>\n

Qar\u015f\u0131n\u0131zda Microsoft Excel proqram\u0131n\u0131n elektron c\u0259dv\u0259lidir. P\u0259nc\u0259r\u0259nin yuxar\u0131dak\u0131 s\u0259tri S\u0259rl\u00f6vh\u0259 s\u0259tri<\/strong> adlan\u0131r. Onun \u00fcz\u0259rind\u0259 ad\u0259t\u0259n redaktorun v\u0259 a\u00e7\u0131lm\u0131\u015f s\u0259n\u0259din ad\u0131 g\u00f6st\u0259rilir. S\u0259rl\u00f6vh\u0259 s\u0259trind\u0259n sonra ayr\u0131-ayr\u0131 menyu b\u00f6lm\u0259l\u0259rind\u0259n ibar\u0259t olan menyu s\u0259tri yerl\u0259\u015fir. H\u0259r bir menyu b\u00f6lm\u0259si Microsoft Excel proqram\u0131nda i\u015fl\u0259m\u0259k \u00fc\u00e7\u00fcn m\u00fc\u0259yy\u0259n \u0259mrl\u0259r toplusundan ibar\u0259tdir. Yerl\u0259\u015fdirm\u0259k<\/strong> (Insert)<\/em> menyusunun \u00fcz\u0259rind\u0259 mauzun sol d\u00fcym\u0259sini bas\u0131n. Bel\u0259likl\u0259, siz i\u015f\u00e7i kitb\u0131nda yerl\u0259\u015fdirm\u0259k \u00fc\u00e7\u00fcn m\u00fcxt\u0259lif obyektl\u0259rl\u0259 qar\u015f\u0131la\u015f\u0131rs\u0131n\u0131z, m\u0259s\u0259l\u0259n \u0130\u015f\u00e7i v\u0259r\u0259qi<\/strong> (work sheet)<\/strong>, Funksiya<\/strong> (funktion)<\/em>, Qrafik v\u0259 ya diaqram<\/strong> (chart)<\/em>. Ayr\u0131-ayr\u0131 b\u00f6lm\u0259l\u0259r altmenyulara apar\u0131r. M\u0259s\u0259l\u0259n, D\u00fcz\u0259li\u015f<\/strong> (Edit)<\/em> menyusunu a\u00e7\u0131n v\u0259 Doldurmaq<\/strong> (Fill)<\/em> \u0259mrini se\u00e7in. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi altmenyu \u0259laq\u0259li b\u00f6lm\u0259l\u0259rd\u0259n ibar\u0259tdir.<\/p>\n

G\u00f6st\u0259ril\u0259n \u0259mrl\u0259rin bir \u00e7oxu klaviatur alternativin\u0259 malikdir. M\u0259s\u0259l\u0259n, File<\/strong> menyusunda yerl\u0259\u015f\u0259n Yadda saxlamaq<\/strong> (Save)<\/em> \u0259mrini Ctrl +S klavi\u015f kombinasiyas\u0131n\u0131n k\u00f6m\u0259yil\u0259 d\u0259 yerin\u0259 yetirm\u0259k olar- bu o dem\u0259kdir ki, Ctrl d\u00fcym\u0259si s\u0131x\u0131l\u0131 v\u0259ziyy\u0259td\u0259 S d\u00fcym\u0259sini bassan\u0131z Yadda saxlamaq<\/strong> (Save)<\/em> \u0259mrini yerin\u0259 yetirmi\u015f olursunuz.Menyu b\u00f6l\u0259l\u0259rind\u0259 passiv \u0259mrl\u0259r boz r\u0259ngl\u0259 g\u00f6st\u0259rilmi\u015fdir. Menyunu ba\u011flamaq \u00fc\u00e7\u00fcn v\u0259r\u0259qin ist\u0259nil\u0259n yerind\u0259 mauzun sol d\u00fcym\u0259sini bas\u0131n.<\/p>\n

Menyu s\u0259trinin ard\u0131nca al\u0259tl\u0259r l\u00f6vh\u0259si g\u0259lir. Bel\u0259 ki, menyu s\u0259trinin alt\u0131nda Standart v\u0259 Formatla\u015fd\u0131rma<\/strong> al\u0259tl\u0259r l\u00f6vh\u0259si yerl\u0259\u015fir. H\u0259r bir l\u00f6vh\u0259 m\u00fc\u0259yy\u0259n al\u0259tl\u0259r y\u0131\u011f\u0131m\u0131ndan ibar\u0259tdir. Siz g\u00f6st\u0259ril\u0259n al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259n ba\u015fqa da ist\u0259nil\u0259n h\u0259r hans\u0131 bir al\u0259tl\u0259r l\u00f6vh\u0259sini se\u00e7\u0259 v\u0259 onu \u00f6z bax\u0131\u015f\u0131n\u0131za g\u00f6r\u0259 d\u0259yi\u015fdir\u0259 bil\u0259rsiniz. \u018flav\u0259 al\u0259tl\u0259r l\u00f6vh\u0259sini ekrana \u00e7a\u011f\u0131rmaq \u00fc\u00e7\u00fcn G\u00f6r\u00fcn\u00fc\u015f<\/strong> (View)<\/em> menyusunda \u2013 Al\u0259tl\u0259r l\u00f6vh\u0259si (Toolbars)<\/em> istifad\u0259 edilir.<\/p>\n

Mauzun g\u00f6st\u0259ricisini al\u0259tl\u0259r l\u00f6vh\u0259sin\u0259 yax\u0131nla\u015fd\u0131r\u0131n v\u0259 kontekst menyunu \u00e7a\u011f\u0131r\u0131n. Bunun \u00fc\u00e7\u00fcn mauzun sa\u011f d\u00fcym\u0259sini bas\u0131n. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi b\u00fct\u00fcn m\u00fcmk\u00fcn al\u0259tl\u0259r l\u00f6vh\u0259l\u0259rinin siyah\u0131s\u0131 a\u00e7\u0131l\u0131b. Ad\u0259t\u0259n al\u0259tl\u0259r l\u00f6vh\u0259si ekran\u0131n yuxar\u0131 hiss\u0259sind\u0259 yerl\u0259\u015fdirilir, lakin siz onu ekran\u0131n ist\u0259nil\u0259n hiss\u0259sind\u0259 yerl\u0259\u015fdir\u0259 bil\u0259rsiniz. Mauzun g\u00f6st\u0259ricisini Standart al\u0259tl\u0259r l\u00f6vh\u0259sinin sol k\u00fcnc\u00fcn\u0259 g\u0259tirin v\u0259 mauzun d\u00fcym\u0259si s\u0131x\u0131l\u0131 v\u0259ziyy\u0259td\u0259 onu v\u0259r\u0259qin otras\u0131na g\u0259tirin. Al\u0259tl\u0259r l\u00f6vh\u0259sini geri qaytarmaq \u00fc\u00e7\u00fcn s\u0259rl\u00f6vh\u0259 s\u0259trind\u0259 mauzu 2 d\u0259f\u0259 bas\u0131n.<\/p>\n

P\u0259nc\u0259r\u0259nin n\u00f6vb\u0259ti sah\u0259si D\u00fcstur s\u0259tri<\/strong> (Formula Bar)<\/em> adlan\u0131r. Onun \u00fcz\u0259rind\u0259 ad\u0259t\u0259n aktiv xanaya daxil edilmi\u015f veril\u0259nl\u0259r v\u0259 ya hesabat g\u00f6st\u0259rilir. Ad<\/strong> (Name Box)<\/em> sah\u0259si d\u00fcstur sah\u0259sind\u0259n solda yerl\u0259\u015fir. O se\u00e7ilmi\u015f xanan\u0131, diaqram\u0131n elementl\u0259rini g\u00f6st\u0259rir.<\/p>\n

Microsoft Excelin kitab v\u0259 i\u015f\u00e7i v\u0259r\u0259ql\u0259ri.<\/h2>\n

Excel s\u0259n\u0259dl\u0259ri kitablar adlan\u0131r. H\u0259r bir kitab m\u00fcvafiq i\u015f\u00e7i v\u0259r\u0259ql\u0259rind\u0259n ibar\u0259tdir, bir qayda olaraq bu v\u0259r\u0259ql\u0259r \u0259laq\u0259li m\u0259ntiqi informasiyadan ibar\u0259t olur. Mauzun g\u00f6st\u0259ricisini Standart (Standard)<\/em> menyusuna yax\u0131nla\u015fd\u0131r\u0131n v\u0259 Yeni <\/strong>(New)<\/em> \u0259mrini se\u00e7in. Bel\u0259likl\u0259 siz yeni kitab yaratm\u0131\u015f olacaqs\u0131z.<\/p>\n

Yeni i\u015f\u00e7i v\u0259r\u0259qi \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn mauzun g\u00f6st\u0259ricisini v\u0259r\u0259qin s\u0259rh\u0259ddin\u0259 g\u0259tirin v\u0259 mauzun sa\u011f d\u00fcym\u0259sind\u0259n kontekst menyunu a\u00e7\u0131n. A\u00e7\u0131lm\u0131\u015f menyu p\u0259nc\u0259r\u0259sind\u0259n Yerl\u0259\u015fdirm\u0259k <\/strong>(Insert)<\/em> \u0259mrini se\u00e7in. Yerl\u0259\u015fdirilmi\u015f i\u015f\u00e7i v\u0259r\u0259qinin Ad\u0131 d\u0259yi\u015fm\u0259k<\/strong> (Rename)<\/em> \u0259mrinin k\u00f6m\u0259kliyi il\u0259 d\u0259yi\u015fdiril\u0259 bil\u0259r. M\u0259s\u0259l\u0259n, \u0259mrini \u00e7a\u011f\u0131r\u0131n v\u0259 v\u0259r\u0259q\u0259 \u00abHesabat\u00bb ad\u0131n\u0131 daxil edin.<\/p>\n

Yeni i\u015f\u00e7i v\u0259r\u0259qi \u0259lav\u0259 etm\u0259k \u00fc\u00e7\u00fcn Yerl\u0259\u015fdirm\u0259k <\/strong>(Insert)<\/em> menyusundan da istifad\u0259 etm\u0259k olar. Yerl\u0259\u015fdirm\u0259k <\/strong>(Insert)<\/em> menyusunu a\u00e7\u0131n v\u0259 \u0130\u015f\u00e7i v\u0259r\u0259qi <\/strong>(Worksheet)<\/em> \u0259mrini se\u00e7in. H\u0259r bir v\u0259r\u0259q 65536 s\u0259tr v\u0259 256 s\u00fctundan ibar\u0259tdir.<\/p>\n

\u015eablonlar Excel s\u0259n\u0259dl\u0259rinin \u0259sas\u0131n\u0131 t\u0259\u015fkil edir. Sizin ixtiyar\u0131n\u0131za xeyli \u015fablon verilmi\u015fdir, bel\u0259 ki, siz bu \u015fablonlar\u0131n \u0259sas\u0131nda Excel s\u0259n\u0259dl\u0259rini yarada bil\u0259rsiniz. Lakin \u015f\u0259xsi ist\u0259k \u0259sas\u0131nda x\u00fcsusi s\u0259n\u0259dl\u0259r d\u0259 yarad\u0131la bil\u0259r. Fayl menyusunda Yeni <\/strong>(New)<\/em> \u0259mrini se\u00e7in. A\u00e7\u0131lm\u0131\u015f p\u0259nc\u0259r\u0259d\u0259n siz i\u015f \u00fc\u00e7\u00fcn ist\u0259nil\u0259n \u015fablon se\u00e7\u0259 bil\u0259rsininz.<\/p>\n

S\u0259tr v\u0259 s\u00fctunlar.<\/h2>\n

H\u0259r bir Excel s\u0259tri sol k\u0259nardan s\u0131ralan\u0131r. S\u0259trin b\u00fct\u00f6vl\u00fckl\u0259 qeyd edilm\u0259si \u00fc\u00e7\u00fcn s\u0131ra n\u00f6mr\u0259sinin \u00fcz\u0259rind\u0259 mauzu bas\u0131n. Ad\u0259t\u0259n s\u0259tirl\u0259r m\u00fc\u0259yy\u0259n h\u00fcnd\u00fcrl\u00fcy\u0259 malikdir. \u018fg\u0259r ist\u0259s\u0259niz s\u0259tirl\u0259rin h\u00fcnd\u00fcrl\u00fcy\u00fcn\u00fc d\u0259yi\u015f\u0259 bil\u0259rsininz. Bunun \u00fc\u00e7\u00fcn Format<\/strong> menyusunda S\u0259tr<\/strong> (Row)<\/em> altmenyusunu v\u0259 daha sonra h\u00fcnd\u00fcrl\u00fck (Height)<\/em> \u0259mrini se\u00e7in. Yaranm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sind\u0259 \u00ab25\u00bb daxil edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi s\u0259trl\u0259rin h\u00fcnd\u00fcrl\u00fcy\u00fc d\u0259yi\u015fdi.<\/p>\n

B\u00fct\u00fcn s\u0259trl\u0259rin h\u00fcnd\u00fcrl\u00fcy\u00fcn\u00fc d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn sol k\u00fcncd\u0259 yuxar\u0131da yerl\u0259\u015f\u0259n Ham\u0131s\u0131n\u0131 qeyd et<\/strong> (Select All) d\u00fcym\u0259sini basaraq b\u00fct\u00fcn s\u0259tirl\u0259ri qeyd edin. Sonra mauzun sa\u011f d\u00fcym\u0259sini h\u0259r hans\u0131 bir xanada bas\u0131n v\u0259 a\u00e7\u0131lm\u0131\u015f kontekst menyudan S\u0259trin h\u00fcnd\u00fcrl\u00fcy\u00fc<\/strong> (Row Height)<\/em> \u0259mrini se\u00e7in. Yaranm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sind\u0259 \u00ab15\u00bb daxil edin.<\/p>\n

Mauzun g\u00f6st\u0259ricisini s\u0259trl\u0259r aras\u0131 s\u0259rh\u0259dd\u0259 g\u0259tirib mauzun d\u00fcym\u0259sini s\u0131xmaqla s\u0259trin h\u00fcnd\u00fcrl\u00fcy\u00fcn\u00fc \u0259ll\u0259 d\u0259 d\u0259yi\u015fm\u0259k olar. Format<\/strong> menyusunda S\u0259tr<\/strong> (Row)<\/em> v\u0259 sonra Gizl\u0259tm\u0259k<\/strong> (Hide)<\/em> \u0259mrini se\u00e7in. Bu \u00fcsulla qeyd edilmi\u015f s\u0259trl\u0259ri gizl\u0259tm\u0259k olar.<\/p>\n

Excel s\u00fctunlar\u0131 v\u0259r\u0259qin yuxar\u0131 hiss\u0259sind\u0259 1 v\u0259 ya 2 h\u0259rfl\u0259 qeyd edilib. 1-d\u0259n 26-ya q\u0259d\u0259r s\u00fctunlar A-dan Z-\u0259 q\u0259d\u0259r h\u0259rfl\u0259rl\u0259 n\u00f6vb\u0259ti 26 s\u00fctun AA v\u0259 AZ v\u0259 s. ard\u0131c\u0131ll\u0131\u011f\u0131 \u015f\u0259klind\u0259 g\u00f6st\u0259rilmi\u015fdir. S\u00fctunun b\u00fct\u00f6vl\u00fckl\u0259 qeyd edilm\u0259si \u00fc\u00e7\u00fcn s\u00fctunun ad\u0131nda mauzu bas\u0131n. Ad\u0259t\u0259n s\u00fctunlar m\u00fc\u0259yy\u0259n en\u0259 malik olur. S\u00fctunun ad\u0131n\u0131 qeyd ed\u0259r\u0259k b\u00fct\u00fcn s\u00fctunu se\u00e7in, mauzun g\u00f6st\u0259ricisini Format<\/strong> menyusuna yax\u0131nla\u015fd\u0131r\u0131n v\u0259 S\u00fctun<\/strong> (Column)<\/em> altmenyusundan En<\/strong> (Width)<\/em> se\u00e7in. Yaranm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sind\u0259 \u00ab15\u00bb daxil edin. Sonunda se\u00e7ilmi\u015f s\u00fctunun eni d\u0259yi\u015fir.<\/p>\n

B\u00fct\u00fcn s\u00fctunlar\u0131n enini d\u0259yi\u015fm\u0259k \u00fc\u00e7\u00fcn sol k\u00fcncd\u0259 yuxar\u0131da yerl\u0259\u015f\u0259n Ham\u0131s\u0131n\u0131 qeyd et<\/strong> (Select All)<\/em> d\u00fcym\u0259sini bas\u0131n v\u0259 kontekst menyudan S\u00fctunun eni<\/strong> (Column width)<\/em> \u0259mrini se\u00e7ib, sonra \u00ab10\u00bb daxil edin.<\/p>\n

Format<\/strong> menyusunun S\u00fctun<\/strong> (Column)<\/em> altmenyusundan Gizl\u0259tm\u0259k<\/strong> (Hide)<\/em> \u0259mrini se\u00e7in. Bel\u0259likl\u0259, qeyd edilmi\u015f s\u00fctunlar gizl\u0259nir.<\/p>\n

\u018fg\u0259r daxil edilmi\u015f veril\u0259nl\u0259r xanan\u0131n h\u00fcdudlar\u0131ndan k\u0259nara \u00e7\u0131x\u0131rsa, s\u00fctunun enini art\u0131rmaq olar. Bunun \u00fc\u00e7\u00fcn kursor m\u00fcvafiq s\u00fctunlar\u0131n s\u0259rh\u0259ddin\u0259 yerl\u0259\u015fdirilir v\u0259 mauz 2 d\u0259f\u0259 bas\u0131n. N\u0259tic\u0259d\u0259, s\u00fctun laz\u0131mi en\u0259 malik olur.<\/p>\n

M\u0259s\u0259l\u0259n \u00abT\u0259snifat\u00bb soz\u00fcn\u00fc daxil edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, h\u0259min s\u00f6z xanan\u0131n h\u00fcdudlar\u0131ndan k\u0259nara \u00e7\u0131x\u0131r. Mauzun g\u00f6st\u0259ricisini s\u00fctunlar\u0131n s\u0259rh\u0259ddin\u0259 yerl\u0259dirib, mauzun d\u00fcym\u0259sini 2 d\u0259f\u0259 bas\u0131n. Bel\u0259lil\u0259, s\u00fctun yeni en\u0259 malik olur.<\/p>\n

Xanalar v\u0259 veril\u0259nl\u0259rin daxil edilm\u0259si.<\/h2>\n

Excel proqram\u0131nda veril\u0259nl\u0259r xanalara daxil edilir. H\u0259r bir xana s\u00fctunun ad\u0131 v\u0259 s\u0259trin s\u0131ra n\u00f6mr\u0259si il\u0259 g\u00f6st\u0259rilir. M\u0259s\u0259l\u0259n, A5 xanas\u0131. Xanalar a\u015fa\u011f\u0131da sadalanan formatda m\u0259lumatlardan ibar\u0259t olur: m\u0259tn; \u0259d\u0259d; tarix.vaxt; d\u00fcstur. G\u0259lin buna sad\u0259 bir misalda baxaq. =C10+C11 (veril\u0259nl\u0259ri \u0259vv\u0259lc\u0259d\u0259n daxil etm\u0259k). G\u00f6rd\u00fcy\u00fcn\u00fcz kimi h\u0259r bir hesabat \u00ab=\u00bb i\u015far\u0259sind\u0259n sonra daxil edilir. Enter d\u00fcym\u0259sini bas\u0131n. Bu klavi\u015f h\u0259m veril\u0259nl\u0259ri daxil edir h\u0259m d\u0259 n\u0259tic\u0259ni g\u00f6st\u0259rir. Xanaya daxil edilmi\u015f \u0259d\u0259d 15 r\u0259q\u0259md\u0259n ibar\u0259t ola bil\u0259r. \u018fg\u0259r s\u00fctun \u0259d\u0259din g\u00f6st\u0259rilm\u0259si \u00fc\u00e7\u00fcn \u00e7ox dard\u0131rsa bu zamn \u0259d\u0259d diyez \u00ab#\u00bb i\u015far\u0259si \u015f\u0259klind\u0259 g\u00f6st\u0259ril\u0259c\u0259k.<\/p>\n

Tarix v\u0259 vaxt\u0131n daxil edilm\u0259si \u00fc\u00e7\u00fcn m\u00fcxt\u0259lif formatlar istifad\u0259 edilir. M\u0259s\u0259l\u0259n, C9 xanas\u0131na 11:45 daxil edin. Bu veril\u0259nl\u0259r Excel t\u0259r\u0259find\u0259n 12-\u0259 15 d\u0259qiq\u0259 qalm\u0131\u015f kimi q\u0259bul olunur.<\/p>\n

\u0130ndi is\u0259 n\u00f6vb\u0259ti xanaya tarixi daxil edin. 9.11.2000- bu redaktor t\u0259r\u0259find\u0259n 9 noyabr 2000-ci il kimi q\u0259bul edilir. Excel tarix v\u0259 vaxtla i\u015fl\u0259m\u0259k \u00fc\u00e7\u00fcn d\u00fcsturlar da t\u0259klif edir. B\u00fct\u00fcn daxil edilmi\u015f veril\u0259nl\u0259r d\u00fcstur s\u0259trind\u0259 v\u0259 xanalarda g\u00f6st\u0259rilir.<\/p>\n

B15 xanas\u0131na \u00ab-567\u00bb r\u0259q\u0259mini daxil edin v\u0259 Enteri bas\u0131n. H\u0259min r\u0259q\u0259m redaktor t\u0259r\u0259find\u0259n m\u0259nfi \u0259d\u0259d kimi q\u0259bul edilir.<\/p>\n

\u00abE\u00bb simvolu \u0259d\u0259din eksponensial t\u0259svir edilm\u0259si zaman\u0131 istifad\u0259 edilir. M\u0259s\u0259l\u0259n, 10 000 000 \u0259d\u0259dini daxil edin v\u0259 Enteri bas\u0131n. Diqq\u0259t edin, veril\u0259nl\u0259r 1E+0.7 kimi t\u0259svir edilmi\u015fdir. Bu o dem\u0259kdir ki, vahid 10 \u00fcst\u00fc 7-y\u0259 vurulur.<\/p>\n

Formatlar\u0131n t\u0259\u2019yini<\/strong><\/p>\n

Microsoft Excel redaktoru veril\u0259nl\u0259r \u00fc\u00e7\u00fcn m\u00fcxt\u0259lif formatlardan istifad\u0259 etm\u0259y\u0259 imkan verir. Bu formatlar veril\u0259nl\u0259rin daxil edilm\u0259sind\u0259n \u0259vv\u0259l v\u0259 sonra istifad\u0259 edil\u0259 bil\u0259r. Xanan\u0131n formatla\u015fd\u0131r\u0131lmas\u0131n\u0131 yerin\u0259 yetirm\u0259k \u00e7ox asand\u0131r. Xanan\u0131 qeyd edin, kontekst menyudan Xanalar\u0131n format\u0131 <\/strong>(Format Cells)<\/em> \u0259mrini se\u00e7in. A\u00e7\u0131lm\u0131\u015f p\u0259nc\u0259r\u0259d\u0259n m\u00fcvafiq format\u0131 se\u00e7in, m\u0259s\u0259l\u0259n, R\u0259q\u0259m (\u0259g\u0259r qeyd edilmi\u015f xanada \u0259d\u0259d varsa). Bel\u0259likl\u0259 siz xanaya r\u0259q\u0259m format\u0131 verdiniz.<\/p>\n

Dig\u0259r formatlardan istifad\u0259 ed\u0259k: xanan\u0131 qeyd edin, mauz\u00fcn g\u00f6st\u0259ricisini Format<\/strong> menyusuna g\u0259tirin v\u0259 Xanalar<\/strong> (Cells)<\/em> altmenyusunu se\u00e7in. \u018fd\u0259d<\/strong> (Number)<\/em> s\u0259hif\u0259sind\u0259 formatlar siyah\u0131s\u0131nda Pul<\/strong> (Currency)<\/em> format\u0131n\u0131 se\u00e7in. Daha sonra \u018fd\u0259din k\u0259sr hiss\u0259sind\u0259 r\u0259q\u0259ml\u0259rin say\u0131 <\/strong>(Decimal Places)<\/em> sah\u0259sind\u0259 2 \u0259d\u0259dini qeyd edin. V\u0259 n\u0259hay\u0259t xanaya \u00ab927\u00bb \u0259d\u0259dini daxil edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, r\u0259q\u0259m pul format\u0131nda t\u0259svir edilmi\u015fdir.<\/p>\n

Dig\u0259r misal, Fayl<\/strong> menyusunda A\u00e7maq<\/strong> (Open)<\/em> \u0259mrini se\u00e7in v\u0259 Traininq adl\u0131 fayl\u0131n \u00fcz\u0259rind\u0259 mauzu 2 d\u0259f\u0259 bas\u0131n. A2-d\u0259n A7-\u0259 q\u0259d\u0259r diapazonu qeyd edin v\u0259 kontekst menyudan Xanalar\u0131n format\u0131 <\/strong>(Format Cells)<\/em> \u0259mrini se\u00e7in, \u018fd\u0259d<\/strong> (Number)<\/em> s\u0259hif\u0259sind\u0259 Tarixi<\/strong> (Date) <\/em>se\u00e7in v\u0259 Tip sah\u0259sind\u0259 \u2013 14-mar-00 variant\u0131n\u0131 qeyd edib OK \u2013i bas\u0131n. Diqq\u0259t edin, veril\u0259nl\u0259r nec\u0259 d\u0259yi\u015fdi.<\/p>\n

1 deyil 2 v\u0259 daha art\u0131q xana daxil edilmi\u015f xanalar diapazonunu formatla\u015fd\u0131rmaq \u00fc\u00e7\u00fcn, ilk n\u00f6vb\u0259d\u0259 m\u00fctl\u0259q h\u0259min diapazon qeyd edilm\u0259lidir. Xanalar\u0131 qeyd edin, sonra mauzun sol d\u00fcym\u0259si s\u0131x\u0131l\u0131 v\u0259ziyy\u0259td\u0259 kursoru s\u00fctun istiqam\u0259tind\u0259 h\u0259r\u0259k\u0259t etdirin ( ya s\u0259tr, ya da s\u0259tr v\u0259 s\u00fctun). Bu \u00fcsulla siz xanalar diapazonunu qeyd etdiniz. Yenid\u0259n Format<\/strong> menyusundan Xanalar<\/strong> (Cells)<\/em> \u0259mrini se\u00e7in. H\u0259min \u0259mri kontekst menyudan da \u00e7a\u011f\u0131rmaq olar.<\/p>\n

Avtoformat \u0259mrind\u0259n istifad\u0259 ed\u0259r\u0259k siz vaxta q\u0259na\u0259t ed\u0259 bil\u0259rsiniz. Format menyusunda yerl\u0259\u015f\u0259n Avtoformat \u0259mrind\u0259n istifad\u0259 etm\u0259kl\u0259 siz veril\u0259nl\u0259r\u0259 \u0259vv\u0259lc\u0259d\u0259n m\u00fc\u0259yy\u0259n edilmi\u015f formatlar\u0131, \u015frifti, d\u00fczl\u0259nm\u0259ni t\u0259tbiq ed\u0259 bil\u0259rsiniz. Verilmi\u015f c\u0259dv\u0259l\u0259 usta formatlar\u0131 t\u0259tbiq ed\u0259k. Avtoformat dialoq p\u0259nc\u0259r\u0259sind\u0259 \u00abList 2\u00bb format\u0131n\u0131 se\u00e7in. C\u0259dv\u0259l formala\u015fd\u0131.<\/p>\n

Xanaya daxil edilmi\u015f veril\u0259nl\u0259rin d\u00fczl\u0259nm\u0259si.<\/h2>\n

Xanaya daxil edil\u0259nl\u0259r Formatla\u015fd\u0131rma<\/strong> al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259ki d\u00fcym\u0259l\u0259rin k\u00f6m\u0259kliyi il\u0259 d\u00fczl\u0259n\u0259 bil\u0259r. Mauzun g\u00f6st\u0259ricisini Format<\/strong> menyusuna g\u0259tirin v\u0259 Xanalar<\/strong> (Cells<\/em>) \u0259mrini se\u00e7in. D\u00fczl\u0259nm\u0259<\/strong> (Aliginment)<\/em> s\u0259hif\u0259sind\u0259 xanada m\u0259tn v\u0259 r\u0259q\u0259ml\u0259rin m\u00f6vqeyin\u0259 n\u0259zar\u0259t edilir. Burada 7 \u00fcf\u00fcqi istiqam\u0259td\u0259 v\u0259 4 \u015faquli istiqam\u0259td\u0259 d\u00fczl\u0259nm\u0259 variant\u0131ndan h\u0259r hans\u0131 1-ni se\u00e7m\u0259k olar. Xanaya Excel daxil edin, sonra M\u0259rk\u0259z\u0259 g\u00f6r\u0259 d\u00fczl\u0259nm\u0259<\/strong> (Center Across Selection)<\/em> variant\u0131ndan istifad\u0259 edin, \u00fcf\u00fcqi istiqam\u0259td\u0259. M\u0259tnin istiqam\u0259tini 45 d\u0259r\u0259c\u0259 istiqam\u0259tind\u0259 d\u0259yi\u015fin. Xanalar\u0131n format\u0131<\/strong> (Format Cells)<\/em> dialoq p\u0259nc\u0259r\u0259sind\u0259 OK d\u00fcym\u0259sini basmaqla \u0259m\u0259liyyat\u0131 t\u0259sdiq edin. Diqq\u0259t edin, xanadak\u0131 s\u00f6z m\u0259rk\u0259z\u0259 g\u00f6r\u0259 d\u00fczl\u0259nib v\u0259 45 d\u0259r\u0259c\u0259 bucaq alt\u0131nda g\u00f6st\u0259rilib.<\/p>\n

Xanada v\u0259 ya xanalar diapazonunda veril\u0259nl\u0259rin d\u00fczl\u0259nm\u0259sind\u0259n sonra ha\u015fiy\u0259l\u0259nm\u0259ni t\u0259tbiq etm\u0259k olar. Ha\u015fiy\u0259l\u0259nm\u0259si vacib olan xanan\u0131 qeyd edin, Format<\/strong> menyusunu a\u00e7\u0131n v\u0259 art\u0131q biz\u0259 tan\u0131\u015f olan Xanalar\u0131n format\u0131<\/strong> (Format Cells)<\/em> dialoq p\u0259nc\u0259r\u0259sini ekrana \u00e7a\u011f\u0131r\u0131n. Ha\u015fiy\u0259l\u0259nm\u0259<\/strong> (Border)<\/em> s\u0259hif\u0259sind\u0259 x\u0259ttin stili kimi 2qat x\u0259tt se\u00e7in, R\u0259ng<\/strong> (Color)<\/em> sah\u0259sind\u0259 g\u00f6y r\u0259ngi se\u00e7in. Sonra Ha\u015fiy\u0259 variant\u0131n\u0131 se\u00e7in, m\u0259s\u0259l\u0259n Xarici<\/strong> (Outline)<\/em> d\u00fcym\u0259sinin \u00fcz\u0259rind\u0259 mauzun d\u00fcym\u0259sini bas\u0131n. Fikir verin, xana ha\u015fiy\u0259l\u0259ndi<\/p>\n

\u015e\u0259rti formatla\u015fd\u0131rma.<\/h2>\n

\u015e\u0259rti formatla\u015fd\u0131rman\u0131 1 \u00e7ox veril\u0259nl\u0259r\u0259, o c\u00fcml\u0259d\u0259n c\u0259dv\u0259l\u0259 t\u0259tbiq etm\u0259k olar. M\u0259s\u0259l\u0259n c\u0259dv\u0259l sat\u0131\u015f haqq\u0131nda yekun m\u0259lumatlardan ibar\u0259tdir v\u0259 dey\u0259k ki, c\u0259dv\u0259l daxilind\u0259 h\u0259r hans\u0131 bir qiym\u0259tin $10000-d\u0259n a\u015fa\u011f\u0131 d\u00fc\u015fd\u00fcy\u00fc halda xanan\u0131n format\u0131 d\u0259yi\u015fsin. Bunu n\u00f6vb\u0259ti misalda ara\u015fd\u0131raq. E18:E22 xanalar diapazonunu qeyd edin v\u0259 Format<\/strong> menyusunu se\u00e7in. A\u00e7\u0131lan menyuda \u015e\u0259rti formatla\u015fd\u0131rma<\/strong> (Conditional Formattinq)<\/em> \u0259mrini se\u00e7in. Ekranda eyni adl\u0131 dialoq p\u0259nc\u0259r\u0259si yaran\u0131r. Bu p\u0259nc\u0259r\u0259d\u0259 \u015f\u0259rt g\u00f6st\u0259rilir.<\/p>\n

Bel\u0259likl\u0259, 1-ci \u015f\u0259rt sah\u0259sind\u0259 Xanan\u0131n qiym\u0259tini<\/strong> (Cell Value is)<\/em> se\u00e7in v\u0259 \u015f\u0259rt kimi b\u00f6y\u00fck v\u0259 ya b\u0259rab\u0259rdir 10 000 \u015f\u0259rtini g\u00f6st\u0259rin. Format<\/strong> d\u00fcym\u0259sini bas\u0131n v\u0259 p\u0259nc\u0259r\u0259d\u0259 qal\u0131n<\/strong> (Bold)<\/strong> stilini v\u0259 R\u0259ng<\/strong> (Color)<\/em> sah\u0259sind\u0259 q\u0131rm\u0131z\u0131 r\u0259ngi g\u00f6st\u0259rin. Ok-i basmaqla daxil edilmi\u015f \u015f\u0259rti t\u0259sdiq edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, yerin\u0259 yetirilmi\u015f \u0259m\u0259liyyat\u0131n n\u0259tic\u0259sind\u0259 \u00abSifari\u015fin c\u0259mi\u00bb s\u00fctununda qoyulmu\u015f \u015f\u0259rt\u0259 m\u00fcvafiq olan qiym\u0259tl\u0259r qeyd edilib.<\/p>\n

Xanalar\u0131n t\u0259mizl\u0259nm\u0259si v\u0259 l\u0259\u011fvi.<\/h2>\n

Traninq. xls fayl\u0131nda B11:B14 xanalar diapazonunu qeyd edin. Mauzun g\u00f6st\u0259ricisin D\u00fcz\u0259li\u015f<\/strong> (Edit)<\/em> menyusuna g\u0259tirin v\u0259 bu menyudan T\u0259mizl\u0259m\u0259<\/strong> (Clear)<\/em> \u0259mrini se\u00e7in. Sonra T\u0259mizl\u0259m\u0259<\/strong> (Clear)<\/em> altmenyusundan Formatlar\u0131<\/strong> (Formats)<\/em> se\u00e7in. N\u0259tic\u0259d\u0259 qeyd edilmi\u015f diapazona t\u0259tbiq edilmi\u015f format silin\u0259c\u0259k.<\/p>\n

\u0130ndi is\u0259 \u015f\u0259rh daxil edilmi\u015f F11 xanas\u0131n\u0131 qeyd edin. Bu \u015f\u0259rhi silm\u0259k \u00fc\u00e7\u00fcn xanan\u0131n kontekst menyusundan \u015e\u0259rhin silinm\u0259si<\/strong> (Delete Comment)<\/em> \u0259mrini se\u00e7in. \u018fg\u0259r siz T\u0259mizl\u0259m\u0259<\/strong> (Clear)<\/em> altmenyusundan \u015e\u0259rh<\/strong> (Comment)<\/em> \u0259mrini se\u00e7s\u0259niz h\u0259min n\u0259tic\u0259y\u0259 g\u0259l\u0259 bil\u0259rsiniz.<\/p>\n

B10:B14 xanalar diapazonunu qeyd edin v\u0259 T\u0259mizl\u0259m\u0259<\/strong> (Clear)<\/em> altmenyusundan Xanan\u0131n t\u0259rkibi <\/strong>(Contents)<\/em> \u0259mrini se\u00e7in. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi xanaya daxil edil\u0259nl\u0259r pozuldu.<\/p>\n

\u018fm\u0259liyyat\u0131n t\u0259kzibi.<\/h2>\n

Veril\u0259nl\u0259rin u\u011fursuz d\u00fcz\u0259li\u015fl\u0259rind\u0259n sonra veril\u0259nl\u0259r T\u0259kzib<\/strong> (Undo)<\/em> \u0259mri il\u0259 b\u0259rpa edil\u0259 bil\u0259r. Sad\u0259c\u0259 olaraq D\u00fcz\u0259li\u015f <\/strong>(Edit)<\/em> menyusunda T\u0259kzib<\/strong> (Undo)<\/em> \u0259mrini se\u00e7in. Bu \u0259mrin k\u00f6m\u0259kliyi il\u0259 siz son 16 \u0259m\u0259liyyat\u0131 t\u0259kzib ed\u0259bil\u0259rsiniz. T\u0259kzib<\/strong> (Undo) <\/em>Standart<\/strong> (Standard)<\/em> al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 m\u00fcvafiq d\u00fcym\u0259 il\u0259 d\u0259 \u0259v\u0259z etm\u0259k olar.<\/p>\n

\u0130st\u0259yiniz\u0259 m\u00fcvafiq olaraq ist\u0259nil\u0259n sayda sonuncu \u0259m\u0259liyyat\u0131 qeyd edin v\u0259 1 d\u0259f\u0259y\u0259 ham\u0131s\u0131n\u0131 l\u0259\u011fv edin<\/p>\n

\u0130stifad\u0259\u00e7i siyah\u0131lar\u0131.<\/h2>\n

Tez-tez i\u015f\u00e7i v\u0259r\u0259qind\u0259 m\u00fc\u0259yy\u0259n ard\u0131c\u0131ll\u0131ql\u0131\u011f\u0131 t\u0259krar etm\u0259k laz\u0131m g\u0259lir. Bel\u0259 tip veril\u0259nl\u0259rin daxil edilm\u0259sini asanla\u015fd\u0131rmaq \u00fc\u00e7\u00fcn Microsoft Excel redaktorunda \u0130stifad\u0259\u00e7i siyah\u0131lar\u0131 istifad\u0259 edilir. Bel\u0259 siyah\u0131n\u0131 yaratmaq \u00fc\u00e7\u00fcn Xidm\u0259t<\/strong> (Servis)<\/em> menyusunda Parametrl\u0259r<\/strong> (Options)<\/em> \u0259mrini se\u00e7in. Ekranda bir s\u0131ra s\u0259hif\u0259l\u0259rd\u0259n ibar\u0259t olan Parametrl\u0259r<\/strong> (Options)<\/em> p\u0259nc\u0259r\u0259si a\u00e7\u0131lacaq. \u0130stifad\u0259\u00e7i siyah\u0131lar\u0131<\/strong> (Custom Lists) <\/em>s\u0259hif\u0259sind\u0259 m\u00f6vcud siyah\u0131lar g\u00f6st\u0259rilmi\u015fdir. \u015e\u0259xsi siyah\u0131n\u0131z\u0131 yaratmaq \u00fc\u00e7\u00fcn Yeni siyah\u0131n\u0131<\/strong> (New Lists)<\/em> se\u00e7in v\u0259 Siyah\u0131n\u0131n elementl\u0259ri<\/strong> (Lists entries)<\/em> sah\u0259sind\u0259 mauzu bas\u0131n. Ard\u0131c\u0131l olaraq qiym\u0259t, say, vergi, kurs, g\u0259lir s\u00f6zl\u0259rini daxil edin v\u0259 \u018flav\u0259 et <\/strong>(Add)<\/em> d\u00fcym\u0259sini s\u0131xmaqla yeni siyah\u0131n\u0131 m\u00f6vcud siyah\u0131lar s\u0131ras\u0131na \u0259lav\u0259 edin. Bel\u0259likl\u0259 siyah\u0131 yarand\u0131. Bu siyah\u0131dan istifad\u0259 ed\u0259k. Xanaya yeni siyah\u0131n\u0131n elementl\u0259rind\u0259n h\u0259r h\u0259ans\u0131 birini daxil edin v\u0259 doldurma i\u015far\u0259sini \u00e7\u0259kin \u00e7\u0259kin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi qalan xanalara siyah\u0131n\u0131n elementl\u0259ri k\u00f6\u00e7\u00fcr\u00fcl\u00fcb.<\/p>\n

\u0130stifad\u0259\u00e7i siyah\u0131lar\u0131 m\u00f6vcud xanalar diapazonunun qeyd edilm\u0259si il\u0259 d\u0259 idxal edil\u0259 bil\u0259r. Veril\u0259nl\u0259ri idxal etm\u0259k \u00fc\u00e7\u00fcn, ilk n\u00f6vb\u0259d\u0259 g\u0259l\u0259c\u0259k siyah\u0131n\u0131n veril\u0259nl\u0259ri yerl\u0259\u015f\u0259n xanalar diapazonunu qeyd edin (g\u00f6st\u0259r A1:D1 Traninq.xls fayl\u0131nda). Parametrl\u0259r<\/strong> (Options)<\/em> dialoq p\u0259nc\u0259r\u0259sind\u0259 \u0130stifad\u0259\u00e7i siyah\u0131lar\u0131<\/strong> (Custom Lists) s\u0259hif\u0259sin\u0259 <\/em>ke\u00e7in. \u0130dxal <\/strong>(\u0130mport)<\/em> d\u00fcym\u0259sini basmaqla qeyd edilmi\u015f veril\u0259nl\u0259ri yeni siyah\u0131ya \u0259lav\u0259 etmi\u015f olurs\u0131z.<\/p>\n

Veril\u0259nl\u0259rin sur\u0259tnin \u00e7\u0131xar\u0131lmas\u0131, k\u0259silm\u0259si v\u0259 yerl\u0259\u015fdirilm\u0259si.<\/h2>\n

D\u00fcz\u0259li\u015f<\/strong> (Edit)<\/em> menyusunda yerl\u0259\u015f\u0259n veril\u0259nl\u0259rin sur\u0259tinin \u00e7\u0131xar\u0131lmas\u0131, k\u0259silm\u0259si v\u0259 yerl\u0259\u015fdirilm\u0259si \u0259mrl\u0259ri veril\u0259nl\u0259rin v\u0259 formatlar\u0131n sur\u0259tinin \u00e7\u0131xar\u0131lmas\u0131, k\u0259silm\u0259si v\u0259 yerl\u0259\u015fdirilm\u0259si \u00fc\u00e7\u00fcn vacibdir.<\/p>\n

N\u00f6vb\u0259ti misala baxaq: Traninq.xls fayl\u0131nda D2: D7 xanalar diapazonunu qeyd edin v\u0259 D\u00fcz\u0259li\u015f<\/strong> (Edit)<\/em> menyusunda K\u0259sm\u0259k <\/strong>(Cut)<\/em> \u0259mrind\u0259n istifad\u0259 edin v\u0259 ya sad\u0259c\u0259 olaraq Al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 K\u0259sm\u0259k <\/strong>(Cut)<\/em> d\u00fcym\u0259sini bas\u0131n. Sonra bu veril\u0259nl\u0259rin yerl\u0259\u015fdirilm\u0259si vacib olan diapazonu qeyd edin v\u0259 D\u00fcz\u0259li\u015f<\/strong> (Edit)<\/em> menyusunda Yerl\u0259\u015fdirm\u0259k<\/strong> (Paste) \u0259mrini icra edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi veril\u0259nl\u0259r i\u015f\u00e7i v\u0259r\u0259qind\u0259 g\u00f6st\u0259rilmi\u015f yer\u0259 yerl\u0259\u015fdirilib.<\/p>\n

Yenid\u0259n I2:I7 diapazonunda veril\u0259nl\u0259ri qeyd edin, mauzun sa\u011f d\u00fcym\u0259sind\u0259n kontekst menyunu \u00e7a\u011f\u0131r\u0131n v\u0259 a\u00e7\u0131lm\u0131\u015f menyu s\u0259hif\u0259sind\u0259 Sur\u0259ti \u00e7\u0131xarmaq<\/strong> (Copy)<\/em> \u0259mrini icra edin. Sur\u0259ti \u00e7\u0131xar\u0131lm\u0131\u015f diapazonu G2: G7 diapazonuna yerl\u0259\u015fdirin. Bunun \u00fc\u00e7\u00fcn sad\u0259c\u0259 olaraq G2 xanas\u0131n\u0131 qeyd edin. Yerl\u0259\u015fdirm\u0259k \u0259mrini Ctrl+V d\u00fcym\u0259l\u0259rinin alternativi il\u0259 \u0259v\u0259z edin. Bel\u0259likl\u0259 veril\u0259nl\u0259r yenid\u0259n G2: G7 diapazonundad\u0131r.<\/p>\n

Yerl\u0259\u015fdirm\u0259k \u0259mri sur\u0259ti \u00e7\u0131xar\u0131lm\u0131\u015f xanalardan h\u0259r \u015feyi: qiym\u0259tl\u0259r, formatlar v\u0259 \u015f\u0259rhl\u0259ri yerl\u0259\u015fdirir. M\u00fc\u0259yy\u0259n elementl\u0259r yerl\u0259\u015fdirm\u0259k \u00fc\u00e7\u00fcn D\u00fcz\u0259li\u015f<\/strong> (Edit)<\/em> menyusunda X\u00fcsusi yerl\u0259\u015fdirm\u0259<\/strong> (Paste Spesial)<\/em> \u0259mri istifad\u0259 edilm\u0259lidir.<\/p>\n

Xanalar\u0131n as\u0131l\u0131l\u0131\u011f\u0131n\u0131n izl\u0259nm\u0259si.<\/h2>\n

\u018fg\u0259r siz b\u00f6y\u00fck i\u015f\u00e7i v\u0259r\u0259ql\u0259ri il\u0259 i\u015fl\u0259y\u0259rk\u0259n bilm\u0259k ist\u0259yirsinizs\u0259 ki, veril\u0259nl\u0259r \u00e7oxlu\u011fu nec\u0259 t\u0259\u015fkil edilib, onda xanalar\u0131n izl\u0259nm\u0259sind\u0259n istifad\u0259 edin. G\u0259lin bunu a\u015fa\u011f\u0131dak\u0131 misal \u00fcz\u0259rind\u0259 ara\u015fd\u0131raq.<\/p>\n

B3-\u0259 78, C5-\u0259 =B3+5 d\u00fcsturunu, F10-a =B3+C5 d\u00fcsturunu, A5-\u0259 B3*45 d\u00fcsturunu, G5-\u0259 = F10+2*2 d\u00fcsturunu, H1-\u0259 F10+A5 d\u00fcsturunu daxil edin. \u0130ndi is\u0259 v\u0259r\u0259qd\u0259 veril\u0259nl\u0259r f\u0259 d\u00fcsturlar\u0131n nec\u0259 \u0259laq\u0259dar oldu\u011funu ara\u015fd\u0131raq. A5 xanas\u0131nda mauzu bas\u0131n v\u0259 Xidm\u0259t<\/strong> (Tools)<\/em> menyusunda Yoxlama<\/strong> (Auditinq) <\/em>\u0259mrini se\u00e7in. Sonra As\u0131l\u0131 xanalar\u0131n izl\u0259nm\u0259si <\/strong>(Trace Dependents)<\/em> v\u0259 daha sonra T\u0259siredici xanalar\u0131n izl\u0259nm\u0259si <\/strong>(Trace Presendents)<\/em> \u0259mrl\u0259rini se\u00e7in. V\u0259r\u0259qd\u0259 yaranan oxlara fikir verin. Qeyd edilmi\u015f 3510 qiym\u0259ti V3 xanas\u0131nda yerl\u0259\u015f\u0259n 78 qiym\u0259tind\u0259n as\u0131l\u0131 v\u0259ziyy\u0259td\u0259dir. H1 xanas\u0131nda yerl\u0259\u015f\u0259n 3671 qiym\u0259ti \u00fc\u00e7\u00fcn t\u0259siredici v\u0259ziyy\u0259td\u0259dir. F10 xanas\u0131nda olan qiym\u0259t haqq\u0131nda n\u0259 dem\u0259k olar? Onun hans\u0131 xana \u00fc\u00e7\u00fcn t\u0259siredici oldu\u011funu m\u00fc\u0259yy\u0259n ed\u0259k. As\u0131l\u0131 xanalar\u0131n izl\u0259nm\u0259si <\/strong>(Trace Dependents)<\/em> \u0259mrini se\u00e7in. Bel\u0259likl\u0259 biz\u0259 m\u0259lum oldu ki, 161 qiym\u0259ti m\u00fcvafiq olaraq G5 v\u0259 H1 xanalar\u0131nda yerl\u0259\u015f\u0259n 165 v\u0259 3671 qiym\u0259tl\u0259ri \u00fc\u00e7\u00fcn t\u0259siredicidir.<\/p>\n

S\u0259n\u0259din strukturla\u015fd\u0131r\u0131lmas\u0131.<\/h2>\n

\u0130\u015f\u00e7i v\u0259r\u0259qin h\u0259r hans\u0131 bir hiss\u0259sinin strukturunun yarad\u0131lmas\u0131 \u00fc\u00e7\u00fcn m\u00fctl\u0259q konkret veril\u0259nl\u0259r sah\u0259sini qeyd edin. Veril\u0259nl\u0259r<\/strong> (Data)<\/em> menyusundan Qrup v\u0259 struktur<\/strong> (Group and Outline) <\/em>altmenyusunu v\u0259 daha sonra Qrupla\u015fd\u0131rma <\/strong>(Group)<\/em> \u0259mrini se\u00e7in. Yaranm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sind\u0259 S\u00fctunlar<\/strong> (Columns<\/em>) qeyd edin. OK-i bas\u0131n. S\u0259n\u0259din g\u00f6r\u00fcn\u00fc\u015f\u00fcn\u00fcn nec\u0259 d\u0259yi\u015fdiyin\u0259 fikir verin. \u00ab-\u00bb i\u015far\u0259sini bas\u0131n, g\u00f6rd\u00fcy\u00fcn\u00fcz kimi qeyd edil\u0259n s\u00fctunla gizl\u0259dilib. S\u00fctunlar\u0131n yenid\u0259n g\u00f6rs\u0259nm\u0259si \u00fc\u00e7\u00fcn \u00ab+\u00bb i\u015far\u0259sini bas\u0131n. Strukturun silinm\u0259si \u00fc\u00e7\u00fcn m\u00fcvafiq s\u00fctunlar\u0131 qeyd edinVeril\u0259nl\u0259r<\/strong> (Data)<\/em> menyusunda Qrup v\u0259 struktur<\/strong> (Group and Outline) <\/em>altmenyusunu se\u00e7in v\u0259 sonra Qrupla\u015fd\u0131rman\u0131n l\u0259\u011fvi (Ungroup)<\/em> \u0259mrini icra edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi qrupla\u015fd\u0131rma l\u0259\u011fv edildi<\/p>\n

D\u00fcsturlar\u0131n istifad\u0259si.<\/h2>\n

D\u00fcstur-xanaya daxil edil\u0259n riyazi \u0259m\u0259liyyatlar ard\u0131c\u0131ll\u0131\u011f\u0131d\u0131r. D\u00fcsturlar sad\u0259 v\u0259 q\u0131sa, ya da m\u00fcr\u0259kk\u0259b v\u0259 uzun ola bil\u0259rl\u0259r. Misal \u00fc\u00e7\u00fcn i\u015f\u00e7i v\u0259r\u0259qind\u0259 xana qeyd edin v\u0259 d\u00fcstur s\u0259trind\u0259 mauzu bas\u0131n. \u00ab=\u00bb i\u015far\u0259sini daxil edin, bel\u0259 ki, h\u0259r bir d\u00fcstur \u00ab=\u00bb i\u015far\u0259sind\u0259n ba\u015flan\u0131r. Sonra 300+700 daxil edib, Enteri bas\u0131n \u2013 g\u00f6rd\u00fcy\u00fcn\u00fcz kimi, xanada d\u00fcsturun n\u0259tic\u0259si kimi 1 000 \u0259d\u0259di yarand\u0131. \u018fn sad\u0259 c\u0259bri \u0259m\u0259liyyatlar v\u0259ziyy\u0259t s\u0259trinin<\/strong> kontekst menyusundan yerin\u0259 ytiril\u0259 bil\u0259r. \u018fn \u00e7ox istifad\u0259 edil\u0259n \u0259m\u0259liyyatlar \u00ab+\u00bb toplama, \u00ab-\u00bb \u00e7\u0131xma, \u00ab\/\u00bb b\u00f6lm\u0259, \u00ab*\u00bb vurma, \u00ab^\u00bb q\u00fcvv\u0259t\u0259 y\u00fcks\u0259ltm\u0259, \u00ab%\u00bb faizdir. S26:S29 diapazonunu qeyd edin, v\u0259ziyy\u0259t s\u0259trind\u0259 <\/strong>mauzun sa\u011f d\u00fcym\u0259sini basaraq kontekst menyunu \u00e7a\u011f\u0131r\u0131n v\u0259 \u0259d\u0259di orta \u0259m\u0259liyyat\u0131n\u0131 se\u00e7in. Bel\u0259likl\u0259 n\u0259tic\u0259 v\u0259ziyy\u0259t s\u0259tird\u0259<\/strong> g\u00f6rs\u0259nir.<\/p>\n

Avtotoplama funksiyas\u0131ndan istifad\u0259 edin. S30 xanas\u0131n\u0131 qeyd edin v\u0259 al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 yunan h\u0259rfi siqma \u015f\u0259klind\u0259 t\u0259svir edilmi\u015f Avtotoplama d\u00fcym\u0259sini bas\u0131n. Veril\u0259nl\u0259rin q\u0259bul edilm\u0259si \u00fc\u00e7\u00fcn bu d\u00fcym\u0259ni t\u0259krar\u0259n bas\u0131n. Gkranda s\u00fctun veril\u0259nl\u0259rinin c\u0259mi yaranacaq.<\/p>\n

N\u00f6vb\u0259ti misal. E25 xanas\u0131na 800, F27 xanas\u0131na is\u0259 69 daxil edin. G27 xanas\u0131n\u0131 qeyd edin v\u0259 \u00ab=\u00bb daxil edin. 800 \u0259d\u0259dini yazmaq \u0259v\u0259zin\u0259 E25 xanas\u0131nda mauzu basmaq kifay\u0259tdir, sonra \u00ab+\u00bb i\u015far\u0259sini daxil edin v\u0259 F27 xanas\u0131nda mauzu bas\u0131n. \u0130ndi is\u0259 c\u0259min al\u0131nmas\u0131 \u00fc\u00e7\u00fcn Enter d\u00fcym\u0259sini bas\u0131n.<\/p>\n

800 \u0259d\u0259dini 950 il\u0259 \u0259v\u0259z edib Enteri bas\u0131n. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi Exsel avtomatik olaraq n\u0259tic\u0259ni d\u0259yi\u015fdi.<\/p>\n

H\u0259r bir d\u00fcsturun sur\u0259ti \u00e7\u0131xar\u0131la bil\u0259r. S26-n\u0131n yan\u0131ndak\u0131 xanada mauzu bas\u0131n, d\u00fcstur s\u0259trind\u0259 \u00ab=\u00bb i\u015far\u0259si daxil edin v\u0259 yenid\u0259n S26 xanas\u0131nda mauzu bas\u0131n. \u018fd\u0259din yaranmas\u0131ndan sonra q\u00fcvv\u0259t\u0259 y\u00fcks\u0259ltm\u0259 i\u015far\u0259sini v\u0259 3 r\u0259q\u0259mini daxil edin. Enteri bas\u0131n. Xanada n\u0259tic\u0259 al\u0131nd\u0131. Y\u0259ni 24 \u0259d\u0259dinin 3 \u0259sasdan q\u00fcvv\u0259ti hesabland\u0131. \u0130ndi is\u0259 d\u00fcsturun sur\u0259tinin \u00e7\u0131xar\u0131lmas\u0131 \u0259m\u0259liyyat\u0131n\u0131 dig\u0259r qalan xanalar \u00fc\u00e7\u00fcn d\u0259 yerin\u0259 yetirin. Bunun \u00fc\u00e7\u00fcn V26 xanas\u0131nda mauzu bas\u0131n v\u0259 mauzun g\u00f6st\u0259ricisini xanan\u0131n a\u015fa\u011f\u0131 sa\u011f k\u00fcnc\u00fcn\u0259 g\u0259tirin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi g\u00f6st\u0259ricinin i\u015far\u0259si d\u0259yi\u015fdi. N\u0259hay\u0259t mauzun d\u00fcym\u0259si bas\u0131l\u0131 v\u0259ziyy\u0259td\u0259 xanan\u0131 b\u00fct\u00fcn veril\u0259nl\u0259r s\u0131ras\u0131 boyunca \u00e7\u0259kin. Bel\u0259likl\u0259 d\u00fcstur dig\u0259r veril\u0259nl\u0259r \u00fc\u00e7\u00fcn d\u0259 t\u0259tbiq edildi. G\u0259lin bunu yoxlayaq. M\u0259s\u0259l\u0259n B27 xanas\u0131n\u0131 qeyd edin v\u0259 d\u00fcstur s\u0259trin\u0259 fikir verin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi 42875 \u0259d\u0259di S27 xanas\u0131n\u0131n q\u00fcvv\u0259t\u0259 y\u00fcks\u0259ldilm\u0259si n\u0259tic\u0259sind\u0259 al\u0131n\u0131b.<\/p>\n

D\u00fcstur redaktoru il\u0259 i\u015fl\u0259m\u0259k \u00fc\u00e7\u00fcn d\u00fcstur s\u0259trind\u0259 \u00ab=\u00bb i\u015far\u0259sini bas\u0131n, sonra verilmi\u015f d\u00fcstur siyah\u0131s\u0131nda Dig\u0259r funksiyalar\u0131<\/strong> (More Functions)<\/em> se\u00e7in. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, b\u00fct\u00fcn funksiyalar kateqoriyalar \u00fczr\u0259 birl\u0259\u015fdirilib. V\u0259r\u0259qd\u0259 h\u0259r hans\u0131 bir xanan\u0131 qeyd edin. Riyazi v\u0259 triqonometrik funksiyalar kateqoriyas\u0131nda m\u00fctl\u0259q qiym\u0259ti \u00abAVS\u00bb se\u00e7in. Yaranm\u0131\u015f xanada D27 xanas\u0131n\u0131n qiym\u0259tini daxil edin OK-i bas\u0131n. N\u0259tic\u0259d\u0259 \u00ab-55\u00bb \u0259d\u0259dinin m\u00fctl\u0259q qiym\u0259ti yaranacaq.<\/p>\n

Ssenaril\u0259r dispe\u00e7eri.<\/h2>\n

M\u00fcr\u0259kk\u0259b m\u0259s\u0259l\u0259l\u0259rl\u0259 i\u015f zaman\u0131 Ssenaril\u0259r dispe\u00e7eri<\/strong> istifad\u0259 edilir. Burada d\u0259yi\u015f\u0259nl\u0259r \u00e7oxlu\u011funu daxil etm\u0259k vacibdir (32-\u0259 q\u0259d\u0259r). \u00abExercises\u00bb fayl\u0131n\u0131 a\u00e7\u0131n. Xidm\u0259t<\/strong> (Tools)<\/em> menyusundan Ssenari<\/strong> (Scenarios) <\/em>\u0259mrini \u00e7a\u011f\u0131r\u0131n. Ssenaril\u0259r dispe\u00e7eri<\/strong> (Scenario Manager) <\/em>dialoq p\u0259nc\u0259r\u0259sind\u0259 \u018flav\u0259 et<\/strong> (Add)<\/em> d\u00fcym\u0259sini bas\u0131n v\u0259 ssenarinin ad\u0131n\u0131 \u00abdatabase 1\u00bb yaz\u0131n. D\u0259yi\u015f\u0259n xanalar<\/strong> (Changing Cells) <\/em>sah\u0259sind\u0259 C5:C9 diapazonunu g\u00f6st\u0259rin v\u0259 Ok-bas\u0131n. Bu sizin d\u0259yi\u015fm\u0259k ist\u0259diyiniz xanalard\u0131r. Ssenarisinin qiym\u0259tl\u0259ri<\/strong> (Scenario values) <\/em>p\u0259nc\u0259r\u0259si yaranacaq. Bel\u0259 ki, burada veril\u0259nl\u0259r bazas\u0131n\u0131n 1-ci variant\u0131nda g\u00f6st\u0259ril\u0259nl\u0259rd\u0259n f\u0259rqli veril\u0259nl\u0259ri daxil etm\u0259k laz\u0131md\u0131r.H\u0259l\u0259lik he\u00e7 bir d\u0259yi\u015fiklik etm\u0259yin v\u0259 \u018flav\u0259 et<\/strong> (Add)<\/em> d\u00fcym\u0259sini bas\u0131n. \u0130kinci ssenarinin \u00abdatabase 2\u00bb yarad\u0131lmas\u0131 \u00fc\u00e7\u00fcn OK-i bas\u0131n. 4 \u0259v\u0259zin\u0259 2 v\u0259 7-nin \u0259v\u0259zin\u0259 vahid daxil edin \u018flav\u0259 et<\/strong> (Add)<\/em> d\u00fcym\u0259sini bas\u0131n.<\/p>\n

Ssenaril\u0259r dispe\u00e7eri<\/strong> (Scenario Manager)<\/em> p\u0259nc\u0259r\u0259sin\u0259 qay\u0131daraq, siz t\u0259\u015fkil edilmi\u015f ssenaril\u0259rin ad\u0131n\u0131 g\u00f6r\u0259c\u0259ksiz. \u00abdatabase 2\u00bb qeyd edin v\u0259 G\u00f6st\u0259rm\u0259k<\/strong> (Show)<\/em> klavi\u015fini bas\u0131n. Bel\u0259likl\u0259, cari veril\u0259nl\u0259r bazas\u0131n\u0131n \u0259v\u0259zin\u0259 yeni veril\u0259nl\u0259r bazas\u0131 yarand\u0131.<\/p>\n

Parametrl\u0259rin se\u00e7ilm\u0259si.<\/h2>\n

Parametrl\u0259rin se\u00e7ilm\u0259si (Goal seek)<\/em> \u0259mrinin k\u00f6m\u0259yi il\u0259 ist\u0259nil\u0259n n\u0259tic\u0259ni ver\u0259n qeyri m\u0259lum qiym\u0259ti tapmaq olar. F14 xanas\u0131n\u0131 qeyd edin v\u0259 d\u00fcstur s\u0259trind\u0259 g\u0259lirin hesablanmas\u0131 \u00fc\u00e7\u00fcn d\u00fcsturu daxil edin, y\u0259ni \u00ab=\u00bb i\u015far\u0259sind\u0259n sonra =B14*C14*E14*(1-D14) daxil edin v\u0259 Enter-i bas\u0131n. N\u0259tic\u0259d\u0259 biz g\u0259lir kimi 960 qiym\u0259tini ald\u0131q.<\/p>\n

G\u0259lir g\u00f6st\u0259rilmi\u015f xanan\u0131 qeyd edin. M\u0259mulat\u0131n qiym\u0259tini d\u0259yi\u015fm\u0259k yolu il\u0259 ist\u0259diyimiz n\u0259tic\u0259ni alma\u011fa c\u0259hd ed\u0259k. Servis \u00abTools\u00bb menyusunda Parametrl\u0259rin se\u00e7ilm\u0259si<\/strong> (Goal seek)<\/em> \u0259mrini se\u00e7in. Eyni adl\u0131 p\u0259nc\u0259r\u0259d\u0259 Qiym\u0259t<\/strong> (To value)<\/em> sah\u0259sind\u0259 ist\u0259diyimiz g\u0259lir qiym\u0259ti kimi 1500 g\u00f6st\u0259rin, Xanan\u0131 d\u0259yi\u015f\u0259r\u0259k<\/strong> (By changing cell)<\/em> sah\u0259sind\u0259 is\u0259 m\u0259mulat\u0131n qiym\u0259ti xanas\u0131n\u0131 qeyd edin, Ok d\u00fcym\u0259sini bas\u0131n. Bel\u0259likl\u0259, biz ald\u0131q ki, g\u0259lirin 1500 olmas\u0131 \u00fc\u00e7\u00fcn m\u0259mulat\u0131n qiym\u0259ti ne\u00e7\u0259 olmal\u0131d\u0131r.<\/p>\n

Siyah\u0131n\u0131n analizi \u00fc\u00e7\u00fcn filtirl\u0259rin istifad\u0259 edilm\u0259si.<\/h2>\n

Filtrasiya se\u00e7imin \u015f\u0259rtl\u0259rin\u0259 cavab ver\u0259n s\u0259tirl\u0259rin g\u00f6st\u0259rilm\u0259si \u00fc\u00e7\u00fcn \u00e7ox m\u00fcnasibdir. Filtrasiya yaln\u0131z se\u00e7imin \u015f\u0259rtl\u0259rin\u0259 cavab ver\u0259n s\u0259tirl\u0259ri g\u00f6st\u0259rir, yerd\u0259 qalan s\u0259tirl\u0259r is\u0259 g\u00f6rs\u0259nmir. B5-d\u0259n F15-\u0259 q\u0259d\u0259r s\u0259tri qeyd edin, Veril\u0259nl\u0259r<\/strong> (Data)<\/em> menyusundan Filtr<\/strong> (Filter) <\/em>altmenyusunu v\u0259 sonra Avtofiltr<\/strong> (Auto filter)<\/em> \u0259mrini qeyd edin.<\/p>\n

Qeyd edilmi\u015f s\u0259tird\u0259 avtofiltrin d\u00fcym\u0259l\u0259ri yaran\u0131r. D5 xanas\u0131nda avtofiltr d\u00fcym\u0259sini bas\u0131n v\u0259 1,61 qiym\u0259tini se\u00e7in. Bel\u0259likl\u0259, ekranda yaln\u0131z se\u00e7ilmi\u015f \u015f\u0259rt\u0259 cavab ver\u0259n s\u0259tirl\u0259r g\u00f6rs\u0259n\u0259c\u0259k. B\u00fct\u00fcn s\u0259tirl\u0259rin g\u00f6st\u0259rilm\u0259si \u00fc\u00e7\u00fcn Veril\u0259nl\u0259r<\/strong> (Data)<\/em> menyusundan Filtr<\/strong> (Filter) <\/em>altmenyusunu v\u0259 sonra Ham\u0131s\u0131n\u0131 g\u00f6st\u0259r<\/strong> (Show All)<\/em> \u0259mrini se\u00e7in. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi b\u00fct\u00fcn s\u0259tirl\u0259r b\u0259rpa olundu. Avtofiltr<\/strong> (Auto filter)<\/em> \u0259mrini t\u0259krar basmaqla Avtofiltri l\u0259\u011fv etm\u0259k olar.<\/p>\n

Veril\u0259nl\u0259rin nizamlanmas\u0131.<\/h2>\n

Excel nizamlama \u00fc\u00e7\u00fcn m\u00fcxt\u0259lif \u00fcsullar t\u0259klif edir. Siz s\u0259tr v\u0259 ya s\u00fctunlar\u0131 artma v\u0259 ya azalma s\u0131ras\u0131 il\u0259 nizamlaya bil\u0259rsiniz. Nizamlaman\u0131 yerin\u0259 yetirm\u0259k \u00fc\u00e7\u00fcn ilk n\u00f6vb\u0259d\u0259 laz\u0131mi xanalar diapazonunu qeyd edin. M\u0259s\u0259l\u0259n, B5:F15 diapazonunu qeyd edin v\u0259 Veril\u0259nl\u0259r<\/strong> (Data) <\/em>menyusunda Nizamlama<\/strong> (Sort) <\/em>\u0259mrini se\u00e7in. Yaranm\u0131\u015f Nizamlama<\/strong> (Sort)<\/em> dialoq p\u0259nc\u0259r\u0259sind\u0259 m\u00fctl\u0259q nizamlaman\u0131n tipini g\u00f6st\u0259rin, m\u0259s\u0259l\u0259n, Artma s\u0131ras\u0131 il\u0259<\/strong> (Ascending) v\u0259<\/em> OK-i bas\u0131n. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, veril\u0259nl\u0259r s\u00fctunu artma s\u0131ras\u0131 \u00fczr\u0259 nizamland\u0131<\/p>\n

M\u00fcm\u00fck\u00fcn qiym\u0259tl\u0259r.<\/h2>\n

Daxil edil\u0259nl\u0259rin b\u0259zi \u015f\u0259rtl\u0259r\u0259 uy\u011fun g\u0259lm\u0259si \u00fc\u00e7\u00fcn M\u00fcm\u00fck\u00fcn qiym\u0259tl\u0259r<\/strong> (Validation)<\/em> \u0259mrind\u0259n istifad\u0259 etm\u0259k laz\u0131md\u0131r. \u015e\u0259rtin yoxlan\u0131lmas\u0131ndan \u0259vv\u0259l m\u00fctl\u0259q \u015f\u0259rtin daxil edil\u0259c\u0259k xanalar diapazonunu qeyd edin. Veril\u0259nl\u0259r<\/strong> (Data)<\/em> menyusunda M\u00fcm\u00fck\u00fcn qiym\u0259tl\u0259r<\/strong> (Validation)<\/em> \u0259mrini se\u00e7i.<\/p>\n

1-ci Sazlama<\/strong> (Setting)<\/em> s\u0259hif\u0259sinin (Allow)<\/em> sah\u0259sind\u0259 daxil edil\u0259c\u0259k veril\u0259nl\u0259rin tipini g\u00f6st\u0259rm\u0259k laz\u0131md\u0131r. M\u0259s\u0259l\u0259n, Tarix<\/strong> (Date)<\/em>, Veril\u0259nl\u0259r<\/strong> (Data)<\/em> sah\u0259sind\u0259 aras\u0131nda (Between) <\/em>\u015f\u0259rtini se\u00e7in, sonra ba\u015flan\u011f\u0131c tarix kimi 01.09.2000 il, son tarix kimi 05.05.2001 ili m\u00fcvafiq olaraq (Start date)<\/em> (End date)<\/em> sah\u0259l\u0259rin\u0259 daxil edin.<\/p>\n

N\u00f6vb\u0259ti Daxil etm\u0259k \u00fc\u00e7\u00fcn m\u0259\u2019lumat<\/strong> (Input message) <\/em>s\u0259hif\u0259sin\u0259 ke\u00e7in. Burada istifad\u0259\u00e7iy\u0259 izahat g\u00f6st\u0259rm\u0259k olar. S\u0259rl\u00f6vh\u0259<\/strong> (Title)<\/em> sah\u0259sind\u0259 \u0130zahat v\u0259 m\u0259lumat (Input message) <\/em>sah\u0259sind\u0259 \u00abTarix daxil edin\u00bb frazas\u0131n\u0131 daxil edin.<\/p>\n

V\u0259 sonuncu S\u0259hv haqq\u0131nda m\u0259lumat<\/strong> (Error alert) <\/em>s\u0259hif\u0259sind\u0259 veril\u0259nl\u0259rin d\u00fczg\u00fcn daxil edilm\u0259diyi t\u0259qdird\u0259 veril\u0259nl\u0259rin s\u0259hv oldu\u011fu haqda m\u0259lumat g\u00f6st\u0259rilir. M\u0259lumat stili kimi \u00abWarning\u00bb-i se\u00e7in, S\u0259rl\u00f6vh\u0259<\/strong> (Title)<\/em> sah\u0259sin\u0259 \u00abFikir verin\u00bb s\u00f6zl\u0259rini, S\u0259hv haqq\u0131nda m\u0259\u2019lumat<\/strong> (Error message) <\/em>sah\u0259sin\u0259 is\u0259 \u00abDaxil olunanlar d\u00fcz deyil\u00bbdaxil edin. Ok-i bas\u0131n.<\/p>\n

Diqq\u0259t edin, mauzun g\u00f6st\u0259ricisini \u015f\u0259rt daxil edilmi\u015f xanalara yax\u0131nla\u015fd\u0131rd\u0131qda, \u0130stifad\u0259\u00e7i \u00fc\u00e7\u00fcn izahat g\u00f6r\u00fcn\u00fcr. \u0130ndi is\u0259 qoyulmu\u015f \u015f\u0259rtd\u0259n k\u0259nara \u00e7\u0131xan h\u0259r hans\u0131 bir tarixi daxil edin, m\u0259s\u0259l\u0259n, 15.06.2000. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, ekranda s\u0259hv haqq\u0131nda m\u0259lumat yarand\u0131.<\/p>\n

Diaqram v\u0259 qrafikl\u0259r.<\/h2>\n

Diaqram v\u0259 qrafiki qurmazdan \u0259vv\u0259l, m\u00fctl\u0259q diaqrama daxil olan s\u0259tr v\u0259 ya s\u00fctun veril\u0259nl\u0259rini qeyd etm\u0259k laz\u0131md\u0131r. B3:B6 veril\u0259nl\u0259r diapazonunu qeyd edin v\u0259 Standart<\/strong> al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 veril\u0259nl\u0259r diapazonunu qeyd edin. Diaqram<\/strong> (Chart Wizard) <\/em>d\u00fcym\u0259sini bas\u0131n.<\/p>\n

Standart tipl\u0259r (Standatd Types) s\u0259hif\u0259sind\u0259 \u00c7evr\u0259vari diaqram (Pie) se\u00e7in v\u0259 1-ci s\u0131rada m\u0259rk\u0259zi diaqram\u0131 qeyd edin. N\u00f6vb\u0259ti p\u0259nc\u0259r\u0259y\u0259 ke\u00e7m\u0259k \u00fc\u00e7\u00fcn \u0130r\u0259li (Next) d\u00fcym\u0259sini bas\u0131n. \u0130r\u0259li (Next) d\u00fcym\u0259sinin t\u0259krar bas\u0131lmasndan sonra diaqrama ad verilm\u0259si t\u0259klif olunur. Diaqram\u0131n ad\u0131<\/strong> (Chart title)<\/em> sah\u0259sind\u0259 diaqrama Test pie ad\u0131 ver\u0259k. Yenid\u0259n \u0130r\u0259li<\/strong> (Next)<\/em> v\u0259 sonra Son<\/strong> (Finish)<\/em> d\u00fcym\u0259l\u0259rini bas\u0131n.<\/p>\n

Yerin\u0259 yetirilmi\u015f \u0259m\u0259liyyatlar n\u0259tic\u0259sind\u0259 i\u015f\u00e7i v\u0259r\u0259qind\u0259 se\u00e7ilmi\u015f diaqram yaranacaq. Mausun d\u00fcym\u0259si bas\u0131l\u0131 v\u0259ziyy\u0259td\u0259 diaqram\u0131 p\u0259nc\u0259r\u0259nin ist\u0259nil\u0259n dig\u0259r hiss\u0259sin\u0259 yerl\u0259\u015fdirin. \u00c7evr\u0259vari diaqram\u0131n ayr\u0131-ayr\u0131 hiss\u0259l\u0259ri m\u00fcst\u0259qil sah\u0259l\u0259rdir. Bu hiss\u0259l\u0259rd\u0259n h\u0259r hans\u0131 birini qeyd edin v\u0259 mausun d\u00fcym\u0259si bas\u0131l\u0131 v\u0259ziyy\u0259td\u0259 qeyd edilmi\u015f hiss\u0259ni diaqramdan ay\u0131r\u0131n.<\/p>\n

Diaqram\u0131 b\u00fct\u00f6vl\u00fckl\u0259 qeyd edin v\u0259 kontekst menyudan Veril\u0259nl\u0259rin formatla\u015fd\u0131r\u0131lmas\u0131<\/strong> (Format data series)<\/em> \u0259mrini se\u00e7in. Eyni adl\u0131 diaqram p\u0259nc\u0259r\u0259sinin Veril\u0259nl\u0259rin qeydi<\/strong> (Data labels) <\/em>s\u0259hif\u0259sind\u0259 Faizl\u0259 g\u00f6st\u0259r<\/strong> (Show percent)<\/em> variant\u0131n\u0131 se\u00e7in v\u0259 OK-i s\u0131xmaqla \u0259mri t\u0259sdiq edin. Fikir verin veril\u0259nl\u0259rin faiz as\u0131l\u0131l\u0131\u011f\u0131 g\u00f6st\u0259rilmi\u015fdir.<\/p>\n

\u018flav\u0259 qiym\u0259tl\u0259rin daxil edilm\u0259si \u00fc\u00e7\u00fcn veril\u0259nl\u0259ri qeyd edib Sur\u0259tini<\/strong> \u00e7\u0131xar\u0131b<\/strong> (Copy)<\/em> v\u0259 diaqrama Yerl\u0259\u015fdirm\u0259k<\/strong> (Paste)<\/em> kifay\u0259tdir.<\/p>\n

Diaqram\u0131 l\u0259\u011fv etm\u0259k \u00e7ox asand\u0131r. Bunun \u00fc\u00e7\u00fcn diaqram\u0131 qeyd edib, klaviaturada olan Delete<\/strong> klavi\u015fini basmaq kifay\u0259tdir.<\/p>\n

Kitab\u0131n yarad\u0131lmas\u0131, a\u00e7\u0131lmas\u0131 v\u0259 ba\u011flanmas\u0131.<\/h2>\n

Menyu s\u0259trind\u0259n Fayl<\/strong> b\u00f6lm\u0259sini se\u00e7in. A\u00e7\u0131lm\u0131\u015f menyu s\u0259hif\u0259sind\u0259 Ba\u011flamaq<\/strong> (Close)<\/em> \u0259mrini se\u00e7in. Yerin\u0259 yetirilmi\u015f \u0259m\u0259liyyat n\u0259tic\u0259sind\u0259 cari kitab ba\u011flanacaq. Kitab\u0131 ba\u011flamazdan \u0259vv\u0259l veril\u0259nl\u0259ri saxlamaq m\u0259sl\u0259h\u0259tdir.<\/p>\n

Yeni i\u015f\u00e7i kitab\u0131n\u0131n yarad\u0131lmas\u0131 \u00fc\u00e7\u00fcn Standart<\/strong> al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 olan Yeni<\/strong> (New)<\/em> d\u00fcym\u0259sind\u0259n d\u0259 istifad\u0259 etm\u0259k olar. Standart<\/strong> al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 Yeni<\/strong> (New)<\/em> d\u00fcym\u0259sini bas\u0131n. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi yeni s\u0259n\u0259d yarand\u0131. Yadda saxlan\u0131lm\u0131\u015f fayllara baxmaq \u00fc\u00e7\u00fcn al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 A\u00e7maq<\/strong> (Open)<\/em> d\u00fcym\u0259sini bas\u0131n. N\u0259tic\u0259d\u0259 Exsel redaktorunda yarad\u0131lm\u0131\u015f fayllar\u0131n siyah\u0131s\u0131 a\u00e7\u0131lacaq v\u0259 siz bu siyah\u0131dan ist\u0259diyiniz fayl\u0131 ekrana \u00e7a\u011f\u0131ra bil\u0259rsiniz. Ba\u011flamaq<\/strong> (X)<\/em> d\u00fcym\u0259si d\u0259 h\u0259m\u00e7inin bax\u0131lan fayl\u0131 ba\u011flay\u0131r. Redaktorun p\u0259nc\u0259r\u0259sinin yuxar\u0131 sa\u011f k\u00fcnc\u00fcnd\u0259 yerl\u0259\u015f\u0259n bu d\u00fcym\u0259ni basmaqla kitab\u0131 ba\u011flay\u0131n. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi, redaktorun p\u0259nc\u0259r\u0259si bo\u015fald\u0131.<\/p>\n

Redaktorun \u00f6z\u00fcn\u00fc ba\u011flamaq \u00fc\u00e7\u00fcn Fayl menyusunu a\u00e7\u0131n v\u0259 \u00c7\u0131x\u0131\u015f<\/strong> (Exit)<\/em>\u0259mrini se\u00e7in.<\/p>\n

\u0130\u015f\u00e7i kitab\u0131n yadda saxlan\u0131lmas\u0131.<\/h2>\n

Exsel kitab\u0131n\u0131n yadda saxlan\u0131lmas\u0131 \u00fc\u00e7\u00fcn Fayl<\/strong> menyusunu a\u00e7\u0131n v\u0259 Yadda saxlamaq<\/strong> (Save)<\/em> \u0259mrini se\u00e7in. A\u00e7\u0131lm\u0131\u015f eyni adl\u0131 dialoq p\u0259nc\u0259r\u0259sinin Fayl\u0131n ad\u0131<\/strong> (File Name) <\/em>sah\u0259sind\u0259 fayl\u0131n ad\u0131n\u0131 \u00abTest\u00bb<\/strong> yaz\u0131n, menyu s\u0259trind\u0259n Xidm\u0259t<\/strong> (Tools)<\/em> d\u00fcym\u0259sini bas\u0131n. A\u00e7\u0131lm\u0131\u015f menyu s\u0259hif\u0259sind\u0259n \u00dcmumi<\/strong> parametrl\u0259ri<\/strong> (General options)<\/em> -u se\u00e7in. N\u0259tic\u0259d\u0259 Yadda saxlaman\u0131n parametrl\u0259ri<\/strong> (Save options)<\/em> dialoq p\u0259nc\u0259r\u0259si yaranacaq. Burada Fayl\u0131n a\u00e7\u0131lmas\u0131 \u00fc\u00e7\u00fcn parol<\/strong> (Password to open)<\/em> v\u0259 D\u0259yi\u015fiklikl\u0259rin daxil edilm\u0259si \u00fc\u00e7\u00fcn parol<\/strong> (Password to modify)<\/em> daxil etm\u0259k olar. T\u0259kzib<\/strong> (Cancel)<\/em> d\u00fcym\u0259sini bas\u0131n. Siz yenid\u0259n Yadda saxlama<\/strong> (Save)<\/em> p\u0259nc\u0259r\u0259sin\u0259 qay\u0131dacaqs\u0131n\u0131z. Yadda saxlama<\/strong> (Save)<\/em> d\u00fcym\u0259sini bas\u0131n v\u0259 ya sad\u0259c\u0259 olaraq Enter \u2013i bas\u0131n. S\u0259rl\u00f6vh\u0259 s\u0259trind\u0259 kitab\u0131n ad\u0131n\u0131n nec\u0259 d\u0259yi\u015fdiyin\u0259 fikir verin.<\/p>\n

\u0130st\u0259yiniz\u0259 m\u00fcvafiq olaraq Fayl<\/strong> menyusunda Hans\u0131 adla yadda saxlamaq<\/strong> (Save As)<\/em> \u0259mrind\u0259n istifad\u0259 ed\u0259r\u0259k h\u0259min fayl\u0131n sur\u0259tini yaratmaq olar.<\/p>\n

Fayla b\u0259zi d\u0259y\u0259i\u015fiklikl\u0259r daxil edin. Al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 Yadda saxlama<\/strong> (Save)<\/em> \u0259mrini se\u00e7in, fayl\u0131n ad\u0131 sah\u0259sin\u0259 yeni ad yaz\u0131n. Bel\u0259likl\u0259 siz fayl\u0131n sur\u0259tini yaratm\u0131\u015f oldunuz.<\/p>\n

S\u0259n\u0259d\u0259 bax\u0131\u015f recimi, s\u0259hif\u0259nin parametrl\u0259ri v\u0259 \u00e7ap\u0131.<\/h2>\n

S\u0259n\u0259di \u00e7ap etm\u0259zd\u0259n \u0259vv\u0259l h\u0259min s\u0259n\u0259di S\u0259n\u0259d\u0259 \u00e7apdan \u0259vv\u0259l bax\u0131\u015f <\/strong>(Print Preview)<\/em> reciminin k\u00f6m\u0259yi il\u0259 g\u00f6zd\u0259n ke\u00e7irm\u0259k t\u00f6vsiyy\u0259 olunur. S\u0259n\u0259d\u0259 \u00e7apdan \u0259vv\u0259l bax\u0131\u015f <\/strong>(Print Preview)<\/em> d\u00fcym\u0259sini bas\u0131n v\u0259 s\u0259n\u0259dinizin nec\u0259 g\u00f6r\u00fcn\u0259c\u0259yin\u0259 bax\u0131n. Ba\u011flamaq<\/strong> (Close) <\/em>d\u00fcym\u0259sini basmaqla i\u015f\u00e7i sah\u0259sin\u0259 geri qay\u0131tmaq olar.<\/p>\n

\u0130\u015f\u00e7i v\u0259r\u0259qin g\u00f6r\u00fcn\u00fc\u015f\u00fcn\u0259 fikir verin. Q\u0131r\u0131q x\u0259tl\u0259 v\u0259r\u0259qin s\u0259rh\u0259ddi g\u00f6st\u0259rilmi\u015fdir. Bu \u0259m\u0259liyyat yaln\u0131z m\u00fcvafiq sah\u0259nin aktivl\u0259\u015fdirilm\u0259si zaman\u0131 ba\u015f verir. Bunun \u00fc\u00e7\u00fcn Xidm\u0259t<\/strong> (Tools)<\/em>menyusunu se\u00e7in v\u0259 a\u00e7\u0131lm\u0131\u015f menyu p\u0259nc\u0259r\u0259sind\u0259 Parametrl\u0259r<\/strong> (Options)<\/em> \u0259mrini se\u00e7in. Yaranm\u0131\u015f Parametrl\u0259r<\/strong> (Options)<\/em> dialoq p\u0259nc\u0259r\u0259sinin G\u00f6r\u00fcn\u00fc\u015f<\/strong> (View) <\/em>s\u0259hif\u0259sind\u0259 S\u0259hif\u0259l\u0259rin b\u00f6lg\u00fcs\u00fc (Page breaks)<\/em> sah\u0259sinin aktivl\u0259\u015fdirin. Bel\u0259 ki, yaln\u0131z bundan sonra i\u015f\u00e7i v\u0259r\u0259qind\u0259 q\u0131r\u0131q x\u0259tl\u0259r yaran\u0131r. V\u0259r\u0259qin \u00f6l\u00e7\u00fcs\u00fc m\u00fcvafiq sazlamalarla yerin\u0259 yetirilir., m\u0259s\u0259l\u0259n sah\u0259nin se\u00e7ilm\u0259si, v\u0259r\u0259qin \u00f6l\u00e7\u00fcs\u00fc v\u0259 s.<\/p>\n

Fayl<\/strong> menyusundan \u00c7ap<\/strong> (Print) <\/em>\u0259mrini se\u00e7in. A\u00e7\u0131lm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sind\u0259 S\u0259hif\u0259l\u0259ri<\/strong> (Pages)<\/em> qeyd edin v\u0259 1-5 diapazonunu g\u00f6st\u0259rin. Sur\u0259tl\u0259rin say\u0131 <\/strong>(Number of copies) <\/em>sah\u0259sind\u0259 2 daxil edin. X\u00fcsusiyy\u0259tl\u0259r<\/strong> (Poperties) <\/em>d\u00fcym\u0259sini basmaqla A4 farmatl\u0131 v\u0259r\u0259q se\u00e7in. Bel\u0259likl\u0259 OK-i basd\u0131qdan sonra 1-d\u0259n 5-\u0259 q\u0259d\u0259r v\u0259r\u0259ql\u0259r 2 n\u00fcsx\u0259d\u0259 \u00e7ap edil\u0259c\u0259k.<\/p>\n

S\u0259hif\u0259nin parametrl\u0259ri il\u0259 i\u015fl\u0259m\u0259k \u00fc\u00e7\u00fcn Fayl \u00abFile\u00bb menyusunda S\u0259hif\u0259nin parametrl\u0259ri<\/strong> (Page setup)<\/em> \u0259mrini se\u00e7in. Yaranm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sinin S\u0259hif\u0259<\/strong> (Page)<\/em> s\u0259hif\u0259sind\u0259 Kitab<\/strong> (Portrait) <\/em>istiqam\u0259tini qeyd edin v\u0259 V\u0259r\u0259qin \u00f6l\u00e7\u00fcs\u00fc<\/strong> (Paper size)<\/em> sah\u0259sind\u0259 A4 format\u0131n\u0131 se\u00e7in.<\/p>\n

N\u00f6vb\u0259ti Ha\u015fiy\u0259y\u0259<\/strong> (Margins)<\/em> s\u0259hif\u0259sin\u0259 ke\u00e7in. Yuxar\u0131 sah\u0259 (Top)<\/em> \u00fc\u00e7\u00fcn 2 sm, A\u015fa\u011f\u0131 sah\u0259 (Bottom) \u00fc\u00e7\u00fcn 2 sm, Sol sah\u0259<\/strong> (Left) <\/em>\u00fc\u00e7\u00fcn 2,5 sm, Sa\u011f sah\u0259 (Right) \u00fc\u00e7\u00fcn 1 sm m\u00fc\u0259yy\u0259n edin.<\/p>\n

Yuxar\u0131 v\u0259 a\u015fa\u011f\u0131 kalontitullar<\/strong> (Header\/Footer) <\/em>b\u00f6lm\u0259sind\u0259 X\u00fcsusi kalontitul<\/strong> (Custom Header)<\/em> d\u00fcym\u0259sini bas\u0131n, g\u00f6rd\u00fcy\u00fcn\u00fcz kimi, dialoq p\u0259nc\u0259r\u0259si yarand\u0131. Burada kalontitul kimi istifad\u0259 edil\u0259c\u0259k ifad\u0259l\u0259rin daxil edilm\u0259si vacibdir.<\/p>\n

Sol b\u00f6lm\u0259ni<\/strong> (Left selection)<\/em> qeyd edin v\u0259 klaviaturadan \u00abBak\u0131 ETM\u00bb s\u00f6zl\u0259rini daxil edin, sonra al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 soldan 2-ci d\u00fcym\u0259ni basmaqla s\u0259hif\u0259nin n\u00f6mr\u0259sini daxil edin. N\u0259hay\u0259t sonuncu 3-c\u00fc sah\u0259d\u0259, y\u0259ni Sa\u011f b\u00f6lm\u0259d\u0259<\/strong> (Right selection)<\/em> s\u0259hif\u0259l\u0259rin \u00fcmumi say\u0131n\u0131 g\u00f6st\u0259rm\u0259k \u00fc\u00e7\u00fcn 3-c\u00fc d\u00fcym\u0259ni bas\u0131n. Yerin\u0259 yetiril\u0259n \u0259m\u0259liyyatlar\u0131n t\u0259sdiqi kimi OK-i bas\u0131n.<\/p>\n

Mausun g\u00f6st\u0259ricisini S\u0259n\u0259d\u0259 \u00e7apdan \u0259vv\u0259l bax\u0131\u015f <\/strong>(Print Preview)<\/em> d\u00fcym\u0259sin\u0259 yaxnla\u015fd\u0131r\u0131n v\u0259 bas\u0131n. Bax\u0131\u015f<\/strong> (Print Preview)<\/em> p\u0259nc\u0259r\u0259sind\u0259 siz qura\u015fd\u0131r\u0131lm\u0131\u015f kalontitullar\u0131 g\u00f6r\u00fcrs\u00fcz.<\/p>\n

\u0130\u015f\u00e7i v\u0259r\u0259qin formala\u015fd\u0131r\u0131lmas\u0131.<\/h2>\n

Veril\u0259nl\u0259r c\u0259dv\u0259lin\u0259 diqq\u0259t edin. V22 xanas\u0131na 1 ne\u00e7\u0259 s\u0259tird\u0259n ibar\u0259t olan ifad\u0259 yaz\u0131lm\u0131\u015fd\u0131r. Bu effekt Xanalar\u0131n formatla\u015fd\u0131r\u0131lmas\u0131<\/strong> (Format cells) <\/em>dialoq p\u0259nc\u0259r\u0259sinin D\u00fczl\u0259nm\u0259<\/strong> (Alignment) <\/em>s\u0259hif\u0259sind\u0259 M\u0259tni ke\u00e7irm\u0259k<\/strong> (Wrop Text)<\/em> sah\u0259sinin aktivl\u0259\u015fdirilm\u0259si il\u0259 h\u0259yata ke\u00e7irilir..<\/p>\n

B20:D24 diapazonunu qeyd edin v\u0259 kontekst menyudan Xanalar\u0131n<\/strong> formatla\u015fd\u0131r\u0131lmas\u0131<\/strong> (Format cells)<\/em> \u0259mirini \u00e7a\u011f\u0131r\u0131n, \u015erift<\/strong> (Font)<\/em> s\u0259hif\u0259sin\u0259 ke\u00e7in v\u0259 sadalanan \u015friftl\u0259rin siyah\u0131s\u0131ndan h\u0259r hans\u0131 birini se\u00e7in, \u015friftin \u00f6l\u00e7\u00fcs\u00fcn\u00fc 14-\u0259 d\u0259yi\u015fin v\u0259 Qal\u0131n maili stili<\/strong> (Bold italic)<\/em> se\u00e7in OK-i bas\u0131n.<\/p>\n

B19:D19 diapazonunu qeyd edin, Formatla\u015fd\u0131rma al\u0259tl\u0259r l\u00f6vh\u0259sind\u0259 ha\u015fiy\u0259 d\u00fcym\u0259sini bas\u0131n v\u0259 qeyd edilmi\u015f fraqment \u00fc\u00e7\u00fcn 2 qat x\u0259tti se\u00e7in.<\/p>\n

\u0130ndi is\u0259 B20:D20 diapazonunu qeyd edin, Xanalar\u0131n formatla\u015fd\u0131r\u0131lmas\u0131<\/strong> (Format cells) <\/em>p\u0259nc\u0259r\u0259sinin Nax\u0131\u015flar<\/strong> (Pattern) <\/em>b\u00f6lm\u0259sind\u0259 b\u0259n\u00f6v\u015f\u0259yi r\u0259ngi qeyd edin, B22:D22 v\u0259 B24:D24 diapazonlar\u0131n\u0131 da m\u00fcvafiq olaraq formala\u015fd\u0131r\u0131n. C\u0259dv\u0259lin g\u00f6r\u00fcn\u00fc\u015f\u00fcn\u00fcn nec\u0259 d\u0259yi\u015fdiyin\u0259 fikir verin.<\/p>\n

Yerl\u0259\u015fdirm\u0259k<\/strong> (Insert) <\/em>menyusunda Hiper\u0259laq\u0259<\/strong> (Hyperlink) <\/em>\u0259mrini se\u00e7in. Hiper\u0259laq\u0259nin yerl\u015fdirilm\u0259si<\/strong> (Insert Hyperlink)<\/em> p\u0259nc\u0259r\u0259sind\u0259 \u00abWWW.BSTC.AZERI.COM\u00bb daxil edin v\u0259 OK-i bas\u0131n. Aktiv xanada yaranan \u0259laq\u0259y\u0259 diqq\u0259t edin. Bu hiper\u0259laq\u0259ni basmaqla siz Bak\u0131 Elmi-T\u0259dris M\u0259rk\u0259zinin web- s\u0259hif\u0259sini a\u00e7m\u0131\u015f olursunuz.<\/p>\n

\u0130\u015f\u00e7i kitab\u0131n m\u00fchafiz\u0259si.<\/h2>\n

\u0130\u015f\u00e7i v\u0259r\u0259qin\u0259 daxil edil\u0259nl\u0259rin m\u00fchafiz\u0259si \u00fc\u00e7\u00fcn menyu s\u0259trind\u0259n Xidm\u0259t<\/strong> (Tools) <\/em>b\u00f6lm\u0259sini se\u00e7in. A\u00e7\u0131lm\u0131\u015f menyu s\u0259hif\u0259sind\u0259n M\u00fchafiz\u0259<\/strong> (Protection)<\/em> altmenyusunu v\u0259 sonra V\u0259r\u0259qin m\u00fchafiz\u0259si<\/strong> (Protect Sheet)<\/em> \u0259mrini se\u00e7in. \u0130\u015f\u00e7i v\u0259r\u0259qin\u0259 daxil edil\u0259n b\u00fct\u00fcn veril\u0259nl\u0259rin m\u00fchafiz\u0259si \u00fc\u00e7\u00fcn a\u00e7\u0131lm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sind\u0259 3 variant\u0131n 3-n\u00fc d\u0259 saxlay\u0131n. Dialoq p\u0259nc\u0259r\u0259sinin Parol<\/strong> (Password) <\/em>sah\u0259sind\u0259 BSTC daxil edin. Ok- bas\u0131n v\u0259 Parolun t\u0259sdiqi <\/strong>(Confirm Password)<\/em> p\u0259nc\u0259r\u0259sind\u0259 h\u0259min s\u00f6z\u00fc t\u0259krar edin. Bl\u0259likl\u0259 i\u015f\u00e7i v\u0259r\u0259qi m\u00fchafiz\u0259 olunub. \u0130\u015f\u00e7i v\u0259r\u0259qind\u0259 qiym\u0259tl\u0259ri d\u0259yi\u015fdirm\u0259y\u0259 v\u0259 ya yeni veril\u0259nl\u0259r daxil etm\u0259y\u0259 c\u0259hd edin. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi he\u00e7 bir d\u0259yi\u015fiklik etm\u0259 m\u00fcmk\u00fcn deyil.<\/p>\n

\u0130\u015f\u00e7i kitab\u0131n m\u00fchafiz\u0259si \u00fc\u00e7\u00fcn M\u00fchafiz\u0259<\/strong> (Protection) <\/em>altmenyusunun \u0130\u015f\u00e7i kitab\u0131n m\u00fchafiz\u0259si<\/strong> (Protect Workbook) <\/em>\u0259mri istifad\u0259 edilir. Yaranm\u0131\u015f dialoq p\u0259nc\u0259r\u0259sinin Parol<\/strong> (Password) <\/em>sah\u0259sind\u0259 Bak.ETM daxil edin . Parolun t\u0259sdiqi<\/strong> (Confirm Password) <\/em>p\u0259nc\u0259r\u0259sind\u0259 Bak. ETM-ni t\u0259krar edin. Art\u0131q Kitab m\u00fchafiz\u0259 olunub. \u0130ndi siz d\u0259yi\u015fiklikl\u0259ri yaln\u0131z xanalara daxil ed\u0259 bil\u0259rsiniz, lakin kitab\u0131n strukturu d\u0259yi\u015fm\u0259z qal\u0131r.<\/p>\n

Mausun g\u00f6st\u0259ricisini i\u015f\u00e7i v\u0259r\u0259ql\u0259rin siyah\u0131s\u0131na g\u0259tirin v\u0259 mausun sa\u011f d\u00fcym\u0259sind\u0259n kontekst menyunu \u00e7a\u011f\u0131r\u0131n. G\u00f6rd\u00fcy\u00fcn\u00fcz kimi art\u0131q v\u0259r\u0259qin l\u0259\u011fv edilm\u0259si, ad\u0131n\u0131n d\u0259yi\u015fdirilm\u0259si, yeni v\u0259r\u0259qin yerl\u0259\u015fdirilm\u0259si \u0259mrl\u0259ri i\u015fl\u0259mir.<\/p>\n

M\u00fchafiz\u0259<\/strong> (Protection) <\/em>\u0259mrinin l\u0259\u011fvi M\u00fchafiz\u0259nin l\u0259\u011fvi<\/strong> (Unprotect workbook) <\/em>\u0259mrinin k\u00f6m\u0259yil\u0259 h\u0259yata ke\u00e7irilir.<\/p>\n

 <\/p><\/blockquote>\n

 <\/p>\n

<\/div>
\r\n