Indlela yokudibanisa iiseli kwi-Excel

Rhoqo, xa usebenza neetafile kwiNkqubo ye-Microsoft Excel, imeko yenzeka xa kufuneka udibanise iiseli ezininzi. Umsebenzi awunzima kakhulu ukuba ezi seli azinazixhobo. Kodwa kufuneka wenze ntoni ukuba ulwazi sele lwenziwe kubo? Ngaba iya kutshatyalaliswa? Makhe siyifumane indlela yokudibanisa iiseli, kubandakanya ngaphandle kokuphulukana neziqulatho zazo, kwiMicrosoft Excel.

Ukudibanisa iiseli kwi-Excel

Cinga ngombutho kuzo zonke iindlela apho iiseli ziya kuhlala khona idatha. Ukuba izikhundla ezibini ezikufuphi zolwazi oluzayo zinolwazi olwahlukileyo, zinokugcinwa kuzo zombini iimeko-zoku, iphakheji yeofisi ibonelela ngemisebenzi ekhethekileyo ekuxoxwe ngayo ngezantsi. Indibaniselwano inokufunwa kungekuphela nje ukwenza idatha ukusuka kwiiseli ezimbini ibe enye, kodwa kwakhona, umzekelo, ukwenzela ukuba kubekho umnqwazi weekholamu ezininzi.

Indlela yoku-1: Umbutho olula

Eyona ndlela ilula yokudibanisa iiseli ezininzi kukusetyenziswa kweqhosha elinikiweyo kwimenyu.

1. Ngokulandelelana khetha iqhosha lemouse lasekhohlo ukudibanisa. Inokuba yimiqolo, iikholamu okanye ukhetho lokunxibelelana. Kwindlela ethathelwe ingqalelo, sisebenzisa umqolo wokudibanisa.



2. Yiya kwithebhu "yasekhaya".



3. Fumana kwaye ucofe kulolo lwemenyu yemeko ye-warger, apho kukho iindlela ezininzi ezinokwenzeka, phakathi kweyona ndlela ilula kubo - "intambo ye-" Chrinene ".



4. Kule meko, iiseli zidityanisiwe, kwaye yonke idatha eya kulingana kwiseli edibeneyo iya kuhlala ikwindawo enye.



5. Ukufomatha isicatshulwa emva kokudibanisa iziko, kufuneka ukhethe into ethi "ukudibanisa ngokuhambelana nolungelelwaniso embindini". Emva kwezenzo ezenziweyo, imixholo inokuthi ilungelelaniswe ngendlela yakho usebenzisa izixhobo ezifanelekileyo.



6. Ukucwangciswa ukungayidibanisa inani elikhulu lemigca ngokwahlukeneyo, sebenzisa "uMbutho weNdawo" ".

Indlela 2: Guqula iipropathi zeseli

Kuyenzeka ukuba udibanise iiseli kwimenyu yomxholo. Iziphumo ezifunyenweyo ezifumaneka kule ndlela aza zahlukile kowokuqala, kodwa umntu unokulungela ukuba asebenziseke.

1. Qwalasela isikhombisi kwiiseli, ekufuneka udityaniswe, cofa kuyo ngoku ngasekunene ucofe, kunye nemenyu yemeko evelayo, khetha "ifomathi yeseli".



2. Kwisisele ifestile yefomati evula, yiya kwithebhu yomgaqo. Sibhiyozela ibhokisi yokujonga "Umbutho WeeSeyile". Kwangoko, ezinye iiparamitha zingafakwa: ulwalathiso kunye nokuqhelaniswa kwesicatshulwa, ukwenqanaba ngokuthe tye kunye nokuthe nkqo, ububanzi bobubanzi, ukuhanjiswa ngamagama. Xa zonke iisetingi zenziwe, cofa kwiqhosha "Kulungile".



3. Njengoko ubona, umanyano lweeseli zenzekile.

Indlela 3: Imanyano ngaphandle kwelahleko

