Mukamagwira ntchito ndi deta yamtunduwu, kawirikawiri kumafunika kuwerengera chiwerengero cha nambala, kapena kuwerengera kuchuluka kwa ndalama zonse. Mbali imeneyi imaperekedwa ndi Microsoft Excel. Koma, mwatsoka, sikuti aliyense wogwiritsa ntchito amatha kugwiritsa ntchito zida zogwirira ntchito ndi chidwi pazomwe akugwiritsa ntchito. Tiyeni tipeze momwe tingawerengere kuchuluka kwa Microsoft Excel.
Kuwerengera kwa chiwerengero cha
Choyamba, tiyeni tipeze momwe tingawerengere chiwerengero cha nambala imodzi kuchokera kwa wina. Njira yowonetsera chiwerengero ndi iyi: "= (nambala) / (total_sum) * 100%.
Choncho, kuti tisonyeze mawerengedwewo, tikupeza kuti angati nambalayi ndi 9 kuchokera 17. Poyamba, timakhala mu selo komwe zotsatira zake ziwonetsedwe. Onetsetsani kuti mumvetsetse mtundu womwe uli m'kabuku Kwawo mu gulu la chida. Ngati mtunduwo uli wosiyana ndi chiwerengero, ndiye kuti tifunika kukhazikitsa "Chidwi" pamtunda.
Pambuyo pake, lembani mawu otsatirawa mu selo: "= 9/17 * 100%".
Komabe, popeza taika mtundu wa magawo a selo, kuwonjezera phindu "100%" sikofunikira. Zokwanira kulemba "= 9/17".
Kuti muwone zotsatirazo, dinani pa Enter in batani. Zotsatira zake, timapeza 52.94%.
Tsopano tiyeni tiwone momwe chidwi chingakhoze kuwerengedwera mwa kugwira ntchito ndi deta zamtundu mu maselo. Tiyerekeze kuti tifunikira kuwerengera kuchuluka kwa gawo ndi malonda a malonda a mtundu wina wa mankhwala kuchokera ku ndalama zonse zomwe zafotokozedwa mu selo losiyana. Kuti muchite izi, mogwirizana ndi dzina la mankhwala, dinani pa selo lopanda kanthu, ndipo yikani mapepala amtunduwu. Ikani chizindikiro "=". Kenaka, dinani selo lomwe likusonyeza kufunika kwa kukhazikitsidwa kwa mtundu wina wa mankhwala. Kenaka, ikani chizindikiro "/". Kenaka, dinani selo ndi chiwerengero cha malonda kwa zinthu zonse. Kotero, mu selo kuti tisonyeze zotsatira, ife tiri ndi mawonekedwe.
Kuti muwone kufunika kwa ziwerengero, dinani pa Enter.
Koma, mwa njira iyi, tapeza tanthauzo la gawo la magawo a mzere umodzi wokha. Kodi nkofunikiradi kufotokoza ziwerengero zotero pa mzere wina uliwonse? Osati kwenikweni. Tiyenera kutengera fomu iyi kumaselo ena. Koma, pakadali pano, kutchulidwa kwa selo ndi ndalama zonse ziyenera kukhazikika nthawi zonse kuti pasakhale kusunthika, mwachidule timayika chizindikiro cha "$" kutsogolo kwa mgwirizano wa mzere wake ndi mzere. Pambuyo pake, kutchulidwa kwa selo kuchokera kwa wachibale kumakhala mtheradi.
Kenaka, timakhala mu ngodya ya kumunsi ya selo, momwe mtengo wake wawerengedwera kale, ndipo, mutagwira batani, ponyani pansi mu selo, komwe ndalama zonsezo zikuphatikizidwa. Monga mukuonera, ndondomekoyi imakopedwa ku maselo ena onse. Chotsatira chowonekeratu cha mawerengedwe.
Mukhoza kuwerengera chiwerengero cha zigawo zina za patebulo, ngakhale ndalama zonse siziwonetsedwa mu selo losiyana. Kuti tichite izi, titajambula selo kuti tisonyeze zotsatira muzomwe timapereka, ikani chizindikiro "=" mmenemo. Kenaka, dinani selo yomwe gawo lanu mukufuna kuti mudziwe. Timayika chizindikiro "/", ndiyeno timayendetsa mkati kuchokera ku kiyibodi chiwerengero chonse chimene chiwerengerocho chiwerengedwa. Kuti mutsegule chiyanjano kukhala mtheradi, paichi, sikofunikira.
Ndiye, monga nthawi yotsiriza, timangodutsa pa ENTER batani, ndipo pokoka ife timakopera fomuyi m'maselo omwe ali pansipa.
Kuwerengera kwa chiwerengero cha chidwi
Tsopano ife tikupeza momwe tingawerengere chiwerengero cha chiwerengero cha chiwerengero cha izo. Njira yeniyeni ya kuwerengera idzakhala motere: "%_value% * total_um." Choncho, ngati tifunika kuwerengera nambala 7% ya 70, tangolani mawu akuti "= 7% * 70" mu selo. Popeza, monga chifukwa, timapeza chiwerengero, osati chiwerengero, pazomweku sikofunikira kukhazikitsa chiwerengero cha peresenti. Ziyenera kukhala zowonjezera kapena zamtundu.
Kuti muwone zotsatira, pindikirani ENTER batani.
Njirayi ndi yabwino kugwiritsa ntchito pogwiritsa ntchito matebulo. Mwachitsanzo, tikufunikira kuchokera ku ndalama za chinthu chilichonse kuti tipeze kuchuluka kwa VAT, yomwe ku Russia ndi 18%. Kuti tichite izi, timakhala pa selo yopanda kanthu mumzere ndi dzina la katundu. Selo ili lidzakhala chimodzi mwa zinthu zomwe zimakhalapo mu gawo limene ndalama za VAT zidzasonyezedwe. Sungani selo ili mu mawonekedwe a peresenti. Timaika chizindikiro "=". Timayika pa kambokosi chiwerengero cha 18%, ndikuyika chizindikiro "*". Kenaka, dinani selo yomwe ilipo ndalama zogulitsa katunduyo. Njirayi ndi yokonzeka. Pankhani iyi, musasinthe mawonekedwe a selo kuti mukhalepo, kapena kuti musamalumikize.
Kuti muwone zotsatira za chiwerengero dinani pa ENTER.
Lembani njirayi kwa maselo ena pokoka pansi. Tebulo yomwe ili ndi chiwerengero cha VAT yatha.
Monga mukuonera, Microsoft Excel imapereka mwayi wogwira ntchito moyenera ndi miyezo ya peresenti. Pankhaniyi, wogwiritsa ntchito angathe kuwerengera chiwerengero cha chiwerengero china mwa chiwerengero ndi chiwerengero cha chiwerengero cha chidwi. Excel ikhoza kugwiritsidwa ntchito kugwira ntchito ndi magawo, monga a regular calculator, koma mungagwiritsenso ntchito kugwiritsira ntchito ntchito yowerengera peresenti m'matawuni. Izi zimakuthandizani kuti mupulumutse kwambiri nthawi ya ogwiritsa ntchito pulogalamuyi.
