Ungawenza njani umhlathana weselfowuni

Ngamanye amaxesha abasebenzisi be-Microsoft e-Excel kufuneka babhalise kwiseli enye yoluhlu lwetafile kwimigca eliqela yesicatshulwa, esenza umhlathi. Ithuba elinjalo e-Excel linokuphunyezwa ngeendlela ezininzi ukusebenzisa izixhobo ezisemgangathweni. Malunga nendlela yokongeza umhlathi kwi-GOPGL yeTheyibhile ye-Excel yeTheyibhile aya kuxelelwa kweli nqaku.

Iindlela zokudluliselwa kwesicatshulwa kwiiseli zetafile

E-Excel, akunakwenzeka ukwenza umhlathi ngokucinezela iqhosha "Ngena" kwikhibhodi yekhompyuter, njengaseLizwi. Apha kuyimfuneko ukusebenzisa ezinye iindlela. Ziya kuxoxwa.

Indlela yokudlulisela isicatshulwa usebenzisa izixhobo zokunxibelelana

Umbhalo wonke wobhalo lwetafile awubekwa ngokulinganayo kwiseli yonke, kuya kufuneka idluliselwe komnye umgca wento enye. Eyona ndlela ilula yokwenza ukuba umsebenzi wahlulwe ngokwala manyathelo alandelayo:

1. Isitshixo sasekhohlo se-wipilator kukuqaqambisa iseli apho umhlathana kufuneka wenziwe khona.

Ukukhetha iseli oyifunayo ukwenza umhlathi kuyo

1. Yiya kwithebhu "yasekhaya", efumaneka kwibar yesixhobo ephezulu yemenyu ephambili yenkqubo.
2. Kwicandelo "lolungelelwaniso", cofa kwiqhosha "lokudluliselwa kwesicatshulwa".

Indlela yokudlulisela iqhosha "lokudluliselwa kwesicatshulwa" kwi-Excel. Isebenza kuzo zonke iinguqulelo zenkqubo

1. Jonga iziphumo. Emva kwento yangaphambili, ubungakanani beseli ekhethiweyo iya kunyuka, kwaye isicatshulwa esikuyo siya kuphinda sakhiwe ibe sisiqendu, songeza imigca eliqela kwinto ethile.

Iziphumo zokugqibela. Isicatshulwa kwiseli esifudukele kumgca omtsha. Indlela yokwenza imihlathana emininzi kwiseli enye

Ukuba isicatshulwa esimiselwe kwindawo ye-Excel iqulethe izibonelelo ezininzi, zinokwahlulwa zababini, ziqala ukunikezela ngalunye kumgca omtsha. Oku kuya kunyusa ubuhewuyisi yoyilo, imbonakalo yeplate iya kuphucuka. Ukufezekisa isahlulelo esinjalo, kubalulekile ukuba sisebenze ngolu hlobo lulandelayo:

1. Khetha iseli yetafile oyifunayo.
2. Jonga umtya ukufaka ifomula ngaphezulu kwemenyu enkulu ye-Excel phantsi kwendawo yezixhobo ezisemgangathweni. Kuyo, isicatshulwa sento ekhethiweyo siyaboniswa ngokupheleleyo.
3. Beka isikhombisi semouse phakathi kweeofisi ezimbini zombhalo kumqolo wokufaka.
4. Tshintshela ikhibhodi yePC kwi-Ekook Ekook kunye ne-Alt + ENTER + ENG "amaqhosha.
5. Qiniseka ukuba izindululo zaye zancedwa, kwaye enye yazo yafudukela kumgca olandelayo. Ke, isiqendu sesibini senziwa kwiseli.

Ukwenza imihlathana emininzi kwiseli enye yoluhlu lwe-Excel Uluhlu

1. Yenza isenzo esifanayo nezinye izivakalisi zombhalo omiselweyo.

Indlela 3. Sebenzisa izixhobo zokufomatha

Le ndlela yokwenza umhlathi kwi-Microsoft i-Excel iquka ukutshintsha ifomati yeeseli. Ukuyisebenzisa, kubalulekile ukwenza amanyathelo alula nge-algorithm:

