Ayizizo zonke abasebenzisi beMicrosoft yamagama ukuba kule nkqubo ungabala ngokwemifanekiso echaziweyo. Ewe kunjalo, ngaphambi kokuba ingeniso yephakheji yeofisi, i-Excel Proper Supers, umhleli wobhalo akafikeleli, nangona kunjalo, ukubala okulula, njengokungqinelana kwedatha, inokwenziwa kuyo. Namhlanje siza kuxela ukuba kwenziwe njani.
Ukubala izixa kwigama
Nangona i-Microsoft inyanzelekile ukuba isebenze kunye nesicatshulwa, ukongeza, inokuqhutywa kwezinto zegrafu, zonke iintlobo zamanani kunye nezinto, iitafile kunye neentetho zezibalo. Eli "sisibini" lihlala lithetha isidingo sokubala imali, oko kukuthi, kunokuba yimfuneko ukuba ifuneke kuzo zombini etafileni kwaye kumzekelo, okanye ifomula. Kwimeko nganye yezi meko, kuyimfuneko ukwenza ngokwahlukileyo. Luya kufunda njani kamva.Indlela yoku-1: Iifomula kunye ne-equations
Ukuba kwigama olifunayo ukubala inani lamanani okanye izinto ezingaziwayo ezirekhodwa kwinkcazo yezibalo, i-equation okanye ifomula, kuya kufuneka ubhekise kwisixhobo sokubhaliweyo sombhalo. Imelwe ekufakweni, indalo kunye notshintsho lwee-equations, malunga nokusebenza esibhale ngolwazi kwinqaku elahlukileyo kwiwebhusayithi yethu - ireferensi kuyo inikezelwe apha ngezantsi.
Funda ngakumbi: Ukusebenza kunye nefomula kunye ne-equations kwiMicrosoft Word
Indlela yesi-2: isambuka kwitafile
Kuninzi rhoqo ngaphambi kokuba abasebenzisi begama leMicrosoft baphakamisa umsebenzi omncinci kancinane kunokubonisa amabinzaniso lwezibalo kunye ne-equations. Isidingo sokubala isixa siyavela xa sisebenza neetafile xa kufuneka sifumane ixabiso elipheleleyo lamanani abhalwe kwikholam yayo eyahlukileyo okanye kumqolo. Oku kuyakwenziwa ngoncedo lwefomula, kodwa ngokwahlukileyo eyahlukileyo kwi-algorithm exoxwe ngentla.
Iimpawu zefomula yomsebenzi
Ukwenza ukubala kwitheyini eyenziwe ngegama, kuya kufuneka ukwazi ukuba zininzi izinto ezibalulekileyo.
- Ukuba utshintsha imixholo yeeseli ezibandakanyiweyo kwifomula, inani lamanani aliyi kuhlaziywa ngokuzenzekelayo. Ukufumana isiphumo esichanekileyo, kuya kufuneka ucofe kwiqhosha leqhosha lasekunene kwiseli kunye nefomula kwaye ukhethe i "Ibala lokuHlaziya".
- Ukubala ngokwefomyula kwenziwa ngokukodwa kwiiseli eziqulathiweyo kuphela. Ukuba kwikholamu okanye umgca ofuna ukushwankathela iiseli ezingenanto, le nkqubo iza kukhupha kuphela kwenxalenye yabo (uluhlu), efakwe kufutshane nefomula, ibekwe ngaphezulu kweseli. Kuya kwenzeka okufanayo nedatha ngemigca.
Ukuqukumbela
Njengoko ubona, qwalasela inani lamanani kwiMicrosoft Word kunokuba ngeendlela ezimbini ezahlukeneyo. Eyokuqala ithetha ukuba isebenze kunye neentetho zezibalo, kunye nesibini - kunye neetafile kunye nedatha equlathwe kwiiseli zabo.