Ukuqhekeza isicatshulwa kwiikholamu kwi-Excel

Ukwahlula okubhaliweyo kwiseli enye kwiikholamu ezininzi ngelixa ugcina ulwazi oluqhelekileyo yingxaki enokuthi idibane nayo abasebenzisi be-Excel. Ukwaphula isicatshulwa kwiikholamu, iindlela ezahlukeneyo zisetyenziswa, ezichazwe ngokusekwe kulwazi olucetywayo, isidingo sokufumana iziphumo zokugqibela kunye nenqanaba lobuchule bomsebenzisi.

Kuyimfuneko ukwahlula igama ngokweekholamu zomntu ngamnye

Ukufezekisa umzekelo wokuqala, thatha itafile ngamagama abantu abahlukeneyo ababhaliswe kuyo. Oku kwenziwa kusetyenziswa isicatshulwa kwizixhobo zekholamu. Emva kokufumana elinye lamaxwebhu, kwafunyanwa impazamo: Amagama kunye namagama ePatrolismic abhalwe kwikholamu enye, edale into ethile yokugqitywa kwamaxwebhu. Ukufumana iziphumo ezifanelekileyo, kuya kufuneka wenze ukwahlulwa kwegama ngokweekholamu zomntu ngamnye. Ungayenza njani - qwalasela ngakumbi. Inkcazo yezenzo:

1. Vula uxwebhu ngempazamo yangaphambili.
2. Sibonisa isicatshulwa ngokuvala i-LKM kwaye sisolula ukhetho kwiseli esezantsi kakhulu.

Nye

1. Kwi-ribbon ephezulu sifumana "idatha" -ya.

2.

1. Emva kokuvula, ndifumana "umsebenzi kunye" neqela "ledatha" kwiqela "kwikholamu". Cofa i-LKM uye kule bhokisi yencoko yababini.

3.

1. Ngokungagqibekanga, ifomathi yedatha yemithombo iya kusetwa "nge-sarators". Shiya iqhosha "iqhosha elilandelayo".
2. Kwiwindows elandelayo, kuyimfuneko ukufumanisa ukuba yintoni umahluko kwisicatshulwa sethu. Sinayo le "indawo", oko kuthetha ukuba sifaka uphawu lokuxapha elixabiso kwaye sivumelane nezenzo ezenziwa ngezenzo kwi-Arhente iqhosha "elilandelayo".

ezine

1. Emva koko kuya kufuneka ubone ifomathi yedatha yekholamu. Ngokungagqibekanga, "jikelele" ifakiwe. Ngolwazi lwethu, le fomathi ifanelekile kakhulu.
2. Etafileni, khetha iseli apho isicatshulwa esiyifomati siya kubekwa khona. Siza kumka kwimvelaphi yomthombo omnye kwaye sazise i-sodresee ehambelanayo kwifowuni yeseli. Ekupheleni, cofa u "Gqibezela".

Ntlanu

6.

Itekisi yohlulwa usebenzisa ifomula

Iifomula ezintsonkothileyo zingasetyenziselwa ukwahlula-hlula okuzimeleyo. Bayafuneka ukubala ngokuchanekileyo isikhundla samagama kwiseli, ukufunyanwa kwezithuba kunye nokwahlula-hlula igama ngalinye ukuyahlukanisa iikholamu. Umzekelo, siya kusebenzisa itafile ngegama. Ukwahlula, kuya kufuneka wenze amanqanaba amathathu osebenza.

Inombolo yenyathelo 1. Dlulisa iifani

Ukwahlula igama lokuqala, kuya kuthatha ixesha elincinci, kuba ukufumanisa indawo efanelekileyo ekufuneka uyityhutyha isithuba esinye kuphela. Emva koko, siya kuhlalutya imiyalelo yenyathelo ngenyathelo ukuze siqonde ukuba ukubalwa kuyafuneka njani kwityala elithile.

1. Itheyibhile enegama elibhaliweyo sele lenziwe. Ukulungiselela ukwenza ukwahlulwa kolwazi, kudale kwindawo eyahlukileyo 3 iikholamu kwaye ikhuphe inkcazo. Chitha uhlengahlengiso lweeseli ngobukhulu.

7.

1. Khetha iseli apho ulwazi malunga negama losapho luya kurekhodwa. Yenza isebenze ngokucinezela i-lkm.

Sibhozo

1. Cofa kwi "mpikiswano kunye nemisebenzi", ukuvuselelwa kwegalelo ekuvuleni kwefestile ukuhlela ifomula.
2. Apha kwicandelo "udidi" kufuneka uskrole phantsi kwaye ukhethe "isicatshulwa".

Thoba

1. Okulandelayo, sifumana ukuqhubeka kweFomula yeLessimv kwaye ucofe kulo mgca. Siyavumelana nezenzo ezenziweyo ngokucinezela iqhosha "Kulungile".
2. Iwindows entsha ivele, apho kufuneka uchaze idilesi yeseli efuna uhlengahlengiso. Ukwenza oku, cofa kubalo "isicatshulwa" kwaye usebenze iseli efunekayo. Ukudibana kuqukwe ngokuzenzekelayo.
3. Ukucacisa inani elifunekayo labalinganiswa, ungabalalisa ngesandla kwaye ufake idatha kwigrafu efanelekileyo okanye ukusebenzisa enye ifomula: Khangela ().
4. Emva koko, ifomula iya kuboniswa kwisicatshulwa seseli. Cofa kuyo ukuvula iwindow elandelayo.

