Ukujikeleza amanani e-Excel: 4 ifashoni yokusebenza

Xa iCandelo lokwenza okanye ukusebenza ngamanani aqhekekileyo, i-Excel ivelise ngokujikeleza. Oku kungenziwa, okokuqala, ngento yokuba amanani achanekileyo achanekileyo anqabile xa kufanelekile, kodwa ayikho intsingiselo yokusebenza ngentetho eninzi emva kwekoma. Ukongeza, kukho amanani ngokomgaqo engajikeleziswanga ngokuchanekileyo. Kwangelo xesha, ukujikeleza okungapheliyo kunokukhokelela kwiimpazamo ezimbi kwiimeko apho kufuneka khona. Ngethamsanqa, le nkqubo inethuba lokufaka abasebenzisi ngokwabo, ukuba amanani aya kuqhutywa njani.

Iimpawu zeNombolo yokuHamba i-Excel

Onke amanani asebenza ngayo i-Excel ye-Excel zahlulwe zaba zichanekile kwaye ziqikelela. Inkumbulo igcinwe kwimemori yokuya kuthi ga kwi-15 yokukhupha, kwaye iboniswe ngaphambi kokukhululwa, eziya kubonisa umsebenzisi ngokwako. Zonke izibalo zenziwa ngokokugcinwa kwimemori, kwaye ayiboniswanga kwi-datage yedatha.

Sebenzisa umsebenzi wokujikeleza, ukulahla inani elithile le-semicolons. Isebenzisa indlela eyamkelweyo ngokubanzi yokujikeleza, xa inani lingaphantsi kwe-5 lijikelezwe kwicala elincinci, nangaphezulu okanye lilingana ne-5 - kwelinye icala.

Ukujikeleza ngamaqhosha kwi-ribbon

Eyona ndlela ilula yokutshintsha ukujikeleza kukuqaqambisa iseli okanye iqela leeseli kwaye, ngelixa kwithebhu yasekhaya, cofa kwi-tepi "okanye" ukunciphisa ukukhulu ". Omabini amaqhosha abekwe kwi-Toolbar "yenombolo". Inombolo kuphela ebonisiweyo iya kubhangiswa, kodwa iqulathe, ukuba kukho imfuneko, ukuya kuthi ga kwiinombolo ezili-15 zamanani aza kubandakanyeka.

Xa ucofa kwiqhosha elithi "Yandisa", inani labalinganiswa ezenziwe emva kokuba ikoma inyuswe.

Iqhosha "lokunciphisa kancinci, ngokulandelelana, linciphisa inani elinye lamanani emva kwekoma.

Ukujikeleza ngefomathi yeseli

Kuyenzeka ukuba ubeke ukujikeleza usebenzisa useto lwefowuni. Ukwenza oku, khetha uluhlu lweeseli kwiphepha, cofa kwiqhosha lasekunene lemouse kwaye ukhethe "ifomathi yeseli" kwimenyu ebonakalayo.

Kwiseto yefomathi yefomathi evula, yiya kwithebhu "yenombolo". Ukuba ifomati yedatha ayichazwanga, kuyimfuneko ukuba ikhuphe, kungenjalo awuyi kuba nakho ukulawula ukujikeleza. Kwinxalenye ephakathi yefestile kufutshane nombhalo "Inani leempawu zokugqibela" zibonisa nje inani leempawu ofuna ukuzibona xa ujikeleza. Emva koko sebenzisa utshintsho.

Ukuseta ukubalwa okucokisekileyo

Ukuba kwiimeko zangaphambili, iiparamitha ezibekiweyo zichaphazela kuphela umboniso wedatha yangaphandle, kwaye ngexesha lokubala, izikhombisi ezichanekileyo zisetyenzisiwe (ukuya kuthi ga kwi-15 yeempawu ezichanekileyo), ngoku siza kukuxelela indlela yokutshintsha ukubala.

1. Cofa ithebhu yefayile ukusuka apho icandelo "leparamitha".



2. Ifestile ye-Excel Ifestile ivuliwe. Ngale festile, yiya kwicandelwana "ngokuzithandela". Beka ibhloko yebhlokhi ebizwa ngokuba "xa uphinde ufundise le ncwadi". Izicwangciso kule bhloko azifakwanga kwiphepha elinye, kodwa kwincwadi iyonke, oko kukuthi, kuyo yonke ifayile. Beka ibhokisi yokukhangela phambi kwe "Ukuchaneka njengoko kwi-screen" parameter kwaye ucofe Kulungile.



3. Ngoku, xa ubala le datha, inombolo ebonisiweyo kwiscreen iya kuthathelwa ingqalelo, kwaye ayisiyo igcinwe kwimemori ye-Excel. Ukuseta kwenombolo ebonisiweyo kunokwenziwa ngayo nayiphi na kwezi ndlela zimbini sithethe ngaphezulu.

Ukusetyenziswa kwemisebenzi

