Ukufometha okunemibandela ku-Excel - ngokuningiliziwe ngezibonelo

Uma udinga ukwethula ulwazi ngeso lengqondo, kulula kakhulu ukwenza lokhu usebenzisa ukufometha okunemibandela. Umsebenzisi osebenzisa le sevisi wonga inani elikhulu lamandla nesikhathi. Ukuze uthole ulwazi oludingekayo, ukubuka okusheshayo kwefayela kwanele.

Ungakwenza kanjani ukufometha okunemibandela ku-Excel

Ungathola "Ukufometha Okunemibandela" kuthebhu yokuqala ngqa iribhoni ngokuya esigabeni "Izitayela". 

Okulandelayo, udinga ukuthola isithonjana somcibisholo kancane kwesokudla ngeso lakho, hambisa ikhesa kuso. Khona-ke izilungiselelo zizovuleka, lapho ungakwazi ukumisa ngokuguquguqukayo yonke imingcele edingekayo. 

Okulandelayo, udinga ukukhetha u-opharetha ofanele ukuze uqhathanise okuguquguqukayo okufunayo nenombolo. Kukhona ama-opharetha okuqhathanisa amane - amakhulu kune, ngaphansi, alingana, naphakathi. Ahlelwe kumenyu yemithetho. 

Okulandelayo, sicacise uchungechunge lwezinombolo kububanzi A1:A11.

Masifomethe isethi yedatha efanelekile. Bese sivula imenyu yezilungiselelo "Ukufometha Okunemibandela" bese sibeka indlela yokukhetha idatha edingekayo. Endabeni yethu, isibonelo, sizokhetha umbandela othi "Okwengeziwe". 

Iwindi elinesethi yezinketho lizovuleka. Engxenyeni engakwesokunxele yefasitela kukhona insimu lapho udinga ukucacisa inombolo 15. Engxenyeni efanele, indlela yokugqamisa ulwazi ibonisiwe, inqobo nje uma ihlangabezana nesimiso esishiwo ngaphambili. Umphumela uzoboniswa ngokushesha.

Okulandelayo, qedela ukumisa ngenkinobho ethi KULUNGILE.

Kuyini ukufometha okunemibandela?

Ngokwezinga elithile, singasho ukuthi iyithuluzi, ngemva kokufunda ukuthi yikuphi ukusebenza ne-Excel okungeke kufane. Lokhu kungenxa yokuthi kwenza ukuphila kube lula kakhulu. Esikhundleni sokusetha mathupha ukufometha kweseli okufana nesimo esithile isikhathi ngasinye, futhi uzame ukuzihlolela ukuthi iyahambisana yini nalo mbandela, udinga nje ukusetha izilungiselelo kanye, bese i-Excel izokwenza yonke into ngokwayo.

Isibonelo, ungenza wonke amaseli aqukethe inombolo enkulu kuno-100 abe bomvu. Noma, thola ukuthi zingaki izinsuku ezisele ngaphambi kwenkokhelo elandelayo, bese ufaka umbala oluhlaza kulawo maseli lapho umnqamulajuqu ungakabi kude ngokwanele. 

Ake sithathe isibonelo.

Leli thebula libonisa uhlu lwempahla olusesitokweni. Inezinsika. njengomkhiqizo, ukuthengiswa okumaphakathi (kukalwa ngamayunithi ngeviki), isitoko kanye nokuthi mangakhi amaviki alo mkhiqizo asele.

Ngaphezu kwalokho, umsebenzi womphathi wokuthenga ukunquma lezo zikhundla, ukugcwalisa okudingekayo. Ukuze wenze lokhu, udinga ukubheka ikholomu yesine ukusuka kwesobunxele, erekhoda isitokwe sezimpahla ngesonto.

Ake sithi umbandela wokunquma imbangela yokwethuka ungaphansi kwamaviki angu-3 ohlu. Lokhu kubonisa ukuthi kudingeka silungise i-oda. Uma isitokwe sezimpahla singaphansi kwamasonto amabili, khona-ke lokhu kubonisa isidingo sokufaka i-oda ngokushesha. Uma ithebula liqukethe inani elikhulu lezikhundla, khona-ke ukuhlola ngesandla ukuthi mangaki amaviki asele kuyinkinga impela. Ngisho noma usebenzisa usesho. Futhi manje ake sibone ukuthi ithebula libukeka kanjani, eligqamisa izimpahla eziyivelakancane ngokubomvu.

