Mena kei te rapu koe i tetahi huarahi ngawari me te tere ki te tatau tau toharite i Excel, kua tae mai koe ki te wahi tika. I roto i tenei tuhinga, ka whakaatu atu matou ki a koe me pehea te hanga pāpāho ki Excel i te huarahi ngawari me te whai hua. Ahakoa e hiahia ana koe ki te tatau i te toharite o te rarangi tau, te awhe motuhake ranei i runga i to ripanga, ma matou koe e arahi i ia taahiraa kia mohio koe ki tenei taputapu whai hua. Ahakoa he tauhou koe ki a Excel, kua mohio ranei koe, ka awhina tenei aratohu ki a koe ki te mahi i nga tatauranga tere me te tika.
– Ma te hikoi ➡️Me pehea te hanga pāpāho ki Excel
Me pehea te hanga pāpāho i Excel
- Whakatuwheratia a Microsoft Excel i runga i tō rorohiko.
- Tīpakohia te pūtau kei hea koe e hiahia ana kia puta te hua toharite.
- Tuhia te tātai "=AVERAGE(" ka whai i nga pūtau e hiahia ana koe ki te tauwaenga. Hei tauira, "=AVERAGE(A1:A10)" ka tauwaenga nga pūtau mai i A1 ki A10.
- Pēhi Tomo ki te tiki i te toharite o nga nga pūtau kua tohua.
- Tirohia te hua me te whakarite kia tika.
- tiakina to kōnae kia kore ai e ngaro nga huringa kua mahia.
Ngā Pātai me ngā Whakautu
Me pēhea te hanga tātai toharite ki Excel?
- Tīmatahia te Excel ka whakatuwhera i te konae e hiahia ana koe ki te mahi.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua toharite.
- Tuhituhi =TOHARITE(
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te toharite.
- Katia te reu ka pehi i te Enter.
Me pehea te tatau i te toharite taumaha i Excel?
- Whakatuwherahia to konae Excel ka kowhiri i te pūtau e hiahia ana koe kia puta te hua toharite taumaha.
- Ka tuhi =TAITAIRANGA(
- Tīpakohia te awhe o uara ka tautapa e koe he taimaha.
- Patohia te Enter kia whiwhi i te hua.
Me pehea te whakamahi i te mahi MEDIAN i Excel?
- Whakatuwherahia to ripanga ki Excel.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua waenga.
- Ka tuhituhi =MEDIAN(
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te tiki tauwaenga.
- Patohia te Enter kia whiwhi i te hua.
Me pehea te hanga toharite neke i roto i te Excel?
- Whakatuwherahia to konae Excel ka kowhiri i te pūtau e hiahia ana koe kia puta te hua toharite neke.
- Tuhia =WAWAREHETANGA NUI (
- Tīpakohia te awhe raraunga e hiahia ana koe ki te tatau i te toharite neke.
- Tauwhāitihia te maha o ngā wā e hiahia ana koe ki te whakauru ki te tātaitanga.
- Pēhia te pātene Enter hei tiki i te hua.
Me pehea te whakamahi i te mahi FASHIONi Excel?
- Whakatuwherahia to ripanga ki Excel.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua ahua.
- Ka tuhituhi =MODE.MULT(
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te tiki aratau.
- Patohia te Enter kia whiwhi i te hua.
Me pehea te tatau awhe i Excel?
- Whakatuwherahia to ripanga ki Excel.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua awhe.
- Ka tuhituhi = MAX (
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te tiki i te awhe.
- Tangohia te hua o te mahi MAX mai i te hua o te mahi MIN ki te tiki i te awhe.
Me pehea te hanga toharite ki Excel me nga tikanga?
- Whakatuwherahia to konae Excel ka kowhiri i te pūtau e hiahia ana koe kia puta te hua toharite herenga.
- Tuhia =AVERAGE.IF(
- Tīpakohia te awhe o ngā pūtau ka arotakehia e te paearu.
- Tuhia nga paearu ki nga korukī rua.
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te tātai i te toharite.
Me pehea te kimi te tikanga tatau i Excel?
- Whakatuwherahia to ripanga ki Excel.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua o te tikanga tatau.
- Ka tuhituhi =TOHARITE(
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te whiwhi i te tikanga tātai.
- Patohia te Enter kia whiwhi i te hua.
Me pehea te hanga i te toharite me nga ōrau i roto i te Excel?
- Whakatuwherahia to ripanga ki Excel.
- Tīpakohia te pūtau e hiahia ana koe kia puta te ōrau toharite.
- Ka tuhituhi =TOHARITE(
- Tīpakohia te awhe o ngā pūtau kei roto ngā ōrau.
- Pēhia Enter ki te tiki i te hua o te toharite o nga ōrau.
Me pehea te tatau i te tikanga geometric i Excel?
- Whakatuwheratia to kōnae Excel.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua o te tikanga āhuahanga.
- Ka tuhituhi =GEOMETRICAVERAGE(
- Tīpakohia te awhe o ngā pūtau e hiahia ana koe ki te tiki i te toharite āhuahanga.
- Patohia te Enter kia whiwhi i te hua.
Ko Sebastián Vidal ahau, he miihini rorohiko e ngakau nui ana ki te hangarau me te DIY. I tua atu, ko ahau te kaihanga o tecnobits.com, kei reira ahau e tohatoha ai i nga akoranga kia pai ake ai te uru me te maarama ki te katoa.