Ukusebenza ngohlu olunamagama ku-Microsoft Excel

Elinye lamathuluzi enza lula umsebenzi ngamafomula futhi likuvumela ukuthi wenze umsebenzi usebenze kahle ngama-arrows wedatha ukuqamba la ma arrows. Ngakho-ke, uma ufuna ukubheka uhla lwedatha enkudlwana, ngeke udinge ukuthi ubhale isixhumanisi esiyinkimbinkimbi, kepha kunalokho khombisa igama elilula ukuthi wena ngokwakho uqokile uhlu oluthile. Ake sibheke ama-nuances ayisisekelo nezinzuzo zokusebenza ngamagama aqanjiwe.

Ukuqanjwa Kwendawo Yendawo

Ibanga eliqanjwe igama lesifunda ngumsebenzisi osinikeze igama elithile. Ngaso leso sikhathi, leli gama libhekwa yi-Excel njengekheli lendawo echaziwe. Ingasetshenziswa njengengxenye yamafomula omsebenzi kanye nokuphikisana, nakumathuluzi akhethekile we-Excel, ngokwesibonelo, Bheka Amanani.

Kunezidingo eziphoqelekile zegama leqembu lamaseli:

• Akufanele kube khona izikhala kukho;
• Kumele iqale ngencwadi;
• Ubude bawo akumele bube ngaphezu kwezinhlamvu ezingama-255;
• Akumelwe kuvezwe abaxhumanisi befomu A1 noma R1C1;
• Incwadi akufanele ibe negama elifanayo.

Igama lendawo yeseli lingabonakala lapho kukhethwa inkambu yegama, etholakala kwesobunxele sebha yefomula.

Uma igama lobubanzi lingabelwe, bese kuyinkambu engenhla, lapho kukhethiwe, ikheli leseli eliphezulu lengakwesobunxele le-array liyakhonjiswa.

Dala ibanga eliqanjwe igama

Okokuqala, sizofunda ukwakha ibanga eliqanjwe ngegama ku-Excel.

1. Indlela esheshayo nelula yokwaba igama kumalungu afanayo uwubhale enkombeni yegama ngemuva kokukhetha indawo ehambelana nayo. Ngakho-ke, khetha uhlu olufakiwe bese ufaka igama ensimini esilibona lidingeka. Kuyinto efiselekayo ukuthi kulula ukukhumbula nokuhambisana nokuqukethwe amaseli. Futhi, ngokweqiniso, kuyadingeka ukuthi ihlangabezana nezidingo zokuphoqelelwa ezichazwe ngenhla.



2. Ukuze uhlelo lufake leli gama ebhukwini lakhona futhi ulikhumbule, chofoza inkinobho Ngena. Igama lizonikezwa endaweni ekhethiwe yeseli.

Ngenhla yaqanjwa inketho eshesha kunazo zonke yokwakha igama le-array, kepha kukude kakhulu nokuphela. Le nqubo nayo ingenziwa ngemenyu yokuqukethwe.

1. Khetha uhlu olufunayo ofuna ukwenza kulo umsebenzi. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Kuluhlu oluvulayo, khetha inketho "Nikeza igama ...".



2. Iwindi lokwakha igama liyavula. Kuya endaweni "Igama" shayela igama ngokuya ngemibandela eshiwo ngenhla. Endaweni "Ububanzi" Ikheli le-array ekhethiwe liyakhonjiswa. Uma wenze ukukhetha ngendlela efanele, khona-ke awudingi ukwenza izinguquko kule ndawo. Chofoza inkinobho "Kulungile".



3. Njengoba ukwazi ukubona enkombeni yegama, igama lesifunda labelwa ngempumelelo.

Enye indlela yokwenza lo msebenzi ifaka ukusetshenziswa kwamathuluzi etheyipini.

1. Khetha indawo yeseli ofuna ukuyiguqula ibe ngegama. Hambisa kuthebhu Amafomula. Eqenjini "Amagama Athile" chofoza isithonjana "Igama".



2. Iwindows efanayo yokuqamba igama iyavula lapho usebenzisa inketho yangaphambilini. Yonke imisebenzi eminye yenziwa ngendlela efanayo.

Inketho yokugcina yokubiza isifunda, esizobheka ukuthi isetshenziswe Umphathi wegama.

