Tsarin Al'amarin Ƙari ko Takardun Lissafi a Excel

Ƙara abubuwa da sauri

Ƙara ginshiƙai ko layuka lambobi yana ɗaya daga cikin ayyukan da aka fi yawan aiki a cikin shirye-shiryen ɓangaren rubutu kamar Excel ko Googlereadsheets .

Ayyukan SUM na samar hanya mai sauri da sauƙi don aiwatar da wannan aiki a cikin takardar aikin Excel.

01 na 05

SUM aikin aiki da jayayya

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

Haɗin aikin SUM shine:

= SUM (Number1, Number2, ... Number255)

Number1 - (da ake buƙata) darajar farko don a taƙaita.
Wannan jayayya na iya ƙunsar ainihin bayanan da aka ƙayyade ko yana iya kasancewa tantancewar salula zuwa wuri na bayanan a cikin takardun aiki .

Number2, Number3, ... Number255 - (na zaɓi) ƙarin dabi'un da za'a ƙayyade har zuwa iyakar 255.

02 na 05

Shigar da SUM Function Amfani da Gajerun hanyoyi

Abin sha'awa shi ne SUM aiki cewa Microsoft ya ƙirƙiri hanyoyi biyu don yin shi ma sauƙi don amfani:

• Hanyar gajeren hanya.
• Siffar ta atomatik a kan shafin shafin shafin rubutun.

Wasu zaɓuɓɓukan don shiga aikin sun haɗa da:

• Yin amfani da akwatin maganganun aikin.
• Shigar da aikin da hannu.

03 na 05

Bayanan Sumad a Mahimman Ƙari na Hanyar Hanya

Maɓallin haɗin haɗi don shigar da SUM aiki shine:

Alt + = (daidai alamar)

Misali

Ana amfani da matakai na gaba don shigar da SUM aiki ta amfani da maɓallan gajeren hanyoyi

1. Danna kan tantanin halitta inda SUM aiki zai kasance.
2. Latsa ka riƙe ƙasa Alt maɓallin kewayawa.
3. Latsa kuma saki alamar daidai (=) a kan keyboard ba tare da bar maɓallin Alt ba.
4. Saki da maɓallin Alt .
5. Dole ne a shigar da SUM aiki a cikin tantanin halitta tare da Sanya shigarwa ko siginan kwamfuta wanda ke tsakanin maɓallin zane mai ban mamaki.
6. Abubuwan da aka riƙe suna riƙe da hujjoji na aikin - adadin labaran labaran ko lambobi don taƙaitawa.
7. Shigar da hujjar aikin:
   • ta yin amfani da ma'ana da danna tare da linzamin kwamfuta don shigar da labaran sassan mutum (duba Bayanan da ke ƙasa);
   • ta yin amfani da danna kuma ja tare da linzamin kwamfuta don nuna hasken mahaɗin sel;
   • rubutawa a cikin lambobi ko bayanan salula da hannu.
8. Da zarar an shigar da hujja, danna maɓallin shigarwa a kan keyboard don kammala aikin;
9. Amsar ya kamata ya bayyana a tantanin halitta dauke da aikin;
10. Lokacin da ka danna kan tantanin halitta dauke da amsar, aikin SUM ɗin da aka kammala ya bayyana a cikin maɓallin tsari a sama da takardun aiki;

Lura : Lokacin shigar da hujjar aikin, tuna:

• Bayanan salula na mutum da aka shigar ta hanyar bugawa ko nunawa dole ne a raba shi da kwamusa;
• don yawan kewayoyin tantancewar da aka shigar ta hanyar bugawa, za'a iya rabu da cikakkiyar sakonni na farko da ƙarshen sifa ( :)

04 na 05

Bayanin Sumad a cikin Excel Amfani da AutoSUM

Ga wadanda suka fi so su yi amfani da linzamin kwamfuta maimakon maɓallin kewayawa, hanya ta hanyar AutoSUM wanda ke kan shafin shafin Rubin, kamar yadda aka nuna a hoton da ke sama, za'a iya amfani dashi don shigar da aikin SUM.

Sashen na atomatik na AutoSUM yana nufin gaskiyar cewa lokacin da aka shiga ta amfani da wannan hanya, aikin yana zaɓi abin da ya gaskata shi ne kewayon kwayoyin da za a tara ta wurin aikin.

Kamar yadda aka nuna a cikin hoton da ke sama, zaɓin da aka zaɓa yana shaded kuma an kewaye shi da iyakokin da aka sani da tafiya da tururuwa.

Lura :

• An tsara aikin SUM don a shigar a kasan wani shafi na bayanai ko a gefen dama na jere na bayanan.
• Idan aikin SUM ya shiga cikin wani wuri banda waɗannan biyu, iyakar sel da aka zaɓa a matsayin ƙwaƙwalwar aiki na iya zama ba daidai ba.
• Don canja zaɓin da aka zaɓa, yi amfani da maɓallin linzamin kwamfuta don nuna hasken madaidaiciya kafin danna maɓallin Shigar don kammala aikin

Don amfani da AutoSUM:

1. Danna kan tantanin halitta inda za a saka aikin;
2. Danna gunkin AutoSUM a kan kintinkiri;
3. SUM aiki ya kamata a shiga cikin tantanin halitta tare da iyakar dabi'un don a taƙaita;
4. Bincika don ganin cewa layin kewaye - wanda zai haifar da hujjar aikin ta daidai;
5. Idan kewayon daidai ne, danna maɓallin shigarwa akan keyboard don kammala aikin;
6. Za a nuna amsar a cikin tantanin halitta inda aka shigar da aikin;
7. Lokacin da ka danna kan tantanin salula da ke dauke da amsar, aikin SUM ɗin da aka kammala ya bayyana a cikin maɓallin tsari a sama da aikin aiki.

05 na 05

Amfani da SUM Function Dialog Box

Yawancin ayyuka a cikin Excel za a iya shiga ta amfani da akwatin maganganu , wanda ke ba ka damar shigar da muhawara don aikin a kan layi. Har ila yau akwatin zance yana kula da haɗin aikin - irin su budewa da rufewa tare da kalmomin da aka yi amfani da su don rarrabe jayayya.

Kodayake ana iya shigar da lambobin mutum kai tsaye a cikin akwatin maganganu kamar yadda muhawarar suke, yawanci mafi kyau shine shigar da bayanai zuwa cikin ɗakunan Kayan aiki kuma shigar da tantancewar sel kamar yadda zance akan aikin.

Don shigar da SUM aiki ta amfani da akwatin maganganu:

1. Danna kan tantanin halitta inda za a nuna sakamakon.
2. Danna maɓallin Formulas na shafin rubutun .
3. Zabi Math & Trig daga ribbon don buɗe jerin aikin da aka sauke.
4. Danna SUM a cikin jerin don kawo akwatin maganganu na aikin;
5. A cikin akwatin maganganu, danna kan lambar Number1 .
6. Fahimta akalla tantanin halitta ko tsinkayen nassoshi.
7. Danna Ya yi don kammala aikin kuma rufe akwatin maganganu.
8. Amsar ya kamata ya bayyana a cikin cell da aka zaba.