Ko te ripanga kei hoki te aha? Ko te tepu i roto i te "Eksele". rorohiko Aunoatanga

Mai te tuku o te hua rawa tuatahi Microsoft i te puka o te rūma tari mārō i roto i te ao nei i teie mahana tetahi o nga taputapu tino ngā, me te tika, he ripakaute. hangaia te rawa taua ripanga te ki whakaoti maha raruraru, a kore noa ki te mahi i ngā mahi pāngarau ohie, rite etahi iwi mahi, pērā i Excel. Ko reira tonu maha take, hei tauira mo te hanga me te whakahaere pātengi raraunga. Whakaae, no te mea Access - tepu hoki te tono. Ko inaianei, mo te whakaaro ki o te kuwaretanga, whakaaro tatou he reira "Excel" ripanga, rite he ratou te noa tino.

Ko te ripanga kei hoki te aha? whakaahuatanga whānui

Ka rite ki te mea faaturahia puna ipurangi, he ripanga te tono tari e taea ki a koe te hanga i te reira te mahi ki reira ranei ranei, ko te tono pūmanawa hangaia e te mo te mahi pāngarau me te tahi atu tātaitanga i runga i te pūtake o ngā huānga e rua-ahu o raraunga.

Ka taea te tāutuhia e te ngā matua i roto i te whakamahi o tenei taumahinga rawa te rota. Heoi, i roto i te take tino whānui, ka taea e tatou te mea e te hangaia te ripanga mō taua take:

• pāngarau, taurangi, me te tahi atu tātaitanga;
• aunoatanga o tukanga tātai;
• te hanganga o ngä tauäkï pütea;
• pāngarau me te tātari hanganga;
• whakatauira pāngarau;
• hōtuhi tātai, me pera i runga i. d.

Ko reira ohie ki te kite e waiwai katoa mai ki raro ki te pāngarau, me ona pärönaki. Ko te nuinga o nga hōtaka e mahi ki raraunga ripa o te moni ki ngā kaiwhakamahi i roto i te wahi tuatahi kia e taea te tono i te aunoatanga o te tātaitanga ki a ratou. I roto i te mau parau te tahi atu, i reira he kahore he take, ngā korero, mo ia wa ki te whakaturia etahi tātai ki te whiwhi i te hua e hiahiatia ana i roto i ngā tukanga ōrite. Na roto i tenei huarahi, te whakamahi o ripakaute, hanga ana e ia nga mea māmā.

Ko te tepu i roto i te "Eksele" tetahi hōtaka rite ranei: whakahaere hanganga

Na whakaaroa te mea ko rānei te tono ripanga Excel-e hāngai ana e he wahi o tetahi huinga tari. e kore e tangohia i ētahi atu hōtaka katoa ki te pūkete no te mea he tata rite ratou whakahaere.

Na he aha i roto i te tepu "Eksele" Ko te ngohi e rua-ahu o te raraunga? Just no te mea i whakamahia tuatahi reira rite rua taunga, ki te whakatata koe i te reira i te wāhi o te tirohanga o te whakahaere o te āhuahanga. E rua ngā āhuatanga matua: he rarangi ripanga me tīwae, ia o nei tohua e tau me pukapuka (i roto i te tahi mau putanga o Excel - tau anake).

Ko te kupu i hanga pūtau ki te wāhitau ahurei (hei tauira, he tohu tuatahi A1). he whakahaere taua ko te akiaki ia ka whakamahi i ngā tātai e kua tomo te hunga i roto i te puka mua e kore, a ki te tohu o tau pūtau me ngā mahi e te tono ki a ratou.

Heoi, kia tuhia te reira e hangaia te ripanga e kore anake ki te mahi ki ngā huānga e rua-ahu. Tino noa, ka taea e koe te tāpiri i fakafekau'aki te tuatoru i roto i te puka o te tau pepa ka hanga ripeka-hononga, e ko, i roto i te tātai ranei i roto i te ako tauanga whakaatu toru hononga. he pai i roto i ngā āhuatanga o te mau herehere ana i roto i nga pūtau o ngā momo rerekē o te raraunga tenei.

I te pae hopea, e nehenehe ia tatou tika te mea, me ki runga ki te pea o te ngohi-ahu wha, rite ina tāuta hononga i roto i te whakamahi i tētahi atu whārangi, tētahi atu hōtaka waho ranei kōnae takitahi ki te pūtau raraunga-herea, kua whakamana tukanga mo ratou ranei.

momo raraunga Pānga

Te mōhiohio tomo i roto i ia pūtau kia whai i te huru tino rerekē. Te reira i katoa tei runga i te aha te huru o te mahi me te meatanga.

