Momwe mungayikitsire mzere mu Excel

Kugwira ntchito ku Microsoft Excel, yoyamba yoyamba ndikuphunzira kuyika zingwe ndi zigawo patebulo. Popanda luso ili, ndizosatheka kugwira ntchito ndi detar. Tiyeni tichite nawo momwe mungawonjezere mzere.

Phunziro: Momwe mungawonjezere mzere mu tebulo la Microsoft

Ikani mzere

Kupambana, pali njira zingapo zoyikitsira mzere pa pepala. Ambiri aiwo ndi osavuta, koma ogwiritsa ntchito a Novice sangakhale ndi chilichonse. Kuphatikiza apo, pali njira yowonjezera zingwe zongowonjezera kumanja kwa tebulo.

Njira 1: Ikani kudzera pagawo logwirizana

Njira imodzi yosavuta yolowera ndikugwiritsira ntchito gawo loyang'ana kwambiri.

1. Kudina mu gulu lozungulira lozungulira ndi mayina a zigawo malinga ndi gawo, kumanzere komwe muyenera kuyika mzamba. Pankhaniyi, mzatiyo wagawidwa kwathunthu. Dinani batani lamanja. Mumenyu yomwe imawoneka, sankhani "phala".



2. Pambuyo pake, mzati watsopanoyo amawonjezeredwa kumanzere kwa malo osankhidwa.

Njira 2: Kuonjezera foni kudzera pa menyu

Mutha kugwira ntchito imeneyi komanso mwanjira ina, ndiye kuti kudzera mwa mndandanda wa cell.

1. Dinani pa cell iliyonse yomwe ili mu khola kumanja kwa mzere adakonzekereratu kuti kuwonjezera. Dinani pa batani lakumanja la mbewa. Muzosankha zomwe zikuwoneka, sankhani "phala ...".



2. Nthawi ino yowonjezera siyingokhala zokha. Windo laling'ono limatseguka, momwe mukufuna kutchula kuti ndi wogwiritsa ntchito kuti alowe:
   • Mzere;
   • Mzere;
   • Cell yokhala pansi;
   • Maselo osasunthira kumanja.

   Timakonzanso kusintha kwa "Column" ndikudina batani la "Ok".



3. Pambuyo pa izi, mzati udzawonjezedwa.

Njira 3: batani pa nthiti

Kuyika kwa mizati kumatha kuchitika pogwiritsa ntchito batani lapadera pa tepi.

1. Sankhani foni kumanzere kwake komwe akukonzekera kuwonjezera mzere. Kukhala mu "kunyumba" tabu, dinani pachizindikiro mu mawonekedwe a Triangle, yomwe ili pafupi ndi batani la "phazi" mu tepi. Mumenyu zomwe zimatseguka, sankhani "kuyikapo mzati ku pepalalo" chinthucho.



2. Pambuyo pake, mzati udzawonjezedwa kumanzere kwa chinthu chosankhidwa.

Njira 4: Kugwiritsa Ntchito Makiyi Otentha

Komanso, mzati watsopano ungawonjezere ndi makiyi otentha. Ndipo pali njira ziwiri zowonjezera

1. Chimodzi mwa izo ndi chofanana ndi njira yoyamba yolowera. Muyenera kudina gawo lolumikizirana lozungulira lomwe lili kumanja kwa malo omwe akufuna kuti ayambe kuyikapo ndi kuyimba kwa CTRL.



2. Kuti mugwiritse ntchito njira yachiwiri, muyenera kuti mudziwe khungu lililonse mpaka kumanja kwa malo. Kenako dinani pa kiyibodi ya CTRL. Pambuyo pake, ndiye pawindo laling'ono lokhala ndi mtundu wa mtundu, womwe umafotokozedwa mu njira yachiwiri yochitira opareshoni. Zowonjezera zomwezo ndendende: Sankhani "nambala" ndikudina batani la "Ok".

Phunziro: Makiyi otentha kwambiri

Njira 5: Kuyika Mizati Yambiri

Ngati mukufuna kuloza mizati ingapo, ndiye kuti sichofunikira kuti mugwire ntchito ina iliyonse pa izi, popeza njirayi imaphatikizidwa muchizolowezi chimodzi.

1. Muyenera kusankha maselo ambiri mu gawo lopingasa kapena magawo omwe ali patsamba logwirizana, ndi mizati ingati yofunika kuwonjezeredwa.



2. Kenako ikani chimodzi mwazomwezo kudzera mwa menyu kapena makiyi otentha omwe afotokozedwera njira zakale. Chiwerengero chofananira cha mizati chidzawonjezedwa kumanzere kwa malo osankhidwa.

Njira 6: Kuwonjezera mzere kumapeto kwa tebulo

Njira zonse zapamwambazi ndizoyenera kuwonjezera olankhula pachiyambi ndi pakati pa tebulo. Amathanso kugwiritsidwa ntchito kuyika mzamba kumapeto kwa tebulo, koma mu izi muyenera kusintha. Koma pali njira zowonjezera mzere mpaka kumapeto kwa tebulo kuti muzindikire mwachangu ndi pulogalamuyo mpaka gawo lakelo. Kuti muchite izi, muyenera kuchita, omwe amatchedwa "anzeru".

1. Timatsindika pamtundu wa tebulo womwe tikufuna kulowa patebulo la "wanzeru".



2. Kukhala pa tabu yakunyumba, dinani mtundu wa "batani la" batani ", lomwe lili mu" masitaelo "pa tepi. Pa mndandanda wa omwe asiyanitsidwa, sankhani imodzi mwazinthu zazikulu za mapangidwe a tebulo pazovala zanu.



3. Pambuyo pake, zenera limatseguka, lomwe limawonetsa magwiridwe antchito a malo osankhidwa. Ngati mwazindikira cholakwika, ndiye kuti mutha kusintha apa. Chinthu chachikulu ndikuti muyenera kuchita izi ndikuwona ngati bokosi la cheke limayikidwa pafupi ndi "tebulo lokhala ndi mutu. Ngati tebulo lanu lili ndi chipewa (ndipo nthawi zambiri zimakhala choncho), koma palibe nkhundachi, ndiye kuti muyenera kukhazikitsa. Ngati makonda onse amakhazikitsidwa molondola, kenako dinani batani la "OK".



4. Pambuyo pa izi, mtundu wodzipatulira udapangidwa ngati tebulo.



5. Tsopano kuti muthandizire gawo latsopano patebulo ili, ndikokwanira kudzaza foni iliyonse kumanja kwake. Kholomo lomwe foni iyi imapezeka nthawi yomweyo.

Monga mukuwonera, pali njira zingapo zowonjezera mizati yatsopano kuti iwonjezere pepala laposalo pakati pa tebulo komanso m'masiku. Kuphatikiza pa zophweka komanso zosavuta, ndibwino kupanga, otchedwa "anzeru". Pankhaniyi, powonjezera deta pamtunda kumanja kwa tebulo, iphatikizidwa mwa iwo ngati mzati watsopano.