Yadda za a ƙara a cikin Excel? Duk cikakkun bayanai!

Microsoft Excel shiri ne na falle wanda za a iya amfani da shi a cikin tsarin aiki daban -daban kamar Windows, macOS, Android, iOS, da sauransu. Yana da aikace -aikacen lissafi da yawa, wannan shine dalilin da yasa wannan labarin yayi bayani yadda za a kara a cikin fice

Yadda ake ƙarawa a cikin Excel

Shirye -shiryen da ke gudana suna zuwa wannan rumbun bayanai na ɗan lokaci, ana ɓacewa lokacin da aka kashe kwamfutar ko aka sake kunna tsarin. Ƙwaƙwalwar RAM ɗin gaba ɗaya tana da tsabta kuma tana shirye don sake amfani da ita. Duk da yake RAM yana riƙe da abun cikin sa. Ingancin ƙwaƙwalwar RAM ya fi ROM girma

Ta wannan hanyar, ya zama kayan aiki na asali ga duk masu amfani waɗanda ke buƙatar babban lissafin kuɗi da lissafin ofis. An nuna shi ta hanyar ba da halaye daban -daban waɗanda ke sauƙaƙe waɗannan matakan lissafi kuma rage rikitarwarsa.

Don sanin yadda ake ƙarawa a cikin Excel, kawai kuna buƙatar amfani da mahimman dabaru don shirin yana kula da aiwatar da kowane lissafin sau da yawa kamar yadda ya cancanta. Dalili ke nan da ɗalibai, ɗaliban jami'a, ma'aikata da akawu suke amfani da su, saboda ɗimbin ayyukansu da saukin samun manyan lissafi.

Yadda ake ƙarawa a cikin Excel tambayoyi ne masu yawan gaske waɗanda za a iya amsa su ta hanya mai sauƙi kuma shine aiwatar da madaidaitan dabaru, tare da wannan kaɗai yana yiwuwa a yi adadi mai yawa a cikin ɗan gajeren lokaci kuma ba tare da kurakurai da za a iya yi idan an yi su da hannu, don haka ingancinsa ya yi yawa sosai.

Wannan shine dalilin da ya sa yana da mahimmanci a san matakan da dole ne a aiwatar da su da kuma dabaru waɗanda dole ne a aiwatar da su don samun sakamako da ake so da inganci, cikin sauri kuma ba tare da matsaloli da yawa ba yayin aiwatar da lissafin, a wannan yanayin taƙaitawa, amma kuma ana iya amfani da wasu ayyukan ilmin lissafi kamar ragi, ninkawa da rarrabuwa.

Idan kuna son sanin abin da cibiyar sadarwar yankin ta ƙunsa, to ana gayyatar ku don karanta labarin Menene LAN, inda aka bayyana aikinsa, tarihinsa, nau'ikan da ke akwai da abubuwan da aka haɗa

Matakai 

Shirin Excel yana da maƙunsar bayanai waɗanda aka ƙirƙiro su don adanawa da adana bayanan bayanan da aka samo a cikin sel na takardar, don ya iya haɓaka ayyukan lissafi wanda sunan Mai amfani ya kafa.

Idan kuna son sani game da mai duba ƙungiya, to ana gayyatar ku don karanta labarin ta Yadda ake amfani da Teamviewer inda aka bayyana manyan halayensa, fa'idodin da yake bayarwa da kuma ayyukan da yake bayarwa

Ana amfani da ayyukan lissafi ta hanyar wasu umarni ko dabaru waɗanda shirin ke da su ta wannan hanyar, yana yiwuwa a aiwatar da lissafi ba tare da matsala ba. Akwai hanyoyi don fahimta ko cimma yadda ake ƙarawa a cikin Excel, wannan shine dalilin da ya sa aka gabatar a ƙasa yadda ake samun wannan aikin ta bin wasu jagororin jagora:

Ƙara a cikin Excel ba tare da dabara ba

