Isici esiwusizo kakhulu ku-Microsoft Excel ukukhethwa kwepharamitha. Kodwa, akuwona wonke umsebenzisi owaziyo ngamakhono ale thuluzi. Ngalo, ungathatha inani lokuqala, uqale emphumela wokugcina ofuna ukufezekisa. Ake sithole ukuthi ungasebenzisa kanjani umsebenzi wokukhetha i-parameter ku-Microsoft Excel.
Okuyisisekelo somsebenzi
Uma kulula ukukhuluma ngokubaluleka komsebenzi wokukhethwa kweParameter, khona-ke kulele ukuthi umsebenzisi angabala idatha edingekayo yokufaka ukuze afinyelele umphumela othize. Lesi sici sifana nethuluzi leSolution Finder, kodwa kuyindlela elula. Kungasetshenziswa kuphela emafomini owodwa, okungukuthi, ukubala esitokisini ngasinye, kudingeka usebenzise leli thuluzi futhi njalo. Ngaphezu kwalokho, umsebenzi wokukhetha ipharamitha ungasebenza ngokufaka okukodwa kuphela, kanye nenani elifunayo elilodwa elibhekisela kulo njengethuluzi elinomsebenzi olinganiselwe.
Ukusebenza komsebenzi ekusebenzeni
Ukuze uqonde ukuthi lo msebenzi usebenza kanjani, kungcono ukuchazela isisekelo saso ngesibonelo esiwusizo. Sizochaza umsebenzi wele thuluzi kusibonelo se-Microsoft Excel 2010, kodwa i-algorithm yezenzo cishe ifana nezinguqulo zamuva zalolu hlelo futhi ngo-2007.
Sinetafula lokukhokhwa kwamaholo namabhonasi kubasebenzi benkampani. Ama-bonuses kuphela abasebenzi abonakalayo. Isibonelo, umklomelo womunye wabo, uNikolaev A. D, yi-ruble angu-6,035.68. Futhi, kwaziwa ukuthi i-premium ibalwa ngokuphindaphinda umholo ngesici se-0.28. Kufanele sithole inkokhelo yabasebenzi.
Ukuze uqale umsebenzi, ekubeni kuthebhu ethi "Idatha", chofoza "Hlaziya" kuthiwani uma "inkinobho, esitholakala kubha yamathuluzi ethi" Ukusebenza neDatha "kulayini. Imenyu ibonakala lapho okudingeka ukhethe khona" Ukukhethwa kweparameter ... " .
Emva kwalokho, iwindi lokukhetha ipharamitha livula. Emkhakheni othi "Setha esitokisini" udinga ukucacisa ikheli laso, equkethe idatha yokugcina esaziwayo, ngaphansi kwayo esizoyihlela khona ukubala. Kulesi simo, kuyiseli lapho umklomelo wesisebenzi sikaNikolaev usungulwa khona. Ikheli lingacaciswa ngesandla ngokuthayipha izixhumanisi zayo endaweni efanele. Uma uthola kunzima ukwenza lokhu, noma ucabange ukuthi kuyingozi, mane uchofoze esitokisini oyifunayo, futhi ikheli lizofakwa ensimini.
Ensimini "Value" kuyadingeka ukuze ucacise inani elithile lomklomelo. Esimweni sethu, kuyoba ngu-6035.68. Esikhathini esithi "Ukushintsha amanani eseli", faka ikheli layo eliqukethe idatha yokuqala esiyidingayo ukubala, okungukuthi, inani lomholo wesisebenzi. Lokhu kungenziwa ngezindlela ezifanayo esizikhulume ngazo ngenhla: ngesandla faka izixhumanisi, noma chofoza iseli elihambelanayo.
Lapho yonke idatha efasiteleni yemingcele igcwele, chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, ukubalwa kwenziwa, futhi izindinganiso ezifanisiwe zivumelaniswe namaseli, okubikwa iwindi lesikhwama solwazi olukhethekile.
Ukusebenza okufanayo kungenziwa kwezinye imigqa yetafula, uma inani le-premium labasebenzi abasele lenkampani liyaziwa.
Ukuxazulula ukulingana
Ngaphezu kwalokho, nakuba akuyona into esemqoka yalo msebenzi, ingasetshenziswa ukuxazulula ukulingana. Noma kunjalo, ithuluzi lokukhetha ipharamitha lingasetshenziswa ngokuphumelelayo kuphela ngokuphathelene nama-equations nomunye ongaziwa.
Ake sithi sine-equation: 15x + 18x = 46. Bhala uhlangothi lwaso lwesobunxele, njengefomula, kwelinye lamaseli. Ngokuqondene nanoma yiliphi ifomula ku-Excel, ngaphambi kokuba i-equation ifake uphawu "=". Kodwa, ngesikhathi esifanayo, esikhundleni se-x uphawu, sibeka ikheli leseli lapho umphumela wekhwalithi oyifunayo uzokhipha.
Esimweni sethu, sibhala ifomula ku-C2, futhi inani elifunayo lizoboniswa ku-B2. Ngakho, ukungena esitokisini C2 kuzoba nefomu elilandelayo: "= 15 * B2 + 18 * B2".
Siqala umsebenzi ngendlela efanayo njengoba kuchaziwe ngenhla, okungukuthi, ngokuchofoza inkinobho ethi "Ukuhlaziywa", kuthiwani uma "ku-tape", nokuchofoza entweni "Ukukhethwa kwepharamitha ...".
Ewindini lokukhetha i-parameter evulekile, ensimini "Setha esitokisini" sibonisa ikheli esabhala ngalo ukulingana (C2). Ensimini "Value" singena inombolo engu-45, njengoba sikhumbula ukuthi ukulingana kubonakala kanje: 15x + 18x = 46. Esikhathini esithi "Ukushintsha amanani eseli", sikhombisa ikheli lapho inani le-x lizokhishwa khona, okungukuthi, isisombululo se-equation (B2). Ngemva kokungena kule datha, chofoza inkinobho ethi "Kulungile".
Njengoba ubona, i-Microsoft Excel ixazululwe ngempumelelo ukulingana. Inani le-x lizolingana no-1.39 esikhathini.
Ngemva kokuhlola ithuluzi lokukhetha i-parameter, sithole ukuthi lokhu kulula, kodwa ngesikhathi esifanayo futhi ewusizo futhi elula ukuthola inombolo engaziwa. Ingasetshenziswa kokubili kokubala kwe-tabular, nokuxazulula ukulingana nomunye ongaziwa. Ngesikhathi esifanayo, ngokusebenza, kungaphansi kwesithuluzi esinamandla kakhulu Sesesho Solution.
