I ngokuphelele futhi isihlobo isixhumanisi Excel. Indlela yokusebenzisa?

Noma ngabe usanda kuqala ukusebenza uhlelo e-Microsoft Excel, cishe uyazi ukuthi omunye zako kulula ukusebenza amafomula namathebula. Ngakho-ke, thina sikanye nawe namuhla, cabangela ekhuluma amathebula okunjalo futhi ukuthola ukuthi kunani ahlobene, ngokuphelele futhi edidayo. Umsebenzi wabo ulula, ngakho-ke kuba elula ababheke practice. Ngakho-ke yini isithenjwa ngokuphelele futhi isihlobo?

definition

Izinkomba e-Microsoft Excel - lena ayifani izixhumanisi Inthanethi. Ngokuthi inkomba ikheli cell (isib: A1, B10). Bona zihlukaniswe izinhlobo ezimbili eziyinhloko - izixhumanisi ngokuphelele futhi isihlobo. Ku-Excel ekhuluma kwenzeka kumaseli, ngakho uma kususwa noma ukukopisha amafomula, sivamile ozidingayo ukuze ulondoloze noma, Ngakolunye uhlangothi, ukuba esikhundleni idatha.

isixhumanisi isihlobo

Lolu hlobo yisona esikhulunywa abantu abaningi. Uma ungazange baqhubeke nezifundo ezikhethekile, ngeke ufunde, khona-ke cishe ukuhlangana izinkomba ngokuphelele. Ngakho siqala neqiniso lokuthi kulula.

izinkomba Ingabe Ohulumeni Banalo Lonke kanye isihlobo amafomula asetshenziselwa ukusebenza cell amakheli, kodwa ukuze okuphambene. Udaba phambi kwethu uhlobo eziyisisekelo futhi ayigcini cell amakheli ku-formula ngesikhathi sokudlulisa yayo. Cabangela nasi isibonelo.

• Ake sithi unikezwa iseli ngedatha (amakholomu) - M1, M2, M3, emgwaqeni ongu-N1, N2, u-N3. Ngezansi nabo M4 iseli sibhala ifomula, umphumela okuyinto isamba izinombolo ezintathu (M4 = M1 + M2 + M3). Njengazo zonke elula. Manje sidinga ukubala okuqukethwe cell H4. Libuye isamba idatha asezintweni kuso. Ukudonsa noma umane ukukopisha cell M4, thina manje ukuthatha Ifomula H4. Ngenxa yalokho, yonke imibhalo ekhonjiwe therein (M1, M2, M3) luzobuyiselwa H1, H2 futhi H3, ngokulandelana.

Lokhu kubizwa ngokuthi isihlobo ekhuluma. Isibonelo kubonakala elula kuphakama umbuzo ngokomzwelo okungokwemvelo, abangafuni kulula ukubhala ifomula entsha? Cha, kumathebula elikhulu izibalo volumetric, okungaba ezihlukahlukene imisebenzi kanye opharetha lithembeke okungaphezu nje ukopishe bese uthumele ifomula kuka kabusha bakha le nkulumo.

uxhumanongqo

Njengoba sekushiwo, izixhumanisi ngokuphelele futhi isihlobo Excel ufeze izinjongo ezihlukahlukene. Uhlobo link phambi kwethu namuhla yesibili, yakhelwe ukugcina ekhuluma ngokuba noma yiziphi izinguquko nokunyakaza formula.

• Ake sithi kudingeka ukuxazulula umsebenzi ngokomzimba. Une-njalo ezithile, egcinwe kuseli A1. Yiqiniso, asikwazanga ukubhala noma nini le nombolo ngesandla, kodwa kulula ukubhala endaweni eyodwa ethile. ezimbili amakholomu idatha njengoba esiwuphiwe (M1, M2, P1, P2). I-M3 kanye P3 amaseli kudingekile ukubala le ndlela elandelayo: M3 = (M1 + M2) * $ A $ 1. Manje lapho ehudula futhi ukukopisha P3 iseli ukuthola umphumela P3 elandelayo = (P1 + P2) * $ A $ 1. Lokho ikheli esetshenziswa iseli ngeke ukuthutha.

Ukushaya ngokuphelele isixhumanisi ikheli, chofoza ifomula, ukhethe "isixhumanisi" oyifunayo bese ucindezela F4. Noma ngesandla uthayipha izinhlamvu "dollar".

okuxubile

Lolu hlobo samuva lapho kwanqunywa itholakala amafomula. Njengoba leli gama lisikisela, lokhu kuyinto ngokuphelele futhi isihlobo inkomba sikhathi. Akunzima ukuqagela ukuthi, ngokomthetho it is eyabizwa ngokuthi A1 noma $ A $ 1. Ngakho, it ikuvumela ukuba ugcine ekhuluma ikhalamu noma umugqa, kodwa bayaqhubeka 'sehla "kuso. Cabangela nasi isibonelo.

Ngakho, sinesizathu itafula enye idatha. Esikhathini kukholomu "A", sinalo inani elithile, futhi emgqeni "1", isici ngawo kumelwe wande. Cell B2, C3 sizoqukatha imiphumela. Njengoba ubona isixhumanisi ngokuphelele futhi isihlobo lapha engenamandla. Ezimweni ezinjalo, uhlobo okuxubile kumele kusetshenziswe.

Sibhala wefomula ngowokuqala kuseli A2 * B2 = B1. Kodwa ukuze idonsele ilungelo, kubalulekile ukuba ulungise kukholomu "A", futhi ngakho phansi ukulungisa string "1". Ngakho-ke, i-esipelingi ifomula kungaba = $ B2 A2 * B $ 1. Ngakho, uma hudula ifomula, sithola uhide yamanani ngamunye amaseli esisele:

• B3 = $ A3 * B $ 1
• C2 = A2 * $ C $ 1
• C3 = $ A3 * C $ 1

Njengoba ubona, isixhumanisi ngokuphelele futhi isihlobo bekangekhe arhelebhe lapha. Ngakho-ke, i-izibalo eziyinkimbinkimbi kudingekile ukusebenzisa uhlobo kuphela okuxubile. Lokhu kuzovumela kobuhlungu ukucaca etafuleni, engeza ku-ke imigqa namakholomu. Kuphela lapho sisebenzelana zalezi zinhlobo ekhuluma kufanele uqaphele kakhulu njalo, ngoba, ukuthi wenze iphutha kanye itafula esetshenziswa ireferensi okuxubile, tfola iphutha kuyoba nzima kakhulu.

Yilokho. Sethemba manje ube kangcono, uyini uxhumanongqo futhi isihlobo.