Uma usebenza ku-Excel, ngezinye izikhathi kudingeka ubale inani lemigqa yebanga elithile. Lokhu kungenziwa ngezindlela eziningana. Ake sihlaziye i-algorithm yokwenza le nqubo usebenzisa izinketho ezahlukene.
Ukunquma inani lemigqa
Kunezinhlobo eziningi zezindlela zokunquma inani lemigqa. Uma usebenzisa, kusetshenziswa amathuluzi ahlukahlukene. Ngakho-ke, udinga ukubheka icala elithile ukuze ukhethe ukhetho olufanele kakhulu.
Indlela 1: i-pointer ebhasini lesimo
Indlela elula yokuxazulula umsebenzi ebangeni elikhethiwe ukubuka ubuningi ebhasini lesimo. Ukwenza lokhu, mane ukhethe uhla oluthandayo. Kubalulekile ukucabangela ukuthi uhlelo lubheka iseli ngayinye nedatha yeyunithi ehlukile. Ngakho-ke, ukuze sigweme ukubalwa kabili, njengoba kudingeka sikwazi inani lemigqa, sikhetha ikholomu eyodwa kuphela endaweni efundwe. Esigodini sesimo ngemuva kwegama "Isibalo" Isiboniso senani langempela lezici ezigcwele ebangeni elikhethiwe lizovela ngakwesokunxele kwezinkinobho zokushintsha izindlela zokubonisa.
Nokho, kwenzeka futhi uma kungekho amakholomu agcwele ngokuphelele etafuleni, futhi kukhona amanani emgqeni ngamunye. Kulesi simo, uma sikhetha ikholomu eyodwa kuphela, lezo zakhi ezingenawo amanani kule kholomu ngeke zifakwe ekubalweni. Ngakho-ke, sisheshe sikhethe ikholomu ecacile, bese sibambe inkinobho Ctrl chofoza amaseli agcwalisiwe emigqeni engenalutho kukholomu ekhethiwe. Kulesi simo, khetha okungaphezu kwesisodwa ngomugqa ngamunye. Ngakho-ke, inani lazo zonke imigqa ebangeni elikhethiwe lapho okungenani iseli elilodwa ligcwala lizoboniswa kubha yomumo.
Kodwa kunezimo lapho ukhetha amaseli agcwele emigqeni, futhi isibonakaliso senombolo ebhasini lesimo asiveli. Lokhu kusho ukuthi lesi sici sikhutshaziwe. Ukuze uyinike amandla, chofoza ngakwesokudla kwibha yesimo nemenyu evelayo, setha uphawu ngokumelene nenani "Isibalo". Manje inombolo yamigqa ekhethiwe izoboniswa.
Indlela 2: sebenzisa umsebenzi
Kodwa, indlela engenhla ayivumeli ukurekhoda imiphumela yokubala endaweni ethile eshidi. Ngaphezu kwalokho, inikeza ikhono lokubala kuphela leyo migqa equkethe amanani, futhi kwezinye izimo kuyadingeka ukubala zonke izakhi kuhlanganise, kufaka phakathi izinto ezingenalutho. Kulesi simo, lo msebenzi uzokusiza. I-CLUTCH. I-syntax yayo ilandelayo:
= OKUQHELEKILE (uhlaka)
Ingaxhunyelwa kunoma iyiphi iseli elingenalutho kushidi, futhi njengengxabano "Uhlu" faka izixhumanisi zobubanzi okufanele ubale kuzo.
Ukuze ubonise umphumela esikrinini, cindezela inkinobho. Ngena.
Ngaphezu kwalokho, ngisho nemigqa engalutholi ngokuphelele yobubanzi izobalwa. Kufanele kuqaphele ukuthi, ngokungafani nendlela eyedlule, uma ukhetha indawo ehlanganisa amakholomu amaningana, opharetha uzobala imigqa kuphela.
Kubasebenzisi abangenalwazi oluncane ngamafomula ku-Excel, kulula ukusebenza ngalolu opharetha Umsebenzi weWebhu.
- Khetha iseli lapho ukukhishwa kwezinto eziphelele kuqedile kuzoboniswa. Sicindezela inkinobho "Faka umsebenzi". Ifakwa ngokushesha ngakwesokunxele kwebha yamakhemikhali.
- Iwindi elincane liqala. Amakhosi omsebenzi. Ensimini "Izigaba" setha isikhundla "Izixhumanisi nezigaba" noma "Uhlu oluphelele lwe-alfabhethi". Ngifuna ukubaluleka CHSTROKukhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lempikiswano yokusebenza ivula. Faka i-cursor ensimini "Uhlu". Sikhetha eshadini elibekwe, inombolo yemigqa ofuna ukuyibala. Ngemuva kokuthi izixhumanisi zale ndawo zikhonjiswe emkhakheni wewindi lezingxoxo, chofoza inkinobho "Kulungile".
- Loluhlelo lwenza idatha futhi lubonise umphumela wokubala imigqa kuseli elichaziwe ngaphambilini. Manje lo mphumela uzoboniswa unomphela kule ndawo uma unganqume ukususa ngesandla.
Isifundo: I-Excel umsebenzi wizard
Indlela 3: Sebenzisa Ihlunga nokufometha okunemibandela
Kodwa kunezimo lapho kubalulekile ukubala hhayi yonke imigqa ebangeni, kodwa kuphela labo abahlangabezana nesimo esithile esicacisiwe. Kulokhu, ukufometha okunemibandela nokuhlunga okulandelayo kuzosiza.
- Khetha ibanga lapho isimo sizohlolwa khona.
- Iya kuthebhu "Ikhaya". On the tape ebhodini amathuluzi "Izitayela" cindezela inkinobho "Ukufometha okunemibandela". Khetha into "Imithetho yokukhethwa kweseli". Ukuqhubeka phambili iphuzu lemithetho ehlukahlukene ivuleka. Ngokomzekelo wethu, sikhetha into "Okuningi ...", nakuba kwamanye amacala ukhetho lungase lubekwe endaweni ehlukile.
- Iwindi livula lapho isimo sisethiwe khona. Emkhawulweni wesokunxele, sibonisa inombolo, amangqamuzana afaka inani eliphakeme kunaleyo, azobe enemibala ethile. Esikhathini esifanele kunelungelo lokukhetha lo mbala, kodwa ungasishiya ngokuzenzakalelayo. Ngemuva kokuthi ukufakwa kwesimiso kuqediwe, chofoza inkinobho. "Kulungile".
- Njengoba ubona, ngemuva kwalezi zenzo, amangqamuzana anelisa isimo agcwele umbala okhethiwe. Khetha lonke uhla lwamanani. Ukuba konke kuthebhu efanayo "Ikhaya", chofoza inkinobho "Hlunga futhi uhlunge" eqenjini lamathuluzi Ukuhlela. Ohlu oluvela, khetha into "Hlunga".
- Emva kwalokho, isithonjana sokuhlunga sivela ezihlokweni zekholomu. Chofoza kukho kukholomu lapho yenziwe khona. Emenyu evula, khetha into "Hlunga ngembala". Okulandelayo, chofoza umbala, ogcwele amangqamuzana afomethiwe anelisa isimo.
- Njengoba ubona, amangqamuzana angabonakaliswa ngombala ngemva kokuba lezi zenzo zifihliwe. Mane nje ukhethe uhla lwamaseli asele bese ubuka inkomba "Isibalo" kubha yomumo, njengokuxazulula inkinga ngendlela yokuqala. Yile namba ezokhombisa inani lemigqa eyanelisa isimo esithile.
Isifundo: Ukufometha okunemibandela ku-Excel
Isifundo: Hlunga bese uhlunga idatha ku-Excel
Njengoba ungabona, kunezindlela eziningana zokuthola inombolo yemigqa ekukhethweni. Ngayinye yalezi zindlela kufanelekile ukusebenzisa izinhloso ezithile. Isibonelo, uma ufuna ukulungisa umphumela, khona-ke inketho ngokusebenza kufanelekile, futhi uma umsebenzi ubala imigqa ehlangabezana nesimo esithile, ukufometha okunemibandela kuzosindiswa, kulandelwe ukuhlunga.
