Mukamawerengera, pamafunika kuti mupeze kuchuluka kwa ntchitozo. Kuwerengera kwamtunduwu nthawi zambiri kumachitika ndi owerengera ndalama, mainjiniya, okonza mapulani, ndi ophunzira m'masukulu ophunzitsa. Mwachitsanzo, njira yowerengera iyi ikufunikira chidziwitso pa kuchuluka kwa malipiro a masiku omwe agwiridwa ntchito. Kukhazikitsidwa kwa ntchitoyi kungafunikire ku mafakitale ena, ngakhale pazofunikira zapakhomo. Tiyeni tiwone momwe mu Excel mungawerengere kuchuluka kwa ntchito.
Kuwerengera kuchuluka kwa ntchito
Kuchokera ku dzina lachitidwe chomwecho, zikuwonekeratu kuti kuchuluka kwazinthu ndizophatikiza pazotsatira kuchulukitsa manambala. Ku Excel, izi zitha kuchitidwa pogwiritsa ntchito njira yosavuta masamu kapena kugwiritsa ntchito ntchito yapadera SUMPRONT. Tiyeni tiwone mwatsatanetsatane njira izi aliyense payekhapayekha.
Njira 1: gwiritsani ntchito mtundu wa masamu
Ogwiritsa ntchito ambiri amadziwa kuti ku Excel mutha kuchita zingapo zazikulu zamasamu pokhazikitsa chizindikiro "=" m'chipinda chopanda kanthu, ndikulemba mawuwo molingana ndi malamulo a masamu. Njira iyi itha kugwiritsidwanso ntchito kuti mupeze kuchuluka kwa ntchitozo. Pulogalamuyi, malinga ndi malamulo a masamu, imawerengera zomwe zachitika, kenako zimangowonjezera zonsezo.
- Khazikitsani chizindikiro chofanana (=) mu cell momwe zotsatira za kuwerengera zidzawonetsedwa. Tikulemba chiwonetsero cha kuchuluka kwa ntchitozo malinga ndi template yotsatirayi:
= a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...Mwachitsanzo, mwanjira iyi mutha kuwerengera mawu akuti:
=54*45+15*265+47*12+69*78 - Kuti muwerengere ndikuwonetsa zotsatira zake pazenera, dinani batani la Enter pa kiyibodi.
Njira 2: gwiritsani ntchito maulalo
M'malo mwa manambala amtunduwu, muthanso kulumikizana ndi ma cell omwe amapezeka. Maulalo akhoza kuikidwa pamanja, koma ndizosavuta kuchita izi powunikira chikwangwani "=", "+" kapena "*" khungu lolingana lomwe lili ndi nambala.
- Chifukwa chake, timalemba nthawi yomweyo mawuwo, pomwe m'malo mwa manambala, zolembedwa zam'masamba zimasonyezedwa.
- Kenako, kuti muwerenge, dinani batani Lowani. Zotsatira za kuwerengera zikuwonetsedwa.
Zowona, mtundu uwu wowerengeka ndiwosavuta komanso wachilengedwe, koma ngati pali zofunikira zambiri patebulopo zomwe zimafunikira kuchulukitsidwa ndikuwonjezeredwa, njira iyi imatha kutenga nthawi yambiri.
Phunziro: Kugwira ntchito ndi mafomu ku Excel
Njira 3: kugwiritsa ntchito SUMPRODUCT
Kuti muwerenge kuchuluka kwa ntchitoyo, ogwiritsa ntchito ena amakonda ntchito yomwe idapangidwa kuti ichitike - SUMPRONT.
Dzinali la wothandizira limalankhula za cholinga chake chokha. Ubwino wa njirayi pamtundu wapitayo ndikuti ungagwiritsidwe ntchito kukonza magulu onse nthawi imodzi, osachita zinthu ndi nambala iliyonse kapena khungu mosiyana.
Kapangidwe ka ntchitoyi ndi motere:
= SUMPRuction (arr11; arr22; ...)
Zotsutsana za wothandizirazi ndi malo amtundu wa data. Komanso, amapangidwa m'magulu a zinthu. Ndiye kuti, ngati mumanga pa template yomwe takambirana pamwambapa (a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...), ndiye kuti zoyambirira ndizomwe zimayambitsa gulu a, lachiwiri - magulu b, lachitatu - magulu c etc. Magawo awa ayenera kukhala ofanana komanso ofanana kutalika. Zitha kupezeka mokhazikika komanso molimba. Ponseponse, wogwiritsa ntchitoyu amatha kugwira ntchito ndi chiwerengero chotsutsana kuyambira 2 mpaka 255.
Formula SUMPRONT Mutha kulembera ku foni kuti muwonetse zotsatira zake, koma kwa owerenga ambiri ndizosavuta komanso kosavuta kuwerengera kudzera pa Ntchito Wizard.
- Sankhani khungu pa pepala momwe zotsatira zomaliza ziziwonetsedwa. Dinani batani "Ikani ntchito". Yapangidwa ngati chithunzi ndipo ili kumanzere kwa munda wamtundu wa formula.
- Wogwiritsa ntchito akachita izi, zimayamba Fotokozerani Wizard. Imatsegula mndandanda wa onse, kupatula ochepa, ogwiritsa ntchito omwe mungagwire nawo ku Excel. Kuti mupeze ntchito yomwe tikufuna, pitani pagawo "Masamu" kapena "Mndandanda wathunthu wa zilembo". Atapeza dzinalo SUMMPROIZV, sankhani ndikudina batani "Zabwino".
- Tsamba la mkangano wa ntchito likuyamba SUMPRONT. Mwa kuchuluka kwa zotsutsana, itha kukhala ndi magawo 2 mpaka 255. Ma adilesi amtunda amatha kuyendetsedwa pamanja. Koma zimatenga nthawi yambiri. Mutha kuzichita mosiyanako. Timayika cholozera m'munda woyamba ndikusankha ndi batani lakumanzere ndikumakanikiza mndandanda woyamba wa pepala. Momwemonso timachita ndi wachiwiri komanso magulu onse otsatirawo, ogwirizanitsa omwe amawonetsedwa nthawi yomweyo mu gawo lolingana. Pambuyo polemba data yonse, dinani batani "Zabwino" pansi pazenera.
- Pambuyo pazinthu izi, pulogalamuyo imadziyimira payokha pawowerengera momwe ikufunikira ndikuwonetsa zotsatira zomaliza mu cell yomwe idatsimikiziridwa mu gawo loyambirira la malangizowa.
Phunziro: Ntchito Wizard ku Excel
Njira 4: kugwiritsa ntchito ntchito
Ntchito SUMPRONT zabwino ndi chakuti zitha kugwiritsidwa ntchito pokhapokha. Tiyeni tiwone momwe izi zimachitikira ndi chitsanzo chapadera.
Tili ndi tebulo la malipiro ndi masiku ogwiridwa ndi ogwila ntchito kwa miyezi itatu mwezi uliwonse. Tiyenera kudziwa ndalama zomwe wogwira ntchito Parfenov D.F. adapeza panthawiyi.
- Momwemonso monga nthawi yapita, timatcha zenera la mkangano SUMPRONT. M'magawo awiri oyambawa, tikuwonetsa madera omwe kuchuluka kwa anthu ogwira ntchito ndi kuchuluka kwa masiku omwe amagwiritsidwa ntchito ndi iwo kukuwonetsedweratu. Ndiye kuti, timachita chilichonse, monga momwe zinalili kale. Koma mu gawo lachitatu timayika zothandizira pazogwiritsira ntchito, zomwe zimakhala ndi mayina ogwira nawo ntchito. Pambuyo pa adilesi timangowonjezera:
= "Parfenov D.F."Pambuyo polemba data yonse, dinani batani "Zabwino".
- Kugwiritsa ntchito kumawerengera. Mizere yokha yomwe dzinali limapezekanso limawaganiziridwa "Parfenov D.F.", ndizomwe timafunikira. Zotsatira za kuwerengera zikuwonetsedwa mu foni yosankhidwa kale. Koma zotsatira zake ndi zero. Izi ndichifukwa choti formula, momwe ilili tsopano, sigwira ntchito molondola. Tiyenera kusintha pang'ono.
- Kuti musinthe fomula, sankhani foni ndi mtengo womaliza. Chitani zochita mu kapamwamba kanyumba. Timatenga kutsutsana ndi zomwe zili m'mabakaka, ndipo pakati pake ndi zotsutsa zina timasintha semicolon kukhala chizindikiro chochulukitsa (*). Dinani batani Lowani. Pulogalamuyi imawerengeredwa ndipo nthawi ino imapereka mtengo wolondola. Tinalandila malipiro athunthu kwa miyezi itatu, zomwe zimachitika chifukwa cha wogwira ntchito m'bizinesi D.F. Parfenov
Momwemonso, mutha kugwiritsa ntchito mikhalidwe osati pazolembazo zokha, komanso manambala okhala ndi madeti powonjezera zilembo "<", ">", "=", "".
Monga mukuwonera, pali njira ziwiri zazikulu zowerengera kuchuluka kwa ntchitozo. Ngati palibe zambiri zochuluka, ndiye kosavuta kugwiritsa ntchito njira yosavuta yowerengera. Chiwerengero chambiri chikamawerengedwa, wogwiritsa ntchitoyo amasunga nthawi yake yayitali komanso khama ngati atagwiritsa ntchito luso la ntchito yapadera SUMPRONT. Kuphatikiza apo, pogwiritsa ntchito momwemonso, mutha kuwerengera pokhapokha ngati formula wamba singachite.
