Ungasetha kanjani ukunemba njengakusikrini ku-Excel. Ungasetha kanjani futhi ulungise ukunemba ku-Excel

Lapho kwenziwa izibalo ezithile ku-Excel ezihlobene ngokuqondile namanani amaqhezu, abasebenzisi bangase bahlangabezane nezimo lapho inombolo engalindelekile ngokuphelele ivela kuseli nomphumela womphumela. Lokhu kungenxa yezici zobuchwepheshe zalolu hlelo. Ngokuzenzakalelayo, i-Excel ithatha amanani ayingxenyana ezibalo ezinamadijithi ayi-15 ngemva kwephoyinti ledesimali, kuyilapho iseli lizobonisa amadijithi afinyelela kwangu-3. Ukuze ungatholi njalo imiphumela yokubala engalindelekile, kubalulekile ukusetha kusengaphambili ukunemba kokuzungezisa okulingana nalokhu okuboniswa esikrinini phambi komsebenzisi.

Isebenza kanjani isistimu yokuqoqa ku-Excel

Ngaphambi kokuba uqale ukusetha ukuzungezwa kwamanani ama-fractional, kunconywa ukuthi ufunde kabanzi mayelana nokuthi lolu hlelo lusebenza kanjani, oluzothinteka ngokushintsha imingcele yalo.

Akunconywa ukushintsha izilungiselelo ezimweni lapho izibalo ezibandakanya izingxenyana zenziwa kaningi. Lokhu kungabuyisela emuva kulokho okufunayo.

Esinye sezimo lapho kutuswa khona ukwenza izinguquko ezengeziwe ekubalweni kokunemba ukungeza izinombolo ezimbalwa usebenzisa indawo yedesimali eyodwa kuphela. Ukuze uqonde ukuthi kwenzekani kaningi ngaphandle kokucushwa okwengeziwe, udinga ukucabangela isibonelo esisebenzayo. Umsebenzisi udinga ukwengeza izinombolo ezimbili - 4.64 no-3.21, kuyilapho ethatha idijithi eyodwa kuphela ngemva kwedesimali njengesisekelo. Inqubo:

1. Ekuqaleni, udinga ukukhetha amaseli anezinombolo ezifakwe kuwo ngegundane noma ikhibhodi.
2. Cindezela u-RMB, khetha umsebenzi othi “Fometha Amaseli” kumenyu yokuqukethwe.

3. Ngemuva kwalokho, kuzovela iwindi elinezilungiselelo, lapho udinga ukuya kuthebhu "Inombolo".
4. Kulolu hlu udinga ukukhetha ifomethi ethi "Numeric".
5. Esigabeni samahhala "Inani lezindawo zamadesimali" setha inani elidingekayo.
6. Kusele ukulondoloza izilungiselelo ngokucindezela inkinobho ethi "KULUNGILE".

Nokho, umphumela ngeke ube ngu-7.8, kodwa u-7.9. Ngenxa yalokhu, umsebenzisi kungenzeka acabange ukuthi iphutha lenziwe. Leli nani eliyiqhezu latholwa ngenxa yokuthi ngokuzenzakalelayo i-Excel yayifingqa izinombolo ezigcwele, nazo zonke izindawo zedesimali. Kodwa ngokombandela owengeziwe, umsebenzisi ucacise inombolo enedijithi eyodwa kuphela ngemva kwephuzu ledesimali elizoboniswa esikrinini. Ngenxa yalokhu, inani eliwumphumela lika-7.85 lahlanganiswa, lapho kwaphuma khona u-7.9.

Kubalulekile! Ukuze uthole ukuthi yiliphi inani elizothathwa uhlelo njengesisekelo ngesikhathi sokubala, udinga ukuchofoza kuseli ngenombolo ye-LMB, unake umugqa lapho kuchazwa ifomula evela kuseli. Kukuyo lapho inani elizothathwa njengesisekelo sezibalo ngaphandle kwezilungiselelo ezengeziwe lizoboniswa.

Ukusetha ukunemba kokusondeza

Indlela yokumisa ukuqoqwa kwamanani amafrakshini we-Excel (2019) - inqubo:

