Kanjani ukubala impande square Excel?

isofthiwe ye-Microsoft Excel has anhlobonhlobo imisebenzi zezibalo ezikuvumela ukuxazulula imisebenzi eyinkimbinkimbi. Inombolo yezenzo elula - kwalokho, ukubuyabuyelela, nabanye - Kulula kakhulu ukwenza, usebenzisa izinhlamvu ezikhethekile. Nokho, kukhona labo ezidinga incazelo ekhethekile - ngakho, hhayi wonke umuntu uyazi ukuthi ukubala impande square Excel.

Uyini umsuka sikwele?

Ngaphambi ekuqaleni inqubo yokufunda, ungathola kanjani impande square ku-Excel, kufanele uthole kangcono iqiniso lokuthi lokhu kuyinto umsebenzi zezibalo. Ngu definition, impande skwele inombolo - iyinombolo kabani square lilingana nenombolo a. Sciences zezibalo kungabonwa izimpande square hhayi kuphela. Futhi ukuza kunoma iyiphi enye degree, ngakho ngokuvamile impande square ubizwa ngokuthi impande besigaba sesibili.

impande umsebenzi

Ekuxazululeni izinkinga ezihlobene ngokuthola isikwele impande "Eksele" azilethi imiphumela efiselekayo ngezindlela eziningana. Ukusebenza zohlelo ivumela kokubili ukusebenzisa esakhelwe ekwenziweni algorithm, bese ubhala ngokwakho, usebenzisa theorems akhethekile izakhiwo impande. Indlela elula yokuthola impendulo isikwele impande umsebenzi. Ku-Excel, kungafinyelelwa ngokuvula ongakhetha imenyu noma enquma ngesandla.

I-syntax silula - emva ecacisa ukusetshenziswa omunye wemisebenzi (setshwayo) kuyadingeka ukubhalisa elisemqoka "impande", okubonisa ucingo umyalo ezifanele. Okulandelayo bayolotshwa phansi kubakaki variable ofuna ukuthatha impande square. Ku-Excel njengephuzu lokuphikisa umsebenzi kungenziwa kusetshenziswa njengenhlangano okubeka obala value kwamanani futhi ireferensi yeseli, futhi isibalo sezibalo ukuthi ihlola inombolo.

Ukusebenzisa izakhiwo zezibalo

Impande square Excel, ungakwazi ukubala eziningi ezinye izindlela angadingi ulwazi olujulile sciences zezibalo. Kuyinto ngokwanele ukuba nazi ukuthi liyini impande - lesi sihloko yathintwa phezu engxenyeni yokuqala ka-athikili. Ukusebenzisa incazelo impande square, it ungaboniswa njengoba amandla okuhambisanayo inombolo ezimbili ezidingekayo. Ngakho, uthole impande square ngaphandle kokusebenzisa "impande" kungenziwa nje waphakamisa inombolo emandleni.

Lokhu kungenziwa futhi ngezindlela ezimbili. Eyokuqala ukusebenzisa nezinye imisebenzi - "esiteji". Sithuthukisa inani elithile noma umphumela isibalo sezibalo e ngezinga ekhethiwe. Kulokhu, in the "degree" akhombise inani 1/2 noma 0.5. Yimani niqonde iyiphi inombolo ngezinga elithile ngangokunokwenzeka futhi ngaphandle kokusebenzisa yimuphi izici - "Eksele" kuyinto uhlamvu ekhethekile ophethe lo msebenzi: "^". Kulokhu, ukuthola impande square, anele ukuphetha Inkulumo kubakaki, balandela ngokungeza "^ (1/2)" noma "* (0.5)." Waba yini umphumela walesi senzo uyofana ukwakhiwa amandla umsebenzi kanye nokusebenzisa "impande" umsebenzi.

Kufanele kuqashelwe ukuthi indlela yokuthola impande Exponentiation kuyinto ngokunethezeka. Isizathu salokhu Kuyaphawuleka ukuthi ngosizo le misebenzi, ungathola impande ngaphandle kokufaka isicelo kokusebenzisa izibalo ekhethekile eyengeziwe.

izibonelo

Ukuze ekugcineni ukubhekana kanjani ukubala impande isikwele Excel, kufanele ucabangele ambalwa izibonelo izindlela ezimbili kuchaziwe ngenhla.

Esimweni sokuqala sisebenzisa isici "impande", ukusibiza usebenzisa inkinobho "Faka Umsebenzi". Ku-window ezokwenza ucacise idatha sokubalwa, ezifana umehluko phakathi kwezindinganiso lamaseli ezimbili, bese uchofoza "OK".

Esimeni sesibili, Usebenzisa inguqulo womuntu ofundekayo, nesabelo okubeka obala igunya, inkulumo ethi elandelayo lokuthola impande skwele inombolo, isibonelo 9:

Waba yini umphumela walesi senzo ngeke isethwe "3".