Inani elizenzekelayo lemitya yokusebenza kwi-Excel. Iindlela ezi-3 zokumisela inani elizenzekelayo lemiqolo kwi-Excel

Xa usebenza netafile, amanani anokufuneka. I-IT ikwakhiwe, ikuvumela ukuba ungene ngokukhawuleza kwaye ujonge idatha eyimfuneko. Ekuqaleni, inkqubo sele inenombolo, kodwa iyinto eqingqiweyo kwaye ayinakutshintshwa. Kucingelwa ukuba ingene ngesandla ingena kwinani elilungele, kodwa alithembelekanga, kunzima ukuyisebenzisa xa usebenza neetafile ezinkulu. Ke ngoko, kule nto siza kujonga ngeendlela ezintathu eziluncedo kwaye zisebenzisa iindlela zokusebenzisa iinombolo zetafile ye-Excel.

Indlela yoku-1: Inani emva kokuzalisa imiqolo yokuqala

Le ndlela yeyona ilula kwaye isetyenziswa kakhulu xa isebenza neetafile ezincinci neziphakathi. Kuthatha ubuncinci bexesha kwaye kuqinisekile ukuba ungaphandle kwazo naziphi na iimpazamo kwinani. Imiyalelo yamanyathelo ngamanyathelo ajongeka ngolu hlobo:

1. Okokuqala ufuna ukwenza ikholamu yokuthatha ukhetho kwitafile eya kulwenzelwe ukuba ungaphezulu.
2. Nje ukuba kudalwe ikholamu, kumgca wokuqala, faka inani 1 ngowesibini, kwaye kumgca wesibini, faka idijithi 2.

Yenza ikholamu kwaye ugcwalise iiseli

1. Khetha iiseli ezimbini ezalisiweyo kunye nokuhamba kwikona esezantsi yendawo ekhethiweyo.
2. Nje ukuba i icon emnqamlezo emnyama ivela, ibambe i-LKM kwaye ilule indawo ukuya esiphelweni setafile.

Yolula inani kulo lonke uluhlu lwetafile

Ukuba yonke into yenziwe ngokuchanekileyo, ikholamu yenani iya kuzaliswa ngokuzenzekelayo. Oku kuyakwanela ukufezekisa iziphumo ozifunayo.

Iziphumo zomsebenzi owenziweyo

Indlela 2: Umqhubi womtya

Ngoku siya kwindlela elandelayo yenombolo, ebonisa ukusetyenziswa komsebenzi "womtya" okhethekileyo:

1. Okokuqala, kuya kufuneka wenze ikholamu ngenxa yenani, ukuba akukho mntu.
2. Kumtya wokuqala wale kholamu, faka ifomula yesiqulatho esilandelayo: = Umgca (A1).

Sazisa ifomula kwiseli

1. Emva kokungena kwifomula, qiniseka ukuba ucinezela iqhosha elithi "ENTER", esebenza umsebenzi, kwaye uya kubona umzobo 1.

Gcwalisa iseli kwaye wolule inani

1. Ngoku ihlala ifana nendlela yokuqala yokuzisa isikhombisi kwikona esezantsi yendawo ekhethiweyo, linda umnqamlezo omnyama kwaye wolule indawo ekupheleni kwetafile yakho.
2. Ukuba yonke into yenziwe ngokuchanekileyo, kuya kuzaliswa ikholamu kunye nenombolo kwaye inokusetyenziselwa ukukhangela ulwazi.

Siqikelela iziphumo

Kukho enye indlela, ukongeza kwindlela echaziweyo. Kuyinyani, kuya kuba yimfuneko ukusebenzisa imodyuli ye "Master":

1. Ngokufanayo, yenza ikholamu yenombolo.
2. Cofa kwiseli yokuqala yomgca wokuqala.
3. Ukusuka phezulu kufutshane nomtya wokukhangela cofa kwi icon "fx" icon.

Sebenzisa "inkosi yemisebenzi"

