"Ukufumana isisombululo" kwi-Excel 2010. Kuphi ukungena kwi "Solution search" Excel

Yonke into ehlabathini iguquka, kwaye oku kwenzeka nangakhathaliseki ukuba sinomnqweno. Inyaniso engatshintshiyo yaziwa ngokukodwa kubasebenzisi bekhomputha, abaye bathatha umkhwa wokuhlaziywa ngamakhadi kunye nexesha elimangalisayo. Ngethamsanqa, iiphakheji zeofisi azihluphekanga, nangona kukho ukungabikho phakathi kwabo.

Yintoni ukubaluleka kweepakethe zeekhompyutha kwiofisi?

Naliphi na isofthiwe yeofisi isixhobo esiluncedo esilungiselelwe ukusebenza kunye neenkcukacha ezinkulu, inani lezinto ezincedisayo eziye zanda kakhulu. Ngoku ngokuncediswa kwezixhobo zokuboniswa, ezabonakala kwiinguqulelo ezintsha zeenkqubo, kwaba nzima kakhulu ukusebenza. Kukho intsha yecrafti yokukhangela eyenza ngokukhawuleza iphakame umsebenzi kunye nokuhamba okukhulu kolwazi. I-Microsoft Excel 2010 ngokwayo isebenza ngokukhawuleza.

Kubonakala ngathi ngoku nje unobhala banobuchule be-MS Office 2007, indlela ukukhululwa kwe-Ofisi ka-2010 kuphumelele ngayo, eyongezelelekileyo kwintloko embi. Kodwa ungacingi ukuba le nguqulo entsha yeprogram "iphosa" abasebenzisi bayo ubunzima kuphela.

Umzekelo walokhu "isisombululo sokusesha" kwi-Excel 2010. Oku kungenayo akusiyo kuphela incedo, kunceda kwakhona ukwenza umsebenzi wakho kunye nomhleli wespredishithi uvelise ngakumbi, kukuvumela ukuba usombulule imisebenzi enzima kakhulu. Ngokukodwa kukulungele ukulungiswa, okufanelekileyo kwiinkampani ezininzi zanamhlanje.

Kutheni i-2010 inguqulelo?

Ngaphandle kwe-Excel yale nguqulo ethile, utshintsho oluphawulekayo luyenzeka nalo. Ngokukodwa, iiphoso ezininzi kwiimfomula zilungisiwe, ngenxa yokuba kwiimeko ezidlulileyo zeprogram kwakudla ngokuba kukho iimpazamo ezibi kakhulu kwizibalo. Akuyimfuneko ukukhankanya ukuba ukugqithiswa okukodwa xa ubeka ubungakanani be-premium buba nemiphumo emibi kakhulu.

Ngombulelo kumboniso omtsha we "ribbon", apho kunokwenzeka ukubonisa ukuboniswa kwemifanekiso kunye negrafu ngaphambi kokufakwa ngokuthe ngqo kwitafile, kuba lula ukuba umsebenzisi abhale amaxwebhu aqeqeshiweyo.

Ukongezelela, inguqulelo entsha yale mgca wetafile ifake iindidi ezintsha zefomula eziya kuba luncedo kakhulu kubagcini bezimali kunye nezoqoqosho. Le meko ibonisa kwakhona "ukuhlonela" kweMicrosoft kubasebenzisi benkampani. Ngenxa yokuba ezi zilandelayo ziimeko zabo, akukho nto ebamangalisayo kule nto.

Kubalulekile! Ukuba awuzange usisebenzise ngaphambili "isisombululo sokusesha" kwi-Excel 2010, ke le ngxube kufuneka ifakwe ngokuhlukileyo.

Ungayifaka njani?

Ngethamsanqa, akunzima ukwenza oku. Ukuba usebenzisa i-Excel 2003 okanye kamva, kufuneka uhambe kwinto ye menu ethi "Izixhobo", uze ukhethe "I-Add-on" apho. Yaye apho i-Excel yinto "yokukhangela izicombululo", ukuba ngumbuzo weenguqu zexesha elizayo kunye neli xesha?

Kwimeko yokusebenzisa i-Excel ukusuka kwinguqulelo ka-2007, iqhosha elithi "Ukufumana izicombululo" lingafumaneka kwi "Tab".

