Math Basic mu Excel kuwonjezera Kuchotsa, Kugawa, ndi Kuchulukitsa
M'munsimu muli mndandanda wa zolemba zomwe zimaphatikizapo masewero oyambirira a masamu ku Excel.
Ngati mukufuna kudziwa kuwonjezera, kuchotsa, kuchulukana, kapena kugawa ziwerengero mu Excel, nkhani zomwe zili pansipa zikuwonetsani momwe mungapangire ma formula kuti muchite zimenezo.
Momwe Mungatulutshire mu Excel
Mitu yophimbidwa:
- Momwe mungatulutse manambala pogwiritsa ntchito fomu ;
- Chitsanzo chotsatira ndichitsulo chokhazikitsa chikhomo chochotsa mu Excel pogwiritsa ntchito mfundo ndi kudula ;
- Chifukwa chogwiritsa ntchito ma selo am'chipindachi chidzakupangitsani kusinthasintha mawerengedwe anu ngati deta yanu isintha.
Momwe Mungagawire Mu Excel
Mitu yophimbidwa:
- Momwe mungagawire manambala awiri pogwiritsa ntchito fomu;
- Chitsanzo choyendetsa pang'onopang'ono chokhazikitsa chigawo chogawanitsa mu Excel pogwiritsa ntchito mfundo ndi kudula;
- Chifukwa chiyani kugwiritsa ntchito ma selo opangidwira kuti zikhale zosavuta kusintha mawerengero anu ngati deta yanu isintha;
Momwe Mungayambire mu Excel
Mitu yophimbidwa:
- Mmene mungachulukire nambala ziwiri pogwiritsa ntchito fomu;
- Chitsanzo chotsatira ndichitsulo chokhazikitsa njira yowonjezera mu Excel pogwiritsa ntchito mfundo ndi kudula;
- Chifukwa chogwiritsa ntchito ma selo am'chipindachi chidzakupangitsani kusinthasintha mawerengedwe anu ngati deta yanu isintha.
Momwe mungawonjezere mu Excel
Mitu yophimbidwa:
- Mmene mungawonjezere manambala awiri pogwiritsa ntchito fomu;
- Chitsanzo choyendetsedweratu chopanga kuwonjezera pa Excel pogwiritsira ntchito mfundo ndi kudula;
- Chifukwa chogwiritsa ntchito ma selo am'chipindachi chidzakupangitsani kusinthasintha mawerengedwe anu ngati deta yanu isintha.
Kusintha Lamulo la Ntchito mu Excel Formula
Mitu yophimbidwa:
- Lamulo la Ntchito Ma pulogalamuyi amawatsatira pamene akufufuza njira
- Mmene mungasinthire dongosolo la ntchito mu mafomu
Otsogolera mu Excel
Ngakhale osagwiritsidwa ntchito mochepa kusiyana ndi a masamu omwe adatchulidwa pamwambapa, Excel amagwiritsa ntchito khalidwe lachikondi
( ^ ) monga wogwiritsira ntchito mwachindunji.
Otsogolera nthawi zina amawatcha kuti kuchulukanso mobwerezabwereza kuyambira nthawi yowonjezera - kapena mphamvu monga momwe imatchulidwira nthawi zina - imasonyeza nthawi zingati nambala yowerengera iyenera kuchulukitsidwa yokha.
Mwachitsanzo, zojambula 4 4 (2) (zowonjezera zinayi) - zili ndi chiwerengero chachinayi chachinayi, ndipo chimasuliridwa ku mphamvu ziwiri.
Mulimonsemo, njirayi ndi njira yaying'ono yonena kuti chiwerengero choyambira chiyenera kuwonjezeka palimodzi kawiri (4 × 4) kuti chikhale ndi zotsatira za 16.
Mofananamo, 5 ^ 3 (cubing) amasonyeza kuti nambala 5 iyenera kuchulukana pamodzi katatu (5 x 5 x 5) kuti apereke yankho la 125.
Ntchito ya Math Excel
Kuphatikiza pa ma masamu omwe ali pamwambawa, Excel ili ndi ntchito zambiri - zida zomangidwa - zomwe zingagwiritsidwe ntchito kuchita masabata ambiri.
Ntchito izi zikuphatikizapo:
Ntchito ya SUM - imapangitsa kuti kukhale kosavuta kuwonjezera zipilala kapena mizere ya manambala;
Ntchito PRODUCT - imachulukitsa nambala ziwiri kapena zambiri pamodzi. Powonjezera manambala awiri, njira yowonjezera ndi yophweka;
Ntchito ya QUOTIENT - imabwereranso kubwezeretsa integer gawo (nambala yokha) ya ntchito yogawa;
Ntchito ya MOD - imabwereranso ntchito yotsalira yotsutsana.