• A wannan yanayin, ba a buƙatar aikace -aikacen dabaru don cimma wannan aikin lissafi, wanda shine jimla
• Kuna da yuwuwar sanya alamar kawai "+"
• A matsayin mataki na farko, dole ne a buɗe sabon falle, wanda shine inda za a yi aikin.
• Sannan dole ne ku shigar da jerin bayanan da za a yi amfani da su a cikin aikin kari
• Dole ne a sanya shi cikin shafi a jere, wato, idan yana cikin shafi na A, ana shigar da shi daga tantanin halitta A1, sannan a cikin sel A2, don haka har sai an shigar da duk bayanan da aka tsara.
• Sannan dole ne a sanya shi a cikin sel na gaba na celtic tare da ƙimar ƙarshe da aka shigar
• A cikin sel ɗin dole ne ku shigar da alamar "="
• Ta wannan hanyar ana nuna alamar za a fara aikin
• Na gaba, dole ne ku zaɓi sel waɗanda ke da ƙima don yin jimlar
• Yakamata a nuna shi bayan alamar: = A1 + A2 + A3… .A har zuwa ƙimar ƙarshe da kuke son sanyawa cikin aikin
• Bayan haka, don kammala wannan aikin, dole ne ku zaɓi fayil ɗin "SHIGA"
• Ta wannan hanyar, ana kashe adadin daidai, yana ba da ƙima a cikin sel inda aka gudanar da aikin.

Ƙara a cikin Excel tare da dabara

• A wannan yanayin, dole ne a yi amfani da takamaiman dabara don cimma ƙari a cikin Excel
• Ta wannan hanyar kuna da sassauci mafi girma tare da bayanan
• Ana ba da shawarar wannan zaɓin lokacin da adadin bayanan da kuke da su ya yi yawa
• Tsarin da za a dasa shi ake kira "SUM" wanda aka sani da ɗayan manyan kayan aikin lissafi a cikin Excel
• A matsayin mataki na farko, dole ne ku sanya shi a cikin sel inda kuke son samun sakamakon aikin ƙarin
• Sannan dole ne ku shiga menu na zaɓuɓɓuka
• Nemi zaɓin mai suna "Formulas"
• Na gaba dole ne ku zaɓi zaɓi wanda ya ce "Saka aiki".
• Sannan dole ne ku zaɓi zaɓin da ya ce "SUM"
• Don gamawa dole ne ku zaɓi zaɓin da ya ce "Karba"
• Da wannan fom ana samun sakamakon jimlar da ake so tare da ƙimomin da aka shigar

Yadda za a ƙara a cikin Excel tare da AutoSum?

Wata hanyar da za a aiwatar da ƙarin aiki a cikin shirin Excel shine ta amfani da aikin AutoSum, don shirin Excel na iya yin jimlar daidai gwargwado, don haka ya zama kayan aiki mai amfani yayin da akwai bayanai da ƙima da yawa a cikin. aiki.

Wannan kayan aikin yana wakiltar alamar Ʃ, wanda ke da ƙidayar Takaitawa, yana ba da damar cimma daidaitattun adadin lambobi iri ɗaya, don haka yana adana lokaci da ƙoƙari mai yawa yayin yin wannan aikin.

Ana samun wannan aikin a cikin Excel ta hanyar alama don shigar da zaɓin da ake kira AutoSum wanda shirin ya gabatar, wanda ke cikin sandar menu na maƙunsar a cikin shafin da ake kira Home inda yake da kayan aiki da yawa don ayyukan da za a iya amfani da su.

Wasu daga cikin waɗannan kayan aikin da za a iya amfani da su a cikin waɗannan ayyukan shine matsakaicin ƙimar da ta dace, haka kuma matsakaicin ƙimar da kuka shigar kuma bi da bi mafi ƙarancin bayanan da aka zaɓa, yana kuma ba da zaɓi na ƙunshe ƙididdigar lambobi, da sauran ayyuka da yawa waɗanda za a iya amfani da su.

Ana iya amfani da wannan kayan aikin AutoSum a cikin yanayin cewa mai amfani yana da bayanai da yawa a cikin aikin, wannan shine dalilin da ya sa waɗannan ke nuna matakan da dole ne a bi ta hanyar maki don amfani da wannan zaɓi na AutoSum da fahimtar yadda ake ƙarawa a cikin Excel:

