Kusintha mawonekedwe mu Excel

Mlandu mu Microsoft Office Excel ndi kutalika kwa zilembo, malo awo m'maselo a tebulo. Excel sipereka ntchito yapadera yosinthira zilembo za zilembo. Komabe, zitha kusinthidwa pogwiritsa ntchito ma formula. Momwe mungachitire izi mwachangu tidzakambirana m'nkhaniyi.

Momwe mungasinthire nkhani mu Excel

Pali zosankha zingapo zosinthira kaundula, iliyonse yomwe iyenera kuganiziridwa mwatsatanetsatane. Kenako, tikambirana njira zonse zomwe zimakulolani kuti musinthe mawonekedwe a zilembo.

Njira 1. Momwe mungalembe chilembo choyamba m'mawu

Ndi chizolowezi kuyambitsa ziganizo m'maselo a tebulo ndi zilembo zazikulu. Izi zimawonjezera kukongola ndi mawonekedwe a gululo. Kuti musinthe chilembo choyamba m'mawu, kuti chikhale chachikulu, muyenera kutsatira algorithm iyi:

1. Ndi batani lakumanzere la mbewa, sankhani ma cell angapo kapena chinthu china chamagulu a tebulo.
2. Mu mzere wolowetsa womwe uli pamwamba pa menyu yayikulu ya Excel pansi pa chida, kapena chilichonse patebulo, lowetsani pamanja fomula kuchokera pa kiyibodi ya PC. "= PROPRANACH ()". M'makolo, wogwiritsa ntchito ayenera kufotokoza mkangano woyenera. Awa ndi mayina a ma cell omwe mukufuna kusintha mawonekedwe amtundu woyamba m'mawu.

3. Mukamaliza kulemba fomula, dinani "Enter" kuti mutsimikizire zomwe zikuchitika.
4. Onani zotsatira. Tsopano mawu onse mu chinthu chosankhidwa kapena mndandanda wa maselo ayenera kuyamba ndi chilembo chachikulu.

5. Ngati ndi kotheka, chilinganizo cholembedwacho chikhoza kutambasulidwa mpaka kumapeto kwa tebulo kuti mudzaze maselo otsalawo.

Tcherani khutu! Njira yosinthira kaundula ndiyovuta ngati mawu angapo alembedwa muselo imodzi nthawi imodzi. Kenako fomulayo idzalemba zilembo zazikulu liwu lililonse.

Formula "= PROPLANCH ()» ndizofunikira kwambiri kugwiritsa ntchito pamene wogwiritsa ntchito akugwira ntchito ndi mayina oyenerera, omwe ayenera kuyamba ndi chilembo chachikulu.

Njira 2. Momwe mungapangire zilembo zonse m'maselo ang'onoang'ono

Njirayi ikugwiritsidwanso ntchito pogwiritsa ntchito ndondomeko yoyenera. Kuti musinthe nkhaniyo mwachangu kukhala zilembo zazing'ono, muyenera kuchita izi molingana ndi algorithm:

1. Ikani cholozera cha mbewa mu selo, chomwe chidzawonetsa zotsatira za fomula.
2. Muzinthu zomwe zasankhidwa patebulo, lembani fomula “= WAPASI ()”. M'mabulaketi, momwemonso, muyenera kufotokoza mkanganowo podina LMB pa chinthu chomwe mukufuna cha cell yoyambirira momwe mlanduwo sunasinthidwe.

3. Dinani "Enter" kuchokera pa kiyibodi kuti mumalize fomula.
4. Onani zotsatira. Ngati zochita zonse zachitidwa molondola, ndiye kuti mawu omwewo kapena mndandanda wa zilembo zokhala ndi zilembo zing'onozing'ono zidzalembedwa mu selo yosankhidwa.

5. Tambasulani zotsatira zake kumapeto kwa mndandanda wa tebulo kuti mudzaze zinthu zotsalira. Mbali imeneyi imalola wogwiritsa ntchito kusalemba fomula ya selo linalake nthawi iliyonse.

Zofunika! Tsoka ilo, mtundu wamba wa Excel ulibe njira yapadera yomwe ili ndi udindo wosintha nkhaniyi, monga mu Microsoft Office Word, chifukwa. Excel idapangidwa kuti izigwira ntchito ndi matebulo, osati zolemba.

Njira 3. Momwe mungalembe zilembo zazikulu m'mawu amodzi

Nthawi zina, popanga tebulo mu MS Excel, wogwiritsa ntchito amafuna kuti chilembo chilichonse mu liwu la cell chikhale ndi zilembo zazikulu. Izi ndi zofunika kuunikira zigawo zofunika za tebulo gulu, kuika chidwi.

Kuti muthane ndi ntchitoyi munthawi yaifupi kwambiri, muyenera kugwiritsa ntchito malangizo osavuta pang'onopang'ono:

1. Sankhani selo lomwe zotsatira za kusintha kwa mlandu zidzawonetsedwa poyika cholozera cha mbewa mmenemo.
2. Lowetsani chilinganizo "=" pa kiyibodi ya pakompyutaMALAMULO ()». M'makolo, pofananiza ndi ndondomeko zomwe zili pamwambazi, muyenera kufotokoza mkangano - gwero la selo kumene mukufuna kusintha mlanduwo.

3. Malizitsani kulemba fomulayo podina batani la "Enter".
4. Onetsetsani kuti zilembo zonse mu selo zalembedwa zilembo zazikulu.

Njira 4. Kusintha nkhani ya zilembo payekha m'mawu

Mu Microsoft Office Excel, mutha kusinthanso kukula kwa chilembo chimodzi kapena zingapo m'mawu. Mwachitsanzo, powapanga kukhala zilembo zazikulu, ndikusiya ena ang'onoang'ono. Kuti muchite izi, simuyenera kugwiritsa ntchito fomula, ingotsatirani njira zingapo zosavuta:

1. Sankhani selo lililonse la gulu la tebulo podina pa ilo ndi batani lakumanzere.
2. Pamzere wolowetsa mafomu pamwamba pa menyu yayikulu ya pulogalamuyo, zomwe zasankhidwa zidzawonetsedwa. Ndikosavuta kukonza zosintha mumzerewu.
3. Ikani cholozera cha mbewa pafupi ndi zilembo zing'onozing'ono m'mawuwo ndikuzichotsa pokanikiza batani la "Backspace" pa kiyibodi ya pakompyuta.
4. Lembani zilembo zomwezo pamanja, koma pongopanga zilembo zazikulu. Kuti muchite izi, muyenera kukanikiza makiyi aliwonse a "Shift" ndikudina pa chilembo chomwe mukufuna.
5. Onani zotsatira. Ngati zonse zili bwino, ndiye kuti nkhani ya kalatayo idzasintha.
6. Chitaninso chimodzimodzi kwa otchulidwa ena onse m'mawu.

Zina Zowonjezera! Mutha kusinthanso nkhani ya zilembo zonse m'mawu pamanja kuchokera pa kiyibodi. Komabe, izi zitenga nthawi yayitali kuposa kugwiritsa ntchito njira inayake.

Kutsiliza

Chifukwa chake, mutha kusintha mawonekedwe a zilembo mu Microsoft Office Excel pogwiritsa ntchito njira zoyenera, kapena pamanja posintha kukula kwa zilembo pa kiyibodi ya PC. Njira zonsezi zafotokozedwa mwatsatanetsatane pamwambapa.