Mwachindunji, Microsoft Excel siimapanga zolemba zowoneka. Pa nthawi yomweyo, nthawi zambiri, makamaka ngati chikalatacho chimatumizidwa kusindikizidwa, amafunika kuwerengedwa. Excel ikukulolani kuti muchite izi pogwiritsira ntchito timitu tapamwamba ndi timapepala. Tiyeni tiwone njira zosiyanasiyana za momwe mungapezere mapepala pamunsiyi.
Kuchuluka kwa Nambala
Mutha kupukuta masamba mu Excel pogwiritsira ntchito mitu yamutu ndi maulendo. Zili zobisika mwachisawawa, zomwe zili m'munsi ndi m'munsi mwa pepala. Chidziwitso chawo ndi chakuti zolembedwera m'derali zimakhala zosaonekera, ndiko kuti, zikuwonetsedwa pamasamba onse a chikalata.
Njira 1: Kuwerengera Kawirikawiri
Kuwerengetsa nthawi zonse kumaphatikizapo mapepala onse a chikalatacho.
- Choyamba, muyenera kuonetsetsa maonekedwe ndi mutu. Pitani ku tabu "Ikani".
- Pa tepiyi mu chida cha zipangizo "Malembo" pressani batani "Zolemba".
- Pambuyo pake, Excel imalowa muzithunzithunzi, ndipo mapazi amapezeka pamapepala. Iwo ali kumtunda ndi kumunsi. Kuwonjezera apo, aliyense wa iwo amagawidwa m'magulu atatu. Timasankha pazondomeko ziti, komanso mu gawo lake, chiwerengerocho chidzachitidwa. Nthawi zambiri, mbali yamanzere ya mutu imasankhidwa. Dinani mbali yomwe mukufuna kukonza nambalayi.
- Mu tab "Wopanga" zowonjezera ma tebulo "Kugwira ntchito ndi mapazi" dinani pa batani "Tsamba la tsamba"zomwe zaikidwa pa tepi mu zida zamagulu "Zoponda Zapansi".
- Monga mukuonera, chizindikiro chapadera chikuwonekera. "& [Tsamba]". Kuti ukhale wosinthidwa nambala, dinani pa malo aliwonse a chikalatacho.
- Tsopano pa tsamba lirilonse la chiwonetsero cha Excel chinawonekera nambala yotsatira. Kuti chiwoneke chowoneka bwino ndikuwonekera motsutsana ndi maziko, chikhoza kupangidwira. Kuti muchite izi, sankhani cholowera pamapazi ndikusungira chithunzithunzi pa icho. Menyu yopangidwira ikuwonekera momwe mungathe kuchita zotsatirazi:
- sintha mtundu wamtundu;
- zikhale izo italic kapena molimba;
- sintha;
- sintha mtundu.
Sankhani zochita zomwe mukufuna kuchita kuti musinthe maonekedwe a nambalayo kufikira mutapeza zotsatira zomwe zimakukhutitsani.
Njira 2: kuwerengera ndi chiwerengero cha mapepala
Kuphatikizanso, mungathe kulemba masamba a Excel ndi chiwerengero chawo pa pepala lililonse.
- Timayambitsa chiwonetsero chowerengera, monga momwe tawonetsera mu njira yapitayi.
- Tisanalembedwe, timalemba mawuwa "Tsamba", ndipo pambuyo pake timalemba mawu "la".
- Ikani malonda mmunda wapansi pambuyo pa mawu "la". Dinani pa batani "Chiwerengero cha masamba"yomwe imayikidwa pa mpiru mu tab "Kunyumba".
- Dinani pa malo alionse m'kalembedwe kuti m'malo mwa malemba awonetsedwe.
Tsopano tili ndi chidziwitso osati cha pepala lokhalo, komanso za nambala yawo yonse.
Njira 3: Kuwerenga kuchokera patsamba lachiwiri
Pali zifukwa zomwe sizili zofunikira kuti muwerenge chiwerengero chonsecho, koma kungoyambira pamalo ena. Tiyeni tione m'mene tingachitire.
Pofuna kuyika chiwerengerochi kuchokera patsamba lachiwiri, ndipo izi ndi zoyenera, mwachitsanzo, polemba zolemba, kusindikizidwa ndi ntchito za sayansi, pamene kupezeka kwa manambala sikuloledwa pa mutu wa mutu, muyenera kuchita zomwe zili pansipa.
- Pitani ku gawo loyendetsa. Chotsatira, pita ku tabu "Wokonza Mapazi"ili pazithunzi zazithunzi "Kugwira ntchito ndi mapazi".
- M'kati mwa zipangizo "Zosankha" Pakaboni, fufuzani chinthucho "Tsamba lapadera la tsamba loyamba".
- Ikani chiwerengero pogwiritsa ntchito batani "Tsamba la tsamba", monga momwe tawonetsera pamwambapa, koma chitani pa tsamba lirilonse kupatula yoyamba.
Monga mukuonera, patatha izi mapepala onse akuwerengedwa, kupatula oyambirira. Komanso, tsamba loyamba limaganiziridwa panthawi yowerengera mapepala ena, koma, ngakhale zili choncho, chiwerengerocho sichisonyezedwa pa izo.
Njira 4: kuwerengera kuchokera pa tsamba lofotokozedwa
Panthawi imodzimodziyo, pali zochitika ngati pakufunika kuti chikalata chiyambe osati kuyambira tsamba loyamba, koma, mwachitsanzo, kuyambira chachitatu kapena chachisanu ndi chiwiri. Chosowa si nthawi zambiri, koma, komabe, nthawizina funso lofunsidwa likufunikanso kuthetsa.
- Timachita chiwerengerochi mwachizoloŵezi, pogwiritsa ntchito bokosi lofanana pa tepi, ndondomeko yowonjezera yomwe inaperekedwa pamwambapa.
- Pitani ku tabu "Tsamba la Tsamba".
- Pakaboni m'makona a kumanzere a bokosilo "Makhalidwe a Tsamba" Pali chithunzi mu mawonekedwe a mzere oblique. Dinani pa izo.
- Fenje lazitali likuyamba, pitani ku tab "Tsamba"ngati itatsegulidwa mu tabu ina. Timayika m'munda wa parameter "Tsamba la tsamba loyamba" nambala yoti iwerengedwe. Dinani pa batani "Chabwino".
Monga momwe mukuonera, pambuyo pake chiwerengero cha tsamba loyamba lachidziwitsocho chinasinthidwa kukhala chomwe chinayankhulidwa mu magawo. Choncho, kuwerengera kwa mapepala omwe amatsatirako kunasunthidwanso.
Phunziro: Momwe mungatulutsire mutu ndi zikhomo ku Excel
Masamba owerengera pa tsamba la Excel ndi losavuta. Ndondomekoyi imapangidwa ndi mitu yoyenda ndi maulendo operekedwa. Kuphatikiza apo, wosuta akhoza kusinthira chiwerengero chake: kuwonetsa mawonetsero a nambala, kuwonjezera chiwonetsero cha chiwerengero cha mapepala a chikalata, nambala kuchokera pamalo ena, ndi zina zotero.
