Pulogalamu ya Microsoft Excel imagwiranso ntchito ndi kuchuluka kwa manambala. Mukamagawa kapena kugwiritsa ntchito manambala, pulogalamuyo imatha. Chifukwa chake, choyambirira, ndi chakuti manambala enieni enieni safunika kwenikweni, koma sichingakhale chothandiza kwambiri kugwiritsa ntchito mawu osavuta ndi malo angapo owerengetsa. Kuphatikiza apo, pali manambala omwe, mokomera, omwe samazunguliridwa ndendende. Koma nthawi imodzimodzi, kuzungulira mosakwanira kumatha kubweretsa zolakwika zazikulu ngati pakufunika kulondola. Mwamwayi, Microsoft Excel ili ndi kuthekera kwa ogwiritsa ntchito kukhazikitsa momwe manambala amawombera.
Kusunga manambala mu kukumbukira kwa Excel
Manambala onse omwe Microsoft Excel imagwira nawo amagawika manambala enieni komanso pafupifupi. Ma biti mpaka 15 akusungidwa kukumbukira, ndipo amawonetsedwa mpaka zotulutsidwa zomwe wogwiritsa ntchitoyo akuwonetsa. Koma, nthawi yomweyo, kuwerengera konse kumachitika malinga ndi zomwe zasungidwa mu kukumbukira, osati kuwonetsa pa polojekiti.
Pogwiritsa ntchito ntchito yozungulira, Microsoft Excel imataya malo ena ake. Excel imagwiritsa ntchito njira yovomerezeka yomwe imavomerezeka, pomwe chiwerengero chochepera 5 chimakhala chochepa, ndipo chachikulu kuposa kapena chofanana ndi 5 chakwera.
Kuzungulira ndi mabatani a Ribbon
Njira yosavuta yosinthira kuzungulira kwa chiwerengero ndikusankha khungu kapena gulu la maselo, ndipo mukadali "tab" la Home, dinani batani "Wonjezerani Bit" kapena "Kwezani Bit" pa riboni. Mabatani onsewo akupezeka m'bokosi la zida. Pankhaniyi, nambala yokha yowonetsedwa ndi yomwe izungulizidwe, koma kuwerengetsa, ngati kuli koyenera, mpaka manambala 15 adzatengedwa.
Mukadina batani "Wonjezerani kuya pang'ono", kuchuluka kwa malo omwe alowetsedwa kumawonjezeka.
Mukadina batani "Tsitsani pang'ono kuya" kuchuluka kwa manambala pambuyo poti mfundo yachepera.
Kuzungulira pamitundu yonse yam'manja
Mukhonzanso kukhazikitsa pogwiritsa ntchito mawonekedwe amnyumba. Kuti muchite izi, sankhani maselo osiyanasiyana patsamba, ndikudina kumanja, ndikusankha "Maselo Otengera" mumenyu omwe akuwoneka.
Pazenera lomwe limatsegulira, masanjidwe amtundu wa maselo omwe muyenera kupita nawo ku tabu "Nambala". Ngati mtundu wa data siwokhulupirira manambala, ndiye kuti muyenera kusankha mtundu wa manambala, apo ayi simungathe kusintha kuzungulira. Pakati penipeni pazenera pafupi ndi mawu akuti "Chiwerengero cha malo osinthika" timangosonyeza nambala ndi nambala ya zilembo zomwe tikufuna kuwona pozungulira. Pambuyo pake, dinani batani "Chabwino".
Kuwerengera molondola
Ngati m'mbuyomu, magawo omwe adakhazikitsidwa adangokhudzanso kuwonetsa kwakunja kwa deta, ndi zidziwitso zolondola (mpaka zilembo 15) zomwe zidagwiritsidwa ntchito powerengera, tsopano tikukuwuzani momwe mungasinthire kuwerengera kolondola.
Kuti muchite izi, pitani ku "Fayilo" tabu. Kenako, timapita ku gawo la "Parameter".
Tsamba la zosankha za Excel limatseguka. Pa zenera ili, pitani gawo la "Advanced". Tikufunafuna mawonekedwe omwe amatchedwa "Mukamawerengera bukuli." Zokonda mbali iyi sizigwira ntchito pa pepala limodzi, koma kwa buku lonse lathunthu, kutanthauza fayilo yonse. Timayika Chowonetserapo patsogolo pa "Set yolondola monga pazenera". Dinani pa batani la "Chabwino" lomwe lili kumunsi kwakumanzere kwa zenera.
Tsopano, mukamawerengera data, nambala yowonetsedwa pachikuto idzawerengeredwa, osati yomwe imasungidwa mu kukumbukira kwa Excel. Kukhazikitsa nambala yowonetsedwa kutha kuchitika mu njira ziwiri zilizonse, zomwe takambirana pamwambapa.
Ntchito Ntchito
Ngati mukufuna kusintha mtengo wozungulira pamene mukuwerengera maselo amodzi kapena angapo, koma simukufuna kuchepetsa kuchuluka kwa kuwerengera kwathunthu kwa chikalatacho, ndiye pankhaniyi, ndibwino kugwiritsa ntchito mwayi womwe ntchito ya ROUND imapereka komanso zosiyana zake, komanso mawonekedwe ena.
Mwa zina zazikulu zomwe zimayang'anira ntchito yozungulira, zotsatirazi ziyenera kufotokozeredwa:
- Round - mozungulira kumawerengeredwa nambala yotsimikizidwa, malinga ndi malamulo ovomerezeka;
- Round - yozungulira kupita ku nambala yapafupi;
- RoundDOWN - mozungulira nambala yapafupi pansi;
- Round - amazungulira nambala ndi kulondola kopatsidwa;
- OKRVVERH - yazungulira nambala yokhala ndi kulondola kopatsidwa;
- OKRVNIZ - imazungulira nambalayi mwakukula kwake molondola;
- OTDB - imakhala yozungulira;
- EVEN - imazungulira data mpaka nambala yapafupi kwambiri;
- Odd - amazungulira idatha ku nambala yapafupi yosamvetseka.
Mwa ntchito za Round, Round UP ndi Round DOWN, mawonekedwe akutsatirani ndi awa: "Dzinalo la ntchitoyi (nambala; nambala ya manambala). Ndiye kuti, mwachitsanzo, ngati mukufuna kuzungulira nambala ya 2,56896 mpaka manambala atatu, ndiye gwiritsani ntchito Round function (2.56896; 3). Kutulutsa ndi nambala 2.569.
Pantchito Round, OKRVVERH ndi OKRVNIZ njira yozungulira yotsatirayi yaikidwa: "dzina la ntchito (nambala; kulondola)". Mwachitsanzo, kuzungulira nambala 11 mpaka angapo apafupi 2, timayambitsa ntchito Round (11; 2). Kutulutsa ndi nambala 12.
Ntchito Jambulani, EVEN ndi Odd zimagwiritsa ntchito mawonekedwe otsatirawa: "Jina la ntchito (nambala)". Pofuna kuzungulira nambala 17 mpaka chapafupi kwambiri, timagwiritsa ntchito ntchito NUMBER (17). Tapeza nambala 18.
Mutha kuyika ntchito mu khungu komanso mzere wogwirira ntchito, mutasankha foni yomwe izikhala. Ntchito iliyonse iyenera kukhala patsogolo pa chizindikiro "=".
Pali njira yosiyaniranayi yokhazikitsira ntchito yozungulira. Ndiosavuta kugwiritsa ntchito ngati pali tebulo lomwe lili ndi mfundo zofunika kuzisintha kuti zizisungidwa.
Kuti muchite izi, pitani pa tabu ya "Fomula". Dinani batani "Math". Kenako, pamndandanda womwe umatsegula, sankhani ntchito yomwe mukufuna, mwachitsanzo Round.
Pambuyo pake, zenera zotsutsana ndi ntchito zimatsegulidwa. Mu gawo la "Nambala", mutha kulowa manambala pamanja, koma ngati tikufuna titazungulira zenera lonse la tebulo, dinani batani kumanja kwa zenera lolemba.
Tsamba la mkangano wa ntchito limachepetsa. Tsopano tikufunika dinani patsamba lalikulu kwambiri lachiwonetsero lomwe deta yake yomwe tikuzunguliza. Mtengo ukamalowera pazenera, dinani batani kumanja kwa phindu ili.
Ntchito yotsutsana ndi ntchito imatsegulanso. M'munda "Chiwerengero cha manambala" timalemba zakuya, komwe timafunikira kuchepetsa magawo. Pambuyo pake, dinani batani "Chabwino".
Monga mukuwonera, nambalayi yazunguliridwa. Kuti mutulutsire tsatanetsatane wina wosanjikizidwa mwanjira yomweyo, sinthani chofikira kumunsi kwa dzanja lamanja ndi mtengo wozungulira, dinani batani lakumanzere, ndikuzikokera pansi kumapeto kwa tebulo.
Zitatha izi, mfundo zonse zomwe zili mgulu lofunidwa zidzazunguliridwa.
Monga mukuwonera, pali njira ziwiri zazikulu zozungulira kuwonetsa kuwonetsa kuchuluka kwa manambala: kugwiritsa ntchito batani pa nthiti, komanso kusintha magawo amitundu. Kuphatikiza apo, mutha kusintha kuzungulira kwa zowerengera zenizeni. Izi zitha kuchitikanso m'njira ziwiri: posintha buku lonse, kapena kugwiritsa ntchito ntchito zapadera. Kusankhidwa kwa njira yina kumadalira kuti mukufuna kutsatsa mtunduwu kuzunguliza deta yonse mufayilo, kapena maselo angapo okha.
