Momwe mungachulukitsire mu Excel. Malangizo amomwe mungachulukitsire mu Excel

Spreadsheet Excel ndi pulogalamu yochita ntchito zambiri yomwe imakulolani kuti mugwiritse ntchito mawerengedwe ambiri osiyanasiyana. Pulogalamuyi imagwira ntchito zosavuta za masamu komanso masamu ovuta. Nkhaniyi iwona njira zingapo zogwiritsira ntchito kuchulukitsa mu spreadsheet.

Kuchulukitsa mu pulogalamu

Tonse timadziwa bwino momwe masamu amachitidwe ngati kuchulukitsa amachitikira pamapepala. Mu spreadsheet, njirayi ndi yosavuta. Chinthu chachikulu ndicho kudziwa ndondomeko yoyenera ya zochita kuti musapange zolakwika powerengera pamene mukugwira ntchito ndi zambiri zambiri.

"*" - chizindikiro cha asterisk chimagwira ntchito ngati kuchulukitsa mu Excel, koma ntchito yapadera ingagwiritsidwe ntchito m'malo mwake. Kuti mumvetse bwino nkhaniyi, ganizirani za kuchulukitsa pogwiritsa ntchito zitsanzo zenizeni.

Chitsanzo 1: kuchulukitsa nambala ndi nambala

Chopangidwa ndi 2 values ​​ndi chitsanzo chodziwika bwino cha masamu mu spreadsheet. Mu chitsanzo ichi, pulogalamuyi imagwira ntchito ngati chowerengera chokhazikika. Njirayi ikuwoneka motere:

1. Timayika cholozera pa selo iliyonse yaulere ndikusankha mwa kukanikiza batani lakumanzere.
2. Lowetsani chizindikiro "=", ndiyeno lembani nambala yoyamba.
3. Timayika chizindikiro cha mankhwalawa mu mawonekedwe a asterisk - "*".
4. Lowetsani nambala yachiwiri.

5. Dinani batani la "Enter" pa kiyibodi.
6. Okonzeka! Mu gawo lomwe mudalowamo njira yosavuta kwambiri, zotsatira za kuchulukitsa zidawonetsedwa.

Zofunika! Mu Excel spreadsheet, pogwira ntchito ndi kuwerengera, malamulo oyambira omwewo amagwira ntchito ngati masamu wamba. Mwa kuyankhula kwina, kugawa kapena kugulitsa kumakhazikitsidwa poyamba, kenako kuchotsa kapena kuchulukitsa.

Tikamalemba mawu okhala ndi mabulaketi papepala, chizindikiro chochulutsa nthawi zambiri sichimalembedwa. Mu Excel, chizindikiro chochulukitsa chimafunika nthawi zonse. Mwachitsanzo, tengani mtengo wake: 32+28(5+7). Mu gawo la purosesa ya tebulo, timalemba mawu awa motere: =32+28*(5+7).

Mwa kukanikiza batani la "Enter" pa kiyibodi, tidzawonetsa zotsatira mu cell.

Chitsanzo 2: chulukitsa selo ndi nambala

Njirayi imagwira ntchito motsatira malamulo omwe ali pamwambawa. Kusiyana kwakukulu sikuchokera ku manambala awiri wamba, koma kuchulukitsa kwa nambala ndi mtengo womwe umapezeka mu selo lina la spreadsheet. Mwachitsanzo, tili ndi mbale yomwe imawonetsa mtengo wa chinthu chilichonse. Tiyenera kuwerengera mtengo ndi kuchuluka kwa zidutswa zisanu. Njirayi ikuwoneka motere:

1. Timayika cholozera mu gawo lomwe likufunika kuchulukitsa. Mu chitsanzo ichi, iyi ndi selo C2.
2. Timayika chizindikiro "="".
3. Timayendetsa mu adilesi ya selo yomwe nambala yoyamba ili. Mu chitsanzo ichi, iyi ndi cell B2. Pali njira ziwiri zofotokozera selo ili. Yoyamba ndikulowetsa pawokha pogwiritsa ntchito kiyibodi, ndipo yachiwiri ndikudina pa selo ili mumzere wolowetsa ma formula.
4. Lowetsani chizindikiro chochulutsa ngati nyenyezi - "*".
5. Lowetsani nambala 5.

