Funda indlela yokufaka isikwele inombolo ku-Excel

Ukufunda ukwenza isikwele ku-Excel kubaluleke kakhulu, ikakhulukazi uma uvamise ukusebenza nalokhu ukwenza izibalo zezibalo noma zezibalo. I-Excel isiyithuluzi eliwusizo kakhulu, noma ngabe uzokwenza izibalo eziyisisekelo noma ufuna ukuyisebenzisela izibalo eziyinkimbinkimbi emsebenzini wakho.

Okwamanje lolu hlelo lweMicrosoft uthole izibuyekezo ezinhle ezikuvumela ukuthi wenze izibalo. Ungayisebenzisa ngisho nokwenza izibalo zezinkampani ezinkulu. Kodwa ukuze ufeze lokhu, udinga ukwazi ukuthi yiziphi izinyathelo okufanele uzilandele.

Kulesi sihloko sichaza ukuthi ungasikwela kanjani ku-Excel, ulandele izindlela ezimbili nezinyathelo ezimbalwa ukuze ukwazi ukwenza izibalo zakho ngokushesha.

Umsebenzi wamandla ku-Excel

Umsebenzi wamandla ku-Excel Iwusizo kakhulu ekwenzeni izibalo zezibalo, uma uyisebenzisa ikunikeza umphumela wokuphakamisa ukuphikisana kwenombolo emandleni. I-syntax yomsebenzi wamandla imi kanje: AMANDLA (inombolo; amandla).

Ukuze usebenzise umsebenzi kufanele uqonde ukuthi usetshenziswa kanjani. Engxoxweni "inombolo" kumele bhala isisekelo wamandla ofuna ukubala (lokhu kufanele kube inombolo yangempela). Esigabeni "amandla" Ikona i-eksponenti ofuna ukukhuphula kuyo leyo nombolo.

Umsebenzi wamandla we-Excel uyithuluzi eliwusizo lochwepheshe bezibalo abavame ukwenza izibalo eziyinkimbinkimbi. Ikakhulukazi kulabo abakhetha ukushiya ukubala ezandleni zohlelo. Ngale ndlela bangagxila ezibalweni eziyinkimbinkimbi emisebenzini yabo.

Izinyathelo zokufunda ukuthi ungasikwele kanjani ku-Excel ngomsebenzi wamandla

Ukuze ukwazi ukusebenzisa umsebenzi wamandla ku-Excel futhi ngaleyo ndlela ufunde indlela yokwenza isikwele ku-ExcelUngalandela izinyathelo ezingezansi:

1. Into yokuqala okufanele uyenze vula ishidi le-excel, sincoma ukuthi udale ithebula eli-odiwe uma kunezinombolo ezimbalwa ofuna ukuziskwele.
2. Uma usuhlele idatha yakho kuthebula, kufanele ubheke isigaba kumenyu enkulu amafomula.
3. Uma usukhethe inketho yamafomula, kufanele uthole inketho endaweni engenhla kwesokunxele Faka umsebenzi.
4. Ukwenza kanjalo kuvula imenyu entsha, lapho ungabhala khona igama lomsebenzi owufunayo, kulokhu kufanele ubhale AMANDLA.
5. Uma usukwenzile, uzoqaphela ukuthi ungakwazi khetha umsebenzi wamandla bese ucindezela Yamukela.
6. Manje uyabona ukuthi enye imenyu ivuleka kanjani, lapho bekutshela khona ukuthi kufanele bhala inombolo noma isisekelo samandla. Kufanele ukhumbule ukuthi kule nketho ungakwazi ukwengeza iseli lapho inombolo ofuna ukuyiskwele ikhona.
7. Bakunikeza nesigaba okufanele ubhale kuso amandla ozowaphakamisa (kulokhu kufanele kube 2).
8. Uma usufake yomibili idatha, uzobona umphumela wokuphindaphinda inombolo oyikhombisile.

Ngokulandela lezi zinyathelo uzokwazi ukufaka isikwele kunoma iyiphi inombolo oyifunayo ku-Excel ngaphandle kwenkinga.

