Imisebenzi enomsebenzi yile mi sebenzi kwi-Excel nakwezinye iiprogram ze-spreadsheet ezenza iiseli apho imisebenzi ikhona ukuze ihlaziywe rhoqo xa iphepha lokusebenzela liphinde lenzeke kwakhona. Imisebenzi ephilileyo ibuyele kwakhona ukuba ngaba, okanye idatha exhomekeka kuyo, ayibonakali iyatshintshile.
Ukongezelela, nayiphi na ifom exhomekeke ngqo okanye ngokungathanga ngqo kwiiseli equkethe umsebenzi ongathandekiyo iya kuphinda iphinde ibuyele kwakhona rhoqo emva kokuba kuqhutywe kwakhona. Ngenxa yezi zizathu, ukusetyenziswa kwemisebenzi eminingi eninzi kwiphepha elibanzi lomsebenzi okanye incwadi yokusebenzela inokwandisa kakhulu ixesha elifunekayo lokubuyisela.
Umsebenzi oqhelekileyo kunye ongaqhelekanga
Ezinye zezinto eziqhelekileyo ezisetyenziswayo zilandelayo:
- Umsebenzi OMSEBENZI
- Umsebenzi weTODAY
- umsebenzi weRAND
ngelixa imisebenzi engasetyenziswanga ngokuqhelekileyo ibandakanya:
Umsebenzi oHloniphekileyo
Njengoko kuboniswe kumfanekiso ongentla,
- iseli D1 iqulethe = umsebenzi we-RAND (), ovelisa inombolo entsha engahleliweyo kunye nokuhlaziywa kwakhona kwephepha lokusebenzela
- iseli D2 iqulethe i-formula = D1 + 5, eyenza ixhomekeke ngqo kwixabiso kwi-cell D1
- iseli D3 iqulethe i-formula = D2 - 10, eyenza ixhomekeke ngokuthe ngqo kwixabiso kwi-cell D2 kwaye, ngenxa yoko, kuxhomekeke ngqo kwixabiso kwi-cell D1
Ngako oko, ixesha ngalinye ixesha lokuphindaphinda iphepha lokusebenzela, ixabiso kwiiseli zeD2 kunye ne-D3 ziya kutshintsha kunye nexabiso kwi-cell D1 kuba zombini i-D2 ne-D3 zixhomekeke ngqo okanye ngokungathanga ngqo kwinani elingenangqungquthela elenziwe ngumsebenzi we-RAND ongenakwenzeka kwi-D1.
Iimpawu ezenza Ukuqwalaselwa kwakhona
Izenzo eziqhelekileyo ezibangele iphepha lokusebenzela okanye ukulungiswa kwincwadi yokusebenza ziquka:
- ukungena kwedatha emitsha ngelixa kwimodi yokumisela ngokuzenzekelayo eyona epheleleyo kuzo zonke iincwadi zokusebenzela kwi-Excel
- ukongeza okanye ukususa imigqa okanye iikholomu kwiphepha lokusebenzela
- iindawo zokufihla okanye ezingagungqiyo (kodwa kungekhona iikholomu) ngaphakathi kwiphepha lokusebenzela
- Ukuqamba kwakhona iphepha lokusebenzela
- ukubuyisela kwakhona iifom ezisebenzayo ngaphakathi kwincwadi yokusebenzela
- ukongeza, ukuhlela, okanye ukususa uluhlu oluthiwa igama
- ngelixa kwimodi yokuqhawula umyalezo, ucinezela iqhosha le-F9 kwibhodibhodi enamandla, kuzo zonke iincwadi zokusebenzela ezivulekileyo, ukulungiswa kwakhona kweeseli ezinamafomula okanye iifomula ezithe zatshintshile ukususela ekubaleni kokugqibela.
- ngelixa ekhompyutheni yokuqwalasela incwadi, ucinezela i-SHIFT + F9 kwibhodibhodi enamandla, kwiphepha elisebenzayo kuphela, ukulungiswa kwakhona kweeseli ezinamafomula okanye iifomula ezithe zatshintshile ukususela ekubaleni kokugqibela.
- ngelixa ekhompyutheni yokuqwalasela incwadi, ucinezela i-CTRL + ALT + F9 kwikhibhodi enokubangela ukulungiswa kwakhona kweefomula kuzo zonke iincwadi zokusebenzela kungakhathaliseki ukuba zitshintshile okanye zingekho ukusuka ekubaleni kokugqibela
Ukufomathiza nokuFometha
Iifomati zemiqathango kufuneka zihlolwe ngokubala nganye ukuba zenze ukuba ngaba iimeko ezibangele ukhetho olukhethiweyo oluya kusetyenziswa luyaqhubeka. Ngenxa yoko, nayiphi na ifomula esetyenziswa kumgaqo wesimo somgaqo-nkqubo usebenza ngokukhawuleza.