Chidule cha ntchito zamasamu mu Excel (Gawo 1). 10 Zothandiza Kwambiri Masamu

Ntchito ya Excel ndi mawu omwe amakulolani kuti musinthe njira inayake yogwirira ntchito ndi nkhokwe. Amabwera m'mitundu yosiyanasiyana: masamu, zomveka ndi zina. Iwo ndi mbali yaikulu ya pulogalamuyi. Masamu a Excel ndi ena mwa omwe amagwiritsidwa ntchito kwambiri. Izi sizosadabwitsa, chifukwa iyi ndi pulogalamu yomwe idapangidwa kuti ikhale yosavuta kukonza manambala ambiri. Pali masamu ambiri, koma apa pali 10 mwa zothandiza kwambiri. Lero tiwunikanso.

Momwe mungagwiritsire ntchito masamu mu pulogalamuyi?

Excel imapereka mwayi wogwiritsa ntchito masamu opitilira 60, omwe mutha kuchita nawo ntchito zonse. Pali njira zingapo zoyika masamu mu selo:

1. Pogwiritsa ntchito batani la "Insert Function", lomwe lili kumanzere kwa kapamwamba kolowera. Mosasamala kuti ndi tsamba liti lalikulu lomwe lasankhidwa pakadali pano, mutha kugwiritsa ntchito njirayi.
2. Gwiritsani ntchito tabu ya Mafomula. Palinso batani lotha kuyika ntchito. Ili kumanzere kwenikweni kwa toolbar.
3. Gwiritsani ntchito makiyi otentha Shift+F3 kuti mugwiritse ntchito wizard.

Njira yotsiriza ndiyo yabwino kwambiri, ngakhale poyang'ana koyamba ndizovuta kwambiri chifukwa chofunika kuloweza kuphatikiza kiyi. Koma m'tsogolomu, zitha kupulumutsa nthawi yambiri ngati simukudziwa kuti ndi ntchito iti yomwe ingagwiritsidwe ntchito kukhazikitsa chinthu china. Pambuyo poyitanira ntchito wizard, bokosi la zokambirana lidzawonekera.

Mmenemo mungathe kuona mndandanda wotsikira pansi wokhala ndi magulu, ndipo tili ndi chidwi ndi momwe owerenga ofulumira angamvetsetse ntchito za masamu. Kenako, muyenera kusankha yomwe imatisangalatsa, ndikutsimikizira zomwe mwachita podina batani la OK. Komanso, wogwiritsa ntchito amatha kuwona omwe amamukonda ndikuwerenga zomwe amafotokozera.

Kenako, zenera lidzawoneka ndi zotsutsana zomwe tiyenera kudutsa ku ntchitoyo.

Mwa njira, mutha kusankha ntchito zamasamu nthawi yomweyo kuchokera pa tepi. Kuti muchite izi, muyenera gulu lakumanzere kwambiri, dinani chizindikiro chomwe chili ndi lalikulu lalikulu, ndikusankha zomwe mukufuna.

Mukhozanso kulowa ntchitoyi nokha. Kwa ichi, chizindikiro chofanana chimalembedwa, pambuyo pake dzina la ntchitoyi likulowetsedwa pamanja. Tiyeni tiwone momwe izi zimagwirira ntchito popereka mayina enieni a ntchito.

Mndandanda wa ntchito za masamu

Tsopano tiyeni titchule ntchito za masamu zodziwika kwambiri zomwe zimagwiritsidwa ntchito m'mbali zonse za moyo wa munthu. Izi ndizomwe zimagwiritsidwa ntchito powonjezera manambala ambiri nthawi imodzi, komanso njira zongopeka monga SUMMESLI, yomwe imagwira ntchito zingapo zosiyanasiyana nthawi imodzi. Palinso chiwerengero chachikulu cha zinthu zina zomwe tidzayang'anitsitsa pakali pano.

Ntchito SUM

Izi ndizomwe zimagwiritsidwa ntchito kwambiri pakadali pano. Amapangidwa kuti aziphatikiza manambala mosinthanasinthana pakati pawo. Mafotokozedwe a ntchitoyi ndi ophweka kwambiri ndipo ali ndi mfundo zosachepera ziwiri - manambala kapena maumboni a maselo, zomwe zimafunikira. Monga mukuonera, sikoyenera kulemba manambala m'mabokosi, ndizothekanso kulowa maulalo. Pankhaniyi, mutha kufotokoza adilesi ya selo pamanja komanso nthawi yomweyo patebulo podina pa cell yofananira pambuyo poti cholozera chayikidwa m'munda wolowetsa. Mkangano woyamba ukalowetsedwa, ndikokwanira kukanikiza batani la Tab kuti muyambe kudzaza lotsatira.

SUMMESLI

Pogwiritsa ntchito mafomu omwe ntchitoyi idalembedwa, wogwiritsa ntchito amatha kuwerengera kuchuluka kwazinthu zomwe zimakwaniritsa zinthu zina. Athandizira kusankha kwazinthu zomwe zimagwirizana ndi njira zina. Fomula ikuwoneka motere: =SUMIF(Range, Criteria, Sum_Range). Tikuwona kuti magawo angapo amaperekedwa ngati magawo a ntchitoyi:

