Kana uchishanda neTabular data, inowanzodikanwa kuti uverenge iyo nhamba yenhamba kana kuverenga chikamu chehuwandu hwehuwandu hwehuwandu hwehuwandu. Iyi ficha inopa Microsoft Excel. Asi zvinosuruvarisa, kwete wega wega mushandisi anoziva mashandisiro aungaita zvishandiso zvekushanda nekufarira muchirongwa ichi. Ngatitsvage nzira yekuverenga sei muzana muExcel.
Excel Inonakidza Kuverenga
Excel inogona kuita akawanda masvomhu mabasa, kusanganisira kuverenga kwakareruka kwekufarira. Mushandisi, zvichienderana nezvinodiwa, hazvizove zvakaoma kuverenga chikamu chehuwandu hwehuwandu uye huwandu hwenzvimbo, kusanganisira mune tabular data sarudzo. Kuti uite izvi, iwe unofanirwa kungotora mukana wevamwe mafomula.Sarudzo 1: muzana yekuverenga yehuwandu
Chekutanga pane zvese, ngatitsvage nzira yekuverenga huwandu hwehuwandu hwekugovana sepesenti yehuwandu hweimwe nhamba kubva kune imwe.
- Fomula yekuverenga iri seinotevera: = (nhamba) / (General_sum) * 100%.
- Kuti tiratidze kuverenga, tinodzidza kuti yakawanda sei nhamba 9 kubva 17. Sarudza iyo Server ichiratidzwa uye uve nechokwadi chekuteerera kune iyo fomati inotsanangurwa pane iyo nzvimbo yebhuta iri mu "nhamba" tab. Kana chimiro chacho chakasiyana kubva muzana, iva nechokwadi chekuisa iyo "muzana" paramende mumunda.
- Mushure meizvozvo, nyora zvinotevera kutaura: = 9/15 * 100%.
- Nekudaro, sezvo isu tikaisa chikamu checerm form fomati, wedzera "* 100%" kuti uwedzere. Zvakaringana kuti tizvitendere pachedu kune rekodhi "= 9/17".
- Kuti uone mhedzisiro, tinya iyo Enter kiyi. Semhedzisiro, tinowana 52.94%.
Zvino tora tarisa nzira yekuverenga nayo kufarira, kushanda neiyo tabular data mumasero.
- Ngatiti isu tinoda kuverenga kuti yakawanda sei muzana muzana yemhando chaiyo yechigadzirwa kubva kune yakazara huwandu hwakatarwa muchitokisi chakasiyana. Kuti uite izvi, mune tambo izita rezvinhu zvinodzvanya pasero risina chinhu uye rongedza chikamu muzana mariri mairi. Isu tinoisa chiratidzo "=". Tevere, tinya pachiteshi, zvichiratidza kukosha kwekushandiswa kwemhando chaiyo yechigadzirwa "/". Zvadaro - nesero ine huwandu hwese hwekutengesa zvinhu zvese. Saka, muchitokisi chekubuda kwemhedzisiro, takanyora formula.
- Kuti utarise kukosha kwekuverenga, tinya Enter.
- Takawana tsananguro yekufarira mune muzana chete mutsara mumwe. Zvakakosha here kuti uunze kuverenga kwakafanana nemutsara wega wega unotevera? Kwete hazvo. Isu tinofanirwa kutevedzera iyi formula kune mamwe masero. Nekudaro, sezvo chinongedzo kuchitokisi chine huwandu hwakazara hunofanirwa kunge hwakagara hwokuti kudzikama hakuitike, ipapo mune formula pamberi penzvimbo yemutsara wayo uye chikamu, tinoisa "$" chiratidzo che $ ". Mushure meizvozvo, kutaura kubva kune hama inoshanduka kuita mhedziso.
- Isu tinotakura iyo kona yekurudyi kurudyi rwechero, kukosha kweiyo yatove yatoverengerwa, uye nekubata bhatani re mbeva, kutambanudzira iyo sero, pane huwandu hwakabatanidzwa. Sezvauri kuona, formula inoteedzerwa kune mamwe masero ese etafura. Pakarepo inooneka mhedzisiro yekuverenga.
- Iwe unogona kuverenga iyo muzana yezvikamu zvega zvetafura, kunyangwe iyo huwandu hwakazara husina kuratidzwa muchitokisi chakasiyana. Mushure mekugadzira sero kuti ubudise mhedzisiro mune muzana fomati, tinoisa iyo "=" chiratidzo mairi. Tevere, tinya pachiteshi, chikamu chake chinofanira kuziva, isa chiratidzo "/" uye uwane huwandu hwacho hwakaverengerwa muzana. Iwe haufanire kushandura chinongedzo kune mhedziso mune ino nyaya.
- Wobva wadzvanya Enter uye nekudhonza nekukoka fomula mumasero, ayo ari pazasi.
Sarudzo yechipiri: Kuverenga kweiyo muzana nhamba
Zvino ngatione kuti ungaverenga sei huwandu hwehuwandu hwakazara muzana kubva pazviri.
- Iyo formula yekuverenga ichave neye inotevera fomu: iyo kukosha_Procantart% * yakazara_sum. Nekuda kweizvozvo, kana tichida kuverenga nhamba yei, semuenzaniso, 7% ye70, tobva ingoisa chirevo "= 7% * 70" muchitokisi. Kubva pakupedzisira tinowana nhamba, kwete muzana, ipapo mune ino kesi hazvidikanwe kuti vaise chimiro muzana. Inofanira kunge iri yakajairika kana nhamba.
- Kuti uone mhedzisiro, tinya Enter.
- Iyi mhando yakanakira kunyorera kushanda nematafura. Semuenzaniso, isu tinoda kubva kune mari yezita rega rega rezvinhu kuti vaunganidze huwandu hweVat kukosha, ndezve 18%. Kuti uite izvi, sarudza sero risina chinhu mumutsetse nezita rezvinhu. Ichava chimwe chezvinhu zvakaumbwa zvekamuri iyo huwandu hweVat zvicharatidzwa. Ini ndinogadzira iyo mune muzana fomati uye isa chiratidzo "=". Isu tinogamuchira iyo nhamba 18% uye iyo "*" chiratidzo pane keyboard. Tevere, tinya pachiteshi umo huwandu hwemari kubva kutengeswa kweiyi zita rechigadzirwa. Formula yakagadzirira. Chinja chimiro cheresenti kana kuita link mhedziso haifanire kunge iri.
- Kuti utarise mhedzisiro yekuverenga kweiyo Enter.
- Kopa formula mune mamwe masero anokwevera pasi. Tafura ine data pane huwandu hweVT yakagadzirira.
Sezvauri kuona, chirongwa ichi chinopa mukana wekushanda zvakanaka nezvakaringana muzana. Mushandisi anogona kuverenga zvese zvikamu zveimwe nhamba mune muzana uye nhamba kubva muzana muzana. Excel inogona kushandiswa kushanda necerenti secalator yenguva dzose, asi zvakare neiri nyore uye otomatiki basa kuverenga kufarira mumatafura.