Manambala ozungulira pa Excel: Mafashoni anayi ogwira ntchito

Mukamachita magawano kapena ntchito ndi manambala ang'onoang'ono, excel imapanga kuzungulira. Izi ndichifukwa chake, choyambirira, ndi mfundo yoti manambala kwathunthu a Fraction ndi osowa pakafunika kutero, koma siyosavuta kwambiri kugwira ntchito ndi mawu ochulukirapo ndi zizindikiro zingapo pambuyo pa comma. Kuphatikiza apo, pali manambala omwe mfundo zake mwa mfundo sizimazungulira. Nthawi yomweyo, kuzungulira kosakwanira kumatha kubweretsa zolakwitsa zovuta m'makhalidwe omwe amafunikira kwenikweni. Mwamwayi, pulogalamuyi imakhala ndi mwayi kukhazikitsa ogwiritsa ntchito okha, momwe manambala adzazunguliridwa.

Zinthu za manambala ozungulira

Manambala onse omwe magwiridwe antchito a Microsoft Excel agawika kuti agwirizane ndi olondola. Memory amasungidwa kukumbukira zotulutsa 15, ndikuwonetsedwa asanatulutsidwe, zomwe zimawonetsa wosuta. Kuwerengera konse kumachitika malinga ndi kukumbukira, ndipo osawonetsedwa paderali.

Pogwiritsa ntchito ntchito yozungulira, Excel imataya semicolons angapo. Imagwiritsa ntchito njira yokhazikika yolumikizira, pomwe nambala itachepera 5 imazungulira mbali yaying'ono, komanso yoposa 5 - m'balily.

Kuzungulira ndi mabatani pa riboni

Njira yosavuta yosinthira ndikuwunikira maselo kapena gulu la ma cell, dinani pa tepi kuti "kukulitsa" kapena "kuchepetsa kukula". Mabatani onse awiriwa ali mu "nambala" ya chida. Nambala yowonetsedwa yokha idzazungulira, koma chifukwa chogwirizana, ngati kuli kotheka, mpaka manambala 15 adzaphatikizidwa.

Mukadina batani la "kukulitsa", chiwerengero cha anthu omwe amapangidwa pambuyo pa imodzi.

Batani la "Kuchepetsa pang'ono", motsatana, kumachepetsa kuchuluka kwa manambala pambuyo pa comma.

Kuzungulira kudzera pa cell

Ndikothekanso kukhazikitsa zosintha pogwiritsa ntchito mawonekedwe a foni. Kuti muchite izi, sankhani maselo osiyanasiyana papepala, dinani batani la mbewa lamanja ndikusankha "Fomu Yanu" mumenyu zomwe zikuwoneka.

Pazenera loyeserera la cell lomwe limatseguka, pitani ku "nambala". Ngati mtundu wa data sunatchulidwe, ndikofunikira kuyiyika, apo ayi simungathe kusungitsa kuzungulira. Mu gawo lalikulu la zenera pafupi ndi zolembedwa "chiwerengero cha zizindikiro za decome" kungowonetsa kuchuluka kwa zizindikiritso zomwe mukufuna kuwona mukamazungulira. Pambuyo potsatira zosintha.

Kukhazikitsa kuwerengera kolondola

Ngati m'mbuyomu, magawo omwe amakhazikitsidwa amangoganiza zongowonetsedwa, ndipo nthawi yowerengera, zizindikiro zolondola zinagwiritsidwa ntchito (mpaka zilembo 15), tsopano tikuuzani kusintha kolondola kwa kuwerengera.

1. Dinani fayilo ya fayilo kuchokera kumeneko kupita ku "magawo".



2. Zenera lambiri limatsegulidwa. Pawindo ili, pitani ku SUPSSESESE ". Ikani makonda omwe amatchedwa "akamayambiranso bukuli". Zosintha mu block iyi siziyikidwa pa pepala limodzi, koma Bukhu lonse lonse, ndiye kuti, ku fayilo yonse. Ikani bokosi loyang'ana kutsogolo kwa "kulungamitsa kulondola kwa" gawo la "gawo ndikudina bwino.



3. Tsopano, powerengera deta, nambala yowonetsedwa pazenera idzakhudzidwa, osati amene amasungidwa kukumbukira. Kukhazikitsa kwa nambala yowonetsedwa kungachitike ndi njira zilizonse zomwe tidakambirana pamwambapa.

Kugwiritsa ntchito ntchito