• Mataki na farko da za a ɗauka shine buɗe sabon maƙunsar bayanai
• Sannan dole ne ku shigar da bayanan da suka dace, kowanne a cikin ginshiƙan sa
• A cikin waɗannan lokuta, kamar yadda suke yawan adadin bayanai da aka haɗa a sassa daban -daban, an saita ƙaddarar bayanan da aka ƙaddara a cikin ginshiƙi
• Misali shine shigar da ƙimar bayanan da aka saita a shafi na A, na bayanan data 2 a shafi na B, don haka har sai an shigar da dukkan ƙimar daidai.
• Sannan dole ne ku gano a cikin akwati na ƙarshe inda aka shigar da ƙimar ƙarshe na shafi na farko A
• A cikin sel na gaba dole ne ku zaɓi sau biyu a cikin zaɓin "Autosum"
• Ta wannan hanyar zai yuwu a cimma sakamakon da ake so na jimlar shafi tare da ƙimomin ƙaddara
• Sel ɗin da aka zaɓa yana nuna jimlar ƙimomi a cikin wannan shafi
• Idan kuna buƙatar neman kowane shafi, kawai dole ku maimaita matakan da aka bayyana a baya
• Ana iya ganin wannan aikin a cikin mashaya dabara ta Excel yana nuna aikin da ake yi wanda zai kasance "SUM (A1: An)" inda aka nuna daga wace tantanin halitta zuwa wacce tantanin halitta za a yi jimlar
• Hakanan kuna da yuwuwar yin AutoSum a cikin shirin Excel tsakanin layuka
• Don wannan fom ɗin dole ne a sanya shi a cikin sel na ƙarshe wanda yake kusa da ƙimar shigarwa ta ƙarshe
• Muna ci gaba don zaɓar zaɓi na AutoSum sau biyu
• Sannan a cikin tantanin halitta za a sami sakamakon jimlar kowane sel da ke cikin jere

Dabara na asali don gudanar da zaɓin AutoSum a cikin Excel

Lokacin da kuke shakku game da yadda ake ƙarawa a cikin Excel, akwai hanyoyi daban -daban don amsawa saboda akwai kayan aikin da yawa waɗanda ke ba da izinin irin wannan aikin, daga cikinsu akwai zaɓi na AutoSum, wanda ake amfani da shi don yawan bayanai da ƙima a cikin sel a cikin daftarin aiki.

A cikin waɗannan lamuran, ya isa kawai zuwa akwatin tare da bayanan farko da aka shigar kuma ci gaba da ja tare da dannawa zuwa dama idan kuna son ƙara kowane shafi a cikin ƙimar, inda zaku iya ganin zaɓin tantanin halitta ya bayyana zaɓi tare da akwatin duhu inda akwai zaɓi na AutoSum.

Ana gudanar da jimlar aikin ta atomatik a cikin kowane ginshiƙi cikin inganci kuma ba tare da ƙoƙari mai yawa ba, yana yin aikin a jere. D wannan hanyar tana faruwa idan an sanya shi a cikin sel na autosum kuma an zaɓi akwatunan ƙasa don yin jimlar kowane jere daidai.

Wata hanyar da za a iya yin AutoSum shine ta zaɓar sau biyu akan gunkin "+", ana aiwatar da shi a cikin sel masu dacewa suna samun sakamakon jimlar ƙimar da aka ƙaddara ba tare da buƙatar aiwatar da shi tare da mai nuna alama ba, wanda shine dalilin da yasa ake ɗaukar abin zamba ga AutoSum.

Sum a cikin tebur lokaci guda

A wannan yanayin, idan kuna son yin aikin ƙarin akan wasu ƙimar da aka samu a cikin sel waɗanda aka shirya a jere kuma a cikin ginshiƙi, dole ne a bi jerin matakai, waɗanda aka nuna a ƙasa a cikin hanyar jagorar maki. don sauƙaƙe aikace -aikacen sa a cikin maƙunsar shirin Excel:

