Me pēhea te ki te tātai i te pakiaka tapawha i roto i Excel?

pūmanawa Microsoft Excel kua he whānui o ngā mahi pāngarau e tukua ki a koe te whakaoti ngā mahi matatini ngā. Ko te tino ngāwari ki te mahi, mā te whakamahi i ngā pūāhua motuhake - He maha o ngā mahi ohie - tua, whakarea, me ētahi atu. Heoi, i reira e te hunga e rapu utu whakaahuatanga motuhake - na, mohio kore katoa e founga ki te tātai i te pakiaka tapawha i roto i Excel.

He aha te mea te pakiaka o te tapawha?

I mua i te timatanga o te tukanga ako, me pehea ki te kitea te pakiaka tapawha ki Excel, kia whiwhi maheni ki te meka e ko te mahi pāngarau tenei. Na roto i te auraa, te pakiaka tapawha o te tau - ko te maha nei tapawha ōrite te tau he. I roto i te pūtaiao pāngarau taea te kite pakiaka tapawha kore anake. Ratou mai ano i roto i tetahi atu tohu, na te maha tuku te pakiaka tapawha ki rite te pakiaka o te tohu tuarua.

mahi pakiaka

I roto i whakaoti i te raruraru e pā ana ki te kimi i te tapawha pakiaka "Eksele" te tiki i te hua e hiahiatia ana i roto i te maha ngā huarahi. Taumahinga o te hōtaka e āhei e rua ki te whakamahi i te hātepe hanga-hanga, me te tuhituhi i te reira koe, te whakamahi i theorems motuhake me ngā āhuatanga o te pakiaka. Ko te huarahi māmā ki te kitea te whakahoki ko te mahi pakiaka tapawha. I roto i te Excel, taea te uru atu i te reira na roto i te te whakatuwhera i te tahua kōwhiringa ranei e tuhituhia ā.

Ko te tino māmā te wetereo - i muri i te tauwhāiti i te whakamahi o tetahi o nga mahi (rite tohu) he tika ki te rēhita i te kupu matua "pakiaka", e tohu ana i te karanga te whakahau e tika ana. Ka kia tuhituhia muri i roto i taiapa tāupe i nei e hiahia ana koe ki te tango i te pakiaka tapawha. I roto i te Excel hei tautohe o te mahi e taea te whakamahi i te reira hei uara mārama tau me te tohutoro ki te pūtau, me te faaiteraa pāngarau e aro mātai ana ki te tau.

Mā te āhuatanga pāngarau

Te pakiaka tapawha i Excel, ka taea e koe te tātai i te maha o te tahi atu tikanga e kore e e rapua e te matauranga hohonu i roto i te pūtaiao pāngarau. He mea nui ki te mohio he aha te mea pakiaka - i pa tenei kaupapa ki runga ki i roto i te wāhanga tuatahi o te tuhinga. Mā te whakamahi i te whakamāramatanga o te pakiaka tapawha, e taea te faaite i te reira rite te mana tauutuutu o tau e hiahiatia e rua. Na, te tiki i te pakiaka tapawha, kahore te whakamahi i te "pakiaka" taea te ara noa te tau ki te mana.

Ka taea te mahi hoki tenei i roto i ara e rua. Ko te tuatahi ko te ki te whakamahi i te tahi atu mahi - "atamira". faateitei te reira i te maha i āta tohua te hua o te faaiteraa pāngarau i roto i te tohu tīpakohia ranei. I roto i tenei take, i roto i te "tohu" tohu i te maha o 1/2 0.5 ranei. Whakaara tetahi tau ki tetahi whānuitanga taea, me kahore te whakamahi o tetahi āhuatanga - "Eksele" ko te pūāhua motuhake i roto i te tiaki o tenei mahi: "^". I roto i tenei take, ki te tiki i te pakiaka tapawha, ranea ki te faaoti whakapuaki i roto i te ', aru mā te tāpiri "(1/2) ^" ranei "* (0.5)." Ko te hua o tenei mahi ka kia rite ki te hanga o te kaha ki te mahi, me te whakamahi o te "pakiaka" mahi.

Me kï reira e te tikanga o te imiraa i te pakiaka mana rea ko atu whakamarie. Ko te take hoki tenei ko te meka e ki te awhina o enei ngā mahi, ka taea e te tiki e koe tetahi pakiaka, kahore tono tetahi tātai motuhake atu.

tauira

Ki te pae hopea mahi ki te pehea, ki te tātai i te pakiaka tapawhā ki Excel, kia whakaaro koutou o tauira mo nga tikanga e rua whakaahuatia ana i runga i te tokorua.

I roto i te take tuatahi whakamahi tatou te āhuatanga "pakiaka", e karanga ana i te reira na roto i te te whakamahi i te pātene "Kōkuhu Taumahi". I roto i te matapihi e ka whakapūtā te raraunga mo te tātai, pērā i te rerekētanga i waenganui i te uara o ngā pūtau e rua, a ka pāwhiri "OK".

I roto i te take tuarua, mā te whakamahi i te putanga tangata-pānui, ki te faaueraa mārama o te kaha o, te kīanga e whai ake nei mō te te kimi i te pakiaka tapawha o te tau, mo te tauira 9:

Ka te hua o tenei mahi kia whakatakotoria ki "3".