Indlela yokusebenza nale nto?

Nangona kubonakala ubude beenkcazo, lo mhlaba uphezulu usebenza ngokucacileyo, kwaye ukuba ukuqonda kwakhe akufuneki ukuba yi-computer ye-genius. Ukuze uqonde ngokupheleleyo umgaqo wesicelo sawo, siya kuwuqwalasela kumzekelo obulula.

Ngoko, "isisombululo sosesho" sisebenza njani kwi-Excel 2010? Masithi, ukuba phambi kwakho kubekho ukunikezelwa kwemisebenzi ye-premium kwintlangano yakho. Ukuze kube lula ukuxazulula ingxaki, makhe sicinge ukuba kufuneka usasaze ibhonasi phakathi kwabo bonke abasebenzi beli sebe. Ubungakanani bebhajethi yebhonasi yi-ruble eziyiwaka ezili-100. Ukwenza oku, unako ukusabalalisa ubungakanani bentlawulo yebhonasi ukuya kubukhulu bomvuzo womqeshwa ngamnye.

Umsebenzi uqala njani?

Ewe, loo msebenzi uya kuqala ngokuphuhliswa kwetafile, ukungena kuzo zonke iinkcukacha ezifunekayo kunye nobume befomula. Ngenxa yoko, ixabiso lilonke lexabiso lebhonasi liya kuqwalaselwa.

Kubalulekile ukwazi ukuba iseli ekujoliswe kuyo (ukucinga ukuba yiC8) idibene necandelo eliya kutshintsha (E2, umzekelo). Ngaloo ndlela, iifomula ezongezelelweyo ziya kufakwa kwibala le C2-C7, apho uya kubala ubungakanani bentlawulo yebhonasi kumqeshwa ngamnye.

Emva koko, i-add-in "yosesho" iqalisiwe kwi-Excel 2010, emva koko iimpawu ezifunekayo ziboniswa kwifestile evuliwe. Qaphela ukuba kwiinguqu ezahlukeneyo zeofisi ye-ofisi, ukubonakala kwezi bhokisi yencoko yababini kunokuhluka kakhulu, ngoko kuya kufuneka ujongane nemeko ngokwakho. Ngethamsanqa, akukho mahluko ekhadikhadi, ngoko akudingeki ukuba uqonde kakhulu.

Ziziphi iinketho ezikhoyo kwibhokisi yencoko yababini?

Ukuququzelela umsebenzi wakho, kufuneka sikhulume ngeempawu eziqhelekileyo ezifumaneka kwicandelo elithile lomsebenzi.

Okokuqala, eli lilitye elijoliswe kuyo. Thabatha ingqalelo! Ngokungafani neminye imisebenzi, okungathi ukusetyenziswa kweendawo eziliqela ngokukhawuleza ukuvelisa idatha, kule meko inokuba yinto enye!

Okwesibini, qiniseka ukuba uhlale ukhumbule ukuba ukhetho lokusebenza lunokuthi lube luninzi kwangoko. Nika ingqwalasela ubuncinane okanye ubuncinane ubunani bexabiso, kunye nesiphumo esithile. Ukuba ufuna ikhetho lokugqibela, kufuneka ucacise umphumo okhethiweyo kwingcambu yenkalo.

Kwakhona, khumbula ukuba kwindima yamaseli aguqukayo angaba yimimandla ehlukeneyo, kwaye uluhlu lwazo zonke. Enyanisweni, kuluhlu loluhlu lwenkqubo oluthatha intengo yokugqibela, ukuthelekisa kunye neentlobo zeenkcukacha zangaphambili.

Ndingayongeza njani imithintelo?

Ukuba ufuna ukufaka ezinye izithintelo, ngoko kufuneka usebenzise inkinobho "Yongeza". Qaphela ukuba xa ubeka ezo zixabiso, kufuneka uqaphele kakhulu. Ukususela kwi-Excel "Ukufumana isisombululo" (imizekelo esicinga ngayo) isetyenziswe kwimisebenzi ebalulekileyo, kubaluleke kakhulu ukufumana ixabiso elichanekileyo.

