Ƙididdigar zuwa Excel - yana da sauki!

A wannan labarin, za mu duba a daya daga cikin ofishin aikace-aikace MS Office Excel.

MS Office Excel - da wani shirin da aka hada a Microsoft Office Complex. Amfani da dama ilmin lissafi lissafin, charting, samar da alluna, da dai sauransu

shirin daftarin aiki ne a Kundin. A littafin kunshi wani Unlimited yawan zanen gado kafa ta mai amfani.

Kowane takardar shirin ne a tebur, kunsha na 256 layuka da kuma 65.536 ginshikan. Kowane cell a tebur da aka kira wani cell.

Excel cell na da mutum adireshin kunshi jere lambar da Latin haruffa shafi (msl, 1A, 2B, 5C).

main fasali

The aiki "Sum" (Naira Miliyan Xari a Excel)

A summation na Figures da lambobin a Excel za a iya yi a hanyoyi uku.

1. Amfani da wani misali da alama - da da ( "+"). A mafi yawan lokuta, irin wannan hanyar da ake amfani a cikin Bugu da kari na karamin adadin lambobi ko lambobi, da kuma a Bugu da kari dabarbari for ƙidãyar sauran ayyuka.
2. Amfani da shigar da aiki "Adadi" da kuma zabi muhawara. Bayar ƙara lambobi shirya a guda tsararru (na shafi, jere), wadanda ba contiguous Kwayoyin, daya girma tsararru, da tsararru na dab Kwayoyin da kuma wadanda ba contiguous sassa. Adadin a Excel amfani da wannan aiki za a iya lasafta wani.
3. Amfani AutoSum alama «Σ», da kuma zabar wani kewayon sharuddan. Ana amfani da yin lissafi da adadin a irin haka ne, kazalika da "Jimlar".

Da dabara "Zagaye"

A sakamakon wani lissafi, kazalika da adadin a Excel, yana iya zama batun zuwa Ƙididdigar. Ƙididdigar a Excel ta muhimmanci ba ya zama rude tare da nuni darajar.
Don yin wani aiki "Ƙididdigar a Excel," dole ne ka zaɓa da cell dauke da lissafi sakamakon, riga da lambar da wani daidai alamar ( '='), zaɓi "Zagaye" aiki da saita lambar da ake so na ragowa.

Game da alama nuni da za a lura da cewa cell nuna da yawan ragowa wanda aka sanya a cikin shi ga mai amfani da ganuwa. Amma a wannan yanayin, Ƙididdigar kamar yadda irin wannan ba ya faru. Lokacin da canza cell size, yawan ragowa kuma dabam a matsayin manyan, ta kara cell, da kuma a cikin karami, idan aka ragewa, shugabanci.

Kamar yadda ka gani, da Ƙididdigar a Excel ba irin wannan mai wuya aiki.

"DACE", "Len" - rubutu ayyuka da damar canza layi tsawon littãfi ko amfani, da kuma hada ko tsaga line.

"BDSCHET", "DSUM" - aiki don bayanai. Bada wajen ƙidaya yawan database records, Naira Miliyan Xari da dabi'u. Wannan aiki ne mai kama da adadin a Excel kamar "Sum".

"Sel" - Wannan aiki na samar da mai amfani da bayanai game da kaddarorin da cell.

Math Ayyuka - Excel kwaya. Lissafi yin amfani da su - babban manufar shirin. A Excel, wata babbar sa na ilmin lissafi ayyuka kamar ba tare da, cosine, baka cosine, baka ba tare da, tangent, cotangent. Lokacin da wadannan siffofin sukan samu Multi-bit darajar. Saboda haka zaɓi "Ƙididdigar a Excel" a cikin wannan labarin ne da amfani a wannan harka.

"MMULT", "MDETERM", "asi" ga yadda ake gudanar a Tazarar iri-iri, matrices.

"Naúrar", "rikon" for tsaka-tsaki da kuma karshe dabi'u.

Logarithms, mikakke logarithms, logarithms.

Statistics. "BETAINV" - sa a koma da kishiya aiki na na game aikin beta yiwuwa yawa. "WEIBULL" - Ya Koma cikin Weibull rarraba.

MS Office Excel ma yana da wani kudi aiki, aiki nassoshi da kuma iri-iri, kwanan wata da lokaci ayyuka, bincika ayyukan da dukiyoyinsu.

Saboda haka, wannan shirin shi ne wani ba makawa ga kayan aiki mutane daga dukan harkokin rayuwa wanda ake ko ta yaya da alaka da mutane da kuma lambobin.