Rorohiko, Pūmanawa
Me pēhea te ki te hanga i te whakareatanga i roto i Excel
ripanga mano "Microsoft Excel" ngāwari e tini i tetahi o koutou tau me awhe. A, no te taea e te reira i tino āwhina i roto i tenei whakaaro? He maha rongoā:
- e kore te mea he tātaitai te ringa.
- Tini awhe nui o tau, a ka hiahia koe ki te kite i te aha e whai wāhi ahua o tau, a pea noa ki te whakakapi i etahi o ratou (i roto i te mahi tātaitai paerewa waho te hiahia ki te tīmata anō te rārangi whakaora i te tātaitanga).
- Whakareatanga - wāhanga anake o te hiato o te tātai.
Ka rite ki a koutou e taea te kite, te whakarea ki Excel - mea e kore e tino hira. Te kore whakareatanga kore e taea te mahi i ngā mahi tata kahore tetahi tātai.
Rerekē whakanuia i roto i "Excel"
"Excel" taea koe ki te tini tahi i te tahi:
- tau motuhake (pai, tōraro, tau tōpū, hautanga).
- Ko nga tau o enei pūtau.
- Awhe o tau.
- uara boolean
Me pēhea te ki te mahi i whakareatanga? Ko te tātai o te whakarea i roto i Excel haamata ki te "ōrite" tohu (=). Ka rite ki i roto i tetahi ake nei tātai tohu tetahi i muri i tetahi tau (ranei pūtau tohutoro kei roto ratou) hono tohu "whetu" (*). e waiho he tātai pērā i whai: "= 0.22 * 16 -5 *" (ka whakanuia tau motuhake) ranei «= G4 * i5» (rite tohenga ka te tohutoro pūtau tohua). Ko te putanga tuatahi o te whakareatanga tenei.
Ka taea te tuhia whakareatanga tātai i roto i Excel te whakamahi i te "hanga" mahi hanga-i roto i:
ingoa taumahi | tohenga | whakaahuatanga |
hanga | Tau / ngā 1; Tau / ngā 2; ... Tau / ngā 255; | Ko te hua o te mahi - te hua o ngā tohenga. Tapeke 255 kia kia whakamahia ki tau motuhake awhe ranei (rahi o te awhe kore e iti). |
Ko te painga o te whakamahi i tenei mahi ko te reira ki te mahi i te whakarea ki Excel - te taea o whakanuia e ia atu, e kore e tau anake, engari ano hoki ropu.
whakaaro tatou inaianei nga tauira motuhake.
Whakareatanga e te "whetū"
Whakamātauria i runga i te pepamahi o te pukapuka "Excel" whai enei tauira:
uara 1 | uara 2 | tātai | hua | |
He | B | C | D | |
2 | 2 | 3 | = A2 * B2 | 6 |
3 | 0.7 | -6 | = A3 * B3 | -4,2 |
4 | PARAU | PARAU | = A4 * B4 | 1 |
5 | PARAU | FALSE | = A5 * B5 | 0 |
6 | FALSE | FALSE | = A6 * B6 | 0 |
Ki te a ratou, ka kite koutou i taua hanga te whakareatanga i roto i Excel he ngāwari. Kia mōhio e te hua o nga uara arorau whakareatanga hei 0 (teka) ranei 1 (pono).
Ko te drawback anake o tenei tikanga o te whakareatanga - e whānui o ngā tau rite ki te tautohe, e kore ia e taea te whakaae. Pea te mōrahi, i te mea nui o tetahi kaiwhakamahi tautuhia vahi i te mutunga o te tuarua tekau tau pūtau ranei, nekehanga, me Ororongo i roto i pūāhua kia "whetūriki."
Ko te ara anake huri noa tenei drawback ko ki te whakamahi i "hanga" mahi.
Whakarea te whakamahi i "hanga" mahi
Fakakaukau ki he founga ki te mahi i whakarea i roto i Excel te whakamahi i te mahi hanga-i roto i.
Ko te pukamahi "Excel" ki te hanga i tētahi paraharaha rite, me te tirohia i runga i ona tauira. I roto i te kotahi tīwae hanga uara maha i roto i tetahi atu tīwae hanga ano hoki e rave rahi tikanga. Whakamātauria ki te tono i te mahi "hanga" koutou here, ka mahi whakarea i ringa i roto i te tohu "whetu".
H | ahau | J | K | |
Range 1 | awhe 2 | hua | tātai | |
12 | 2 | 6 | 9,378,270.72 | Kua Hua = (H12: H16: I12: I16) |
13 | 7 | 14.2 | 9,378,270.72 | Kua Hua = (H12: I16) |
14 | 5 | -2,7 | 9,378,270.72 | = H12 * H13 * H14 * H15 * H16 * I12 * I13 * I14 * I15 * I16 |
15 | 0,26 | 4 | ||
16 | -10 | 56 |
I roto i te tīwae "Tātai" o tenei tepu mārama whakaatu e te mea e tata nga awhe uara, taea te whakamahi ratou rite te awhe. Ano i runga i te tepu e taea kite koe e ki te mahi "hanga" tini katoa o enei awhe, ka tiki i te hua te ara ano, me te mea i matou i runga i tetahi ringa e whakamahatia te uara o enei pūtau. Ka rite ki a koutou e taea te kite, te whakarea ki Excel - ko te putunga.
meka Interesting! Whakamātauria te nekehia atu inaianei kotahi uara i tetahi pūtau, wahi o te awhe, ka kia tino kau pūtau kau. Ka kite koe i e hanga i te wa ano i te mahi ki te mahi i te tātai, te tuku i noa te pūtau kau. Na ko konei te hua o "ā-ringa" whakarea tahuri ki te kore. Ko tenei ano tetahi atu painga motuhake o te kōwhiringa hanga-i roto i ki te tini "whetūriki" - e kore te reira te whakaae ki ngā pūtau pātea rite te kore, i te reira tika kaituku ratou i te tatauranga.
He wā ka e hanga tātai mo te plurality o mahi pukapuka pepa, me te whārangi hua kei te rongoa tātai, kei roto i te hua o te uara o te tahi atu pepa. Ki te ka takoto kau tetahi tetahi o ratou, he whakarea ohie o te "whetu" tahuri koutou hua katoa i roto i te kore.
Mai i tenei e taea e tatou e faaoti e te whakahaere o tātaitanga matatini i runga i ngā rau maha he pai ki te whakamahi i te mahi "hanga" kia rite ki te kaupapa matua.
tepu whakareatanga
Titiro i muri, te hanga i tētahi tepu whakareatanga i roto i Excel. E mea ohie.
He | B | C | D | E | |
1 | 2 | 4 | 6 | 8 | |
2 | 3 | = $ A2 * B $ 1 | 12 | 18 | 24 |
3 | 5 | 10 | 20 | 30 | 40 |
4 | 7 | 14 | 28 | 42 | 56 |
5 | 9 | 18 | 36 | 54 | = $ A5 * E $ 1 |
I roto i te whakarerenga iho o te tepu whakareatanga paerewa ngā he tīwae o tetahi huinga o tau i roto i te rarangi - te tahi atu. Hei taea ki te tārua i te tātai, ko reira e tika ana ki te whakamahi i ngā hononga whakauru - ki te whakatika i te taha o te tohu "tāra" ($) te tau tīwae mai i poutū rārangi raraunga, me te whakapae ki te whai raraunga '= A2 * $ B $ 1 ".
Similar articles
Trending Now