Sida loo sameeyo isku dhufasho ee Excel

isbiriidhshiit awood leh "Microsoft Excel" si fudud u tarmin doonaa mid ka mid ah tirada iyo safafka aad. Marka waxa ay noqon kartaa wax aad u waxtar leh in arrintan la xiriira? Waxaa jira xalal badan oo:

• gacanta ma aha calculator ah.
• Tarma safafka badan oo tiro, oo aad rabto in aad ogaatid nooca lambarada ay ku lug leeyihiin, oo laga yaabo in xitaa uu u bedelo qaar ka mid ah (in hawlaha calculator caadiga ah oo aan u baahan si ay u bilaabaan line mar kale badbaadin xisaabinta).
• Ku dhufo - qayb kaliya ee kooban oo ah caanaha.

Sida aad arki karto, isku dhufashada si Excel - wax gabi ahaanba aan micno ku fadhiyin. Aan isku dhufashada hawlgallada ma aan samayn karo ku dhowaad ma ka mid ah caanaha.

Lahjadaha dhufasho ee "Excel"

"Excel" ogolaanayaa inaad midba midka kale si ay u tarmin doonaa,

• lambarada gaarka ah (positive, negative, abyoonaha, jajab).
• The tirada unugyadan.
• Safafka tirooyinka.
• qiimaha Boolean

Sida loo sameeyo isku dhufashada? formula ee isku dhufashada ee Excel bilaabantaa "uyeelaysaan" calaamad (=). Sida halkan formula kasta oo lagu tilmaamay mid ka mid ah ka dib markii tiro kale (ama cell tixraaca iyaga oo ka kooban) ku xiran sumaddii "star" (*). formula noocan oo kale ah uu noqon doono sida soo socota: "= 0.22 * 16 * -5" (marka bateen tirada gaar ah) ama «= G4 * I5» (sida doodaha markii tixraacyada gacanta ku qeexan). Tani waa version ugu horeysay ee isku dhufashada.

formula dhufashada ee Excel la diiwaan karaa iyadoo la isticmaalayo "dhigi" function dhisay-in:

Faa'iidada of isticmaalaya shaqada this waa in ay sameeyaan isku dhufashada in Excel - suurtagalnimada ee tarmo by kasta oo kale, ma tirada oo keliya, laakiin sidoo kale guutooyin.

Waxaan hadda u fiirsada tusaalooyin gaar ah.

Isku dhufashada by a "star"

Isku day on xaashida ka mid ah buugga "Excel" raac tusaalooyinkan:

iyaga waxaa la jiray, waxaad arki doontaa in ka dhigi dhufashada ee Excel waa u fududahay. Ogsoonow in natiijada qiimaha macquulka dhufashada noqon 0 (been ah) ama 1 (run).

khasaare kaliya ee habkan of dhufashada - kala duwan in tirada sida wax xuja ah, ayuu ma aqbali karaan. Malaha ugu badnaan, taas oo ku filan wax kasta oo user qeexay meel dhamaadka tobanka tirada labaad ama gacanta, ku biiro, iyo daraa in characters si "calaamad."

Sida kaliya ee agagaarka khasaare this waa in la isticmaalo "dhigi" shaqo.

Isku dhufashada isticmaalaya "dhigi" function

Ka fikir sida loo sameeyo isku dhufasho ee Excel isticmaalaya function dhisay-in.

buugga The "Excel" si ay u abuuraan saxan la mid ah oo hubiyo tusaalooyin iyada. In mid ka mid column dhigi qiimaha badan ee column kale sidoo kale dhawr macne. Isku day in aad codsato shaqo "dhigi" xidhay, oo wuxuu oofin dhufashada by gacanta iyada oo calaamada "star".

Tiirka "Formula" ee shaxdan si cad u muujinaysaa in haddii safafka qiimaha waa u dhow, waxay loo isticmaali karaa sida kala duwan. Sidoo kale on miiska aad ka arki kartaa in shaqada "dhigi" in lagu dhufto oo dhan oo safafka kuwan, iyo natiijada lagu helo si la mid ah sida haddii aan ku hal gacan badiyaa qiimaha unugyadan. Sida aad arki karto, isku dhufashada si Excel - waa SNAP ah.

Dhab ahaantii Interesting! Isku day mid ka mid ah qiimaha ayaa haatan laga saaray gacanta kasta, oo qayb ka ah kala duwan, unugyada madhnaan doonaa gebi ahaanba madhan. Waxaad arki doontaa in waqti isku mid ah ka dhigi shaqo ah si ay u qabtaan xisaab ah, si fudud u sii daayo gacanta madhan. Oo halkan waa natiijada dhufashada "Buugga" jeestay in ay eber. Tani weli waa faa'iido kale oo kala duwan ee xulashada dhisay-in lagu dhufto "calaamad" - waxa aanu aqbali unugyada maran sida eber, waxa kaliya iyaga oo soo bandhigtay ka xisaabinta.

Waxaa jira jeer marka xisaabaha lagu sameeyey dadka aawadiis ee hannaanka shaqada buugaagta go'yaal, iyo sheet ka dhalanaya waxa lagu kaydiyaa formula, oo ka kooban wax soo saarka oo ka mid ah qiyamka oo ka mid ah xaashiyaha kale. Haddii mid kasta oo iyaga ka mid ah wuu madhnaan doonaa, dhufashada fudud oo ka mid ah "star" jeesan natiijada oo dhan in eber.

Laga soo bilaabo tan waxaannu ku tirinnaa karaa in maamulka xisaabaha adag on go'yaal badan fiican in la isticmaalo shaqada "dhigi" sida mudnaanta.

shaxda isku dhufashada

Fiiri la soo dhaafay, la abuuro shaxda isku dhufashada ah ee Excel. Way fududahay.

In xeerkii shaxda isku dhufashada caadiga ah waxaa ka mid ah column ah mid ka mid ah set oo ah tiro oo isku xiga - oo kale ah. Si aad u awoodo in aad nuqulka formula ah, waxaa lagama maarmaan ah in la isticmaalo links isku qasan - si uu u xaliyo by "dollar" calaamada ($) Tirada column laga bilaabo khadadka xog joog iyo jiif in ay xogta '= A2 * $ B $ 1 ".