1. Mtundu wa ma cell. Izi zikuphatikiza ma cell omwe akuyenera kuyang'aniridwa motsutsana ndi zomwe zafotokozedwa mumtsutso wachiwiri.
2. Mkhalidwe. Mkhalidwe womwewo, womwe mulingo womwe wafotokozedwa mkangano woyamba udzawunikidwa. Zomwe zingatheke ndi izi: zazikulu kuposa (chizindikiro >), zochepa kuposa (chizindikiro <), osati zofanana (<>).
3. Chiwerengero cha mafotokozedwe. Mndandanda womwe udzafotokozedwe mwachidule ngati mkangano woyamba ukugwirizana ndi chikhalidwecho. The osiyanasiyana maselo ndi mwachidule angakhale yemweyo.

Mtsutso wachitatu ndi wosankha.

ntchito PRIVATE

Nthawi zambiri, ogwiritsa ntchito amagwiritsa ntchito njira yokhazikika yogawa manambala awiri kapena kuposerapo. Chizindikiro / chimagwiritsidwa ntchito popanga masamu. Kuipa kwa njirayi ndi kofanana ndi kugwiritsa ntchito ma masamu pamanja. Ngati kuchuluka kwa deta ndikwambiri, kumakhala kovuta kuwerengera molondola. Mutha kusintha magawano pogwiritsa ntchito ntchitoyi PRIVATE. Syntax yake ndi iyi: = GAWO(Nambala, Denominator). Monga mukuonera, tili ndi mfundo ziwiri zazikuluzikulu apa: nambala ndi denominator. Amafanana ndi manambala akale a masamu ndi denominator.

ntchito PRODUCT

Izi ndizosiyana ndi ntchito yapitayi, yomwe imapanga kuchulukitsa kwa manambala kapena mizere yomwe yalowetsedwa pamenepo ngati mikangano. Mofanana ndi ntchito zofananira zam'mbuyomu, izi zimapangitsa kuti zitheke kulowetsa zambiri osati za manambala enieni, komanso mizere yokhala ndi manambala.

ntchito ROUNDWOOD

Kuzungulira ndi chimodzi mwazochita zodziwika kwambiri m'mbali zosiyanasiyana za moyo wamunthu. Ndipo ngakhale kukhazikitsidwa kwaukadaulo wamakompyuta sikuli kofunikira monga kale, chilinganizochi chikugwiritsidwabe ntchito kubweretsa nambala mu mawonekedwe okongola omwe alibe malo ambiri owerengera. Pansipa mutha kuwona momwe ma generic syntax a formula yogwiritsira ntchito ntchitoyi ikuwonekera: =ROUND(nambala,nambala_manambala). Tikuwona kuti pali mikangano iwiri apa: nambala yomwe idzakhala yozungulira komanso chiwerengero cha manambala omwe adzawonekere kumapeto.

Kuzungulira ndi mwayi wabwino wopangitsa moyo kukhala wosavuta kwa owerenga spreadsheet ngati kulondola sikuli kofunikira. Mwamtheradi ntchito iliyonse yachizoloŵezi imalola kugwiritsa ntchito kuzungulira, chifukwa m'zochitika za tsiku ndi tsiku ndizosowa kuchita zinthu zomwe mukufunikira kuwerengera molondola chiwerengero cha zikwi zana. Izi zimazungulira nambala molingana ndi malamulo okhazikika,

ntchito MPHAMVU

Oyamba ogwiritsa ntchito a Excel nthawi zambiri amadabwa momwe angakwezere nambala ku mphamvu. Pachifukwa ichi, njira yosavuta imagwiritsidwa ntchito, yomwe imachulukitsa nambala yokhayokha nthawi zina. Lili ndi mfundo ziwiri zofunika: =MPHAMVU(nambala, mphamvu). Monga momwe mukuonera kuchokera ku syntax, mkangano woyamba umakulolani kufotokoza nambala yomwe idzachulukitsidwe kangapo. Mtsutso wachiwiri ndi mlingo umene udzakwezedwe.

ntchito muzu

Ntchitoyi imakupatsani mwayi wodziwa masikweya a mtengo woperekedwa m'makolo. Fomula template ikuwoneka motere: =MUZI(nambala). Mukalowetsa fomuyi kudzera m'bokosi lolowera, muwona kuti pali mkangano umodzi wokha womwe uyenera kulowetsedwa.

ntchito LOG

Iyi ndi ntchito ina ya masamu yomwe imakupatsani mwayi wowerengera logarithm ya nambala inayake. Zimatengera zifukwa ziwiri kuti zigwire ntchito: nambala ndi maziko a logarithm. Mtsutso wachiwiri ndi wosankha. Pankhaniyi, mtengowo utenga womwe wakonzedwa mu Excel monga womwe umatchulidwa mwachisawawa. Ndiko kuti, 10.

Mwa njira, ngati mukufuna kuwerengera decimal logarithm, mutha kugwiritsa ntchito LOG10.

