Ufomato olunemiqathango e MS Excel - a icala kancinane yaziwa spreadsheet ethandwayo

Yentsapho iimveliso ofisi ze Microsoft Corporation phantsi Excel igama uthotho iziqhubekisi spreadsheet ezinamandla athandwa kakhulu zombini ngenxa eziqhelekileyo kubasebenzisi becomputer buqu kunye neengcali iprofayili elimxinwa apho awumiselayo enamandla izixhobo zecomputer zibe sisixhobo sele umsebenzi zemathematika elide, imifanekiso , kunye nezinye iinkcukacha manani.

Le imveliso software i nobuchwepheshe bolwazi eyenzelwe Ukusebenza ngobuchule iiseti data enkulu. Excel ivumela ukuba zokusebenzisa ngokucacileyo ngokusesikweni ukuphunyezwa iintlobo ngeentlobo zibalo ezifanayo, ngokunjalo ukwenza zokulungisa kakuhle ulwazi lwamanani obubhaliweyo imithamo emikhulu.

Umzekelo, ukwenza nkqi, oluchanekileyo kakuhle uhlalutyo wezemali, irhafu yengeniso, njl iimpawu eziphambili le software enamandla kudala kufundwe kakuhle ngabo bonke abachaphazelekayo. Kodwa Excel has a lot of iimfihlakalo namacebo ezaziwa kuphela kwisangqa elimxinwa lweengcali. Enye yezi amaqela ngasese ukuxhomekeka kolungiso. Lo msebenzi ubonelela uluhlu olubanzi kakhulu iimpawu ezingaqhelekanga.

Esi sixhobo, ebizwa i "ukuxhomekeka kolungiso" yenza kube lula ukufezekisa iziphumo ezinomdla kakhulu kunye namava uyadika iisethi zedatha eyothusayo ezibonwayo. Amathuba usebenzisa lo msebenzi ukusombulula iingxaki ezahlukeneyo kwaye zahlukahlukene kakhulu. ukuxhomekeka kolungiso ivumela ukunyanzelisa ifomati ethile iseli ngokungqinelana imixholo xa kwangaphambili iimeko. Olu hlobo ufomato kulula kwaye saka kakhulu zokuhlalutya iiseti data enkulu.

Ufomato kweMiqathango Excel, ngaphandle ubaxo, sisixhobo esinamandla ovula amathuba nanto yokusebenza spreadsheets yaye zikwavumela ukuba kubekho bahlole uluhlu yamanani owomileyo. Kubangel 'umdla eli thuba obungaqhelekanga ukujonga zonke iintlobo amaphepha ntetho. fomati kwemiqathango yenza kube lula ukufumana ngaphandle ezahlukahlukeneyo, imisindo evela data kuthotho lulonke. izinto ezibalulekileyo nayo shwaka kwimboniselo umhlalutyi ngayo. Oku kunokuba luncedo kakhulu kwi- processing of kwedatha yeenkcukacha-manani. Ufomato olunemiqathango e Excel 2007 ineempawu ezinika umdla eliphezulu, ezifana ukuthambeka umbala, lines data kukhuhlwe ezahlukeneyo, imifanekiso ezizodwa ezidityaniswe iiseli kwaye ikuvumela ukhethe ngokukhawuleza ukufumana unxibelelwano phakathi iziphawuli ezahlukeneyo.

Sebenzisa ukuxhomekeka kolungiso nalo ilula kakhulu - nje ezimbalwa konqakrazo kabini lwemouse. Masithi uyila itafile iiseli ezithile equlathe ezinye parameters. Kufuneka lokutshintsha imibala iseli fill ngokungqinelana utshintsho amaxabiso data wokwamanani akuzo. Umzekelo, ukuba iseli iqulatha inani elithabathayo, kuya ukugcwalisa ngokuzenzekelayo umbala obomvu, yaye ukuba ezakhayo - oluhlaza.

Ukuze wenze oku, kufuneka nje ukuba usebenzise i 'yokuFomatha "menu, nqakraza i umba apho i" ukuxhomekeka kolungiso ". Kulo iseli, oyimfuneko ukumisela ifomathi efunekayo, kufuneka luqaqanjisiwe. Kwibhokisi yencoko "ukuxhomekeka kolungiso" kufuneka ukhankanye imeko phantsi apho iseli kwaye utshintshe umbala nihluthe. Ngeqosha le "Indlela" okufanayo ibhokisi yencoko yababini ukuchaza ukubonakala oyifunayo.

Ukuba ufuna ukutshintsha ukufomatha iseli enye ukuya kwenye, kuxhomekeke data, ngoko kuyimfuneko ukuba babhenele kwi "indlela" lebhokisi yotsalo-phantsi uluhlu fomati olunemiqathango ekhohlo. Umgama phakathi iiseli Akukhathaliseki. Ifomula nako nayiphi: nangona ukubalwa ukubaluleka zamanani, nangona ixabiso nokwehla asethi. Ngokomzekelo, xa ufuna ukwenza, xa A1 lweeseli luvulekile phindwa ngo ezine, iseli ethile okanye iiseli ezininzi Ndizuze fill etyheli, ngoko, njengoko imeko, faka le fomyula ilandelayo: "= MOD (A1, 4) = 0." Emva koko sebenzisa iqhosha "Format" ukucacisa olifunayo fill umbala. Ngaphezu koko, uyihlele ukufometha nocolo ikhutshelwa iseli oyifunayo okanye ibanga.