Umsebenzi we-Excel: ukukhetha ipharamitha

I-Excel ijabulisa abasebenzisi bayo ngamathuluzi nemisebenzi eminingi ewusizo. Enye yalezi ngokungangabazeki Ukukhetha ipharamitha. Leli thuluzi likuvumela ukuthi uthole inani lokuqala ngokusekelwe kunani lokugcina ohlele ukulithola. Ake sibheke ukuthi singasebenza kanjani nalo msebenzi ku-Excel.

Kungani umsebenzi udingeka

Njengoba kushiwo ngenhla, umsebenzi womsebenzi Ukukhetha ipharamitha kuhlanganisa ukuthola inani lokuqala okungatholakala kulo umphumela wokugcina. Ngokuvamile, lo msebenzi ufana ne Sesha Izixazululo (ungayifunda ngokuningiliziwe esihlokweni sethu -), noma kunjalo, kulula.

Ungasebenzisa umsebenzi kufomula eyodwa kuphela, futhi uma udinga ukwenza izibalo kwamanye amaseli, kuzodingeka wenze zonke izenzo kuwo futhi. Futhi, ukusebenza kunqunyelwe inani ledatha ecutshungulwayo - inani elilodwa kuphela lokuqala nelokugcina.

Ukusebenzisa umsebenzi

Ake siqhubekele esibonelweni esisebenzayo esizokunikeza ukuqonda okungcono kakhulu kokuthi umsebenzi usebenza kanjani.

Ngakho, sinetafula elinohlu lwezimpahla zemidlalo. Sazi kuphela inani lesaphulelo (560 rub. esikhundleni sokuqala) kanye nobukhulu bayo, obufanayo kuzo zonke izinto. Kufanele uthole izindleko ezigcwele zezimpahla. Ngesikhathi esifanayo, kubalulekile ukuthi esitokisini, okuzobonisa kamuva inani lesaphulelo, ifomula yokubala kwayo yabhalwa (kithi, ukuphindaphinda inani eliphelele ngosayizi wesaphulelo).

Ngakho, i-algorithm yezenzo imi kanje:

1. Iya kuthebhu "Idatha"lapho sichofoza inkinobho “kuthiwani uma” ukuhlaziya eqenjini lamathuluzi “Isibikezelo”… Ohlwini oluya phansi, khetha "Ukukhetha ipharamitha" (ezinguqulweni zangaphambili, inkinobho ingase ibe seqenjini "Ukusebenza ngedatha").
2. Iwindi lizovela esikrinini ukuze ukhethe ipharamitha okufanele igcwaliswe:
   • kunani lensimu "Kufakwe esitokisini" sibhala ikheli elinedatha yokugcina esiyaziyo, okungukuthi leli yiseli elinenani lesaphulelo. Esikhundleni sokuzifakela izixhumanisi, ungavele uchofoze kuseli oyifunayo kuthebula ngokwalo. Kulokhu, ikhesa kufanele ibe senkambu ehambisanayo yokufaka ulwazi.
   • Njengenani, sibonisa inani lesaphulelo, esilaziyo - 560 deda.
   • In the "Ukushintsha inani leseli" ngokwenza noma ngokuchofoza ngegundane, cacisa izixhumanisi zeseli (kufanele abambe iqhaza kufomula yokubala inani lesaphulelo), lapho sihlela ukubonisa inani lokuqala.
   • cindezela uma usulungile OK.
3. Uhlelo luzokwenza izibalo futhi lubonise umphumela efasiteleni elincane elingavalwa ngokuchofoza inkinobho. OK. Futhi, amanani atholakele azovela ngokuzenzakalelayo kumaseli ashiwo wethebula.
4. Ngokufanayo, singakwazi ukubala inani elingenasaphulelo leminye imikhiqizo uma sazi inani eliqondile lesaphulelo kulowo nalowo mkhiqizo.

Ukuxazulula Izibalo Ngokusebenzisa Ukukhetha Kwepharamitha

Naphezu kweqiniso lokuthi lokhu akuyona isiqondiso esiyinhloko sokusebenzisa umsebenzi, kwezinye izimo, uma kuziwa kokungaziwa, kungasiza ekuxazululeni izilinganiso.

Isibonelo, sidinga ukuxazulula isibalo: 7x+17x-9x=75.

1. Sibhala isisho kuseli yamahhala, sishintsha uphawu x ekhelini leseli ofuna ukulithola inani lalo. Ngenxa yalokho, ifomula ibukeka kanjena: =7*D2+17*D2-9*D2.
2. Ukuchofoza Faka futhi uthole umphumela njengenombolo 0, okunengqondo impela, njengoba kufanele sibale inani leseli D2, okungu-“x” esibalweni sethu.
3. Njengoba kuchazwe esigabeni sokuqala se-athikili, kuthebhu "Idatha" cindezela inkinobho “kuthiwani uma” ukuhlaziya bese ukhetha "Ukukhetha ipharamitha".
4. Ewindini elivelayo, gcwalisa amapharamitha:
   • Inani lenkambu "Kufakwe esitokisini" khombisa izixhumanisi zeseli esibhale kulo isibalo (isb B4).
   • Ngenani, ngokusho kwe-equation, sibhala inombolo 75.
   • In the “Ukushintsha Amanani Eseli” cacisa izixhumanisi zeseli ofuna ukuzithola ivelu yazo. Esimweni sethu, lokhu kunjalo D2.
   • Uma yonke into isilungile, chofoza OK.
5. Njengasesibonelweni esikhulume ngaso ngenhla, izibalo zizokwenziwa futhi umphumela uzotholakala, njengoba kuboniswe ngefasitela elincane.
6. Ngakho-ke, sikwazile ukuxazulula i-equation futhi sithole inani x, okwaba ngu-5.

Isiphetho

Ukulinganisa kuwumsebenzi ongakusiza ukuthi uthole inombolo engaziwa etafuleni, noma uxazulule isibalo nengaziwa. Into eyinhloko ukwazi amakhono okusebenzisa leli thuluzi, futhi lizoba umsizi obalulekile ngesikhathi sokwenziwa kwemisebenzi ehlukahlukene.