Hlunga ku-Excel - Okuyisisekelo

Ukuhlunga idatha ku-Excel kukuvumela ukuthi ubonise phakathi kwenani elikhulu lolwazi kuphela lokho okudingayo njengamanje. Isibonelo, ukuba nohlu lwezinkulungwane zezimpahla ku-hypermarket enkulu phambi kwakho, ungakhetha kuphela ama-shampoos noma okhilimu kuwo, bese ufihla okwesikhashana okunye. Kulesi sifundo, sizofunda ukuthi zisetshenziswa kanjani izihlungi ohlwini lwe-Excel, setha ukuhlunga kumakholomu amaningana ngesikhathi esisodwa, futhi ususe izihlungi.

Uma ithebula lakho liqukethe inani elikhulu ledatha, kungase kube nzima ukuthola ulwazi oludingayo. Izihlungi zisetshenziselwa ukunciphisa inani ledatha eliboniswa eshidini le-Excel, okukuvumela ukuthi ubone ulwazi oludingayo kuphela.

Ukusebenzisa isihlungi ku-Excel

Esibonelweni esilandelayo, sizosebenzisa isihlungi kulogi yokusetshenziswa kwezingxenyekazi zekhompuyutha ukuze sibonise kuphela amakhompyutha aphathekayo namathebulethi atholakalayo ukuze abuyekezwe.

1. Khetha noma iyiphi iseli kuthebula, isibonelo iseli A2.

Ukuze ukuhlunga kusebenze kahle ku-Excel, ishidi lomsebenzi kufanele libe nomugqa wesihloko osetshenziselwa ukubiza ikholomu ngayinye. Esibonelweni esilandelayo, idatha esekhasini lokusebenzela ihlelwa njengamakholomu anezihloko kumugqa 1: I-ID #, Uhlobo, Incazelo Yezingxenyekazi zekhompuyutha, njalonjalo.

1. Chofoza Idatha, bese ucindezela umyalo Hlunga.
2. Izinkinobho zemicibisholo zivela ezihlokweni zekholomu ngayinye.
3. Chofoza inkinobho enjalo kukholamu ofuna ukuyihlunga. Esimweni sethu, sizosebenzisa isihlungi kukholomu B ukuze sibone kuphela izinhlobo zezinto esizidingayo.
4. Imenyu yokuhlunga izovela.
5. Susa ukumaka ibhokisi Khetha konkeukususa ngokushesha zonke izinto.
6. Thikha amabhokisi ukuze uthole izinhlobo zezinto zokusebenza ofuna ukuzishiya kuthebula, bese uchofoza OK. Esibonelweni sethu, sizokhetha aphathekayo и Tabletsukubona lezo zinhlobo zemishini kuphela.
7. Ithebula ledatha lizohlungwa, kufihlwe okwesikhashana konke okuqukethwe okungahambisani nemibandela. Esibonelweni sethu, amalaptop namathebulethi kuphela ahlala ebonakala.

Ukuhlunga kungasetshenziswa futhi ngokukhetha umyalo Hlunga bese uhlunga ithebhu Ikhaya.

Faka izihlungi eziningi ku-Excel

Izihlungi ku-Excel zingafingqwa. Lokhu kusho ukuthi ungasebenzisa izihlungi eziningi kuthebula elifanayo ukuze unciphise imiphumela yokuhlunga. Esibonelweni sangaphambilini, sesivele silihlungile ithebula ukuze sibonise amakhompyutha aphathekayo namathebulethi kuphela. Manje umsebenzi wethu uwukunciphisa idatha nakakhulu futhi sibonise kuphela amakhompyutha aphathekayo namathebulethi athunyelwe ukuze abuyekezwe ngo-August.

1. Chofoza inkinobho yomcibisholo kukholomu ofuna ukuyihlunga. Kulokhu, sizosebenzisa isihlungi esengeziwe kukholomu D ukuze sibone ulwazi ngedethi.
2. Imenyu yokuhlunga izovela.
3. Hlola noma ususe ukumaka amabhokisi kuye ngedatha ofuna ukuyihlunga, bese uchofoza OK. Sizoyeka ukukhetha zonke izinto ngaphandle August.
4. Isihlungi esisha sizosetshenziswa, futhi amakhompyutha aphathekayo namathebulethi alethwe ukuze aqinisekiswe ngo-August kuphela azohlala etafuleni.

Ukukhipha isihlungi ku-Excel

Ngemva kokufaka isihlungi, maduze nje kuyodingeka ukuthi sisisuse noma sisisuse ukuze kuhlungwe okuqukethwe ngendlela ehlukile.

1. Chofoza inkinobho yomcibisholo kukholomu ofuna ukususa kuyo okokuhlunga. Esibonelweni sethu, sizosusa isihlungi kukholomu D.
2. Imenyu yokuhlunga izovela.
3. Khetha into Susa isihlungi kukholomu... Esibonelweni sethu, sizosusa isihlungi kukholamu Ihanjiswe ukuthi ibuyekezwe.
4. Isihlungi sizokhishwa futhi idatha ebifihliwe ngaphambilini izovela kabusha eshidini le-Excel.

Ukuze ususe zonke izihlungi kuthebula le-Excel, chofoza umyalo Hlunga ithebhu Idatha.