Hei tauira, whakaturia he momo tau, no te taea te whakamahi tātai taurangi ato'a rewa, ōrau, ranei momotuhi pūtaiao mō pāngarau noa. Just rite ngāwari, ka taea e koe te whakamahi i te hōputu rā me te wā, ka taea e te tahi mau taime e whai hua momo moni pūtea ranei. I roto i tenei take, ka te raraunga, kua puta aunoa ratou hōputu ki te tāuru e hiahiatia ana.

I te pae hopea, i roto i tetahi mara, ka taea e koe whakaturia te hōputu kuputuhi, i roto i nei whakaaturia ngā mōhiohio katoa i roto i te puka, i whakaurua ki te papapātuhi.

Mā te tātai ohie

ripakaute Rorohiko tuatahi i titiro rite te tikanga pono pāngarau. Na ia kaiwhakamahi te tika nei tīmata ki te mahi ki taua hōtaka, me ako ki te whakamahi i ngā tātai ara ohie.

Ka rite ki kua whakahuatia, kua aroaro ratou i roto i te puka motuhake. Hei tauira, i roto i tetahi mara ko ki te tāuta i te tau tātai hua o ngā pūtau rerekē e kore e taea te tuhituhi noa 2 x 2. hoki tenei whakaaro, me whakapūtā koe te wāhitau taua, i kōrerotia i runga ake. Me kī e whai tatou e rua o nei e kei i roto i ngā pūtau ki taunga A1 me B1 (A me B - tīwae 1 me 2 - nga rarangi ripanga). Ki te tomo i te tātai e whakamahia ana e te mara motuhake i raro i te paeutauta, i ko te tuatahi ki te tohu i te Hōtaka o Mahi aifaito me tohu te wāhitau hiahiatia. Ko te kupu, whakareatanga tahito tātai ko: = A1 * B1, a te aha e tau e tomo i roto i te pūtau kore he, pera nui. Ko te tika te tātai e whakaritea hoki ano i roto i te mara motuhake, i meinga nei hei rerekē i te mua e rua (te kore te hōtaka ka maka noa he hapa).

Mea faahiahia te nui o kanohi. Ka taea e koe te rēhita noa tua (= A1 + B1), engari te whakamahi i te whānuitanga o ngā raraunga tāuru e tango roa rawa. Na te reira māmā ki te whakapūtā reira rite te katoa, kia ara ki te whakamahi o te rōpū motuhake.

Hei tauira, mo te whānui i A1 ki A10 ka tomo tātai A11 ki te mea e taea e mara whakamahi i tēnei kōwhiringa: = SUM (A1: A10) noa ranei ki te pāwhiri i runga i te pātene i runga i te rōpū TapekeAunoa i te whakatakoto i te pūtau formulaic raro i te whakamutunga o te awhe tāuru.

O te akoranga, e kore te anake taua tātai iti, me nga tātai katoa ki te mahino pai ano i roto i te mahi.

Ngā hononga me te whakaaturanga kauwhata o te raraunga

No iti ngā ki te titiro me etahi āhuatanga e pā ana ki te ripeka-tohutoro whakaaturanga, me raraunga. timata tatou ki te tuarua.

Ki te kore e te tangata mohio, i runga i taea te hanga e te pūtake o te tepu pūrongo wāhi, pērā i ngā hoahoa, te whakaputa whaihanga o ngā āhuatanga rerekē ranei tae noa ki te hanga wā-poto me te wā roa-matapae, ahakoa kauwhata me ngā tūtohi e anake te wahi iti o te mea e taea e taua hōtaka.

Cross-tohutoro i roto i te wahi kua oti whakahuatia. E whai wāhi ana ratou i roto i te here o e rua tukanga raraunga i ngā mātāpuna rerekē (ngā pūtau, pepa, me te tahi atu tono, ngā kōnae, ngā hononga Ipurangi, a na i runga i. D.). Here, e kore te mea tino iti te mara o te mahi. Ratau, e kore e ara mōhio o te meka e i roto i te taua Excel taea te ngāwari te waihanga kēmu unpretentious maha kaiwhakamahi. He tauira a Tūrongo, o tenei - "Snake".

mutunga

tonu te reira ki te tāpiri e kore ko tika te ripanga mo te runga ake katoa. ngā hōtaka whai wāhitanga, ratou whakamahi E mea aano, engari ki te whakaahua i te reira katoa, ara i roto i te puka tino poto, e kore e mahi i te pae tino i te hiahia katoa. Na reira, ki te hiahia koe ki te ako ki te mahi ki tepu, me te whakamahi i te mahi i roto i te ki tonu, ka waiho i te reira e tika ana, kia rite ki te mea ratou, i te tai'oi te tuhinga hangarau (te painga o te kōrero whakamārama i roto i te taua Excel māngai i te taumata teitei).