Ukukhetha ipharamitha ku-Excel. "Khetha ipharamitha" umsebenzi

Umsebenzi othi “Khetha ipharamitha” ku-Excel ikuvumela ukuthi unqume ukuthi laliyini inani lokuqala, ngokusekelwe enanini lokugcina elaziwayo. Bambalwa abantu abazi ukuthi leli thuluzi lisebenza kanjani, lo myalelo wendatshana uzokusiza ukuthi ukuthole.

Indlela umsebenzi osebenza ngayo

Umsebenzi oyinhloko womsebenzi othi “Parameter Selection” ukusiza umsebenzisi we-e-book abonise idatha yokuqala eholele ekubonakaleni komphumela wokugcina. Ngokusho kwesimiso sokusebenza, ithuluzi lifana nethi "Sesha Isixazululo", futhi "Ukukhethwa Kwezinto Zokusebenza" kubhekwa njengento elula, ngoba ngisho nomuntu oqalayo angakwazi ukusingatha ukusetshenziswa kwayo.

Nakani! Isenzo somsebenzi okhethiwe sithinta iseli eyodwa kuphela. Ngakho-ke, lapho uzama ukuthola inani lokuqala lamanye amafasitela, kuzodingeka wenze zonke izenzo futhi ngokuvumelana nesimiso esifanayo. Njengoba umsebenzi we-Excel ungasebenza enanini elilodwa kuphela, uthathwa njengokhetho olunomkhawulo.

Izici zohlelo lokusebenza: ukubuka konke kwesinyathelo ngesinyathelo ngencazelo usebenzisa isibonelo sekhadi lomkhiqizo

Ukuze sikutshele kabanzi mayelana nokuthi i-Parameter Selection isebenza kanjani, masisebenzise i-Microsoft Excel 2016. Uma unenguqulo yakamuva noma yangaphambili yohlelo lokusebenza olufakiwe, izinyathelo ezithile kuphela zingahluka kancane, kuyilapho isimiso sokusebenza sihlala sinjalo.

1. Sinetafula elinohlu lwemikhiqizo, lapho kuphela amaphesenti esaphulelo aziwa khona. Sizobheka izindleko kanye nenani eliwumphumela. Ukuze wenze lokhu, iya kuthebhu ethi "Idatha", engxenyeni ethi "Isibikezelo" sithola ithuluzi elithi "Analysis what if", chofoza umsebenzi "Ukukhetha Ipharamitha".

2. Uma kuvela iwindi le-pop-up, endaweni ethi "Setha kuseli", faka ikheli leseli olifunayo. Esimweni sethu, leli inani lesaphulelo. Ukuze singakubekeli isikhathi eside futhi singashintshi ngezikhathi ezithile ukwakheka kwekhibhodi, sichofoza kuseli oyifunayo. Inani lizovela ngokuzenzakalelayo endaweni efanele. Ngokuphambene nenkambu ethi "Value" khombisa inani lesaphulelo (ama-ruble angama-300).

Kubalulekile! Iwindi elithi “Khetha ipharamitha” alisebenzi ngaphandle kwenani elimisiwe.

3. Kunkambu ethi “Shintsha inani leseli”, faka ikheli lapho sihlele ukubonisa khona inani lokuqala lentengo yomkhiqizo. Sigcizelela ukuthi leli windi kufanele libambe iqhaza ngokuqondile kufomula yokubala. Ngemuva kokuqinisekisa ukuthi wonke amanani uXNUMXbuXNUMXbare afakwe kahle, chofoza inkinobho ethi "KULUNGILE". Ukuze uthole inombolo yokuqala, zama ukusebenzisa iseli esetafuleni, ngakho kuzoba lula ukubhala ifomula.

4. Ngenxa yalokho, sithola izindleko zokugcina zezimpahla ngokubalwa kwazo zonke izaphulelo. Uhlelo lubala ngokuzenzakalelayo inani elifiswayo futhi libonise efasiteleni le-pop-up. Ngaphezu kwalokho, amanani aphindiwe kuthebula, okuyiseli elikhethelwe ukwenza izibalo.

Encwadini! Ukufaka izibalo kudatha engaziwa kungenziwa kusetshenziswa umsebenzi othi “Khetha ipharamitha”, ngisho noma inani eliyinhloko liwuhlobo lwengxenye yedesimali.

Ukuxazulula isibalo usebenzisa ukukhethwa kwamapharamitha

Isibonelo, sizosebenzisa i-equation elula ngaphandle kwamandla nezimpande, ukuze sikwazi ukubona ngokubonakalayo ukuthi isisombululo senziwa kanjani.

1. Sinesibalo: x+16=32. Kuyadingeka ukuqonda ukuthi iyiphi inombolo efihliwe ngemuva kwe "x" engaziwa. Ngakho-ke, sizoyithola sisebenzisa umsebenzi we- "Parameter Selection". Okokuqala, sibeka i-equation yethu kuseli, ngemuva kokufaka uphawu "=". Futhi esikhundleni sokuthi “x” sibeka ikheli leseli lapho okungaziwa kuzovela khona. Ekupheleni kwefomula efakiwe, ungafaki uphawu olulinganayo, ngaphandle kwalokho sizobonisa "FALSE" kuseli.

2. Ake siqale umsebenzi. Ukuze wenze lokhu, senza ngendlela efanayo nasendleleni yangaphambilini: kuthebhu "Idatha" sithola "Isibikezelo" block. Lapha sichofoza umsebenzi othi "Hlaziya kuthiwani uma", bese uya kuthuluzi elithi "Khetha ipharamitha".

3. Efasiteleni elivelayo, kunkambu ethi “Setha inani”, bhala ikheli leseli esinezibalo kulo. Okusho ukuthi, leli yiwindi elithi "K22". Emkhakheni othi "Value", sibhala inombolo elingana ne-equation - 32. Ensimini ethi "Ukushintsha inani leseli", faka ikheli lapho okungaziwa kuzongena khona. Qinisekisa isenzo sakho ngokuchofoza inkinobho ethi "KULUNGILE".

4. Ngemuva kokuchofoza inkinobho ethi "KULUNGILE", kuzovela iwindi elisha, lapho kucaciswe khona ukuthi inani lesibonelo esinikeziwe litholakele. Kubukeka kanjena:

Kuzo zonke izimo lapho ukubalwa kokungaziwa kwenziwa "Ukukhethwa kwamapharamitha", ifomula kufanele isungulwe; ngaphandle kwalo, akunakwenzeka ukuthola inani lezinombolo.

Iseluleko! Kodwa-ke, ukusebenzisa umsebenzi othi “Ukukhetha Ipharamitha” ku-Microsoft Excel maqondana nezibalo akunangqondo, ngoba kuyashesha ukuxazulula izinkulumo ezilula ngokungaziwa uwedwa, hhayi ngokucinga ithuluzi elifanele ku-e-book.

Ukufingqa

Esihlokweni, sihlaziyele ukusetshenziswa komsebenzi we- "Parameter selection". Kodwa qaphela ukuthi esimweni sokuthola okungaziwa, ungasebenzisa ithuluzi elinikezwe ukuthi kukhona okungaziwa kuphela. Endabeni yamathebula, kuzodingeka ukhethe amapharamitha ngawodwana kuseli ngalinye, njengoba inketho ayishintshwa ukuze isebenze nalo lonke uhla lwedatha.