I-Excel 2003 iTayiti yeTyiti yeTeyi

01 ngo-10

I-Excel 2003 iTayiti yeTyiti yeTeyi

Le tutorial ihlanganisa amanyathelo okudala ishadi leepeyi kwi-Excel 2003 usebenzisa iWebel Chart Wizard.

Ukugqiba amanyathelo kwizihloko ezingezantsi kuza kuvelisa iseshati yeepayi efana nomfanekiso ongentla.

Ukwahluka kweenguqulelo

Amanyathelo kule tutorial basebenzisa iindlela zokufometha kunye neendlela zokufumaneka ezikhoyo kwi-Excel 203. Ezi zihluke kwizinto ezifumaneka kwiinguqulelo zangaphambili zenkqubo. Sebenzisa ezi zilandelayo ziqhagamshelo zezifundo zegrafu zeetrafini kwezinye iinguqulelo ze-Excel.

02 ngo 10

Ukufaka iData yeDatha yeDatha

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Kungakhathaliseki ukuba uluphi uhlobo lwetshathi okanye igrafu oyidalayo, isinyathelo sokuqala ekudaleni idilesi ye-Excel lihlala lifaka idatha kwiphepha lokusebenzela.

Xa ufaka idatha, gcina le mithetho engqondweni:

1. Ungashiyi imigca okanye iikholomu ezingenanto xa ufaka idatha yakho.
2. Faka idatha yakho kwiikholomu.

• Xa ubeka i- spreadsheet yakho, dwelisa amagama achaza idatha kwikholamu enye kwaye, ekunene kwaloo, idatha ngokwayo.
• Ukuba kukho uchungechunge olungaphezulu kweyodwa yedatha, babhale uluhlu emva kolunye kwiikholamu kunye nesihloko kwinqaku nganye yedatha phezulu.

Kule khokelo

1. Faka idatha njengoko iboniswe kumfanekiso ongentla kwiiseli A3 ukuya kwi-B6.

03 ngo 10

Ukukhetha iData yeDatha yeDatha

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Ukusebenzisa imouse

1. Drag ukhethe kunye nekhompi ye mouse ukuze ukhankasele iiseli eziqulethe idatha ukuba zifakwe kwigrafu.

Ukusebenzisa ikhibhodi

1. Cofa kwi-top left of data yegrafu.
2. Gcina phantsi iqhosha le- SHIFT kwibhodibhodi.
3. Sebenzisa izitshixo zitshixo kwibhodibhodi ukhethe idatha ukuba ifakwe kwididi yepayi.

Qaphela: Qiniseka ukuba ukhethe nayiphi na ikholomu kunye nezihloko ezihamba phambili ofuna ukufakwa kwigrafu.

Kule khokelo

1. Gqamisa ibloko leeseli ukusuka kwi-A3 ukuya kwi-B6 usebenzisa enye yeendlela ezi ngasentla.

04 we-10

Ukuqala kwiWeb Wizard

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Unokukhetha ezimbini ukuqala iWebel Chart Wizard.

1. Cofa kwi icon yeWebhu yeTyrtti kwibharari yesikhokelo esiphantsi (khangela umzekelo wesithombe ngaphezulu)
2. Chofoza kwi Faka> Ishadi ... kumamenyu.

Kule khokelo

1. Qala iWebhu yeSiza ngeendlela ozikhethayo.

05 we-10

I-Excel iKhadi Wizard Isinyathelo 1

Khetha iThart kwi-Standard Tab

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

1. Khetha uhlobo lweTrart ukusuka kwipaneli lasekhohlo.
2. Khetha icandelo elingaphantsi kwetafile ukusuka kwicala elifanelekileyo.

Kule khokelo

1. Khetha uhlobo lweetayiti ekhompini.
2. Khetha i- Pie nge-3-D yomboniso wesalathisi phantsi kwesandla sokunene
3. Chofoza Okulandelayo.

06 ngo 10

I-Excel iKhadi Wizard Isinyathelo 2

Khangela kuqala iTharthi yakho

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

• Emva kokuba ukhethe idatha yakho ngaphambi kokuba uqale iWebel Chart Wizard, kufuneka ubone umzekelo wetshathi yakho kwifestile ephezulu kwibhokisi yencoko.
• Kwi- spreadsheet yakho, idatha efakwe kwitekiti ijikelezwe yizintuthwane ezihambayo-umda omnyama onomtsalane malunga nedatha yakho.
• Ngaphantsi kwefestile yokujonga kuqala ibhokisi equlethe iinkcukacha zeseli zoluhlu lweedatha olufakwe kwitshathi. Ukuba isatshati yakho ingakhange ibonakale kakuhle, khangela ukuba unyule uluhlu lwe data olufanelekileyo kwi-spreadsheet.

Kule khokelo

1. Chofoza Okulandelayo.

07 ngo 10

I-Wizard ye Excel Chart Isinyathelo 3

Izinketho zeTyrt

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Nangona kukho iinketho ezininzi phantsi kweetekisi ezithandathu zokuguqula ukubonakala kwetshathi yakho, kweli nqanaba, siza kufaka izihloko kuphela.

