Nthawi zambiri, pakati pamagulu omwe amapezeka, ogwiritsa ntchito Excel amatembenukira ku masamu. Kugwiritsa ntchito, mutha kuchita masamu osiyanasiyana a arithmetic ndi algebraic. Nthawi zambiri amagwiritsidwa ntchito pokonzekera komanso kuwerengera kwa sayansi. Tidziwa kuti gulu ili ndi liti, ndikukhala mwatsatanetsatane kwa otchuka kwambiri aiwo.
Kugwiritsa ntchito ntchito zamasamu
Pogwiritsa ntchito masamu, mutha kuwerengera zingapo. Zikhala zothandiza kwa ophunzira ndi ana asukulu, mainjiniya, asayansi, owerengera ndalama, okonza. Gulu ili lili ndi opanga pafupifupi 80. Tikhala mwatsatanetsatane pa khumi omwe adadziwika kwambiri.
Mutha kutsegula mndandanda wazotsatira zamasamu m'njira zingapo. Njira yosavuta yoyambira Wizard Yogwira ntchito ndikudina batani. "Ikani ntchito", yomwe ili kumanzere kwa baramu yamu formula. Pankhaniyi, muyenera kusankha khungu lomwe zotsatira za kukonza deta ziwonetsedwa. Njirayi ndi yabwino chifukwa imatha kukhazikitsidwa kuchokera pa tabu iliyonse.
Mutha kuyambitsanso Wizard Yogwira Ntchito popita pa tabu Mawonekedwe. Pamenepo muyenera dinani batani "Ikani ntchito"ili kumanzere kwenikweni kwa tepiyo mu chipangizo chida Laibulale ya Feature.
Pali njira yachitatu yomwe ingayambitsire ntchito Wizard. Imachitidwa ndikakanikiza kuphatikiza makiyi pa kiyibodi Shift + F3.
Wogwiritsa ntchito atachita chilichonse mwanjira ili pamwambapa, Wizard Yogwira Ntchito itatseguka. Dinani pazenera m'munda Gulu.
Mndandanda wotsika pansi umatseguka. Sankhani malo mmenemu "Masamu".
Pambuyo pake, mndandanda wazinthu zonse za masamu ku Excel zimawonekera pazenera. Kuti mupitirize kukhazikitsa mfundozo, sankhani yokhayo ndikudina batani "Zabwino".
Palinso njira yosankhira woyang'anira masamu popanda kutsegula windo lalikulu la Ntchito Wizard. Kuti muchite izi, pitani ku tabu yomwe mumatidziwa kale Mawonekedwe ndipo dinani batani "Masamu"yomwe ili pambali ya gulu lazida Laibulale ya Feature. Mndandanda umatseguka, pomwe muyenera kusankha njira yoyenera yothetsera vuto linalake, pambuyo pake zenera la mfundo zake limatsegulidwa.
Zowona, ziyenera kudziwidwa kuti si mitundu yonse ya gulu la masamu yomwe imawonetsedwa pamndandandandawu, ngakhale ambiri aiwo. Ngati simukupeza wothandizirayo, dinani chinthucho "Ikani ntchito ..." kumapeto kwa mndandanda, pambuyo pake Wizard Wogwira Ntchito watha kutsegulidwa.
Phunziro: Ntchito Wizard ku Excel
SUM
Ntchito yogwiritsidwa ntchito kwambiri SUM. Wogwiritsa ntchito amapangidwira kuti awonjezere zambiri m'maselo angapo. Ngakhale ikhoza kugwiritsidwa ntchito pamitengo yanthawi zonse ya manambala. Syntax yomwe ingagwiritsidwe ntchito ndi zolemba zamanja ndi motere:
= SUM (nambala1; nambala2; ...)
Pa zenera zotsutsana, muyenera kulowa zolumikizana ndi maselo okhala ndi deta kapena mzere m'minda. Wogwiritsa ntchito amawonjezera zomwe zalembedwazo ndikuwonetsa zonse mu selo limodzi.
Phunziro: Momwe mungawerengere kuchuluka kwa Excel
SUMU
Wogwiritsa ntchito SUMU amawerengera kuchuluka kwa kuchuluka kwamaselo. Koma, mosiyana ndi ntchito yam'mbuyo, mu opaleshoni iyi mutha kukhazikitsa mawonekedwe omwe azindikire kuti ndi ati omwe akukhudzidwa ndikuwerengera ndi omwe sanatsatire. Mukafotokoza za vuto, mutha kugwiritsa ntchito zizindikilo ">" ("zina"), "<" ("zochepa"), "" ("zosofanana"). Ndiye kuti, nambala yomwe sikukwaniritsa zomwe zatchulidwa sizikumbukiridwa mu mkangano wachiwiri mukamawerengera kuchuluka kwake. Kuphatikiza apo, pali mkangano wowonjezera "Zowerengera Mwachidule"koma osankha. Ntchito yake ili ndi syntax yotsatirayi:
= SUMMES (Range; Craption; Sum_range)
Round
Monga titha kumvetsetsa kuchokera ku dzina la ntchitoyo Round, imagwiritsa ntchito ziwerengero. Mtsutso woyamba wa opaleshoni iyi ndi nambala kapena cholozera ku foni yomwe ili ndi nambala ya manambala. Mosiyana ndi ntchito zina zambiri, mtundu uwu sungakhale mtengo. Mtsutso wachiwiri ndi chiwerengero cha malo omwe mumafuna kuzungulira. Kuzungulira kumachitika molingana ndi malamulo a masamu ambiri, ndiye kuti, kwa nambala yapafupi ya modulo. Makina a formula iyi ndi:
= Round (nambala; nambala_azithunzi)
Kuphatikiza apo, Excel ili ndi mawonekedwe monga Round UP ndi RoundDOWN, yomwe imazungulira ziwerengero mpaka zazing'ono ndi zazing'ono.
Phunziro: Kuchulukitsa ziwerengero ku Excel
CHENJEZO
Ntchito yothandizira LANGANI kuchulukitsa kwa manambala kapena kwa omwe ali m'maselo a pepalalo. Zomwe zikutsutsana ndi ntchitoyi ndikuwonetsa ma cell omwe ali ndi zidziwitso zochulukitsa. Ponseponse, mpaka 255 maulalo oterewa angagwiritsidwe ntchito. Zotsatira za kuchulukitsa zimawonetsedwa mu khungu lina. Kapangidwe ka mawu awa ndi motere:
= CHEMA (nambala; nambala; ...)
Phunziro: Momwe mungachulukire molondola mu Excel
ABS
Kugwiritsa ntchito mtundu wamasamu ABS manambala amawerengedwa. Wogwiritsa ntchitoyu ali ndi mfundo imodzi - "Chiwerengero", ndiye kuti, kukalozera ku khungu lomwe lili ndi ziwerengero. Masamba sangakhale ngati mkangano. Syntax ndi motere:
= ABS (chiwerengero)
Phunziro: Ntchito ya Module ku Excel
ZOCHITITSA
Kuchokera ku dzina ndizodziwikiratu kuti ntchito ya wothandizira ZOCHITITSA ikukweza manambala kufika pamlingo wopatsidwa. Ntchitoyi ili ndi mfundo ziwiri: "Chiwerengero" ndi "Degree". Yoyamba mwaiyo imatha kuwonetsedwa ngati ulalo wa foni yomwe ili ndi mtengo wowerengera. Kutsutsana kwachiwiri kukuwonetsa kuchuluka kwa kukonzekera. Kuchokera pazomwe tafotokozazi, zikutsatira kuti syntax ya wothandizira ili ndi motere:
= DEGREE (chiwerengero; digiri)
Phunziro: Momwe mungadziwonetsere ku Excel
MUTHA
Ntchito yovuta MUTHA ndi kuchotsa kwa muzu wapakati. Wogwiritsa ntchitoyu ali ndi mfundo imodzi yokha - "Chiwerengero". Udindo wake ukhoza kukhala cholumikizana ndi foni yokhala ndi deta. Syntax amatenga mawonekedwe awa:
= ROOT (chiwerengero)
Phunziro: Momwe mungawerengere muzu mu Excel
Mlandu PABWINO
Ntchito yofunikira pa fomula Mlandu PABWINO. Zimakhala ndikuwonetsa nambala iliyonse mwatsatanetsatane pakati pa manambala awiri opatsidwa mu foni yomwe idatchulidwa. Kuchokera pa kufotokozera kwa magwiridwe antchito a opareshoni ndizodziwikiratu kuti mfundo zake ndizotsogola komanso kutsika kwa nthawi. Dongosolo lake ndi:
= CASE BETWEEN (Lower_Bound; Upper_Bound)
TSOGOLO
Wogwiritsa ntchito TSOGOLO kugawa manambala. Koma mu zotsatira za magawanidwe, iye amangowonetsa chiwerengero chokhacho, chophatikizidwa ndi modulus yaying'ono. Zomwe zimatsutsana pamtunduwu ndizofotokoza maselo omwe ali ndi gawo logawanitsa ena. Syntax ndi motere:
= PRIVATE (Numerator; Denomator)
Phunziro: Formula yogawa ya Excel
ROMAN
Ntchitoyi imakupatsani mwayi kuti musinthe manambala achiarabu, omwe Excel imagwiritsa ntchito mwaulesi, kuti ikhale ya Chiroma. Wogwiritsa ntchito ali ndi mfundo ziwiri: zonena za selo lomwe lili ndi nambala yosinthika ndi mawonekedwe. Mtsutso wachiwiri ndiwosankha. Syntax ndi motere:
= ROMAN (Chiwerengero; Fomu)
Ntchito zodziwika bwino zokha za Excel zokha zomwe zafotokozedwa pamwambapa. Amathandizira kwambiri kuwerengera kosiyanasiyana kuwerengera mu pulogalamuyi. Pogwiritsa ntchito njira izi, mutha kuchita ntchito zosavuta kwambiri zowerengera komanso kuwerengera zovuta kwambiri. Makamaka amathandizira pazochitika zomwe muyenera kupanga malo okhala.
