Te whakaawhiwhi ki Excel - te mea ohie!

I roto i tēnei tuhinga ka titiro tatou ki tetahi o nga tono tari MS Office Excel.

MS Office Excel - he hōtaka ngā e kei roto i te Matatini Microsoft Office. Whakamahia hoki te whānuitanga o tātaitanga pāngarau, Tūtohi, te hanga tepu, me ētahi atu

tuhinga hōtaka ko te pukamahi. Kei te pukapuka o te here i te maha o ngā rau whakaturia e te kaiwhakamahi.

Ko te tepu ia hōtaka pepa, arā, o 256 nga rarangi, me 65,536 tīwae. huaina katoa pūtau i roto i te ripanga e te pūtau.

He ona ake wāhitau takitahi ngā o te tau haupae me te pūtau Excel Latin reta tīwae (hei tauira, 1A, 2B, 5C).

āhuatanga matua

Ko te mahi "moni" (te moni i roto i Excel)

Ka taea te mahi te aofangatuku o whika me tau i roto i Excel i ara e toru.

1. Mā te whakamahi i te tohu tāpiri paerewa - te tāpiri ( "+"). I roto i te nuinga o te wā, e whakamahia ana he tikanga taua i roto i te tua o te tau iti o ngā mati tau ranei, a i roto i ngā tātai tua mo te tätaitanga o te tahi atu mahi.
2. Mā te whakamahi i te tāuru mahi "moni", me te kōwhiri tohenga. Āhei tāpiri tau whakaritea i roto i te ngohi kotahi (o te tīwae, rarangi), pūtau kore-pātata, kotahi ngohi ahu, te ngohi o ngā pūtau pātata me ngā wāhanga kore-pātata. Nui i roto i Excel te whakamahi i tenei mahi e taea te tatau i tetahi.
3. Mā te TapekeAunoa tohu «Σ», a te kōwhiri i te whānui o ngā ngā. Kei te whakamahia te reira ki te tātai i te moni i roto i ngā take pērā, me te te "moni".

Ko te tātai "rauna"

Ko te hua o tetahi tātai, me te te nui i roto i Excel, kia kia ngohengohe ki whakaawhiwhi. Te whakaawhiwhi i roto i te nui Excel kore ki te e raruraru ki te uara whakaatu.
Hei mahi i tētahi mahi "whakaawhiwhi i Excel," me tīpako koe i te pūtau kei roto i te hua tatauranga, mua i te tau ki te tohu rite ( '='), tīpako i te "rauna" mahi, me te whakaturia te maha e hiahiatia ana o paraire.

No nia i te whakaatu tohu kia tuhia ki e whakaatu te pūtau te maha o nga paraire whakanohoia e te roto i te reira no te aritanga kaiwhakamahi. Otiia i roto i tenei take, whakaawhiwhi rite taua e kore e tupu. A, no te huri i te rahi pūtau, rerekē te maha o nga paraire ano rite te nui, i te whakanui ake i te pūtau, a i roto i te iti, ina te whakaiti i te reira, te arata'iraa.

Ka rite ki a koutou e taea te kite, e kore te mea he taua mahi uaua te whakaawhiwhi i Excel.

"MAITAI", "Len" - mahi kuputuhi e tukua ki te huri i te rēhita raina roa ranei whakamahi, me ki ngā ranei raina wahia.

"BDSCHET", "DSUM" - mahi mō pātengi. Tukua ki te tatau i te maha o ngā pūkete pātengi raraunga, te moni o uara. Ko rite ki te nui i roto i Excel rite "SUM" tenei mahi.

"Ngā pūtau" - tenei mahi whakarato te kaiwhakamahi ki ngā mōhiohio e pā ana ki te āhuatanga o te pūtau.

Taumahi Math - Excel pata. Calculations whakamahi ratou - te whakaaro matua o te hōtaka. I roto i te Excel, he huinga nui o ngā mahi pāngarau pērā i aho, whenu, pewa whenu, pewa hara, pātapa, pātapa taupoki. A, no te e maha whiwhi enei āhuatanga uara moka-maha. Na tīpako "Te whakaawhiwhi i Excel" i roto i tenei tuhinga he whai hua i roto i tenei take.

"MMULT", "MDETERM", "ASI" mō ngā mahi i runga i ngā huānga tau, tāhū,.

"KAUPAPA", "wā" mō ngā uara takawaenga, me te whakamutunga.

Taupū kōaro, taupū kōaro rārangi, taupū kōaro.

Tatauranga. "BETAINV" - hanga i te hoki ki te mahi kōaro o te mahi peta kiato tūponotanga wāhi. "Weibull" - Whakahokia te Weibull tuari.

MS Office Excel hoki kua he mahi pūtea, tohutoro mahi me ngā huānga, te rā me te mahi wa, te taki ohipa me ngā āhuatanga.

Ko te kupu, ko tenei hōtaka he taputapu mahuinga ia mo te iwi o ngaio katoa e te hopoia hono ki tau, me tau.