Me pehea te tatau i te pakiaka i Excel?

Kei a Microsoft Excel he huinga maha o nga mahi. Ma tana awhina, ka taea e koe te whakamahi i nga tatauranga pangarau maha. Heoi, ki te mea he tino marama te kaupapa o te mahi me nga mahi tinowari, me pehea te tatau i te pakiaka i roto i te "Excel", kaore i te mohio.

Ko te mahi "pakiaka"

Ara ki te tātai i te pakiaka tapawha i roto i te "Eksele" he torutoru, a te watea tino o ratou - te whakamahi i te mahi motuhake o "pakiaka", whakatinana i roto i te hōtaka. Ki te karanga ki a koe, me tuhi koe i te raupapa i roto i te pūtau, i te raupapa ture ranei, ka pa ranei i te paatu "Whakauru mahi".

Mena ka tīpako koe i te tikanga tuatahi i roto i te pūtau, me tuhi "= ROOT (X)", kei hea "X" me whakapumautia he tau, he pūtau rānei e whai hua ana, ka kitea te pakiaka. I te piti o nga keehi, i muri i te patatau i te paatu "Whakauru Mahi", me tuhi koe i te "pakiaka" i roto i te mara rapu me te whiriwhiri i te mahi kua whakaritea. I muri i tera, ka whakatuwheratia he matapihi, kei te whakaarohia kia tuhia i te ringaringa te tau, ka whiriwhiri ranei i te waea i reira te tau e hiahiatia ana.

Pato matatiki

Heoi, i te wa e mahi ai te mahi ki te tautuhi i te pakiaka i Excel, kaore i te waahi noa. Hei tautuhi i te pakiaka o tetahi tohu, me whakamahi koe i tetahi atu huarahi - te whakamahi i te tikanga taapiri o te pakiaka. Ma te tautuhi, ko te uara o te pakiaka o te kaha o te nth ko te tau e kaha ake ki te kaha o n ki te tiki i te kupu i raro i te pakiaka.

Ko te tikanga, kia whiwhi ai i te uara o te pakiaka o te kaha-n-nui, he nui ki te whakanui i te tau ki te tohu rererangi - 1 / n. Hei tautuhi i te pakiaka i roto i Excel i tenei ara, ka taea hoki e koe te whakamahi i tetahi o nga otinga otinga ka taea. Ko te tuatahi ko te whakamahi i te mahi, ko te tuarua ko te tohu tohu i te mahi.

Na te patene i te pātene "Whakauru mahi", he mea tika ki te tuhi i te rarangi rapu "tohu" me te whiriwhiri i te mahi tika. I roto i te matapihi tuwhera ka rua nga waahi - i te tuatahi ka hiahia koe ki te tautuhi i te tau, me te tuarua - te tohu e hiahiatia ana kia hangaia. Hei whakapūtā he mārama mana rea kia whakamahi i te "^" huru, aru e te tohu. He mea pai kia mohiohia i roto i te keehi o te mana whakaheke he mea tika kia whakauruhia ki roto i nga tohu kia whiwhi ai i te hua tika. Ko te kupu, ki te whakatatau te pakiaka tapawha ki te kia tuhia hanganga o te puka: x ^ (1/2).