Enye yezinto ezisemqoka zeMicrosoft Excel yikhono lokusebenza ngamafomula. Lokhu kwenza lula futhi kusheshiswe inqubo yokubala imiphumela ephelele, nokubonisa idatha oyifunayo. Leli thuluzi luhlobo lwesici sohlelo lokusebenza. Ake sibheke ukuthi angawakha kanjani amafomula eMicrosoft Excel, nokuthi ungasebenza kanjani nabo.
Dala amafomula alula
Amafomula alula kuMicrosoft Excel ayizinto ezenziwa phakathi kwe-arithmetic phakathi kwedatha etholakala kumaseli. Ukuze wakhe ifomula enjalo, okokuqala, sibeka uphawu olulinganayo esitokisini lapho umphumela wokutholwa ekusebenzeni kwezibalo kufanele ukhonjiswe khona. Noma ungama esitokisini bese ufaka uphawu olulinganayo emgqeni wamafomula. Lezi zenzo ziyafana, futhi ziyaphindwa ngokuzenzakalelayo.
Ngemuva kwalokho sikhetha iseli elithile eligcwele idatha bese sibeka uphawu olufunwayo lwe-arithmetic ("+", "-", "*", "/", njll.). Lezi zibonakaliso zibizwa ngokuthi abasebenza ngefomula. Khetha iseli elilandelayo. Ngakho-ke, phinda kuze kube yilapho wonke amaseli esiwadingayo ehilelekile. Ngemuva kokuthi le nkulumo ifakiwe ngokuphelele, ukuze ubuke umphumela wokubala, cindezela inkinobho ethi Enter kwikhibhodi.
Izibonelo zokubalwa
Ake sithi sinetafula lapho kuboniswa khona inani lezimpahla, nentengo yunithi yalo. Sidinga ukwazi inani eliphelele lezindleko zento ngayinye yezimpahla. Lokhu kungenziwa ngokuphinda inani ngenani lezimpahla. Siba yisikhombisi esitokisini lapho kufanele kukhonjiswe khona isamba, bese sifaka uphawu olulinganayo (=) lapho. Okulandelayo, khetha iseli nenani lezimpahla. Njengoba ukwazi ukubona, ukuxhumana kuyo kuvela ngokushesha emva kophawu olulinganayo. Ngemuva kwalokho, ngemuva kwezixhumanisi zeseli, udinga ukufaka isibonakaliso sesibalo. Kulokhu, kuzoba uphawu lokuphindaphindeka (*). Okulandelayo, sichofoza kuseli lapho idatha ibekwe khona ngentengo yeyunithi. Ifomula ye-arithmetic isilungile.
Ukubuka umphumela wayo, vele ucindezele inkinobho ethi Enter kwikhibhodi.
Ukuze ungafaki le formula ngaso sonke isikhathi ukubala inani lentengo yento ngayinye, vele uhambise isikhombisi ekhoneni elingezansi kweseli ngomphumela, bese ulihudula lisiya kuyo yonke indawo emigqeni lapho into ikhona.
Njengoba ubona, ifomula yakopishwa, futhi izindleko zizonke zabalwa ngokuzenzakalelayo zohlobo ngalunye lomkhiqizo, ngokuya ngobuningi bawo nentengo.
Ngendlela efanayo, umuntu angakwazi ukubala amafomula ezenzweni eziningana, nangezimpawu ezihlukile ze-arithmetic. Eqinisweni, amafomula e-Excel ahlanganiswa ngokuya ngemigomo efanayo lapho kwenziwa khona ezibonelweni ezijwayelekile zezibalo ezibalweni. Kulokhu, cishe i-syntax efanayo iyasetshenziswa.
Senza umsebenzi ube nzima ngokuhlukanisa inani lezimpahla ezisetafuleni zibe ngamabhendi amabili. Manje, ukuze sithole inani eliphelele, kudingeka siqale sengeze isibalo sayo yomibili imithwalo, bese siphindaphindeka ngomphumela ngentengo. Ku-arithmetic, lezo zenzo zenziwa kusetshenziswa amabakaki, ngaphandle kwalokho ukuphindaphindeka kuzokwenziwa njengesenzo sokuqala, okuzoholela ekubalweni okungalungile. Sisebenzisa amabakaki, futhi ukuxazulula le nkinga ku-Excel.
Ngakho-ke, faka uphawu olulinganayo (=) esitokisini sokuqala sekholamu "Sum". Ngemuva kwalokho sivula ibakaki, chofoza kuseli yokuqala kukholamu "1 batch", faka uphawu lokuhlanganisa (+), chofoza iseli yokuqala kukholamu "2 batch". Okulandelayo, vala ubakaki, bese ubeka isibonakaliso ukuze siphindaphindwe (*). Chofoza kuseli lokuqala kukholomu "Intengo". Ngakho-ke sinayo ifomula.
Chofoza inkinobho ethi Enter ukuze uthole umphumela.
Ngendlela efanayo nesikhathi sokugcina, usebenzisa indlela yokudonsela phansi nokwehla, kopisha leli fomula eminye imigqa yetafula.
Kumele kwaziwe ukuthi akuzona zonke lezi zinhlobo okufanele zenziwe emangqamuzaneni aseduze, noma ngaphakathi kwetafula elifanayo. Zingaba kwelinye itafula, noma kwelinye iphepha ledokhumenti. Uhlelo lusazobala umphumela kahle.
Isibali
Noma kunjalo, umsebenzi oyinhloko weMicrosoft Excel ukubala ematafuleni, kepha uhlelo lokusebenza lungasetshenziswa njengekhalori elula. Mane ubeke uphawu olulinganayo bese ufaka izenzo ezifiselekayo kunoma yiliphi iseli leshidi, noma izenzo zingabhalwa kubha yefomula.
Ukuthola umphumela, chofoza ku-Enter inkinobho.
Izitatimende eziyisisekelo ze-Excel
Ama-opharetha wokubala abalulekile asetshenziswa ku-Microsoft Excel afaka okulandelayo:
- = ("uphawu olulinganayo") - lilingana;
- + ("plus") - okungeziwe;
- - ("minus") - ukukhupha;
- ("asterisk") - ukuphindaphindwa;
- / ("slash") - ukwahlukana;
- ^ ("circumflex") - exponentiation.
Njengoba ukwazi ukubona, iMicrosoft Excel ihlinzeka ngethuluzi lamathuluzi eliphelele lomsebenzisi ukwenza imisebenzi ehlukene yezibalo. Lezi zenzo zingenziwa zombili lapho kuhlanganiswa amatafula, futhi ngokwahlukana ukubala umphumela wokusebenza kwe-arithmetic.
