Kōmaka i roto i Excel. Te mahi i roto i Excel. tauira Excel

he mahuinga ki te mahi ki tau, me nga tepu pūmanawa Microsoft Excel. āhei te reira ki a koutou kia ngāwari tātaitanga matatini, te utu kauwhata me ngā tūtohi. Te mahi ki te papa e whai he tirohanga rārangi, ka taea Microsoft Excel ki a koutou te tīpako i te uara e hiahiatia ana, ka kōmaka tīwae. Ka taea te kōmaka te raraunga i roto i te e piki kia heke ranei rite ki nga uara e kua kei roto i te pūtau. Ka taea te mahi te taua whawhe ki te rauemi kuputuhi, ka kia tū reira rānei i te ana'iraa piapa ranei i roto i te pū whakamuri. hiahiatia Kōmaka i roto i Excel te ki te whakarite i wātea ki te tirohanga me te ngāwari ki te pānui i te kōrero.

Te hanga koutou ake raupapa ahua

I te tahi taime e ara taua āhuatanga, ina e hiahia ana koe ki te kōmaka te raraunga i roto i te raupapa e he rerekē i te hunga tīariari. I roto i tenei take, ka taea e koe te hanga i tou ake tikanga, e hiahiatia ana e te mo te mahi atu.

Hei waihanga i tētahi raupapa ritenga, e hiahia ana koe ki te haere ki te ripa "Utauta", ka kōwhiri i "Ngā Kōwhiringa." He te te tahua o "pae", te wahi i te taha i mahue o te matapihi kei ngā rārangi ngā whakamahia mō te kōmaka. "Rārangi New", tīpako i te kōwhiringa ki te waihanga i tō ake kia. Katoa o te "Rārangi tūemi" uara e tika ana, me ngā tawhā me whakaturia i roto i te mara.

E wehea uara tāuru te whakamahi i te "E tomo" kī. Ki te tomo i te raraunga katoa e hiahia ana koe i roto i te tikanga, kia rite ki nei te heke mai ka kia rārangi kōmaka. A, no te whakaturia e uara katoa, pēhi i te pātene "Tāpiri". Hei kawemai i te rārangi e te pato kua runga i te papamahi, kia koutou te whakamahi i te kōwhiringa "Kawemai he rārangi o nga pūtau," ka mea etahi wāhitau pūtau. Ko taea te mahi i te reira anake, no te kei o te rārangi i ngā tūemi i roto i te raupapa, e hiahiatia ana e te mo te kōmaka atu uara. I te mutunga e hiahia ana koe ki te pāwhiri i runga i "Kawemai."

Na te reira ngāwari ki te whakarite mōhiohio, ki te mahi i roto i Excel i whakamarie. Ki te mahi i tenei, haere ki te "Raraunga" tahua, me te ka tīpako i te ripa "Kōmaka". I roto i te "Kōmaka i ..." kia whakaturia tawhā tauwhāiti, a pēhi i te pātene hāngai. I runga i te mata puta te matapihi "Kōmaka Kōwhiringa", te wahi whakapūtā koe te raupapa ahua o nga raraunga.

I muri i taua kia whiriwhiri koe i tou ake kia ahua, me te whakaū i tō kōwhiringa mā te pēhi i OK.

I roto i te Kua tikanga ki te kōmaka i Excel kua kawea i roto i, e hiahia ana koe ki te tuu i te pehu i roto i te pūtau ngā, ka pāwhiri i runga i te pātene e rite ana ki te ahua i roto i te e piki heke raupapa ranei. E tū ratou i runga i te paeutauta.

Kōmaka i te ingoa me te utu

E mea pinepine i te hinonga i reira ko te āhuatanga, ina e hiahia ana koe ki te kōmaka te raraunga rite ki nga ingoa whakamutunga o ngā kaimahi. Ko watea i roto i taua raraunga e pā ana ki te kaimahi ngā tenei, ka waiho i roto i te raina kotahi.

Hoki mārama, kōmaka te mōhiohio e kore anake e ingoa, engari i runga i te nui o te utu rānei. I roto i tenei take, e kore e taea te mahi i te tahi mau pātene ahua. Ki te hiahia koe i tenei ahua o raraunga, whakarato Excel te putanga e whai ake nei:

• Me koe ki te whakahohe i te whakahau "Raraunga", me te ka "Kōmaka".
• I roto i te matapihi whakatuwheratia "Range kōmaka" me tīpako koe "Kōmaka i ..." ka whakapūtā he tīwae ngā. Na kia neke koe i te atatohu ki te tūranga e hiahiatia ana: e haere ake te heke te raupapa ranei.

