Guqula inqaku libe kwindawo yokugqibela kwi-Excel

I-Excel sisixhobo esibalulekileyo kuyo nayiphi na ingcali esebenza ngamanani kunye nedatha. Nangona kunjalo, ngamanye amaxesha sibalekela kumqobo omncinci: umahluko phakathi kokusebenzisa ixesha okanye isiphumlisi ukwahlula idesimali. Ngokuxhomekeke kwindawo yakho okanye ukhetho lobuqu, kunokufuneka utshintshe lo mahluli kwi-spreadsheets zakho. Kule tutorial, siya kukukhokela inyathelo ngenyathelo ukuze wenze olu tshintsho ngokulula nangempumelelo.

Ngaphambi kokuqala, kubalulekile ukugxininisa ukuba i-Excel ikuvumela ukuba usebenze ngazo zombini inqaku njengakwinqaku lokugqibela, kodwa hayi ngaxeshanye. Ukuba i-spreadsheet sakho simiselwe ukuba sisebenzise iikoma, awuzukwazi ukusebenzisa amaxesha, ngokuphendululekileyo. Oku kunokubangela iimpazamo xa usenza iifomula okanye iigrafu ukuba ufaka ngempazamo isimboli engalunganga. Ukongeza, xa ungenisa i-spreadsheets kweminye imithombo, ungadibana nesahluli sedesimali esahlukileyo kuneso usidingayo.

Uyitshintsha njani inqaku ukuya kwinqanaba lokugqibela kwi-Excel

Ukwenza olu tshintsho, kuyacetyiswa ukuba usebenzise inguqulo ehlawulweyo ye-Excel, ngokukhethekileyo emva kwe-Excel 2000. Ukuqala nge-Excel 2007, i-interface yeprogram iye yahlaziywa ngokupheleleyo, ngoko ke imiyalelo ingahluka kancinci kwiinguqulelo zangaphambili.

Ngaphambi kokuguqula i-spreadsheet yakho, kubalulekile ukuba yenza ikopi yogcino lwedatha yakho. Unokusebenzisa ii-hard drives zangaphandle okanye iinkonzo zokugcina ilifu ukuze uqinisekise ukuba unenguqulelo ekhuselekileyo yomsebenzi wakho kwimeko yazo naziphi na iziganeko ezingalindelekanga.

Jonga umahluli wokugqibela

Ukujonga ukuba yeyiphi idecimal umahluli inguqulelo yakho ye-Excel esetyenziswayo, landela la manyathelo:

1. Cofa ekunene kwiseli engenanto.
2. Khetha i "Ifomathi yeSeli" ukhetho.
3. Kwithebhu ethi "Inombolo", khetha icandelo elithi "Inombolo".
4. Apha ungabona i inani elimiselweyo leedesimali kwaye ukuba inguqulelo yakho yeExcel isebenzisa iikoma okanye amanqaku edesimali.

Guqula umahluli wokugqibela

Nje ukuba uchonge umahluli wedesimali yangoku, lixesha lokuyitshintsha. Landela le miyalelo:

1. Yiya kwi "Fayile" menu kwaye ukhethe "Options." Kwiinguqulelo ezindala ze-Excel, ukhetho lwe-"Options" lubekwe kwimenyu ye-"Tools".
2. Fumana icandelo elithi "Ekuqhubekekayo".
3. Khangela icandelo elithi "Decimal Separator".
4. Kwibhokisi ehambelanayo, tshintsha indawo ukuya kwinqanaba lokugqibela, okanye ngokuphendululekileyo, ngokweemfuno zakho.
5. Cofa "Kulungile" ukugcina utshintsho.

I-Excel iyakusebenzisa ngokuzenzekelayo umahluli omtsha wedesimali kuzo zonke iiseli eziqulethe amanani edesimali kwi-spreadsheet sakho.

Izinto ezilungileyo zokusebenzisa isahluli sedesimali esichanekileyo

Ukusebenzisa isahluli sedesimali esichanekileyo kwispredishithi sakho se-Excel kunezibonelelo ezininzi:

• Ziphephe iimpazamo kwiifomula kunye neegrafu ngokufaka ngempazamo isimboli engalunganga.
• Ukuququzelela ukuhambelana nezinye iinkqubo okanye iinkqubo oko kunokufuna umahluli othile wokugqibela.
• Ivumela ukufundwa okucacileyo nokungaguquguqukiyo kwamanani edesimali, ngakumbi ukuba wabelana ngespreadsheets zakho nabanye abantu.

Ukongeza, xa ungenisa idatha evela kweminye imithombo, ukuqinisekisa ukuba unomahluli wedesimali ofanelekileyo kuya kongela ixesha kunye nomzamo wokuphonononga kunye nokulungisa amanani.

Lungiselela idatha yakho kwi-Excel ngokutshintshela kumanqaku edesimali

Kubalulekile ukuqaphela ukuba ukutshintsha isahluli sedesimali kwi-Excel akuyi kuchaphazela amanani osele uwafakile kwi-spreadsheet sakho. Ukuba ufuna ukuhlaziya iidesimali ezikhoyo, kuya kufuneka uyenze ngesandla okanye usebenzise i Ifomula yokubuyisela.

Kwakhona, khumbula ukuba olu tshintsho luya kusebenza kuzo zonke iispredishithi ezintsha ozenzayo kwi-Excel. Ukuba ufuna ukusebenzisa isahluli sedesimali esahlukileyo kwiprojekthi ethile, kuya kufuneka uyilungise kwakhona kwiinketho zenkqubo.

Ukutshintsha ixesha ukuya kwinqanaba le-decimal kwi-Excel yinkqubo elula kodwa ebalulekileyo yokugcina ukungaguquguquki kunye nokuphepha iimpazamo kwi-spreadsheets zakho. Ngokulandela la manyathelo achazwe kwesi sifundo, uya kukwazi ukuhlengahlengisa i-Excel kwiimfuno zakho kunye nezinto ozikhethayo, kwaye usebenze ngokufanelekileyo ngamanani edesimali. Ungalibali ukwenza ugcino lwedatha yakho phambi kokuba wenze naluphi na utshintsho, kwaye ukonwabele ubhetyebhetye olunikezelwa sesi sixhobo sokubala sinamandla.