Phakathi kokusebenza okuningi kwezibalo okwenziwa yiMicrosoft Excel, ngokwemvelo, kunokuphindaphindwa. Kepha, ngeshwa, akubona bonke abasebenzisi abangasisebenzisa ngokunembile futhi ngokugcwele lesi sici. Ake sibheke ukuthi yenziwa kanjani inqubo yokuphindaphindeka kwiMicrosoft Excel.
Izimiso Zokuphindaphindeka ku-Excel
Njenganoma yimuphi omunye umsebenzi we-arithmetic ku-Excel, ukubuyabuyelela kwenziwa ngokusebenzisa amafomula akhethekile. Izenzo zokuphindaphindwa ziqoshwa kusetshenziswa isibonakaliso se- "*".
Ukuphindaphindwa kwezinombolo ezejwayelekile
Ungasebenzisa iMicrosoft Excel njenge-wokubala, bese umane ukuphindaphindeka amanani ahlukahlukene kuyo.
Ukuze siphindaphindeke inombolo ngesinye, sibhala kunoma yiliphi iseli eshidini, noma emgqeni wamafomula, isibonakaliso sithi (=). Okulandelayo, bonisa isici sokuqala (inombolo). Ngemuva kwalokho, beka isibonakaliso ukuze siphindaphindwe (*). Ngemuva kwaloko, bhala intfo yesibili (inombolo). Ngakho-ke, iphethini yokuphindaphinda ejwayelekile izobukeka kanjena: "= (inombolo) * (inombolo)".
Isibonelo sikhombisa ukuphindaphindwa kuka-564 ngu-25. Isenzo siqoshwe ngefomula elandelayo: "=564*25".
Ukubuka umphumela wokubala, cindezela ukhiye ENTER.
Ngesikhathi sokubala, udinga ukukhumbula ukuthi ukubaluleka kwe-arithmetic ku-Excel kuyafana nakwizibalo ezijwayelekile. Kodwa, isibonakaliso sokuphindaphinda kufanele sengezwe kunoma yikuphi. Uma, lapho kubhalwa inkulumo ephepheni, kuvunyelwe ukushiya uphawu lokuphindaphinda phambi kwamabakaki, bese kuba ngu-Excel, ekubalweni okuyilo, kuyadingeka. Isibonelo, inkulumo ethi 45 + 12 (2 + 4), ku-Excel udinga ukubhala ngokulandelayo: "=45+12*(2+4)".
Amaseli amaningi ngeseli
Inqubo yokuphindaphinda iseli ngeselula inciphisa wonke emgomeni ofanayo nenqubo yokuphinda inamba ngenombolo. Okokuqala, udinga ukunquma ukuthi umphumela uzokhonjiswa kuseliphi iseli Sibeka uphawu olulinganayo (=) kuyo. Okulandelayo, chofoza ngokuhlukile kumaseli okuqukethe okuqukethwe okudinga ukuphindwa. Ngemuva kokukhetha iseli ngayinye, beka uphawu lokuphindaphinda (*).
Ikholamu yokuphindaphindwa kwekholomu
Ukuze wandise ikholamu ngekholomu, kuzodingeka uphindaphinde amaseli aphezulu kakhulu ala makholamu, njengoba kukhonjisiwe kwisibonelo esingenhla. Ngemuva kwalokho, sima ekhoneni elingezansi kwesokunxele seseli eligcwele. Umaka wokugcwalisa uyavela. Hudula phansi ngenkathi ubambe inkinobho yegundane kwesobunxele. Ngakho-ke, ifomula yokuphindaphindwa ikopishelwa kuwo wonke amaseli kukholamu.
Ngemuva kwalokho, amakholomu azokwandiswa.
Ngokufanayo, ungaphindaphinda amakholomu amathathu noma ngaphezulu.
Kwandisa iseli ngenombolo
Ukuze wandise iseli ngenombolo, njengasezibonelweni ezichazwe ngenhla, okokuqala, faka uphawu olulinganayo (=) kuleso seli ohlose ukukhombisa impendulo yokusebenza kwe-arithmetic. Okulandelayo, udinga ukubhala phansi isibalo sezinombolo, faka uphawu lokuphindaphindeka (*), bese uchofoza kuseli ofuna ukuliphindaphinda.
Ukuze ubonise umphumela esikrinini, chofoza inkinobho ENTER.
Kodwa-ke, ungenza isenzo ngokulandelana okuhlukile: masinyane ngemuva kwesiginali esilinganayo, chofoza kuseli ukuthi liphindaphindwe, bese kuthi, ngemuva kwesibonakaliso sokuphindaphinda, ubhale inombolo. Ngemuva kwakho konke, njengoba wazi, umkhiqizo awushintshi usuka ekuvumelweni kwezinto.
Ngendlela efanayo, ungakwazi, uma kunesidingo, ukuphindaphindwa kwamaseli nezinamba eziningana ngasikhathi sinye.
Phindaphinda ikholamu ngenombolo
Ukuze uphindaphinde ikholomu ngenombolo ethile, kufanele ugcwalise iseli ngokushesha ngale nombolo, njengoba kuchaziwe ngenhla. Ngemuva kwalokho, sisebenzisa umaki wokugcwalisa, kopisha ifomula siye kumaseli aphansi, bese sithola umphumela.
Phindaphinda ikholamu ngeseli
Uma kunenombolo esitokisini esithile lapho ikholamu kufanele iphindwe ngayo, ngokwesibonelo, kukhona ukubekeka okuthile, khona-ke indlela engenhla ngeke isebenze. Lokhu kungenxa yokuthi lapho sikopisha uhla lwalezi zinto zombili luzoshintsha, futhi sidinga ukuthi esinye sezici sibe njalo.
Okokuqala, siphindaphindeka ngendlela ejwayelekile iseli lokuqala lekholamu ngeseli eliqukethe okwanele. Okulandelayo, kwifomula, sibeka uphawu lwedola phambi kwezixhumanisi zekholomu nesixhumanisi somugqa esitokisini ngokuhlangana. Ngale ndlela, saphenduka isixhumanisi esihlobene saba ngokuphelele, izixhumanisi zazo ezingeke zishintshe lapho sikopisha.
Manje, kuseyindlela ejwayelekile, usebenzisa umaki wokugcwalisa, kopisha ifomula kwamanye amaseli. Njengoba ukwazi ukubona, imiphumela eqediwe ivele ngokushesha.
Isifundo: Ungasenza kanjani isixhumanisi esiphelele
Umsebenzi we-PRODUCT
Ngaphezu kwendlela ejwayelekile yokuphindaphindeka, e-Excel kukhona ithuba lalezi zinhloso zokusebenzisa umsebenzi okhethekile UMkhiqizo. Ungayibiza yonke ngezindlela ezifanayo njenganoma yimuphi omunye umsebenzi.
- Usebenzisa Umsebenzi Wizard, ongavulwa ngokuchofoza inkinobho "Faka umsebenzi".
- Ngethebhu Amafomula. Ukuba kuyo, udinga chofoza inkinobho "Izibalo"etholakala kubambo kubhokisi lamathuluzi Umtapo wesici. Ngemuva kwalokho, ohlwini olubonakala, khetha "PRODUCTION".
- Thayipha igama lomsebenzi UMkhiqizo, nokuphikisana kwayo, ngesandla, ngemuva kophawu olulinganayo (=) kuseli olufunayo, noma kubha yefomula.
Ngemuva kwalokho, udinga ukuthola umsebenzi UMkhiqizo, ewindini elivuliwe le-wizard yokusebenza, bese uqhafaza "Kulungile".
Ithempulethi yomsebenzi wokungenela lencwadi imi ngalendlela elandelayo: "= PRODUCTION (inombolo (noma ireferensi yeseli); inombolo (noma isithenjwa seseli); ...). Okusho ukuthi, uma ngokwesibonelo kudingeka ukuthi siphindaphindeke ngo-77 ngama-55, bese siphindeka ngama-23, bese sibhala ifomula elandelayo: "= Umkhiqizo (77; 55; 23)". Ukukhombisa umphumela, chofoza inkinobho ENTER.
Lapho usebenzisa izinketho ezimbili zokuqala zokusebenzisa umsebenzi (usebenzisa i-Function Wizard noma ithebhu Amafomula), iwindi lokuphikisana liyavula, lapho udinga ukufaka izimpikiswano ngesimo sezinombolo, noma amakheli weselula. Lokhu kungenziwa ngokuchofoza kumaseli owafunayo. Ngemuva kokufaka izingxabano, chofoza inkinobho "Kulungile", ukwenza ukubala, nokukhombisa umphumela esikrinini.
Njengoba ukwazi ukubona, e-Excel kunenombolo enkulu yezinketho zokusebenzisa imisebenzi ye-arithmetic njengokuphindaphindwa. Into esemqoka ukwazi ama-nuances wokusebenzisa amafomula wokuphindaphindeka esimweni ngasinye.
