Indlela Yokuthola Imilinganiselo Ekhulu Kunazo zonke ku-Excel Database noma Uhlu

01 ngo-04

I-Excel SUBTOTAL Isici Sibutsetelo

Thola izilinganiso ezinkulu kakhulu nge-Excel 2007's Subtotal Feature

I-Excel's Subtotal isici isebenza ngokufaka umsebenzi we-SUBTOTAL ku- database noma uhlu lwemininingwane ehlobene. Ukusebenzisa i-Subtotal feature kwenza ukuthola nokukhipha ulwazi oluqondile kusuka etafuleni elikhulu lwedatha ngokushesha futhi kulula.

Ngisho noma ibizwa ngokuthi "i-Subtotal feature", awukhawulelwanga ukuthola isamba noma inani lemigqa ekhethiwe yedatha. Ngaphezu kokuphelele, ungathola futhi amanani amakhulu kunazo zonke kwisigatshana ngasinye se-database.

Lesi sifundo sinyathelo ngesinyathelo sibandakanya isibonelo sendlela yokuthola inani eliphakeme kakhulu lokuthengisa kwisifunda ngasinye sokuthengisa.

Izinyathelo kulesi sifundo ziyi:

1. Faka Idatha Yokufundisa
2. Ukuhlunga Isampuli sedatha
3. Ukuthola inani elikhulu kakhulu

02 ka 04

Faka Idatha yokuThuthukiswa kweStotal

Qaphela: Ukuze uthole usizo ngalezi ziqondiso bheka isithombe esingenhla.

Isinyathelo sokuqala sokusebenzisa i-Subtotal feature ku-Excel ukufaka idatha kushidi lokusebenzela .

Uma wenza kanjalo, gcina izingqondo ezilandelayo engqondweni:

• Kubalulekile ukufaka idatha ngendlela efanele. Amaphutha, abangelwa ukungena kwedatha okungalungile, angumthombo wezinkinga eziningi ezihlobene nokuphathwa kwedatha.
  
• Shiya imigqa noma amakholomu angenalutho uma ufaka idatha. Lokhu kuhlanganisa ukungashiyi umugqa ongacacile phakathi kwezihloko zekholomu kanye nomugqa wokuqala wedatha.

Kule Nfundo

Faka idatha kumaseli A1 kuya ku-D12 njengoba kuboniswa esithombeni ngenhla. Kulabo abangacabangi ukuthayipha, idatha, imiyalo yokuyikopisha ku-Excel, iyatholakala kule sixhumanisi.

03 ka 04

Ukuhlunga Idatha

Qaphela: Ukuze uthole usizo ngalezi ziqondiso bheka isithombe esingenhla. Chofoza kusithombe ukuze ukhulise.

Ngaphambi kokuba ama-subtotal angasetshenziswa, idatha yakho kufanele iqoqwe ikholomu yedatha ofuna ukukhipha ulwazi kusuka.

Lokhu kuqoqa kwenziwa ngokusebenzisa i-Excel's Sort feature .

Kulesi sifundo, sifuna ukuthola inombolo ephakeme kakhulu yama-oda esifundeni ngasinye sokuthengisa ukuze idatha ihlelwe yi-heading Region .

Ukuhlunga Idatha Ngomkhakha Wokuthengisa

1. Hudula ukhethe amaseli A2 kuya ku-D12 ukuze uwaqokomise. Qiniseka ukuthi ungafaki isihloko kumugqa owodwa ekukhethweni kwakho.
   
2. Chofoza kuthebhu yedata yedatha.
   
3. Chofoza inkinobho yoHlelo ephakathi nendawo yebhanethi yedatha ukuvula ibhokisi lebhokisi lezinhlobo .
   
4. Khetha Uhlobo Ngomkhakha kusuka kuhlu lokudonsa phansi ngaphansi kwekholomu ebhokisini lengxoxo.
   
5. Qinisekisa ukuthi idatha yami inezinhloko zihlolwe ekhoneni eliphezulu lesokudla lebhokisi lebhokisi.
   
6. Chofoza OK.
   
7. Idatha kumaseli A3 kuya ku-D12 kufanele ihlelwe manje ngama-alfabhethi ngendawo yesibili ikholomu. Idatha yezintathu zokuthengisa ezivela esifundeni saseMpumalanga kufanele ibhalwe ohlwini kuqala, ilandelwe iNyakatho, bese iseningizimu, bese igcina isifunda saseNtshonalanga.

04 ka 04

Ukuthola Ukubaluleka Okukhulu Kokusebenzisa Ama-Subtotals

Qaphela: Ukuze uthole usizo ngalezi ziqondiso bheka isithombe esingenhla.

Kulesi sinyathelo, sizosebenzisa i-Subtotal feature ukuze sithole isilinganiso esiphezulu sokuthengisa isilinganiso esifundeni ngasinye. Ukuze uthole inani eliphakeme noma elikhulu kakhulu, isici se-Subtotal sisebenzisa umsebenzi we-MAX.

Kulesi sifundo:

1. Hudula ukhethe idatha kumaseli A2 kuya ku-D12 ukuyiqokomisa.
   
2. Chofoza kuthebhu yedata yedatha.
   
3. Chofoza inkinobho ye-Subtotal ukuvula ibhokisi lengxoxo le-Subtotal.
   
4. Ngokuqala okukhethwa kukho ebhokisini lengxoxo Kushintsho ngalunye ku: khetha Isifunda kusuka kuhlu lokudonsa phansi.
   
5. Ngenketho yesibili ebhokisini lengxoxo Sebenzisa umsebenzi: khetha u- MAX ohlwini lokudonsa.
   
6. Ngenketho yesithathu ebhokisini lezingxoxo Yengeza ama-subtotals ukuze: hlola Ukuthengisa Okuphelele kuphela ohlwini lwezinketho ezinikezwe efasiteleni.
   
7. Kumabhokisi amathathu wokuhlola ngezansi kwebhokisi lengxoxo, hlola:
   
   Faka esikhundleni se-subtotals yamanje
   Isifinyezo ngezansi kwedatha
   
8. Chofoza OK.
   
9. Ithebula lwedatha kufanele lifake inani eliphakeme kakhulu lokuthengisa esifundeni ngasinye (imigqa 6, 9, 12, no-16) kanye ne- Grand Max (inani eliphakeme kakhulu lokuthengisa kuzo zonke izifunda) emgqeni 17. Kufanele lifanane nesithombe phezulu kwalesi sifundo.