• Mataki na farko da dole ne a aiwatar shine zaɓi ko zaɓi jere da shafi wanda aikin AutoSum zai yi.
• Sannan dole ne a zaɓi zaɓin AutoSum sau biyu
• Ta wannan hanyar, ana samun jimlar aikin tare da ƙimar daidai
• Sannan, a mataki na gaba, an gano cewa shirin Excel yana yin aikin ƙarawa ta atomatik a cikin layuka kuma bi da bi a cikin ginshiƙai
• Don wannan dole ne ku zaɓi ƙimar da aka samo a cikin sel
• Ya kamata a bar shafi tare tare da layin da babu komai
• Ta wannan hanyar yana yiwuwa a aiwatar da aikin ta atomatik tare da ƙimar daidai kuma a cikin lokaci ɗaya

Sum a cikin duka shafi a Excel

Don cimma ƙarawa a cikin shafi ɗaya kawai a cikin shirin Excel, ana iya aiwatar da shi ta hanya mai sauƙi tunda wannan hanyar na iya haifar da shakku a lokacin aikace -aikacen ta, shi ya sa a ƙasa akwai matakan da dole ne a bi don aiwatar da shi a cikin hanya madaidaiciya:

• A matakin farko wanda dole ne a aiwatar, dole ne a buɗe sabon maƙunsar Excel
• Sannan dole ne a shigar da ƙimar daidai
• Don wannan, kowane ɗayan bayanan da aka ƙaddara dole ne a sanya su cikin shafi na A
• Yanzu dole ne ku aiwatar da hanya don ƙara kowane ƙimar da aka shigar a shafi na A
• Dole ne a yi la'akari da adadin ƙimar da aka shigar saboda yakamata a haskaka shi har zuwa jere na ƙarshe wanda ke da wannan shafi tare da ƙimomin da aka shigar
• Yanzu yakamata ya kasance yana cikin sel na ƙarshe tare da ƙimar da aka shigar
• Muna ci gaba da zaɓar tantanin halitta wanda ke bi kuma babu komai
• A wannan lokacin ne yakamata ku je menu wanda Excel ke da shi
• Sannan dole ne ku zaɓi zaɓi na AutoSum
• Ana samun sakamakon jimlar da aka yi
• Tare da waɗannan matakai masu sauƙi yana yiwuwa a ƙara bayanan da aka shigar a cikin takamaiman shafi
• Hakanan zaka iya gudanar da wannan jimlar akan shafi ta shigar da aiki
• Dole ne a zaɓi tantanin da ke bin ƙimar ƙarshe da aka shigar
• Sannan zaɓi zaɓi na gaba "Alt + Shift + ="
• Ta wannan hanyar, ana samun sakamakon jimlar aikin da za a yi ta atomatik.
• Kasancewa ta wannan hanyar dabara ce ko gajeriyar hanya wacce shirin Excel ke da ita

Ƙara ginshiƙai biyu a cikin Excel

Tambayar yadda ake ƙara ginshiƙai biyu a cikin Excel shima ya zama ruwan dare gama gari, wanda a ciki kuma zaku iya amfani da gajerun hanyoyin da shirin na Excel ya sauƙaƙe aiwatar da wannan aikin. Don wannan, dole ne a bi jerin maki waɗanda ke zama jagora ga matakan da za a bi don yin jimlar tsakanin ginshiƙai biyu:

• A mataki na farko, dole ne a buɗe sabon maƙunsar shirin Excel
• Sannan dole ne a shigar da ƙimar daidai a cikin ginshiƙai biyu
• Waɗannan na iya zama Shafi A da Shafi B
• Sannan dole ne ku zaɓi ginshiƙai don yin aikin Sum
• Gaba dole ne ku zaɓi maɓallan "Alt + Shift + ="
• Wannan haɗin maɓalli yana aiwatar da jimlar ta atomatik tsakanin ginshiƙai biyu
• Ana samun sakamakon a cikin tantanin halitta wanda babu komai kuma kusa da sel na ƙarshe tare da ƙimar rukunin da aka shigar
• Ana ɗaukar wannan fom ɗin azaman dabarar Excel don adana lokaci da ƙoƙari don yin aikin ƙari tsakanin ginshiƙai biyu
• Ta wannan hanyar, ana samun sakamakon da ake so cikin sauƙi da sauƙi.

