Ayyukan lissafi a cikin Excel kayan aiki ne mai ƙarfi wanda ke ba ka damar yin ƙididdige ƙididdiga da bincike da yawa. Daga cikin iyawarsa da yawa, ikon ƙididdige adadin jimla cikin sauri da sauƙi ya fice. Wannan aikin yana da amfani musamman a cikin yanayi inda kuke buƙatar ƙayyade adadin adadin zuwa jimillar. A cikin wannan labarin, za mu koyi yadda ake amfani da wannan aikin a cikin Excel don ƙididdige yawan adadin jimlar, mataki zuwa mataki da fasaha. Idan kuna sha'awar haɓaka lissafin lissafin ku a cikin Excel da samun ingantaccen sakamako mai inganci, ci gaba da karantawa!
1. Gabatarwa ga aikin lissafi a cikin Excel don ƙididdige yawan adadin jimlar
Ayyukan lissafi don ƙididdige adadin jimla a cikin Excel kayan aiki ne mai fa'ida sosai don yin ƙididdiga daidai da inganci. Tare da wannan aikin, zaku iya hanzarta samun kashi ɗaya na lamba dangane da wani kuma kuyi nazarin lambobi a hanya mai sauƙi.
Don ƙididdige adadin jimlar a cikin Excel, dole ne ku yi amfani da aikin "PERCENTAGE". Wannan aikin yana ba ku damar nemo ainihin adadin adadin dangane da jimillar. Yin amfani da wannan aikin, zaku iya yin jerin lissafi yadda ake samu yawan karuwa ko raguwa, yawan girma, da sauransu.
Ma'anar aikin "PERCENTAGE" a cikin Excel shine kamar haka: =PERCENTAGE(lamba, jimla). Ma'aunin "lambar" yana wakiltar adadin da kake son nemo kashi kuma ma'aunin "jimillar" shine jimillar ko ƙimar tushe dangane da wanda zaku ƙididdige kashi. Da zarar ka shigar da wannan aikin a cikin tantanin halitta na Excel, zaku sami sakamakon lissafin adadin da ake so.
2. Matakai don amfani da aikin lissafi a cikin Excel kuma sami kashi na jimla
Don amfani da aikin lissafi a cikin Excel don samun adadin jimlar, bi waɗannan matakan:
Hanyar 1: Bude Microsoft Excel a kan kwamfutarka kuma ƙirƙirar sabon maƙunsar rubutu.
Hanyar 2: Nemo tantanin halitta da kake son nuna kashi a ciki kuma ka tabbata an zaɓi shi. Sa'an nan kuma je zuwa mashaya dabara a saman na allo sannan ka rubuta wannan dabarar: = total_value*(percentage/100), inda “total_value” shine jimillar kimar da kake son samun kashi sannan “percentage” shine kaso da kake son kirga. Misali, idan kuna son lissafin kashi 25% na 200, dabarar zata kasance: = 200*(25/100).
Hanyar 3: Danna maɓallin Shigar don samun sakamako. Tantanin da aka zaɓa zai nuna adadin ƙididdiga. Idan kana son nuna sakamakon a matsayin kashi a cikin nau'in rubutu, za ka iya daidaita tsarin tsarin tantanin da aka zaɓa ta danna dama akansa, zaɓi "Format Cells," zaɓi shafin "Lambar", sannan zaɓi zaɓi "Kashi" zaɓi. .
3. Ilimin asali na aikin lissafi a cikin Excel don ƙididdige kashi
Don yin lissafin kashi a cikin Excel, yana da mahimmanci don samun ilimin asali na yadda ake amfani da ayyukan lissafin da wannan kayan aikin ke bayarwa. Na gaba, za mu nuna muku wasu mahimman ra'ayoyi da yadda ake amfani da su a cikin Excel don aiwatar da lissafin adadin ku. nagarta sosai.
Ɗayan ayyukan da aka fi amfani da su a cikin Excel don lissafin kashi shine aikin PERCENT. Wannan aikin yana ba ku damar ƙididdige yawan adadin lamba ɗaya dangane da wani. Misali, idan kuna son lissafta kashi 20% na 150, zaku iya amfani da dabara mai zuwa: =PORCENTAJE(150, 20). Wannan zai ba ku 30, wanda shine 20% na 150.
Wani aiki mai amfani don lissafin kashi a cikin Excel shine PERCENTAGE.ACUM. Wannan aikin yana ba ku damar ƙididdige adadin da aka tara na a kewayon tantanin halitta. Misali, idan kuna da jerin tallace-tallace na wata-wata kuma kuna son ƙididdige adadin adadin kowane wata na jimlar shekara, zaku iya amfani da aikin PERCENTAGE.ACUM. Kawai zaɓi kewayon sel waɗanda ke ɗauke da ƙimar kowane wata kuma yi amfani da dabarar =PORCENTAJE.ACUM(rango).
4. Misalai masu amfani na yadda ake amfani da aikin lissafi a cikin Excel don ƙididdige yawan adadin jimla
Don ƙididdige yawan adadin jimlar ta amfani da aikin lissafi a cikin Excel, kuna buƙatar bin matakai kaɗan. Da farko, dole ne ka zaɓi tantanin halitta inda kake son nuna sakamakon lissafin. Bayan haka, dole ne a shigar da tsarin da ya dace, wanda ya ƙunshi tsari mai zuwa: "= (daraja / jimla)*100". A cikin wannan tsari, "darajar" tana wakiltar adadin da kuke son ƙididdige kashi kuma "jimilar" ita ce jimlar ƙimar da ake magana.
Misali, idan kuna son ƙididdige adadin tallace-tallacen da aka samu dangane da jimillar tallace-tallace na wata, zaku iya amfani da wannan dabarar a cikin Excel: "=(sales_obtained/total_sales)*100". Lokacin da kuka shigar da wannan dabarar a cikin tantanin halitta da aka zaɓa, Excel zai yi lissafin ta atomatik kuma ya nuna sakamakon a matsayin kashi.
Yana da mahimmanci a tuna cewa lokacin amfani da aikin lissafi a cikin Excel, yana yiwuwa a daidaita adadin wuraren ƙima da kuke son nunawa a sakamakon. Don yin wannan, dole ne ka danna dama akan tantanin da aka zaɓa kuma zaɓi zaɓin "Format cells". A cikin "Lambar" shafin, za ka iya zaɓar zaɓin "Kashi" kuma saita adadin adadin da ake so.
5. Iyakoki da la'akari lokacin amfani da aikin lissafi a cikin Excel don ƙididdige kashi
Lokacin amfani da aikin lissafi a cikin Excel don ƙididdige kashi, yana da mahimmanci a tuna da iyakancewa da la'akari da yawa waɗanda zasu iya shafar daidaiton sakamakon. Ɗaya daga cikin maɓalli na maɓalli shine cewa Excel yana amfani da ƙayyadaddun madaidaicin ƙididdiga, wanda zai iya haifar da ƙananan kurakurai a cikin sakamakon a wasu lokuta. Yana da kyau a sake duba madaidaicin saitunan don tabbatar da cewa sun hadu da takamaiman bukatun lissafin.
Wani muhimmin abin la'akari shi ne cewa Excel yana amfani da ƙididdigar ƙididdiga na lambobi 15 ta tsohuwa, wanda zai iya haifar da matsala tare da ƙididdiga masu girma ko kaɗan. A waɗannan lokuta, yana iya zama larura a yi amfani da ƙira na musamman don guje wa kurakurai na zagaye ko ƙima mara kyau. Bugu da ƙari, yana da mahimmanci a tuna cewa Excel yana amfani da ma'aunin ƙima a matsayin mai rarraba ƙima, don haka ya zama dole a yi amfani da madaidaicin bayanin lokacin shigar da bayanai.
Bugu da ƙari, yana da mahimmanci a lura cewa Excel na iya gabatar da ƙalubale yayin ƙididdige adadin ƙima mara kyau. A wasu lokuta, sakamakon bazai zama da hankali ba ko yana iya buƙatar ƙarin gyare-gyare. Yana da kyau a tabbatar da sakamakon da yin ƙarin gwaje-gwaje don tabbatar da cewa an ƙididdige adadin daidai. Hakazalika, ana ba da shawarar yin amfani da tsarin lamba masu dacewa don gabatar da sakamakon a cikin tsari mai haske da fahimta.
6. Sauran ci gaba na amfani da aikin lissafi a cikin Excel don ƙididdige kashi
A cikin Excel, aikin math yana ba da damar da yawa don ƙididdige kashi da aiwatar da ƙididdiga na gaba. Baya ga ƙididdige kashi na asali, akwai kuma wasu ayyuka masu ƙarfi waɗanda za a iya amfani da su don ƙarin aikace-aikacen ci gaba. Anan muna nuna muku wasu ci-gaba na amfani da aikin lissafi a cikin Excel don ƙididdige kaso:
1. Amfani da aikin DEVSERIE: Wannan aikin yana da amfani lokacin da kuke buƙatar ƙididdige girman girma ko raguwa tsakanin ƙima biyu. Don amfani da shi, kawai zaɓi tantanin halitta inda kake son nuna sakamakon, rubuta "= DEVSERIE(start_value, end_value)" sannan danna Shigar. Sakamakon zai zama canjin kashi tsakanin dabi'u biyu.
2. Amfani da aikin PERCENTAGE: Wannan aikin yana ba ku damar ƙididdige yawan adadin lamba ɗaya dangane da wani. Misali, idan kuna son ƙididdige adadin tallace-tallacen da aka samu dangane da wata manufa, zaku iya amfani da dabarar “= PERCENTAGE(sales_achieved, goal)”. Wannan zai ba ku adadin tallace-tallace da aka samu dangane da manufar da aka kafa.
3. Aiwatar da tsarin sharadi: Wata hanyar da za a yi amfani da aikin lissafi a cikin Excel don ƙididdige kashi ita ce ta yin amfani da tsarin tsari. Wannan fasalin yana ba ku damar haskaka sel ta atomatik bisa wasu yanayi. Misali, zaku iya haskaka duk tallace-tallacen da suka wuce wani kaso ta amfani da tsarin yanayi. Don yin wannan, zaɓi sel ɗin da kuke son haskakawa, je zuwa shafin "Gida" akan ribbon, zaɓi "Tsarin Yanayi," kuma zaɓi zaɓin "Highlight Cell Dokokin Cell". Sa'an nan, zaɓi "Mafi Girma" kuma rubuta kashi da ake so. Kwayoyin da suka cika wannan yanayin za a haskaka su ta atomatik.
7. Yadda ake siffanta tsari da daidaiton sakamako yayin ƙididdige kashi a cikin Excel
Al lissafin kashi a cikin Excel, yana yiwuwa a tsara tsari da daidaitattun sakamakon don daidaita su zuwa bukatunmu. Wannan na iya zama da amfani musamman lokacin aiki tare da adadi mai yawa na bayanai kuma yana buƙatar gabatar da sakamakon a bayyane kuma dalla-dalla. A ƙasa akwai matakan da za a bi don cimma wannan:
1. Zaɓi cell ɗin da kake son yin lissafin kashi. Sa'an nan, danna kan "Home" tab a ciki da toolbar na Excel.
- tip: Idan kana son ƙididdige adadin adadin ɗaya dangane da wani, tabbatar da zaɓar tantanin halitta wanda ke ɗauke da cikakkiyar ƙimar maimakon tantanin halitta wanda ke ɗauke da ƙimar ɓarna.
2. Da zarar a cikin shafin "Home", danna maɓallin "Kashi" a cikin rukunin umarni na "Lambar" don amfani da tsarin kashi zuwa tantanin da aka zaɓa. Wannan zai canza darajar zuwa kashi goma.
- Koyawa: Idan kana son tsara tsarin adadin kashi, danna-dama akan tantanin halitta kuma zaɓi "Format Cells." Akwatin maganganu yana bayyana inda zaku iya daidaita adadin wuraren ƙima da daidaita sauran bayanan tsarawa.
3. Don sanya sakamakon ya zama daidai, za ku iya daidaita adadin wuraren ƙididdiga na ƙididdiga. Don yin wannan, yi haka: danna-dama tantanin halitta mai ƙunshe da kashi, zaɓi "Format Cells," sa'annan ka saita adadin da ake so na decimal a cikin "Lambar" shafin. Ka tuna cewa adadin wuraren ƙima na iya shafar daidaitattun sakamakon.
8. Yadda za a gyara kurakurai masu yuwuwa yayin amfani da aikin lissafi a cikin Excel don ƙididdige kashi
- Don warware kurakurai masu yuwuwa yayin amfani da aikin lissafi a cikin Excel don ƙididdige kashi, yana da mahimmanci don tabbatar da cewa kayi amfani da madaidaicin daidaitawa a cikin dabara. Tsarin lissafin a kashi a cikin Excel es: =darajar*(kashi/100). Tabbatar cewa kun shigar da ƙimar da suka dace kuma kuyi amfani da haɓakawa da alamun rarraba daidai.
- Bugu da ƙari, yana da mahimmanci a lura cewa Excel yana amfani da tsarin salula na asali don nuna sakamakon lissafin. Idan kana son nuna sakamakon a matsayin kashi, tabbatar da amfani da tsarin kashi zuwa tantanin halitta da aka zaba. Don yin wannan, zaɓi tantanin halitta kuma danna maballin "Kashi" akan maballin tsarawa.
- Idan kuna fuskantar matsalolin ƙididdige kashi a cikin Excel, kuna iya amfani da fasalin tsara yanayin don haskaka sakamakon da ba daidai ba. Misali, zaku iya saita ƙa'idar tsara yanayin don haskaka sel waɗanda ke ƙunshe da sakamako sama da ƙayyadaddun iyaka ko ƙasa da ƙaramin ƙima. Wannan zai taimaka maka da sauri gano kurakurai a cikin lissafin ku kuma gyara su.
9. Dabaru da tukwici don haɓaka lissafin kashi a cikin Excel ta amfani da aikin lissafi
Don inganta lissafin kashi a cikin Excel ta amfani da aikin lissafi, akwai jerin dabaru da tukwici wanda zai iya zama da amfani. Matakan da za a bi za a yi dalla-dalla a ƙasa don tabbatar da ingantaccen lissafi mai inganci.
1. Yi amfani da aikin PERCENTAGE: Excel yana ba da takamaiman aiki don ƙididdige kashi cikin sauƙi. Don amfani da shi, kawai rubuta "= PERCENTAGE(lamba, kashi)" a cikin tantanin halitta da ake so. Tabbatar maye gurbin "lambar" tare da ƙimar da kuke son ƙididdige kashi da "kashi" tare da kashi da kuke son nema. Misali, "= PERCENT(A1, 20)" zai lissafta kashi 20% na darajar tantanin halitta A1.
2. Yi amfani da tsarin salula na al'ada: Baya ga aikin PERCENTAGE, Excel yana ba ku damar tsara tsarin sel don nuna sakamako azaman kashi. Don yin wannan, zaɓi sel ɗin da kuke son nuna kashi, danna-dama kuma zaɓi zaɓi "Format Cells". A cikin "Lambar" shafin, zaɓi nau'in "Kashi" kuma saita adadin da ake so na decimals. Ta wannan hanyar, zaku iya duba kashi a bayyane kuma a bayyane.
3. Yi amfani da nassoshin tantanin halitta: Idan kana buƙatar ƙididdige kaso don ƙima daban-daban a cikin takardar lissafi, yana da kyau a yi amfani da nassoshi tantanin halitta. Misali, idan kana so ka lissafta kashi 10 cikin 1 na jerin lambobi a cikin sel A10 zuwa A1, maimakon buga = PERCENT(A10, 1) ga kowane tantanin halitta, kawai ka rubuta dabarar a cikin tantanin halitta B10 kuma ka ja shi zuwa tantanin halitta BXNUMX. Ta wannan hanyar, Excel za ta daidaita ma'anar tantanin halitta ta atomatik kuma ta lissafta daidai adadin kowane ƙima.
10. Kwatanta tsakanin aikin lissafi da sauran zaɓuɓɓukan lissafin kashi a cikin Excel
A cikin wannan kwatancen, za mu bincika aikin lissafi da sauran zaɓuɓɓukan lissafin kashi a cikin Excel. A ƙasa, za mu daki-daki daban-daban madadin kuma mu ba da misalai ga kowannensu.
Ɗayan zaɓin da aka fi amfani da shi don ƙididdige kashi a cikin Excel shine aikin "PERCENTAGE". Wannan aikin yana ƙididdige adadin ƙimar ɗaya dangane da wani. Misali, idan muna da sel biyu A1 da B1, inda A1 ya ƙunshi jimillar ƙima kuma B1 ya ƙunshi kaso da muke son ƙididdigewa, za mu iya amfani da dabara `= PERCENTAGE(A1,B1)` don samun sakamakon.
Wani zaɓi shine yin amfani da ayyukan lissafi masu sauƙi. Misali, idan muna so mu ƙididdige kashi 30% na ƙimar, za mu iya ninka shi da 0.3. Wannan Ana iya yi kai tsaye zuwa cikin kwayar halitta ta Excel ta amfani da dabara `= A1 * 0.3`. Bugu da ƙari, kuna iya amfani da wannan fasaha don yin wasu ƙididdiga masu alaƙa, kamar ƙara kashi zuwa ƙima ko rage kashi daga ƙima.
Ƙarin ƙarin zaɓi shine a yi amfani da tsari na yanayi don haskaka ƙimar kashi ta atomatik. Wannan na iya zama da amfani lokacin da kuke aiki tare da manyan saitin bayanai kuma kuna son samun saurin nuni na kashi. Don yin wannan, zaku iya zaɓar kewayon sel waɗanda kuke son haskakawa sannan ku je shafin "Gida" akan kayan aiki. Na gaba, zaɓi zaɓin "Tsarin Yanayi" kuma zaɓi ƙa'idar da ta fi dacewa da bukatun ku. Misali, zaku iya haskaka duk ƙimar sama da 50% a cikin kore da ƙimar ƙasa a cikin ja.
A taƙaice, Excel yana ba da zaɓuɓɓuka da yawa don ƙididdige kashi. Kuna iya amfani da aikin "PERCENTAGE" don samun ingantaccen sakamako, yin lissafin lissafi mai sauƙi, ko amfani da tsara yanayin don haskaka ƙimar kashi ta atomatik. Zaɓin zaɓi zai dogara ne akan buƙatun mutum da abubuwan da ake so.
11. Yadda ake amfani da aikin lissafi a cikin Excel don ƙididdige kashi a cikin tebur da jadawali
- Bude Microsoft Excel kuma zaɓi tebur ko ginshiƙi wanda kuke son ƙididdige kaso. Tabbatar cewa an tsara bayanan ku da kyau kafin farawa.
- A cikin tantanin halitta inda kake son nuna kashi, yi amfani da aikin ''=kashi(cell1, cell2)'' inda 'cell1' shine ƙimar da kake son ƙididdige kashi kuma 'cell2' shine jimillar ko tushen da kashi a kai. za a lissafta . Misali, idan kana so ka lissafta adadin tallace-tallace na samfur dangane da jimillar tallace-tallace, tsarin zai zama '= kashi (B2, B7)', yana zaton cewa B2 ya ƙunshi darajar tallace-tallace na samfurin kuma B7 ya ƙunshi jimillar. na tallace-tallace.
- Danna Shigar don samun sakamakon lissafin kashi. Za a nuna ƙimar a matsayin lambar ƙima, don haka yana buƙatar tsara shi azaman kashi. Zaɓi cell kuma danna dama. Sannan zaɓi zaɓin 'Format Cells' kuma a cikin 'Lambar' shafin, zaɓi 'Kashi' sannan zaɓi adadin wuraren da ake so. Shirya! Yanzu za ku sami adadin da aka lissafta daidai a cikin tebur ko jadawali.
Yin amfani da aikin lissafi a cikin Excel don ƙididdige kaso a cikin teburi da jadawali shine a ingantacciyar hanya don ganin bayanan ta hanyar da za a iya fahimta. Ka tuna cewa ana iya amfani da wannan aikin a lokuta daban-daban, kamar ƙididdige adadin girma dangane da jimillar ko kwatanta dabi'u daban-daban. Har ila yau, ku tuna cewa Excel yana ba da wasu ayyuka da kayan aikin da za su iya fadada lissafin ku da damar gabatar da bayanai. Bincika kuma gwada waɗannan fasalulluka don haɓaka ƙwarewar ku na Excel!
12. Muhimmanci da aikace-aikace na aikin lissafi a cikin Excel don ƙididdige yawan adadin jimlar
Ayyukan lissafi a cikin Excel kayan aiki ne na asali don aiwatar da ƙididdiga cikin sauri da daidaito. Ɗayan aikace-aikacen gama gari shine ƙididdige yawan adadin jimlar. Ana amfani da wannan fasalin a fannoni daban-daban kamar lissafin kuɗi, ƙididdiga, kuɗi, da ƙari. Tare da Excel, zamu iya yin wannan lissafin ta hanya mai sauƙi da inganci.
Don ƙididdige adadin jimlar a cikin Excel, za mu iya amfani da aikin "%". Wannan aikin yana ba mu damar samun kashi daidai da ƙimar da muke son ƙididdigewa. Misali, idan muna da jimlar tallace-tallace kuma muna son samun adadin tallace-tallace don takamaiman samfur, zamu iya amfani da aikin lissafi a cikin Excel don yin wannan lissafin.
Mataki na farko shine zaɓi tantanin halitta inda muke son samun sakamakon lissafin. Na gaba, muna rubuta umarni mai zuwa: «= (sel tare da ƙimar da ake so) % (sel tare da jimlar)». Misali, idan muna so mu lissafta adadin tallace-tallace na samfurin da ya samar da $500 na kudaden shiga daga cikin jimlar $2000 na tallace-tallace, za mu rubuta "= 500/2000" kuma danna Shigar. Excel zai nuna mana sakamakon wannan lissafin a matsayin kashi.
13. Yadda ake sarrafa lissafin kashi a cikin Excel ta amfani da aikin lissafi
Yin lissafin kashi na atomatik a cikin Excel na iya adana lokaci da ƙoƙari, musamman lokacin aiki tare da manyan bayanan bayanai. Abin farin ciki, Excel yana ba da aikin lissafi wanda zai ba ku damar yin wannan lissafin cikin sauri da daidai. Ayyukan da dole ne mu yi amfani da su shine aikin "PERCENTAGE", wanda ke cikin nau'in ayyukan lissafi a cikin Excel.
Don amfani da aikin kashi a cikin Excel, dole ne mu bi matakai masu zuwa:
- Zaɓi cell ɗin da muke son samun sakamakon lissafin kashi.
- Shigar da dabara "= PERCENTAGE(lamba, jimla)" a cikin mashigin dabara, maye gurbin "lambar" tare da ƙimar da muke son ƙididdige kaso da "jimillar" tare da jimillar ƙimar da muke son kafa kaso a kanta.
- Danna maɓallin Shigar don samun sakamakon lissafin kuma nuna daidai adadin a cikin tantanin halitta da aka zaɓa.
Misali, idan muna so mu lissafta kashi 20% na jimlar adadin 100, kawai sai mu zabi tantanin halitta wanda muke son sakamakon ya bayyana, sai a shigar da dabara "= PERCENTAGE(20, 100)" sannan a danna Enter. Excel zai yi lissafin kuma ya nuna sakamakon, a wannan yanayin, 20.
14. Ƙarshe da shawarwari lokacin amfani da aikin lissafi a cikin Excel don ƙididdige kashi
A ƙarshe, aikin lissafi a cikin Excel kayan aiki ne mai ƙarfi wanda ke ba ku damar ƙididdige kashi cikin sauri da daidai. A cikin wannan labarin, mun ga yadda ake amfani da wannan fasalin a yanayi daban-daban kuma mun nuna wasu dabaru da dabaru don samun sakamako mafi kyau.
Ɗaya daga cikin fa'idodin yin amfani da aikin lissafi a cikin Excel shi ne cewa yana ba da nau'i-nau'i masu yawa waɗanda za a iya daidaita su da buƙatu daban-daban. Ko kuna buƙatar ƙididdige yawan adadin lamba, karuwa ko raguwa, ko duk wani lissafin da ke da alaƙa da kaso, Excel yana da dabarar da ta dace a gare ku.
Yana da mahimmanci a tuna cewa lokacin amfani da aikin lissafi a cikin Excel don ƙididdige kashi, yana da mahimmanci a bayyana a sarari game da hanyoyin da bayanan da ake buƙata don samun ingantaccen sakamako. Bugu da ƙari, ana ba da shawarar cewa ku san kanku da wasu ayyuka masu alaƙa, kamar ayyukan zagaye da tsarawa, don samun babban iko akan sakamakon.
A taƙaice, aikin lissafi a cikin Excel kayan aiki ne mai ƙarfi kuma mai amfani wanda ke ba mu damar ƙididdige adadin jimlar cikin sauƙi. Ko muna buƙatar nemo adadin tallace-tallacen da aka samu, haɓakar ƙimar saka hannun jari ko duk wani lissafin dangane da kashi, Excel yana ba mu kayan aikin da suka dace don cimma shi. ingantacciyar hanya.
Ta amfani da aikin PERCENT a haɗe tare da mai aiki da rarrabawa da ninkawa, za mu iya samun ingantattun sakamako masu inganci cikin kankanin lokaci. Har ila yau, Excel yayi mana da ikon tsara bayanan ta yadda za a nuna su a cikin nau'i na kashi, yana sa ya fi sauƙi wajen fassarawa.
Yana da mahimmanci a tuna cewa lokacin amfani da aikin lissafi a cikin Excel don ƙididdige adadin jimlar, dole ne mu tabbatar da shigar da muhawara daidai kuma mu mutunta tsarin tsarin. Bugu da ƙari, yana da mahimmanci a fahimci mahallin da ake yin lissafin kuma a yi la'akari da wasu ma'auni masu dacewa waɗanda zasu iya rinjayar sakamakon.
A ƙarshe, aikin lissafi a cikin Excel yana ba mu mafita mai inganci da sauri don ƙididdige adadin jimlar. Tare da ɗan ƙaramin aiki da sanin kayan aikin da ake da su, kowane mai amfani zai iya yin cikakken amfani da wannan fasalin kuma ya yi ingantacciyar ƙididdiga a cikin maƙunsar bayanan su. Don haka, Excel ya zama kayan aiki mai mahimmanci don bincike da gabatar da bayanan ƙididdiga a fagen ƙwararru da ilimi.
Ni Sebastián Vidal, injiniyan kwamfuta mai sha'awar fasaha da DIY. Bugu da ƙari, ni ne mahaliccin tecnobits.com, inda nake raba koyaswar don sa fasaha ta fi dacewa da fahimtar kowa ga kowa.