Momwe mungachotsere mizu mu Excel. Malangizo okhala ndi zithunzi zochotsa mizu mu Excel

Mu spreadsheet, kuwonjezera pa masamu wamba, mutha kugwiritsanso ntchito kuchotsa mizu. Kuchokera m'nkhaniyi muphunzira momwe mungawerengere masamu mu spreadsheet.

Njira yoyamba: kugwiritsa ntchito ROOT

Pali mitundu ingapo ya ogwiritsa ntchito mu Excel spreadsheet. Kuchotsa muzu ndi chimodzi mwazinthu zothandiza. Mawonekedwe anthawi zonse amawoneka motere: =MUZU(nambala). Kuyenda:

1. Kuti mugwiritse ntchito kuwerengera, muyenera kuyika fomula mu cell yopanda kanthu. Njira ina ndikulowa mu bar ya formula, mutasankha kale gawo lofunikira.
2. M'mabokosi, muyenera kulowa chizindikiro cha manambala, muzu womwe tidzapeza.

3. Pambuyo pochita zosintha zonse, dinani batani la "Enter" lomwe lili pa kiyibodi.
4. Okonzeka! Chotsatira chofunidwa chikuwonetsedwa mu gawo losankhidwiratu.

Tcherani khutu! M'malo mwa chiwerengero cha chiwerengero, mukhoza kulowa ogwirizanitsa a selo komwe nambalayo ili.

Kuyika fomula pogwiritsa ntchito Function Wizard

Ndizotheka kugwiritsa ntchito njira yomwe imachotsa mizu kudzera pawindo lapadera lotchedwa "Insert function". Kuyenda:

1. Timasankha gawo lomwe tikukonzekera kuwerengera zonse zomwe tikufuna.
2. Dinani pa batani la "Insert Function", lomwe lili pafupi ndi mzere wolowetsa mafomu, ndipo likuwoneka ngati "fx".

3. Zenera laling'ono lotchedwa "Insert Function" linawonetsedwa pazenera. Timawulula mndandanda wambiri womwe uli pafupi ndi mawu akuti "Category:". Pamndandanda wotsikira pansi, sankhani chinthu "Mathematics". Pazenera "Sankhani ntchito:" timapeza ntchito "ROOT" ndikusankha mwa kukanikiza LMB. Pambuyo pochita zosintha zonse, dinani "Chabwino".

4. Zenera latsopano lotchedwa "Function Arguments" linawonetsedwa pazenera, lomwe liyenera kudzazidwa ndi deta. M'munda wa "Nambala", muyenera kuyika chizindikiro cha manambala kapena kungowonetsa makonzedwe a gawo lomwe zidziwitso zofunikira zimasungidwa.

5. Pambuyo pochita zosintha zonse, dinani batani "Chabwino".
6. Okonzeka! Mu gawo losankhidwiratu, zotsatira za kusintha kwathu zidawonetsedwa.

Kuyika ntchito kudzera mu gawo la "Mafomula".

Maphunziro a tsatane-tsatane akuwoneka motere:

1. Timasankha selo lomwe timakonzekera kuwerengera zonse zomwe tikufuna.
2. Timapita ku gawo la "Mafomu", lomwe lili pamwamba pa mawonekedwe a spreadsheet. Timapeza chipika chotchedwa "Function Library" ndikudina chinthu cha "Math".

3. Mndandanda wautali wa mitundu yonse ya ntchito za masamu wawululidwa. Timapeza woyendetsa wotchedwa "ROOT" ndikudina pa LMB.

4. Iwindo la "Function Arguments" likuwonekera pachiwonetsero. M'gawo la "Nambala", muyenera kuyika chizindikiro cha manambala pogwiritsa ntchito kiyibodi, kapena kungowonetsa makonzedwe a cell pomwe zidziwitso zofunikira zimasungidwa.
5. Pambuyo pochita zosintha zonse, dinani "Chabwino".

6. Okonzeka! Mu gawo losankhidwiratu, zotsatira za kusintha kwathu zidawonetsedwa.

Njira yachiwiri: kupeza muzu pokweza ku mphamvu

Njira yomwe ili pamwambayi imathandizira kuchotsa mosavuta muzu wa square wa mtengo uliwonse wa chiwerengero. Njirayi ndi yabwino komanso yosavuta, koma sichitha kugwira ntchito ndi mawu a cubic. Kuti athetse vutoli, m'pofunika kukweza chizindikiro cha chiwerengero ku mphamvu ya kachigawo kakang'ono, komwe chiwerengerocho chidzakhala chimodzi, ndipo chiwerengerocho chidzakhala mtengo wosonyeza digiri. Mawonekedwe a mtengowo ndi awa: =(Nambala)^(1/n).

Ubwino waukulu wa njirayi ndikuti wogwiritsa ntchito amatha kuchotsa muzu wa digiri iliyonse mwa kungosintha "n" mu denominator kukhala nambala yomwe akufuna.

Poyamba, ganizirani momwe ndondomeko yochotsera muzu wa square ikuwoneka: (Nambala)^(1/2). Ndizosavuta kuganiza kuti ndiye njira yowerengera muzu wa cube ndi motere: =(Nambala)^(1/3) etc. Tiyeni tiwunike ndondomekoyi ndi chitsanzo chapadera. Njirayi ikuwoneka motere:

1. Mwachitsanzo, m'pofunika kuchotsa muzu wa cube wa mtengo wamtengo wapatali 27. Kuti tichite izi, timasankha selo laulere, dinani ndi LMB ndikulowetsamo zotsatirazi: =27^(1/3).

2. Pambuyo pochita zosintha zonse, dinani batani la "Enter".

3. Okonzeka! Mu selo losankhidwiratu, zotsatira za kusintha kwathu zinawonetsedwa.

Ndikoyenera kudziwa kuti apa, ngati mukugwira ntchito ndi ROOT, m'malo mwa mtengo wamtengo wapatali, mukhoza kulowa makonzedwe a selo lofunika.

Kutsiliza

Mu Excel spreadsheet, popanda zovuta zilizonse, mutha kuchita ntchito yochotsa muzu kuchokera pamtengo uliwonse wa manambala. Kuthekera kwa purosesa ya spreadsheet kumakupatsani mwayi wowerengera kuti muchotse mizu yamitundu yosiyanasiyana (square, cubic, ndi zina zotero). Pali njira zingapo zogwirira ntchito, kotero wogwiritsa ntchito aliyense akhoza kusankha yabwino kwambiri kwa iye.