Kwi-Windows Excel Excel, unokwakha ngokukhawuleza umzobo ecaleni kwetafile iqhubekile ukubonisa iimpawu zayo eziphambili. Umzobo wenziwa ukongeza inqaku ukuze ubonakalise ulwazi oluboniswe kuwo, ubanike igama. Eli nqaku lifumana iindlela zokwenza ibali kwitshathi kwi-Excel ka-2010.
Ungayakha njani itshathi kwi-Excel kwitafile
Okokuqala, kubalulekile ukuqonde ukuba umzobo owakhelwe njani kule nkqubo ekuqwalaselwe kuyo. Inkqubo yokwakhiwa kwayo yenziwe la manyathelo alandelayo:
- Kwitafile yomthombo, khetha uluhlu olufunayo lweeseli, iikholamu ezimele ziboniswe ngalo.
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_1](/userfiles/22/1348_1.webp)
- Yiya "Faka" ithebhu kwigrafu ephezulu yemenyu ephambili yenkqubo.
- Kwibhloko ethi "Umzobo", cofa kwenye yeendawo ezibonisa ubume begraphithi. Umzekelo, unokukhetha itshathi okanye itshathi.
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_2](/userfiles/22/1348_2.webp)
- Emva kokuba ugqibe isenzo sangaphambili, iwindow enomzobo owakhelweyo kufuneka ibonakale ecaleni kweplate yegama lokuqala kwi-Excel. Iya kubonisa ukuxhomekeka phakathi kwamaxabiso athathwa njengeluhlu. Ke umsebenzisi unokumbulela ngokucacileyo umahluko kumaxabiso, ahlalutya ishedyuli kwaye agqibe kuyo.
Ungakongeza njani iNtsapho kwiTshathi ye-Excel ka-2010 ngendlela eqhelekileyo
Le yeyona ndlela ilula yokongeza inqaku elingayithathi umsebenzisi ixesha elininzi lokuphumeza. Isiseko sendlela kukwenza la manyathelo alandelayo:
- Yakha umzobo kwesi sikimu ingentla.
- I-hiptiulator yecala lasekhohlo icinezela i icon yeGreen Cross kwibar yesixhobo ngasekunene kwegrafu.
- Kwezi festile zingasentla zefestile evula ecaleni kwentsomi yelegend, faka uphawu ukwenza umsebenzi.
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_3](/userfiles/22/1348_3.webp)
- Hlaziya umzobo. Kufuneka yongeze isayini yezinto ezivela kuluhlu lwetafile.
- Ukuba kukho imfuneko, unokutshintsha indawo yeShedyuli. Ukwenza oku, cofa i-LKM kwi-legend kwaye ukhethe olunye ukhetho lwendawo. Umzekelo, "ngasekhohlo", "ezantsi", "Phezulu", "ngasekunene" okanye "ngaphezulu kwesa ngasekhohlo".
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_4](/userfiles/22/1348_4.webp)
Ungawutshintsha njani umbhalo webali kwitshathi kwi-Excel ka-2010
Ukurhoxiswa kwembali, ukuba ifunwa, inokutshintshwa ngokuseta ifonti efanelekileyo nobungakanani. Unokwenza lo msebenzi ngokwemiyalelo elandelayo:- Yakha umzobo kwaye wongeze imbali kuyo kwi-algorithm exoxwe ngentla.
- Lungisa ubungakanani, ifonti yetekisi kuluhlu lwetheyibhile Uluhlu, kwiiseli apho kwakhiwa khona ishedyuli ngokwakhe. Xa ucacisa isicatshulwa kwikholamu yetafile, isicatshulwa kwimbali yetshathi iza kutshintsha ngokuzenzekelayo.
- Jonga iziphumo.
Ungagcwalisa njani itshathi
Ukongeza kwiNqaku, kukhona idatha engaphezulu enokuboniswa kwiShedyuli eyakhiweyo. Umzekelo, igama laso. Ukuchaza into eyakhiweyo, kuyimfuneko ukuba senze ngolu hlobo lulandelayo:
- Yakha umzobo kwipleyiti yomthombo kwaye uye kwi-"yobeko" ithebhu ngaphezulu kwemenyu ephambili yenkqubo.
- Indawo yomsebenzi kunye nemizobo iya kuvulwa, apho iiparamitha ezininzi ziyafumaneka ukutshintsha. Kule meko, umsebenzisi kufuneka acofe iqhosha elithi "umzobo".
- Kuluhlu olundisiweyo lweendlela zokhetho, khetha uhlobo lohlobo lwendawo. Ingabekwa embindini wokugqobhoza, okanye ngaphezulu kweshedyuli.
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_5](/userfiles/22/1348_5.webp)
- Emva kokwenza ubugqwetha bangaphambili, umzobo "uvela kwigrafu eyakhiweyo. Umsebenzisi wakhe uya kuba nakho ukutshintsha, amise ngesandla kwikhibhodi yekhompyuter nakweyiphi na enye indibaniselwano yamagama afanelekileyo kwitafile yetafile.
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_6](/userfiles/22/1348_6.webp)
- Kubalulekile ukusayina i-axis kwitshathi. Babhalisela ngendlela efanayo. Kwibhloko yomsebenzi kunye neetshathi, kuya kufuneka ucofe iqhosha elithi "Axis Igama". Kuluhlu olungafumanekiyo, khetha enye ye-axes: nokuba nkqo okanye ethe tye. Okulandelayo, yenza utshintsho olufanelekileyo lwendlela ekhethiweyo.
![Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010 1348_7](/userfiles/22/1348_7.webp)
Enye indlela yokutshintsha itshathi yeNqaku kwi-Excel
Unokuhlela isicatshulwa seShedyuli kwiShedyuli usebenzisa isixhobo esakhiwe kwinkqubo. Ukwenza oku, kufuneka wenze amanyathelo ambalwa alula kwi-algorithm:- I-menapilator eyintloko ye-Manipulator icofa kwimbali yegama elifunayo kwitshathi eyakhiweyo.
- Kwifestile yewomxholo yefestile, cofa kwi "Filters" umgca ". Emva koko, ifestile yeefilimu ze-field ezivulekileyo.
- Cofa kwiqhosha "Khetha Idatha", ibekwe ezantsi kwefestile.
- Kwimenyu entsha "Khetha imithombo yedatha", kuya kufuneka ucofe "utshintsho" kwibhloko "yebali".
- Kwifestile elandelayo kwi "Groney Igama", uza kubhalisa igama elahlukileyo kwinqaku elikhethiweyo ngaphambili kwaye ucofe u "Kulungile".
- Jonga iziphumo.
Ukuqukumbela
Ke, ukwakhiwa kwembali kwi-Microsoft i-Excel Excel ka-2010 yahlulwe yangamanqanaba aliqela, nganye ifuna isifundo esineenkcukacha. Ukuba unqwenela, ulwazi olukwitshathi lunokukhawuleza uhlule. Ngaphezulu kwemithetho esisiseko yomsebenzi kunye neetshathi e-Excel zachazwa.
Umyalezo Wongeza njani iNqaku kwiTshathi ye-Excel ivele kuqala kwitekhnoloji yolwazi.