1. I-LKM ibalaselisa iseli apho isicatshulwa esiyifowuniweyo singabekwa ngenxa yobungakanani obukhulu.
2. Ngayo nayiphi na indawo yento, ulungisa i-wivilator.
3. Kwifestile yokuvula yohlobo lomxholo, cofa kwi "fomu yeseli ..." into.

Indlela yokufikelela kwifestile yefomati ye-Microsoft kwi-IOfisi ye-Microsoft i-Excel

1. Kwimenyu yokufomatha yezinto eziya kuboniswa emva kokwenza i-curiphote yangaphambili, kufuneka uye kwicandelo "lokuhambisa".
2. Kwicandelo elitsha lemenyu, fumana ibhloko "yomboniso" kwaye ubeke uphawu ecaleni kwe "DLULISO NGOKUFANELEKILEYO".
3. Cofa kwi "Kulungile" emazantsi efestile ukuze usebenzise utshintsho.

I-Algorithm ye-Algorithm kwithebhu yokulungelelanisa kwi "fomu yeseli" kwimenyu yesiqendu

1. Jonga iziphumo. Iseli iya kukhetha ngokuzenzekelayo ubungakanani obufunwayo ukuze isicatshulwa singahambi ngaphaya kwemida yayo, kwaye umhlathi uza kudalwa.

Indlela 4. Ukusetyenziswa kwefomula

I-Ofisi yeMicrosoft Excel inefomula ekhethekileyo yokwenza imihlathana, ukuhambisa okubhaliweyo kwimigca eliqela kwiiseli zetafile. Ukufezekisa owona msebenzi, ungasebenzisa le algorithm yezenzo:

1. Khetha iseli ethile yetafile ye-LKM. Kubalulekile ukuba ekuqaleni kwakungekho sibhalo kunye nabanye oonobumba kwinto leyo.
2. Ngesandla kwikhibhodi yekhompyuter Faka ifomula "= ukubamba (" isicatshulwa1 "; isimboli1"; ");" isicatshulwa2 ")" Endaweni yamagama athi "Isicatshulwa1" kunye "nombhalo2", kufuneka uqhube ngexabiso lekhonkrithi, i.e. Bhala abalinganiswa abafunekayo.
3. Emva kokubhala ukucofa kwi "Ngena" ukugqiba ifomula.

Ukusetyenziswa kwefomula ekhethekileyo yokudlulisela imigca kwi-Excel

1. Jonga iziphumo. Isicatshulwa esichaziweyo siya kuba kwimigca eliqela yeseli, kuxhomekeka kumthamo wayo.

Ukongeza njani ifomula yokudala iziqendu kwinani elifunayo leeseli

Ukuba umsebenzisi kufuneka sokutshintshela imiqolo e kanye izinto eziliqela uluhlu itafile usebenzisa ifomula kuxoxwe ngasentla, kwanele ukuba bandise umsebenzi ukuya uluhlu ezichaziweyo iiseli. Ngokubanzi, inkqubo yokuvuselela ifomula kwi-Excel ijongeka ngolu hlobo:

1. Khetha iseli apho iziphumo zefomula ibhalisiwe.
2. Beka isikhombisi semouse ukuya kwi-engile esezantsi yento ekhethiweyo kwaye ikhwele i-lkm.
3. Yolula iseli kwinani elifunayo lemiqolo yoluhlu lwetafile, ngaphandle kokukhulula i-LKM.
4. Khupha isitshixo sasekhohlo se-wipilator kwaye ujonge iziphumo.

Ukuqukumbela

Ngenxa yoko, ukudalwa kweziqendu kwiMicrosoft yeOfisi ye-Excel Centel akubangeli iingxaki nakuBasebenzisi abangenamava. Ukudluliselwa ngokufanelekileyo imigca, kubalulekile ukukhokelwa yimiyalelo engasentla.

Umyalezo njengakwiseli ye-Excel ukwenza isiqendu sivele kuqala kwitekhnoloji yolwazi.