Zonke iicandelo zetshathi ye-Excel zingaguquzwa emva kokuba ugcwalise iWeb Wizard, ngoko akufuneki ukuba wenze zonke iindlela zakho zokufometha kwangoku.

Kule khokelo

1. Cofa kwiTyhupha yeTytile phezulu kwebhokisi yencoko yababini yeShadi.
2. Kwibhokisi yebhokisi yeTyrtti, thayipha isihloko: I-Reko ye-Cookie Shop 2007 Revenue Sales .
3. Cofa kwiTebhu yeeLebhile zeDatha kwi-bhokisi yencoko yeebhokisi yeWebhu.
4. Kwileta Iqukethe icandelo, nqakraza kwikhetho lePesenti yokuyikhetha.
5. Xa ishati kwiwindow yokubuka kuqala ibonakala kakuhle, nqakraza Okulandelayo.

Qaphela: Njengoko ungeze iileta zetekisi kunye nedatha kufuneka zifakwe kwiwindow yokubuka kuqala ukuya kwesokudla.

08 ngo 10

I-Wizard ye Excel Chart Isinyathelo 4

Indawo yeTyati

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Kukho ukhetho olubini kuphela apho ufuna ukufaka ifati yakho:

1. Njengomshicileli omtsha (faka ishadi kwikhasi lokusebenzela eyahlukileyo ukusuka kwincwadi yakho yokusebenzela)
   
2. Njengento kwiphepha 1 (faka ishadi kwikhasi elifanayo kunye nedatha yakho kwincwadi yokusebenzela)

Kule khokelo

1. Cofa kwiqhosha lerediyo ukuze ufake ishati njengento kwiphepha 1.
2. Cofa uqhafaza.

Isalathisi esisiseko esisiseko sidalwa kwaye sifakwe kwiphepha lakho lokusebenzela. Ukufomathiza iphepha elilandelayo lifomathile kule tstsana ukulinganisa ityiti yeepeyi eboniswe kwiNyathelo 1 yale khokelo.

09 we-10

Ukongeza Umbala kwiChart Chart

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Shintsha umbala wangasemva wetadi

1. Ukucofa ngokukhawuleza kanye kunye nomkhomba we mouse kwiyiphi imvelaphi emhlophe yegrafu ukuvula imenyu ehlayo.
2. Cofa nge mouse ekhompyutheni kwindlela yokuqala kwimenyu: Yenza ifomathi yeStatshi ukuze uvule ibhokisi yencoko yendawo yefayile yeTyrtti.
3. Cofa kwii Patterns ithebhu ukuze ukhethe.
4. Kwinqanaba leNgingqi , nqakraza kwisikwere semibala ukuze ukhethe.
5. Kule khokelo, khetha umbala obomvu ngaphantsi kwebhokisi yencoko yababini.
6. Chofoza OK.

Shintsha umbala wesiqalo / susa umda ukusuka kumgca

1. Ukucofa ngokukhawuleza kanye kunye nomkhomba we mouse ngaphi kwimbali yesigcawu segrafu ukuvula imenyu ehlayo.
2. Cofa kunye nekhompi ye mouse kwikhetho lokuqala kwimenyu: Yenza i-Legend Legend ukuvula ibhokisi yencoko yencoko yefayile.
3. Cofa kwii Patterns ithebhu ukuze ukhethe.
4. Kwiqendu lomdawulo ngakwesobunxele kwibhokisi yencoko, nqakraza kwiNdawo engekho yokususa umda.
5. Kwinqanaba leNgingqi , nqakraza kwisikwere semibala ukuze ukhethe.
6. Kule khokelo, khetha umbala obomvu ngaphantsi kwebhokisi yencoko yababini.
7. Chofoza OK.

10 kwi-10

Ukuxhaphaza i-Piece of Pie

Qaphela: Ukuze uncede ngale miyalelo, khangela umzekelo wesentla apha.

Ukongeza ugxininiso kwisiqephu esithile se-pie ongashenxisa okanye "uqhube" le ngceka ephuma kwenye iseshati.

1. Cofa kunye nekhompi ye mouse kwi satshati ukuyiqokomisa. Iibhloko ezincinci ezimnyama zimele zibonwe kumda wangaphandle we-pie.
2. Cofa okwesibini nge-mouse pointer kwi-yellow (oatmeal grain). Iibhloko ezimnyama kufuneka ngoku zizungeze nje eli qhekeza elilodwa le-pie.
3. Cofa uze udibe ngakwesobunxele kunye nekhompi ye mouse kwiqhekeza eliphuzi le-pie. Isiqwenga sifanele sishiye kwenye indawo yetshathi.
4. Ukuhambisa isahluko esiqhekekileyo kwindawo yayo yangaphambili phinda amanyathelo 1 no-2 ngasentla uze udonsa ucezu kwakhona kwi-pie. Kuya kubuyela ngokuzenzekelayo kwindawo yayo yangaphambili.

Ngeqhephu oluphuzi luqhube isatshati yakho imele ifane neesayiti zeetayi eziboniswe kwiNyathelo 1 yale khokelo.