Ungaphindaphinda kanjani ku-Excel. Imiyalo yokuthi ungakwenza kanjani ukuphindaphinda ku-Excel

Ispredishithi i-Excel wuhlelo olusebenza ngezindlela eziningi olukuvumela ukuthi usebenzise izibalo eziningi ezahlukene. Uhlelo lenza kokubili imisebenzi elula ye-arithmetic kanye nezibalo zezibalo eziyinkimbinkimbi. Lesi sihloko sizobheka izindlela ezimbalwa zokwenza ukuphindaphinda ku-spreadsheet.

Yenza ukuphindaphinda kuhlelo

Sonke sazi kahle ukuthi ukusebenza kwe-arithmetic njengokuphindaphinda kwenziwa kanjani ephepheni. Kuspredishithi, le nqubo nayo ilula. Into esemqoka ukwazi i-algorithm efanele yezenzo ukuze ungenzi amaphutha ekubaleni ngenkathi usebenza ngenani elikhulu lolwazi.

“*” – uphawu lwenkanyezi lusebenza njengokuphindaphinda ku-Excel, kodwa umsebenzi okhethekile nawo ungasetshenziswa esikhundleni salokho. Ukuze uqonde kangcono udaba, cabanga inqubo yokuphindaphinda usebenzisa izibonelo ezithile.

Isibonelo 1: ukuphindaphinda inombolo ngenombolo

Umkhiqizo wamanani angu-2 uyisibonelo esijwayelekile nesicacile sokusebenza kwe-arithmetic kuspredishithi. Kulesi sibonelo, uhlelo lusebenza njengesibali esijwayelekile. I-Walkthrough ibonakala kanje:

1. Sibeka ikhesa kunoma iyiphi iseli yamahhala bese siyikhetha ngokucindezela inkinobho yegundane kwesokunxele.
2. Faka u-“=" ngena kuyo, bese ubhala inombolo yoku-1.
3. Sibeka uphawu lomkhiqizo ngendlela yenkanyezi - "*".
4. Faka inombolo yesi-2.

5. Cindezela inkinobho ethi "Enter" kukhibhodi.
6. Ilungile! Emkhakheni ofake kuwo ifomula elula, umphumela wokuphindaphinda ubonisiwe.

Kubalulekile! Kuspredishithi se-Excel, lapho usebenza ngezibalo, imithetho yokuqala efanayo iyasebenza njengakwizibalo ezijwayelekile. Ngamanye amazwi, ukuhlukanisa noma umkhiqizo kuqaliswa kuqala, bese ususa noma uphindaphinde.

Uma sibhala isisho esinabakaki ephepheni, uphawu lokuphindaphinda ngokuvamile alubhalwa. Ku-Excel, uphawu lokuphindaphinda luhlala ludingeka. Isibonelo, thatha inani: 32+28(5+7). Emkhakheni wephrosesa yetafula, sibhala lesi sisho ngendlela elandelayo: =32+28*(5+7).

Ngokucindezela inkinobho ethi "Enter" kukhibhodi, sizobonisa umphumela kuseli.

Isibonelo sesi-2: phindaphinda iseli ngenombolo

Le ndlela isebenza ngokwemithetho efanayo nesibonelo esingenhla. Umehluko omkhulu akuwona umkhiqizo wezinombolo ezimbili ezijwayelekile, kodwa ukuphindaphinda kwenombolo ngenani elikwelinye iseli lesipredishithi. Isibonelo, sinepuleti elibonisa inani leyunithi yanoma yimuphi umkhiqizo. Kufanele sibale intengo nenani lezingcezu ezinhlanu. I-Walkthrough ibonakala kanje:

1. Setha ikhesa emkhakheni lapho kudingeka khona ukwenza ukuphindaphinda. Kulesi sibonelo, leli yiseli C2.
2. Sibeka uphawu "=".
3. Sishayela ekhelini leseli lapho inombolo yokuqala itholakala khona. Kulesi sibonelo, leli yiseli B2. Kunezindlela ezimbili zokucacisa leli seli. Owokuqala okokufaka okuzimele kusetshenziswa ikhibhodi, kanti okwesibili ukuchofoza leli seli ngenkathi usemgqeni wokufaka amafomula.
4. Faka uphawu lokuphindaphinda ngendlela yenkanyezi - “*”.
5. Faka inombolo 5.