6. Dinani batani la "Enter" pa kiyibodi ndikupeza zotsatira zomaliza za kuwerengera.

Chitsanzo 3: chulukitsa maselo ndi selo

Tangoganizani kuti tili ndi tebulo lokhala ndi deta yosonyeza kuchuluka kwa zinthu ndi mtengo wake. Tiyenera kuwerengera kuchuluka kwake. Mchitidwe wowerengera kuchuluka kwake sikusiyana kwenikweni ndi njira yomwe ili pamwambapa. Kusiyanitsa kwakukulu ndikuti tsopano sitilowetsamo manambala aliwonse, ndipo powerengera timagwiritsa ntchito deta yokha kuchokera ku maselo a tebulo. Njirayi ikuwoneka motere:

1. Ikani cholozera mu gawo D2 ndikusankha mwa kukanikiza batani lakumanzere.
2. Lowetsani mawu otsatirawa mu bar ya formula: =B2*С2.

3. Dinani batani la "Enter" ndikupeza zotsatira zomaliza za kuwerengera.

Zofunika! Njira yopangira mankhwala imatha kuphatikizidwa ndi ntchito zosiyanasiyana za masamu. Fomula imatha kukhala ndi mawerengedwe ambiri, maselo ogwiritsidwa ntchito, ndi manambala osiyanasiyana. Palibe zoletsa. Chinthu chachikulu ndikulemba mosamala mafotokozedwe a mawu ovuta, chifukwa mutha kusokonezeka ndikupanga kuwerengera kolakwika.

Chitsanzo 4: kuchulukitsa ndime ndi nambala

Chitsanzochi ndi kupitiriza kwa chitsanzo chachiwiri, chomwe chili kumayambiriro kwa nkhaniyi. Tili ndi kale zotsatira zowerengetsera za kuchuluka kwa nambala ndi gawo la selo C2. Tsopano muyenera kuwerengera zikhalidwe zomwe zili m'mizere ili pansipa potambasula fomula. Tiyeni tiwone izi mwatsatanetsatane. Njirayi ikuwoneka motere:

1. Sunthani cholozera cha mbewa kumunsi kumanja kwa gawolo ndi zotsatira zowonetsedwa. Pankhaniyi, ndi selo C2.
2. Ikasunthidwa, cholozeracho chinasanduka chithunzi chomwe chimawoneka ngati chowonjezera chaching'ono. Gwirani pansi batani lakumanzere la mbewa ndikulikokera mpaka pansi pamzere wa tebulo.
3. Tulutsani batani lakumanzere la mbewa mukafika pamzere womaliza.

4. Okonzeka! Tidapeza zotsatira zakuchulukitsa zikhalidwe kuchokera pagawo B ndi nambala 5.

Chitsanzo 5: chulukitsani ndime imodzi

Chitsanzo chimenechi ndi kupitiriza ndi chitsanzo chachitatu chimene takambirana m’nkhani ino. Mu chitsanzo chachitatu, njira yochulukitsa gawo limodzi ndi lina idaganiziridwa. Ma aligorivimu a zochita sikusiyana kwenikweni ndi chitsanzo cham'mbuyomu. Njirayi ikuwoneka motere:

1. Sunthani cholozera cha mbewa kumunsi kumanja kwa gawolo ndi zotsatira zowonetsedwa. Munthawi imeneyi ndi cell D
2. Ikasunthidwa, cholozeracho chinasanduka chithunzi chomwe chimawoneka ngati chowonjezera chaching'ono. Gwirani pansi batani lakumanzere la mbewa ndikulikokera mpaka pansi pamzere wa tebulo.
3. Tulutsani batani lakumanzere la mbewa mukafika pamzere womaliza.

4. Okonzeka! Tidapeza zotsatira za gawo B ndi gawo C.

Ndikoyenera kutchera khutu momwe njira yotambasulira chilinganizo, yofotokozedwa mu zitsanzo ziwiri, imagwirira ntchito. Mwachitsanzo, selo C1 ili ndi formula =A1*V1. Mukakokera chilinganizo ku selo pansi C2, idzatenga mawonekedwe =A2*V2. Mwa kuyankhula kwina, ma cell coordinates amasintha pamodzi ndi malo omwe akuwonetsedwa.

Chitsanzo 6: kuchulukitsa ndime ndi selo

