Ibha yefomula engekho ku-Excel - okufanele ukwenze. Izixazululo ezi-3 zenkinga uma ibha yefomula inyamalala

Enye yezindawo ezibaluleke kakhulu kuhlelo lokusebenza lwe-Excel ibha yefomula. Inhloso yawo isekelwe ekwenzeni izibalo kanye nokuhlela okuqukethwe kwamaseli. Okukhethekile kwebha yefomula ukuthi ngokugqamisa iseli ngevelu yokugcina, ukuboniswa kwezenzo ezenziwe ezibalweni kuzofakwa. Ngeshwa, ngezinye izikhathi izimo ziphakama lapho le nkinobho inyamalala kuphaneli ye-Excel. Sizohlaziya izimo eziningana ezingase zibangele izinkinga ezinjalo, nokuthi zixazululwa kanjani ngezindlela ezilula.

Ibha yefomula inyamalele: siyini isizathu

Kunezizathu ezimbili kuphela eziyinhloko zokuthi kungani lesi sixhumi esibonakalayo singanyamalala kubha yamathuluzi - lolu wushintsho kuzilungiselelo ze-Excel kanye nokwehluleka kwesoftware. Kodwa zihlukaniswe ngamacala anemininingwane eyengeziwe.

Isizathu #1: Shintsha izilungiselelo zokuphakelayo

Lolu hlobo lwenkinga lungenzeka ngemva kokuthi umsebenzisi esuse ukumaka ngephutha into enesibopho sokusebenza kwebha yefomula. Ake sibone ukuthi ungayixazulula kanjani inkinga:

1. Phezulu kwebha yamathuluzi kunenkinobho ethi Buka.
2. Ngokuhambisa ikhesa bese ucindezela inkinobho engakwesokunxele, siya kuthebhu ehambisanayo.
3. Ngemva kokuthola umugqa wefomula, bheka ukuthi ukhona yini umaka phambi kwawo. Faka uma kunesidingo.
4. Njengomphumela wezenzo ezithathiwe, ulayini uzophinde uvele kusixhumi esibonakalayo sohlelo.

Qaphela! Awudingi ukuqala kabusha uhlelo noma ikhompuyutha ukuze ulungise izilungiselelo.

 Isizathu #2: Izilungiselelo Zezinketho ze-Excel Zishintshile

Ibha yefomula ingase inyamalale ngemva kokuyikhubaza ngephutha noma ngenkani ezinkethweni zohlelo. Ukuxazulula inkinga, kusetshenziswa izindlela ezimbili: eyokuqala ichazwe ngaphambili, futhi ukulungisa inkinga ngendlela yesibili, uzodinga ukukhiqiza kabusha zonke izinyathelo ngokulandelana okufanayo nalapho ukhubaza lo msebenzi. Iyiphi elula futhi eqondakala kangcono kumsebenzisi we-PC ukuthi anqume. Isixazululo ngendlela yesibili:

1. Kubha yamathuluzi, thola “Ifayela” bese uqhubekela phambili.
2. Kuthebhu evulayo, udinga ukuthola "Izilungiselelo". Njengomthetho, i-interface element itholakala phansi kakhulu kohlelo.

3. Okulandelayo, efasiteleni elivulayo, yehlela kulayini "Okuthuthukile", ngemuva kokuchofoza lapho "Izinketho ezengeziwe zokusebenza ne-Excel" zizovela ngakwesokunxele.
4. Ngokuzungezisa isondo legundane, siphakamisa ikhasi phezulu, lapho sithola khona iqembu lezilungiselelo elithi "Isikrini".
5. Kancane kancane ungathola "Bonisa ibha yefomula".
6. Kunalokho, qoka ibhokisi.

Kubalulekile! Ngokungafani nendlela yangaphambilini yokuxazulula inkinga, lena idinga ukuqinisekiswa koshintsho lwezilungiselelo. Ngakho-ke, ukuze izinguquko zisebenze, ngaphansi kwezilungiselelo ezengeziwe zemingcele, udinga ukuchofoza inkinobho ethi "KULUNGILE", okuzosho ukuqedwa kwezenzo.

Isizathu #3: Ukuphahlazeka kohlelo noma inkohlakalo

Ukuxazulula inkinga, uma amaphutha enziwe kuzilungiselelo, alungiswa kalula, kodwa yini okufanele uyenze uma uhlelo luphahlazeka, noma luhluleka ngokuphelele. Kulokhu, udinga ukuzama ukubuyisela i-Excel. Okulandelayo yisibonelo sokubuyisela uhlelo usebenzisa Windows 10 njengesibonelo. Yize izilungiselelo ezinguqulweni zangaphambili zeWindows zicishe zifane:

1. Ekhoneni elingezansi kwesokunxele, chofoza inkinobho ethi "Qala".
2. Kubha yokusesha sibhala "Iphaneli Yokulawula".
3. Ngemva kokutholwa yisistimu, vula uhlelo lokusebenza ngokucindezela inkinobho yegundane kwesokunxele.
4. Kuhlelo lokusebenza oluvulayo, udinga ukusetha ukubukeka kwezithonjana kube kuncane bese uye kokuthi "Izinhlelo Nezici".
5. Iwindi Lokukhipha/Shintsha Izinhlelo lizovuleka. Lapha sithola uhlelo lokusebenza esiludingayo (kulokhu, i-Microsoft Excel noma i-Office) bese uchofoza kwesokudla kuso. Ebhokisini lengxoxo elivelayo, udinga ukuvula inkinobho ethi "Shintsha". Futhi, ukusebenza kungenziwa ngokuchofoza igama lohlelo ngenkinobho yesokunxele bese uchofoza unhlokweni wohlu lwento esibonakalayo evele "Shintsha".

6. Lapho nje ukuqala koshintsho kuqinisekisiwe, iwindi elisha lokubuyisela uhlelo lizovuleka. Lapha udinga ukukhetha enye yezindlela. Njengomthetho, "Ukubuyisela Ngokushesha" kwanele, okungadingi uxhumano lwe-inthanethi. Ngakho-ke, simisa ukukhetha kwethu kule nto bese uchofoza inkinobho ethi "Buyisela".

Iwindi elithi "Khipha futhi ushintshe uhlelo" liqukethe iphakheji evamile ye-Microsoft Office, ngemva kokuqala izinguquko, ukutholwa okugcwele kwazo zonke izinhlelo ezifakwe kulo mkhiqizo ezivela ku-Microsoft kuzokhiqizwa kabusha. Linda ukuthi inqubo iqede futhi uqinisekise ukuthi ibha yefomula ivela endaweni yayo. Uma lokhu kungenzeki, bheka indlela yesibili.

Iseluleko! Indlela yesibili "Buyisela phezu kwenethiwekhi" ikhethwa kuphela uma kungekho lutho olushintshile ngemva kwendlela yokuqala. Kudinga isikhathi esengeziwe kanye noxhumano lwe-inthanethi oluzinzile.

Isiphetho

Uma uhlonza inkinga ngokulahleka kwebha yefomula, awudingi ukuphelelwa ithemba nokwethuka. Sicela ufunde lesi sihloko kuqala. Mhlawumbe isizathu kwaba ushintsho ngephutha kuzilungiselelo zohlelo, okulungiswa indaba imizuzu. Esimweni esibi kakhulu, lapho uhlelo luphahlazeka, uzodinga ukubuyisela i-Microsoft Office, nayo eyenziwa kalula uma ulandela yonke imiyalelo.