Nthawi zambiri, pakati pa magulu omwe alipo, ogwiritsa ntchito Excel amatchula masamu. Mothandizidwa ndi iwo n'zotheka kupanga ziwerengero zosiyanasiyana za masamu ndi algebraic. Nthawi zambiri amagwiritsidwa ntchito pokonzekera ndi kuwerengetsa sayansi. Timaphunzira zomwe gulu lonse la ogwira ntchito likuyimira komanso mwatsatanetsatane tidzakumbukira anthu otchuka kwambiri.
Kugwiritsa ntchito masamu kumagwira ntchito
Pothandizidwa ndi ntchito za masamu mungathe kupanga zowerengera zosiyanasiyana. Zidzakhala zopindulitsa kwa ophunzira ndi ana a sukulu, injini, asayansi, owerengetsera ndalama, okonza mapulani. Gululi likuphatikizapo oposa 80 ogwira ntchito. Tidzakambirana mwatsatanetsatane za khumi zomwe zimatchuka kwambiri.
Mukhoza kutsegula mndandanda wamakalata a masamu m'njira zingapo. Njira yosavuta yothetsera ntchito ya wizara ndiyokudalira pa batani. "Ikani ntchito"yomwe ili kumanzere kwa bar. Pankhaniyi, choyamba muyenera kusankha selo kumene zotsatira za kusinthidwa kwa deta ziwonetsedwe. Njira iyi ndi yabwino chifukwa ikhoza kukhazikitsidwa kuchokera pa tabu iliyonse.
Mukhozanso kukhazikitsa Wowonjezera Ntchitoyo popita ku tabu "Maonekedwe". Kumeneko muyenera kukanikiza batani "Ikani ntchito"ili pambali yakumanzere ya tepi mu bokosi lazamasamba "Laibulale ya Ntchito".
Pali njira yachitatu yogwiritsira ntchito wizara. Ikuchitidwa mwa kukanikiza kuphatikizira kwachinsinsi pa kibokosi. Shift + F3.
Pambuyo pa wogwiritsa ntchito iliyonse yamtunduwu, Funs Wizard yatsegula. Dinani pawindo pa munda "Gulu".
Mndandanda wotsika. Sankhani malo mmenemo "Masamu".
Pambuyo pake, mndandanda wa ntchito zonse za masamu ku Excel ikuwonekera pawindo. Kuti mupite kumayambiriro kwa ndemanga, sankhani chimodzi mwachindunji ndikusindikiza pa batani "Chabwino".
Palinso njira yosankhira olemba masamu popanda kutsegula zenera lalikulu la Wothandizira Wothandizira. Kuti muchite izi, pitani ku kabuku kakang'ono kozoloŵera. "Maonekedwe" ndipo dinani pa batani "Masamu"ili pa tepi mu zida zamagulu "Laibulale ya Ntchito". Mndandanda umatsegulidwa kuchokera pamene muyenera kusankha njira yothetsera ntchito inayake, kenako zowonekera zowonekera.
Komabe, ziyenera kudziwika kuti sizinthu zonse za gulu la masamu zomwe zalembedwa mndandandawu, ngakhale ambiri a iwo ali. Ngati simukupeza wothandizira amene mukufuna, ndiye dinani pa chinthucho "Ikani ntchito ..." pansi pa mndandanda, pambuyo pake Mbuye wa ntchito, omwe amadziwika kale ndi ife, adzatsegulidwa.
Phunziro: Wowonjezera Wogwira Ntchito
SUM
Ntchito yogwiritsidwa ntchito kwambiri SUM. Wogwiritsa ntchitoyi ndi cholinga chowonjezera deta m'maselo angapo. Ngakhale zikhoza kugwiritsidwa ntchito pamasamba achizoloŵezi. Mawu omasuliridwa omwe angagwiritsidwe ntchito polemba ndondomeko ndi awa:
= SUM (nambala1; nambala2; ...)
Muwindo lamatsutso, lowetsani dera la deta kapena zowonongeka m'minda. Wogwiritsira ntchito amawonjezera zinthuzo ndi kusonyeza chiwerengero chonse mu selo losiyana.
Phunziro: Momwe mungawerengere ndalama mu Excel
Miyeso
Woyendetsa Miyeso Komanso amawerengetsera chiwerengero cha manambala m'maselo. Koma, mosiyana ndi ntchito yapitayi, mu woyendetsa ntchitoyi, mungathe kukhazikitsa chikhalidwe chimene chidzatsimikizire kuti ndi chikhalidwe chiti chomwe chimawerengedwa, ndi zomwe siziri. Pofotokoza mkhalidwewu, mukhoza kugwiritsa ntchito zizindikiro ">" ("zambiri"), "<" ("pansi"), "" ("osalingana"). Ndiko kuti, chiwerengero chomwe sichikugwirizana ndi chikhalidwe chodziwika sichinayang'anidwe mu mtsutso wachiwiri pakuwerengera ndalamazo. Komanso, pali kutsutsana kwina "Chiwerengero cha Kusambira"koma silololedwa. Ntchitoyi ili ndi mawu ofanana nawo:
= SUMMESLES (Mtunda; Criterion; Range_Summing)
ROUND
Monga tingathe kumvetsetsa kuchokera ku dzina la ntchito ROUNDZimagwira manambala ozungulira. Mtsutso woyamba woyendetsa ntchitoyi ndi nambala kapena kutanthauza selo lokhala ndi chiwerengero cha chiwerengero. Mosiyana ndi zina zambiri, ntchitoyi siingakhale yamtengo wapatali. Kukangana kwachiwiri ndi chiwerengero cha malo osungirako. Kuzungulira kumapangidwa malinga ndi malamulo ambiri a masamu, ndiko kuti, kwa nambala yapafupi ya modulo. Mawu omasuliridwa awa ndi awa:
= ROUND (nambala; ziwerengero)
Komanso, mu Excel, pali ntchito monga ROUNDUP ndi CIRCLEyomwe imakhala yowerengeka mpaka kufupi kwambiri ndi yaying'ono pamtengo wapatali.
Phunziro: Nambala zozungulira zambiri
KUPANGA
Ntchito yogwira ntchito DZIWANI ndi kuchulukitsa kwa manambala payekha kapena zomwe ziri mu maselo a pepala. Zokambirana za ntchitoyi ndizofotokozera maselo omwe ali ndi deta yowonjezera. Mpaka 255 zilankhulo zotere zingagwiritsidwe ntchito. Zotsatira za kuchulukitsa zikuwonetsedwa mu selo losiyana. Chidule cha mawu awa ndi:
= KUKHALA (nambala; nambala; ...)
Phunziro: Momwe mungachulukire moyenera mu Excel
ABS
Kugwiritsa ntchito masamu ABS Iwerengera nambala ya gawoli. Mawu awa ali ndi kutsutsana kumodzi - "Nambala"ndiko kuti, kutanthawuza ku selo lokhala ndi chiwerengero cha chiwerengero. Zosiyana pazochitika za mkangano sangathe kuchita. Chidule chake ndi:
= ABS (nambala)
Phunziro: Excel module ntchito
ZINTHU
Kuchokera pa dzina ilo likuwonekera kuti ntchito ya woyendetsa ZINTHU ndikumanga chiwerengero ku digiti. Ntchitoyi ili ndi zifukwa ziwiri: "Nambala" ndi "Degree". Choyamba chikhoza kufotokozedwa ngati kutanthauza selo lokhala ndi chiwerengero cha chiwerengero. Kukangana kwachiwiri kumasonyeza kukula kwake. Kuchokera pa zomwe tatchulazi zikutsatiranso kuti mawu ofanana ndi awa:
= ZOFUNIKA (nambala; digiri)
Phunziro: Momwe mungakwezere digiri ku Excel
MALO
Ntchito yogwira ntchito MALO ali ndi mizere yambiri. Wogwira ntchitoyi ali ndi kukangana kokha - "Nambala". M'ntchito yake ikhoza kutanthauza selo yomwe ili ndi deta. Syntax imatenga mawonekedwe awa:
= ROOT (nambala)
Phunziro: Momwe mungawerengere muzu mu Excel
ZINTHU
Njirayi ili ndi ntchito yeniyeni. ZINTHU. Icho chimaphatikizapo kutulutsira ku selo lolankhulidwa nambala iliyonse yomwe ilipo pakati pa manambala awiri operekedwa. Kuchokera kufotokozera momwe ntchitoyi ikugwiritsidwira ntchito, zikuwonekeratu kuti mfundo zake ndizomwe zili pamwamba ndi pamunsi pa nthawiyi. Mawu ake ndi:
= CHASE (Lower_boundary; Upper_boundary)
PRIVATE
Woyendetsa PRIVATE ankagawa magawo. Koma mu zotsatira za kugawa, izo zimangosonyeza nambala yokha, yowerengeka ndi nambala yaing'ono. Zokambirana zayiyi ndizofotokozera maselo omwe ali ndi magawano ndi ogawa. Mawu omasulira ndi awa:
= PRIVATE (Numerator; Denominator)
Phunziro: Gawani njira mu Excel
ROMAN
Ntchitoyi ikukuthandizani kuti mutembenuzire ziwerengero zachiarabu, zomwe Excel ikugwira ntchito mwachisawawa, kukhala nambala zachiroma. Wogwiritsira ntchitoyi ali ndi zifukwa ziwiri: kutanthawuzira kwa selo ndi nambala yoti isinthidwe ndi mawonekedwe. Mgwirizano wachiwiri ndi wosankha. Chidule chake ndi:
= ROMAN (Nambala; Fomu)
Pamwamba, ntchito yodziwika kwambiri ya Excel masamu yakhala ikufotokozedwa. Zimathandizira kuti zikhale zosavuta kuziwerengera pulogalamuyi. Pothandizidwa ndi njirazi, mukhoza kupanga masamu awiri owerengeka komanso ovuta kwambiri. Makamaka amathandizira panthawi yomwe mukufunika kupanga mawerengero ambirimbiri.
