Lokacin aiki tare da bayanan tabula, yana da mahimmanci don lissafin yawan adadin, ko lissafta adadin yawan adadin. Wannan fasali ya samar da Microsoft Excel. Amma, rashin alheri, ba kowane mai amfani yana iya amfani da kayan aiki don aiki tare da sha'awa cikin wannan aikace-aikace. Bari mu ga yadda za a tantance kashi a cikin Microsoft Excel.
Ƙididdigar yawan adadin
Da farko, bari mu gano yadda za a lissafa yawan adadin lamba daga wani. Ƙididdigar lissafin ƙididdiga kamar haka: "= (lambar) / (total_sum) * 100%.
Don haka, don nuna lissafi a cikin aiki, zamu gano yawancin adadin lambar ne 9 daga 17. Da farko, mun zama cikin tantanin halitta inda za a nuna sakamakon. Tabbatar kula da yadda aka tsara a cikin shafin shafin a cikin ƙungiyar kayan kayan. Idan tsarin ya bambanta da kashi, to dole ne mu saita saitin "Batu" a filin.
Bayan haka, rubuta bayanan da ke cikin tantanin halitta: "= 9/17 * 100%".
Duk da haka, tun da mun saita tsarin adadin tantanin tantanin halitta, kara da darajar "* 100%" ba lallai ba ne. Ya isa ya rubuta "= 9/17".
Don ganin sakamakon, danna maɓallin Shigar da ke keyboard. A sakamakon haka, muna samun 52.94%.
Yanzu bari mu dubi yadda za a iya lissafi sha'awa ta hanyar aiki tare da bayanan tabula a cikin kwayoyin. Ƙila za mu buƙaci adadin kashi ne kashi na tallace-tallace na wani nau'i na samfurin daga adadin da aka ƙayyade a cikin tantanin halitta. Don yin wannan, a cikin layi tare da sunan samfurin, danna kan wayar maras tabbatattun, kuma saita tsarin ƙimar a ciki. Saka alamar "=". Kusa, danna kan tantanin halitta yana nuna darajar aiwatar da samfurin samfurin. Sa'an nan, sanya alamar "/". Bayan haka, danna kan tantanin halitta tare da adadin tallace-tallace na duk samfurori. Saboda haka, a tantanin tantanin halitta don nuna sakamakon, muna da tsari.
Don ganin darajar lissafi, danna maballin Shigar.
Amma, ta wannan hanya, mun sami ma'anar kashi kashi na daya kawai. Shin wajibi ne a gabatar da irin wannan lissafi ga kowane layi na gaba? Ba dole ba ne. Muna buƙatar kwafin wannan tsari zuwa wasu kwayoyin. Amma, tun da yake a cikin wannan yanayin zancen tantanin salula tare da jimillar jimillar dole ne ta kasance da tsayin daka don babu wata matsala, a cikin tsarin da muke sa alamar "$" a gaban haɗin jeri da shafi. Bayan haka, zancen tantanin halitta daga dangi ya juya cikin cikakkiyar.
Bayan haka, zamu kasance a cikin kusurwar ƙananan ƙananan tantanin halitta, wanda aka ƙayyade darajarsa, kuma, riƙe da maɓallin linzamin kwamfuta, ja shi zuwa tantanin halitta, inda yawancin ya haɗa. Kamar yadda kake gani, ana kwashe ma'anar ta zuwa duk sauran sassan layin. Nan da nan sakamakon sakamakon lissafin.
Kuna iya ƙidaya yawan adadin abubuwan da ke cikin teburin, koda kuwa ba a nuna yawan adadin a cikin tantanin salula ba. Don yin wannan, bayan mun tsara tantanin tantanin halitta don nuna sakamakon a matsayi na yawan, sanya saitin "=" a ciki. Kusa, danna kan tantanin salula wanda kake son ganowa. Mun sanya alamar "/", sa'an nan kuma muna fitar da daga cikin keyboard yawan adadin wanda aka ƙidaya yawan. Don kunna hanyar haɗi zuwa cikakken, a wannan yanayin, ba lallai ba ne.
Bayan haka, kamar lokaci na ƙarshe, zamu danna kan maɓallin ENTER, kuma ta jawo mu kwafin dabara a cikin sassan da ke ƙasa.
Ƙididdiga yawan adadin sha'awa
Yanzu mun gano yadda za a tantance adadin adadin yawan adadin shi. Gaba ɗaya don lissafi zai kasance kamar haka: "%_value% * total_sum." Saboda haka, idan muna buƙatar lissafin abin da lambar yake 7% na 70, to, kawai shigar da kalmar "= 7% * 70" a tantanin halitta. Tunda, a sakamakon haka, muna samun lambar, ba kashi, a cikin wannan yanayin ba lallai ba ne don saita tsarin girma. Dole ne ya kasance ko jimla ko nau'i.
Don duba sakamakon, danna maballin ENTER.
Wannan samfurin yana da matukar dace don amfani don yin aiki tare da tebur. Alal misali, muna buƙatar daga kudaden kowane abu don lissafin adadin VAT, wanda a Russia shine 18%. Don yin wannan, zamu kasance a cikin komai marar layi a layi tare da sunan kayan. Wannan tantanin halitta zai zama ɗaya daga cikin abubuwan da aka tsara a cikin mahallin da za a nuna yawan VAT. Shirya wannan tantanin halitta a cikin tsarin girma. Mun sanya alamar "=". Mun buga maɓallin keyboard lambar 18%, kuma sanya alamar "*". Kusa, danna kan tantanin salula da yawan kudaden shiga daga sayarwa wannan abu. An shirya wannan tsari. A wannan yanayin, kada kayi canza tsarin tantanin halitta zuwa kashi, ko sanya hanyoyin haɗi cikakke.
Domin ganin sakamakon sakamakon lissafi danna maballin ENTER.
Kwafi wannan tsari zuwa wasu kwayoyin ta hanyar jawowa. Tebur tare da bayanan akan adadin VAT an shirya.
Kamar yadda kake gani, Microsoft Excel tana samar da damar yin aiki tare da darajar yawan farashi. A wannan yanayin, mai amfani zai iya ƙidaya duka rabo na wani lamba a cikin kashi kuma yawan adadin yawan sha'awa. Ana iya amfani da Excel don yin aiki tare da kashi ɗaya, kamar ƙwararru na yau da kullum, amma zaka iya amfani da shi don sarrafa aikin yin lissafin kashi a cikin tebur. Wannan yana ba ka damar ingantaccen lokacin masu amfani da wannan shirin yayin lissafi.
