Sungani Mankhwala Othandizira

Lembani Deta, Fomu, Kupanga Maonekedwe ndi Zambiri

Mankhwala odzaza ndi malo ochepa kwambiri, ofiira wakuda kapena ofiira kumunsi kumanja kwachindunji cha selo yogwira ntchito zomwe zingakupulumutseni nthawi ndi khama pamene zimagwiritsidwa ntchito kufotokoza zomwe zili mkati mwa maselo amodzi kapena maselo pafupi ndi maselo omwe ali pafupi.

Ntchito zake zikuphatikizapo:

• Kujambula deta ndi kupanga
• Kujambula mafomu
• Kudzaza maselo okhala ndi manambala angapo, monga osamvetseka kapena nambala
• Kuwonjezera masiku a sabata kapena mwezi amalembedwa ku tsamba lokumbukira
• Kuwonjezera mndandanda wazinthu zomwe zimagwiritsidwa ntchito kawirikawiri, monga mayina a dipatimenti kapena mauthenga a lipoti, ku tsamba la ntchito

Kugwira Ntchito Yodzaza

Mankhwala odzaza amagwira ntchito mogwirizana ndi mbewa. Kugwiritsa ntchito:

1. Onetsetsani selo (s) zomwe zili ndi deta kuti zikhombedwe kapena, panthawi ya mndandanda, zowonjezera.
2. Ikani pointer ya mouse pamasamba odzaza-pointer amasintha ku chiphindi chaching'ono chakuda chakuda ( + ).
3. Lembani ndi kugwira batani lamanzere.
4. Kokani mankhwala odzaza ku selo kapena malo omwe akupitawo.

Kujambula Deta Popanda Kulimbitsa

Pamene deta imasindikizidwa ndi kukhutira, osasintha mtundu uliwonse wopangidwa ndi deta, monga ndalama, bold kapena italics, kapena selo kapena maonekedwe a mtundu, amasindikizidwanso.

Kuti mukope deta popanda kukopera ma formatting, mutatha kukopera deta ndi mankhwala odzaza, Excel ikuwonetsa Fufuzani Zomwe Mungakwaniritse pansipa ndi kumanja kwa maselo atsopano.

Kusindikiza pa batani ukutsegula mndandanda wa zosankha zomwe zikuphatikizapo:

• Sungani maselo
• Lembani zokometsa zokha
• Lembani popanda kupanga

Kusinthanitsa Podzaza osasinthikakokokoko kukasunga deta ndi kukhuta koma osati gwero lopanga.

Chitsanzo