Tiyeni tiwunike ndondomeko yochulukitsa ndime ndi selo. Mwachitsanzo, ndikofunikira kuwerengera kuchotsera kwa mndandanda wazinthu zomwe zili mugawo B. Mu gawo E2, pali chizindikiro chochotsera. Njirayi ikuwoneka motere:

1. Poyamba, mu gawo C2, timalemba chilinganizo cha gawo B2 ndi E2. Fomula ikuwoneka motere: =B2*E2.

2. Simuyenera kudina batani la "Enter" nthawi yomweyo, chifukwa pakadali pano zofananira zimagwiritsidwa ntchito, ndiye kuti, panthawi yokopera magawo ena, kusintha komwe kunakambidwa kale kudzachitika (gawo B3 lidzachulukitsidwa ndi E3). ). Cell E2 ili ndi mtengo wa kuchotsera, zomwe zikutanthauza kuti adilesiyi iyenera kukhazikitsidwa pogwiritsa ntchito chidziwitso chonse. Kuti mugwiritse ntchito njirayi, muyenera kukanikiza kiyi "F4".
3. Tapanga chitsimikiziro chamtheradi chifukwa tsopano chizindikiro cha "$" chawonekera mu fomula.

4. Pambuyo popanga maulalo amtheradi, dinani batani la "Enter".
5. Tsopano, monga m'zitsanzo pamwambapa, timatambasulira chilinganizocho kumaselo apansi pogwiritsa ntchito chogwirira chodzaza.

6. Okonzeka! Mutha kuwona kulondola kwa mawerengedwewo poyang'ana fomula mu cell C9. Apa, monga kunali koyenera, kuchulukitsa kumachitika ndi gawo E2.

Othandizira PRODUCT

Mu spreadsheet ya Excel, zopanga zazizindikiro zitha kukhazikitsidwa osati pongolemba mafomu. Pali ntchito yapadera mu mkonzi wotchedwa PRODUCT, zomwe zimagwiritsa ntchito kuchulukitsa kwa zikhalidwe. Njirayi ikuwoneka motere:

1. Timadina gawo lomwe tikufuna kuwerengera ndikudina chinthu cha "Insert function" chomwe chili pafupi ndi mzere wolowetsa mafomu.

2. Zenera la "Function Wizard" lidzawonekera pazenera. Wonjezerani mndandanda pafupi ndi mawu akuti "Category:" ndikusankha chinthu "Masamu". Mu chipika "Sankhani ntchito:" timapeza lamulo PRODUCT, sankhani ndikudina batani la OK.

3. Zenera la mikangano limatsegulidwa. Apa mutha kufotokozera manambala wamba, maumboni achibale ndi mtheradi, komanso mikangano yophatikizidwa. Mutha kuyika nokha deta pogwiritsa ntchito zolembera pamanja kapena pofotokoza maulalo amaselo podina pa batani lakumanzere la mbewa patsamba logwirira ntchito.

4. Lembani mikangano yonse ndikudina OK. Zotsatira zake, tinapeza chopangidwa ndi maselo.

Zofunika! "Function Wizard" ikhoza kusiyidwa ngati wogwiritsa ntchito spreadsheet ya Excel akudziwa kulemba fomula kuti awerengere mawuwo pamanja.

Kanema pa ntchito zochulutsa mu Excel

Ngati malangizo ndi zitsanzo zili pamwambazi sizinakuthandizeni kuchulutsa mu spreadsheet, ndiye kuti kuonera kanema wotsatira kungakuthandizeni:

Kanemayo, pogwiritsa ntchito zitsanzo zenizeni, akufotokoza njira zingapo zochulukitsira pulogalamuyo, kotero ndikofunikira kuyang'ana kuti muwone bwino momwe njirazi zikugwiritsidwira ntchito.

Kutsiliza

Ndizotheka kukhazikitsa kuchulukitsa mu Excel spreadsheet m'njira zambiri. Mutha kuchulukitsa mtengo wa ma cell, kuchulukitsa nambala ndi gawo, kugwiritsa ntchito maumboni achibale ndi mtheradi, ndikugwiritsa ntchito masamu. PRODUCT. Chifukwa cha chisankho chochuluka chotero, wogwiritsa ntchito aliyense akhoza kusankha njira yabwino kwambiri kwa iye yekha ndikuigwiritsa ntchito pogwira ntchito ndi deta mu spreadsheet.