Dala uhlu lokudonsa phansi ku-Excel kusuka kwenye ishidi

Ukudala uhlu lokudonsa ku-Excel kukuvumela ukuba ufake idatha esitokisini esithile sephepha lokusebenzela kusuka kuhlu oluhleliwe lokufakiwe.

Izinzuzo zokusebenzisa uhlu lokudonsa zibandakanya:

• Ukwenza ukungena kwedatha kulula
• Ukuvimbela amaphutha wokufaka idatha
• Ikhawulela inani lezindawo zokufaka idatha

I-Excel Drop Down Down Uhlu Isinyathelo Ngesifundo Izihloko Zezifundo

• Ukufaka idatha yokufundisa
• Ukwakha Uhlobo Olubizwa NgeDatha
• Ukuqala uhlu lokudonsa phansi
• Usebenzisa uhlu lokuqinisekisa idatha
• Ukufaka Umthombo Wedatha nokugcwalisa Uhlu Lokunciphisa
• Ukushintsha Izinto Zohlu
• Izinketho zokuvikela uhlu lokudonsa phansi

Ukufaka idatha yokufundisa

Isinyathelo sokuqala sokwakha uhlu lokudonsa ku-Excel ukufaka idatha .

Qaphela: Imiyalo yokufundisa ayifaki ukufomatha izinyathelo zephepha lokusebenzela.

Lokhu ngeke kuphazamise ukuqedela ukufundisa. Iphepha lakho lokusebenzela lizobonakala lihlukile kunesibonelo ekhasini 1, kodwa uhlu lokudonsa luzokunika imiphumela efanayo.

Faka idatha ngezansi kumaseli aboniswe kumashidi eyodwa kanye nambili ebhuku le-Excel.

Izinyathelo Zokufundisa

1. Faka imininingwane elandelayo kumaseli afanele kuShidi 1 lephepha lokusebenzela: D1 - Uhlobo lwe-Cookie:
2. Chofoza kuthebhu yeShidi leShidi 2.
   
3. Faka imininingwane elandelayo kumaseli afanele kuShidi 2 lephepha lokusebenzela:
   A1 - I-Gingerbread A2 - I-Lemon A3 - I-Oatmeal Raisin A4 - I-Chocolate Chip

Uhlu lokudonsa luzofakwa kwiseli E1 eshidi 1.

Ukudala Uhlobo Olubizwa NgeDatha Yedatha

Ibanga elibizwe likuvumela ukuthi ubheke ububanzi obuthile bamaseli encwadini ye-Excel.

Izigaba ezibizwa ngokuthi i-Excel zibandakanya ukuzisebenzisa ngamafomula kanye nokudala amashadi.

Kuzo zonke izimo, ububanzi obunqunyelwe busetshenziselwa indawo yobuningi bezinkomba ezibonisa ukuthi indawo yedatha kushicilelo.

Uma lisetshenziswe kuhlu oludonsela phansi, uhla olubizwa ngokuthi lusetshenziswa njengomthombo wezinto zohlu.

Izinyathelo Zokufundisa

1. Hudula ukhethe amaseli A1 - A4 kuShidi 2.
2. Chofoza ebhokisini legama elisenhla kwekholomu A
3. Thayipha "amakhukhi" (ayikho izingcaphuno) ebhokisini legama
4. Cindezela inkinobho ENTER ekhibhodi
5. Amaseli A1 kuya ku-A4 ephepheni 2 manje anegama lebanga "lamakhukhi"
6. Londoloza ishidi lakho lokusebenzela

Ukuvula ibhokisi lokungena lokuqinisekisa idatha

Zonke izinketho zokuqinisekiswa kwedatha ku-Excel, kufaka phakathi uhlu lokudonsa phansi, zibekwe kusetshenziswa ibhokisi lengxoxo yokuqinisekisa idatha.

Ibhokisi lebhokisi lengxoxo yokuqinisekiswa kwedatha litholakala ngaphansi kwethebhu yedatha yebhebhoni .

