Inqaku eliluncedo kakhulu kwiNkqubo ye-Microsoft i-Excel kukhetho lweparameter. Kodwa, ayinguye umsebenzisi owaziyo malunga nobuchule besixhobo. Ngayo, unokukhetha ixabiso lokuqala, ukutyhala ngaphandle kwesiphumo sokugqibela sokuba kufuneka uphumelele. Masifumanise ukuba ungayisebenzisa njani into yokukhetha iparameter kwi-Microsoft Excel.
Isiseko somsebenzi
Ukuba senziwe lula ukuthetha malunga nokukhethwa komsebenzi weparameter, ke ngoko ilele kwinto yokuba umsebenzisi angabale data eyimfuneko yokufezekisa iziphumo ezithile. Eli nqaku liyafana nesixhobo sesigqibo sezixhobo, kodwa yindlela eyenziwe lula. Ingasetyenziswa kuphela kwiifomula ezizodwa, oko kukuthi, ukubala kwiseli nganye ekufuneka iqhube kuyo yonke isixhobo kwakhona. Ukongeza, umsebenzi wokukhetha iparameter unokusebenza kuphela kwintshayelelo enye kuphela, kwaye enye yentsingiselo oyifunayo, ebonisa, njengesixhobo esisebenzayo.Umsebenzi wesicelo ekusebenzeni
Ukuze siqonde ukuba le nqaku isebenza njani, kungcono ukuchaza eyona nto iphambili kumzekelo osebenzayo. Siza kucacisa umsebenzi wesixhobo kumzekelo wenkqubo ye-Microsoft Excel, kodwa izenzo ze-algorithm zifana ngokugqibeleleyo kwiinguqulelo zalo nkqubo, kwaye ngo-2007.
Sineetafile zokuhlawula intlawulo kunye nabasebenzi boShishino. Kukho kuphela amabhaso abasebenzi. Umzekelo, ibhonasi yenye yazo - iNikolaev A. D, yi-6035.68 ruble. Kwakhona, yaziwa ukuba iprimiyamu ibalwa ngokuphindaphindise umvuzo kwi-COERD ye-0.28. Kufuneka sifumane umvuzo wabasebenzi.
Ukuqalisa umsebenzi ngelixa "idatha", cofa ku-"uhlalutyo" ukuba "", nto leyo ekhoyo kwi-Tepe "ibhloko yedatha" kwi-thepe "ibhloko yedatha" kwi-thepe. Imenyu iyavela apho ufuna ukukhetha "ukukhetha iparameter ...".
Emva koko, iwindows yokukhetha iparameter ivulwa. Kwindawo ethi "Fakela kwintsimi yeseli", kufuneka uchaze idilesi yayo enedatha yesiphelo esaziwa ngayo, esiya kwenza ukubalwa. Kule meko, esi siseli apho umqeshwa weNikolaev efakiwe. Idilesi inokuthi ichazwe ngesandla ngokusindisa ukunxibelelanisa kwayo kwicandelo elihambelanayo. Ukuba ukufumanisa kunzima ukwenza, okanye ukuthathele ingqalelo ngokungalunganga, nqakraza kwiseli enqwenelekayo, kwaye iya kufakwa idilesi endle.
Intsimi "yexabiso" ifuna ukucacisa ixabiso elithile lebhaso. Kwimeko yethu, iya kuba ngama-6035.68. Kwintsimi ethi "Ukutshintsha kwentsimi yeseli yeselfowuni, ungena kwidilesi yaso equlethe idatha yomthombo esifuna ukubala, oko kukuthi, ubungakanani bemivuzo yabasebenzi. Oku kungenziwa ngeendlela ezifanayo esithetha ngazo ngaphezulu: ukuqhuba ngokulungelelanisa ngesandla, okanye ucofe kwiseli efanelekileyo.
Xa yonke idatha ye-parameter yefestile igcwalisiwe, cofa kwiqhosha le-Ok.
Emva koko, ukubalwa kwenziwe, kwaye amaxabiso akhethiweyo afikelele kwiiseli, njengoko kuchaziwe ngefestile yolwazi olukhethekileyo.
Umsebenzi onjalo unokwenziwa kweminye imiqolo yetafile, ukuba ixabiso lePrimiyamu yelinye ishishini laziwa.
Ukusombulula i-equations
Ukongeza, nangona le ayisiyonto yeprofayile yalo msebenzi, inokusetyenziselwa ukucombulula i-equations. Kuyinyani, isiXhobo sokuKhetha esikhethileyo sinokusetyenziswa ngempumelelo ngokubhekisele kwi-equation kunye esingaziwayo.
Masithi sine-equation: 15x + 18x = 46. Rekhoda indima yaso esekhohlo, njengefomula, kwenye yeeseli. Njengalo naliphi na ifomula egqwesileyo, phambi kwe-equation, sibeka uphawu "=". Kodwa, kwangaxeshanye, endaweni yophawu x, useta idilesi yeseli apho iziphumo zexabiso elifunekayo ziya kuboniswa.
Kwimeko yethu, sibhala ifomula kwi-C2, kwaye ixabiso elinqwenelekayo liya kuboniswa kwi-B2. Ke, irekhodi kwiseli ye-C2 iya kuba nele fom ilandelayo: "= 15 * B2 + 18 * B2".
Siqala umsebenzi ngendlela efanayo njengoko kuchaziwe apha ngasentla, oko kukuthi, ngokucofa ku "uhlalutyo" ukuba ukuba "" kwaye "kwaye uguqule".
Kwifestile yokukhetha iparamitha evula, kwi "Fakela kwintsimi" yeseli, chaza idilesi esirekhodiweyo esirekhodiweyo (C2). Kwintsimi ethi "Ixabiso", faka inani lama-45, kuba sikhumbula ukuba i-equation imi ngolu hlobo lulandelayo: 15x + 18x = 46. Kwintsimi "yokutshintsha iseli", sichaza idilesi apho ixabiso le-X liyaboniswa, oko kukuthi, isisombululo se-equation (B2). Emva kokuba singene kule datha, cinezela iqhosha u "Kulungile".
Njengoko ubona, iMicrosoft Excel isombulule ngempumelelo i-equation. Ixabiso le-X liya kuba ngu-1.39 ngethuba.
Emva kokuvavanya isiXhobo sokukhetha iparameter, safumanisa ukuba ilula, kodwa kwangaxeshanye iluncedo kwaye ilungele ukufumana inombolo engaziwayo. Ingasetyenziswa zombini i-computing yetheyi yetheyi yetheyiki kwaye icombulule i-equations kunye engaziwayo. Kwangelo xesha, ngokwendlela yokusebenza, iphantsi kwesixhobo sezisombululo esinamandla ngakumbi.