Yadda ake amfani da Wizard Aiki a cikin Excel. Kira, zabar ayyuka, cika gardama, aiwatar da aiki

Manajan Ayyuka na Microsoft Excel yana sauƙaƙa yin aiki tare da lissafi. Yana kawar da buƙatar shigar da dabarar harafi ɗaya a lokaci ɗaya, sannan a nemi kurakurai a cikin lissafin da ya taso saboda buga rubutu. Babban ɗakin karatu na Manajan Ayyuka na Excel yana ƙunshe da samfura don amfani iri-iri, sai dai lokacin da kuke buƙatar ƙirƙirar ƙirar gida. Don yin aiki tare da tebur ƙasa da lokaci, za mu bincika amfani da wannan kayan aiki mataki-mataki.

Mataki #1: Buɗe Wizard Aiki

Kafin samun dama ga kayan aiki, zaɓi tantanin halitta don rubuta dabara - danna tare da linzamin kwamfuta don kauri firam ya bayyana a kusa da tantanin halitta. Akwai hanyoyi da yawa don ƙaddamar da Wizard Aiki:

1. Danna maɓallin "Fx", wanda ke gefen hagu na layin don aiki tare da tsarin aiki. Wannan hanyar ita ce mafi sauri, don haka ta shahara tsakanin masu Microsoft Excel.
2. Je zuwa shafin "Formulas" kuma danna babban maɓallin tare da wannan suna "Fx" a gefen hagu na panel.
3. Zaɓi nau'in da ake so a cikin "Library of ayyuka" kuma danna kan rubutun "Saka aikin" a ƙarshen layin.
4. Yi amfani da haɗin maɓallin Shift + F Wannan kuma hanya ce mai dacewa, amma akwai haɗarin manta haɗin da ake so.

Mataki #2: Zaɓi Feature

Manajan Ayyuka ya ƙunshi ƙididdiga masu yawa zuwa kashi 15. Kayan aikin bincike suna ba ku damar gano shigarwar da ake so cikin sauri tsakanin mutane da yawa. Ana yin binciken ta hanyar kirtani ko ta nau'ikan ɗaiɗaikun mutane. Kowane ɗayan waɗannan hanyoyin yana buƙatar bincika. A saman taga Manajan akwai layin "Neman aiki". Idan kun san sunan tsarin da ake so, shigar da shi kuma danna "Nemo". Duk ayyuka tare da suna kama da kalmar da aka shigar zasu bayyana a ƙasa.

Binciken rukuni yana taimakawa lokacin da sunan dabara a cikin ɗakin karatu na Excel ba a san shi ba. Danna kibiya a gefen dama na layin "Kategori" kuma zaɓi ƙungiyar ayyuka da ake so ta jigo.

Akwai wasu igiyoyi a cikin sunayen rukuni. Zaɓin "Cikakken lissafin haruffa" sakamakon a cikin jerin duk ayyukan laburare. Zaɓin "10 Kwanan nan An Yi Amfani da shi" yana taimaka wa waɗanda ke zabar ƙira iri ɗaya don yin aiki da su. Ƙungiya ta “Compatibility” jerin dabaru ne daga tsoffin juzu'in shirin.

Idan aikin da ake so yana cikin rukunin, danna shi tare da maɓallin linzamin kwamfuta na hagu, layin zai zama shuɗi. Duba idan zaɓin daidai ne kuma danna "Ok" a cikin taga ko "Shigar" akan maballin.

Mataki #3: cika muhawarar

Taga don rubuta gardamar ayyuka zai bayyana akan allon. Adadin layukan fanko da nau'in kowane gardama ya dogara da sarkar dabarar da aka zaɓa. Bari mu bincika matakin ta amfani da aikin ma'ana "IF" a matsayin misali. Kuna iya ƙara ƙimar hujja a rubuce ta amfani da madannai. Buga lambar da ake so ko wani nau'in bayanin cikin layi. Shirin kuma yana ba ku damar zaɓar sel waɗanda abun ciki zai zama hujja. Anan akwai hanyoyi guda biyu don yin shi:

1. Shigar da sunan tantanin halitta a cikin kirtani. Zaɓin ba shi da daɗi idan aka kwatanta da na biyu.
2. Danna kan tantanin halitta da ake so tare da maɓallin linzamin kwamfuta na hagu, zane mai digo zai bayyana tare da gefen. Tsakanin sunayen sel, zaku iya shigar da alamun lissafi, ana yin wannan da hannu.

Don tantance kewayon sel, riƙe na ƙarshe kuma ja shi zuwa gefe. Matsakaicin dige-dige mai motsi ya kamata ya ɗauki duk sel ɗin da ake so. Kuna iya saurin canzawa tsakanin layin gardama ta amfani da maɓallin Tab.

Wani lokaci adadin muhawara yana ƙaruwa da kansa. Babu buƙatar jin tsoron wannan, tun da yake yana faruwa ne saboda ma'anar wani aiki na musamman. Wannan yakan faru lokacin amfani da dabarar lissafin Manajan. Ba lallai ba ne hujjar ta ƙunshi lambobi – akwai ayyukan rubutu inda aka bayyana sassan magana cikin kalmomi ko jimloli.

Mataki #4: Ci gaba da Aiki

Lokacin da aka saita duk ƙimar kuma an tabbatar da su daidai, danna Ok ko Shigar. Lambar da ake so ko kalmar da ake so zata bayyana a cikin tantanin halitta inda aka ƙara dabara, idan kun yi komai daidai.

Idan akwai kuskure, koyaushe zaka iya gyara kuskuren. Zaɓi cell mai aiki kuma shiga cikin Manajan, kamar yadda aka nuna a mataki #1. Wani taga zai sake bayyana akan allon inda kake buƙatar canza ƙimar jayayya a cikin layi.

Idan an zaɓi tsarin da ba daidai ba, share abubuwan da ke cikin tantanin halitta kuma maimaita matakan da suka gabata. Bari mu gano yadda ake cire aiki daga tebur:

• zaɓi cell ɗin da ake so kuma danna Share akan maballin;
• danna sau biyu akan tantanin halitta tare da dabara - lokacin da magana ta bayyana a ciki maimakon ƙimar ƙarshe, zaɓi shi kuma danna maɓallin Backspace;
• danna sau ɗaya akan tantanin halitta da kake aiki a cikin Mai sarrafa Aiki kuma share bayanin daga ma'aunin dabara - yana saman tebur.

Yanzu aikin ya cika manufarsa - yana yin lissafi ta atomatik kuma yana 'yantar da ku kaɗan daga aiki mai sauƙi.