Izibalo akudingeki kube nzima uma usebenzisa i-Excel
Njengazo zonke izibalo eziyisisekelo zokusebenza ku-Excel ukwengeza izinombolo ezimbili noma ngaphezulu ku-Excel udinga ukwakha ifomula .
Qaphela: Ukwengeza ndawonye izinamba eziningana ezitholakala kukholomu eyodwa noma umugqa kushidi lokusebenzela, sebenzisa umsebenzi we-SUM , ohlinzeka isinqamuleli ekwakheni ifomula elide lokufaka.
Amaphoyinti abalulekile okufanele akhumbule ngamafomula e-Excel:
- Amafomula e-Excel aqala ngaso sonke isibonakaliso esilinganayo ( = );
- Uphawu olulinganayo lufakwe njalo esitokisini lapho ufuna impendulo ivele khona;
- Isibonakaliso sokufaka ku-Excel yisisimboli esisodwa (+);
- Ifomula igcwaliswe ngokucindezela ukhiye wokungena kwikhibhodi.
Sebenzisa Ukubhekisela Kwamaselula Kufomula Amafomula
Esithombeni ngenhla, isethi yokuqala yezibonelo (imigqa 1 kuya ku-3) isebenzisa ifomula elula - ekhoneni C - ukwengeza idatha ndawonye kumakholomu A no-B.
Nakuba kungenzeka ukufaka izinamba ngqo kwifomula lokungezelela - njengoba kuboniswe ifomula:
= 5 + 5
emgqeni wesibili wesithombe - kungcono kakhulu ukufaka idatha kumaseli okusebenzela bese usebenzisa amakheli noma izinkomba zalawo maseli kufomula - njengoba kuboniswe ifomula
= A3 + B3
emgqeni 3 ngenhla.
Enye inzuzo yokusebenzisa izingqikithi zeseli kunokuba idatha yangempela kwifomula yukuthi, uma kwenzeka ngemuva kwesikhathi, kuyadingeka ukushintsha idatha kuyindaba elula yokufaka idatha esitokisini esikhundleni sokubhala kabusha ifomula.
Ngokujwayelekile, imiphumela yefomula izobuyekeza ngokuzenzekelayo uma idatha ishintsha.
Ukufaka Izinkomba Zezingcingo Nge Point futhi Chofoza
Yize kungenzeka ukuthi uthayiphe ifomula engenhla ibe yiseli C3 futhi ube nempendulo efanele, ngokuvamile kungcono ukusebenzisa iphuzu bese uchofoze , noma ukhomba , ukwengeza izingqikithi zeseli emafomula ukuze unciphise amathuba amaphutha adalwe ngu ukuthayipha ekubhekiseni kweselula okungalungile.
Iphoyinti nokuchofoza kuhilela ukumane ngokuchofoza kuseli eliqukethe idatha nge-mouse pointer ukuze ungeze ireferensi yeseli kwifomula.
Ukwakha ifomula yokwengeza
Izinyathelo ezisetshenziselwa ukwakha ifomula lokungeziwe kumakhalekhukhwini C3 ziyi:
- Thayipha uphawu olulinganayo esitokisini C3 ukuze uqale ifomula;
- Chofoza ku-cell A3 nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomu ngemuva kwesibonakaliso esifanayo;
- Thayipha uphawu olubanzi (+) kufomula ngemuva kwe- A3;
- Chofoza kuseli B3 nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomu ngemuva kwesignali yokwengeza;
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula;
- Impendulo 20 kufanele ibe khona esitokisini C3;
- Ngisho noma ubona impendulo ku-cell C3, ukuchofoza kulelo seli kuzobonisa ifomula = A3 + B3 ebhafini yefomula ngaphezulu kwephepha lokusebenzela.
Ukushintsha ifomu
Uma kudingekile ukulungisa noma ukushintsha ifomula, izinketho ezimbili ezinhle kakhulu ziyi:
- Chofoza kabili ifomula ekhasini lokusebenzela ukuze ubeke i-Excel ku- Hlela imodi bese wenza izinguquko kwifomula - isebenza kangcono izinguquko ezincane.
- Chofoza kanye esitokisini esinefomu bese uphinde ufake yonke ifomula - engcono kakhulu ekushintsheni okukhulu.
Ukwakha amafomula amaningi anzima
Ukubhala amafomula amaningi ahlukeneyo afaka imisebenzi eminingi - njengokuhlukaniswa noma ukususa noma ukufaka - njengoba kuboniswe emigqeni emihlanu kuya kweyisikhombisa kusibonelo, sebenzisa izinyathelo ezibalulwe ngenhla ukuze uqalise bese uqhubeka nje wengeze umsebenzisi ohambelana nezibalo olandelwa yi- izingqikithi zeseli eziqukethe idatha entsha.
Ngaphambi kokuxuba imisebenzi ehlukene yezibalo ndawonye kwifomula, noma kunjalo, kubalulekile ukuqonda ukulandelana kwemisebenzi eyenziwa yi-Excel uma kuhlolwa ifomula.
Ukuze wenze umkhuba, zama lesi sinyathelo nesinyathelo sesiteleka sefomula eyinkimbinkimbi .
Ukudala ukulandelana kwe-Fibonacci
Ukulandelana kwe-Fibonacci, eyakhiwe isazi sezibalo sase-Italy sekhulu leshumi nambili uLeonardo Pisano, yakha uchungechunge oluqhubekayo lwezinombolo ezikhulayo.
Lezi chungechunge zivame ukusetshenziselwa ukuchaza, ngezibalo, phakathi kwezinye izinto, amaphetheni ahlukene atholakele emvelweni afana nalokhu:
- Ukubunjwa kwama-sea shells ahlukahlukene;
- Ukuhlelwa kwamaqabunga egatsheni lomuthi;
- Indlela yokukhiqiza izinyosi.
Ngemuva kwezinombolo ezimbili zokuqala, inombolo ngayinye eyengeziwe kulolu chungechunge ingumumo wezinombolo ezimbili ezandulele.
Ukulandelana kwe-Fibonacci elula, ekhonjiswe esithombeni ngenhla, iqala ngezinombolo zero nenye:
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, 1597, 2584 ...
I-Fibonacci ne-Excel
Njengoba uchungechunge lwe-Fibonacci luhilela ukuhlanganisa, kungadalwa kalula ngefomula lokungeziwe ku-Excel njengoba kuboniswe esithombeni ngenhla.
Izinyathelo ezingezansi imininingwane yokuthi ungakha kanjani ukulandelana kwe-Fibonacci elula usebenzisa ifomula. Izinyathelo zihilela ukudala ifomula yokuqala ku-cell A3 bese ukopisha leyo fomula kumaseli asele usebenzisa isibambo sokugcwalisa .
I-iteration ngayinye, noma ikhophi, yefomu, ineza ndawonye izinombolo ezimbili ezedlule ngokulandelana.
Izinyathelo ezingezansi zidala ukulandelana kwikholomu eyodwa, kunezingqimba ezintathu eziboniswe kusibonelo sesithombe ukwenza lula ukukopisha kube lula.
Ukwakha uchungechunge lwe-Fibonacci oluboniswe kusibonelo usebenzisa ifomu lokungezelela:
- Esikhathini se-A1 thayipha i-zero (0) bese ucindezela ukhiye we- Enter ekhibhodi;
- Kwiseli A2 thayipha i-1 bese ucindezela ukhiye we- Enter ;
- Esikhathini se-A3 thayipha ifomula = A1 + A2 bese ucindezela ukhiye we- Enter ;
- Chofoza ku-cell A3 ukuze wenze iseli esebenzayo ;
- Beka isikhombisi segundane phezu kwesibambo sokugcwalisa - idayi elimnyama ekhoneni elingezansi elingakwesokudla leseli A3 - i-pointer ishintshela kwisibonakaliso sabantu abamnyama ( + ) uma siphelile isibambo sokugcwalisa;
- Gwema inkinobho yegundane kwimbambo yokugcwalisa bese uhudula isilinisi segundane esitokisini A31;
- I-A31 kufanele iqukathe inombolo 514229 .