Ungayikhipha kanjani impande ku-Excel. Imiyalelo enezithombe-skrini zokukhipha impande ku-Excel

Kuspredishithi, ngaphezu kokusebenza kwe-arithmetic okujwayelekile, ungasebenzisa nokukhipha impande. Kusukela esihlokweni uzofunda kahle ukuthi uzenza kanjani izibalo zezibalo kuspredishithi.

Indlela yokuqala: usebenzisa i-opharetha ye-ROOT

Kunezinhlobonhlobo eziningi zabasebenzisi kusipredishithi se-Excel. Ukukhipha impande kungenye yezici eziwusizo. Ifomu elijwayelekile lomsebenzi libukeka kanje: =IMPANDE(inombolo). Ukuhamba ngezinyawo:

1. Ukuze wenze izibalo, kufanele ufake ifomula kuseli elingenalutho. Enye inketho ukungena kubha yefomula, usukhethe ngaphambilini umkhakha odingekayo.
2. Kubakaki, kufanele ufake inkomba yezinombolo, impande esizoyithola.

3. Ngemuva kokwenza konke ukukhohlisa, cindezela inkinobho ethi "Enter" etholakala kukhibhodi.
4. Ilungile! Umphumela oyifunayo uboniswa emkhakheni okhethwe ngaphambilini.

Nakani! Esikhundleni senkomba yezinombolo, ungafaka abaxhumanisi beseli lapho inombolo ngokwayo itholakala khona.

Ukufaka ifomula kusetshenziswa Iwizadi Yomsebenzi

Kungenzeka ukusebenzisa ifomula esebenzisa ukukhishwa kwezimpande ngefasitela elikhethekile elibizwa ngokuthi “Faka umsebenzi”. Ukuhamba:

1. Sikhetha umkhakha esihlela ukwenza kuwo zonke izibalo esizidingayo.
2. Chofoza inkinobho ethi "Faka Umsebenzi", etholakala eduze komugqa wokufaka amafomula, futhi ibukeka njengokuthi "fx".

3. Iwindi elincane elibizwa ngokuthi “Faka Umsebenzi” liboniswe esikrinini. Sembula uhlu olubanzi oluseduze nombhalo othi "Isigaba:". Ohlwini oluya phansi, khetha into ethi “Mathematics”. Efasiteleni "Khetha umsebenzi:" sithola umsebenzi "ROOT" bese uwukhetha ngokucindezela LMB. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

4. Iwindi elisha elibizwa ngokuthi “Izimpikiswano Zomsebenzi” liboniswe esikrinini, okufanele ligcwaliswe ngedatha. Emkhakheni othi "Inombolo", udinga ukufaka inkomba yezinombolo noma umane ubonise izixhumanisi zomkhakha lapho kugcinwa khona ulwazi lwezinombolo oludingekayo.

5. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK".
6. Ilungile! Emkhakheni okhethwe ngaphambili, umphumela wezinguquko zethu ubonisiwe.

Ukufaka umsebenzi ngesigaba "Amafomula".

Isifundo sesinyathelo ngesinyathelo sibukeka kanje:

1. Sikhetha iseli lapho sihlela ukwenza zonke izibalo esizidingayo.
2. Sithuthela engxenyeni ethi “Amafomula”, etholakala phezulu kwesixhumi esibonakalayo sespredishithi. Sithola ibhulokhi ebizwa ngokuthi "Ilabhulali Yomsebenzi" bese uchofoza into ethi "Math".

3. Uhlu olude lwazo zonke izinhlobo zemisebenzi yezibalo lwembuliwe. Sithola opharetha ngokuthi "ROOT" bese uchofoza kukho LMB.

4. Iwindi elithi “Function Arguments” livela esibukweni. Ensimini ethi "Inombolo", kufanele ufake inkomba yezinombolo usebenzisa ikhibhodi, noma umane ubonise izixhumanisi zeseli lapho kugcinwa khona ulwazi lwezinombolo oludingekayo.
5. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

6. Ilungile! Emkhakheni okhethwe ngaphambili, umphumela wezinguquko zethu ubonisiwe.

Indlela yesibili: ukuthola impande ngokukhuphulela amandla

Indlela engenhla isiza ukukhipha kalula impande yesikwele yanoma yiliphi inani lenombolo. Indlela ilula futhi ilula, kodwa ayikwazi ukusebenza nezinkulumo ze-cubic. Ukuze uxazulule le nkinga, kuyadingeka ukuphakamisa inkomba yezinombolo emandleni engxenye, lapho inombolo izoba yinye, futhi i-denominator izoba inani elibonisa izinga. Ifomu elijwayelekile lalelivelu limi kanje: =(Inombolo)^(1/n).

Inzuzo eyinhloko yale ndlela ukuthi umsebenzisi angakwazi ukukhipha impande yanoma yiliphi idigri ngokumane aguqule u-“n” ku-denominator abe inombolo ayidingayo.

Ekuqaleni, cabanga ukuthi ifomula yokukhipha impande yesikwele ibukeka kanjani: (Inombolo)^(1/2). Kulula ukuqagela ukuthi ke ifomula yokubala impande ye-cube imi kanje: =(Inombolo)^(1/3) njll. Ake sihlaziye le nqubo ngesibonelo esithile. I-Walkthrough ibonakala kanje:

1. Isibonelo, kuyadingeka ukukhipha impande ye-cube yenani lenombolo 27. Ukwenza lokhu, sikhetha iseli yamahhala, chofoza kuyo nge-LMB bese ufaka inani elilandelayo: =27^(1/3).

2. Ngemuva kokwenza konke ukukhohlisa, cindezela inkinobho ethi "Enter".

3. Ilungile! Kuseli elikhethwe ngaphambili, umphumela wokuguqulwa kwethu ubonisiwe.

Kuyaqapheleka ukuthi lapha, njengalapho usebenza no-opharetha we-ROOT, esikhundleni senani elithile lezinombolo, ungafaka izixhumanisi zeseli elidingekayo.

Isiphetho

Kuspredishithi se-Excel, ngaphandle kobunzima, ungenza umsebenzi wokukhipha impande kunoma iyiphi inombolo yezinombolo. Amakhono okucubungula isipredishithi akuvumela ukuthi wenze izibalo ukuze ukhiphe impande yamadigri ahlukahlukene (isikwele, i-cubic, njalonjalo). Kunezindlela eziningana zokuqalisa, ngakho umsebenzisi ngamunye angazikhethela okungcono kakhulu.