Electronic Excel ripanga - he taputapu whai hua mo te tātari o te raraunga

Ko te puka ripa whakamahia ki te tohu ngā mōhiohio i roto i te puka whānui, te tikanga mo te muri tātaritanga raraunga. Ka taea e ripakaute Excel whakaaunoa te tukanga o te whakahaere rorohiko me raraunga, kauwhata tohu te tātari mōhiohio.

A, no te rere te hōtaka pukamahi kau whakaaturia i runga i te mata, i te mea he huinga o pepa e toru (te taunoa), i runga i ia o te mea reira he tepu. E taua rarangi Ripanga i te 1, me nga pou whakaritea i roto i reta Latin, tīmata ki te A. I roto i te katoa whārangi 65 whakanohoia ki runga i nga mano o nga rarangi, me mo 250 tīwae. ngā tepu Electronic Excel o ngā pūtau whakahuatia momo A1, te wahi A - tīwae ti'araa, 1 - raina ti'araa. Ka taea hoki te tīpako i tētahi poraka o ngā pūtau. Hei tauira, A1: C4 ti'araa tohu te huinga o ngā pūtau no ki te rohe tapawhā, e A1 koki maitai pūtau me C4.

pūāhua whakahōputu i roto i te pūtau, ko te tino rite ki te pūtukatuka kupu, anake i roto i Excel ngā tawhā iti e taea te huri. Ka taea te whakamana whawhe katoa o nga pūtau mā te whakamahi i te kōrero "Pūtau Hōputu."

Ka rite ki te tikanga, i muri i te tukatuka raraunga ko reira e tika ana ki te whakaatu i te hua i roto i te puka kauwhata. He whai wāhitanga fe'unga mo tenei i roto i Excel. kauwhata Bar, ngā tūtohi, wāhi me ngā tūtohi porowhita. whakamahia ia o ratou i roto i etahi wā. Ki te hiahia koe ki te whakaatu kauwhata te hononga o te huinga raraunga e rua, ka taea e koe te whakamahi i te kauwhata ranei te tūtohi marara. Ki te hiahia koe ki te whakaatu wāhanga o te katoa, ka taea e tatou te hanga i te porowhita tōnati ranei tūtohi. I roto i te take whakamutunga, mo te haratau o mahara ki te hoahoa, ko te reira e minaminatia ki te tango i te maha o ngā uara i roto i te whānuitanga 5-6.

kia kia Kei te pūtau i roto i te raraunga taketake rite kuputuhi, tau (tau tōpu, hautau, Ōrau, etc), me te tātai. haamata Tetahi tātai ki te tohu "=" me kei roto i te pūtau tepu momotuhi, tohu o ngā mahi tauhanga me mahi paerewa. E 10 ngā kāwai o ngā mahi hōtaka Microsoft Excel: pūtea, te rā me te wā, pāngarau, tatauranga , me ētahi atu. meatia tenei e mo te haratau o ratou rārangi, i roto i nei e whakaritea nga mahi katoa i roto i te ana'iraa piapa (tuatahi i roto i te reo Ingarihi, me te ka i roto i Russian).

whai hoki ripakaute Excel te āheinga o kōmaka me raraunga tātari. Ki te kawea koutou ki te tepu i te rārangi roa, ka taea e te reira rawa ngāwari ki te mahi tahi me, ki te whakarite rarangi i roto i te piki ake te heke te raupapa ranei. Ano, kia kia whakamana te kōmaka i tetahi tīwae noa ake ranei. Ko te tātari āhei ki te tīpako etahi rarangi o te pūtake (huru). Hei tauira, ka taea e whakaatu i te reira i runga i te mata, anake te hunga uara e he nui ake i te kore.

A, no te he putanga ki te ripakaute tā Excel taea ngāwari whakarite ki tetahi whārangi rahi, te whakanui ake whakaiti i tauine ranei. Na roto i te taunoa, e kore e nga rohe tepu kitea ina tā koutou, na ki te hiahia koe ki te, ka taea e koe te whakaatu tukutuku i roto i te kōrero "Pūtau Hōputu" (te "Taitapa").

Microsoft Excel ngā 2010 hōtaka i roto i MicrosoftOffice 2010 mōkihi e ngā tetahi tatini o ētahi atu taupānga whai hua. i enei hōtaka katoa he atanga rite e ohie te tukanga whanaketanga o te kaiwhakamahi.