Kusankha parameter mu Excel. "Sankhani parameter" ntchito

Ntchito ya "Select parameter" mu Excel imakupatsani mwayi wodziwa mtengo woyambira, kutengera mtengo womaliza womwe umadziwika kale. Ndi anthu ochepa omwe amadziwa momwe chidachi chimagwirira ntchito, malangizo ankhaniyi akuthandizani kuti mumvetsetse.

Momwe ntchitoyi imagwirira ntchito

Ntchito yaikulu ya ntchito ya "Parameter Selection" ndiyo kuthandiza wogwiritsa ntchito e-book kusonyeza deta yoyambirira yomwe inachititsa kuti zotsatira zomaliza ziwoneke. Malingana ndi mfundo yogwiritsira ntchito, chidachi chikufanana ndi "Fufuzani Njira Yothetsera", ndipo "Kusankha Zinthu" kumaonedwa kuti n'kosavuta, chifukwa ngakhale woyambitsa akhoza kugwiritsa ntchito.

Tcherani khutu! Zochita za ntchito yosankhidwa zimakhudza selo limodzi lokha. Chifukwa chake, poyesa kupeza mtengo woyambira mazenera ena, muyenera kuchitanso zinthu zonse molingana ndi mfundo yomweyo. Popeza ntchito ya Excel imatha kugwira ntchito pamtengo umodzi wokha, imawonedwa ngati njira yochepa.

Mawonekedwe a ntchito yogwiritsira ntchito: mwachidule mwachidule ndi kufotokozera pogwiritsa ntchito chitsanzo cha khadi la malonda

Kuti ndikuuzeni zambiri za momwe Parameter Selection imagwirira ntchito, tiyeni tigwiritse ntchito Microsoft Excel 2016. Ngati muli ndi pulogalamu yamtsogolo kapena yapitayi yomwe yaikidwa, ndiye kuti masitepe ena okha akhoza kusiyana pang'ono, pamene mfundo yogwiritsira ntchito imakhalabe yofanana.

1. Tili ndi tebulo lokhala ndi mndandanda wazinthu, momwe chiwerengero chokha cha kuchotsera chimadziwika. Tidzayang'ana mtengo ndi kuchuluka kwake. Kuti muchite izi, pitani ku tabu ya "Data", mu gawo la "Forecast" timapeza chida cha "Analysis ngati", dinani pa "Parameter kusankha".

2. Pamene zenera lotulukira likuwonekera, m'munda wa "Set in cell", lowetsani adilesi yomwe mukufuna. Kwa ife, izi ndi ndalama zochotsera. Kuti tisamalembe kwa nthawi yayitali komanso osasintha nthawi ndi nthawi ma kiyibodi, timadina pa cell yomwe tikufuna. Mtengowo udzawonekera m'munda wolondola. Motsutsana ndi gawo la "Value" likuwonetsa kuchuluka kwa kuchotsera (ma ruble 300).

Zofunika! Zenera la "Select parameter" silikugwira ntchito popanda mtengo wokhazikitsidwa.

3. Pagawo la "Sinthani mtengo wa cell", lowetsani adilesi yomwe tikufuna kuwonetsa mtengo woyambira wamtengo wa chinthucho. Tikugogomezera kuti zenerali liyenera kutenga nawo gawo mwachindunji pakuwerengera. Tikawonetsetsa kuti zikhalidwe zonse uXNUMXbuXNUMXbare zidalowa molondola, dinani batani "Chabwino". Kuti mupeze nambala yoyamba, yesani kugwiritsa ntchito selo yomwe ili patebulo, kuti zikhale zosavuta kulemba fomula.

4. Zotsatira zake, timapeza mtengo womaliza wa katunduyo powerengera zochotsera zonse. Pulogalamuyo imawerengera mtengo womwe ukufunidwa ndikuwuwonetsa pawindo la pop-up. Kuphatikiza apo, zikhalidwe zimabwerezedwa patebulo, mwachitsanzo, mu cell yomwe idasankhidwa kuti iwerengere.

Zolemba! Kuwerengera koyenera ku data yosadziwika kungathe kuchitidwa pogwiritsa ntchito ntchito ya "Select parameter", ngakhale mtengo woyambirira uli ngati gawo la decimal.

Kuthetsa equation pogwiritsa ntchito kusankha magawo

Mwachitsanzo, tidzagwiritsa ntchito equation yosavuta popanda mphamvu ndi mizu, kuti tiwone momwe yankho limapangidwira.

1. Tili ndi equation: x+16=32. Ndikofunikira kumvetsetsa kuti ndi nambala iti yomwe imabisika kumbuyo kwa "x" yosadziwika. Chifukwa chake, tidzayipeza pogwiritsa ntchito ntchito ya "Parameter Selection". Poyamba, timalemba ma equation athu mu selo, titayika chizindikiro "=". Ndipo m'malo mwa "x" timayika adilesi ya selo momwe zosadziwika zidzawonekera. Kumapeto kwa chilinganizo chomwe mwalowa, musaike chizindikiro chofanana, apo ayi tidzawonetsa "FALSE" mu selo.

2. Tiyeni tiyambe ntchito. Kuti tichite izi, timachita mofanana ndi njira yapitayi: mu "Data" tabu timapeza chipika cha "Forecast". Apa ife alemba pa "Yesani ngati" ntchito, ndiyeno kupita "Sankhani chizindikiro" chida.

3. Pazenera lomwe likuwoneka, m'munda wa "Set value", lembani adilesi ya selo momwe tili ndi equation. Ndiye kuti, ili ndi zenera la "K22". M'munda wa "Value", timalemba nambala yomwe ikufanana ndi equation - 32. Mugawo la "Kusintha mtengo wa selo", lowetsani adiresi yomwe zosadziwika zidzakwanira. Tsimikizirani zochita zanu podina batani "Chabwino".

4. Pambuyo podina batani la "Chabwino", zenera latsopano lidzawonekera, momwe zimafotokozedwera momveka bwino kuti mtengo wachitsanzo womwe waperekedwa unapezedwa. Zikuwoneka motere:

Nthawi zonse pamene kuwerengera kosadziwika kumachitidwa ndi "Kusankhidwa kwa magawo", ndondomeko iyenera kukhazikitsidwa; popanda izo, n'zosatheka kupeza chiwerengero cha chiwerengero.

Upangiri! Komabe, kugwiritsa ntchito "Parameter Selection" mu Microsoft Excel pokhudzana ndi ma equation sikumveka, chifukwa kumafulumira kuthetsa mawu osavuta ndi osadziwika nokha, osati pofufuza chida choyenera mu e-book.

Mwachidule

M'nkhaniyi, tidasanthula za ntchito ya "Parameter kusankha". Koma dziwani kuti pankhani yopeza zosadziwika, mutha kugwiritsa ntchito chida chomwe chilipo chosadziwika. Pankhani ya matebulo, padzakhala kofunikira kusankha magawo payekhapayekha pa selo iliyonse, popeza chisankhocho sichimasinthidwa kuti chigwire ntchito ndi deta yonse.