Momwe mungazungulire nambala mu Excel. Mawonekedwe a manambala kudzera pazosankha, kuyika zolondola, zowonetsera

Spreadsheet Excel ili ndi magwiridwe antchito ambiri omwe amakulolani kuti muzitha kusintha zinthu zosiyanasiyana pogwiritsa ntchito manambala. Nthawi zambiri zimachitika kuti pochita zinthu zosiyanasiyana, magawo ang'onoang'ono amachotsedwa. Ichi ndi chinthu chothandiza kwambiri, chifukwa ntchito zambiri mu pulogalamuyi sizifuna zotsatira zolondola. Komabe, pali kuwerengera koteroko komwe kuli koyenera kusunga kulondola kwa zotsatira, popanda kugwiritsa ntchito kuzungulira. Pali njira zambiri zogwirira ntchito ndi manambala ozungulira. Tiyeni tione zonse mwatsatanetsatane.

Momwe manambala amasungidwira mu Excel ndikuwonetsedwa pazenera

Ndondomeko ya spreadsheet imagwira ntchito pa mitundu iwiri ya chidziwitso cha manambala: pafupifupi ndi yeniyeni. Munthu amene amagwira ntchito mkonzi wa spreadsheet akhoza kusankha njira yowonetsera chiwerengero cha chiwerengero, koma mu Excel palokha, deta ili mu mawonekedwe enieni - mpaka zilembo khumi ndi zisanu pambuyo pa decimal. Mwa kuyankhula kwina, ngati chiwonetsero chikuwonetsa deta mpaka malo awiri a decimal, ndiye kuti spreadsheet imatanthawuza zolemba zolondola kwambiri pamtima panthawi yowerengera.

Mutha kusintha mawonedwe a zidziwitso zama manambala pachiwonetsero. Njira yozungulira ikuchitika motsatira malamulo otsatirawa: zizindikiro kuchokera ku zero mpaka zinayi zophatikizidwa zimazunguliridwa pansi, ndipo kuyambira zisanu mpaka zisanu ndi zinayi - mpaka zazikulu.

Zofunikira pakuzungulira manambala a Excel

Tiyeni tione mwatsatanetsatane njira zingapo zofotokozera manambala.

Kuzungulira ndi Mabatani a Riboni

Ganizirani njira yosavuta yozungulira yozungulira. Malangizo atsatanetsatane amawoneka motere:

1. Timasankha selo kapena ma cell angapo.
2. Timapita ku gawo la "Home" ndipo mu "Nambala" ya malamulo, dinani LMB pa "Decrease bit deep" kapena "Onjezani kuya" chinthu. Ndizofunikira kudziwa kuti ziwerengero zosankhidwa zokha zidzazunguliridwa, koma mpaka manambala khumi ndi asanu a chiwerengerocho amagwiritsidwa ntchito powerengera.
3. Kuwonjezeka kwa zilembo ndi m'modzi pambuyo pa koma pambuyo podina chinthu "Onjezani kuya pang'ono".

4. Kuchepetsa zilembo m'modzi kumachitika mukadina "Decrease bit deep" chinthu.

Kuzungulira Kupyolera mu Mawonekedwe a Maselo

Pogwiritsa ntchito bokosi lotchedwa "Cell Format", ndizothekanso kukhazikitsa kusintha kozungulira. Malangizo atsatanetsatane amawoneka motere:

1. Timasankha selo kapena mtundu.
2. Dinani RMB pagawo losankhidwa. Zosankha zapadera zatsegulidwa. Apa tikupeza chinthu chotchedwa "Format Cells ..." ndikudina LMB.

3. Zenera la Format Cells likuwonekera. Pitani ku gawo la "Number". Timatchera khutu ku "Numeric formats:" ndikuyika chizindikiro "Numeric". Mukasankha mtundu wina, pulogalamuyo siyitha kugwiritsa ntchito manambala ozungulira.. Pakatikati pa zenera pafupi ndi "Nambala ya malo decimal:" timayika chiwerengero cha zilembo zomwe tikufuna kuziwona panthawiyi.

4. Pamapeto pake, dinani "Chabwino" kuti mutsimikizire zosintha zonse zomwe zachitika.

Khazikitsani kulondola kwa mawerengedwe

Mu njira zomwe tafotokozazi, magawo omwe adakhazikitsidwa adakhudza kokha pakupanga kwakunja kwa manambala, ndipo powerengera, zida zolondola zidagwiritsidwa ntchito (mpaka munthu wakhumi ndi chisanu). Tiyeni tikambirane mwatsatanetsatane mmene kusintha kulondola kwa mawerengedwe. Malangizo atsatanetsatane amawoneka motere:

1. Pitani ku gawo la "Fayilo", kenako kumanzere kwa zenera latsopano timapeza chinthu chotchedwa "Parameters" ndikudina ndi LMB.

