Ukufometha okunemibandela e-MS Excel - nohlangothi elaziwayo elincane we-spreadsheet ethandwa

Umndeni imikhiqizo ehhovisi Microsoft Corporation ngaphansi kwegama Excel uchungechunge yespredishithi izilimi enamandla athandwa kakhulu kokubili abavamile abasebenzisi computer siqu nochwepheshe iphrofayela ewumngcingo okuyiwona lokhu lamathuluzi isofthiwe enamandla Sekuyisikhathi eside abe ithuluzi esisemqoka emsebenzini zezibalo, ihluzo , kanye neminye imininingwane kwezibalo.

Lo mkhiqizo isofthiwe kuyinto ubuchwepheshe Imininingwane eyenzelwe ukucutshungulwa professional enkulu amasethi wedatha. Excel ikuvumela ukuba ukushintsha futhi ngokucacile bahlele ukuqaliswa ezihlukahlukene computations efanayo, kanye ukwenza ngokucubungula ulwazi zezinombolo nobungokomtlolo e omningi.

Ngokwesibonelo, ukwenza analysis fast, enembile nokufanele ezezimali, intela, njll imphawu letibalulekile le software enamandla Sekuyisikhathi eside kahle ufundwa bonke abathintekayo. Kodwa-Excel has a lot of izimfihlo namasu eyaziwa kuphela kumbuthano ewumngcingo ongoti. Enye yalezi amaqembu imfihlo ukuhlela okunombandela. Lokhu umsebenzi inikeza uhlu olubanzi kakhulu izici engavamile.

Ithuluzi, ebizwa ngokuthi "ukuhlela okunombandela" kwenza kube nokwenzeka ukuba kuzuzwe imiphumela umnandi kakhulu futhi omuhle ezibukwayo isipiliyoni boring amasethi wedatha. The kungenzeka usebenzisa lo msebenzi ukuze uxazulule izinkinga ezihlukahlukene futhi zahlukahlukene kakhulu. Ukufometha okunemibandela ivumela ukuphoqelela yeseli format ezithile ngokuvumelana okuqukethwe lapho predetermined izimo. Lolu hlobo ukufomatha ekahle futhi zinengqondo kakhulu ekuhlaziyeni ezinkulu amasethi wedatha.

Ukufometha okunemibandela ku-Excel, ngaphandle ihaba, iyithuluzi elinamandla esivula amathemba engakaze yenziwe ukusebenza spreadsheet uvumele bahlole array lezinombolo ezomile. Kuhlaba umxhwele ngokukhethekile leli thuba engavamile ukubheka zonke izinhlobo isethulo amaphepha. ifomethi okunemibandela wenze kube lula ukuthola okuhlukile ahlukahlukene, kwakuphazamisa kusukela jikelele idatha chungechunge. Amathrendi ezibalulekile futhi lalizonyamalala le umhlaziyi sika. Lokhu kungaba usizo kakhulu esikhathini ukusebenza kwedatha kwezibalo. Ukufometha okunemibandela Excel 2007 inezici ezithile ezithakazelisayo eziphambili, ezifana umbala gradients, ezahlukene Ukufiphaza idatha imigqa, imifanekiso ekhethekile kunezelwa amaseli bese ikuvumela ukuba ngokushesha sihlaziye izinga esesithuthuke ngalo ukuxhumana phakathi izinkomba ezahlukene.

Sebenzisa ukuhlela okunombandela futhi silula - nje igundane izinkinobho ezimbalwa. Asithi udale ithebula kumaseli ezithile esiqukethe nemingcele. Udinga ukushintsha imibala yokugcwalisa cell ngokuhambisana ushintsho zezinombolo amagugu idatha equkethwe kuwo. Ngokwesibonelo, uma iseli iqukethe inombolo engenhle, kuyoba ugcwalise ngokuzenzakalelayo umbala zibomvu, uma omuhle - oluhlaza.

Ukuze wenze lokhu, nje udinga ukusebenzisa "Ifomethi" imenyu, chofoza nto lapho "okunemibandela Ukufometha". Kulesi cell, okuyinto edingekayo ukuze usethe ngefomethi oyifunayo, kufanele ezigqanyisiwe. Ebhokisini lengxoxo "okunemibandela Ukufometha" kuzomele ucacise isimo esitokisini futhi ukushintsha ngaphansi okuyinto umbala, nasutha. Nge inkinobho "Ifomethi" okufanayo ibhokisi lengxoxo ukuchaza ukubonakala oyifunayo.

Uma udinga ukushintsha nokufomethwa kwesinye isitokisi bazifake kwesinye, kuye ngokuthi idatha ke kubalulekile ukuba baphendukela "ifomula" kwesokunxele uhlu olwehlayo ibhokisi nezakhiwo okunemibandela. Ibanga phakathi amaseli akunandaba. Ifomula kungaba futhi iyiphi: yize ukubala ukubaluleka kwezibalo, nakuba ukubaluleka ukwehla kwentengo amafa. Ngokwesibonelo, uma ufuna, lapho A1 esitokisini iphindaphindeke ezine, iseli ethize noma amaseli amaningi aluthola yokugcwalisa phuzi ngalesosikhathi, njengoba isimo, faka le ndlela elandelayo: "= I-MOD (A1, 4) = 0." Khona-ke sebenzisa inkinobho ethi "Ifomethi" ukuze ucacise oyifunayo yokugcwalisa umbala. Ngaphezu kwalokho, ukukopisha ukufomatha nokunamathisela udluliselwa iseli oyifunayo noma ububanzi.