Ntchito ya Excel: kusankha magawo

Excel imakondweretsa ogwiritsa ntchito ake ndi zida zambiri zothandiza ndi ntchito. Mosakayikira chimodzi mwa zimenezi ndi Kusankha kwa parameter. Chida ichi chimakupatsani mwayi wopeza mtengo woyambira potengera mtengo womaliza womwe mukufuna kulandira. Tiyeni tiwone momwe tingagwiritsire ntchito ntchitoyi mu Excel.

Chifukwa chiyani ntchitoyi ikufunika

Monga tafotokozera pamwambapa, ntchito ya ntchitoyi Kusankha kwa parameter Zimakhala ndi kupeza mtengo woyambira pomwe zotsatira zomaliza zitha kupezeka. Mwambiri, ntchito iyi ndi yofanana ndi Sakani Mayankho (mutha kuziwerenga mwatsatanetsatane m'nkhani yathu -), komabe, ndizosavuta.

Mutha kugwiritsa ntchito ntchitoyi munjira imodzi yokha, ndipo ngati mukufuna kuwerengera m'maselo ena, muyenera kuchitanso zonse zomwe zili mmenemo. Komanso, ntchitoyo imakhala yochepa ndi kuchuluka kwa deta yomwe ikukonzedwa - mfundo imodzi yokha ndi yomaliza.

Kugwiritsa ntchito

Tiyeni tipitirire ku chitsanzo chothandiza chomwe chingakupatseni kumvetsetsa bwino momwe ntchitoyi imagwirira ntchito.

Chifukwa chake, tili ndi tebulo lomwe lili ndi mndandanda wazinthu zamasewera. Timangodziwa kuchuluka kwa kuchotsera (560 rub. kwa malo oyamba) ndi kukula kwake, komwe ndi kofanana kwa zinthu zonse. Muyenera kupeza ndalama zonse za katunduyo. Nthawi yomweyo, ndikofunikira kuti mu cell, yomwe pambuyo pake iwonetse kuchuluka kwa kuchotsera, chilinganizo cha kuwerengera kwake chinalembedwa (kwa ife, kuchulukitsa ndalama zonse ndi kukula kwa kuchotsera).

Choncho, algorithm ya zochita ndi motere:

1. Pitani ku tabu "Zambiri"momwe timadina pa batani “bwanji ngati” kusanthula mu gulu la zida "Zoneneratu"… Mu dontho-pansi mndandanda, sankhani "Parameter Selection" (m'matembenuzidwe akale, batani likhoza kukhala pagulu "Kugwira ntchito ndi data").
2. Iwindo lidzawonekera pazenera kuti musankhe parameter yomwe ikufunika kudzazidwa:
   • mu mtengo wamunda "Khalani mu cell" timalemba adilesi ndi data yomaliza yomwe tikudziwa, mwachitsanzo, iyi ndi cell yokhala ndi kuchotsera. M'malo molowetsa pamanja ma coordinates, mutha kungodina pa cell yomwe mukufuna patebulo lomwe. Pankhaniyi, cholozera ayenera kukhala m'munda lolingana kulowa zambiri.
   • Monga mtengo, tikuwonetsa kuchuluka kwa kuchotsera, komwe tikudziwa - 560 pakani.
   • Mu "Kusintha mtengo wa cell" pamanja kapena podina ndi mbewa, tchulani zolumikizira za cell (ayenera kutenga nawo gawo munjira yowerengera kuchotsera), momwe tikukonzekera kuwonetsa mtengo woyambira.
   • akanikizire mukakonzeka OK.
3. Pulogalamuyi idzachita mawerengedwe ndikuwonetsa zotsatira pazenera laling'ono lomwe lingathe kutsekedwa podina batani. OK. Komanso, zomwe zapezeka ziziwoneka zokha m'maselo omwe atchulidwa patebulo.
4. Momwemonso, titha kuwerengera mtengo wosatsika mtengo wazinthu zina ngati tidziwa kuchuluka kwa kuchotsera kwa chilichonse.

Kuthetsa Equations Pogwiritsa Ntchito Parameter Selection

Ngakhale kuti iyi si njira yayikulu yogwiritsira ntchito ntchitoyi, nthawi zina, ikafika yosadziwika, ingathandize kuthetsa ma equation.

Mwachitsanzo, tiyenera kuthetsa equation: 7x+17x-9x=75.

1. Timalemba mawu mu cell yaulere, m'malo mwa chizindikiro x ku adilesi ya cell yomwe mtengo wake mukufuna kupeza. Chifukwa chake, fomula ikuwoneka motere: =7*D2+17*D2-9*D2.
2. Kusindikiza Lowani ndikupeza zotsatira ngati nambala 0, zomwe ndi zomveka, popeza timangowerengera mtengo wa selo D2, lomwe ndi "x" mu equation yathu.
3. Monga tafotokozera m'gawo loyamba la nkhaniyi, pa tabu "Zambiri" kanikizani batani “bwanji ngati” kusanthula ndi kusankha "Parameter Selection".
4. Pawindo lomwe likuwoneka, lembani magawo:
   • M'munda mtengo "Khalani mu cell" onetsani ma coordinates a cell momwe timalembera equation (ie B4).
   • Mu mtengo, molingana ndi equation, timalemba nambala 75.
   • Mu “Kusintha Makhalidwe a Maselo” tchulani ma coordinates a cell omwe mtengo wake mukufuna kupeza. Kwa ife, izi ndi D2.
   • Zonse zikakonzeka, dinani OK.
5. Monga momwe tafotokozera pamwambapa, kuwerengera kudzapangidwa ndipo zotsatira zake zidzapezedwa, monga momwe tawonetsera pawindo laling'ono.
6. Chifukwa chake, takwanitsa kuthetsa equation ndikupeza mtengo wake x, zomwe zidapezeka kuti 5.

Kutsiliza

Kuyika ndi ntchito yomwe ingakuthandizeni kupeza nambala yosadziwika patebulo, kapena kuthetsa equation ndi imodzi yosadziwika. Chinthu chachikulu ndikudziŵa luso la kugwiritsa ntchito chida ichi, ndiyeno chidzakhala chothandizira chofunikira kwambiri pakugwira ntchito zosiyanasiyana.