10

1. Sifumana intsimi "Isicatshulwa seSikolo" kwaye ucofe umahluli ochazwe kwisicatshulwa. Kwimeko yethu, esi sisithuba.
2. Kwi- "TOKING YOKUFUNDA" Intsimi yokukhangela ", kufuneka usebenze kwiseli ehleliweyo ebangela ukudluliselwa ngokuzenzekelayo kwidilesi.
3. Yenza umsebenzi wokuqala ukubuyela ukuze uhle. Eli nyathelo liza kubonisa ngokuzenzekelayo inani labalinganiswa ukuya kwindawo.

Shumi elinanye

1. Siyavuma kwaye ucofe iqhosha "Kulungile".

Ngenxa yoko, inokubonwa ukuba iseli ihlengahlengiswa kwaye ifani yenziwa ngokuchanekileyo. Utshintsho lokuqalisa ukusebenza kuyo yonke imigca, tsala i-commation yoKhetho phantsi.

Inombolo yenyathelo 2. Amagama okudluliselwa

Ukwahlula iLizwi leSibini, kuya kuthatha amandla kunye nexesha elincinci, njengoko ukwahlulwa kwegama kwenzeka izithuba ezibini.

1. Njengeefomula eziphambili, sikhuthaza okufanayo kwiNdlela efanayo = i-PSTR (.

12

1. Khetha iseli kwaye uchaze isikhundla apho isicatshulwa sibhalisiweyo.
2. Yiya kwikholam yokuqala "isikhundla sokuqala kwaye ufake ifomula yokukhangela ().
3. Yiya kuyo usebenzisa imiyalelo yangaphambili.

13

1. Kwi "Iskim Itekisi ichaza indawo.
2. Ngokucofa kwisicatshulwa "sokubhaliweyo", vula iseli.

Shumi elinane

1. Sibuyela kwifomula = pst ephezulu kwiscreen.
2. Kwintambo "ye-nach.position" Sibonisa ifomula +1. Iya kuba negalelo ekuqalekeni kweakhawunti ukusuka kwisimboli esilandelayo ukusuka kwisithuba.

Shumi elinantlanu

1. Yiya kwinkcazo yenani labalinganiswa-faka ifomula yokukhangela ().
2. Yiya kule fomula phezulu kwaye ugcwalise yonke idatha sele iqondakale kuwe.
3. Ngoku kwi "NOCOPE.SECE.SEECTION.SEPOTION Yenza olunye utshintsho lwefomyula kwaye ugcwalise yonke imigca ngendlela eyaziwayo, ngaphandle kokufaka nantoni na "kwi-nach.sup.supotions".
4. Yiya kwifomula yangaphambili yefomula kwaye "kwi-nach.position" yongeza +1.
5. Sibuyela kwifomula = pst kunye "nenombolo yemiqondiso" yongeza intetho yokukhangela (""; A2) -1.

Ixabiso le-16 Inani le-3. Gcina i-patrotroymic

1. Ngokuvula iseli kwaye ujike kwimpikiswano yomsebenzi, khetha ifomula yePracemir. Cofa "Kulungile".

17.

1. Kwintsimi "yokubhaliweyo", faka idilesi yeseli ehlelweyo.
2. Apho ufuna ukuchaza inani leempawu, bhala i-DLSTR (A2).

Shumi elinesibhozo

1. Ukuchonga ngokuchanekileyo inani lemiqondiso ekugqibeleni, kufuneka ubhale: -Iporisk ().
2. Yiya kwi-HOMECOM. Kwigama elithi "iskim chaza indawo. Kwi- "Itekisi yokukhangela" - ukujongana neseli. Kwi "NOCOCE.SOCATE" Faka ifomula yokukhangela (). Hlela ifomula ngokuseta intsingiselo efanayo.
3. Yiya kuKhangelo oludlulileyo kunye nomtya "uch.position" wongeza +1.

Shumi elinethoba

1. Yiya kwifomula yePratseMV kwaye uqiniseke ukuba zonke iintshukumo zenziwe ngokuchanekileyo.

Amashumi amabini

Ukuqukumbela

Inqaku liphumelele ngeendlela ezimbini eziqhelekileyo zokwahlula ulwazi kwiisesi kwikholamu. Ukulandela imiyalelo engafakwanga, unokufumana lula ukubanakho kwezi ndlela kwaye uzisebenzise. Ubunzima bokwahlukana kwikholamu usebenzisa iifomula zinokutyhala kwixesha lokuqala labasebenzisi abangenamava, kodwa ukusetyenziswa kwendlela yendlela kuya kunceda ukuyiqhelanisa nokuyisebenzisa kwixesha elizayo ngaphandle kwengxaki.

UMYALEZO WOKUQHUTYWA I-TOOCT kwikholamu kwi-Excel kwi-Excel ivele kuqala kwitekhnoloji yolwazi.