2. Bokosi lotchedwa "Zosankha za Excel" likuwonekera pachiwonetsero. Timapita ku "Advanced". Timapeza chipika cha malamulo "Pamene mukuwerengeranso bukuli." Ndikoyenera kudziwa kuti zosintha zomwe zasinthidwa zidzakhudzanso buku lonse. Ikani cholembera pafupi ndi mawu akuti "Khazikitsani kulondola ngati pazenera." Pomaliza, dinani "Chabwino" kuti mutsimikizire zosintha zonse zomwe zachitika.

3. Okonzeka! Tsopano, powerengera zambiri, mtengo wotuluka wa chiwerengero cha chiwerengero pawonetsero udzaganiziridwa, osati zomwe zimasungidwa kukumbukira pulosesa ya spreadsheet. Kukhazikitsa manambala omwe akuwonetsedwa kumachitika ndi njira iliyonse ya 2 yomwe yafotokozedwa pamwambapa.

Kugwiritsa ntchito ntchito

Chenjerani! Ngati wogwiritsa ntchito akufuna kusintha kuzungulira powerengera wachibale ndi selo limodzi kapena angapo, koma sakukonzekera kuchepetsa kulondola kwa mawerengedwe mubuku lonse la ntchito, ndiye kuti agwiritse ntchito mphamvu za ROUND.

Ntchitoyi ili ndi ntchito zingapo, kuphatikiza kuphatikiza ndi ena ogwiritsa ntchito. M'magulu akuluakulu, kuzungulira kumachitika:

• "ROUNDDOWN" - ku nambala yapafupi pansi mu modulus;
• "ROUNDUP" - mpaka mtengo wapafupi kwambiri mu modulo;
• "OKRVUP" - ndi kulondola kwatchulidwa pamwamba pa modulo;
• "OTBR" - mpaka nthawi yomwe nambalayo imakhala mtundu wathunthu;
• "ROUND" - mpaka nambala yodziwika ya zilembo molingana ndi miyezo yovomerezeka yozungulira;
• "OKRVNIZ" - ndi kulondola kwatchulidwa pansi modulo;
• "Ngakhale" - mpaka mtengo wapafupi;
• "OKRUGLT" - ndi kulondola kwatchulidwa;
• "ODD" - kumtengo wapafupi wosamvetseka.

Ogwiritsa ntchito a ROUNDDOWN, ROUND, ndi RoundUP ali ndi mawonekedwe awa: =Dzina la wogwiritsa ntchito (nambala;nambala_manambala). Tiyerekeze kuti wogwiritsa ntchito akufuna kupanga njira yozungulira pamtengo wa 2,56896 mpaka malo atatu, ndiye ayenera kulowa "=ZOCHITA (2,56896;3)”. Pomaliza, adzalandira:

Othandizira "ROUNDDOWN", "ROUND", ndi "ROUNDUP" ali ndi mawonekedwe awa: =Dzina la wogwiritsa ntchito(nambala,kulondola). Ngati wosuta akufuna kuzungulira mtengo 11 mpaka kuchulukitsa kwapafupi kwa awiri, ndiye kuti ayenera kulowa "=KUzungulira (11;2)". Pomaliza, adzalandira:

Ogwiritsa ntchito "ODD", "SELECT", ndi "EVEN" ali ndi mawonekedwe awa:  =Dzina la wogwiritsa ntchito (nambala). Mwachitsanzo, pozungulira mtengo 17 mpaka mtengo wapafupi, ayenera kulowa "= LACHITATU(17)». Pomaliza, adzalandira:

Ndikoyenera kuzindikira! Wogwira ntchitoyo akhoza kulowetsedwa mu mzere wa ntchito kapena mu selo lokha. Musanalembe ntchito mu selo, iyenera kusankhidwa pasadakhale mothandizidwa ndi LMB.

Spreadsheet ilinso ndi njira ina yolowetsamo opareshoni yomwe imakulolani kuchita ndondomeko yozungulira manambala. Ndizabwino mukakhala ndi tebulo la manambala lomwe likufunika kusinthidwa kukhala zozungulira mugawo lina. Malangizo atsatanetsatane amawoneka motere:

1. Timapita ku gawo la "Formulas". Apa tikupeza chinthu "Math" ndikudina ndi LMB. Mndandanda wautali watsegulidwa, momwe timasankha woyendetsa wotchedwa "ROUND".

2. Bokosi la zokambirana lotchedwa "Function Arguments" linawonekera pachiwonetsero. Mzere wa "Nambala" ukhoza kudzazidwa ndi chidziwitso nokha ndi zolemba pamanja. Njira ina yomwe imakupatsani mwayi wozungulira zonse ndikudina LMB pa chithunzi chomwe chili kumanja kwa gawo kuti mulembe mkangano.