1. Khetha uhlu. Ithebhu Amafomulachofoza isithonjana esikhulu Umphathi wegamaetholakala wonke eqenjini elifanayo "Amagama Athile". Noma ungasebenzisa izinkinobho zokhiye esikhundleni salokho I-Ctrl + F3.



2. Iwindows liyasebenza Umphathi wegama. Kuyo, chofoza inkinobho "Dala ..." ekhoneni eliphezulu kwesobunxele.



3. Ngemuva kwalokho iwindi elijwayelekile lokwenza amafayela liyasungulwa, lapho udinga ukufeza izinto ezikhohlakele ebezixoxwa ngenhla. Igama elizokwabelwa uhlu lizovela ngaphakathi I-Dispatcher. Ingavalwa ngokuchofoza inkinobho evamile ekhoneni eliphezulu kwesokudla.

Isifundo: Ungayibiza kanjani iseli e-Excel

Ukusebenza Okubizwa Ngebanga

Njengoba kushiwo ngenhla, uhlu lwamagama angahle lusetshenziswe ngenkathi kwenziwa imisebenzi ehlukahlukene e-Excel: amafomula, imisebenzi, amathuluzi akhethekile. Ake sibheke isibonelo esithile sokuthi lokhu kwenzeka kanjani.

Eshidi elilodwa sinalo uhlu lwamamodeli obuchwepheshe bekhompyutha. Sinomsebenzi ekhasini ishidi lesibili etafuleni ukwenza uhlu lokudonsa phansi kulolu hlu.

1. Okokuqala, ephepheni lohlu, sinika igama ibanga nganoma yiziphi izindlela ezixoxwe ngenhla. Ngenxa yalokhu, lapho kugqanyiswa uhlu enkambu yegama, igama lale nhla kufanele liboniswe. Kukhale igama "Amamodeli".



2. Ngemuva kwalokho, siqhubekela eshidi lapho itafula likhona, lapho kufanele sakhe uhlu olwehlayo. Khetha indawo etafuleni esihlela ukusebenzisa uhlu olwehlayo. Hambisa kuthebhu "Idatha" bese uchofoza inkinobho Ukuqinisekiswa Kwedatha ebhokisini lamathuluzi "Sebenza nedatha" ekhasethini.



3. Kuwindi lokuqinisekisa idatha eliqalisiwe, iya kuthebhu "Izinketho". Ensimini "Uhlobo lwedatha" inani lokukhetha Uhlu. Ensimini "Umthombo" esimweni esejwayelekile, kuzofanele ufake ngesandla zonke izinto zohlu olwehlayo oluzayo, noma unikeze isixhumanisi sohla lwabo, uma likhona kudokhumenti. Lokhu akuyona indawo elula kakhulu, ikakhulukazi uma uhlu lukhona kwelinye iphepha. Kepha kithi, yonke into ilula kakhulu, ngoba sayinikeza igama ohlwini oluhambelanayo. Ngakho-ke vele ubeke uphawu okulinganayo bese ubhala leli gama enkundleni. Isisho esilandelayo siyatholakala:

   = Amamodeli

   Qhafaza "Kulungile".



4. Manje, lapho ungena phezu kwanoma isiphi iseli ebangeni esisebenzise kulo ukuqinisekiswa kwedatha, unxantathu ubonakala ngakwesokunene sawo. Ukuchofoza kulo unxantathu kuvula uhlu lwedatha yokufaka, ekhishwe kusukela kuhlu kwelinye iphepha.



5. Kumele nje sikhethe inketho oyifunayo ukuze inani elivela kuhlu livele esitokisini esikhethiwe etafuleni.

Ibanga eliqanjwe igama libuye lisetshenziswe kalula njengezimpikiswano kwimisebenzi ehlukahlukene. Ake sibheke ukuthi lokhu kusetshenziswa kanjani ekusebenzeni ngesibonelo esithile.

Ngakho-ke, sinethebula lapho imali yamagatsha amahlanu ebhizinisi ichazwa njalo ngenyanga. Sidinga ukwazi imali ephelele yeGatsha 1, iGatsha lesi-3 neleGatsha lesi-5 isikhathi sonke esikhonjisiwe ethebula.

1. Okokuqala, sibeka igama emugqeni ngamunye wegatsha elihambisanayo etafuleni. EGatsheni 1, sikhetha indawo enamaseli aqukethe idatha yemali engenayo izinyanga ezintathu. Ngemuva kokugqamisa emkhakheni wegama, bhala igama "Branch_1" (ungakhohlwa ukuthi igama alikwazi ukuqukethe isikhala) bese uchofoza inkinobho Ngena. Igama lendawo efanele lizonikezwa. Uma ufisa, ungasebenzisa noma iyiphi enye indlela yokuqamba, okuxoxwe ngayo ngenhla.



