Me pēhea te hanga i tētahi ripanga tātai Excel He tino pukenga mo te tangata e mahi ana me nga raraunga. Ahakoa kei te whakahaere pakihi koe, kei te pupuri i to putea whaiaro, kei te whai ranei i o tikanga whakakorikori tinana, he taputapu kaha a Excel hei awhina i a koe ki te whakariterite me te tātari tika i nga korero. I roto i tenei tuhinga, ka arahi matou ki a koe i roto i nga huarahi ngawari me te taketake ki te hanga i tetahi pepa Excel, mai i te whakatuwheratanga o te kaupapa ki te hanga i to ripanga tuatahi. Ahakoa he tauhou koe, he kaiwhakamahi mohio ranei, kei konei matou hei awhina i a koe kia mohio koe ki tenei waahanga matua o te hua matihiko!
– Step by step ➡️ Me pehea te hanga pepa Excel
- Hipanga 1: Whakatuwheratia a Microsoft Excel i runga i to rorohiko.
- Hipanga 2: Patohia te "Pukamahi Hou" hei hanga tuhinga Excel hou.
- Hipanga 3: Kia tuwhera te pukamahi hou, ka kite koe i tetahi ripanga tuwhera.
- Hipanga 4: Kei raro o te rau, ka kite koe i nga ripa rereke, pawhiria te "Raurangi 1" ki te timata ki te mahi i tera rau.
- Hipanga 5: Inaianei kua rite koe ki te timata ki te whakauru i o raraunga. Ka taea e koe te tuhi kupu, tau me nga tauira ki nga pūtau o te rau Excel.
- Hipanga 6: Hei huri i te whakatakotoranga cell, pawhiria te pūtau, pūtau rānei e hiahia ana koe ki te whakahōputu ka kōwhiri i te kōwhiringa whakahōputu e hiahia ana koe ki te paeutauta.
- Hipanga 7: Mena kei te pirangi koe ki te whakauru haupae, poupou ranei, pawhiria te nama haupae, reta tiwae ranei hei kowhiri i te rarangi katoa, tīwae ranei, ka paato-matau ka kowhiri i te "Whakauru" ki te taapiri i tetahi rarangi hou, tīwae ranei.
- Hipanga 8: Hei tiaki i to pepa Excel, pawhiria te "Kōnae" ka kowhiria "Tiaki Hei." Kōwhiritia te wāhi me te ingoa kōnae, ka pāwhiri "Tiaki."
Ngā Pātai me ngā Whakautu
Me pēhea te hanga i tētahi ripanga tātai Excel
1. Me pehea taku whakatuwhera i te Excel ki taku rorohiko?
Hei whakatuwhera i a Excel ki to rorohiko, whai i enei mahi:
- Pāwhiritia te pātene tīmata kei te kokonga maui o raro o te mata.
- Patohia te "Excel" i roto i te pouaka rapu ka pehi i te Whakauru.
- Patohia te ata Excel ka puta ki nga hua rapu.
2. Me pehea taku tiimata ki te hanga pepa Excel?
Hei timata ki te hanga pepa Excel, mahia enei e whai ake nei:
- Whakatuwheratia a Excel i runga i to rorohiko.
- Patohia te "Pukamahi Hou", "Hou" ranei hei whakatuwhera i tetahi ripanga tuwhera hou.
3. Me pehea taku whakauru rarangi me nga pou ki Excel?
Hei kōkuhu haupae me ngā tīwae ki Excel, whai i ēnei mahi:
- Tīpakohia te haupae, tīwae rānei e hiahia ana koe ki te kōkuhu i tētahi haupae, tīwae hōu rānei.
- Pāwhiri-matau ka kowhiri i te "Whakauru" mai i te tahua taka-iho.
4. Me pehea taku huri i te whakatakotoranga pūtau ki Excel?
Hei huri i te whakahōpututanga o ngā pūtau ki Excel, mahia enei e whai ake nei:
- Tīpakohia ngā pūtau e hiahia ana koe ki te whakahōputu.
- Patohia te ripa »Kainga» kei runga o te mata.
- Kōwhiria ngā kōwhiringa whakahōputu pēnei i te momotuhi, te tae papamuri, ngā taitapa, aha atu.
5. Me pehea taku mahi tatau i Excel?
Hei mahi tatau i Excel, whai i enei mahi:
- Tuhia nga uara e hiahia ana koe ki te tatau ki nga pūtau e rite ana.
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua.
- Tuhia te tātai pāngarau, hei tauira, =SUM(A1:A5) hei tāpiri i ngā uara mai i A1 ki A5.
6. Me pehea taku tiaki i tetahi pepa Excel ki taku rorohiko?
Hei tiaki i tetahi rau Excel ki to rorohiko, whai i enei mahi:
- Patohia te paatene Office kei te kokonga maui o runga o te mata.
- Tīpakohia "Tiaki hei".
- Kōwhiritia te wāhi me te ingoa kōnae, ka pāwhiri "Tiaki."
7. Me pehea taku tuhi pepa Excel?
Hei tā i te pepa Excel, mahia enei e whai ake nei:
- Patohia te paatene Office i te kokonga maui o runga o te mata.
- Tīpakohia "Tā".
- Kōwhiria ngā kōwhiringa tā ka pāwhiri "Print."
8. Me pehea taku whakamahi i nga tauira i Excel?
Hei whakamahi tātai i Excel, whai i enei mahi:
- Tīpakohia te pūtau e hiahia ana koe kia puta te hua.
- Patohia te tohu rite (=) ka whai i te tauira pangarau, hei tauira, =SUM(A1:A5) hei taapiri i nga uara mai i te A1 ki te A5.
9. Me pehea taku whakauru tūtohi ki Excel?
Hei kōkuhu tūtohi ki Excel, mahia enei e whai ake nei:
- Tīpakohia te raraunga e hiahia ana koe ki te tāpiri ki te tūtohi.
- Patohia te ripa "Whakauru" kei te tihi o te mata.
- Kōwhiria te momo tūtohi e hiahia ana koe ka whakarite kia rite ki o hiahia.
10. Me pehea taku tiaki i tetahi pepa Excel me te kupuhipa?
Hei tiaki i tetahi rau Excel me te kupuhipa, whai i enei mahi:
- Patohia te ripa "Arotake" kei te tihi o te mata.
- Tīpakohia "Tiaki Pepa" ka tautuhi i te kupuhipa uru.
- Whakaūhia te kupuhipa ka paato "OK."
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.