Ungayidibanisa njani ibali kwiTshathi ye-Excel ka-2010

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:

1. Kwitafile yomthombo, khetha uluhlu olufunayo lweeseli, iikholamu ezimele ziboniswe ngalo.

Khetha uluhlu olufunekayo lweeseli ezikwitheyibhile ukwakha itshathi

1. Yiya "Faka" ithebhu kwigrafu ephezulu yemenyu ephambili yenkqubo.
2. Kwibhloko ethi "Umzobo", cofa kwenye yeendawo ezibonisa ubume begraphithi. Umzekelo, unokukhetha itshathi okanye itshathi.

Izenzo zokwakha itshathi kwi-Excel ka-2010

1. 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:

1. Yakha umzobo kwesi sikimu ingentla.
2. I-hiptiulator yecala lasekhohlo icinezela i icon yeGreen Cross kwibar yesixhobo ngasekunene kwegrafu.
3. Kwezi festile zingasentla zefestile evula ecaleni kwentsomi yelegend, faka uphawu ukwenza umsebenzi.

Ukubeka i-tick ecaleni komgca "Legend" kwisiboniso sayo kwiShedyuli eyakhiweyo

1. Hlaziya umzobo. Kufuneka yongeze isayini yezinto ezivela kuluhlu lwetafile.
2. 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".

Ukutshintsha indawo yomzobo kwibhloko kwifestile efanelekileyo

Ungawutshintsha njani umbhalo webali kwitshathi kwi-Excel ka-2010

Ukurhoxiswa kwembali, ukuba ifunwa, inokutshintshwa ngokuseta ifonti efanelekileyo nobungakanani. Unokwenza lo msebenzi ngokwemiyalelo elandelayo:

1. Yakha umzobo kwaye wongeze imbali kuyo kwi-algorithm exoxwe ngentla.
2. Lungisa ubungakanani, ifonti yetekisi kuluhlu lwetheyibhile Uluhlu, kwiiseli apho kwakhiwa khona ishedyuli ngokwakhe. Xa ucacisa isicatshulwa kwikholamu yetafile, isicatshulwa kwimbali yetshathi iza kutshintsha ngokuzenzekelayo.
3. 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:

1. Yakha umzobo kwipleyiti yomthombo kwaye uye kwi-"yobeko" ithebhu ngaphezulu kwemenyu ephambili yenkqubo.
2. Indawo yomsebenzi kunye nemizobo iya kuvulwa, apho iiparamitha ezininzi ziyafumaneka ukutshintsha. Kule meko, umsebenzisi kufuneka acofe iqhosha elithi "umzobo".
3. Kuluhlu olundisiweyo lweendlela zokhetho, khetha uhlobo lohlobo lwendawo. Ingabekwa embindini wokugqobhoza, okanye ngaphezulu kweshedyuli.

Ukongeza izihloko kwitshathi kwi-Microsoft Excel

1. 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.

UTSHINTSHO OLONGOSA kwigama legama

1. 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.

Ukutyikitya i-axes kwitshathi

Enye indlela yokutshintsha itshathi yeNqaku kwi-Excel

Unokuhlela isicatshulwa seShedyuli kwiShedyuli usebenzisa isixhobo esakhiwe kwinkqubo. Ukwenza oku, kufuneka wenze amanyathelo ambalwa alula kwi-algorithm:

1. I-menapilator eyintloko ye-Manipulator icofa kwimbali yegama elifunayo kwitshathi eyakhiweyo.
2. Kwifestile yewomxholo yefestile, cofa kwi "Filters" umgca ". Emva koko, ifestile yeefilimu ze-field ezivulekileyo.
3. Cofa kwiqhosha "Khetha Idatha", ibekwe ezantsi kwefestile.

Ifestile yeBhodi yeMfesane kwi-Excel

1. Kwimenyu entsha "Khetha imithombo yedatha", kuya kufuneka ucofe "utshintsho" kwibhloko "yebali".
2. Kwifestile elandelayo kwi "Groney Igama", uza kubhalisa igama elahlukileyo kwinqaku elikhethiweyo ngaphambili kwaye ucofe u "Kulungile".

Ukubhala igama elitsha kwizinto zegrafu

1. 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.