Kusintha mitundu yosiyanasiyana mu Excel

M'maphunziro apitawa, tidakambirana mfundo zoyambira ndi zidziwitso zokhudzana ndi masanjidwe mu Excel. Mu phunziro ili, tipitiriza kuphunzira njira zingapo, koma ndikutsindika kwambiri momwe angagwiritsire ntchito. Ndiye, mumasintha bwanji fomula yomwe ilipo kale mu Excel?

Malamulo osinthira masanjidwe amitundu

Fomulayi ikayikidwa mu cell imodzi, kuyisintha mu Excel nthawi zambiri sikovuta kwenikweni. Chachikulu apa ndikuti musaiwale kumaliza kukonza ndi kuphatikiza kofunikira Ctrl + Shift + Lowani.

Ngati fomulayo ili ndi ma cell ambiri, mwachitsanzo, ibweza mndandanda, ndiye kuti zovuta zina zimayamba nthawi yomweyo, makamaka kwa ogwiritsa ntchito novice. Tiyeni tiwone malamulo angapo omwe muyenera kuwamvetsetsa musanayambe kukonza mndandanda.

1. Simungasinthe zomwe zili mu selo limodzi lomwe lili ndi fomula yofananira. Koma selo lililonse limatha kukhala ndi kapangidwe kake.
2. Simungathe kuchotsa ma cell omwe ali m'gulu lamitundu yosiyanasiyana. Mutha kungochotsa gulu lonselo.
3. Simungathe kusuntha ma cell omwe ali gawo lamitundu yosiyanasiyana. Koma mukhoza kusuntha gulu lonse.
4. Simungathe kuyika maselo atsopano, kuphatikizapo mizere ndi mizati, mumagulu osiyanasiyana.
5. Simungagwiritse ntchito ma fomula amitundu yambiri pamatebulo opangidwa ndi lamulo Table.

Monga mukuonera, malamulo onse omwe ali pamwambawa akutsindika kuti gulu ndi limodzi. Ngati simutsatira limodzi mwamalamulo omwe ali pamwambapa, Excel sidzakulolani kuti musinthe mndandandawo ndipo ipereka chenjezo ili:

Kusankha gulu mu Excel

Ngati mukufuna kusintha fomula yofananira, chinthu choyamba kuchita ndikusankha mitundu yomwe ili ndi gululo. Mu Excel, pali njira zitatu zochitira izi:

1. Sankhani magulu osiyanasiyana pamanja, mwachitsanzo pogwiritsa ntchito mbewa. Iyi ndi njira yosavuta, koma nthawi zina njira yosayenera.
2. Kugwiritsa ntchito dialog box Sankhani gulu la ma cell. Kuti muchite izi, sankhani selo iliyonse yomwe ili mgululi:Ndiyeno pa Home tabu kuchokera pa dontho pansi mndandanda Pezani ndi kusankha pitani Sankhani gulu la ma cell.

   

   Bokosi la zokambirana lidzatsegulidwa Sankhani gulu la ma cell. Khazikitsani batani la wailesi ku Current Array ndikudina OK.

   

   Mndandanda wamakono udzawonetsedwa:

   

3. Kugwiritsa ntchito zosakaniza zazikulu CTRL+/. Kuti muchite izi, sankhani selo lililonse pamndandanda ndikusindikiza kuphatikiza.

Momwe mungachotsere fomula yayikulu

Chosavuta chomwe mungachite ndi gulu mu Excel ndikuchotsa. Kuti muchite izi, ingosankha gulu lomwe mukufuna ndikusindikiza batani Chotsani.

Momwe mungasinthire fomula yayikulu

Chithunzi chomwe chili pansipa chikuwonetsa mawonekedwe omwe amawonjezera milingo iwiri. Zitha kuwoneka kuchokera pachithunzichi kuti polowa chilinganizo, talakwitsa pang'ono, ntchito yathu ndikuwongolera.

Kuti musinthe fomula yofananira, chitani izi:

1. Sankhani kuchuluka kwa gululo pogwiritsa ntchito njira iliyonse yomwe mukudziwa. Kwa ife, uwu ndi mtundu C1:C12.
2. Pitani ku njira yosinthira fomula podina pa bar ya formula kapena kukanikiza kiyi F2. Excel idzachotsa zingwe zopindika kuzungulira fomula yofananira.
3. Konzani zofunikira pa formula:
4. Ndiyeno akanikizire kuphatikiza makiyi Ctrl + Shift + Lowanikusunga zosintha. Fomula idzasinthidwa.

Kusintha makulidwe amitundu yosiyanasiyana

Nthawi zambiri pamafunika kuchepetsa kapena kuonjezera kuchuluka kwa ma cell munjira zosiyanasiyana. Ndidzanena nthawi yomweyo kuti iyi si ntchito yophweka ndipo nthawi zambiri zimakhala zosavuta kuchotsa gulu lakale ndikupanga latsopano.

Musanachotse mndandanda wakale, lembani fomula yake ngati mawu ndikuigwiritsa ntchito mugulu latsopano. Ndi njira zovuta, njirayi idzapulumutsa nthawi yambiri.

Ngati mukufuna kusintha malo omwe ali patsamba lantchito popanda kusintha kukula kwake, ingosunthani ngati mulingo wabwinobwino.

Pali njira zingapo zosinthira makulidwe amitundu yomwe mungapeze zothandiza. Maphunzirowa amaperekedwa m'nkhani ino.

Chifukwa chake, lero mwaphunzira momwe mungasankhire, kufufuta ndikusintha mafomu osiyanasiyana, komanso mwaphunziranso malamulo othandiza ogwirira nawo ntchito. Ngati mukufuna kuphunzira zambiri za masanjidwe mu Excel, werengani nkhani zotsatirazi:

• Chiyambi cha mafomula osiyanasiyana mu Excel
• Mafomu a Multicell mu Excel
• Mafomu amtundu wa cell mu Excel
• Mndandanda wa zosinthika mu Excel
• Kugwiritsa ntchito mitundu yosiyanasiyana mu Excel
• Njira zosinthira masanjidwe amitundu mu Excel