Isici esiwusizo kakhulu kuMicrosoft Excel UkuKhetha Ipharamitha. Kepha, akuwona wonke umsebenzisi owazi ngamakhono aleli thuluzi. Ngosizo lwayo, kungenzeka ukukhetha inani lokuqala, kusukela kumphumela wokugcina odinga ukufinyelelwa. Ake sibheke ukuthi ungawusebenzisa kanjani umsebenzi wokufanisa ipharamitha kuMicrosoft Excel.
Umongo womsebenzi
Uma kungelula ukukhuluma ngomnyombo Wokukhetha umsebenzi wepharamitha, khona-ke kuqukethe iqiniso lokuthi umsebenzisi angakwazi ukubala idatha yokuqala edingekayo ukuze afinyelele umphumela othize. Lesi sici sifana nethuluzi le-Solution Finder, kepha inketho elula kakhulu. Ingasetshenziswa kuphela kumafomula wodwa, okungukuthi, ukubala kuseli ngalinye, udinga ukusebenzisa leli thuluzi futhi ngaso sonke isikhathi. Ngaphezu kwalokho, umsebenzi wokukhetha ipharamitha ungasebenza ngokufaka okukodwa kanye nenani elilodwa olufunayo, elikhuluma ngalo njengethuluzi elisebenza ngokulinganiselwe.
Ukubeka umsebenzi
Ukuze uqonde ukuthi lo msebenzi usebenza kanjani, kungcono ukuchaza ingqikithi yawo ngesibonelo esisebenzayo. Sizochaza ukusebenza kwaleli thuluzi sisebenzisa isibonelo seMicrosoft Excel 2010, kepha i-algorithm yezenzo icishe ifane kuzo zombili izinguqulo zakamuva zalolu hlelo nakuhlobo luka-2007.
Sinethebula lamaholo nezinkokhelo zebhonasi kubasebenzi. Amabhonasi abasebenzi ayaziwa kuphela. Isibonelo, i-premium enye yazo - uNikolaev A. D, ngama-ruble angama-6035.68. Kuyaziwa futhi ukuthi iprimiyamu ibalwa ngokwengeza amaholo ngesizathu esingu-0.28. Kufanele sithole inkokhelo yabasebenzi.
Ukuze uqale umsebenzi, ekubeni kuthebhu ethi "Idatha", chofoza inkinobho ethi "What if", ebekwe endaweni ethi "Working with Data" block on the ribbon. Kuvela imenyu lapho udinga ukukhetha into ethi "Ukukhetha Ipharamitha ..." .
Ngemuva kwalokho, iwindi lokukhetha ipharamitha liyavula. Ensimini ethi "Faka kuseli", udinga ukucacisa ikheli layo eliqukethe idatha yokugcina esaziyo, esiyokwenza ngokwezifiso ukubalwa. Kulesi simo, lesi yiseli lapho kunikezwa khona umklomelo wabasebenzi bakaNikolaev. Ikheli lingacaciswa ngesandla ngokushayela izixhumanisi zalo enkambeni ehambisanayo. Uma ulahlekelwe ukwenza lokhu, noma ukuthole kungaphazamisi, vele uchofoze kuseli oyifunayo bese ikheli lizongena endle.
Ensimini "Ivelu" kufanele uchaze inani elithile le-premium. Esimweni sethu, kuzoba ngu-6035.68. Emkhakheni "Ukushintsha amanani weseli" sifaka ikheli laso eliqukethe idatha yomthombo esidinga ukuyibala, okungukuthi, inani lomholo womsebenzi. Lokhu kungenziwa ngezindlela ezifanayo esikhulume ngazo ngenhla: shayela izixhumanisi ngesandla, noma chofoza kuseli elihambisanayo.
Lapho yonke idatha yewindows iphakethe igcwaliswa, chofoza inkinobho "Kulungile".
Ngemuva kwalokho, ukubalwa kwenziwa, futhi amanani akhethiwe angena kumaseli, njengoba kubikwa iwindi lemininingwane elikhethekile.
Ukusebenza okufanayo kungenziwa kweminye imigqa yetafula, uma inani lebhonasi labasebenzi abasele bebhizinisi laziwa.
Isixazululo
Ngaphezu kwalokho, noma lesi akusona isici sephrofayili salo msebenzi, singasetshenziswa ukuxazulula i-equation. Kuliqiniso, ithuluzi lokukhetha ipharamitha lingasetshenziswa ngempumelelo kuphela maqondana namanani angaziwa.
Ake sithi sine-equation: 15x + 18x = 46. Sibhala uhlangothi lwayo lwesobunxele, njengefomula, kwelinye lamaseli. Njenganoma iyiphi ifomula ku-Excel, sibeka uphawu = phambi kwe-equation. Kepha, ngasikhathi sinye, esikhundleni sesibonakaliso x sibeka ikheli leseli lapho umphumela wenani olifunayo uzokhonjiswa khona.
Esimweni sethu, sibhala ifomula ku-C2, futhi inani elifunayo lizokhonjiswa ku-B2. Ngakho-ke, ukungena kweseli C2 kuzoba nefomu elilandelayo: "= 15 * B2 + 18 * B2".
Siqala umsebenzi ngendlela efanayo naleyo echazwe ngenhla, okungukuthi, ngokuchofoza inkinobho ethi "Ukuhlaziywa", kuthiwani uma "esekhalini", nangokuchofoza ku- "Ipharamitha Ukukhetha ...".
Ewindi lokukhetha ipharamitha elivula, enkampanini ethi "Setha esitokisini", chaza ikheli lapho sabhala khona i-equation (C2). Emkhakheni "Inani" sifaka inombolo u-45, ngoba sikhumbula ukuthi i-equation ibukeka kanjena: 15x + 18x = 46. Emkhakheni "Ukushintsha amanani weseli" sibonisa ikheli lapho inani le-x lizokhonjiswa, okungukuthi, empeleni, isisombululo se-equation (B2). Ngemuva kokufaka le datha, chofoza inkinobho ethi "kulungile".
Njengoba ukwazi ukubona, iMicrosoft Excel ixazulule ngempumelelo i-equation. Inani le-x lizoba ngu-1.39 esikhathini.
Ngemuva kokuhlola ithuluzi lokukhetha iParameter, sithole ukuthi lokhu kulula impela, kepha ngasikhathi sinye umsebenzi owusizo futhi ofanele wokuthola inombolo engaziwa. Ingasetshenziswa zombili ukubala kwe-tabular, nokuxazulula i-equation neyodwa engaziwa. Ngasikhathi sinye, ngokuya kokusebenza, liphansi kunethuluzi lokusesha lesisombululo elinamandla kakhudlwana.
