Microsoft Excel imagwiranso ntchito deta. Pochita magawano kapena kugwira ntchito ndi nambala zochepa, pulogalamuyi ikuzungulira. Izi makamaka chifukwa chakuti nambala yeniyeni yopanda malire ndi yosafunika kwenikweni, koma sizili bwino kugwira ntchito ndi chiwonetsero chophweka ndi malo angapo osankha. Kuphatikiza apo, pali manambala omwe sali oyendetsedwa molondola. Koma, panthawi imodzimodziyo, kuzungulira kosakwanira kungabweretse ku zolakwika zazikulu m "mene zinthu zimakhala zoyenera. Mwamwayi, mu Microsoft Excel, ogwiritsira okha akhoza kukhazikitsa momwe zingati zidzakhalire.
Sungani manambala mu Memory Memory
Nambala zonse zomwe Microsoft Excel zimagwira zimagawidwa kukhala zenizeni ndi zofanana. Mawerengero mpaka ma 15 ali kusungidwa mu kukumbukira, ndipo amawonetsedwa mpaka chiwerengero chimene wophunzira mwiniyo amasonyeza. Koma, panthawi yomweyi, ziwerengero zonse zimagwiridwa molingana ndi deta yosungidwa, osati kuwonetsedwa pazitsulo.
Pogwiritsa ntchito ntchito yozungulira, Microsoft Excel imataya malo enaake omwe amasintha. Mu Excel, njira yodzigwiritsira ntchito yowonongeka imagwiritsidwa ntchito, pamene chiwerengero chocheperapo ndichisanu chikuphwanyidwa, ndi chachikulu kapena chofanana ndi 5 - mmwamba.
Kuzungulira ndi mabatani pa mpiru
Njira yosavuta yosintha chiwerengero cha nambala ndiyo kusankha selo kapena magulu a maselo, ndipo pakakhala pakhomo la Kanyumba, dinani pa kaboni pa "Kuonjezera Digitality" kapena "Chopitsa Digitality". Mabatani onsewa ali mu bokosi la "Number". Pachifukwa ichi, nambala yokonzedweratu idzakhala yozungulira, koma kuwerengera, ngati kuli kofunikira, mpaka manambala khumi ndi khumi ndi awiri adzaphatikizidwa.
Mukasindikiza pa batani "Pitirizani kukula kwapang'ono", chiwerengero cha zilembo zolembedwera mutatha kukweza komiti imodzi.
Mukamalemba pa batani "kuchepetsani pang'ono" chiwerengero cha chiwerengero pambuyo poti decimal yafupika ndi imodzi.
Kupyolera mu selo mtundu
Mutha kukhazikitsa zozungulira pogwiritsa ntchito maofesi apangidwe. Pachifukwachi, muyenera kusankha maselo ambiri pa pepala, dinani botani lamanja la mbewa, ndipo mu menu yomwe yapezeka, sankhani chinthu "Chigawo cha maselo".
Muwindo lotseguka la mawonekedwe a selo, pitani ku tab "Number". Ngati mtundu wa deta siwunambala, ndiye kuti muzisankha mawerengedwe a chiwerengero, mwinamwake simungathe kusintha kusintha. Pakatikati pazenera pafupi ndi kulembedwa "Chiwerengero cha malo apamwamba" timangosonyeza ndi chiwerengero chiwerengero cha zilembo zomwe tikufuna kuziwona. Pambuyo pake, dinani pakani "OK".
Ikani kuwerengera molondola
Ngati mavoti apitawo, magawo omwe adayikawo amangotengera mawonedwe a kunja, ndipo zizindikiro zolondola (mpaka 15) zimagwiritsidwa ntchito pazowerengero, tsopano tikukuuzani momwe mungasinthire kulondola kwa ziwerengerozo.
Kuti muchite izi, pitani ku "Fayilo" tab. Kenako, pita ku gawo la "Parameters".
Fayilo la Excel zosankha limatsegula. Muwindo ili, pitani ku gawo lakuti "Advanced". Tikuyang'ana malo ochezera omwe amatchedwa "Pamene akuwerenganso bukuli." Zokonzera kumbali iyi zikugwiritsidwa ntchito ku mapepala onse, koma ku bukhu lonse lonse, ndiko, ku fayilo yonse. Timayika kutsogolo kwa "parameter" monga "pazenera." Dinani ku batani "OK" yomwe ili kumbali ya kumanzere kwawindo.
Tsopano, pakuwerengetsa deta, mtengo wamtengo wapatali wa nambala yomwe ili pazenera idzaganiziridwa, osati zomwe zasungidwa m'kumbukumbu la Excel. Kusintha kwa nambala yosonyezedwa kungakhoze kuchitidwa mwa njira iliyonse, yomwe ife takambirana pamwambapa.
Kugwiritsa ntchito ntchito
Ngati mukufuna kusintha mtengo wozungulira powerengera limodzi ndi maselo angapo, koma simukufuna kuchepetsa kuwerengera kwa chiwerengero chonsecho, ndiye kuti ndibwino kugwiritsa ntchito mwayi woperekedwa ndi ntchito ya ROUND ndi zosiyana zake, komanso zina zina.
Pakati pa ntchito zazikulu zomwe zimayendera kuzungulira, zotsatirazi ziyenera kufotokozedwa:
- ROUND - kuzungulira ku chiwerengero cha malo osungira, malinga ndi malamulo ovomerezeka omwe amavomerezedwa;
- ROUND-UP - kuzungulira mpaka pafupi nambala mmwamba moduli;
- ROUNDDOWN - kuzungulira kufupi ndi nambala pansi pa module;
- RING - imazungulira chiwerengerocho ndi kulongosola kolondola;
- OKRVVERH - kuzungulira nambalayi ndichindunji pamutu;
- OKRVNIZ - kuzungulira nambala yomwe ili pansiyo ndi kuperekedwa molondola;
- OTBR - kuzungulira deta ku nambala;
- CHETN - imazungulira deta kupita kufupi kapena nambala;
- Zosamvetsetseka - kuzungulira deta ku nambala yosakayika yapafupi.
Pogwiritsa Ntchito ROUND, ROUNDUP ndi ROUNDDOWN, mawonekedwe otsatirawa ndi awa: "Dzina la ntchito (chiwerengero; chiwerengero). Izi ndizo, kuti, ngati mukufuna kufotokoza chiwerengero cha 2.56896 mpaka ma dijiti zitatu, ndiye gwiritsani ntchito ROUND (2.56896; 3). Zotsatira zake ndi nambala 2.569.
Mndandanda wotsatirawu umagwiritsidwa ntchito pa ROUNDCASE, OKRVVER ndi OKRVNIZ: "Dzina la ntchitoyi (nambala; molondola)". Mwachitsanzo, pozungulira chiwerengero cha 11 mpaka pafupipafupi 2, yambani ntchito ya ROUND (11; 2). Zotsatira zake ndi nambala 12.
Ntchito OTBR, CHETN ndi OUT OF amagwiritsa ntchito njira zotsatirazi: "Dzina la ntchito (nambala)". Kuti muyandikire nambala 17 mpaka pafupi, mugwiritseni ntchito CHETN (17). Timapeza nambala 18.
Ntchitoyi ingathe kulowa ponseponse mu selo ndi m'ndondomeko ya ntchito, mutasankha selo yomwe idzapezeka. Ntchito iliyonse iyenera kutsogoleredwa ndi "=" chizindikiro.
Pali njira yosiyana yofotokozera ntchito zozungulira. Ndiwothandiza makamaka pamene pali tebulo ndi mfundo zomwe ziyenera kukhala ziwerengero zozungulira m'magulu osiyana.
Kuti muchite izi, pitani ku tab "Ma formula". Dinani pa batani "Masamu". Kenako, m'ndandanda yomwe imatsegulira, sankhani ntchito yomwe mukufuna, mwachitsanzo ROUND.
Pambuyo pake, ntchito yowonekera zowatsegula. Mu "Nambala", mungathe kulemba manambala, koma ngati tifuna kuyendetsa deta yonseyo, ndiye dinani pa batani kumanja kwazenera pazenera.
Ntchito yotsutsana zenera ikuchepetsedwa. Tsopano mukuyenera kutsegula pa selo lapamwamba la mndandanda, deta yomwe titi tipeze. Pambuyo mtengowo utalowa m'zenera, dinani pa batani kupita kumanja kwa mtengo uwu.
Ntchito yotsutsana zenera ikutsegulanso. Mu "Number of digits" munda timalemba mozama zomwe tikufunika kuti tipewe tizigawo ting'onoting'ono. Pambuyo pake, dinani pakani "OK".
Monga mukuonera, chiwerengerocho chatsopano. Kuti tilembetse deta zonse zomwe tikuzifuna mofanana, timasuntha chithunzithunzi kumbali ya kumanja ya selo ndi mtengo wozungulira, dinani kubokosi lakumanzere, ndipo yesani mpaka kumapeto kwa tebulo.
Pambuyo pake, malingaliro onse m'mbali yomwe mukufuna idzapangidwa.
Monga mukuonera, pali njira zazikulu ziwiri zoyendetsera chiwonetsero cha nambala: pogwiritsa ntchito batani pa tepi, ndi kusintha kusintha kwa maselo. Kuwonjezera apo, mutha kusintha kusintha kwa deta yomwe ilipo. Izi zikhozanso kuchitidwa mwa njira ziwiri: pakusintha mipangidwe ya bukhu lonselo, kapena kugwiritsa ntchito ntchito yapadera. Kusankhidwa kwa njira inayake kumadalira ngati mutha kugwiritsa ntchito mtundu uwu wa deta zonsezo mu fayilo, kapena kwa maselo enaake.