Menene aikin "Ƙara idan" a cikin Excel?

Daga cikin ayyuka daban -daban da kayan aikin da ake samu a cikin shirin Excel, aikin SUMARIF ya yi fice saboda ana ɗaukarsa ɗayan ayyukan da masu amfani za su iya amfani da su, tunda yana ba da zaɓi na cimma jimlar adadin sel waɗanda ke gabatar da takamaiman tsari. ma'auni.

Ta wannan hanyar, yana yiwuwa a rarrabe daga aikin duk zafin da ba ya gabatar da wannan takamaiman sifa ko ma'auni kuma mai amfani yana aiwatar da shi. Tare da wannan yanayin da aka zaɓa, ana iya aiwatar da jimlar gwargwadon yanayin da ake buƙata, ta haka ne ake samun adadin kuɗi ta hanyar canza yanayin.

Aikin SUMARIF yana gabatar da jerin muhawara waɗanda sune tushen aikin ta, don haka yana da mahimmanci a san waɗannan muhawarar don samun damar aiwatar da wannan aikin daidai, wannan shine dalilin da yasa aka yi bayanin muhawarar da yakamata ta fahimta a ƙasa.

Rango

• Hujja ce ta tilas
• Ya ƙunshi ƙayyade ko bincika kewayon da aka kafa a cikin tantanin halitta
• Ya ƙunshi dukkan ƙimar da za a bincika da kimantawa

Kwatantawa

• Hujja ce ta tilas
• Bayar da sharadin da dole ne a cika shi
• Yana sanya sifar da dole ne a yi la’akari da ita a cikin tantanin halitta kuma ana la’akari da ita cikin jimlar
• Yana tabbatar da bayyana jimlar, ko dai ta hanyar lamba, rubutu, da sauransu
• Lokacin da kuke da shari'ar da kuke da yanayin takamaiman lamba, ana haifar da sakamakon da tantanin halitta ya yi daidai da adadin yanayin.
• Hakanan kuna iya gabatar da shari'ar cewa yanayin ya kasance saboda magana, don haka a wancan lokacin zaku iya zaɓar iyakokin "Mafi Girma" ko kuma "Ƙasa da" don ci gaba da jimlar daidai
• A cikin yanayin da aka kafa yanayin yanayin rubutu, shine lokacin da akwai ƙimar rubutu wanda dole ne ya haɗu a cikin ƙaruwar adadin wasu ginshiƙai waɗanda ke da takamaiman lambobi.

Sum sum

• Wannan hujja ce ta tilas
• Ya ƙunshi nuna sel waɗanda za su shiga ko shiga cikin jimlar daidai
• Lokacin da aka cire wani ƙima, ana aiwatar da jimlar tare da jayayya na Range

Yadda ake ƙara sa'o'i a cikin Excel?

A cikin shirin Excel, ana iya aiwatar da ayyuka daban -daban azaman ayyuka, daga cikinsu ana iya haskaka aikin yin jimlar awanni, wannan yanayin yana da ɗan rikitarwa idan aka kwatanta da sauran ayyukan ƙari saboda gaskiyar cewa dole ne ya sami ilimin. na hanyoyin da za a gudanar da su yadda ya kamata.

Don wannan hanya ya zama dole a fahimci matakan da dole ne a aiwatar don sauƙaƙe aikin kuma a guji rikitarwa a aiwatar da shi. Babban shakka da rikitarwa da ake samu a cikin irin wannan ayyukan shine lokacin a cikin sel daban suna da sa'o'i da mintuna daban -daban, don haka jimlar ta fara daidaitawa cikin wahala.

