Ukususa impande kunombolo kuyisenzo sezibalo esivamile. Ibuye isetshenziselwe ukubalwa okuhlukahlukene kumatafula. KuMicrosoft Excel, kunezindlela ezimbalwa zokubala leli nani. Ake sihlolisise izindlela ezahlukahlukene zokwenza izibalo kulolu hlelo.
Izindlela zokukhipha
Kunezindlela ezimbili eziphambili zokubala le nkomba. Enye yazo ilungele ukubala impande yesikwele, bese elesibili lingasetshenziswa ukubala amanani wanoma iliphi ibanga.
Indlela yoku-1: Ukufaka Umsebenzi
Ukuze kukhishwe impande yesikwele, kusetshenziswa umsebenzi, obizwa ngokuthi yi-ROOT. I-syntax yayo imi ngolu hlobo:
= I-ROOT (inombolo)
Ukuze usebenzise le nketho, kwanele ukubhala le nkulumo esitokisini noma kulayini wohlelo lokusebenza, ungene esikhundleni segama elithi "inombolo" ngenombolo ethile noma ikheli leseli lapho litholakala khona.
Ukuze wenze ukubala futhi ukhombise umphumela esikrinini, cindezela inkinobho ENTER.
Ngaphezu kwalokho, ungafaka le formula ngokusebenzisa iwizadi yokusebenza.
- Sichofoza kuseli eshidini lapho kuzobukiswa khona umphumela wokubala. Iya inkinobho "Faka umsebenzi"ibekwe eduze komugqa wokusebenza.
- Kuluhlu oluvulayo, khetha INDLALO. Chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyavula. Ensimini okuwukuphela kwayo kule windi, kufanele ufake noma inani elithize lapho okukhishwa kuzokwenzeka khona, noma izixhumanisi zeseli lapho kutholakala khona. Kwanele ukuthi uchofoze lesi seli ukuze ikheli laso lifakwe enkundleni. Ngemuva kokufaka idatha, chofoza inkinobho "Kulungile".
Ngenxa yalokhu, umphumela wokubala uzovezwa kuseli ekhonjisiwe.
Ungabiza nomsebenzi ngokusebenzisa ithebhu Amafomula.
- Khetha iseli ukubonisa umphumela wokubala. Iya kuthebhu ethi "amafomula".
- Kubha yamathuluzi "Umtapo Wezincwadi Wokusebenza" kubambo, chofoza inkinobho "Izibalo". Kuluhlu olubonakala, khetha inani INDLALO.
- Iwindi lokuphikisana liyavula. Zonke ezinye izinto ziyefana ncamashi lapho usebenzisa inkinobho "Faka umsebenzi".
Indlela 2: exponentiation
Sebenzisa inketho engenhla ngeke kusize ukubala impande ye-cubic. Kulokhu, ivelu kufanele inyuselwe kumandla e-fractional. Uhlobo olujwayelekile lwefomula yokubala lumi kanje:
= (inombolo) ^ 1/3
Okusho ukuthi, lokhu ngokusemthethweni akuyona neze isizinda, kepha ukuphakamisa inani lamandla ku-1/3. Kepha leli banga liyimpande ye-cubic, ngakho-ke lesi senzo ku-Excel sisetshenziselwa ukuyithola. Esikhundleni senombolo ethile, ungafaka futhi izixhumanisi zeseli ngemininingwane yezinombolo kule fomula. Ukuqoshwa kwenziwa kunoma iyiphi indawo eshidi noma emugqeni wamafomula.
Ungacabangi ukuthi le ndlela ingahle isetshenziselwe kuphela ukukhipha izimpande ze-cubic kusuka kunombolo. Ngendlela efanayo, ungbala isikwele nanoma iyiphi enye impande. Kepha kuphela kulesi simo lapho kuzodingeka usebenzise ifomula elandelayo:
= (inombolo) ^ 1 / n
n izinga lokudalwa.
Ngakho-ke, le ndlela ikhetha indawo yonke kunokusebenzisa indlela yokuqala.
Njengoba ubona, ngaphandle kweqiniso lokuthi i-Excel ayinawo umsebenzi okhethekile wokukhipha izimpande ze-cubic, lokhu kubalwa kungenziwa kusetshenziselwa ukukhulisa amandla wenhlangano, okuyi-1/3. Ungasebenzisa umsebenzi okhethekile ukukhipha impande yesikwele, kepha futhi ungakwenza lokhu ngokukhulisa inani linamandla. Okwamanje kuzodingeka ukukhuphula amandla u-1/2. Umsebenzisi ngokwakhe kufanele anqume ukuthi iyiphi indlela yokubala elula kuye.