Ukuba ufuna ukutshintsha ixabiso lokujikeleza kubalo olunye okanye ezingaphezulu, kodwa ungafuni ukunciphisa ukuchaneka kokubala ngokubanzi kuxwebhu, kwimeko apho kungcono ukusebenzisa amandla e-"edikiweyo" kunye nokwahluka kwayo ezahlukeneyo, kunye neminye imisebenzi.

Phakathi kwemisebenzi ephambili elawula ukujikeleza kufuneka yabelwe ngolu hlobo lulandelayo:

• "Ijikelezwe" -ijikeleze kwinani elichaziweyo leempawu zomfanekiso okwisiqinisekiso ngokwemigaqo ejikelezayo ngokubanzi;
• "Isithili semfundo" -ijikeleza ukuya kuthi ga kwimodyuli ekufutshane;
• "I-Roundlice" -ijikeleza ukuya kwinombolo ekufutshane kwimodyuli;
• "Ijikelezwe" -ijikeleza inani elichanekileyo;
• "I-Okrwp" -ijikeleza inombolo echanekileyo yemodyuli;
• "I-Okrvnis" - ijikeleza imodyuli yenombolo echanekileyo;
• "I-OTBR" -ijikeleza idatha kwinani elipheleleyo;
• "Inkundla" - ijikeleze idatha kwindawo ekufutshane ne
• Msgstr "UMXHOLO" - ujikeleze idatha kwinani elikufuphi.

Imisebenzi ye "Direct", "i-Rotwylier" kwaye "iRoundlice" isebenzisa le fomathi ilandelayo: Igama lomsebenzi (inombolo; inani leeyunithi). Oko kukuthi, ukuba, ukuba, umzekelo, ufuna ukujikeleza inani le-2,56896 ukuya kumanani amathathu, emva koko sebenzisa umsebenzi "ujikelezwe (2,56896; 3)". Ngenxa yoko, kuyavela inani le-2,569.

Kwimisebenzi ethi "Isikhokelo", "Okrwp" kunye "okrvis" Oku kusetyenziswa yifomula yokujikeleza: igama lomsebenzi (linga). Ke, ukujikeleza inani le-11 ukuya kwinani elikufutshane, ngokubalulekileyo 2, sifaka "isithili (11; 2)". Iziphumo zifumana isiphumo 12.

Imisebenzi "yeBrithi", "ne" kwaye "iyunifomu" Sebenzisa le fomathi ilandelayo: Igama lomsebenzi (inombolo). Ukujikeleza inani le-17 kweyona nto ikufutshane, sisebenzisa "iNkundla ye-17 (17)". Sifumana iziphumo 18.

Umsebenzi ungafakwa kwiseli nangomqolo wokusebenza, emva kokukhetha iseli apho kuya kuba khona. Phambi kokuba ngamnye amiselwe "=".

Kukho indlela eyahlukileyo eyahlukileyo yokwazisa imisebenzi ejikelezayo. Kuyinto efanelekileyo ukuyisebenzisa xa kukho itafile enamaxabiso odinga ukuguqula ngamanani ajikelezileyo kwikholamu eyahlukileyo.

1. Yiya kwithebhu "formulas" kwaye ucofe iqhosha "leMathematics". Kuluhlu oluvula, khetha umsebenzi ofanelekileyo, umzekelo, "wajikeleza".



2. Emva koko, impikiswano yomsebenzi ivula. Kwintsimi "yenombolo", ungangena ngesandla, kodwa ukuba sifuna ukujikeleza idatha yetafile yonke, emva koko ucofe kwiqhosha lefestile yedatha yedatha.



3. Iwindow yempikiswano yomsebenzi isongelwe. Ngoku nqakraza kwiseli ephezulu yekhonkco ledatha esijikelezileyo. Emva kokuba ixabiso lifakwe efestileni, cofa kwiqhosha ngasekunene kwexabiso.



4. Ifestile yomsebenzi iwindows kwakhona ivula. "Inani le-diserges", bhala kancinci apho kufuneka sisike amaqhezu kwaye sisebenzise utshintsho.



5. Inani elijikelezwe. Ukwenzela ukujikeleza kwaye yonke enye idatha yekholamu enqwenelekayo, yiza nesikhombisi kwikona esezantsi ngasekunene kweseli enexabiso lemouse, ucofe iqhosha lemouse lasekhohlo, kwaye usolule ezantsi kwetafile.



6. Ngoku zonke iinqobo ezisemgangathweni ziya kujikelezwa.

Njengoko ubona, zimbini iindlela eziphambili zokujikeleza umboniso obonakalayo wenani: Sebenzisa iqhosha le-teipe nangokutshintsha iiparamitha zefomathi yefowuni. Ukongeza, unokutshintsha ukujikeleza kwedatha ebalwa. Ingakwenziwa ngeendlela ezahlukeneyo: Guqula useto lwencwadi xa iyonke okanye ukusetyenziswa kwemisebenzi ekhethekileyo. Ukukhetha kwendlela ethile kuxhomekeke ekubeni uza kufaka isicelo esifanayo sokujikeleza yonke idatha kwifayile okanye kuluhlu oluthile lweeseli.