ntchito ZONSE

Ngati simungathe kugawa nambala imodzi ndi ina kuti zotsatira zake zikhale nambala, ndiye kuti nthawi zambiri mumayenera kupeza yotsalayo. Kuti muchite izi, muyenera kulowa fomula =REMAID(nambala, wogawa). Tikuwona kuti pali mikangano iwiri. Yoyamba ndi nambala yomwe ntchito yogawa imachitika. Chachiwiri ndi divisor, mtengo womwe nambala imagawikana. Mutha kuyika fomulayi mwina poyika zikhalidwe zoyenera m'mabulaketi mukalowa pamanja, kapena kudzera pa wizard yolowera.

Mfundo yochititsa chidwi: kugwira ntchito kwa magawano ndi otsala kumatchedwanso kuti magawo onse ndipo ndi gulu lapadera la masamu. Amadziwikanso kuti magawano a modulo. Koma pochita, mawu oterowo amapewa bwino, chifukwa chisokonezo mu terminology ndi chotheka.

Masamu osatchuka kwambiri

Zina mwazinthu sizodziwika kwambiri, komabe adalandiridwabe. Choyamba, iyi ndi ntchito yomwe imakupatsani mwayi wosankha nambala mwachisawawa munjira inayake, komanso yomwe imapanga nambala yachiroma kuchokera ku nambala yachiarabu. Tiyeni tione mwatsatanetsatane.

ntchito PAKATI PA Mlandu

Ntchitoyi ndi yosangalatsa chifukwa imawonetsa nambala iliyonse yomwe ili pakati pa mtengo A ndi mtengo B. Amakhalanso mikangano yake. Mtengo A ndi malire apansi a chitsanzo, ndipo mtengo B ndi malire apamwamba.

Palibe manambala mwachisawawa kwathunthu. Zonsezi zimapangidwa motsatira ndondomeko zina. Koma izi sizikhudza kugwiritsa ntchito chilinganizochi, mfundo yosangalatsa chabe.

ntchito NOVELI

Nambala yokhazikika yomwe imagwiritsidwa ntchito mu Excel ndi Chiarabu. Koma mutha kuwonetsanso manambala mumtundu waku Roma. Kuti muchite izi, mungagwiritse ntchito ntchito yapadera yomwe ili ndi zifukwa ziwiri. Loyamba ndi lofotokoza za selo lomwe lili ndi nambala, kapena nambala yomwe. Mtsutso wachiwiri ndi mawonekedwe.

Ngakhale kuti manambala achiroma salinso ofala monga analili kale, nthawi zina amagwiritsidwabe ntchito mu . Makamaka, mawonekedwe awa oyimira ndi ofunikira muzochitika zotere:

1. Ngati mukufuna kulemba zaka zana kapena chikwi. Pankhaniyi, kujambula mawonekedwe ndi motere: XXI zaka kapena II millennium.
2. Kulumikizana kwa mneni.
3. Если было несколько монархов с одним именем, то римское число обозначает его порядковый номер.
4. Kusankhidwa kwa Corps mu Armed Forces.
5. On a military uniform in the Armed Forces, the blood type is recorded using Roman numerals so that a wounded unknown soldier can be saved.
6. Manambala a mapepala amawonetsedwanso m'mawerengero achiroma kuti maumboni omwe ali m'mawuwo asafunikire kuwongolera ngati mawu oyamba asintha.
7. Kupanga chizindikiro chapadera cha ma dials kuti muwonjezere zosoweka.
8. Kufotokozera nambala ya seriyoni ya chinthu chofunikira, lamulo kapena chochitika. Mwachitsanzo, Nkhondo Yadziko II.
9. Mu chemistry, manambala achiroma amatanthauza kuthekera kwa zinthu zamakhemikolo kupanga kuchuluka kwa maubwenzi ndi zinthu zina.
10. Mu solfeggio (ichi ndi chilango chomwe chimaphunzira kapangidwe ka nyimbo ndikukulitsa khutu la nyimbo), manambala achiroma amasonyeza chiwerengero cha sitepe mumtundu wa mawu.

Manambala achiroma amagwiritsidwanso ntchito powerengetsera kuti alembe nambala ya mawuwo. Chifukwa chake, kusiyanasiyana kwa manambala achi Roma ndikokulirapo.

Сейчас почти не спользуются те форматы даты, которые дразумевают в видео римских цифр, komanso kubweza kukhutitsidwa kwapadziko lonse lapansi. Ситуации, в которых используются римские цифры, могут отличаться в разных странах. Mwachiyelezgero, mu Литве они активно используются на дорожных знаках, для обозначения дней недели, а также на витринах.

Nthawi yoti tifotokoze mwachidule. Mafomu a Excel ndi mwayi wabwino kuti moyo wanu ukhale wosavuta. Masiku ano tapereka TOP ya ntchito zodziwika bwino za masamu m'maspredishithi omwe amakulolani kuti mugwire ntchito zambiri. Koma pofuna kuthetsa mavuto enaake, mafomula apadera amakhala oyenerera bwino.