Ndi kuwerengera kosalekeza m'matebulo a Excel, wogwiritsa ntchito posachedwa adzakumana ndi kufunika kowonjezera manambala ena. Njira yofananayi imachitika nthawi zambiri pothetsa mavuto osiyanasiyana. - kuchokera ku masamu osavuta kupita ku mawerengedwe ovuta a engineering. Komabe, ngakhale kugwiritsidwa ntchito kwakukulu kwa ntchitoyi, Excel ilibe njira yosiyana yomwe mungathe kuchulukitsa manambala kuchokera ku maselo. Kuti muchite izi, muyenera kuphunzira momwe mungagwiritsire ntchito chilinganizo chonse, chomwe chapangidwa kuti chikweze manambala amunthu kapena zovuta za digito kumphamvu zosiyanasiyana.

Mfundo yowerengera masikweya a nambala

Musanazindikire momwe mungakwezere bwino manambala ku mphamvu yachiwiri kudzera mu Excel, muyenera kukumbukira momwe masamu amagwirira ntchito. Sikweya ya nambala ndi nambala inayake yomwe imachulukitsidwa yokha.. Kuti muchite masamuwa pogwiritsa ntchito Excel, mutha kugwiritsa ntchito imodzi mwa njira ziwiri zotsimikiziridwa:

• ntchito masamu ntchito MPHAMVU;
• kugwiritsa ntchito chilinganizo chomwe chizindikiro cha exponent "^" chimasonyezedwa pakati pa zikhalidwe.

Njira iliyonse iyenera kuganiziridwa mwatsatanetsatane muzochita.

Fomula yowerengera

Njira yosavuta yowerengera masikweya a manambala kapena nambala yomwe mwapatsidwa ndi kudzera mu fomula yokhala ndi chizindikiro cha digiri. Mawonekedwe a formula: =n^ 2. N ndi nambala iliyonse kapena nambala iliyonse yomwe idzachulukitsidwe yokha kuti ikhale ndi squaring. Pachifukwa ichi, mtengo wa mkanganowu ukhoza kufotokozedwa ndi ma cell coordinates, kapena ndi nambala yeniyeni.

Kuti mumvetsetse momwe mungagwiritsire ntchito chilinganizo molondola kuti mupeze zotsatira zomwe mukufuna, m'pofunika kuganizira zitsanzo 2 zothandiza. Njira yomwe ikuwonetsa mtengo wa manambala mu fomula:

1. Sankhani selo lomwe zotsatira za kuwerengera zidzawonetsedwa. Chongani ndi LMB.
2. Lembani ndondomeko ya selo ili pamzere waulere pafupi ndi chizindikiro cha "fx". Chitsanzo chosavuta kwambiri: =2^2.
3. Mutha kulemba fomula mu cell yomwe mwasankha.

4. Pambuyo pake, muyenera kukanikiza "Enter" kuti zotsatira za kuwerengera ndi ntchitoyo ziwonekere mu selo yolembedwa.

Njira yomwe ikuwonetsa kugwirizanitsa kwa selo, chiwerengero chake chiyenera kukwezedwa ku mphamvu yachiwiri:

1. Lembanitu nambala 2 mu selo losasintha, mwachitsanzo B

2. Sankhani mwa kukanikiza LMB cell yomwe mukufuna kuwonetsa zotsatira za kuwerengera.
3. Lembani chizindikiro choyamba "=", pambuyo pake - zogwirizanitsa za selo. Ayenera kudziwonetsera okha mu buluu.
4. Kenako, muyenera kuyika chizindikiro "^", nambala ya digiri.
5. Chochita chomaliza ndikudina batani la "Enter" kuti mupeze zotsatira zomwe mukufuna.

Zofunika! Njira yomwe yaperekedwa pamwambapa ndi yapadziko lonse lapansi. Itha kugwiritsidwa ntchito kukweza manambala ku mphamvu zosiyanasiyana. Kuti muchite izi, ingolowetsani nambala pambuyo pa chizindikiro cha "^" ndi chofunikira.

Ntchito ya POWER ndi kugwiritsa ntchito kwake