Futhi ngempela, kulula kakhulu ukuzulazula. 

Yiqiniso, lesi sibonelo siyafundisa, esenziwe lula ngandlela-thile uma siqhathaniswa nesithombe sangempela. Futhi imizuzwana nemizuzu egciniwe ngokusetshenziswa njalo kwamatafula anjalo iphenduka amahora. Manje kwanele nje ukubheka etafuleni ukuze uqonde ukuthi yiziphi izimpahla ezishodayo, futhi ungachithi amahora uhlaziya iseli ngalinye (uma kunezinkulungwane zezinto ezinjalo zempahla).

Uma kukhona izimpahla "eziphuzi", udinga ukuqala ukuzithenga. Uma isikhundla esihambisanayo sibomvu, khona-ke udinga ukukwenza ngokushesha. 

Ngenani lelinye iseli

Manje ake sibheke isibonelo esisebenzayo esilandelayo.

Ake sithi sinethebula elinjalo, futhi sibhekene nomsebenzi wokugqamisa imigqa equkethe amanani athile. 

Ngakho-ke, uma iphrojekthi isaqhutshwa (okungukuthi, ayikaqedwa, ngakho-ke imakwe ngohlamvu "P"), ngakho-ke sidinga ukwenza ingemuva layo libe bomvu. Amaphrojekthi aqediwe amakwe ngokuluhlaza.

Ukulandelana kwethu kwezenzo kulesi simo kuzoba kanje:

1. Khetha ububanzi bamanani. 
2. Chofoza inkinobho ethi "Ukufometha Okunemibandela" - "Dala Umthetho".
3. Sicela uqaphele ukuthi esimweni sethu, udinga ukusebenzisa ifomula ngendlela yomthetho. Okulandelayo, sisebenzisa umsebenzi IFukugqamisa imigqa efanayo. 

Okulandelayo, gcwalisa imigqa njengoba kukhonjisiwe kulesi sithombe.

Kubalulekile! Izintambo kufanele zikhonjwe ngokuphelele. Uma sibhekisela kuseli, khona-ke kulokhu kuxutshwe (nokulungiswa kwekholomu).

Ngokufanayo, umthetho wenziwa kulawo maphrojekthi omsebenzi angakaqedwa kuze kube manje. 

Yilokhu indlela yethu ebukeka ngayo.

Futhi ekugcineni, sinesizindalwazi esinjalo njengomphumela.

Izimo Eziningi

Ukuze uthole ukucaca, ake sithathe ububanzi A1:A11 etafuleni ukuze sibonise ukuthi, ngesibonelo sangempela esisebenzayo, ungasebenzisa kanjani izimo ezimbalwa ukuze unqume ukufometha kweseli.

Izimo ngokwazo zimi kanje: uma inombolo kuseli idlula inani elingu-6, bese igqanyiswa ngokubomvu. Uma kuluhlaza, umbala uluhlaza. Futhi ekugcineni, izinombolo ezinkulu, ezingaphezu kuka-20, zizogqanyiswa ngombala ophuzi. 

Kunezindlela ezimbalwa zokuthi ukufometha okunemibandela kwenziwa kanjani ngokwemithetho eminingana.

1. Indlela 1. Sikhetha ububanzi bethu, ngemva kwalokho, kumenyu yezilungiselelo zokufometha okunemibandela, khetha umthetho onjalo wokukhetha iseli njengokuthi "Okwengeziwe". Inombolo 6 ibhalwe kwesokunxele, futhi ukufometha kusethwe kwesokudla. Esimweni sethu, ukugcwaliswa kufanele kube bomvu. Ngemva kwalokho, umjikelezo uphindwe kabili, kodwa ezinye imingcele sezivele zisethiwe - ezingaphezu kuka-10 nombala oluhlaza futhi ezingaphezu kuka-20 nombala ophuzi, ngokulandelana. Uzothola umphumela onjalo.
   

   