Ungasebenzisa futhi ifomula yamandla ku-Excel ngqo futhi ikulondolozele izinyathelo ezimbalwa. Ukuze ukufeze ungakwazi khetha iseli eshidini le-Excel ofuna ukulibala.

Uma useselini kufanele ubhale kuphela i-syntax yomsebenzi, kodwa njengefomula “= AMANDLA (inombolo; amandla)”; lapho kufanele uqale ubhale inombolo ofuna ukuyiskwele futhi mhlawumbe inombolo u-2, ukuze ukwazi ukuyiskwele.

Indlela yokwazi ukuthi usikwele kanjani ku-Excel ngezinyathelo ezimbalwa

Umsebenzi wamandla akusiyo yodwa indlela ukuze ukwazi ukuphakamisa isikwele. Kukhona indlela engase isheshe futhi ibe lula nokubala. Nazi izinyathelo ongazilandela:

1. Into yokuqala okufanele uyenze khetha iseli lapho ufuna ukukhombisa khona isikwele, inombolo.
2. Manje kufanele ufake umbhalo olandelayo ngaphakathi kwezingcaphuno “=(inombolo noma iseli)^2".
3. Ngaphakathi kubakaki kufanele faka inombolo Yini ofuna ukuyikweqa noma faka iseli iphi inombolo ofuna ukuyiskwele.
4. Ngokusebenzisa le fomula ngokuqondile kuseli, uzothola umphumela wenombolo ofuna ukuyiskwele kalula nangezinyathelo ezimbalwa.

Lezi zinyathelo zilula kakhulu futhi zingaba usizo kakhulu uma udinga ukwenza izibalo zesikhashana.

Yini okufanele ngiyikhumbule lapho ngifaka inombolo ku-Excel?

Lapho ufunda indlela yokufaka isikwele inombolo ku-Excel, kufanele ucabangele izici ezithile ezibalulekile, kungakhathaliseki ukuthi iyiphi kulezi zindlela ezimbili ozisebenzisayo. Phakathi kwamaphuzu okufanele uwacabangele kukhona:

• Esimeni sokusebenzisa umsebenzi AMANDLA, kungenzeka ukuthi ubhala ifomula ngokuqondile kuseli noma wenze inqubo ngemenyu yefomula. Kumele baqonde ukuthi siyini isisekelo samandla nokuthi i-eksponenti yokuthi ihlale ingu-2, okungenani kulesi simo ofuna ukusikweleta ngaso sonke isikhathi.
• Lapho ubhala ifomula ngokuqondile kumaseli e-Excel kufanele usebenzise uphawu "+" noma "="".. Uma ungakwenzi, uhlelo aluboni ukwakheka ozama ukukusebenzisa, isibonelo, kufanele kube: “=amandla (inombolo; i-eksponenti)"Noma"+(inombolo noma iseli)^2"
• Kubalulekile ukuthi hlola ukuthi iyiphi inketho engcono kakhulu lapho ubala isikwele ku-Excel. Njengoba uma kuyisibalo somsebenzi wakho, kutuswa ukuthi usebenzise ifomula enikezwe yi-Excel. Ngoba lokhu kungaba usizo uma ufuna ukushintsha i-eksponenti, uma kwenzeka ucelwa ukuthi uyiphakamise ngaphezu kwesikwele.
• Kuhle, gcina idatha ihlelekile ngamatafula bese ukhomba ukuthi yimaphi amanani owabalayo futhi ngaleyo ndlela ukwazi ukusebenzisa izindlela ze-squaring ku-Excel ngendlela efanele.

Inqubo yokwazi ukuthi usikwele kanjani inombolo ku-Excel ayinzima kangako, inqobo nje uma usebenzisa enye yezinqubo ngendlela efanele, uzokwazi ukwenza izibalo zakho ngaphandle kwenkinga.

Manje njengoba usufundile ukuthi ungafaka kanjani isikwele inombolo ku-Excel, ungakwenza yenza lezi zinhlobo zezibalo ngokushesha, kungakhathaliseki ukuthi uzoyinika idatha yakho.