Jagoran Mataki na Mataki na Yin Amfani da Ayyukan Hoto na Excel

01 na 02

Zaɓi Bayanai tare da Sakamakon Sakamakon

Nemo Ayyukan Hanya

Aikace- aikacen Duba Excel, wanda ya haɗa da aikin KASHI, ana amfani da su don ganowa da kuma dawo da bayanai daga jerin ko tebur bisa la'akari da ƙimar ko lambar index.

A cikin yanayin da aka zaba, yana amfani da lambar ƙididdiga don nemowa da sake dawo da wani darajar ta musamman daga jerin jerin bayanai.

Lambar index yana nuna matsayi na darajar a jerin.

Alal misali, ana iya amfani da aikin don dawo da sunan wata takamaiman shekara ta shekara bisa ga lambar index daga 1 zuwa 12 ya shiga cikin tsari.

Kamar yawancin ayyukan Excel, CHOOSE yana da mafi tasiri idan an haɗa shi da wasu maƙalai ko ayyuka don dawo da sakamakon daban-daban.

Alal misali zai zama aikin da zaɓa don aiwatar da ƙididdiga ta yin amfani da ayyukan SUM , AVERAGE , ko MAX na Excel a kan wannan bayanan dangane da lambar da aka zaba.

Sakamakon Sakamakon Ayyuka da Magana

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Hadawa don aikin da aka zaɓa shine:

= CHOOSE (Index_num, Value1, Value2, ... Value254)

Index_num - (da ake bukata) Ya ƙayyade wane darajar za a dawo ta wurin aikin. Index_num zai iya zama lambar tsakanin 1 da 254, wata maƙirai, ko kuma tunani akan cell dake dauke da lambar tsakanin 1 da 254.

Darajar - (Value1 ana buƙatar, ƙarin halayen zuwa iyakar 254 suna zaɓi) Jerin dabi'u waɗanda za'a mayar da su ta wurin aikin dangane da ƙaddamarwar Index_num. Ƙididdiga na iya zama lambobi, bayanan salula , jeri na jeri , dabara, ayyuka, ko rubutu.

Misali Yin amfani da Ƙa'idar Excel ta Sakamakon Ayyuka don Nemi Bayanai

Kamar yadda za a iya gani a cikin hoton da ke sama, wannan misali zai yi amfani da aikin da aka zaɓa don taimakawa wajen ƙididdige yawan bashin shekara ga ma'aikata.

Darajar ita ce yawan nauyin albashi na shekara daya kuma kashi yana dogara ne akan cikawa tsakanin 1 zuwa 4.

Ayyukan KASHI ya canza dabi'un wasan kwaikwayon cikin kashi daidai:

rating - kashi 1 3% 2 5% 3 7% 4 10%

Wannan darajar darajar wannan ne sannan aka haɓaka ta albashi na shekara don samun karin bashin shekara ta ma'aikaci.

Misalin ya kunshi shigar da aikin KASHI a cikin cell G2 sannan kuma ya yi amfani da cikakken cikawa don kwafin aikin zuwa kwayoyin G2 zuwa G5.

Shigar da Bayanan Tutorial

1. Shigar da wadannan bayanan cikin sel D1 zuwa G1
2. 
   Bonus J. Smith Salaye mai aiki na ma'aikata 3 $ 50,000 K. Jones 4 $ 65,000 R. Johnston 3 $ 70,000 L. Rogers 2 $ 45,000

Shigar da Sakamakon Sakamakon

Wannan sashe na koyawa ya shiga aikin da aka zaɓa a cikin sel G2 kuma yana ƙididdiga kashi bisa dari bisa ga yadda aka yi daidai ga ma'aikaci na farko.

1. Danna kan salula G2 - wannan shine inda za a nuna sakamakon aikin
2. Danna maɓallin Formulas na shafin rubutun
3. Zabi Binciken da Magana daga ribbon don bude jerin jerin ayyuka
4. Danna kan Zaɓi a cikin jerin don ɗaukar maganganun aikin.
5. A cikin akwatin maganganu, danna kan jerin Index_num
6. Danna kanfikan E2 a cikin takardun aiki don shigar da tantanin halitta a cikin akwatin maganganu
7. Danna maɓallin Value1 a cikin akwatin maganganu
8. Shigar da kashi 3 cikin wannan layi
9. Danna maɓallin Value2 a cikin akwatin maganganu
10. Shigar da kashi 5 cikin wannan layi
11. Danna maɓallin Value3 a cikin akwatin maganganu
12. Shigar da 7% akan wannan layi
13. Danna maɓallin Value4 a cikin akwatin maganganu
14. Shigar da 10% akan wannan layi
15. Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
16. Darajar "0.07" ya kamata ya bayyana a cell G2 wanda shine nau'i na decimal don 7%

02 na 02

Sakamakon Sakamakon misali (ci gaba)

Ana ƙayyade Bonus ma'aikacin

Wannan ɓangare na koyawa na gyaggyara aikin da aka yi a cikin cell G2 ta hanyar ninka sakamakon aikin lokacin aikin albashi na ma'aikaci don lissafin kyautar shekara.

An gyara wannan gyare-gyaren ta amfani da maballin F2 don shirya tsarin.

1. Danna kan cell G2, idan ya cancanta, don sanya shi tantanin halitta
2. Latsa maɓallin F2 a kan keyboard don sanya Excel a yanayin gyare - aikin cikakken
   = CHOOSE (E2, 3%, 5%, 7%, 10%) ya kamata ya bayyana a cikin tantanin halitta tare da wurin sakawa bayan bayanan aikin rufewa
3. Rubuta alama ( * ), wanda shine alamomin ƙaddamarwa a Excel, bayan bayanan rufewa
4. Danna kan tantanin halitta F2 a cikin takardun aiki don shigar da tantanin salula zuwa aikin albashin ma'aikaci a cikin tsari
5. Latsa maɓallin shigarwa a kan keyboard don kammala tsarin da kuma barin yanayin gyare-gyare
6. Darajar "$ 3,500.00" ya kamata ya bayyana a cell G2, wanda shine 7% na albashi na shekara-shekara na $ 50,000.00
7. Danna kan salula G2, cikakkiyar tsari = CHOOSE (E2, 3%, 5%, 7%, 10%) * F2 yana bayyana a cikin tsari da aka kafa a sama da takardun aiki

Kusar da Formus Bonus Formula tare da Cika Cike

Wannan sashe na koyaswar koyon kofin ta cikin sel G2 zuwa kwayoyin G3 zuwa G5 ta yin amfani da rikewar cika .

1. Danna kan salula G2 don sa shi tantanin halitta mai aiki
2. Sanya ma'anar linzamin kwamfuta a kan kusurwar baki a cikin kusurwar dama na kusurwa na G2. Maɓin zai canza zuwa alamar da aka sanya "+"
3. Danna maɓallin linzamin hagu kuma jawo ƙoshin da aka cika zuwa cell G5
4. Saki da maɓallin linzamin kwamfuta. Sel na G3 zuwa G5 ya kamata ya ƙunshi yawan kuɗi na sauran ma'aikatan da suka rage kamar yadda aka gani a hoton a shafi na 1 na wannan koyawa