Chinthu chofunika kwambiri mu Microsoft Excel ndi kusankha kosankhidwa. Koma, osati wosuta aliyense amadziwa za kuthekera kwa chida ichi. Ndicho, mutha kutenga mtengo wapachiyambi, kuyambira pa zotsatira zomaliza zomwe mukufuna kuzikwaniritsa. Tiyeni tione momwe mungagwiritsire ntchito ntchito yosankha pa Microsoft Excel.
Chofunika cha ntchitoyo
Ngati kuli kovuta kulankhula za momwe ntchitoyi ikuyendera, ndiye kuti wogwiritsa ntchitoyo angathe kuwerengera zotsatira zofunikira kuti athe kupeza zotsatira zake. Chizindikiro ichi chikufanana ndi chida cha Solution Finder, koma ndi njira yophweka. Ikhoza kugwiritsidwa ntchito mwa njira imodzi yokha, ndiko kuti, kuwerengera selo iliyonse, muyenera kuyendetsa chida ichi kachiwiri. Kuphatikiza apo, chisankho chokhazikitsa ntchito chingagwire ntchito ndi phindu limodzi lokha, ndi lofunika kwambiri, lomwe limatanthawuza ngati chida chopanda ntchito.
Kugwiritsa ntchito ntchitoyi pakuchita
Kuti mumvetse momwe ntchitoyi ikugwirira ntchito, ndi bwino kufotokozera zomwe zili ndichitsanzo chabwino. Tidzafotokozera ntchito ya chida ichi pa chitsanzo cha Microsoft Excel 2010, koma ndondomeko ya zochitikazo ziri zofanana panthawi ya pulojekitiyi komanso mu 2007.
Tili ndi tebulo la malipiro a malipiro ndi mabhonasi kwa ogwira ntchito. Ma bonasi okha ogwira ntchito amadziwika. Mwachitsanzo, mphoto ya mmodzi wa iwo, Nikolaev A. D, ndi rubanda 6,035.68. Komanso, zimadziwika kuti kuonjezera kumawerengedwa ndi kuchulukitsa malipiro ndi chinthu cha 0.28. Tiyenera kupeza malipiro a antchito.
Kuti muyambe ntchitoyo, pokhala pa tabu ya "Deta", dinani pa "Sakanizani" ngati "batani, yomwe ili mu barabu yothandizira ndi" Data "pajamboni. Menyu ikuwonekera momwe muyenera kusankha" Kusankhidwa kwa Parameter ... " .
Pambuyo pake, mawindo osankhidwa osankhidwa amayamba. Kumunda "Kuikidwa mu selo" muyenera kufotokozera adiresi yake, yomwe ili ndi deta yomaliza yomwe tikuidziwa, yomwe tidzasintha mawerengedwewo. Pachifukwa ichi, ndilo selo komwe mphoto ya wogwira ntchito ya Nikolaev imakhazikitsidwa. Adilesi ikhoza kufotokozedwa mwa kulemba makonzedwe ake mu malo oyenera. Ngati mukuvutika kuti muchite izi, kapena mukuganiza kuti ndizosokoneza, ndiye kuti pangoyani selo lofunidwa, ndipo adilesiyi idzayendetsedwa kumunda.
M'munda "Mtengo" ukufunika kuti uwonetsetse phindu lenileni la mphoto. Kwa ife, zidzakhala 6035.68. Mu "Masinthidwe a maselo", lowetsani adiresi yake yomwe ili ndi deta yoyamba yomwe tifunikira kuwerengetsera, ndiko kuti, kuchuluka kwa malipiro a antchito. Izi zikhoza kuchitidwa mofanana ndi zomwe tinakambirana pamwambapa: lowetsani makonzedwe, kapena dinani pa selo lofanana.
Pamene deta yonse muzenera yadzaza, dinani "Bwino".
Pambuyo pake, mawerengedwe amapangidwira, ndipo miyezo yofanana ikuyenerera m'maselo, omwe amafotokozedwa ndiwindo lapadera ladzidzidzi.
Ntchito yofananako ingakhoze kuchitidwa pa mizere ina ya tebulo, ngati mtengo wa phindu la otsala ogwira ntchito a kampaniyo amadziwika.
Kuthetsa kusinthanitsa
Kuonjezera apo, ngakhale sichifukwa chachikulu cha ntchitoyi, ikhoza kugwiritsidwa ntchito kuthetsa ziyanjano. Komabe, chida chosankhira chokhacho chingagwiritsidwe ntchito moyenera pokha pa kulemekeza kwa equations ndi osadziwika.
Tiyerekeze kuti tili ndi equation: 15x + 18x = 46. Lembani mbali ya kumanzere, ngati njira, mu imodzi mwa maselo. Pemphani njira iliyonse mu Excel, isanayambe kuyika chizindikiro "=". Koma, panthawi imodzimodzi, m'malo mwa chizindikiro cha x, timayika adilesi ya selo komwe zotsatira za mtengo wofunikila zidzaperekedwa.
Kwa ife, tikulemba njirayi mu C2, ndipo mtengo wofunidwa udzawonetsedwa mu B2. Motero, kulowa mu selo C2 kudzakhala ndi mawonekedwe awa: "= 15 * B2 + 18 * B2".
Timayambitsa ntchitoyo monga momwe tafotokozera pamwambapa, kutanthawuza pa batani "Analysis", bwanji ngati "pa tepi", ndikudumpha pa chinthucho "Kusankha kwa parameter ...".
Muzenera zosankha zomwe zimatsegulidwa, kumunda "Kuikidwa mu selo" timasonyeza adiresi yomwe tilembera equation (C2). Kumunda "Mtengo" timalowa nambala 45, popeza tikukumbukira kuti equation ikuwoneka ngati iyi: 15x + 18x = 46. Mu "Masinthidwe a maselo", timasonyeza adiresi yomwe mtengo wa x udzatulutsidwa, ndiko kuti, yankho la equation (B2). Titatha kulowa deta iyi, dinani pakani "OK".
Monga momwe mukuonera, Microsoft Excel anathetsa bwinobwino yankho. Mtengo wa x udzafanana ndi 1.39 mu nthawi.
Pambuyo pofufuza chida chosankhira, tazindikira kuti izi ndi zophweka, koma panthawi yomweyi ndi ntchito yothandiza ndi yabwino kupeza nambala yosadziwika. Ikhoza kugwiritsidwa ntchito palimodzi kuwerengetsera malemba, ndi kuthetsa kulinganirana ndi chosadziwika. Pa nthawi yomweyi, pazinthu zogwirira ntchito, ndizowona kuti ndizochepa kwambiri kufunafuna Chida chothandizira.