Yintoni omele uyenze ukuba kukho idatha kwiiseli ezidityanisiweyo, kuba xa udibanisa onke amaxabiso ngaphandle kweqonga ephezulu? Kule meko, ulwazi luyimfuneko ukusuka kwisisele esinye ukuya kwiseli engapheliyo kulowo ukwiseli yesibini, kwaye ugqithisele kwindawo entsha ngokupheleleyo. Ngale nto, uphawu olukhethekileyo lwe "&" (elibizwa ngokuba "ngumsindo") okanye ifomula "i-funsung (i-Eng. Ikhonkrithi)" inokuhlangabezana nale nto.

Masiqale ngendlela elula. Into ekufuneka uyenzile kukuchaza indlela kwiiseli ezidityanisiweyo kwiseli entsha, kwaye ufake uphawu olukhethekileyo phakathi kwazo. Masixhume iiseli ezintathu ngexesha elinye, ngaloo ndlela besenza umtya wokubhaliweyo.

1. Khetha iseli apho unqwenela ukubona khona iziphumo zomanyano. Kuyo, bhala umqondiso wokulingana "=" kwaye ngokulandelelana ukhethe izikhundla ezithile okanye uluhlu olupheleleyo lwedatha ye-gesing. Phakathi kweseli nganye okanye uluhlu kufuneka lube luphawu lwe-AmUstrant "&". Kumzekelo othile, sidibanisa iiseli "A1", "B1", "c1" kwi "D1". Emva kokungena emsebenzini, cofa u "Enter".



2. Ngenxa yesenzo sangaphambili kwiseli kunye nefomula, zontathu zonke izikhundla zazidityaniswe kwenye.



3. Ukwenzela ukuba isicatshulwa ekugqibeleni, unokongeza izithuba phakathi kweeseli. Kuyo nayiphi na ifomula, ukongeza izehlo phakathi kwedatha, kufuneka ufake indawo kwizibiyeli. Ke ngoko, faka phakathi "A1", "B1" kwaye "C1" ngale ndlela: "= A1 &" & B1 ".



4. Ifomula icebisa malunga nomgaqo ofanayo-iiseli ezichaziweyo okanye i-ranges ziya kudityaniswa kwindawo onokuthi uyimisele umsebenzi "=". Ukuqwalaselwa komzekelo womntu, endaweni yalo kumsebenzi okhankanywe: "= Bamba (A1;"; B1; "; C1)."; C1). Nceda uqaphele ukuba izithuba ziya kongezwa kwangoko ukuze kube lula. Kwifomula, indawo ithathelwa ingqalelo njengesikhundla esahlukileyo, oko kukuthi, songeza indawo kwiseli ye-A1, emva koko i-B1 iseli njalo njalo.



5. Ukuba ufuna ukususa idatha yemithombo esetyenziselwa ukudibanisa, ukushiya kuphela iziphumo, ungakopa loo ngcaciso isetyenzisiweyo njengexabiso kwaye ususe iikholamu ezongezelelweyo. Ukwenza oku, ikopi yexabiso eligqityiweyo kwiseli "ye-D1" ye-"CTRL + C" izitshixo, cofa ekunene kwiseli yasimahla kwaye ukhethe "amaxabiso".



6. Ngenxa yoko - isiphumo esicocekileyo ngaphandle kwefomula kwiseli. Ngoku ungacima ulwazi lwangaphambili olufanelekileyo.

Ukuba isisele esiqhelekileyo esidibanisa kwiNkqubo ye-Microsoft Excel ilula kakhulu, ke noMbutho weeseli ngaphandle kwelahleko kuya kufuneka zibhalwe. Nangona kunjalo, oku kukwenziwa ngumsebenzi wolu hlobo lwenkqubo. Ukusetyenziswa kweempawu kunye nabalinganiswa abakhethekileyo kuya konga ixesha elininzi ekusebenzeni kwesixa esikhulu solwazi.