kawea hoki te mara tuarua i roto i analogously ki kōmaka. Ka kōmaka te hōtaka te ingoa o anake te hunga kaimahi e whai i te taua utu.

Ki te he te tino nui te mōhiohio, ka taea e koe te hanga i tou ake rārangi ki te whakarite i tō raraunga. Te reira e tauturu te karo hapa ina mahi ki te rauemi, haunga ka waiho reira māmā ki te hapai i.

Kōmaka pūrārangi

Hei kōmaka te mōhiohio i roto i te ana'iraa piapa, me haere koe ki te "Raraunga" tahua. I mua i-hiahia ki te tīpako i te tīwae ki i te mahi, ko te ki te kia tono. Ka nga raraunga e kōmaka mā te pēhi i te icon "A ki te Z", ranei hurihia. I muri i taua, whakaatu te mata he matapihi e kei te uiraa: "? E Me ahau ki whakawhānui aunoa i te whānuitanga o ngā raraunga" E mea titauhia ia farii i me te pēhi "Tiaki". E kore e te tuhinga katoa ngaro tona tikanga, a ka hāngai te toenga o nga pou raraunga ki te huringa.

Ka taea te mahi Kōmaka i Excel i ara i tetahi atu. Te tīpako i te pūtau ngā, e hiahia ana koe ki te pāwhiri i runga i te icon. Otiia i roto i tenei take i te pātai o te roha o te awhe e kore e puta, E faarahi te reira aunoa.

taumata-Maha kōmaka

A, no te mahi ki tuhinga, a kia rapu i te taumata-maha kōmaka i Excel. Hei whakamahi i tēnei āhuatanga, e hiahia ana koe ki te tīpako i tētahi pūtau i roto i te rārangi, me te pāwhiri i runga i te kōwhiringa "Kōmaka" i raro i reira. E kotahi taumata ki kia, a he mea e taea ki te whiriwhiri i tetahi, pērā i te taha o te rā. Ki te mahi i tenei, pāwhiritia te "Tāpiri apa". Hoki te haratau o te taea ki te mahi i roto i te taumata o te rārangi kōmaka e kaupapa.

Ki te tika, kei te neke ake ki raro ranei i te taumata, e taui to ratou matua. Ki te mahi i tenei, tīpako i te taumata, me te pāwhiri i runga i te icon pere. Ano, taumata ngāwari tārua mukua ranei.

Tātai i roto i te Microsoft Excel

Tātai i roto i te Excel , he faaiteraa e tīmata ki "ōrite" tohu, tito o uara ā-tau, wāhitau pūtau, ingoa ranei mahi. E hono katoa o ratou ki tohu o ngā mahi tātai: whakareatanga, wehenga, tangohanga, ranei mana rea.

Operation i roto i te tātai wehea rite ki ngā whāinga matua:

• Te faaiteraa i roto i te taiapa, me te mana rea.
• Division me te whakarea.
• Subtraction me te tua.

whakaatu te pūtau te hua anake, engari kei te tātai ake kei roto i te pae tātai. Ki te huri koe ke te hua mutunga kei te aunoa.

Me pēhea te ki te hanga i te huringa i roto i te tātai?

Ki te kahore he he hiahia ki te huri i te tātai, e hiahia ana koe ki te pāwhiri i roto i te pae tātai ranei pēhi i te F2 pātene. I muri i nga whakarerekētanga katoa e tika ana ki te pēhi «E tomo» tāuru ranei icon i roto i te rarangi. taea hoki te tono tika Huringa i roto i te pūtau. Ki tenei mutunga, kia pāwhiri te wāhi tīpakohia rua.

tohutoro pūtau me te kaupapa o te tātai

Ako ki Excel, i roto i te tauira, ka taea e maha kite koe hononga. Mā te hononga e āhei ki te whakamahi i ngā raraunga i roto i te kerēme e te hunga i roto i ngā wāhi rerekē o te pepa. Pea ki te whakamahi i ngā tohutoro pūtau, kei roto i ētahi atu pukamahi taupānga ranei.

I muri tomo i te pūtau tona tātai e taea te whakawhiti tārua ki tētahi atu tauwāhi ranei. I roto i tenei pūtau, i tū riro free tātai. Te huri i nga hononga whanaunga anake, me te hope tonu tamau.

Hei nuku i te tātai, tuu i te pehu i te kokonga o te pūtau ki te whakaatu i te pere rua-taha. Kati iho te pātene kiore, ka taea e toia koe i te reira ki te wāhi e hiahiatia ana.