Indlela 1: Inkinobho yokufaka umsebenzi
Inketho esebenzisa inkinobho ekhethekile ukushayela imenyu ethi "Umsebenzi" ilungele abasebenzisi be-novice nalabo abangafuni ukubhala ngesandla esimweni ngasinye, bebheka imininingwane ye-syntax yohlelo.
- Lapho ufaka ifomula, iseli lihlala likhethwe ngokuyinhloko, lapho inani lokugcina lizotholakala ngokuzayo. Kwenze ngokuchofoza kwi-LKM block efanelekile.
- Bese uye kwithuluzi elithi "Insert Funct" ngokuchofoza inkinobho eyabelwe le nkinobho kuphaneli ephezulu.
- Okulandelayo udinga ukuthola isici esifanele. Ukuze wenze lokhu, ungayifaka incazelo emfushane noma uthathe isinqumo esigabeni.
- Bheka uhlu oluseBlock ngezansi ukuze ukhethe umsebenzi ofanayo lapho.
- Lapho kwabelwe ezansi, imininingwane emfushane ngesenzo kanye nesimiso sokuqoshwa sizokhonjiswa.
- Ukuthola imininingwane esetshenzisiwe evela kubathuthukisi, kuzodingeka uchofoze ngosizo olugqamile "ngalo msebenzi".
- Lapho nje ukukhethwa kokusebenza kwenzeka, kuzovela iwindi elihlukile, lapho izimpikiswano zalo zigcwele khona. Isibonelo, sathatha iFomula Max, sibonisa inani eliphezulu kulo lonke uhlu lwezimpikiswano. Ngakho-ke, njengenombolo, uhlu lwamangqamuzana afakiwe ebangeni lokubala lisethwe lapha.
- Esikhundleni sokugcwalisa okwenziwa ngesandla, ungachofoza etafuleni futhi unikeze wonke amaseli ukuze ungene ebangeni elifanayo.
- UMax, njengeminye imisebenzi, ngokwesibonelo, amanani ajwayelekile kakhulu angafaka uhlu lwamaphiko amaningi futhi abala amanani avela kubo bonke. Ukuze wenze lokhu, gcwalisa i-oda elifanayo ngamabhulokhi alandelayo "Inombolo2", "Inombolo3" nokunye.
- Ngemuva kokuchofoza inkinobho ethi "KULUNGILE" noma ukhiye we-ENTER, ifomula ifakwa esitokisini esikhethwe ngaphambilini ngomphumela wokuphumela. Uma uchofoza kuyo kuphaneli ephezulu, uzobona ukuqoshwa kwe-syntax kwefomula futhi, uma kunesidingo, ungakuhlela.
Indlela 2: Ifomula Tab
Qala ukusebenza ngamathuluzi okufaka amafomula, obekubhekwe ngenhla, awukwazi kuphela ngosizo lwenkinobho yokwakha umsebenzi, kepha futhi kuthebhu ehlukile lapho kukhona amanye amathuluzi ahehayo.
- Chofoza ithebhu yefomula ngephaneli ephezulu.
- Ukusuka lapha ungavula iwindi le- "Inction Work", uqale ukuludala, khetha ifomula kusuka kumtapo wezincwadi noma usebenzise ithuluzi le-Avosson, esiphakamisa ukuthi likucabangele.
- Kuzodingeka ukuthi ukhethe wonke amaseli okumele afingqeniswe, bese uqhafaza kulayini we-Avosson.
- Ifomula ifakwa ngokuzenzakalelayo ngayo yonke impikiswano, futhi umphumela uzoboniswa ekugcineni kwamabhulokhi weseli ebangeni.
Indlela 3: Ukudalwa Kwezincwadi Zefomula
Kwesinye isikhathi kulula ukusebenzisa indlela yezandla yokufaka amafomula, ngoba i-Creation Wizard kungenzeka ingakwazi ukubhekana nalo msebenzi, ngokwesibonelo, uma kukhulunywa ngenani elikhulu lezimo uma noma ezinye izici ezijwayelekile. Ezimweni ezinjalo, gcwalisa iseli ngokuzimela ngokushesha futhi kube lula.
- Njengoba sekushiwo ngendlela yokuqala, ukuqala, khetha iseli lapho ifomula kufanele itholakale khona.
- Bhala uphawu "=" enkundleni yokufaka phezulu noma kwisiliva uqobo, okuyosho ukuqala kwefomula.
- Bese usetha umsebenzi uqobo ngokubhala igama lawo. Sebenzisa amathiphu ukuhlinzeka ngokunemba kokubhala, futhi uzijwayeze nezincazelo ezibonakala zithola inhloso yomsebenzi.
- Beka ubakaki wokuvula nokuvala lapho kuzobhalwa khona izimo.
- Gqamisa indawo yamanani noma ubhale amaseli afakiwe ezingxabanweni zakho. Uma kunesidingo, faka izimpawu zokulingana noma ukungalingani kanye nama-degree aqhathanisayo.
- Umphumela wefomula uzoboniswa ngemuva kokucindezela ukhiye we-ENTER.
- Uma kusetshenziswa imigqa noma imigqa eminingana, faka isibonakaliso ";", bese ufaka amanani alandelayo njengoba kuchaziwe ku-Prompts ekhonjiswe esikrinini.
Ekupheleni kwezindlela ezintathu, siphawula ngokuba khona kwendatshana ehlukile kwiwebhusayithi yethu, lapho umbhali ehlukanisa iningi lemisebenzi ewusizo ekhona ku-Excel. Uma nje uqala ukujwayela kwakho ngalolu hlelo, bheka imithetho yokusebenzisa lezo zinketho.
Funda kabanzi: Imisebenzi ewusizo ku-Microsoft Excel
Indlela 4: Ukufaka ifomula yezibalo
Inketho yokugcina ukufaka ifomula noma i-equation, engaba wusizo kubo bonke abasebenzisi abadinga ukudala izinkulumo ezinjalo etafuleni. Ukuze wenze lokhu, indlela elula yokusebenzisa ithuluzi elikhethekile.
- Vula ithebhu ethi "Faka" bese wandise isigaba se- "Symbols".
- Qala ukudala ifomula ngokuchofoza inkinobho "equation".
- Yenza kusebenze indawo ukuze i-equation ishintshe ngokushesha usayizi wayo ukuze kube lula, bese usebenzisa izinhlamvu noma izakhiwo ezenziwe ngomumo zokwenza lula ukudalwa kwefomula.
- Lapho usuqedile, ungahambisa ifomula kunoma iyiphi indawo futhi ushintshe amapharamitha wayo angaphandle.
Uma ngasizathu sesizathu sesizathu sivele ngokubalwa kwamafomula, kungenzeka kakhulu ukuthi kwenziwe ngamaphutha ngokufaka kwazo noma okunye ukungasebenzi kahle. Waziqhenya ngomyalo olandelayo.
Funda kabanzi: Izinkinga ngokubala amafomula ku-Microsoft Excel