2. Ngendlela efanayo, ukugqamisa izindawo ezihambisanayo, sinikeza amagama emigqa namanye amagatsha: "Igatsha_2", "Igatsha_3", "Igatsha_4", "Igatsha_5".



3. Khetha into eshidi lapho kuzobukiswa khona i-DRM. Chofoza isithonjana "Faka umsebenzi".



4. Ukuqalisa okwenziwe Umsebenzi Wizards. Siqhubekela ebhlokini "Izibalo". Simisa ukukhetha kusuka ohlwini lwabasebenza opharetha abatholakala egameni ISUM.



5. Iwindi lokuphikisana nomsebenzi liyasebenza ISUM. Lo msebenzi, oyingxenye yeqembu labasebenza ngezibalo, wenzelwe ngqo ukufingqa amanani wokubala. I-syntax imelwe yifomula elandelayo:

   = SUM (inombolo1; inombolo2; ...)

   Njengoba kulula ukuyiqonda, opharetha ufingqa konke ukuphikisana kweqembu "Inombolo". Ngendlela yokuphikisana, amanani womabili ngokwawo kanye nezethenjwa kumaseli noma amabanga lapho zitholakala khona angasetshenziswa. Uma kusetshenziswe i-arrays, isamba samanani aqukethe izinto zawo, abalwa ngemuva, asetshenziswa njengezimpikiswano. Singasho ukuthi "sifinyelela" esenzweni. Kungesixazululo senkinga yethu ukuthi kuzosetshenziswa i-DRM of range.

   Isamba opharetha ISUM ingahle ibe nezimpikiswano ezisuka koku-1 kuya ku-255 Kepha kithi, kuzodingeka izimpikiswano ezintathu kuphela, ngoba sizokwengeza amabanga amathathu: "Branch_1", "Igatsha_3" futhi "Igatsha_5".

   Ngakho-ke, setha ikhesa enkundleni "Inombolo1". Njengoba sinikeze amagama amabanga adinga ukungezwa, asidingi ukufaka izixhumanisi ensimini noma ukukhetha izindawo ezihambisanayo ephepheni. Mane usho igama le-array elizongezwa: "Branch_1". Emasimini "Inombolo2" futhi "Inombolo 3" bhala ngokufanele "Igatsha_3" futhi "Igatsha_5". Ngemuva kokuthi lokhu kwenziwa ngenkani kwenziwe, chofoza ku "Kulungile".



6. Umphumela wesibalo uboniswa kuseli elikhethwe ngaphambi kokuya Isici Wizard.

Njengoba ubona, ukwabela igama emaqenjini amaseli kuleli cala kwenze kwaba lula ukwengeza amanani ezinombolo akhiwe kuwo, ngokuqhathaniswa uma ngabe sisebenza sinamakheli, kunamagama.

Impela, lezi zibonelo ezimbili esizikhombisile ngenhla zibonisa kude kakhulu nazo zonke izinzuzo kanye namathuba wokusebenzisa amabanga aqanjwe lapho asetshenziswa njengengxenye yemisebenzi, amafomula namanye amathuluzi e-Excel. Okukhethwa kukho kokusebenzisa i-arrapp lapho igama linikezwe khona akunakubalwa. Noma kunjalo, lezi zibonelo noma kunjalo zenza sikwazi ukuqonda izinzuzo eziphambili zokuqanjwa kwezindawo zeshidi ngokuqhathaniswa nokusetshenziswa kwamakheli abo.

Isifundo: Ungabalwa kanjani inani ku-Microsoft Excel

Ukuphathwa Kwegama Lokwakha Okuthiwa

Indlela elula yokuphatha amabanga aqanjwe amagama wedlula Umphathi wegama. Usebenzisa leli thuluzi, ungabela amagama ku-arrays namaseli, uguqule izindawo ezivele zinamagama futhi uziqede. Mayelana nokuthi uqamba kanjani ukusebenzisa I-Dispatcher Sesikushilo ngenhla, manje sizofunda ukwenza amanye amaqhinga kuyo.

