Momwe mungapangire ndime yapamwamba

Nthawi zina ogwiritsa ntchito a Microsoft Office Excel ayenera kulembetsa mu selo limodzi la tebuloni kamodzi malembedwe angapo omwe adalembedwapo, ndikupanga ndime. Mwayi woterewu umatha kukhazikitsidwa m'njira zingapo pogwiritsa ntchito zida zamapulogalamu. Za momwe mungawonjezere ndime mu khungu la MS ikuluikulu lidzauzidwa m'nkhaniyi.

Njira zosamutsa malembedwe atsetse ma cell

Kupambana, ndizosatheka kupanga ndime pokakamiza kiyi ya "Lowani" kuchokera pa kiyibodi yapakompyuta, monga mawu. Apa ndikofunikira kugwiritsa ntchito njira zina. Adzakambirana.

Njira 1. Kusamutsa mawu pogwiritsa ntchito zida

Mawu onse a malembedwe onse a tebulo saikidwa chimodzimodzi mu khungu lonse, motero iyenera kusunthidwa ku mzere wina wa chinthu chomwecho. Njira yosavuta yochitira ntchitoyi idagawidwa m'njira zotsatirazi:

1. Chifuwa chakumanzere cha munthuyo ndikuwunikira gawo lomwe ndime iyenera kupangidwa.

Kusankha kwa khungu lomwe mukufuna kupanga ndime

1. Pitani ku "kunyumba" tabu, yomwe ili mu chida chapamwamba cha mndandanda waukulu wa pulogalamu.
2. Mu "gawo", dinani pa batani la "Zolemba".

Njira yopita ku batani la "Zolemba" pa Excel. Imagwira ntchito m'mabaibulo onse

1. Onani zotsatira zake. Pambuyo pochita kale, kukula kwa khungu lomwe lasankhidwa lidzakula, ndipo lembalo lidzamangidwanso m'ndimeyi, ndikuwonjezera mizere ingapo mu chinthu.

Zotsatira zomaliza. Mawu mu cell adasamukira ku mzere watsopano. Njira 2. Momwe mungapangire ndime zingapo mu khungu limodzi

Ngati lembalo lomwe lili ndi gawo labwino kwambiri lili ndi zopereka zingapo, zitha kugawidwa wina ndi mnzake, kuyambira aliyense wochokera ku mzere watsopano. Izi zikuwonjezera zokopa za kapangidwe kake, maonekedwe a mbale asintha. Kuti mukwaniritse izi, ndikofunikira kuchita motere:

1. Sankhani cell yomwe mukufuna.
2. Onani chingwe kuti mulembe fomu pamwamba pa menyu yayikulu kwambiri yomwe ili pamalo a zida wamba. Mmenemo, mawu a chinthu chosankhidwa amawonetsedwa kwathunthu.
3. Ikani cholozera cha mbewa pakati pa maofesi awiri mu mzere.
4. Sinthani kiyibodi ya PC ku English Canut ndi nthawi imodzi yothetsera "alt + kulowa" mabatani.
5. Onetsetsani kuti malingaliro adasachitsidwa, ndipo m'modzi wa iwo adasamukira mumzere wotsatira. Chifukwa chake, gawo lachiwiri limapangidwa mu khungu.

Kupanga magawo angapo mu khungu limodzi la tebulo lambiri

1. Chitani zoterezi ndi ziganizo zina zotchulidwa.

Njira 3. Gwiritsani ntchito zida

Njira iyi popanga ndime mu Microsoft Office Excel imaphatikizapo kusintha maselo. Kuti mukwaniritse, ndikofunikira kuchita zinthu zosavuta ndi algorithm:

1. LKM ikutsindika khungu lomwe mawu omwe adalemba sayikidwa chifukwa chachikulu.
2. Mwa dera lililonse la chinthucho, mumadina kumanja.
3. Pawindo lotsegula la mtundu wambiri, dinani pa "mawonekedwe a foni ..." chinthu.

Njira yopita ku zenera la cell mu Microsoft Office Excel

1. Mumenyu zopanga za zinthu zomwe ziziwonetsedwa pambuyo pochita zomata zam'mbuyomu, muyenera kupita gawo la "lilumikizidwe".
2. Mu gawo latsopano la menyu, pezani "zowonetsera" ndikuyika pafupi ndi "kusamutsa malingana ndi" gawo.
3. Dinani pa "Ok" pansi pazenera kuti musinthe.

Zochita algorithm munjira yolumikizidwa mu menyu ya "Follance" pa chilengedwe cha ndime

1. Onani zotsatira zake. Selo lidzasankha zongosankha zomwe mukufuna kuti malembawo asapitirize kupitilira malire ake, ndipo ndime idzalengedwa.

Njira 4. Kugwiritsa ntchito formula

Microsoft Office Excel ili ndi njira yapadera yopanga ndime, kusamutsa mawu kupita kumizere ingapo pagombe la mabasi. Kuti mukwaniritse ntchitoyo, mutha kugwiritsa ntchito izi:

1. Sankhani khungu la LKM. Ndikofunikira kuti poyamba musakhale ndi zilembo komanso zina zomwe zili mmodzi.
2. Pamanja kuchokera ku kiyibodi ya pakompyuta Lowani "= Kugwira (" mawu1 "; chizindikiro (10);" mawu2 ")". M'malo mwa mawu oti "lembani mawu" ndi "mawu2", muyenera kuyendetsa mfundo zolondola, i. Lembani zilembo zofunika.
3. Pambuyo polemba kuti mudine "Lowani" kuti mumalize fomula.

Kugwiritsa ntchito njira yapadera yosamutsa mizere kuti ikwaniritse

1. Onani zotsatira zake. Zolemba zomwe zatchulidwazi zizipezeka pamanja zingapo, kutengera mawu ake.

Momwe mungatalikitsire formula popanga magawo ku chiwerengero chomwe mukufuna

Ngati wogwiritsa ntchito akuyenera kusamutsa mizere ikamodzi pagome limodzi pazamagome pogwiritsa ntchito njira yomwe ili pamwambapa, ndikukwanira kuwonjezera ntchito ndi ma cell osiyanasiyana. Mwambiri, njira yokonzanso formula yomwe imawoneka ngati iyi:

1. Sankhani khungu lomwe zotsatira za formula zimalembetsedwa.
2. Ikani cholozera cha mbewa kumanja kwa chinthu chosankhidwa ndikuwumitsa LKM.
3. Tambasulani khungu kuti mupeze mizere ya mizere ya matebulo, osatulutsa LKM.
4. Tulutsani fungulo lakumanzere kwa malo oyipitsa ndikuwona zotsatira zake.

Mapeto

Chifukwa chake, kulengedwa kwa ma microsoft Office Exsot Chuma sikuyambitsa mavuto ngakhale ogwiritsa ntchito osadziwa. Kusamutsa mizere yoyenera, ndikofunikira kutsogoleredwa ndi malangizo omwe ali pamwambapa.

Mauthenga monga mu khungu la Excel kuti apangitse ndime yoyamba ku ukadaulo.