Sida loo badin doonaa in unugyada "Eksele" Naftooda ka mid ah?

Maalmahan, mid ka mid ah waxyaabaha ugu caan ah oo xisaabaha adag yahay barnaamijka Microsoft Excel. Its ka shaqeynayaan ballaadhan u fududayn lahaa xalka of hawlaha set in hore u lahaa in ay qaataan waqti badan ku. Maanta aynu eegno sida leysugu dhufto ee unugyada "Eksele" wada tiro badan.

Isku dhufashada ee "Eksele"

Ka hor inta aadan ogaado sida leysugu dhufto tiro "Eksele", waxaa xusid mudan shaqeynayaan ballaadhan barnaamijka, kaas oo u ogolaanaya in labada shaqo cad tirooyinka iyo isticmaalka unugyada ay ku jiraan naftooda iyo lambarada iyo qaaciidooyinka, dejiyo ay ka shaqeeyaan. Si aad u badin hal ama in ka badan unugyada ama tirada unugyada in loo baahan yahay in bar formula ka dib markii calaamada siman tilmaamaya xubno xog sheet ama qiimaha qoraal ah.

Isku dhufashada by gacanta cell

Dheeraad ah, waxaa haboon fahamka mabda'a, sida in "Eksele" in lagu dhufto gacanta in ay gacanta iyo wixii dhibaatooyin aad la kulmi karto in geeddi-socodka. Waayo, tarmo qiyamka laba unugyada oo isku xigta u baahan tahay inaad iska diiwaan formula qaabka soo socda: "= * B A", halkaas oo "A" iyo "B" - links in ay xubno ka kala mid ah xaashida "Excel", i.e. unugyada.

Hel natiijada, waxaa laga yaabaa in aad u baahan tahay in la abuuro nuqul ka mid ah, iyo dadka isticmaala inta badan ma ka waaban, kaliya nuqul qiimaha cell this by it galinta kale. Si kastaba ha ahaatee, habkan ku dhici doonaa oo la beddelo links khuseeya fiiqaya in factorization ah. Si looga fogaado qalad noocan oo kale ah, waa in ay noqdaan unug meesha aad rabto in aad nuqul ka natiijada, geli link a si ay gacanta ugu soo guuriyeen, ama "hagaajin" cinwaanka isiradeeda by "$" calaamada. calaamada dollar xajisto qiimaha tixraaca in dhimaya ah, ee Raaca - taas oo ah, $ link A4 had iyo jeer u gudbin doonaa in column A, A $ 4 - line afraad, iyo $ A $ 4 - kaliya cell A4 ah. In si kale loo dhigo, qamaar ee gacanta - abuurka ah ee tixraaca ah buuxda, waxa uu.

Isku dhufashada of columns iyo saf

Isticmaalka qamaar cinwaanada cell geynta, aad si toos ah u sida leysugu dhufto ee "Eksele" column by column ama isku xigta si ay u keensato tegi karo. Si loo badbaadiyo waqtiga on qoraal formula weyn, aad si fudud u isticmaali kartaa hantida badala tixraaca cell marka u dhaqaaqo a cinwaanka pointer cusub. Taasi waa, haddii ay lagama maarmaan tahay in lagu dhufto laba laba qiimaha laba tiirar, waxa ku filan in ay qoraan formula isku dhufashada labada ugu horreeya ee unugyada, ka dibna, haysta calaamad "madow daray", taas oo u muuqatay in geeska midig ee hoose in ay hoos u fidin natiijada oo ay la socdaan dhammaan qiyamka column-multiplier.

Si loo gaaro natiijo isku mid ah saf ah, waxaa lagama maarmaan ah oo kaliya in ay soo saaraan natiijada iskala weheliyaan khadadka kala. Waxaa xusid mudan in si looga fogaado wareegaayo intii lagu koobi xiga natiijada, waxaa lagama maarmaan ah si uu u xaliyo caanaha column cayimay ama isku xigta - ka dibna ay awoodaan si looga fogaado khaladaadka ku jira xisaabinta.

dhufashada ee isku xigta ama column si ay gacanta

By fahamka sida leysugu dhufto ee "Eksele" column by column ama isku xigta si ay u keensato, waxaa lagama maarmaan ah in deggan ka mid ah hawlgal gaar ah - isku dhufasho unugyada oo isku xigta ama column. Haddii geynta dhufashada isticmaalaan tallaabo la mid ah sida ay dhacdo isku dhufashada ah tiirarkii, natiijada kaliya loo laablaabi by qiimaha safka kowaad ee column this, tan iyo cinwaanka unugga la cell walba soo jeeda mid ka mid booska kala duwanaan doonaa.

Si looga hor, waxaa lagama maarmaan ah si uu u xaliyo tirada line a lagu dhufto cell ama ay kulligeed - kiiskan, isticmaali karin qiimaha for tiirar badan noqon doonaan. In the case of dhufashada by line cell column warqad qufulka gaar ah a ku filan oo u ku nool yahay, ama inay sameeyaan labada joogto ah u dhimaya cinwaanka cell.

Sida loo badin doonaa tirooyinka oo dhan oo isku xigta ama column

Mararka qaarkood "Eksele" waxaa loo baahan yahay in la sameeyo qalliin la mid ah guud ahaan in, kaliya fulinta hawlgalka dhufasho. Si kastaba ha ahaatee, nidaam gaar ah oo si toos ah loogu talagalay this aanu jirin, sidaa darteed dad badan oo aan ogayn sida loo "Eksele" tarma tirada column hal ama keensato kasta oo kale, waxaa si cad loogu sameeyo, qoraalana garoomada gacanta kasta. Dhab ahaantii, in barnaamijka uu jiro qalliin oo kaa caawin kara xallinta dhibaatada of sida leysugu dhufto ee "Eksele" mid kasta dhowr jeer oo kale oo si dhakhso ah.

Si aad u tarmin kala duwan oo qaar ka mid ah unugyada qaba midba midka kale, kaliya dooro menu "Function Insert" howlgalka lagu magacaabo "dhigi." Sida muran shaqada unugyada in ay tahay in la sii badisay by kasta oo kale, waxay noqon kartaa sida tiirar, khadadka, unugyada, ama arrays oo dhan. Waa in la ogaadaa in joogitaanka cell madhan kala duwan loo dejiyay natiijada dhufashada ma qummana in eber - kiiskan barnaamijka iska indha doonaa gacanta this, i.e. waxba Gallobayse midnimada.

oo kooban

Jaantuska soo baxay sida leysugu dhufto ee "Eksele" la fulin karo waraaqaha si cadaalad ah oo adag, oo ay ku jiraan wararka dhaqaalaha iyo qiyaasaha. Inta badan hawlaha xisaabta lagu samayn karaa in si la mid ah, laakiin qaar ka mid ah ay qaataan waa in ay tixgeliyaan waxyaabaha gaarka ah ee ay fulinta, iyo sidoo kale qaab unug. Sidaas darteed, tusaale ahaan, by qaybinaya gacanta in gacanta ay ka maqan yihiin qiyamka in mid ka mid ah, natiijada waa qayb baadi by eber ah.