1. I "Umsebenzi Master" uvuliwe, apho kufuneka ucofe khona kwinqaku elithi "Udidi" kwaye ukhethe "Amakhonkco kunye CRYS".

Khetha amacandelo afunekayo

1. Ukusuka kwimisebenzi ecetywayo, uya kukhetha ukhetho "umgca".

Sebenzisa umsebenzi "Umtya"

1. Iwindows eyongezelelweyo iya kuvela kulwazi. Kuya kufuneka ubeke into yesikhombisi kwi "Referet" kunye nenkcazo yedilesi yeselfowuni yokuqala yekholamu yenombolo (kwimeko yethu yi-A1).

Gcwalisa idatha efunekayo

1. Enkosi kwizenzo ezenziwe kwiseli yokuqala engenanto, kuyavela inombolo. 1. Kuhlala kwakhona ukusebenzisa i-angle esezantsi yendawo ekhethiweyo yokuluka kuyo yonke itafile.

Yolula umsebenzi kulo lonke uluhlu lwetafile

Ezi zenzo ziya kunceda ukufumana zonke iinombolo eziyimfuneko kwaye aziyi kunceda ukuba ungaphazanyiswa ngamaqhinga anjalo ngelixa usebenza netafile.

Indlela 3: Ukusetyenziswa kwenkqubela phambili

Kwaye le ndlela yahlukile kwezinye izinto ezisusa abasebenzisi kwimfuno yokusebenzisa uphawu lwe-Autofle. Lo mbuzo ubaluleke kakhulu, kuba isicelo sayo asisebenzi xa sisebenza neetafile ezinkulu.

1. Yenza ikholamu yenani kunye nenqaku kwinombolo yokuqala yeseli 1.

Yenza isenzo esisisiseko

1. Yiya kwi-Toolbar kwaye usebenzise icandelo "lasekhaya", apho siya kwicandelwana "lokuhlela" kwaye sijonge i-icon ye-arrow phantsi (xa usiya kunika igama "gcwalisa").

Yiya kwi "nkqubela"

1. Kwimenyu eyehlayo kufuneka usebenzise umsebenzi "ukuqhubela phambili".
2. Kwifestile evelayo, kufuneka kwenziwe oku kulandelayo:

Gcwalisa ulwazi oluyimfuneko

1. Ukuba yonke into yenziwe ngokuchanekileyo, uya kubona iziphumo zokuzikhethela ezenzekelayo.

Iziphumo ezifunyenweyo

Kukho enye indlela yokwenza inani elinje elikhangeleka ngolu hlobo:

1. Siphinda inyathelo ukwenza ikholamu kunye nophawu kwiseli yokuqala.
2. Saba uluhlu lwetafile oceba ukubalwa.

Sibhiyozela uluhlu lwetafile

1. Yiya kwicandelo "lasekhaya" kwaye ukhethe icandelwana "lokuhlela".
2. Sikhangela into ethi "Gcwalisa" kwaye ukhethe "inkqubela-phambili".
3. Kwifestile evelayo, siphawula idatha efanayo, inyani ngoku ayizalisi into ethi "umda intsingiselo".

Gcwalisa idatha kwifestile eyahlukileyo

1. Cofa kwi "Kulungile".

Olu khetho luxhaphake ngakumbi, kuba aludingi ukubalwa kwezinto ezinyanzelekileyo ngemigca efuna inombolo. Kuyinyani, nangayiphi na imeko kuya kufuneka wabele uluhlu ekufuneka lubalwe.

Isiphumo

Ukuqukumbela

Inombolo yomqolo inokwenza lula umsebenzi ngetafile efuna ukuhlaziywa rhoqo okanye ukukhangela ulwazi olufunayo. Ngenxa yemiyalelo eneenkcukacha echazwe apha ngasentla, unokukhetha esona sisombululo siphezulu sokusombulula umsebenzi.

Umyalezo ozenzekelayo ozenzekelayo wemitya yokusebenza kwi-Excel. Iindlela ezi-3 zokumisela imitya yokuzila ngokuzenzekelayo kwi-Excel ivele kuqala kwitekhnoloji yolwazi.