Isici esiwusizo kakhulu ku-Microsoft Excel Program ukukhethwa kwepharamitha. Kepha, akuwona wonke umsebenzisi owaziyo ngamakhono aleli thuluzi. Ngalo, ungakhetha inani lokuqala, uqhamuke kumphumela wokugcina odinga ukuwufinyelela. Ake sibheke ukuthi singayisebenzisa kanjani isici sokukhethwa kwepharamitha ku-Microsoft Excel.
Umqondo womsebenzi
Uma kwenziwa lula ukukhuluma ngomongo wokukhethwa komsebenzi wepharamitha, khona-ke kutholakala eqinisweni lokuthi umsebenzisi angabala idatha yomthombo edingekayo ukuze afeze umphumela othile. Lesi sici sifana nethuluzi lezinqumo, kepha liyindlela elula kakhudlwana. Ingasetshenziswa kuphela kumafomula owodwa, okungukuthi, ukubala esitokisini ngasinye udinga ukusebenzisa ngaso sonke isikhathi leli thuluzi. Ngaphezu kwalokho, umsebenzi wokukhethwa kwepharamitha ungasebenza kuphela kwisingeniso esisodwa, futhi enye yezincazelo ezifiselekayo, ezikubonisa, njengethuluzi elinokusebenza okulinganiselwe.Umsebenzi wohlelo lokusebenza ekusebenzeni
Ukuze uqonde ukuthi lesi sici sisebenza kanjani, kungcono ukuchaza umongo waso esibonelweni esisebenzayo. Sizochaza umsebenzi wethuluzi esibonelweni sohlelo lweMicrosoft Excel 2010, kepha isenzo se-algorithm sifana ngezinguqulo zakamuva zalolu hlelo, kwathi ngonyaka we-2007.
SineThebula Lokukhokhelwa Kwakhokhwa Kwabakhokhela kanye nabasebenzi bebhizinisi. Kunemiklomelo kuphela yabasebenzi. Isibonelo, ibhonasi yenye yazo - uNikolaev A. D, ama-ruble angama-6035.68. Futhi, kuyaziwa ukuthi i-premium ibalwa ngokuphindaphinda umholo ku-coefficied e-0.28. Kufanele sithole iholo labasebenzi.
Ukuze uqale umsebenzi ngenkathi kuthebhu "yedatha", chofoza ekuhlaziyweni kwe- "Ukuhlaziya" uma "", okutholakala ku- "Ukusebenza nge-Table Block Block ethepheni. Imenyu ivela lapho ufuna ukukhetha khona "Ukukhetha kwepharamitha ...".
Ngemuva kwalokho, iwindi lokukhetha ipharamitha liyavula. In the "Faka Esendaweni ye-Cell", udinga ukucacisa ikheli layo eliqukethe idatha yokuphela eyaziwa yithi, esizokwenza ngokwezifiso ukubalwa. Kulokhu, lesi yiseli lapho kufakwa khona umsebenzi wesisebenzi sikaNikolaev. Ikheli lingacaciswa ngesandla ngokulonga izixhumanisi zalo kwinsimu ehambisanayo. Uma ukuthola kunzima ukukwenza, noma ukukubheka njengento ephathekayo, bese uchofoza nje kwiseli oyifunayo, futhi ikheli lizofakwa enkundleni.
Inkambu "yenani" idinga ukucacisa inani elithile lomklomelo. Kuthu, kuzoba ngu-6035.68. Ensimini ethi "Ukuguqula Amanani Wezingcingo", ufaka ikheli layo eliqukethe idatha yomthombo esidinga ukubala, okungukuthi, inani lemiholo yabasebenzi. Lokhu kungenziwa ngezindlela ezifanayo esaxoxa ngazo ngenhla: ukushayela izixhumanisi ngesandla, noma chofoza kusethi efanele.
Lapho yonke idatha yewindows yepharamitha igcwalisiwe, chofoza inkinobho ethi OK.
Ngemuva kwalokho, ukubalwa kwenziwa, futhi amanani akhethiwe angena kumaseli, njengoba kubikwe yiwindi lolwazi elikhethekile.
Ukuhlinzwa okunjalo kungenziwa eminye imigqa yetafula, uma inani le-premium yebhizinisi laziwa.
Ukuxazulula izilinganiso
Ngaphezu kwalokho, yize lesi akusona isici sephrofayili salo msebenzi, singasetshenziswa ukuxazulula izibalo. Kuliqiniso, ithuluzi lokukhetha ipharamitha lingasetshenziswa ngempumelelo kuphela maqondana ne-zibalo nelingaziwa.
Ake sithi sine-equation: 15x + 18x = 46. Qopha ingxenye yaso yangakwesobunxele, njengefomula, kwelinye lamaseli. Ngokuqondene noma iyiphi ifomula ku-Efpelle, ngaphambi kwe-equation, sibeka uphawu lokuthi "=". Kepha, ngasikhathi sinye, esikhundleni sesibonakaliso x, usetha ikheli leseli lapho kuzokhonjiswa khona inani lenani elifunekayo.
Kuthu, sibhala ifomula ku-C2, futhi inani elifunekayo lizokhonjiswa ku-B2. Ngakho-ke, irekhodi eliku-C2 cell lizoba nefomu elilandelayo: "= 15 * B2 + 18 * B2".
Siqala umsebenzi ngendlela efanayo njengoba kuchaziwe ngenhla, okungukuthi, ngokuchofoza ku- "Ukuhlaziywa" ukuthi uma "" "ethepheni," bese eshintsha "ipharamitha ...".
Ewindini lokukhetha ipharamitha elivula, ku- "Faka enkundleni yeseli", chaza ikheli esiqopha ngalo i-equation (C2). In the "Value" field, faka inombolo 45, ngoba siyakhumbula ukuthi i-equation imi kanjena: 15x + 18x = 46. Ensimini "eguqukayo yeselula", sicacisa ikheli lapho kuboniswa inani le-X, okungukuthi, empeleni, ikhambi le-equation (B2). Ngemuva kokuthi singene kule mininingwane, cindezela inkinobho ethi "Kulungile".
Njengoba ukwazi ukubona, iMicrosoft Excel ixazulule ngempumelelo i-equation. Inani le-X lizoba ngu-1.39 esikhathini.
Ngemuva kokuhlola ithuluzi lokukhetha ipharamitha, sathola ukuthi kulula kakhulu, kepha ngasikhathi sinye esisebenzayo nesilula sokuthola inombolo engaziwa. Ingasetshenziswa zombili nge-table computing futhi ukuxazulula izibalo nge-One engaziwa. Ngasikhathi sinye, ngokuya ngokusebenza, kuphansi kwethuluzi lezixazululo ezinamandla ngokwengeziwe.