KWESOKUDLA ku-Excel. Ifomula kanye nokusetshenziswa komsebenzi we-RIGHT ku-Excel

Iphrosesa yamagama ye-Excel inama-opharetha amaningi akuvumela ukuthi ulawule ulwazi lombhalo. Umsebenzi othi RIGHT ukhipha inani elithile lenombolo kuseli elinikeziwe. Kulesi sihloko, sizofunda ngokuningiliziwe izici zalo opharetha, futhi, ngokusebenzisa izibonelo ezithile, sizothola zonke izici zomsebenzi.

Imigomo nezinjongo zomsebenzisi WOKUDLA

Injongo eyinhloko yokuthi RIGHT iwukuba kukhishwe inombolo ethile yezinhlamvu kuseli elinikeziwe. Ukukhipha kuqala kusukela ekugcineni (uhlangothi lwesokudla). Umphumela wokuguqulwa uboniswa kuseli ekhethiwe ekuqaleni, lapho ifomula kanye nomsebenzi ngokwawo wengezwa. Lo msebenzi usetshenziselwa ukukhohlisa ulwazi lombhalo. RIGHT itholakala esigabeni sombhalo.

Incazelo yomsebenzisi we-RIGHT kuspredishithi se-Excel

Ukubuka okujwayelekile komsebenzisi: =KULUNGILE(umbhalo,inombolo_yezinhlamvu). Ake sibheke impikiswano ngayinye:

• Impikiswano yokuqala - "Umbhalo". Lesi yinkomba yokuqala lapho izinhlamvu zizogcina zikhishwe khona. Inani lingaba umbhalo othile (khona-ke ukukhishwa okuvela embhalweni kuzokwenziwa kucatshangelwa inombolo eshiwo yezinhlamvu) noma ikheli leseli okuzokwenziwa kulo ukukhishwa ngokwalo.
• Impikiswano yesi-2 – “Inani_labalingisi”. Lokhu kucacisa ukuthi zingaki izinhlamvu ezizokhishwa kunani elikhethiwe. I-agumenti icaciswe njengezinombolo.

Nakani! Uma le mpikiswano ingagcwaliswanga, iseli lapho umphumela uboniswa khona lizobonisa okuwukuphela kwawo uhlamvu lokugcina kwesokudla se-agumenti yombhalo enikeziwe. Ngamanye amazwi, sengathi sifake iyunithi kulo mkhakha.

Ukusebenzisa I-Opharetha OKUFANELE Esibonelweni Esithize

Esibonelweni esithize, ake sicabangele ukusebenza komsebenzisi we-RIGHT ukuze sazi izici zayo kangcono. Isibonelo, sinepuleti elibonisa ukuthengiswa kwamateku. Kukholomu yoku-1, amagama anikezwa ngenkomba yobukhulu. Umsebenzi uwukukhipha lobu bukhulu kwenye ikholomu.

Ukuhamba ngezinyawo:

1. Ekuqaleni, sidinga ukudala ikholomu lapho ulwazi luzokhishwa khona ekugcineni. Masiyinike igama – “Usayizi”.

2. Hambisa i-pointer kuseli 1st yekholomu, iza ngemva kwegama, bese uyikhetha ngokucindezela i-LMB. Chofoza into ethi "Faka Umsebenzi".

3. Iwindi elithi Faka Umsebenzi liyavela esibukweni. Sithola umbhalo othi "Isigaba:" bese uvula uhlu oluseduze nalo mbhalo. Ohlwini oluvulayo, thola into ethi “Umbhalo” bese uchofoza kuyo LMB.

4. Efasiteleni "Khetha umsebenzi:" bonke abangaba opharetha bombhalo babonisiwe. Sithola umsebenzi othi “RIGHT” bese siwukhetha ngosizo lwe-LMB. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK".

