Kanjani ukubala impande e "Eksele"?

Uhlelo Microsoft Excel has iqoqo elinothile imisebenzi. Ungayisebenzisa ukukhiqiza eziningi izibalo ezahlukene zezibalo. Nokho, uma isimiso ukusebenza izenzo ezilula liqondwe kakhulu, indlela ukubala impande e "Eksele" ukwazi akubona bonke.

"Impande" umsebenzi

Izindlela ukubala impande square ku "Eksele" ezimbalwa, futhi elula kunazo wabo - ukusebenzisa umsebenzi okhethekile "impande", esezivele zisebenza ohlelweni. Ukuze kubalulekile ukubiza kuseli ngokwayo noma ibha ifomula ukubhalisa-syntax yayo, noma chofoza inkinobho ethi "Faka Umsebenzi".

Uma ukhetha indlela yokuqala, iseli ukuthi kurekhodwe "= SQRT (X)", lapho esikhundleni "X" kufanele kube inombolo noma yeseli kokuba value kwamanani, impande okumele sitholakale. Esimeni sesibili, ngemva ngokucindezela "Umsebenzi Faka" inkinobho kuyadingeka ukubhala emkhakheni search "impande" bese ukhetha umsebenzi ohlongozwayo. Lokhu kuzovula iwindi esikunika noma ukubhalisa inombolo ngesandla, noma uyikhethe equkethe inombolo edingekayo.

iqhinga zezibalo

Nokho, lapho umsebenzi ukubala impande e "Eksele" akusho ngaso sonke isikhathi kuba isikwele. Ukubala impande iyiphi degree kufanele asebenzise enye indlela - ukusetshenziswa zezibalo osho. Ngu definition, ukubaluleka impande n-hydrochloric ngokwezinga - inombolo okufanele ophakanyiswe emandleni n, ukuthola isisho engaphansi impande.

Ngakho, ukuze uthole inani impande degree n-hydrochloric ngokwanele sokuzakhela inani degree ephambene - 1 / n. Ukubala impande e "Eksele" ngale ndlela, ungase futhi usebenzise omunye kungenzeka izixazululo algorithm. Eyokuqala yalezi ukusebenzisa umsebenzi, kwesibili - e iziyalezo ezicacile zomprofethi isenzo.

Ngokuchofoza inkinobho "Faka Umsebenzi", kuzomele ubhale ku ibhokisi "degree" bese ukhetha okukhethwa kukho ezifanele. Ku-window esivula, kuzoba izinkambu ezimbili - Okokuqala udinga ukucacisa inombolo, kanti eyesibili - ngezinga elingakanani kufanele avuswe. Ukuze ucacise okubeka obala Exponentiation kufanele asebenzise "^" uhlamvu, kwalandela degree. Kuyaphawuleka ukuthi esimweni amandla wamaqhuzu, kumelwe buyela ke kubakaki ukuze uthole umphumela lesifanele. Ngakho, ukubala impande square ukuba isakhiwo ifomu eqoshiwe: x ^ (1/2).