1. Ukuya ku I-Dispatcherhambisa kuthebhu Amafomula. Lapho, kufanele uchofoze isithonjana, esibizwa Umphathi wegama. Isithonjana esichaziwe sitholakala eqenjini "Amagama Athile".



2. Ngemuva kokuya I-Dispatcher ukuze ukwazi ukwenza ngobuqili obudingekayo ngobubanzi, udinga ukuthola igama lawo ohlwini. Uma uhla lwezakhi lungabanzi kakhulu, khona-ke lokhu kulula kakhulu. Kepha uma encwadini yamanje kukhona amashumi amaningana ama-arrays noma ngaphezulu, khona-ke ukwenza lula umsebenzi kunengqondo ukusebenzisa isihlungi. Chofoza inkinobho "Hlunga"ekhoneni eliphezulu kwesokudla sewindi. Ukuhlunga kungenziwa kuzinkomba ezilandelayo ngokukhetha into ehambelana nayo kwimenyu evulayo:
   • Amagama eshidini;
   • encwadini;
   • ngamaphutha;
   • awekho amaphutha;
   • Amagama athile;
   • Amagama etafula.

   Ukuze ubuyela kuhlu oluphelele lwezinto, vele ukhethe inketho "Sula isihlungi".



3. Ukuze ushintshe imingcele, igama noma ezinye izakhiwo zohlu olunamagama, khetha into oyifunayo I-Dispatcher bese uchofoza inkinobho "Shintsha ...".



4. Kuvulwa iwindi lokushintsha igama. Inezinkambu ezifanayo newindows yokwakha ibanga eliqanjwe ngegama esikhulume ngalo ngaphambili. Kungalesi sikhathi lapho izinkambu ziyogcwala idatha.

   Ensimini "Igama" Ungashintsha igama lendawo. Ensimini "Qaphela" Ungangeza noma uhlele inothi ekhona. Ensimini "Ububanzi" Ungashintsha ikheli le-array enegama. Kukhona ithuba lokukwenza ngokusebenzisa isingeniso sencwadi yeziqondisi esidingekayo, noma ngokubeka isikhombisi emkhakheni nokukhetha uhlu oluhambisanayo lwamaseli ephepheni. Ikheli lakhe lizovela ngokushesha enkundleni. Inkambu kuphela engakwazi ukuhlelwa "Isifunda".

   Ngemuva kokuhlela imininingwane sekuqediwe, chofoza inkinobho "Kulungile".

Futhi ku I-Dispatcher uma kunesidingo, ungenza inqubo yokususa ibanga eliqanjwe igama. Kulokhu, vele, hhayi isifunda ngokwaso esisekhadini sizosuswa, kodwa igama elinikezwe lona. Ngakho-ke, ngemuva kokuba inqubo isiqediwe, uhlu olubonisiwe lungatholakala kuphela ngokuxhumanisa kwalo.

Lokhu kubalulekile kakhulu, ngoba uma usuvele usebenzise igama elisusiwe kwifomula ethile, khona-ke ngemuva kokususa igama leli fomula lizophutha.

1. Ukuze wenze inqubo yokususa, khetha into oyifunayo ohlwini bese uchofoza inkinobho Susa.



2. Ngemuva kwalokho kuqaliswa ibhokisi lengxoxo, elicela ukuqinisekisa ukuzimisela kwalo ukususa into ekhethiwe. Lokhu kwenziwa ukuvikela umsebenzisi ukuthi enze le nqubo ngephutha. Ngakho-ke, uma uqinisekile ngesidingo sokususa, kuzodingeka uchofoze inkinobho "Kulungile" ewindini lokuqinisekisa. Ngaphandle kwalokho, chofoza inkinobho. Khansela.



3. Njengoba ukwazi ukubona, into ekhethiwe isusiwe ohlwini. I-Dispatcher. Lokhu kusho ukuthi uhlu olunamathiselwe kulo luphelelwe igama. Manje kuzokhonjwa kuphela izixhumanisi. Ngemuva kwakho konke ukukhwabanisa ku I-Dispatcher uqeda, chofoza inkinobho Valaukuqeda iwindi.

Kusetshenziswa ibanga eliqanjwe igama kungenza kube lula ukusebenza nge-Excel amafomula, imisebenzi, namanye amathuluzi. Izinto eziqanjwe ngokwazo zingalawulwa (ziguqulwe futhi zisulwe) kusetshenziswa okakhelwe ngaphakathi okhethekile I-Dispatcher.