5. Iwindi elithi "Izimpikiswano Zomsebenzi" livele esibukweni linemigqa emibili engenalutho. Emgqeni othi "Umbhalo" kufanele ufake izixhumanisi zeseli 1st yekholomu "Igama". Esibonelweni sethu esithile, leli yiseli A2. Ungakwazi ukwenza le nqubo ngokwakho ngokuyifaka mathupha noma ngokucacisa ikheli leseli. Chofoza umugqa ukuze uthole isethi yamanani, bese uchofoza i-LMB kuseli oyifunayo. Emgqeni othi "Inombolo_yezinhlamvu" sibeka inombolo yezinhlamvu "kusayizi". Kulesi sibonelo, lena inombolo yesi-9, njengoba ubukhulu busekupheleni kwenkundla futhi buthatha izinhlamvu eziyisishiyagalolunye. Kuyaphawuleka ukuthi "isikhala" futhi uphawu. Ngemva ukubulawa konke Action siyacindezela «KULUNGILE".

6. Ngemuva kokwenza konke ukukhohlisa, udinga ukucindezela inkinobho ethi "Enter".

Kubalulekile! Ungabhala ifomula yesisebenzisi ngokwakho ngokuyisa isikhombisi kuseli oyifunayo futhi ucacise inani: =KULUNGILE(A2).

7. Njengomphumela wokukhwabanisa okwenziwe, ubukhulu bama-sneakers buzoboniswa esitokisini esikhethiwe, lapho sengeze khona umqhubi.

8. Okulandelayo, udinga ukwenza isiqiniseko sokuthi u-opharetha usetshenziswa kuseli ngayinye yekholomu ethi "Usayizi". Hambisa isikhombisi segundane ekhoneni elingezansi kwesokudla senkambu ngenani lefomula elifakiwe. Ikhesa kufanele ibe nesimo sophawu oluncane olumnyama oluhlanganisayo. Bamba i-LMB bese uhambisa isikhombi ngezansi. Ngemva kokukhetha lonke ibanga elidingekayo, khulula inkinobho.

9. Ekugcineni, yonke imigqa yekholomu ethi "Usayizi" izogcwaliswa ngolwazi oluvela kukholomu "Igama" (izinhlamvu zokuqala eziyisishiyagalolunye zikhonjisiwe).

10. Ngaphezu kwalokho, uma ususa amanani ngosayizi kukholamu ethi "Igama", azosuswa futhi kukholomu ethi "Usayizi". Lokhu kungenxa yokuthi amakholomu amabili manje axhunyiwe. Sidinga ukususa lesi sixhumanisi ukuze kube lula ngathi ukusebenza ngolwazi lwethebula. Sikhetha wonke amaseli wekholomu ethi "Usayizi", bese uchofoza kwesokunxele kusithonjana "Kopisha" esitholakala kubhulokhi "Ibhodi lokunamathisela" lesigaba "Ekhaya". Okunye okuhlukile kwenqubo yokukopisha isinqamuleli sekhibhodi "Ctrl + C". Inketho yesithathu ukusebenzisa imenyu yokuqukethwe, ebizwa ngokuchofoza kwesokudla iseli ebangeni elikhethiwe.

11. Esigabeni esilandelayo, chofoza kwesokudla kuseli lokuqala lendawo ephawulwe ngaphambilini, bese kumenyu yokuqukethwe sithola ibhulokhi ethi "Namathisela Izinketho". Lapha sikhetha into ethi "Values".

12. Ngenxa yalokho, lonke ulwazi olufakwe kukholomu "Usayizi" luzimele futhi aluhlobene nekholomu "Igama". Manje usungakwazi ukuhlela futhi ususe ngokuphephile kumaseli ahlukene ngaphandle kwengozi yoshintsho lwedatha kwenye ikholomu.

Isiphetho neziphetho ngomsebenzi we-RIGHT

I-spreadsheet i-Excel inenani elikhulu lemisebenzi ekuvumela ukuthi wenze ukukhohlisa okuhlukahlukene ngolwazi lombhalo, izinombolo kanye nesithombe. Umsebenzisi we-RIGHT usiza abasebenzisi ukunciphisa kakhulu isikhathi sokukhipha izinhlamvu ukusuka kukholomu eyodwa ukuya kwenye. Umsebenzi muhle kakhulu ekusebenzeni ngenani elikhulu lolwazi, njengoba ikuvumela ukuthi uqede ukucatshangwa kwenani elikhulu lamaphutha.