Ngati mukufuna kusintha phindu lakuwerengera kamodzi kapena zingapo, koma osafuna kuchepetsa kuwerengera kwa chikalatacho, ndiye kuti ndibwino kugwiritsa ntchito luso loti "lozungulira" Ndipo zosiyana zosiyanasiyana zosiyanasiyana, komanso ntchito zina.

Pakati pa ntchito zazikulu zomwe zimayendetsa ziyenera kugawidwa motere:

• "Wozungulira" - kuzungulira mpaka nambala yotchulidwa malinga ndi malamulo omwe avomerezedwa;
• "Pamwamba pa District" - kuzungulira mpaka kufupi ndi gawo la gawo;
• "Rounddlice" - kuzungulira mpaka kumapeto kwa gawo;
• "Wozungulira" - wozungulira nambalayo ndi kulondola kwake;
• "Okrwp" - ozungulira nambalayo ndi kulondola kwa gawo;
• "Okrvynis" - ozungulira gawo limodzi ndi kulondola kwake;
• "Otr" - ozungulira deta;
• "Khothi" - lozungulira zidziwitso ku nambala yapafupi kwambiri;
• "Zovuta" - kuzungulira deta ku nambala yosamvetsetseka.

Kwa ntchito za "ozungulira", "ozungulira" ndi "Roordrice" amagwiritsa ntchito mawonekedwe awa: Dzinalo la ntchito (nambala). Ndiye kuti, ngati mungafune kuzungulira nambala 2.56896 mpaka manambala atatu, kenako gwiritsani ntchito ntchito "yozungulira (2,56896; 3)". Zotsatira zake, zimawerengedwa nambala 2.569.

Kwa ntchito "chigawo", "Okrwp" ndi "Okrvis" Izi zimagwiritsidwa ntchito ndi njira yozungulira iyi: dzina la ntchito (nambala). Chifukwa chake, kuzungulira nambala 11 mpaka nambala yapafupi, angapo 2, timalowa mu chigawo "(11; 2)". Zotsatira zimapeza zotsatira 12.

"Otbr" Ntchito, "ngakhale" yunifolomu "Gwiritsani ntchito mtundu wotsatirawu: dzina la ntchito (nambala). Pofuna kuti nambala 17 kufikira apafupi ngakhale, timagwiritsa ntchito "Khothi (17)". Timapeza zotsatira 18.

Ntchitoyi imatha kulowa mu chipinda ndi mzere wa ntchito, mutasankha khungu momwe zidzakhala. Ntchito iliyonse isanakhazikike "=".

Pali njira ina yosiyana yodziwitsira ntchito. Ndizovuta kugwiritsa ntchito pakakhala tebulo ndi mfundo zomwe mukufuna kusintha kukhala manambala ozungulira mu gawo lina.

1. Pitani ku Mafola a Tab "ndikudina batani la" masamu ". M'ndandanda womwe umatsegulira, sankhani ntchito yoyenera, mwachitsanzo, "ozungulira".



2. Pambuyo pake, mayanjano amakangana. Mu "nambala", mutha kulowa pamanja, koma ngati tikufuna kuzungulira deta yonseyo, kenako dinani batani kumanja kwa zenera la data.



3. Zewi la kutsutsana la ntchitoyi lidakulungidwa. Tsopano dinani pafoni yapamwamba ya cholembera chomwe deta yomwe deta yomwe tazunguliridwa. Mtengo wake utalowetsedwa pazenera, dinani batani kumanja kwa mtengo wake.



4. Makina otsutsa a ntchito amatsegulanso. Mu "gawo la" mundawo, lembani pang'ono momwe tifunikira kudula tizigawo tambiri ndikugwiritsa ntchito zosintha.



5. Kuchuluka kozungulira. Pofuna kuzungulira pansi ndi zina zonse za mzere womwe mukufuna, bweretsani chotemberero kumanzere kwa cell ndi mtengo wozungulira, dinani kumapeto kwa tebulo.



6. Tsopano zofunikira zonse mu mzere udzazunguliridwa.

Monga mukuwonera, pali njira ziwiri zazikulu zowonetsera chiwonetsero cha nambala: pogwiritsa ntchito batani la tepi ndikusintha magawo a mawonekedwe a cell. Kuphatikiza apo, mutha kusintha kuzungulira kwa deta yowerengedwa. Itha kuchitidwanso mosiyanasiyana: Sinthani makonda a bukulo lonse kapena kugwiritsa ntchito ntchito zapadera. Kusankha njira inayake kumadalira ngati mukugwiritsa ntchito mtundu wofanizira wozungulira deta yonse mu fayilo kapena kokha kwa maselo osiyanasiyana.