Imisebenzi evuthayo yilezo zisebenza ku-Excel nakwezinye izinhlelo zespredishithi ezidala amangqamuzana lapho imisebenzi ikhona ukuze ivuselele njalo uma ishidi lomsebenzi liphindaphindiwe. Imisebenzi eguquguqukayo ivuselela ngisho noma, noma idatha abaxhomeke kuyo, ayibonakali ukuthi ishintshile.
Ngaphezu kwalokho, noma yiluphi uhlobo oluxhomeke ngqo noma ngokungaqondile esitokisini oluqukethe umsebenzi oluyinkimbinkimbi luzophinde lubuyele kabusha njalo lapho kulungiswa kabusha. Ngenxa yalezi zizathu, ukusetshenziswa kwemisebenzi eminingi eningi emkhakheni omkhulu wokusebenzela noma ebhukwini kungakwazi ukwandisa kakhulu isikhathi esidingekayo sokuvuselelwa.
Umsebenzi ovamile futhi ongavamile
Ezinye zezinto ezivame ukusetshenziselwa ukuzithokozisa:
- umsebenzi we- MAN
- umsebenzi wanamuhla
- umsebenzi we- RAND
kuyilapho imisebenzi engavamile engasetshenziswa kakhulu ihlanganisa:
Isibonelo somsebenzi ovuthiwe
Njengoba kuboniswe esithombeni ngenhla,
- iselula D1 iqukethe umsebenzi we- = RAND (), odala inombolo entsha engahleliwe nokuhlelwa kabusha kwephepha lokusebenzela
- iseli D2 iqukethe ifomula = D1 + 5, eyenza ukuthi ixhomeke ngokuqondile ngenani eliselilini D1
- iselula D3 iqukethe ifomu = D2 - 10, okwenza ukuthi ixhomeke ngokuqondile ngenani eliselifini D2 futhi, ngenxa yalokho, ixhomeke ngqo ngokubaluleka kwiseli D1
Ngakho-ke, isikhathi ngasinye sokuvuselelwa kwephepha lokusebenza kusebenza, amanani kumaseli e-D2 no-D3 azoguquka kanye nenani ku-cell D1 ngoba kokubili i-D2 ne-D3 zixhomeke ngokuqondile noma ngokungaqondile ngenombolo ehleliwe eyenziwe umsebenzi we-RAND ongathandeki ku-D1.
Izenzo ezenza Ukuqagela
Izenzo ezivamile eziqala ishidi lokusebenzela noma ukulungisa kabusha ibhuku zihlanganisa:
- ukungena kwedatha entsha ngenkathi kumodi yokuvuselela okuzenzakalelayo okuzenzakalelayo kuwo wonke ama-workbook ku-Excel
- ungeze noma ususe imigqa noma amakholomu kushidi lokusebenzela
- ukufihla noma imigqa engavimba (kodwa hhayi amakholomu) ngaphakathi kwephepha lokusebenzela
- Ukuqamba kabusha ishidi lokusebenzela
- ukuvuselela ama-worksheets ngaphakathi kwebhuku lokusebenzela
- engeza, ukuhlela, noma ukususa uhla olubizwa ngokuthi
- ngenkathi kumodi yokubuyisa ibhukwana, ucindezela ukhiye we-F9 ekhibhodi ephoqa, kuzo zonke izincwadi zomsebenzi ezivulekile, ukulungisa kabusha amaseli aqukethe amafomula noma amafomula athembekile ashintshile kusukela ekubalweni kokugcina.
- ngenkathi kumodi yokubuyisa amabhuku, ukucindezela i-SHIFT + F9 ekhibhodi ephoqa, kumsebenzi osebenzayo kuphela, ukulungiswa kabusha kwamaseli aqukethe amafomula noma amafomula athile asetshenziswe kusukela ekubalweni kokugcina.
- ngenkathi kumodi yokubuyisela amabhuku, ngokucindezela i-CTRL + ALT + F9 ekhibhodi ephoqa ukuvuselelwa kwazo zonke amafomula kuzo zonke izincwadi zokusebenzela kungakhathaliseki ukuthi zishintshile noma cha kusukela ekubalweni okugcina
Ukufometha okunemibandela nokuqalwa kabusha
Amafomu okunemibandela kudingeka ahlolwe ngesibalo ngasinye ukuze athole ukuthi izimo ezenza ukuthi izinketho zokufometha ezicacisiwe zisetshenziswe. Ngenxa yalokho, noma iyiphi ifomula esetshenziselwa ukubaluleka kokufometha okunemibandela ngokuphumelelayo iba yinto engavamile.