Matsalar ba ta da wuya a yayin da kake amfani da Excel
Kamar yadda yake tare da dukkan matakan aikin lissafi a cikin Excel don ƙara lambobi biyu ko fiye a Excel kana buƙatar ƙirƙirar takarda .
Lura: Don ƙara yawan lambobin da suke a cikin wani shafi guda ɗaya ko jere a cikin takardun aiki, yi amfani da SUM Function , wanda yana bayar da gajeren hanya don ƙirƙirar daɗaɗɗen tsari.
Mahimman mahimmanci suyi tunani game da siffofin Excel:
- Formulas a cikin Excel sukan fara da daidai alamar ( = );
- Alamar daidai ita ce ta taɓa shiga cikin tantanin halitta inda kake son amsawa ta bayyana;
- Ƙarin buƙata a Excel shine alamar da aka fi sani (+);
- An kammala tsari ta latsa maɓallin Shigar da ke keyboard.
Yi amfani da Siffar salula a Ƙarin Formulas
A cikin hoton da ke sama, saitin farko na misalai (layuka 1 zuwa 3) yi amfani da tsari mai sauƙi - wanda yake a cikin shafi na C - don ƙara tare da bayanai a ginshiƙai A da B.
Kodayake yana yiwuwa a shigar da lambobi kai tsaye a cikin wani ƙari - kamar yadda aka nuna ta hanyar:
= 5 + 5
a cikin jere na 2 na hoton - yana da kyau a shigar da bayanai cikin fayilolin aikin aiki sannan a yi amfani da adiresoshin ko alamomin waɗannan sel a cikin tsari - kamar yadda aka nuna ta
= A3 + B3
a jere 3 a sama.
Ɗaya daga cikin amfani da yin amfani da bayanan salula fiye da ainihin bayanan a cikin wata hanya shine, idan a kwanan wata, ya zama dole don canza bayanai yana da sauƙi na maye gurbin bayanai a cikin tantanin halitta maimakon sake rubutawa da wannan tsari.
Yawanci, sakamakon wannan tsari zai sabunta ta atomatik sau ɗaya bayanan canje-canjen.
Shigar da Siffofin Siffar Tare da Matsa da Latsa
Ko da yake yana yiwuwa a rubuta irin wannan tsari a cikin C3 kuma ana samun amsar daidai, yawanci ya fi dacewa don amfani da ma'ana kuma danna , ko nunawa , don ƙara sassan tantanin halitta don ƙididdiga don rage girman yiwuwar kurakurai da bugawa a cikin maƙasudin salon salula.
Matsa da danna sun shafi kawai danna tantanin halitta dauke da bayanai tare da maɓallin linzamin kwamfuta don ƙara mahimmancin tantancewar kwayar halitta zuwa wannan tsari.
Samar da Formula Ƙara
Matakai da aka yi amfani da su don ƙirƙirar ƙari a cikin ƙwayoyin C3 sune:
- Rubuta alamar daidai a cikin cell C3 don fara tsari;
- Danna kan A3 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan daidai alamar;
- Rubuta alamar (+) a cikin tsari bayan A3;
- Danna kan B3 tareda maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan bugu da kari;
- Latsa maɓallin shigarwa a kan keyboard don kammala tsari;
- Amsar 20 ya kasance a cell C3;
- Ko da yake kakan sami amsar a cikin C3 cell, danna kan tantanin halitta zai nuna nau'in = A3 + B3 a cikin maɓallin tsari a sama da takardun aiki.
Canza Formula
Idan ya zama wajibi don gyara ko canza wani tsari, biyu daga cikin mafi kyau mafi kyau shine:
- Danna sau biyu a kan tsari a cikin takardun aiki don sanya Excel a Yanayin Shirya sa'annan kuyi canje-canje a cikin tsari - aiki mafi kyau don canje-canje kaɗan.
- Danna sau ɗaya a kan tantanin halitta dauke da tsari kuma sake shigar da dukkan matakan - mafi kyau ga manyan canje-canje.
Ƙirƙirar ƙirar ƙwararrun ƙira
Don rubuta tsarin da ya fi rikitarwa wanda ya haɗa da ayyuka masu yawa - irin su rabuwa ko raguwa ko kari - kamar yadda aka nuna a layuka biyar zuwa bakwai a cikin misalin, amfani da matakan da aka jera a sama don farawa sannan kuma kawai ci gaba da ƙara ƙaddancin lissafin ilmin lissafi ya biyo baya bayanan salula sun ƙunshi sababbin 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 .
Samar da jerin Fibonacci
Wani samfurin Fibonacci, wanda aka kirkiri shi daga karni na sha biyu na lissafin Italiyanci Leonardo Pisano, ya samar da jerin lambobi masu yawa.
Ana yin amfani da waɗannan sassan don bayyana, a cikin ilmin lissafi, a tsakanin sauran abubuwa, alamu daban-daban da aka samo a cikin yanayin kamar:
- Girman siffar daban-daban na bahar ruwan;
- Tsarin ganye a kan reshe na itace;
- Tsarin haifar ƙudan zuma.
Bayan lambobi biyu na farawa, kowane ƙarin lambar a cikin jerin shine jimla na lambobin da suka gabata.
Mafi sauki Fibonacci jerin, wanda aka nuna a cikin hoto a sama, ya fara da lambobin zero kuma daya:
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, 1597, 2584 ...
Fibonacci da Excel
Tun da jerin fibonacci sun hada da ƙarin, za'a iya yin sauƙin halitta tare da ƙarin ƙari a Excel kamar yadda aka nuna a cikin hoto a sama.
Matakan da ke ƙasa dalla-dalla yadda za a ƙirƙiri mafi sauki fibonacci jerin ta amfani da tsari. Matakan sun haɗa da ƙirƙirar daftarin farko a cikin salula A3 sannan sannan ka kwafi irin wannan tsari zuwa sauran sauran kwayoyin ta amfani da rikewar cika .
Kowace korafin, ko kwafi, na dabarar, ya haɗa tare da lambobi biyu da suka gabata a jerin.
Matakan da ke ƙasa suna ƙirƙira jerin a cikin wani shafi, maimakon a cikin ginshiƙai uku da aka nuna a cikin misalin hoto don yin sauƙi tsarin.
Don ƙirƙirar jerin fibonacci da aka nuna a cikin misalin ta yin amfani da mabuɗin ƙari:
- A cikin cell A1 type zero (0) kuma danna maɓallin Shigar da ke keyboard;
- A cikin cell A2 type a 1 kuma latsa Shigar maballin;
- A cikin salula A3 irin wannan = A1 + A2 kuma danna maballin Shigarwa ;
- Danna kan salula A3 don sanya shi tantanin halitta ;
- Sanya maƙalin linzamin kan ginin cika - dotin baki a kasan dama kusurwa na cell A3 - Mainter ya canza zuwa alamar bidiyon ( + ) lokacin da ya cika makamin cikawa;
- Riƙe maɓallin linzamin maɓallin linzamin kwamfuta a kan mai cikawa kuma ja da maɓallin linzamin kwamfuta zuwa ga cell A31;
- A31 ya ƙunshi lamba 514229 .