2. Indlela 2. Yiya kumenyu yezilungiselelo eyinhloko yethuluzi le-Excel “Ukufometha Okunemibandela”. Lapho sithola imenyu ethi "Dala Umthetho" bese uchofoza kwesokunxele kule nto.
   

   

    Ngemuva kwalokho, Okulandelayo, khetha into ethi “Sebenzisa ifomula ..." (egqanyiswe esithombeni ngohlaka olubomvu) bese usetha isimo sokuqala. Ngemva kwalokho, chofoza OK. Futhi-ke umjikelezo uphindaphindiwe ngezimo ezilandelayo ngendlela efanayo njengoba kuchazwe ngenhla, kodwa ifomula isetshenziswa.

   

Kubalulekile ukukunaka lokhu. Esibonelweni sethu, amanye amaseli afana nemibandela embalwa ngesikhathi esisodwa. I-Excel ixazulula le ngxabano ngale ndlela elandelayo: umthetho ongenhla usetshenziswa kuqala. 

Futhi nasi isithombe-skrini sokuqonda kangcono.

Isibonelo, sinenombolo 24. Ihlangabezana nazo zontathu izimo ngesikhathi esisodwa. Kulesi simo, kuyoba khona ukugcwaliswa okuhlangabezana nesimo sokuqala, naphezu kokuthi iwela kakhulu ngaphansi kwesithathu. Ngakho-ke, uma kubalulekile ukuthi izinombolo ezingaphezulu kuka-20 zigcwaliswe ngophuzi, isimo sesithathu kufanele sibekwe endaweni yokuqala. 

Ukufometha Idethi Enemibandela

Manje ake sibone ukuthi ukufometha okunemibandela kusebenza kanjani namadethi. Sinebanga elipholile kangaka.

Kulokhu, udinga ukusetha umthetho wokufometha onemibandela njengokuthi “Idethi”.

Ngemva kwalokho, ibhokisi lengxoxo livuleka ngesethi yonke yezimo. Ungajwayelana nabo ngokuningiliziwe kulesi sithombe-skrini (basohlwini kwesokunxele sesikrini ngendlela yohlu).

Sidinga nje ukukhetha efanele bese uchofoza inkinobho "OK".

Siyabona ukuthi lezo zinsuku ezibhekisela evikini lokugcina ngesikhathi lolu hlu ludwetshwa ngalo zazigqanyiswe ngokubomvu. 

Ukusebenzisa amafomula

Isethi yemithetho yokufometha enemibandela evamile inkulu impela. Kodwa izimo zihlukile, futhi uhlu olujwayelekile lungase lunganele. Kulokhu, ungazakhela owakho umthetho wokufometha usebenzisa ifomula. 

Ukuze wenze lokhu, chofoza inkinobho ethi "Dala Umthetho" kumenyu yokufometha enemibandela, bese ukhetha into eboniswe kusithombe-skrini.

Imigqa (ngevelu yeseli)

Ake sithi sidinga ukugqamisa umugqa oqukethe iseli elinenani elithile. Kulesi simo, sidinga ukwenza ukulandelana okufanayo kwezenzo njengangenhla, kodwa kumayunithi ezinhlamvu. Okusho ukuthi, ungakhetha ukuthi ibuphi ububanzi ukufometha okunemibandela okufanele kusebenze kubo. 

Ungawenza kanjani umthetho

Ukuze udale umthetho, kufanele usebenzise inketho efanele esigabeni esithi "Ukufometha Okunemibandela". Ake sibheke ukulandelana okuthile kwezenzo. 

Okokuqala udinga ukuthola into ethi "Ukufometha Okunemibandela" iribhoni kuthebhu "Ekhaya". Ingabonwa ngesici samaseli anemibala eminingi yamasayizi ahlukene anesithombe eduze kwawo esinophawu olulinganayo olunqanyuliwe. 