Izinyathelo Zokufundisa

1. Chofoza kuthebhu ye-Sheet 1 phansi kweskrini ukuze ushintshe ishidi 1
2. Chofoza ku-cell E1 ukuze wenze iseli esebenzayo - yilapho uhlu lokudonsa luzobe lukhona
3. Chofoza kuthebhu yedatha yedatha yemenyu ye-ribbon ngaphezulu kwephepha lokusebenzela
4. Chofoza kusithonjana sokuqinisekiswa kwedatha kwi-Ribbon ukuvula imenyu yehla
5. Chofoza ku-Option Data Validation kwimenyu ukuvula ibhokisi lengxoxo ye-Data Validation

Usebenzisa uhlu lokuqinisekisa idatha

Ngaphezu kokungeza uhlu lwezintambo phansi kwephepha lokusebenzela, ukuqinisekiswa kwedatha ku-Excel kungasetshenziswa futhi ukulawula noma ukunciphisa uhlobo lwedatha olungangena kumaseli athile.

Ezinye zezinketho ezivame ukusetshenziswa:

• Uhlu
• Izinsuku kanye / noma izikhathi
• Izinombolo eziphelele
• Umbhalo
• Amafomula (abekwe ngaphansi kokukhethwa komkhuba )

Kulesi sinyathelo, sizokhetha ukhetho lohlu njengoba uhlobo lokuqinisekiswa kwedatha oluzosetshenziselwa iselula E1 eshadini 1.

Izinyathelo

1. Chofoza ku- Izilungiselelo ithebhu ebhokisini lengxoxo
2. Chofoza umcibisholo ophansi ekupheleni kwe- Allow line ukuze uvule imenyu yehla
3. Chofoza ohlwini ukuze ukhethe uhlu olwehlisiwe lokuqinisekiswa kwedatha kuseli D1 futhi usebenze umthombo womthombo ebhokisini lengxoxo

Ukufaka Umthombo WeDatha nokugcwalisa Uhlu Lokudonsa phansi

Njengoba umthombo wedatha lohlu olwehlisiwe lukhona ekhasini lokusebenzela elihlukile, ububanzi obuqanjwe ngaphambilini obudalwe ngaphambilini buzofakwa emgqeni womthombo ebhokisini lengxoxo .

Izinyathelo

1. Chofoza kulayini lomthombo
2. Thayipha "= amakhukhi" (ayikho izingcaphuno) emgqeni womthombo
3. Chofoza u- Kulungile ukuqedela uhlu lokudonsela phansi bese uvale ibhokisi lengxoxo ye- Data Validation
4. I-icon encane yomcibisholo ophansi isekelwe ngakwesokudla kweselula E1
5. Ukuchofoza umcibisholo ophansi kufanele uvule uhlu oluhlehlisiwe oluqukethe amagama amane ekhukhi angeniswa kumaseli A1 kuya ku-A4 ekhasini 2
6. Ukuchofoza kumunye wamagama kufanele ufake lelo gama libe yiseli E1

Ukuhlela Izinto Zohlu

Ukuze ugcine uhlu olwehlisiwe kusesimweni nezinguquko kudatha yakho, kungase kudingeke ukuthi ushintshe ngezikhathi ezithile izinqumo ohlwini.

Njengoba sasebenzisa ububanzi obubizwa ngokuthi umthombo wezinto zethu ohlwini kunamagama ohlu lwamagama, ukushintsha amagama wekhukhi ebangeni eliqanjwe elisezinteleni A1 kuya ku-A4 ekhasini 2 ngokushesha ushintshe amagama ohlwini lokudonsa phansi.

Uma idatha ingeniswa ngqo ebhokisini lebhokisi, ukwenza izinguquko ohlwini kufaka ukubuyela emuva ebhokisini lengxoxo bese uhlela umthombo womsakazo.