6. Cindezela inkinobho ethi "Enter" kukhibhodi bese uthola umphumela wokugcina wokubala.

Isibonelo sesi-3: phindaphinda iseli ngeseli

Ake sithi sinetafula elinedatha ebonisa inani lemikhiqizo kanye nenani layo. Sidinga ukubala inani. Ukulandelana kwezenzo zokubala inani cishe akuhlukile kule ndlela engenhla. Umehluko omkhulu ukuthi manje asizifaki izinombolo ngokwethu, futhi ngezibalo sisebenzisa kuphela idatha evela kumaseli wetafula. I-Walkthrough ibonakala kanje:

1. Beka ikhesa kumkhakha we-D2 bese uyikhetha ngokucindezela inkinobho yegundane kwesokunxele.
2. Faka isisho esilandelayo kubha yefomula: =B2*С2.

3. Cindezela inkinobho ethi "Enter" bese uthola umphumela wokugcina wokubala.

Kubalulekile! Inqubo yomkhiqizo ingahlanganiswa nemisebenzi ehlukahlukene ye-arithmetic. Ifomula ingaba nenani elikhulu lezibalo, amaseli asetshenzisiwe, kanye namanani ezinombolo ahlukahlukene. Ayikho imikhawulo. Into esemqoka ukubhala ngokucophelela amafomula wezinkulumo eziyinkimbinkimbi, njengoba ungadideka futhi wenze ukubala okungalungile.

Isibonelo sesi-4: ukuphindaphinda ikholomu ngenombolo

Lesi sibonelo siwukuqhubeka kwesibonelo sesibili, esitholakala ekuqaleni kwalesi sihloko. Sesivele sinomphumela obaliwe wokuphindaphinda inani lezinombolo kanye nomkhakha weseli C2. Manje udinga ukubala amanani emigqeni engezansi ngokwelula ifomula. Ake sibheke lokhu ngokuningiliziwe. I-Walkthrough ibonakala kanje:

1. Hambisa ikhesa yegundane ekhoneni elingezansi kwesokudla lomkhakha ngomphumela obonisiwe. Kulokhu, iseli C2.
2. Lapho ihanjiswa phezulu, ikhesa yaphenduka isithonjana esifana nokuhlanganisa okuncane. Cindezela phansi inkinobho yegundane engakwesokunxele bese uyihudulela kumugqa ongezansi kakhulu wetafula.
3. Dedela inkinobho yegundane kwesokunxele uma ufika umugqa wokugcina.

4. Ilungile! Sithole umphumela wokuphindaphinda amanani kusuka kukholomu B ngenombolo 5.

Isibonelo sesi-5: phindaphinda ikholomu ngekholomu

Lesi sibonelo siwukuqhutshekwa kwesibonelo sesithathu okukhulunywe ngaso ekuqaleni kwalesi sihloko. Isibonelo sesi-3, kucatshangelwe inqubo yokuphindaphinda umkhakha ngomunye. I-algorithm yezenzo cishe ayihlukile kunesibonelo sangaphambilini. I-Walkthrough ibonakala kanje:

1. Hambisa ikhesa yegundane ekhoneni elingezansi kwesokudla lomkhakha ngomphumela obonisiwe. Kulesi simo, i-cell D
2. Lapho ihanjiswa phezulu, ikhesa yaphenduka isithonjana esifana nokuhlanganisa okuncane. Cindezela phansi inkinobho yegundane engakwesokunxele bese uyihudulela kumugqa ongezansi kakhulu wetafula.
3. Dedela inkinobho yegundane kwesokunxele uma ufika umugqa wokugcina.

4. Ilungile! Sithole umphumela womkhiqizo wekholomu B ngekholomu C.

Kuyafaneleka ukunaka ukuthi inqubo yokwelula ifomula, echazwe ezibonelweni ezimbili, isebenza kanjani. Isibonelo, iseli C1 liqukethe ifomula =A1*V1. Lapho uhudula ifomula kuseli eliphansi C2, kuzothatha ifomu =A2*V2. Ngamanye amazwi, izixhumanisi zeseli ziyashintsha kanye nendawo yomphumela obonisiwe.

Isibonelo sesi-6: ukuphindaphinda ikholomu ngeseli

Ake sihlaziye inqubo yokuphindaphinda ikholomu ngeseli. Isibonelo, kuyadingeka ukubala isaphulelo sohlu lwemikhiqizo etholakala kukholomu B. Emkhakheni we-E2, kukhona inkomba yesaphulelo. I-Walkthrough ibonakala kanje:

