Kusarudza parameter muExcel. "Sarudza parameter" basa

Basa re "Sarudza parameter" muExcel rinokutendera kuti uone kuti kukosha kwekutanga kwaive kupi, zvichibva pane yakatozivikanwa kukosha kwekupedzisira. Vashoma vanhu vanoziva kuti chishandiso ichi chinoshanda sei, ichi chinyorwa-kuraira chichakubatsira iwe kuti uzvione.

Mashandiro anoita basa racho

Basa guru re "Parameter Selection" basa nderokubatsira mushandisi we-e-book kuratidza data rekutanga rakatungamirira pakuonekwa kwechigumisiro chekupedzisira. Maererano nenheyo yekushanda, chimbo chacho chakafanana ne "Tsvaga Mhinduro", uye "Sarudzo Yezvinhu" inofungidzirwa kuti iri nyore, sezvo kunyange anotanga anogona kubata kushandiswa kwayo.

Teerera! Chiito chebasa rakasarudzwa chinobata sero rimwe chete. Saizvozvo, kana uchiedza kutsvaga kukosha kwekutanga kune mamwe mahwindo, iwe uchafanirwa kuita zvese zviito zvakare maererano neiyo musimboti. Sezvo basa reExcel richingoshanda pane imwechete kukosha, inoonekwa seyakaganhurwa sarudzo.

Zvimiro zvechishandiso chebasa: nhanho-nhanho nhanho ine tsananguro uchishandisa muenzaniso wechigadzirwa kadhi

Kuti ndikuudze zvakawanda pamusoro pekuti Parameter Selection inoshanda sei, ngatishandisei Microsoft Excel 2016. Kana iwe uine gare gare kana yapfuura shanduro yekushandiswa yakaiswa, ipapo mamwe matanho chete anogona kusiyana zvishoma, asi nheyo yekushanda inoramba yakafanana.

1. Tine tafura ine runyorwa rwezvigadzirwa, umo chete muzana wekuderedzwa unozivikanwa. Tichatsvaga mari uye mari inoguma. Kuti uite izvi, enda ku "Data" tab, muchikamu che "Forecast" tinowana "Ongororo chii kana" chishandiso, tinya pa "Parameter sarudzo" basa.

2. Kana hwindo rinobuda richioneka, mundima ye "Set in cell", isa iyo yaunoda sero kero. Kwatiri, iyi ndiyo mari yekuderedzwa. Kuti urege kuinyora kwenguva yakareba uye kwete nguva nenguva kushandura iyo keyboard marongerwo, isu tinya pane yaunoda sero. Ukoshi huchangoerekana hwaonekwa mumunda chaiwo. Kupesana nemunda "Kukosha" kunoratidza huwandu hwekuderedzwa (300 rubles).

Zvinokosha! Iwindo re "Sarudza parameter" harishande pasina kukosha kwakatarwa.

3. Mundima ye "Shandura kukosha kwesero", isa kero yatinoronga kuratidza kukosha kwekutanga kwemutengo wechigadzirwa. Isu tinosimbisa kuti hwindo iri rinofanira kutora chikamu mune yekuverenga formula. Mushure mekuita shuwa kuti hunhu hwese uXNUMXbuXNUMXbare hwakapinda nemazvo, tinya bhatani rekuti "OK". Kuti uwane nhamba yekutanga, edza kushandisa sero iri mutafura, saka zvichava nyore kunyora fomu.

4. Nekuda kweizvozvo, tinowana mutengo wekupedzisira wezvinhu nekuverenga kwese kuderedzwa. Iyo purogiramu inoverenga otomatiki kukosha kwainoda uye inoiratidza mune pop-up hwindo. Pamusoro pezvo, hunhu hunodzokororwa mutafura, kureva musero rakasarudzwa kuita masvomhu.

Pane chinyorwa! Kukodzera kuverenga kune isingazivikanwe data kunogona kuitwa uchishandisa "Sarudza parameter" basa, kunyangwe kukosha kwekutanga kuri muchimiro chechidimbu chedesimali.

Kugadzirisa equation uchishandisa sarudzo yeparameter

Semuenzaniso, tichashandisa equation iri nyore pasina masimba nemidzi, kuitira kuti tigone kuona kuti mhinduro yacho inogadzirwa sei.

1. Tine equation: x+16=32. Izvo zvinodikanwa kuti unzwisise kuti ndeipi nhamba yakavanzwa kumashure kwe "x" isingazivikanwe. Saizvozvo, isu tichaiwana tichishandisa iyo "Parameter Selection" basa. Kutanga, tinonyora equation yedu muchitokisi, mushure mekuisa chiratidzo "=". Uye panzvimbo ye "x" tinoisa kero yesero umo zvisingazivikanwe zvichaonekwa. Pakupera kwefomura yakapinda, usaisa chiratidzo chakaenzana, kana zvisina kudaro isu ticharatidza "FALSE" muchitokisi.

2. Ngatitange basa. Kuti tiite izvi, tinoita nenzira imwecheteyo nenzira yapfuura: mu "Data" tab tinowana "Forecast" block. Pano tinodzvanya pane "Ongorora chii kana" basa, uye woenda kune "Sarudza parameter" chishandiso.

3. Muhwindo rinoonekwa, mu "Set value" munda, nyora kero yesero umo tine equation. Ndiko kuti, iyi ndiyo "K22" hwindo. Mundima ye "Value", zvakare, tinonyora nhamba iyo yakaenzana nekuenzanisa - 32. Mundima ye "Kushandura kukosha kwesero", pinda kero iyo isingazivikanwi ichakodzera. Simbisa chiito chako nekudzvanya pakanzi "OK".

4. Mushure mekudzvanya bhatani re "OK", hwindo idzva richaonekwa, iro rinonyatso kutaurwa kuti kukosha kwemuenzaniso wakapihwa kwakawanikwa. Zvinoita seizvi:

Muzviitiko zvose apo kuverengwa kwezvisingazivikanwi kunoitwa ne "Sarudzo yemiganhu", chirevo chinofanira kusimbiswa; pasina iyo, hazvibviri kuwana kukosha kwenhamba.

Zano! Nekudaro, kushandisa iyo "Parameter yekusarudza" basa muMicrosoft Excel zvine chekuita neequations hazvina musoro, nekuti inokurumidza kugadzirisa matauriro akareruka neasingazivikanwe wega, uye kwete nekutsvaga chishandiso chakakodzera mune e-bhuku.

Kupfupisa

Muchinyorwa, isu takaongorora nezvekushandisa nyaya ye "Parameter sarudzo" basa. Asi cherechedza kuti munyaya yekuwana zvisingazivikanwe, unogona kushandisa chishandiso chakapihwa kuti pane imwe chete isingazivikanwe. Panyaya yematafura, zvichave zvakafanira kusarudza maparameter ega ega sero rega, sezvo sarudzo isingagadziriswe kushanda nehuwandu hwe data.