Thola Amanani Ayisilinganiso nge-Excel'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 ajwayelekile kukholomu ngayinye noma insimu yedatha ku-database yakho. Lesi sinyathelo ngesifundo sesinyathelo sibandakanya isibonelo sendlela yokuthola izindinganiso ezijwayelekile zekholomu ethile yedatha ku-database. Izinyathelo kulesi sifundo ziyi:

1. Faka Idatha Yokufundisa
2. Ukuhlunga Isampuli sedatha
3. Ukuthola ukulinganisa okuphakathi

01 ngo-02

Faka Idatha yokuThuthukiswa kweStotal

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.

Kulesi sifundo:

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

02 ka 02

Ukuhlunga Idatha

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 ejwayelekile 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 ekhuluma 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.