Njira yachiwiri, yomwe imaonedwa kuti ndi yovuta kwambiri ponena za squaring nambala inayake, ndi kudzera mu ntchito ya MPHAMVU. Ndikofunikira kuti mukweze manambala osiyanasiyana m'maselo a tebulo la Excel ku mphamvu zofunikira. Maonekedwe a fomula yonse yamasamu yolumikizidwa ndi wogwiritsa ntchitoyu: = MPHAMVU(nambala yofunikira, mphamvu). Kufotokozera:

1. Digiri ndi mtsutso wachiwiri wa ntchitoyi. Imatanthawuza digiri inayake kuti muwerengenso zotsatira kuchokera padijiti yoyambirira kapena mtengo wa manambala. Ngati mukufuna kusindikiza lalikulu la nambala, muyenera kulemba nambala 2 pamalo ano.
2. Nambala ndiyo mtsutso woyamba wa ntchitoyi. Imayimira mtengo wofunikira womwe njira ya masamu squaring idzagwiritsidwe. Ikhoza kulembedwa ngati selo logwirizanitsa ndi nambala kapena nambala yeniyeni.

Njira yokwezera nambala ku mphamvu yachiwiri kudzera mu ntchito ya MPHAMVU:

1. Sankhani selo la tebulo momwe zotsatira zidzasonyezedwe pambuyo powerengera.
2. Dinani pa chizindikiro kuti muwonjezere ntchito - "fx".
3. Zenera la "Function Wizard" liyenera kuwonekera pamaso pa wogwiritsa ntchito. Apa muyenera kutsegula gulu lomwe lilipo kale, sankhani "Masamu" pamndandanda womwe umatsegulidwa.

4. Pamndandanda womwe waperekedwa kwa ogwiritsa ntchito, muyenera kusankha "DEGREE". Tsimikizirani zosankhidwazo podina batani "Chabwino".
5. Kenako, muyenera kukhazikitsa mfundo ziwiri zogwirira ntchito. M'munda waulere "Nambala" muyenera kulowa nambala kapena mtengo womwe udzakwezedwa ku mphamvu. M'munda waulere "Degree" muyenera kufotokoza digirii yofunikira (ngati iyi ndi squaring - 2).
6. Chomaliza ndikumaliza kuwerengera ndikukanikiza batani la OK. Ngati zonse zachitika molondola, mtengo wokonzekera udzawonekera mu selo losankhidwa pasadakhale.

Momwe mungakwezere nambala kukhala mphamvu pogwiritsa ntchito ma cell coordinates:

1. Mu cell ina, lowetsani nambala yomwe idzakhala masikweya.
2. Kenako, ikani ntchito mu selo lina kudzera mu "Function Wizard". Sankhani "Masamu" pamndandanda, dinani "DEGREE" ntchito.
3. Pazenera lomwe limatsegulidwa, pomwe mikangano yantchito iyenera kufotokozedwa, muyenera kulowa zikhalidwe zina, mosiyana ndi njira yoyamba. M'munda waulere "Nambala" muyenera kufotokoza makonzedwe a selo momwe chiwerengero cha nambala chomwe chimakwezedwa ku mphamvu chilipo. Nambala 2 imalowetsedwa mu gawo lachiwiri laulere.

4. Ingodinanso batani "Chabwino" ndikupeza zotsatira zomaliza mu cell yolembedwa.

Sitiyenera kuiwala kuti ntchito ya MPHAMVU ndiyokhazikika, yoyenera kukweza manambala ku mphamvu zosiyanasiyana.

Kutsiliza

Malinga ndi ziwerengero za boma, pakati pa masamu ena, ogwiritsa ntchito mu Excel spreadsheets amakula ma manambala osiyanasiyana nthawi zambiri kuposa momwe amachitira njira zina za gululi. Komabe, chifukwa chakuti palibe ntchito yapadera yochitira izi mu pulogalamuyi, mutha kugwiritsa ntchito njira ina yomwe nambala yofunikira imalowetsedwa m'malo mwake, kapena mutha kugwiritsa ntchito opareshoni ya POWER yosiyana, yomwe ilipo kuti musankhe. Ntchito Wizard.