Yi amfani da bayanan salula kuma yana nuna ninka cikin Excel
Kamar yadda yake da dukkan ayyukan aiki na lissafi a Excel, ninka lambobi biyu ko fiye ya haɗa da ƙirƙirar takarda.
Mahimman mahimmanci suyi tunani game da siffofin Excel:
- Formulas a cikin Excel sukan fara da daidai alamar ( = ).
- Alamar daidai tana shiga cikin tantanin halitta inda kake son amsawa.
- Alamar ƙaddamarwa ko mai amfani da aka yi amfani da shi a cikin takaddun Excel shine alamar alama ( * ).
Amfani da Siffofin Siffar a cikin Formulas
Ko da yake yana yiwuwa a shigar da lambobi kai tsaye a cikin wani tsari, yana da kyau a shigar da bayanai a cikin fayilolin aikin aiki sannan a yi amfani da adiresoshin ko kuma nassoshi na waɗannan sel a cikin tsari.
Babban amfani da amfani da tantanin halitta a cikin wata hanya, maimakon ainihin bayanan, ita ce, idan a kwanan wata, ya zama dole don canza bayanai, yana da sauƙi na maye gurbin bayanai a cikin kwayoyin kamalai maimakon sake rubutawa dabara.
Sakamakon dabarar za ta sabunta ta atomatik sau ɗaya bayanan bayanan da ke tattare da kwayoyin kamala.
Shigar da Siffofin Siffar ta Amfani da Gyara
Har ila yau, kodayake yana yiwuwa a rubuta irin labaran da ake amfani dashi a cikin wannan tsari, mafi dacewa shi ne amfani da nunawa don ƙara maƙalarin salula.
Bayyanawa ya haɗa da danna kan kwayoyin da ke dauke da bayanai tare da maɓallin linzamin kwamfuta don ƙara ƙirar salula zuwa wannan tsari. Amfanin amfani da wannan tsarin ita ce ta rage yiwuwar kurakurai da aka kirkira ta hanyar rubutawa a cikin maƙasudin salon salula.
Alamar ƙirar yawanci
Kamar yadda aka nuna a hoton da ke sama, wannan misali ya haifar da wata ƙira a cikin cell C1 wanda zai ninka bayanai a cikin cell A1 ta bayanan data A2.
Ƙarshen dabarar a cikin cell E1 zai kasance:
= A1 * A2
Shigar da Bayanan
- Rubuta lamba 10 a cikin salula A1 kuma latsa maɓallin Shigar da ke kan keyboard,
- Rubuta lambar 20 a cikin salula A2 kuma latsa maɓallin Shigar ,
Shigar da Formula
- Danna kan tantanin halitta C1 don sa shi tantanin halitta mai aiki - wannan shine inda za'a nuna sakamakon wannan tsari.
- Rubuta = (alamar daidai ) cikin cell C1.
- Danna kan salula A1 tare da maɓallin linzamin kwamfuta don shigar da wannan tantanin halitta a cikin tsari.
- Rubuta * ( alama ta alama ) bayan A1.
- Danna maɓallin A2 tare da maɓallin linzamin kwamfuta don shigar da wannan tantanin salula.
- Latsa maɓallin shigarwa a kan keyboard don kammala tsari.
- Amsar 200 ya kasance a cell C1.
- Ko da yake an nuna amsar a cikin ƙwayoyin C1, danna kan tantanin halitta zai nuna ainihin matsala = A1 * A2 a cikin maɓallin tsari a sama da takardun aiki.
Canza Bayanan Bayanin Samun
Don gwada darajar amfani da bayanan salula a cikin wani tsari:
- Canja lambar a cikin salula A2 daga 20 zuwa 5 kuma danna maballin shigarwa a kan keyboard.
Amsar a cikin ƙwayoyin C1 ya kamata a sabunta ta atomatik zuwa 50 don yin la'akari da sauyawar bayanai a cikin cell A2.
Canza Formula
Idan ya zama wajibi don gyara ko canza wani tsari, biyu daga cikin mafi kyau mafi kyau shine:
- Danna sau biyu a cikin takaddun aiki don sanya Excel a Yanayin daidaitawa sa'annan kuyi canje-canje a cikin tsari. Wannan yana aiki mafi kyau ga ƙananan canje-canje.
- Danna sau ɗaya a kan tantanin halitta dauke da ma'anar da sake rubutawa da dukan tsari. Wannan hanya mafi kyau ga manyan canje-canje.
Ƙirƙirar ƙirar ƙwararrun ƙira
Don rubuta tsarin da yafi rikitarwa wanda ya haɗa da ayyuka masu yawa - irin su ragu, ƙari, da rarraba, kazalika da ƙaddamarwa - kawai ƙara masu amfani da lissafin ilmin lissafi a cikin tsari madaidaiciya da kuma bayanan salula wanda ke dauke da bayanai.
Kafin ka haɗu da aiki daban-daban na ilmin lissafi a cikin wani tsari, duk da haka, yana da muhimmanci a fahimci tsari na ayyukan da Excel ke biyo bayan yin la'akari da tsari.
Don yin aiki, gwada wannan matakan mataki zuwa mataki na tsari mai mahimmanci .