Functions i roto i Excel: he aha e whakamahia ratou?

Me kï reira e he taumahinga nui, ara te wahi iti o e pai-mohiotia hōtaka Excel maha toe "i muri i nga scenes". Ko rawa pono o te mahi tari rā, he tokomaha o nga ngā mahi e taea te aunoa tenei. I roto i te taiao kaiwhakamahi ngaio ko āhuatanga tino rongonui ki Excel, ki e taea ara e koe te hanga i tou ake tātai. Heoi, he aha te mea katoa e pā ana ki?

Ko te take i huaina te āhuatanga i roto i tenei tono e whakahau kuputuhi ohie e kua tikanga e te rorohiko, tuku ara nga tātai pāngarau tino matatini. No te tauturu matau koe, hoatu i te tauira oraora. Meatia whakaaro koutou e tohu i te mahi i roto i Excel rite tenei: "= AVERAGE (A1: A5)"? Ki te kīa nei koe i te whakarāpopototanga i te timatanga, i roto i te whakamāoritanga Russian o tenei ko "te uara toharite o te awhe o ngā pūtau A1 ki A5 urutomo." Ko te tohu ":" E kore te whakaritea wehewehenga me te whānui.

Me mea e ahau e ki te tomo ā e kore e te tau wāhi kia tikanga, mai i to ratou tohatoha o te kiore te hōtaka te kī maui ki to ratou pouaka tātai tāuru ano whakakapi. Ko te taea o te taua tātaitanga i roto i Excel taputapu kaha ki te kawe i ngā mahi pāngarau matatini mā te hono tepu ki tetahi pūnaha pāhekoheko.

Me pēhea te ki te tomo i te reira?

Ka rite ki kia tīmata ngā mahi o te tātai ki te "=" tohu i roto i te rārangi tāuru. aru ana tēnei e te whakarāpopototanga o te whakapuaki, i muri i tenei i hoatu e te taiapa e (rite i roto i te tauira i runga ake). Roto He tohenga ko te whakaaturanga kauwhata o te uara e whakamahia ana i roto i te tātai. Ka rite ki taua, e taea te whakamahi mahi i roto i Excel kore anake pūtau takitahi, engari ano hoki ki te uara kotahi, me te he raupapa katoa o tohutoro pūtau. Ko te kupu, ko te kupu "= SUM (12: 24)" Ka hoatu e koe te hua "36", i te pūnaha rite "= SUM (A12: A24)" ka hoatu te moni o nga tau e te hunga i roto i te awhe i tohua.

mahi tauroto

Ka rite ki ta matou i kua mea, Ko na kaha tenei taputapu e taea ai te reira ki te whakaoti tae noa whārite rawa matatini. Hoki tenei Excel (te uara o ngā mahi e taea e tino rerekē) whakamahi i roto i ngā pūnaha matatini atu kīanga. Ki te hanga mārama reira, hoatu tatou he tauira mahi: "= SUM (A5: A10: AVERAGE (B7: C10))." Kia mahara e te kōhanga whitu tautoko. O te akoranga, ka taea e koe te tomo me te ake tautohe, engari kua whakapono reira e kia haere ka faaiteraa.

Heoi, kei te mahi i te tohunga Microsoft tonu ki te whakapai ake o ratou hua, na reira ko te tupono e ka hohoro mahino te hōtaka me ngā kīanga matatini atu.

"E te Kaiwhakaako"

Hoki ngā kaiwhakamahi tauhou whakaratohia te "Ruānuku Taumahi", e nui whakahaere ratou whakatū. Ka taea e koe te whakamahi i te reira i roto i ara e rua:

• Kimihia te ripa "Kōkuhu" ka tīpako reira te tūemi "mahi";
• Ka taea e koe te whakaiti i te wā ki te kitea i runga i te paeutauta pātene "Pānga Kōkuhu".

Ka rite ki ta matou i kua mea, ki te whakamahi i ripanga ētita i Microsoft taea hoki e ngā ākonga, rite taea reira ki a koutou te tātai me te ake "akiaki" tauira. Ko te kupu, ko te kauwhata i roto i ngā mahi Excel e whakarato otinga kauwhata watea, me te pūmanawa ki ngā raruraru o te momo «y = f (x), he wāhanga [he, b]. Hipanga h = 0,1 ». Tenei ka whakahaere nui te tukanga akoranga.