1. Lowetsani nambala yosinthidwa-monga $ 45.98-mu selo A1 la pepala la ntchito.
2. Dinani pa selo A1 kachiwiri kuti mupange selo yogwira ntchito.
3. Ikani pointeru ya mbewa pazitsulo chodzaza (tinthu tating'onoting'onoting'onoting'onoting'ono kamene kali pansipa kumanja kwa selo A1).
4. Pogwiritsa ntchito phokoso lidzasintha ku chizindikiro chaching'ono chakuda chakuda ( + ) pamene muli nacho chotsatira.
5. Pamene pointer ya mouse imasintha ku chizindikiro chophatikiza, dinani ndikugwiritsira ntchito batani.
6. Kokani chotsani chodzaza ku selo A4 kuti mufanizire nambala ya $ 45.98 ndi kukonzera ma selo A2, A3, ndi A4.
7. Maselo A1 mpaka A4 ayenera tsopano kukhala ndi nambala yokonzedwa $ 45.98.

Kujambula Mafomu

Mafomu omwe amakopedwa pogwiritsira ntchito chodzaza adzakhala osinthidwa kuti agwiritse ntchito deta pamalo awo atsopano ngati atalengedwa pogwiritsa ntchito ma selo.

Zolemba za magulu ndizolemba kalata ndi nambala ya mzere wa selo kumene deta yomwe ikugwiritsidwa ntchito muyiyi, monga A1 kapena D23.

Mu chithunzi pamwambapa, selo H1 liri ndi fomu yomwe imaphatikiza pamodzi manambala mu maselo awiri kumanzere.

Mmalo molowa manambala enieni mu chiganizo mu H1 kupanga chojambula ichi,

= 11 + 21

Mafotokozedwe a selo amagwiritsidwa ntchito mmalo mwake ndipo ndondomeko imakhala:

= F1 + G1

Mu mayankho onsewa, yankho mu selo H1 ndi: 32, koma chiganizo chachiwiri, chifukwa chagwiritsidwa ntchito pogwiritsa ntchito maselo akhoza kukopera pogwiritsira ntchito mankhwala odzaza maselo H2 ndi H3 ndipo idzapereka zotsatira zolondola pa deta mizere.

Chitsanzo

Chitsanzo ichi chimagwiritsa ntchito mafotokozedwe a selo m'mafomu, choncho mafotokozedwe onse a selo muzokambirana omwe amakopedwa adzasintha kuti asonyeze malo awo atsopano.

1. Onjezerani deta lowonedwa mu chithunzi pamwambapa kwa maselo F1 mpaka G3 mu tsamba lokumbukira.
2. Dinani pa selo H1.
3. Lembani fomu: = F1 + G1 mu selo G1 ndi kulowetsani Enter key pa makiyi.
4. Yankho 32 liyenera kuoneka mu selo H1 (11 + 21).
5. Dinani pa selo H1 kachiwiri kuti mupange selo yogwira ntchito.
6. Ikani pointeru ya mbewa pazitsulo chodzaza (tinthu tating'onoting'onoting'onoting'ono tating'onoting'ono kamene kali kumunsi kumanja kwa selo H1).
7. Pogwiritsa ntchito phokoso lidzasintha ku chizindikiro chaching'ono chakuda chakuda ( + ) pamene muli nacho chotsatira.
8. Pamene pointer ya mouse imasintha ku chizindikiro chophatikizapo, dinani ndi kugwira batani lamanzere.
9. Kokani mankhwala odzaza pa selo H3 kuti mufanizire fomuyi ku maselo H2 ndi H3.
10. Maselo H2 ndi H3 ayenera kukhala ndi chiwerengero cha 72 ndi 121 motsatira - zotsatira za mawonekedwe omwe amajambula maselo.
11. Ngati inu mutsegula pa selo H2 fomu = F2 + G2 ingakhoze kuwonedwa mu bar barula pamwamba pa tsamba.
12. Ngati inu mutsegula pa selo H3 mndandanda = F3 + G3 mukhoza kuwona mu bar.

Kuwonjezera Mndandanda wa Numeri kwa Maselo

Ngati Excel ikuzindikira seloyo ngati gawo la mndandanda, idzagwirizanitsa ma selo ena osankhidwa ndi zinthu zotsatirazi mndandanda.

Kuti muchite zimenezi, muyenera kulemba deta yokwanira yosonyeza chitsanzo cha Excel, monga kuwerengera ndi ziwiri, zomwe mukufuna kuzigwiritsa ntchito.

Mukatha kuchita izi, kugwiritsira ntchito kungagwiritsidwe ntchito kubwereza mndandanda nthawi zambiri pakufunika.

Chitsanzo

1. Lembani chiwerengero chachiwiri mu selo D1 ndikusindikizira fungulo lolowani mukhiyi.
2. Lembani chiwerengero chachinayi mu selo D2 ndikusindikizani ku Enter.
3. Sankhani maselo D1 ndi D2 kuti awoneke .
4. Dinani ndikugwiritsira ntchito pointer la ndondomeko pazitsulo chodzaza pansi kumbali yakumanja ya selo D2.
5. Kokani chotsezera chodzaza pansi ku cell D6.
6. Maselo D1 mpaka D6 ayenera kukhala ndi manambala: 2, 4, 6, 8, 10, 12.

Kuwonjezera Masiku a Sabata

Excel ili ndi mndandanda wa maina, masiku a sabata ndi miyezi ya chaka, zomwe zingathe kuwonjezeredwa pa tsambalo pogwiritsira ntchito chodzaza.

Kuti muwonjezere mayina pa tsamba, muyenera kungouza Excel zomwe mukufuna kulemba ndipo izi zikuchitika polemba dzina loyamba mndandanda.

Kuwonjezera masiku a sabata mwachitsanzo,

1. Lembani Lamlungu int o selo A1.
2. Dinani ku key lolowamo pa khibhodi.
3. Dinani pa selo A1 kachiwiri kuti mupange selo yogwira ntchito.
4. Ikani pointeru yamagulu pa chogwiritsira ntchito chodzaza pansi kumanja kwa ngodya ya selo yogwira ntchito.
5. Pogwiritsa ntchito phokoso lidzasintha ku chizindikiro chaching'ono chakuda chakuda ( + ) pamene muli nacho chotsatira.
6. Pamene pointer ya mouse imasintha ku chizindikiro chophatikiza, dinani ndikugwiritsira ntchito batani.
7. Kokani mankhwala odzaza pa selo G1 kuti galimoto idzaze masiku a sabata kuyambira Lolemba mpaka Loweruka.

Excel imakhalanso ndi mndandanda wa mndandanda wa mafupomu ang'onoang'ono a masiku a sabata monga Sun , Mon , ndi zina komanso maina a mwezi ndi afupi- January, February, March ndi Jan, Feb, Mar omwe angathe kukhala Wowonjezera pa tsambalo pogwiritsa ntchito ndondomeko zotchulidwa pamwambapa.

Kuti muwonjezere Mndandanda Wachikhalidwe Kuti Mudzalitse Mankhwala

Excel imakulolani inu kuti muwonjezere mndandanda wanu wa mayina monga maina a dipatimenti kapena zolemba zomwe mukugwiritsa ntchito kuti mugwiritse ntchito pogwiritsira ntchito. Mndandanda ukhoza kuwonjezeredwa pamagwiritsidwe ntchito polemba mayina mwawokha kapena powajambula kuchokera ku mndandanda womwe ulipo papepala.

Kujambula Zatsopano Zodzidza Zodzilembera Wekha

1. Dinani pa Fayilo ya tabu ya Ribbon (Excel 2007 dinani pa batani la Office).
2. Dinani Zosankha zowonjezera Excel Options dialog box .
3. Dinani Patsogolo Patali ( Excel 2007 - Tate lachidwi) kumanja kwanja.
4. Pendani ku Gawo Lachiwiri lazndandanda zam'ndandanda mu dzanja lamanja ( Excel 2007 - Top options section pa pamwamba pa tsamba ).
5. Dinani kusintha Koperani Zam'ndandanda Zamanja muzanja lamanja kuti mutsegule Bokosi la Mafotokozedwe Amtundu .
6. Lembani mndandanda watsopanowu muwindo la zolembera .
7. Dinani Add kuti muwonjezere mndandanda watsopano kuwindo la Custom Lists pazanja lamanzere.
8. Dinani KOPEREKEZE kawiri kuti mutseke mabokosi onse a zokambirana ndikubwezereni kuntchito.
9. Yesani mndandanda watsopanowo polemba dzina loyambirira m'ndandanda ndikugwiritsira ntchito chida chodzaza kuti muwonjezere mayina ena pa tsamba.

Kutumiza Mndandanda Wodzakwaniritsa Zolemba Zomwe Mumakonda Kuchokera pa Tsamba Lanu

1. Onetsetsani maselo osiyanasiyana mu tsamba lomwe lili ndi zilembo, monga A1 mpaka A5.
2. Tsatirani masitepe 1 mpaka 5 pamwamba kuti mutsegule Zolemba Zokambirana Zamtundu.
3. Maselo angapo omwe asankhidwa kale ayenera kukhalapo mwa mawonekedwe a maselo omveka , monga $ A $ 1: $ A $ 5, mu List of Import kuchokera maselo bokosi pansi pa dialog box.
4. Dinani batani la Import .
5. Tsambali yatsopano Yodzaza Zolemba imapezeka pawindo la Custom Lists.
6. Dinani KOPEREKEZE kawiri kuti mutseke mabokosi onse a zokambirana ndikubwezereni kuntchito.
7. Yesani mndandanda watsopanowo polemba dzina loyambirira m'ndandanda ndikugwiritsira ntchito chida chodzaza kuti muwonjezere mayina ena pa tsamba.