Ngendlela, kuvela kwimimiselo yokuba ezi ziphumo zixhomekeka. Gcina ukhumbule ukuba awukwazi ukubalula nje kuphela iiseli ezithile, kodwa kuzo zonke izigaba. Kule meko, yiyiphi iindidi zeempawu kunye neifomula endingazisebenzisa?

Ungasebenzisa imiqondiso: "=", "> = =", "<=". Ukongeza, iifomula zivunyelwe: "I-Target", "Bean" (ibhanari okanye inani elipheleleyo), kunye ne "Time". Kubalulekile! Ikhefu lokugqibela livumela ukusetyenziswa kwazo zonke iindidi ezahlukeneyo. Oku kufumaneka kuphela kwiinguqu ze-Excel 2010 nangaphezulu, esinye esinye isizathu sokutshintsha kwabo. Kule maphakheji yesofthiwe yeofisi, "ukufuna isisombululo esiphezulu" kwi-Excel ayenziwanga ngokukhawuleza, kodwa kulunge ngakumbi.

Ukuba sithetha malunga nokubala iiprayimesi, ngoko-coefficient kufuneka ichaneke kakuhle. Ungacacisa le parameter ngeendlela eziliqela. Kulula ukwenza lo msebenzi usebenzisa inkinobho "Yongeza". Ukongezelela, unokujonga ibhokisi "Yenza imiqulu ngaphandle kwemingcele engekho engagwenxa". Ndingayifumana phi le nketho kwiinguqu ezidala zenkqubo?

Ukuba usebenzisa i-Excel 2007 okanye kamva, itholakala ngokuchofoza inkinobho ethi "Okukhethwa kukho", inomxholo othi "Solution search options".

Sifuna isiphumo esilungileyo

Ukufuna isisombululo esilungileyo, kufuneka ucofe kwiqhosha elithi "Run" okanye "Fumana isisombululo"). Emva koko, "Isiphumo socando lweSombululo" ibhokisi yencoko yababini ibonakala phambi kwakho.

Ukuba unelisekile ngempendulo yokugqibela, ngoko kufuneka ucofe kwiqhosha elithi "Kulungile". Emva koko, impendulo oyithandayo iya kugqitywa etafileni. Kwimeko apho ixabiso elithe lafunyanwa ngandlela-thile ngeendlela ezikhethiweyo, kufuneka ucofe kwiqhosha "Khansela". Emva koko itafile iya kubuyela ngokukhawuleza kwixabiso langaphambili, emva koko uza kuqhubeka ukukhangela isisombululo esiphezulu.

Kubalulekile! Ukuba ubuncinane ngandlela-thile utshintshe idatha yasekuqaleni, ke esi sixazululo kuya kufuneka senziwe kuqala.

Kuphi enye into engayifaka ngayo "ukukhangela izisombululo" umsebenzi we-Excel? Makhe sibone omnye umzekelo.

Ukunciphisa iindleko

Njengoko sithethe ngasentla, lo msebenzi ungasetyenziselwa ukwandisa iinkqubo zokuvelisa. Zama ukunciphisa iindleko zenkampani, ejongene nokwakhiwa okuphantsi. Kukho inkampani, kunye nabathengisi abathathu, ababandakanyeka ekunikezeni izinto zokwakha.

Ngokuqinisekileyo, ukuba kwixabiso lezinto ezikhutshweyo zonke iindleko zokumiswa kwazo ziya kuhlawulwa, kwaye ngoko ke kunomdla wequmrhu lokukhetha umthengi lowo umsebenzi wakhe ungabizi. Yiyiphi idatha efunekayo ukuba ifakwe "kwisisombululo sokusesha" i-MS Excel?

Kubalulekile ukubonisa iindleko zokwakha izinto, iimfuno zazo kwisakhiwo sokwakhiwa, kunye neendleko zokuthutha izinto, ngokuqwalasela nganye ibini "Umthengi-Umthengi". Kwisitayile ekujoliswe kuyo, isamba seendleko zokuthutha ezipheleleyo kufuneka siboniswe.

Ukuba wenza konke ngokuchanekileyo, "isisombululo sokusesha" esisebenza kwi-Excel siza kukuvumela ukuba wenze isicwangciso esona sincomekayo soshishino lokwakha, esiza kukuzisa imali engenayo. Inhlanhla!