Chinthu chofunikira kwambiri mu Microsoft Excel ndi Kusankhidwa kwa Paramu. Koma, siwogwiritsa ntchito aliyense amadziwa za kuthekera kwa chida ichi. Ndi chithandizo chake, ndizotheka kusankha mtengo woyambira, kuyambira pazotsatira zomaliza zomwe zimayenera kukwaniritsidwa. Tiyeni tiwone momwe mungagwiritsire ntchito ntchito yofananira ndi Microsoft mu Microsoft Excel.
Chinsinsi cha ntchitoyo
Ngati ndizosavuta kuyankhula za tanthauzo la ntchito Parula Selection, ndiye kuti zili mu chochitika chakuti wosuta amatha kuwerengetsa zofunikira zoyamba kuti akwaniritse zotsatira zake. Izi ndizofanana ndi chida cha Solution Finder, koma ndichosavuta. Itha kugwiritsidwa ntchito pokhapokha ngati mukuwerenga mu foni iliyonse, muyenera kuyendetsanso chida ichi nthawi iliyonse. Kuphatikiza apo, ntchito yosankhidwa ndi parateni imatha kugwira ntchito limodzi ndikuyika limodzi ndi phindu limodzi, lomwe limayankhula ngati chida choperewera.
Kuyika ntchitoyo
Kuti mumvetsetse momwe ntchitoyi imagwirira ntchito, ndibwino kufotokoza tanthauzo lake ndi chitsanzo chogwira ntchito. Tidzafotokozera momwe chida chikugwiritsira ntchito chitsanzo cha Microsoft Excel 2010, koma mawonekedwe a algorithm ali ofanana pafupifupi mumabuku ena a pulogalamuyi komanso mu 2007.
Tili ndi tebulo la malipiro ndi malipiro a bonasi kwa ogwira ntchito. Ma bonasi antchito okha ndi omwe amadziwika. Mwachitsanzo, premium ya m'modzi mwa iwo - Nikolaev A. D, ndi 6035.68 rubles. Zimadziwikanso kuti premium imawerengeredwa pochulukitsa malipiro chifukwa cha 0.28. Tiyenera kupeza malipiro a ogwira ntchito.
Kuti muyambitse ntchitoyi, kukhala mu "Data" tabu, dinani batani la "What if", lomwe lili "chida cha" Working with Data "pa riboni. Menyu mumapezeka momwe muyenera kusankha" kusankha "... .
Pambuyo pake, zenera losankha paramu limatseguka. Mu gawo la "Ikani mu khungu", muyenera kufotokoza adilesi yake yomwe ili ndi chidziwitso chomaliza chomwe tidadziwe, chomwe tiziwerengera. Potere, iyi ndi foni pomwe mphotho ya antchito ya Nikolaev imayikidwa. Adilesiyi ikhoza kufotokozedwa pamanja poyendetsa magwirizano ake m'munda wolingana. Ngati mukulephera kuchita izi, kapena ngati zikukusowetsani, ingodinani pafoni yomwe mukufuna ndipo adilesiyo idzalowetsedwa kumunda.
Mu gawo "Mtengo" muyenera kutchulapo mtengo wake umafunika. M'malo mwathu, padzakhala 6035.68. Pamugawo "Kusintha kwa zofunikira za khungu" timalowa adilesi yake yomwe ili ndi zomwe zikupezeka zomwe tikufunika kuwerengera, ndiye kuchuluka kwa malipiro a wogwira ntchito. Izi zitha kuchitika munjira zomwe tinakambirana pamwambapa: kuyendetsa magawo pamanja, kapena dinani pafoni yofanana.
Pamene deta yonse ya zenera yadzaza, dinani batani "Chabwino".
Pambuyo pake, kuwerengera kumachitika, ndipo zomwe zasankhidwa zimakwanira m'maselo, monga momwe zenera lapadera lazidziwitso limachitikira.
Kuchita kofananako kukhoza kuchitika pamizere ina ya tebulo, ngati phindu la bonasi ya otsalira a bizinesi ikudziwika.
Njira yothetsera
Kuphatikiza apo, ngakhale siyiri mawonekedwe a ntchito iyi, itha kugwiritsidwa ntchito kuthetsa ma equation. Zowona, chida chosankha paramu chitha kugwiritsidwa ntchito bwino pokhudzana ndi ma equation ndi osadziwika.
Tiyerekeze kuti tili ndi equation: 15x + 18x = 46. Tikulemba mbali yake yakumanzere, ngati formula, mu imodzi mwa maselo. Monga fomula iliyonse mu Excel, timayika chikwangwani = kutsogolo kwa equation. Koma, nthawi yomweyo, m'malo mwa chizindikiro x timayika adilesi ya foni komwe zotsatira za kufunika zikuwonetsedwa.
M'malo mwathu, timalemba formula mu C2, ndipo kufunika komwe kukuwonetsedwa mu B2. Chifukwa chake, kulowa mu cell C2 kudzakhala ndi mawonekedwe awa: "= 15 * B2 + 18 * B2".
Timayamba ntchitoyi monga momwe tafotokozera pamwambapa, ndiye kuti, mwa kuwonekera pa batani la "Analysis", bwanji ngati "pa tepi", komanso ndikudina "Kusankha Kwa Paramende ...".
Pazenera kusankha gawo lomwe limatsegulira, mu gawo la "Set in cell", tchulani adilesi yomwe tidalemba equation (C2). M'munda "Mtengo" timalowa nambala 45, popeza timakumbukira kuti equation imawoneka motere: 15x + 18x = 46. M'munda "Kusintha kwa maselo" tikuwonetsa adilesi yomwe phindu x liziwonetsedwa, ndiye kuti, yankho la equation (B2). Titalowetsa izi, dinani batani "Chabwino".
Monga mukuwonera, Microsoft Excel yathetsa mayesowo bwino. Mtengo wa x udzakhala 1.39 munyengo.
Titaunika chida cha kusankha cha Parameter, tapeza kuti izi ndizosavuta, koma nthawi yomweyo zimakhala zothandiza komanso zosavuta kupeza nambala yosadziwika. Itha kugwiritsidwa ntchito pa kuwerengera kwa ma tabular, komanso kuthana ndi mayeso ndi chimodzi chosadziwika. Nthawi yomweyo, pamalingaliro a magwiridwe antchito, amachepetsedwa ndi chida champhamvu chofufuzira.