A cikin waɗannan lokuta, ana shirya sel masu sa'o'i da mintuna daban -daban a cikin takamaiman fanni, don haka ƙara jimlar sa'o'i yana da wuya. Ba za a iya aiwatar da aikin SUM ba saboda wannan aikin yana buƙatar ƙarin ƙimar lissafi, don haka idan aka yi amfani da sakamakon ba daidai ba ne.

Ga waɗannan lamuran, dole ne a tsara sel na maƙunsar don samun nasarar aikin ta hanyar da ta dace. Wannan shine dalilin da ya sa aka nuna matakan da za a bi a ƙasa ta wasu maki waɗanda ke zama jagora don cimma aikin ƙari ta hanyar da ta dace:

• Don matakin farko wanda dole ne a aiwatar shine samun sel na maƙunsar da aka tsara don ci gaba zuwa tsarin SUMA.
• Sannan dole ne a shigar da ƙimar daidai da minti da sa'a a cikin kowane sel
• Sannan ana sanya shi a cikin sel na ƙarshe tare da ƙimar da aka shigar
• Yanzu ci gaba kai tsaye zuwa sel na gaba wanda babu komai
• Muna ci gaba don zaɓar maɓallin linzamin kwamfuta na dama
• Sannan dole ne ku zaɓi zaɓi na "Tsarin salula"
• A cikin wannan ɓangaren muna ci gaba da buɗe akwati tare da zaɓuɓɓuka
• Sannan dole ne ku je sashin da ake kira "Rukuni"
• Sannan dole ne ku zaɓi zaɓin da ake kira "Na al'ada"
• Yanzu dole ne ku gungura a sashin da ake kira "Nau'in"
• Da ke ƙasa akwai yuwuwar zaɓar takamaiman tsari
• A wannan yanayin, dole ne ku zaɓi tsarin "[H]: mm: ss".
• An zaɓi shi a kan maɓallin da ke cewa "Karba"
• Yana da mahimmanci a tuna cewa dole ne a takaita sa'o'i a cikin baka
• Ta wannan hanyar yana ba da ma'anar cewa jimlar sa'o'i da mintuna ana haifar su ta hanyar da ta dace
• Don kammala wannan aikin, dole ne ku zaɓi maɓallin AutoSum

Yadda za a takaita takamaiman kwanakin a Excel?

A cikin shirin Excel kuna da yuwuwar ƙara kwanakin a hanya mai sauƙi kuma mai sauƙi, duk da haka yawanci ana haifar da shakku a cikin wannan ɓangaren saboda wannan nau'in ƙari da tsarin sa ba gama gari bane, duk da haka matakan da dole ne a ɗauka suna da sauƙi ba tare da buƙatar ƙara rikitarwa a aiwatar da shi.

Dole ne shirin yayi la'akari da kwanakin azaman lambobi don haka an kafa bambancin saƙar rubutu kuma ana iya aiwatar da aikin ƙari. Wannan shine dalilin da ya sa aka nuna matakan da za a bi a ƙasa ta hanyar 'yan maki don a sami sauƙin wannan jimlar:

• A mataki na farko da za a aiwatar, dole ne a buɗe faifan rubutu mara komai
• Sannan dole ne ku shigar da kwanakin da suka dace
• Idan akwai ranakun daban -daban, shiga cikin sel A1 da sel B1
• Sannan dole ne ku zaɓi sel d B1
• Yanzu an danna shi tare da maɓallin linzamin kwamfuta na dama
• Dole ne ku zaɓi zaɓi na "Tsarin salula"
• Sannan dole ne ku zaɓi zaɓi na "Janar"
• Muna ci gaba da buɗe akwatin zaɓuɓɓuka
• Sannan yakamata a nuna cewa a cikin sel B1 takamaiman lambar tana canzawa zuwa "43702"
• Tare da wannan, ana ƙara ƙima 1 a cikin tantanin
• Sannan dole ne a sake zaɓar shi "Tsarin salula"
• Yanzu an canza shi zuwa gajeriyar kwanan wata
• Ta wannan hanyar ana samun jimlar kwanan wata daidai