Kulesi sinyathelo, sizoguqula isifungo esifushane kuya ku- Oatmeal Raisin ohlwini oluhlehlisayo ngokushintsha idatha eselifenini A3 yobubanzi obuqanjwe.

Izinyathelo

1. Chofoza esitokisini se-A3 ekhasini 2 (Isifinyezo esifushane) ukuze senze iseli elisebenzayo
2. Thayipha i- Oatmeal Raisin ibe yiseli A3 bese ucindezela ukhiye wokungena kwikhibhodi
3. Chofoza umcibisholo ongezansi uhlu lwamanethiwekhi e-E1 yeshidi 1 ukuvula uhlu
4. Into yesi-3 ohlwini kufanele ifunde i- Oatmeal Raisin esikhundleni se- Shortbread

Izinketho zokuvikela uhlu lokudonsa phansi

Kusukela idatha yethu isemakhasini ahlukene ahluke ohlwini olwehlayo izinketho ezimbili ezitholakalayo zokuvikela idatha yohlu yilezi:

• Fihla ishidi lokusebenzela eliqukethe idatha (ishidi 2)
• Vikela iphepha lokusebenzela elifaka ukuvala amangqamuzana A1 kuya ku-A4 ekhasini 2

Uma ukuphepha kungakhathazeki, ukufihla iphepha lokusebenzela eliqukethe idatha yolwazi kuyindlela enhle ngoba yenza kube lula ukubuyekeza uhlu uma kudingeka.

Uma ukuphepha kukukhathazeka iphasiwedi ingezwa lapho ivikela ipheshana lokuvikela ukuguqula izinto ezikuhlu.

Ukudala Uhlu Lokudonsa Ngokwehlu Lokusebenza Oluhlukile

Uhlu lokudonsa luvumela ukuthi ufake idatha ku-spreadsheet ye-Excel kusuka kuhlu oluhleliwe lokufakiwe.

Ingxenye 1 ihlanganisa izinyathelo zokwakha uhlu oluhlaselayo nedatha kushidi elifanayo njengohlu lokudonsa phansi.

Lesi sifundo sihlanganisa ukudala uhlu oluwehlisiwe kuhlu lokusebenzela oluhlukile.

Isibonelo: Ukwakha uhlu lokudonsa phansi nedatha kwiphepha lokusebenzela elihlukile

Faka imininingwane elandelayo kumaseli afanele kuSheet 1 yephepha lokusebenzela:
I-E1 - I-Cookie Shop
I-D2 - Uhlobo lwe-Cookie:
Chofoza kuthebhu yeShidi leShidi 2.
Faka imininingwane elandelayo kumaseli afanele kuSheet 2 noma ishidi lokusebenzela:
I-A1 - I-Gingerbread
I-A2 - i-Lemon
I-A3 - i-Oatmeal Raisin
I-A4 - I-Chocolate Chip
Gqamisa amaseli A1 - A4 kuShidi 2.
Thayipha "amakhukhi" (ayikho izingcaphuno) ebhokisini legama bese ucindezela ukhiye wokungena kwikhibhodi.
Chofoza kuthebhu yeSpredishithi yeShidi 1
Chofoza kuseli E2 - indawo lapho imiphumela izoboniswa khona
Chofoza kuthebhu yedatha
Chofoza ku-Option Data Validation kusuka ku-Ribbon ukuvula imenyu
Chofoza ku-Ukuqinisekiswa kwedatha kwimenyu ukukhuphula ibhokisi lengxoxo
Chofoza ku-Izilungiselelo ithebhu ebhokisini lengxoxo
Ukusuka Imenyu yokuvumela khetha Uhlu
Thayipha = amakhukhi emgqeni womthombo ebhokisini lengxoxo
Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
Umcibisholo ophansi kufanele uvele eceleni kweseli E2
Uma uchofoza umcibisholo uhlu olwehla kufanele luvulekele ukubonisa amagama amane wekhukhi