Kukhona inkinobho ethi "Dala Umthetho". Ungaphinda uchofoze inkinobho ethi "Phatha imithetho", emva kwalokho ibhokisi lengxoxo lizovuleka, lapho ungakwazi futhi ukudala umthetho ngokuchofoza inkinobho ehambisanayo ekhoneni eliphezulu kwesokunxele. 

Ungabona futhi kuleli windi leyo mithetho esivele isetshenzisiwe.

Imithetho yokukhetha iseli

Kulungile, sikhuluma kakhulu mayelana nendlela yokudala imithetho, kodwa kuyini? Umthetho wokukhetha amaseli ubhekisela ezicini ezicatshangelwa uhlelo ukuze kunqunywe ukuthi amaseli awafanele afomethwe kanjani. Isibonelo, izimo zingaba nkulu kunenombolo ethile, ibe ngaphansi kwenombolo ethile, ifomula, njalonjalo. Kukhona isethi yonke yazo. Ungajwayelana nazo futhi uzijwayeze ukusetshenziswa kwazo “ebhokisini lesihlabathi”. 

Ifometha wonke amaseli ngokusekelwe kumanani awo

Umuntu angasetha ngokuzimela ububanzi: umugqa wonke, idokhumenti yonke, noma iseli elilodwa. Uhlelo lungagxila kuphela enanini leseli eyodwa. Lokhu kwengeza ukuguquguquka kwenqubo. 

Fometha kuphela amaseli ahlukile noma ayimpinda

Kunenombolo enkulu yemithetho exhunywe ngokuqondile ohlelweni. Ungakwazi ukujwayelana nabo kumenyu ethi "Ukufometha Okunemibandela". Ikakhulukazi, ukuze ukufometha kusebenze kuphela kumanani aphindwe kabili noma kwawahlukile kuphela, kunenketho ekhethekile - "Amanani ayimpinda".

Uma ukhetha le nto, iwindi elinezilungiselelo liyavuleka, lapho ungaphinda ukhethe khona okuphambene - khetha amanani ayingqayizivele kuphela. 

Fometha amanani kububanzi obungezansi nangaphezulu kwesilinganiso

Ukufometha amanani ngaphansi noma ngaphezulu kwesilinganiso, kukhona futhi inketho ekhethekile kumenyu efanayo. Kodwa udinga ukukhetha enye imenyu encane - "Imithetho yokukhetha amanani okuqala nawokugcina". 

Ukufometha kuphela amanani okuqala nawokugcina

Kumenyu encane efanayo, kungenzeka ukugqamisa kuphela amanani okuqala nawokugcina ngombala okhethekile, ifonti nezinye izindlela zokufometha. Ngokwendinganiso, kunenketho yokukhetha izakhi eziyishumi zokuqala nezokugcina, kanye no-10% yenani eliphelele lamaseli afakwe kulobu bubanzi. Kodwa umsebenzisi angakwazi ukunquma ngokuzimela ukuthi mangaki amaseli okufanele awakhethe.

Ifometha kuphela amaseli anokuqukethwe okuthile

Ukufometha kuphela amaseli anokuqukethwe okuthile, kufanele ukhethe umthetho wokufometha othi Equal To noma Uqukethe Umbhalo. Umehluko phakathi kwabo ukuthi esimweni sokuqala, intambo kufanele ihambisane nombandela ngokuphelele, kanti okwesibili, ingxenye kuphela. 

Njengoba ubona, ukufometha okunemibandela kuyisici esisebenzayo sohlelo lwe-Excel olunikeza inani elikhulu lezinzuzo kumuntu owazi kahle. Siyazi ukuthi ekuqaleni, konke lokhu kungase kubonakale kuyinkimbinkimbi. Kodwa empeleni, izandla zidonseleka kuyo ngokushesha nje lapho ibonakala igqamisa ucezu oluthile lombhalo ngokubomvu (noma lufomethwe nganoma iyiphi enye indlela), ngokusekelwe kokuqukethwe kwalo noma ngokuhambisana nenye umbandela. Lo msebenzi ufakwe kusethi eyisisekelo yolwazi lwe-Excel, ngaphandle kwalo ngisho nomsebenzi wezimfundamakhwela ngamaspredishithi nezizindalwazi akunakwenzeka.