Microsoft Excel software ce ta falle wanda ke ba masu amfani damar tsarawa, tsarawa, da lissafin bayanai tare da dabaru ta amfani da tsarin sel da aka raba ta layuka da ginshiƙai.
Fahimtar manufar jerin zaɓuka a cikin Excel
Kafin mu shiga cikakkun bayanai kan yadda ake ƙirƙirar jerin zaɓuka a cikin Excel, da farko muna buƙatar fahimtar sosai menene jerin zaɓuka a cikin Excel. Jerin da aka zazzage, wanda kuma aka sani da akwati zaɓi ko menu na zaɓuka, fasalin Excel ne wanda ke ba masu amfani damar zaɓar ƙima daga jerin da aka riga aka ƙayyade.
Wannan yana da amfani a yanayi da yawa. Misali, idan kuna shigar da bayanai da hannu kuma akwai wasu dabi'u waɗanda ke gama-gari kuma ana maimaita su akai-akai, zaku iya ƙirƙirar jerin zaɓuka don waɗannan ƙimar don hanzarta aiwatar da shigar da bayanai.
Ana shirya bayanai don jerin zaɓuka
Mataki na farko don ƙirƙirar jerin zaɓuka a cikin Excel shine shirya bayanan da kuke son bayyana a cikin jerin. Wannan jeri na iya haɗawa da komai daga jerin sunaye, birane, lambobi, ko wani abu da kuke buƙata.
Anan ga matakan shirya bayanai don jerin zaɓuka:
- Bude Excel kuma ƙirƙirar sabon maƙunsar rubutu ko amfani da wanda yake.
- A cikin fanko ko jere, rubuta bayanan da kuke son bayyana a cikin jerin abubuwan da aka saukar. Kowane shigarwa dole ne ya kasance a cikin tantanin halitta daban.
Bayan kun shigar da duk bayanan, zaku iya zaɓar su kuma ba su suna ta akwatin suna a kusurwar hagu na sama.
Ƙirƙirar jerin zaɓuka
Da zarar kun shirya naku bayanai kuma ka ba su a nombre, za mu iya fara aiwatar da ƙirƙirar jerin zaɓuka:
- Zaɓi tantanin halitta inda kake son samun jerin zaɓuka.
- Danna maballin 'Data' a cikin babban mashaya menu.
- A cikin rukuni na 'Data Tools', danna 'Data Validation'.
Yanzu za a gabatar muku da taga 'Data Validation' inda zaku iya daidaita ƙa'idodin tantanin halitta da aka zaɓa.
Yana daidaita ƙa'idodin tabbatar da bayanai
Mataki na ƙarshe na ƙirƙirar jerin zaɓuka a cikin Excel shine saita ƙa'idodin ingantattun bayanai:
- A cikin 'Data Validation' taga, danna kan 'Settings' tab.
- A ƙarƙashin taken 'Ba da izini', zaɓi 'List' daga jerin zaɓuka.
- A cikin filin 'Origin', rubuta sunan da kuka ba da bayanan ku kuma danna 'Ok'.
A wannan gaba, ya kamata ka sami wani saukar da jerin a cikin Excel wanda ke nuna bayanan da aka shigar. Kuna iya gwada ta ta zaɓar tantanin halitta wanda kuka saita jerin zaɓuka a cikinsa kuma danna kibiya.
Amfani da gyara lissafin zazzagewar ku
Tare da jerin zaɓuka da aka riga aka ƙirƙira, zaku iya amfani da shi ta zaɓin kowane tantanin halitta tare da jeri kuma zaɓi shigarwa. Don canza lissafin ko canza bayanan tabbatarwa, kawai maimaita matakan da suka gabata.
Ka tuna cewa jeri-jerin da aka saukar a cikin Excel kayan aiki ne na ceton lokaci wanda ke inganta inganci da daidaiton shigarwar bayanai. Yana da mahimmancin fasaha wanda duk masu amfani da Excel su sani.
