Chothandiza kwambiri mu pulogalamu ya Microsoft Excorva ndikusankhidwa kwa paramu. Koma, si wogwiritsa aliyense amene amadziwa za kuthekera kwa chida ichi. Ndi izi, mutha kusankha mtengo woyamba, kutuluka kuchokera kotsiriza komaliza komwe muyenera kukwaniritsa. Tiyeni tipeze momwe mungagwiritsire ntchito gawo lomwe mungalembetsere microsoft Excel.
Choyambitsa cha ntchito
Ngati kugwiritsidwa ntchito mopepuka kuyankhula za kusankha kwa gawo la gawo, ndiye kuti limagona chifukwa wogwiritsa ntchitoyo amatha kuwerengera zomwe zimafunikira kuti mukwaniritse zotsatira zake. Izi zikufanana ndi chida chotsimikizira chida, koma ndi chosavuta kwambiri. Itha kugwiritsidwa ntchito mu mitundu imodzi yokha, ndiye kuti, kuwerengera mu khungu lililonse muyenera kuthamanga nthawi iliyonse Chida ichi. Kuphatikiza apo, ntchito yosankhidwa imatha kugwiriridwa pa mawu amodzi okha, ndipo imodzi mwazofunikira, zomwe zikuwonetsa, monga chida chokhala ndi magwiridwe antchito.Ntchito ntchito
Kuti mumvetsetse momwe mbali iyi imagwira, ndibwino kufotokoza chitsanzo chake pa zitsanzo zothandiza. Tidzafotokozera ntchito ya chida pa zitsanzo za Microsoft Excel 2010, koma zomwe algorithm ndizofanana ndi mitundu iyi ya pulogalamuyi, ndipo mu 2007.
Tili ndi tebulo lolipira ndi antchito. Pali zongopereka mphotho chabe. Mwachitsanzo, bhonasi ya m'modzi wa iwo - Nikolaev A. D, ndi 6035.68 Rubles. Komanso, zimadziwika kuti mtengo umawerengeredwa ndikuchulukitsa malipiro pa 0,28. Tiyenera kupeza malipiro antchito antchito.
Kuti muyambe ntchitoyo mukakhala "data", dinani pa "kusanthula" ngati " Menyu akuwoneka kuti mukufuna kusankha "kusankhidwa kwa parameter ...".
Pambuyo pake, zenera kusankha parameter chitseguka. Mu "kukhazikitsa mu chipinda cha cell", muyenera kutchulapo adilesi yake yomwe ili ndi deta yomaliza yomwe tidzadziwike, zomwe tisinthasintha kuwerengera. Pankhaniyi, iyi ndi khungu komwe wogwira ntchito wa Nikolaev adayikidwa. Adilesiyi ikhoza kufotokozedwa pamanja posunga magwiridwe ake ku gawo lolingana. Ngati zikukuvutani kuchita, kapena kuona kuti ndizosavuta, kenako dinani khungu lomwe lingafune, ndipo adilesiyo idzalowetsedwa m'munda.
Munda wa "mtengo" umafuna kunena kufunika kwa mphotho. M'malo mwathu, lidzakhala 6035.68. Mu "njira yosinthira maselo", mumalowa adilesi yake yomwe ili ndi gwero lomwe tikufunika kuwerengetsa, ndiye kuti, kuchuluka kwa malipiro a antchito. Izi zitha kupangidwira njira zomwe timalankhulira pamwambapa: kuyendetsa magwiridwe antchito pamanja, kapena dinani pafoni yoyenera.
Zomwe zidalitse zenera zonse zadzaza, dinani batani la OK.
Pambuyo pake, kuwerengera komwe kumapangidwa, ndipo malingaliro osankhidwa amakwanira maselo, monganso zenera lapadera.
Ntchito yotereyi imatha kuchitidwa m'mizere ina ya tebulo, ngati mtengo wa mtengo wabizinesi wina wonse umadziwika.
Kuthera Kukhazikika
Kuphatikiza apo, ngakhale izi siziri gawo la ntchitoyi, lingagwiritsidwe ntchito kuthana ndi malingaliro. Zowona, chida chosankha cha parameter chitha kugwiritsidwa ntchito bwino poyerekeza ndi equation ndi imodzi yosadziwika.
Tiyerekeze kuti tili ndi equation: 15x + 18x = 46. Lembani mbali yakumanzere, ngati njira, mu imodzi mwa maselo. Ponena za njira iliyonse yowonjezera, isanachitike equation, timayika chikwangwani "=". Koma, nthawi yomweyo, m'malo mwa chikwangwani X, mumayika adilesi ya khungu pomwe zotsatira za mtengo womwe mukufuna zidzawonetsedwa.
M'malo mwathu, timalemba fomu mu C2, ndipo mtengo womwe mukufuna udzawonetsedwa mu B2. Chifukwa chake, mbiriyo mu cell cell imakhala ndi mawonekedwe otsatirawa: "= 15 * B2 + 18 * B2".
Timayamba ntchitoyo mofananamo monga tafotokozera pamwambapa, ndiye kuti, podina pa "kusanthula" kuti ngati "" pa tepi ... ".
Pazenera losankhidwa lomwe limatseguka, mu "gawo la" gawo la Cell ", fotokozerani adilesi yomwe tidalemba equation (C2). M'munda wa "Mtengo Wanu", ulowenso nambala ya 45, popeza tikukumbukira kuti kuchuluka kwake ndi motere: 15x + 18x = 4x = 4x = 46. Mu "gawo losintha la maselo, timatchulanso adilesi yomwe x yamtengo wapatali ikuwonetsedwa, ndiye kuti, yankho la equation (B2). Titalowa mu data iyi, kanikizani batani la "OK".
Monga mukuwonera, Microsoft Excel idathetsa bwino equation. Mtengo wa X udzakhala 1.39 mu nthawi.
Pambuyo pofufuza chida chosankha cham'munsi, tidazindikira kuti sizachilendo, koma nthawi yomweyo ndizothandiza komanso chothandiza pakupeza nambala yosadziwika. Itha kugwiritsidwa ntchito panjira yonse ya tebulo ndikuthetsa equation ndi imodzi yosadziwika. Nthawi yomweyo, malinga ndi magwiridwewo, ndife otsika mtengo wamphamvu kwambiri.