Gulu la masamu ndi ma trigonometric lili ndi pafupifupi 80 ntchito zosiyanasiyana za Excel, kuyambira kufupikitsa kofunikira ndi kuzungulira, kupita ku chiwerengero chodziwika bwino cha ntchito za trigonometric. Monga gawo la phunziroli, tiwonanso ntchito zamasamu zothandiza kwambiri mu Excel.
Za masamu ntchito SUM и SUMMESLI Mukhoza kuwerenga mu phunziro ili.
ZOCHITA ()
masamu ntchito ROUNDWOOD amakulolani kuti muzungulire mtengo ku chiwerengero chofunikira cha malo a decimal. Mukhoza kufotokoza chiwerengero cha malo a decimal mu mkangano wachiwiri. Pachithunzi chomwe chili pansipa, fomulayi imazungulira mtengo ku malo amodzi a decimal:
Ngati mtsutso wachiwiri uli ziro, ndiye kuti ntchitoyo imazungulira mtengowo mpaka nambala yapafupi:
Mtsutso wachiwiri ukhozanso kukhala wolakwika, pomwe mtengowo umazunguliridwa ku mfundo yofunikira ya decimal:
Nambala ngati 231,5 ndi ntchito ROUNDWOOD kuzungulira kuchokera ku zero:
Ngati mukufuna kuzungulira nambala mmwamba kapena pansi pamtengo wokwanira, mutha kugwiritsa ntchito ntchitoyi Chithunzi cha KRUGLVVERH и ZUNGULIRA PASI.
PRODUCT()
masamu ntchito PRODUCT amawerengera zotsatira za mikangano yake yonse.
Sitidzakambirana mwatsatanetsatane za ntchitoyi, chifukwa ndi yofanana kwambiri ndi ntchitoyi SUM, kusiyana kuli kokha m’chifuno, wina akungonena mwachidule, wachiwiri kuchulukitsa. Zambiri za SUM Mutha kuwerenga nkhaniyo Sum mu Excel pogwiritsa ntchito ntchito za SUM ndi SUMIF.
ABS ()
masamu ntchito ABS imabweretsanso mtengo wokwanira wa nambala, mwachitsanzo, gawo lake.
ntchito ABS zingakhale zothandiza powerengera masiku pakati pa madeti awiri, pamene palibe njira yodziwira kuti ndi tsiku liti lomwe ndi chiyambi ndi mapeto.
Pachithunzi chomwe chili pansipa, mizati A ndi B ikuyimira madeti, ndipo ndi iti mwa iwo yomwe ili yoyambirira komanso deti lomaliza silidziwika. Ndikofunikira kuwerengera kuchuluka kwa masiku pakati pa masiku awa. Ngati mungochotsa tsiku lina kuchokera pa tsiku limodzi, ndiye kuti kuchuluka kwa masiku kungakhale kolakwika, zomwe sizolondola kwenikweni:
Kuti tichite izi, timagwiritsa ntchito ABS:
Kulimbikira Lowani, timapeza masiku olondola:
MUZI ()
Imabweza masikweya mizu ya nambala. Nambalayo isakhale yotsutsa.
Mukhozanso kuchotsa muzu wa square mu Excel pogwiritsa ntchito exponentiation operator:
DEGREE()
Zimakulolani kuti mukweze nambala ku mphamvu yomwe mwapatsidwa.
Ku Excel, kuwonjezera pa masamuwa, mutha kugwiritsa ntchito wofotokozera:
CASEBETWEEN()
Imabweza nambala yachisawawa pakati pa zikhalidwe ziwiri zoperekedwa ngati zotsutsana. Nthawi iliyonse pepala likawerengedwanso, zikhalidwe zimasinthidwa.
Ngakhale pali ntchito zambiri za masamu mu Excel, ndi zochepa chabe zomwe zili zamtengo wapatali. Palibe chifukwa chophunzirira chilichonse nthawi imodzi, popeza zambiri sizingakhale zothandiza. Masamu omwe afotokozedwa m'phunziroli ndi ochepa kwambiri omwe angatsimikizire kuti mukugwira ntchito molimba mtima mu Excel ndipo sizidzadzaza kukumbukira kwanu ndi zambiri zosafunikira. Zabwino zonse komanso kuchita bwino pophunzira Excel!