Madadaalo Xisaabta. celceliska

In xisaabta, celceliska xisaabta ee lambarada (ama celcelis) - wadarta tirooyinka oo dhan in set this, qaybsan by tiradooda. Tani waa aragtida ugu baahsan iyo guud of size celcelis ahaan. Sida aad ogtahay, si aad u ogaato qiimaha celcelis ahaan, waxaa lagama maarmaan ah in la koobo dhammaan xogta aad u baahan tahay oo kala goo by tirada la eego.

Waa maxay celceliska xisaabta?

Bal aynu eegno tusaale.

Tusaale 1. tirada la eego 6, 7, 11. Waxaan u baahanahay in la helo ay qiimaha celceliska.

Go'aan.

Si aad u bilawdo, heli wadarta dhammaan tirada xogta.

6 + 7 + 11 = 24

Haddaba qaybin lacagta keentay by tirada la eego. Tan iyo markii aan leeyihiin saddex eego, siday u kala horreeyaan, waxaan u kala qaybiyaan saddex.

24: 3 = 8

Sidaas awgeed, qiimaha celcelis ahaan tirooyinka 6, 7 iyo 11 - waa 8. Muxuu 8? Maxaa yeelay qadarka 6, 7 iyo 11 ka mid ah sida saddex eights noqon doonaa. Tan waxaa si cad u arkay in sawir ah.

Qiimaha celcelis waa xoogaa la mid ah "Nigeria" tirooyinka. Sida aad arki karto, farabadan of qalin u noqday heer la mid ah.

Ka fiirso tusaale kale, si ay u adkeeyaan aqoontooda.

Tusaale 2. tirooyinka la eego: 3, 7, 5, 13, 20, 23, 39, 23, 40, 23, 14, 12, 56, 23, 29. Waxaa lagama maarmaan ah in la helo ay qiimaha celceliska.

Go'aan.

Waxaan ka heli tiriya.

+ 7 + 5 3 + 13 + 20 + 23 + 39 + 23 + 40 + 23 + 14 + 12 + 56 + 23 + 29 = 330

Qaybi tirada ereyada (kiiskan - 15).

330: 15 = 22

Sidaas awgeed, qiimaha celceliska ah ee la ballamay tirooyinka waa loo siman yahay ilaa 22.

Haddaba ka fiirsada tirada taban. Xusuuso sida loo soo koobo. Tusaale ahaan, waxaad leedahay laba tiro yihiin 1 iyo -4. heli doonaan wadarta.

1 + (-4) = 1 - 4 = -3

og, ha ka fikiro si aynu tusaale kale.

Tusaale 3. Soo saar qiimaha celceliska tirada: 3, -7, 5, 13, -2.

Go'aan.

Raadi wadarta tirooyinka.

3 + (-7) + 5 + 13 + (-2) = 12

Tan iyo shuruudaha 5, kala qaybin lacagta keentay by 5.

12: 5 = 2,4

Sidaas awgeed, xisaabta ay ka dhigan tahay qiimaha of 3, -7, 5, 13, -2 waa 2.4.

Maalmahan, horumarka farsamada badan habboon in la isticmaalo for helidda qiimaha celcelis ahaan barnaamijyada computer. Microsoft Office Excel - mid ka mid ah. Raadi qiimaha celceliska ee Excel sahlan oo dhakhso ah. Gaar ahaan, barnaamijkan waa baakadka ku software Microsoft Office. Ka fiirso tilmaamo gaaban, sida in la helo xisaab celceliska qiimaha leh barnaamijkan.

Si loo xisaabiyo qiimaha celceliska taxane ah oo tiro, isticmaali function celceliska. Saan ee shaqada this:
= Celceliska (argument1, argument2, ... argument255)
halkaas oo argument1, argument2, ... argument255 - waa labada tiro ama tixraacyo cell (unugyada loogu tala galay safafka iyo Arrays).

Si aad uga dhigto more cad, waxaan tijaabin doonaa aqoonta helay.

1. Ku qor lambarka 11, 12, 13, 14, 15, 16 ee C1 cell - C6.
2. Dooro C7 cell, adigoo gujinaya waxa on. In goobta this, waxaan ku tusi doonaa qiimaha celceliska.
3. Click on the "Caanobooraha" tab.
4. Dooro Functions More> si tirokoobka in la furo ah liiska hoos-hoos.
5. Select CELCELINTA. Ka dib markii sanduuqa wada hadal this waa in la furo.
6. Dooro iyo jiididda in gacanta C1-C6, in la qeexo kala duwan oo ku yaal sanduuqa wada hadal.
7. Xaqiiji in aad talaabo adigoo riixaya "OK".
8. Haddii aad wax kasta si sax ah, C7 gacanta, waa in aad arki jawaab - 13.7. By gujinaya C7 shaqada unug (= Celceliska (C1: C6)) lagu soo bandhigi doonaa in bar caanaha.

Aad u habboon in la isticmaalo function si diiwaan haynta, biilka ama marka aad kaliya u baahan tahay si aad u ogaato qiimaha celceliska taxane ah oo aad u dheer oo tiro. Sidaa darteed, waxaa inta badan loo isticmaalaa in xafiisyada iyo shirkadaha waaweyn. Tani waxay u ogolaaneysaa in nafo la amarka diiwaanada, iyo waxay suuro gelineysaa in si deg deg ah u hesho wax (tusaale ahaan, dakhliga celceliska bil kasta). Sidoo kale iyadoo la kaashanayo Excel, waxaad ka heli kartaa qiimaha celcelis ahaan shaqo.