3. Pambuyo podina chizindikirochi, zenera la "Function Arguments" linagwa. Timadina LMB pagawo lakumtunda kwa gawo, zomwe tikukonzekera kuzungulira. Chizindikirocho chinawonekera mubokosi lazotsutsa. Timadina LMB pa chithunzi chomwe chili kumanja kwa mtengo womwe ukuwoneka.

4. Chophimbacho chinawonetsanso zenera lotchedwa "Function Arguments". Mu mzere "Nambala ya manambala" timayendetsa mozama pang'ono, komwe ndikofunikira kuchepetsa magawo. Pomaliza, dinani chinthu "Chabwino" kutsimikizira zosintha zonse zomwe zachitika.

5. Nambala yawerengeredwa. Tsopano tikuyenera kuchita njira yozungulira ma cell ena onse mugawoli. Kuti muchite izi, sunthani cholozera cha mbewa kumunsi kumanja kwamunda ndi zotsatira zowonetsedwa, ndiyeno, pogwira LMB, tambasulani ndondomekoyi mpaka kumapeto kwa tebulo.

6. Okonzeka! Takhazikitsa ndondomeko yozungulira ma cell onse mugawoli.

Momwe mungazungulire ndi kutsika mu Excel

Tiyeni tiwone mwatsatanetsatane wogwiritsa ntchito ROUNUP. Mtsutso woyamba umadzazidwa motere: adilesi ya selo imalowetsedwa ndi chidziwitso cha manambala. Kudzaza mkangano wachiwiri kuli ndi malamulo otsatirawa: kuyika mtengo "1" kumatanthauza kuzungulira gawo la decimal mpaka gawo lonse, kuyika mtengo "2" kumatanthauza kuti pambuyo pokhazikitsa ndondomeko yozungulira padzakhala munthu mmodzi pambuyo pa decimal. , ndi zina zotero. Lowetsani mtengo wotsatirawu pamzere wolowetsa mafomula: = ZOCHITA (A1). Pomaliza timapeza:

Tsopano tiyeni tiwone chitsanzo chogwiritsa ntchito ROUNDDOWN. Lowetsani mtengo wotsatirawu pamzere wolowetsa mafomula: =ROUNDSAR(A1).Pomaliza timapeza:

Ndizofunikira kudziwa kuti ogwiritsa ntchito "ROUNDDOWN" ndi "ROUNDUP" amagwiritsidwanso ntchito kukhazikitsa njira yozungulira kusiyana, kuchulukitsa, ndi zina.

Chitsanzo cha ntchito:

Momwe mungazungulire nambala yonse mu Excel?

Ogwiritsa ntchito "SELECT" amakulolani kuti mugwiritse ntchito kuzungulira ku chiwerengero chonse ndikutaya zilembo pambuyo pa decimal point. Mwachitsanzo, taganizirani chithunzi ichi:

Ntchito yapadera ya spreadsheet yotchedwa "INT" imakulolani kubweza mtengo wonse. Pali mkangano umodzi wokha - "Nambala". Mutha kuyika manambala kapena ma cell coordinates. Chitsanzo:

Choyipa chachikulu cha wogwiritsa ntchito ndikuti kuzungulira kumangochitika pansi.

Kuti mufikire zidziwitso za manambala pamagulu onse, ndikofunikira kugwiritsa ntchito ma opareshoni omwe adaganiziridwa kale "ROUNDDOWN", "EVEN", "ROUNDUP" ndi "ODD". Zitsanzo ziwiri zogwiritsira ntchito operekera awa kuti agwiritse ntchito kuzungulira ku mtundu wonse:

Chifukwa chiyani Excel imazungulira manambala akulu?

Ngati pulogalamuyo ili ndi mtengo waukulu, mwachitsanzo 73753956389257687, ndiye kuti idzatenga mawonekedwe otsatirawa: 7,37539E + 16. Izi ndichifukwa choti gawoli lili ndi mawonekedwe a "General". Kuti muchotse mtundu uwu wa kutulutsa kwamitengo yayitali, muyenera kusintha mawonekedwe amunda ndikusintha mtundu kukhala Numeric. Kuphatikiza kiyi "CTRL + SHIFT + 1" kumakupatsani mwayi wokonza. Pambuyo popanga zoikamo, nambalayo itenga mawonekedwe olondola.

Kutsiliza

Kuchokera m'nkhaniyi, tapeza kuti ku Excel pali njira ziwiri zazikulu zozungulira mawonedwe owoneka a manambala: kugwiritsa ntchito batani lomwe lili pazida, komanso kusintha makonda amtundu wa cell. Kuphatikiza apo, mutha kukhazikitsa kusintha kozungulira kwa zidziwitso zomwe zawerengedwa. Palinso zosankha zingapo za izi: kusintha magawo a zolemba, komanso kugwiritsa ntchito masamu. Wogwiritsa ntchito aliyense azitha kusankha yekha njira yabwino kwambiri yoyenera zolinga ndi zolinga zake.