1. Yiya kumenyu enkulu "Ifayela".

2. Iya kuthebhu ethi "Parameters". Ungayithola phansi ekhasini kwesokunxele.
3. Khetha izilungiselelo ezithuthukile.
4. Ngakwesokudla sewindi elivelayo, thola ibhulokhi ethi “Lapho ubala kabusha le ncwadi”, thola umsebenzi othi “Setha ukunemba okucacisiwe” kuyo. Lapha udinga ukuhlola ibhokisi.
5. Ngemva kwalezi zinyathelo, iwindi elincane lesixwayiso kufanele livele esikrinini. Izobonisa ukuthi ngokwenza lesi senzo, ukunemba kwezibalo emathebula kungase kwehle. Ukuze ulondoloze izilungiselelo, kufanele uvumelane nezinguquko ngokuchofoza "KULUNGILE". Cindezela okuthi “KULUNGILE” futhi ukuze uphume kuzilungiselelo.

Uma udinga ukucisha umsebenzi wokuzungezisa oqondile noma uwushintshe, udinga ukuya kuzilungiselelo ezifanayo, ususe ukumaka ibhokisi noma ufake inombolo ehlukile yezinhlamvu ngemuva kwephoyinti ledesimali, elizocatshangelwa ngesikhathi sokubala.

Ungakulungisa kanjani ukunemba ezinguqulweni zangaphambili

I-Excel ibuyekezwa njalo. Yengeza izici ezintsha, kodwa amathuluzi amaningi amakhulu ayasebenza futhi ahlelwa ngendlela efanayo. Lapho usetha ukunemba okuqoqayo kwamanani ezinguqulweni zangaphambili zohlelo, kunomehluko omncane ovela enguqulweni yesimanje. Ku-Excel 2010:

1. Iya kuthebhu ethi “Ifayela” kubha yamathuluzi eyinhloko.
2. Hamba kuzinketho.
3. Iwindi elisha lizovela lapho udinga ukuthola khona bese uchofoza "Okuthuthukile".
4. Kusele ukuthola into ethi "Lapho ubala kabusha le ncwadi", beka isiphambano eduze komugqa "Setha ukunemba njengasesikrinini." Qinisekisa izinguquko, londoloza izilungiselelo.

Inqubo ye-Excel 2007:

1. Ephaneli eliphezulu elinamathuluzi espredishithi avuliwe, thola isithonjana se-“Microsoft Office”, chofoza kuso.
2. Uhlu kufanele luvele esikrinini, lapho udinga ukukhetha khona into ethi "Izinketho ze-Excel".
3. Ngemva kokuvula iwindi elisha, iya kuthebhu "Okuthuthukisiwe".
4. Ngakwesokudla, yiya eqenjini lezinketho “Lapho ubala kabusha le ncwadi”. Thola umugqa "Setha ukunemba njengasesikrinini", setha isiphambano phambi kwawo. Londoloza izinguquko ngenkinobho ethi "KULUNGILE".

Inqubo ye-Excel 2003:

1. Thola ithebhu "Isevisi" kubha yamathuluzi eyinhloko, ngena kuyo.
2. Kusukela ohlwini oluvelayo, yiya engxenyeni ethi “Izilungiselelo”.
3. Ngemuva kwalokho, kuzovela iwindi elinezilungiselelo, lapho udinga ukukhetha "Izibalo".
4. Kusele ukumaka ibhokisi eliseduze nepharamitha ethi "Ukunemba njengakusikrini".

Isiphetho

Uma ufunda ukusetha ukunemba kokuzungeza ku-Excel, lesi silungiselelo sizokusiza wenze izibalo ezidingekayo lapho, ngokwemibandela, yilawo manani ezinombolo kuphela uXNUMXbuXNUMXb acabangela idijithi eyodwa ngemuva kwephuzu ledesimali engacatshangelwa. Kodwa-ke, akufanele sikhohlwe ukuyivala ezimweni ezijwayelekile, lapho izibalo kufanele zibe nembe ngangokunokwenzeka, kucatshangelwa zonke izinombolo.