☑️ Njira 3 Zapamwamba Zopangira Matebulo mu Google Mapepala
- Ndemanga za News
Kugwira ntchito ndi matebulo angapo, ma chart, ndi ma cell mu spreadsheet yayitali kumatha kukhala kotopetsa. Komanso, mutha kuwunikira mzere kapena gawo linalake kuti muwunikire muzolemba za Google Sheets. Mapepala a Google ali ndi njira zambiri zosinthira kuti matebulo awa awoneke bwino.
Mutha kugwiritsa ntchito zosankha zosasinthika, kugwiritsa ntchito mitu kuti muwonjezere moyo pazithunzi izi, kapena kusankha pulogalamu yowonjezera kuti musinthe. Tikuwonetseni momwe mungasankhire matebulo ndi ma chart mu Google Sheets popanda kusokoneza.
1. Sinthani mitundu ya tebulo
Mapepala a Google ali ndi zosankha zosasinthika zosintha mutu, pansi, ndi mitundu yama cell. Tiyeni tiwone izo zikugwira ntchito.
Khwerero 1: Tsegulani spreadsheet mu Google Sheets.
Khwerero 2: Mukamaliza kuwonjezera zolemba ndikupanga matebulo, dinani Format pamwamba.
Khwerero 3: Sankhani Mitundu Yamitundu (ngakhale dzina likanakhala labwinoko apa) ndipo mndandanda wam'mbali udzatsegulidwa.
Khwerero 4: Dinani kachizindikiro kakang'ono pafupi ndi zomwe zilipo ndikusankha mtundu womwe mukufuna kuyikapo mitundu.
Gawo 5: Sankhani masitayelo amodzi osasinthika ndipo pompopompo muwona masitayelo atsopano akugwira ntchito.
Kuti muwalekanitse ndi paketi, mutha kugwiritsa ntchito mtundu wamutu wakuda pamutu ndi pansi. Mitu yokhazikika idapangidwa kuti ikhale yoyera koyera ndi inanso mthunzi wopepuka kuti pakhale kusiyana kokwanira pakati pa ziwirizi.
Mutha kusinthanso mutu, mtundu 1, mtundu 2, ndi mutu wapansi kuti mumakonda. Mukangosintha masitayelo osasinthika, idzasungidwa ngati mutu wanthawi zonse kuti mutha kuzigwiritsa ntchito mtsogolo ndikudina kamodzi kokha. Dinani batani la Ndamaliza ndikusangalala ndi spreadsheet mu avatar yokongola.
2. Gwiritsani ntchito mitu
Mitu ndiyothandiza makamaka popanga ma bar ndi mizere kukhala okopa kwambiri. Mutha kusintha mawonekedwe a ma chart omwe awonjezeredwa mu Google Sheets ndikudina kamodzi kokha. Ndimomwemo.
Khwerero 1: Mu Google Mapepala, sankhani Format kuchokera pa menyu.
Khwerero 2: Dinani Mitu pa menyu yotsitsa.
Khwerero 3: Yang'anani mulu wamitu yokhazikika pampando wakumanja.
Khwerero 4: Sankhani mutu womwe mumakonda ndikuwona mtundu watsopano ukugwira ntchito.
Ngati simukonda chilichonse pamndandanda, mutha kusankha mutu uliwonse ndikudina makonda pamwamba.
Mndandanda wotsatirawu udzakuthandizani kusintha mtundu wa font, mtundu wa malemba, mtundu wa tchati, mtundu wa hyperlink ndikusintha mitundu yosiyanasiyana ya mawu pamutu. Dinani batani la "Chachitika" ndipo mwamaliza.
3. Gwiritsani ntchito pulogalamu yowonjezera ya Table Styles
Ngati simukukonda zopereka za Google, mapulagini a chipani chachitatu ali pano kuti akupulumutseni. Ndi pulogalamu yowonjezera ya chipani chachitatu yotchedwa Table Styles, mukhoza kusintha maonekedwe a spreadsheet pa ntchentche. Choyamba, tikuwonetsani momwe mungayikitsire Table Styles mu akaunti yanu ya Google Sheets ndikuwona pulogalamu yowonjezera ikugwira ntchito.
Khwerero 1: Mu Google Mapepala, dinani Zowonjezera pamwamba.
Khwerero 2: Tsegulani mapulagini menyu ndikusankha Pezani Mapulagini.
Khwerero 3: Google Workspace Marketplace idzatsegulidwa. Gwiritsani ntchito bar yofufuzira yomwe ili pamwamba ndikuyang'ana Masitayilo a Table.
Tsitsani masitayilo a Table mu Google Sheets
Khwerero 4: Ikani masitayilo a Table mu Google Sheets.
Tsopano popeza mwayika masitayelo a Table, tiyeni tikuwonetseni momwe mungagwiritsire ntchito pulogalamu yowonjezera kupanga matebulo mu Google Sheets.
Khwerero 1: Mukatsegula spreadsheet mu Google Sheets, sankhani Zowonjezera kuchokera pa menyu.
Khwerero 2: Onjezani masitayilo a Table ndikudina Kunyumba.
Mudzawona masitayilo a Table akugwira ntchito mu menyu yoyenera. Mosiyana ndi njira yosasinthika ya "Toggle Colours" mu Google Sheets, Table Styles samazindikira tebulo mu Mapepala. Muyenera kusankha mtundu wa ma cell pamanja. Tinasankha B27:F38 kuti muyike mu Google Mapepala mu chitsanzo chomwe chili pansipa.
Pansi pa Masitayelo a Table, sankhani imodzi mwamituyi. Zowonjezera zimapereka masitayelo angapo oti musankhe. Mutha kusintha kalembedwe ndi mitundu yopepuka, yakuda kapena yosiyana.
Pamodzi ndi kusintha mzere wapamutu, mzere wapansi, ndikugwiritsa ntchito mitundu ina, Masitayelo a Table asinthanso mitundu yakumanzere ndi kumanja.
Mutha kukulitsa njira ya Preview ndikusintha ndikuyang'ana masanjidwe akugwira ntchito musanagwiritse ntchito ku Google Mapepala. Dinani kalembedwe batani pansi mukakhala okondwa ndi chithunzithunzi.
Pangani masamba owoneka bwino kuchokera ku Google Sheets
Maspredishiti anu a Google sakuyenera kukhala osalankhula nthawi zonse. Ndi kuchuluka koyenera kwa masanjidwe mu Mapepala, mutha kusintha mathebulo ndi matchati kuti akhale osangalatsa m'maso.
SOURCE: Ndemanga za News
Osayiwala kugawana nawo nkhani yathu pamasamba ochezera kuti atilimbikitse. 👓