Lapho usebenza e-Excel, kwesinye isikhathi udinga ukubala inani lemigqa ebangeni elithile. Kunezindlela eziningana zokwenza lokhu. Sizohlaziya i-algorithm yokwenza le nqubo sisebenzisa izinketho ezahlukahlukene.
Inquma inani lemigqa
Kunezindlela ezimbalwa impela zokunquma inani lemigqa. Lapho uwasebenzisa, kusetshenziswa amathuluzi ahlukahlukene. Ngakho-ke, udinga ukubheka icala elithile ukuze ukhethe inketho efanelekile.
Indlela yoku-1: pointer kubha yesimo
Indlela elula yokuxazulula umsebenzi ebangeni elikhethiwe ukubheka inombolo esebhari lesimo. Ukuze wenze lokhu, mane ukhethe ibanga olifunayo. Kubalulekile ukucabanga ukuthi uhlelo lubala iseli ngayinye nedatha yiyunithi ehlukile. Ngakho-ke, ukuvimbela ukubalwa okuphindwe kabili, ngoba kudingeka sazi inani lemigqa, sikhetha ikholamu eyodwa kuphela endaweni yokufunda. Kubha yesimo ngemuva kwegama "Ubuningi" ngakwesobunxele kwezinkinobho zokushintsha imodi yokubonisa, inkomba yenombolo yangempela yezinto ezigcwalisiwe ebangeni elikhethiwe iyavela.
Kuliqiniso, lokhu kuyenzeka nangabe kungekho amakholomu agcwele ngokuphelele etafuleni, futhi umugqa ngamunye unamanani. Kulokhu, uma sikhetha ikholamu eyodwa kuphela, khona-ke lezo zinto ezingenawo amanani kulelo kholomu ngeke zifakwe ekubalweni. Ngakho-ke, khetha ikholomu ecacisiwe ngokuphelele, bese ubamba inkinobho Ctrl chofoza kumaseli agcwele, kuleyo migqa evele ingenalutho kwikholamu ekhethiwe. Kulokhu, khetha kungabi ngaphezu kweseli elilodwa emgqeni ngamunye. Ngakho-ke, umugqa wesimo uzobonisa inani layo yonke imigqa ebangeni elikhethiwe lapho okungenani iseli elilodwa ligcwele.
Kepha kunezimo lapho ukhetha amaseli agcwele emigqeni, futhi ukuboniswa kwenombolo kubha yesimo akuveli. Lokhu kusho ukuthi lesi sici sikhutshaziwe nje. Ukuze uyinike amandla, chofoza kwesokudla kubha yesimo nakwimenyu evelayo, hlola ibhokisi eliseduze nenani "Ubuningi". Manje isibalo semigqa ekhethiwe sizokhonjiswa.
Indlela 2: sebenzisa umsebenzi
Kepha, indlela engenhla ayivumeli ukulungisa imiphumela yokubala endaweni ethile eshidini. Ngaphezu kwalokho, kunikeza ithuba lokubala kuphela leyo migqa lapho amanani akhona, futhi kwezinye izikhathi kuyadingeka ukubala zonke izinto ezikuhlanganisiwe, kufaka phakathi ezingenalutho. Kulokhu, umsebenzi uzokusiza CHART. I-syntax yayo imi ngolu hlobo:
= STROKE (uhlu)
Ingahanjiswa kunoma yisiphi iseli elingenalutho eshidini, kodwa njengengxabano Array faka izixhumanisi zobubanzi ofuna ukubala kuzo.
Ukubonisa umphumela esikrinini, chofoza nje Ngena.
Ngaphezu kwalokho, ngisho imigqa yebanga elingenalutho ngokuphelele izobalwa. Kuyaqapheleka ukuthi, ngokungafani nendlela yangaphambilini, uma ukhetha indawo efaka amakholomu ambalwa, opharetha uzobheka imigqa kuphela.
Kulula ukuthi abasebenzisi abanolwazi oluncane ngamafomula aku-Excel basebenze nalo opharetha Isici Wizard.
- Khetha iseli okuzophuma kulo ukubala kokuqediwe kwezinto. Chofoza inkinobho "Faka umsebenzi". Itholakala ngokushesha ngakwesobunxele sebha yefomula.
- Kuqala iwindi elincane Umsebenzi Wizards. Ensimini "Izigaba" setha isikhundla Izinkomba kanye nokufika noma "Uhlu oluphelele lwe-alfabhethi". Ufuna inani ISIHLOKO, ikhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana ngomsebenzi liyavula. Faka ikhesa endle Array. Khetha ububanzi beshidi, inombolo yemigqa ofuna ukubala kuyo. Ngemuva kokuthi izixhumanisi zale ndawo ziboniswe emkhakheni wewindi lokuphikisana, chofoza inkinobho "Kulungile".
- Uhlelo lucubungula imininingwane futhi lubonisa umphumela wokubala imigqa kuseli elicacisiwe ngaphambili. Manje leli nani lizokhonjiswa kule ndawo njalo, uma unganqumi ukukususa ngesandla.
Isifundo: I-Excel Feature Wizard
Indlela 3: sebenzisa ukuhlunga nokufomatha okunemibandela
Kepha kunezikhathi lapho kudingekile ukubala hhayi yonke imigqa ebangeni, kodwa kuphela yilezo ezihlangabezana nesimo esithile esinikeziwe. Kulokhu, ukufometha okunemibandela nokuhlunga okulandelayo kuzokusiza
- Khetha ibanga lapho isimo siyohlolwa khona.
- Iya kuthebhu "Ikhaya". Kubambo olubekwe ebhokisini lamathuluzi Izitayela chofoza inkinobho Ukufomatha okunemibandela. Khetha into Imithetho Yokukhetha Iseli. Okulandelayo, into yemithetho eyahlukahlukene iyavula. Ngokwesibonelo sethu, siyakhetha "Okuningi ...", yize kwamanye amacala ukukhetha kungamiswa endaweni ehlukile.
- Kuvulwa iwindi lapho isimo sisethwe khona. Ensimini yangakwesobunxele, chaza inombolo, amaseli afaka inani elikhudlwana kuzodingeka lipende ngombala othile. Ensimini efanele, kungenzeka ukhethe lo mbala, kepha ungawushiya ngokuzenzakalelayo. Ngemuva kokubeka isimo sesiphelile, chofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalezi zenzo amaseli anelisa lesi simo agcwala umbala okhethiwe. Khetha lonke uhla lwamanani. Ukuba kuyo yonke into kuthebhu efanayo "Ikhaya"chofoza inkinobho Hlunga nesihlungi eqenjini lamathuluzi "Ukuhlela". Kuluhlu olubonakala, khetha "Hlunga".
- Ngemuva kwalokho, kuvela isithonjana sokuhlunga kusihloko sekholomu. Sichofoza kukho kwikholamu lapho ukufometha kwenziwa khona. Kumenyu evulayo, khetha "Hlunga ngombala". Okulandelayo, chofoza umbala owagcwalisa amaseli afomethwe anelisa isimo.
- Njengoba ukwazi ukubona, amaseli awamakwa ngombala ngemuva kokuba lezi zenzo zifihliwe. Vele ukhethe uhla olusele lwamaseli bese ubheka inkomba "Ubuningi" kubha yesimo, njengokuxazulula inkinga ngendlela yokuqala. Yile nombolo ezokhombisa inani lemigqa enelisa isimo esithile.
Isifundo: Ukufomatha okunemibandela ku-Excel
Isifundo: Hlunga futhi uhlunge idatha ku-Excel
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokuthola inani lemigqa kucezu olukhethiwe. Enye nenye yalezi zindlela ilungele izinhloso ezithile. Isibonelo, uma ufuna ukulungisa umphumela, khona-ke kulokhu ukukhetha okunomsebenzi kufanelekile, futhi uma umsebenzi ukubala imigqa ehlangabezana nesimo esithile, ukufometha okunemibandela ngokuhlunga okulandelayo kuzokusiza.
