Phakathi kwemisebenzi eminingi ye-arithmetic ukuthi i-Microsoft Excel ingenza, yebo, kukhona nokuphindaphindiwe. Kodwa, ngeshwa, akubona bonke abasebenzisi abangasebenzisa ngokugcwele leli thuba futhi balisebenzise ngokugcwele. Ake sibone ukuthi singenza kanjani inqubo yokubuyabuyelela ku-Microsoft Excel.
Izimiso zokuphindaphinda ku-Excel
Njenganoma yikuphi ukusebenza kwe-arithmetic ku-Excel, ukubuyabuyelela kwenziwa ngokusebenzisa amafomula akhethekile. Izenzo zokuphindaphinda zilotshiwe usebenzisa isibonakaliso - "*".
Ukuphindaphindwa kwezinombolo ezivamile
I-Microsoft Excel ingasetshenziswa njenge-calculator futhi ivele iphindise izinombolo ezihlukahlukene kuyo.
Ukuze sande inombolo eyodwa ngomunye, singena kunoma yisiphi iseli kushidi, noma emgqeni wefomula, uphawu (=). Okulandelayo, cacisa isici sokuqala (inombolo). Khona-ke, sibeka isibonakaliso sokwandisa (*). Bese ubhala isici sesibili (inombolo). Ngakho, iphethini lokuphindaphinda jikelele lizobukeka kanje: "= (inombolo) * (inombolo)".
Lesi sibonelo sibonisa ukuphindaphinda kuka-564 ngo-25. Isenzo sibhaliwe ngefomula elandelayo: "=564*25".
Ukubuka umphumela wezibalo, udinga ukucindezela ukhiye ENTER.
Ngesikhathi sokubala, udinga ukukhumbula ukuthi okubaluleke kakhulu kokusebenza kwe-arithmetic ku-Excel, kufana nokujwayelekile kwezibalo. Kodwa, isibonakaliso sokuphindaphinda sidinga ukungezwa noma yikuphi. Uma, uma ubhala inkulumo ephepheni, kuvunyelwe ukushiya uphawu lokuphindaphinda ngaphambi kokuba abazali, bese kuthi ku-Excel, kube nokubalwa okulungile, kuyadingeka. Isibonelo, inkulumo engu-45 + 12 (2 + 4), ku-Excel, udinga ukubhala kanje: "=45+12*(2+4)".
Ukuphindaphinda kweselula ngeseli
Inqubo yokwandisa iseli ngomakhalekhukhwini ikwehlisa yonke into ibe yindlela efanayo nenqubo yokwandisa inombolo ngenombolo. Okokuqala, udinga ukunquma ukuthi yisiphi isici umphumela uzoboniswa. Kulo sibeka uphawu olulinganayo (=). Okulandelayo, chofoza ngokuzenzekelayo kumaseli okuqukethwe okudingeka akwandiswe. Ngemva kokukhetha iseli ngalinye, faka uphawu lokuphindaphinda (*).
Yandisa ikholomu ngekholomu
Ukuze ukwandise ikholomu ngekholomu, ngokushesha udinga ukwandisa amaseli aphezulu kulawa kholomu, njengoba kuboniswe kusibonelo ngenhla. Khona-ke, siba ekhoneni elingezansi elingakwesokunxele leseli eligcwele. Uphawu lokugcwalisa luvela. Hudula phansi inkinobho yegundane lesokunxele ucindezelwe. Ngakho, ifomu lokuphindaphinda likopishwa kuwo wonke amaseli ekholomu.
Emva kwalokho, amakholomu azokwandiswa.
Ngokufanayo, ungandisa amakholomu amathathu noma ngaphezulu.
Ukuphindaphinda kweselula ngenombolo
Ukuze ukwandise iseli ngenombolo, njengalezi zibonelo ezichazwe ngenhla, okokuqala, faka uphawu olulinganayo (=) esitokisini lapho uhlose ukukhipha impendulo yemisebenzi ye-arithmetic. Okulandelayo, udinga ukubhala phansi umphindiseli wezinombolo, faka uphawu lokuphindaphinda (*), bese uqhafaza kuseli ofuna ukuliphindayo.
Ukuze ubonise umphumela esikrinini, chofoza inkinobho. ENTER.
Noma kunjalo, ungenza izenzo ngendlela ehlukile: ngokushesha emva kwesibonakaliso esilinganayo, chofoza kuseli elidinga ukwandiswa, bese kuthi emva kwesibonakaliso sokuphindaphinda, bhala inombolo. Ngempela, njengoba kuyaziwa kahle, umkhiqizo awushintshi kusukela ekuhlelweni kabusha kwezinto.
Ngendlela efanayo, kungenzeka, uma kunesidingo, ukwandisa amaseli amaningana nezinombolo eziningana ngesikhathi esisodwa.
Ukwandisa ikholomu ngenombolo
Ukuze ukwandise ikholomu ngenani elithile, kumele usande ngokushesha iseli ngale nombolo, njengoba kuchazwe ngenhla. Khona-ke, usebenzisa uphawu lokugcwalisa, kopisha ifomula kumaseli aphansi, futhi uthole umphumela.
Yandisa ikholomu ngeseli
Uma kukhona inombolo esitokisini esithile lapho ikholomu kufanele yande khona, isibonelo, kukhona ikhoefficient ethile lapho, khona-ke indlela engenhla ngeke isebenze. Lokhu kungenxa yokuthi uma ukukopisha, ububanzi bezinto zombili buzoshintsha, futhi sidinga esinye sezici ukuba zihlale zikhona.
Okokuqala, phinda ngendlela evamile iseli lokuqala lekholomu ngeseli equkethe coefficient. Ngaphezu kwalokho, kufomula sibeka uphawu lwedoli ngaphambi kwezixhumanisi zekholomu kanye nomugqa wechungechunge leseli nge-coefficient. Ngale ndlela, siphendule ireferensi yesihlobo ngokubhekisela ngokuphelele, izixhumanisi zazo ezingeke zishintshe uma kukopishwa.
Manje, ihlala ngendlela evamile, isebenzisa uphawu lokugcwalisa, ukukopisha ifomula kwamanye amaseli. Njengoba ungabona, umphumela ophelile uvele ngokushesha.
Isifundo: Indlela yokwenza isixhumanisi esiphelele
Umsebenzi wokukhiqiza
Ngaphandle kwendlela yokuphindaphinda evamile, ku-Excel kunokwenzeka ukuthi lezi zinhloso zisebenzise umsebenzi okhethekile Ukukhiqiza. Ungabiza ngendlela efanayo nanoma yimuphi omunye umsebenzi.
- Ukusebenzisa i-Wizard Wizard, engasungulwa ngokuchofoza inkinobho "Faka umsebenzi".
- Ngethebhu "Amafomula". Ngenkathi ukhona, udinga ukuchofoza inkinobho. "Isibalo"okuyinto itholakala ku-tape ebhodini lamathuluzi "I-Function Library". Khona-ke, kuhlu oluvela, khetha UFANELE.
- Thayipha igama lomsebenzi Ukukhiqiza, kanye neziphakamiso zalo, ngesandla, emva kwesibonakaliso esilinganayo (=) esitokisini esifuna, noma kubha yefomula.
Khona-ke, udinga ukuthola umsebenzi Ukukhiqiza, ku-window evulekile yomsebenzi window, bese uchofoza "Kulungile".
Ithempulethi yomsebenzi yokufaka ngesandla iyindlela elandelayo: "= I-PRODUCTION (inombolo (noma i-reference reference); inombolo (noma i-reference reference); ...)". Okusho ukuthi uma sibonela ukuthi sidinga ukwandisa ama-77 ngo-55, futhi sivame nge-23, bese sibhala ifomula elandelayo: "= UKUQUKETHWA (77; 55; 23)". Ukuze ubonise umphumela, chofoza inkinobho. ENTER.
Uma usebenzisa izinketho ezimbili zokuqala zokusebenzisa umsebenzi (usebenzisa i-Function Wizard noma ithebhu "Amafomula"), ifasitela lezingxoxo livuleka, lapho okudingeka ufake khona izingxabano ngesimo sezinombolo, noma amakheli eseli. Lokhu kungenziwa nje ngokuchofoza amaseli afunayo. Ngemva kokufaka izingxabano, chofoza inkinobho "Kulungile", ukwenza izibalo, futhi ubonise umphumela esikrinini.
Njengoba ubona, ku-Excel kunenombolo enkulu yezinketho zokusebenzisa ukusebenza okunjalo kwe-arithmetic njengokuphindaphinda. Into eyinhloko ukwazi ama-nuances okusebenzisa amafomula wokuphindaphinda kwimeko ngayinye.