1. Ekuqaleni, kukholamu C2, sibhala ifomula yomkhiqizo womkhakha B2 ngo-E2. Ifomula ibukeka kanje: =B2*E2.

2. Akufanele uchofoze ngokushesha inkinobho ethi "Faka", ngoba okwamanje kusetshenziswa ireferensi ehlobene nefomula, okungukuthi, phakathi nenqubo yokukopisha kweminye imikhakha, kuzovela i-coordinate shift okuxoxwe ngayo ngaphambili (umkhakha B3 uzophindaphindwa nge-E3). ). Iseli E2 liqukethe inani lesaphulelo, okusho ukuthi leli kheli kufanele lilungiswe kusetshenziswa ireferensi ephelele. Ukuze usebenzise le nqubo, kufanele ucindezele ukhiye "F4".
3. Senze isithenjwa esiphelele ngoba manje uphawu lwe-“$” seluvele kufomula.

4. Ngemva kokudala izixhumanisi eziphelele, cindezela inkinobho ethi "Enter".
5. Manje, njengasezibonelweni ezingenhla, selula ifomula kumaseli aphansi sisebenzisa isibambo sokugcwalisa.

6. Ilungile! Ungahlola ukunemba kwezibalo ngokubheka ifomula kuseli C9. Lapha, njengoba bekudingekile, ukuphindaphinda kwenziwa ngumkhakha we-E2.

I-Opharetha PRODUCT

Kuspredishithi i-Excel, umkhiqizo wezinkomba ungasetshenziswa hhayi kuphela ngokuchaza amafomula. Kukhona umsebenzi okhethekile kumhleli obizwa ngokuthi UMKHIQIZO, esebenzisa ukuphindaphindeka kwamanani. I-Walkthrough ibonakala kanje:

1. Sichofoza umkhakha lapho sifuna ukusebenzisa khona izibalo bese sichofoza into ethi "Faka umsebenzi" etholakala eduze komugqa wokufaka amafomula.

2. Iwindi elithi “Function Wizard” lizovela esikrinini. Nweba uhlu eduze nombhalo othi “Isigaba:” bese ukhetha into ethi “Mathematical”. Kubhulokhi ethi “Khetha umsebenzi:” sithola umyalo UMKHIQIZO, ikhethe bese uchofoza inkinobho ethi OK.

3. Iwindi lezimpikiswano liyavuleka. Lapha ungacacisa izinombolo ezijwayelekile, izinkomba ezihlobene neziphelele, kanye nezimpikiswano ezihlanganisiwe. Ungakwazi ukufaka idatha ngokwakho usebenzisa okokufaka okwenziwa ngesandla noma ngokucacisa izixhumanisi zamaseli ngokuchofoza inkinobho yegundane engakwesokunxele ekhasini lokusebenza.

4. Gcwalisa wonke ama-agumenti bese uchofoza okuthi OK. Ngenxa yalokho, sathola umkhiqizo wamaseli.

Kubalulekile! “I-Function Wizard” ingashiywa uma umsebenzisi wespredishithi se-Excel azi ukuthi ifakwa kanjani ifomula ukuze abale isisho mathupha.

Ividiyo ekusebenzeni kokuphindaphinda ku-Excel

Uma imiyalelo nezibonelo ezingenhla zingakusizanga ukuthi usebenzise ukuphindaphinda kusipredishithi, ukubuka ividiyo elandelayo kungakusiza:

Ividiyo, isebenzisa izibonelo ezithile, ichaza izindlela ezimbalwa zokuphindaphinda ohlelweni, ngakho-ke kufanelekile ukuyibuka ukuze ubone ngokucacile ukuthi lezi zinqubo zenziwa kanjani.

Isiphetho

Kungenzeka ukusebenzisa ukuphindaphinda kusipredishithi se-Excel ngezindlela eziningi. Ungakwazi ukuphindaphinda inani lamaseli, uphindaphinde inombolo ngomkhakha, usebenzise izinkomba ezihlobene neziphelele, futhi usebenzise umsebenzi wezibalo. UMKHIQIZO. Ngenxa yokhetho olubanzi kangaka, umsebenzisi ngamunye angazikhethela indlela elula kakhulu futhi ayisebenzise lapho esebenza nedatha kusipredishithi.