Esinye sezici eziyinhloko ze-Microsoft Excel yikhono lokusebenza ngamafomula. Lokhu kunciphisa kakhulu futhi kuphuthumise inqubo yokubala amanani, futhi ubonise idatha oyifunayo. Leli thuluzi yisici esiyingqayizivele sesicelo. Ake sibone ukuthi singakha kanjani amafomula ku-Microsoft Excel, nokuthi singasebenza kanjani nabo.
Ukwakha amafomula alula
Amafomula alula kunawo wonke ku-Microsoft Excel yizinkulumo zokusebenza kwe-arithmetic emkhatsini wedatha esesitokisini. Ukuze udale ifomula efanayo, okokuqala, sibeka uphawu olulinganayo esitokisini okufanele lukhiphe umphumela olutholakala ekusebenzeni kwe-arithmetic. Noma ungama esitokisini, bese ufaka uphawu olulinganayo ebhawulweni yefomula. Lezi zenzo zilingana futhi ziphindwe ngokuphindaphindiwe.
Bese ukhetha iseli ethize eligcwele idatha, bese ufaka uphawu lwesibhamu olufunayo ("+", "-", "*", "/", njll). Lezi zimpawu zibizwa ngokuthi ama-formula operators. Khetha iseli elilandelayo. Ngakho siphinda kuze kube yilapho wonke amangqamuzana esiwadingayo angeke ahileleke. Ngemuva kokuthi le nkulumo ingeniswe ngokugcwele, ukuze ubuke umphumela wokubala, cindezela inkinobho yokungena kwikhibhodi.
Izibonelo zokubala
Ake sithi sinetafula lapho kubonakala khona inani lempahla, futhi intengo yunithi yayo. Sidinga ukwazi izindleko eziphelele zento ngayinye. Lokhu kungenziwa ngokuphindaphinda ubuningi ngentengo yezimpahla. Siba isikhombisi esitokisini lapho inani kufanele liboniswe khona, bese ufaka uphawu olulinganayo (=) lapho. Okulandelayo, khetha iseli ngobuningi bezimpahla. Njengoba ubona, ukuxhuma kuso ngokushesha kubonakala emva kwesignali esilinganayo. Khona-ke, emva kwezixhumanisi zeseli, udinga ukufaka uphawu lwe-arithmetic. Kulesi simo, kuyoba uphawu lokuphindaphinda (*). Okulandelayo, chofoza esitokisini lapho idatha ifakwa khona ngentengo ngayinye. Ifomula ye-arithmetic ilungile.
Ukuze ubuke umphumela walo, mane ucindezela inkinobho yokungena kwikhibhodi.
Ukuze ungangeni kuleli fomu isikhathi ngasinye ukubala izindleko eziphelele zento ngayinye, vele uhambise isikhombisi ekhoneni elingezansi ngakwesokudla leseli ngomphumela, bese uyihudula phansi yonke indawo emigqeni lapho igama lento likhona khona.
Njengoba ubona, ifomula yakopishwa, futhi izindleko eziphelele zibalwa ngokuzenzakalelayo ngohlobo ngalunye lomkhiqizo, ngokusho kwedatha ngobuningi bayo kanye nentengo.
Ngendlela efanayo, kungenzeka ukubala amafomula ngezenzo eziningana, futhi ngezibonakaliso ezahlukene zezibalo. Eqinisweni, amafomu e-Excel ahlanganiswa ngokuvumelana nemigomo efanayo nezibonelo ezivamile zezibalo zezibalo. Ngesikhathi esifanayo, cishe i-syntax efanayo isetshenziswa.
Masicindezele lo msebenzi ngokuhlukanisa ubuningi bezimpahla etafuleni zibe ngamabhakethi amabili. Manje, ukuze sithole izindleko eziphelele, kuqala sizodinga ukwengeza ubungako bokubili kokuthunyelwa, bese sibandisa umphumela ngamanani. Ku-arithmetic, izenzo ezinjalo zizokwenziwa ngokusebenzisa abazali, kungenjalo isenzo sokuqala sizokwenziwa ngokuphindaphindiwe, okuzoholela ekubaleni okungalungile. Sisebenzisa amabakaki, futhi ukuxazulula le nkinga ku-Excel.
Ngakho, sibeka uphawu olulinganayo (=) esitokisini sokuqala sekholomu "Sum". Bese uvula ibhakhashi, chofoza esitokisini sokuqala kukholomu "ye-batch", faka isibonakaliso esengeziwe (+), chofoza esitokisini sokuqala kukholomu "ye-batch". Okulandelayo, vala isibakaki, bese usetha uphawu lokuphindaphinda (*). Chofoza kuseli lokuqala kukholomu "Intengo". Ngakho sathola ifomula.
Chofoza inkinobho yokungena ukuze uthole umphumela.
Ngendlela efanayo yokugcina, usebenzisa indlela yokudonsa, sikopisha leli fomu kwezinye imigqa yetafula.
Kumele kuqashelwe ukuthi akuzona zonke lezi fomula kufanele zitholakale kumaseli aseduze, noma ngaphakathi kwetafula elifanayo. Bangase babe kwelinye itafula, noma ngisho nakwenye ishidi lombhalo. Lolu hlelo luzoqhubeka lubala kahle umphumela.
I-Calculator
Noma, umsebenzi omkhulu we-Microsoft Excel ukubalwa ematafuleni, kodwa isicelo singasetshenziswa, futhi njengendlela yokubala elula. Kulula nje, sibeka uphawu olulinganayo, futhi sifaka izenzo ezidingekayo kunoma iyiphi iseli leshidi, noma singabhala izenzo ezenzeni yefomula.
Ukuthola umphumela, chofoza inkinobho yokungenisa.
Izitatimende eziyinhloko ze-Excel
Ama-opharetha amakhulu abalo asetshenziswa ku-Microsoft Excel afaka okulandelayo:
- = ("uphawu olulinganayo") - alinganayo;
- + ("plus") - ngaphezu;
- - ("khipha") - ukususa;
- ("i-asterisk") - ukubuyabuyelela;
- / ("slash") - ukwahlukana;
- ^ ("circumflex") - ukucacisa.
Njengoba ungabona, i-Microsoft Excel inikeza ithuluzi eliphelele lomsebenzisi ukwenza imisebenzi ehlukahlukene yezibalo. Lezi zenzo zingenziwa kokubili ekulungiseleleni amatafula futhi ngokwahlukana ukubala umphumela wemisebenzi ethile ye-arithmetic.
