Ukuguqula iileta ukuba ibe ngamanani. Ngaba kuye kwafuneka ukuba ukope amanani ukusuka kwifayile enye ukuya kwenye uze ubalekele kwiingxaki zokubala okanye ungqubano kulungelelwano lwedatha njengoko isoftware ibaphathe ngokuchanekileyo kwaye ifomatiwe njengombhalo, emva kokudlulisa, endaweni yokuba amanani? Ngaba ukhe wasebenza kwiprojekthi edinga ukuguqula iileta zibe ngamanani kanambambili kwaye awazi ukuba ungayenza njani? Ndiyabheja ewe, kuba ulapha kwaye ufunda esi sikhokelo indlela yokuguqula oonobumba kumanani Nangona kunjalo, akukho ngxaki: nokuba ungumfundi, uchwepheshe okanye unomdla olula, ngoku ndiza kubonisa amanyathelo okufikelela kwisisombululo esilungele wena.
Ngokubhekisele, amanani akhutshelwa kwiphepha lokusebenzela ngamanye amaxesha afayilishwa kwiiseli ngokungathi zingumbhalo. Olu hlobo lwengxaki luhlala lwenzeka xa ungenisa idatha kwimithombo yangaphandle, mhlawumbi ngenxa yokuba yayifomathiwe ngendlela eyahlukileyo. Kule meko, amanani afomathiweyo njengombhalo atshintshiwe asekhohlo kwaye ayilunganga kwiseli, kwaye ahlala eboniswa sisalathiso sempazamo. Nangona kunjalo, yingxaki elula ukuyicombulula.
Ngokuphathelele iiprojekthi ezibandakanya unyango lwe iinombolo zebhambari okanye ukufihlwa kombhalo oguqula oonobumba ukuba babe ngamanani, izisombululo ezikhoyo kuwe zininzi kwaye kulula ukuzamkela. Masihambe kunye ukuze siqonde indlela yokwenza.
Index
Ungawaguqula njani amagama abe ngamanani kwi-Excel
Ngaba unengxaki yokukhuphela amanani ukusuka kwelinye iphepha ukuya kwelinye njengoko amanani, sele edluliselwe, ngaba akwifomathi yokubhaliweyo? Ndiza kukuchaza indlela yokusombulula le ngxaki ngeendlela ezahlukeneyo usebenzisa IMicrosoft Excel. Yinkqubo yespredishithi eyaziwayo ebandakanyiweyo kwiphakheji yeOfisi (kodwa ikwakhona kwinguqulo emileyo kwiWindows nakwiivenkile zeMacOS) kwaye iyahambelana Windows kunye neMacOS.
Inguqu ngokujonga impazamo
Indlela yokuqala yokusombulula ingxaki endiphakamisa ukuba isekwe kuyo Ukujonga imposiso qhubeka ngokugqwesileyo, okwangoku ufumaneka kuphela kwiinguqulelo desktop isicelo
Njengoko sele uqaphele, amanani agcinwe njengombhalo alungelelaniswe ngasekhohlo kweeseli ezizodwa. Emva koko khetha iseli okanye iiseli ofuna ukuguqula, ucofe i icon kunye uphawu lophawu ecaleni kwenani, kwaye kwimenyu eyehlayo ebonakalayo, cofa Guqula kwinani.
Ukuba olu khetho alukho, khetha iseli okanye iiseli zokuguqula (okanye ikholamu yonke, ukuba ikho imfuneko; into ebalulekileyo kukuba zonke iiseli ezikhethiweyo zikwikholamu enye), kwithebhu data ebekwe phezulu ekunene, cofa iqhosha Okubhaliweyo kwimiqolo. Kwifestile evelayo, cofa ngoko nangoko kwiqhosha. finalke ukuba uyasebenzisa iifestile cinezela iqhosha Ctrl kunye neqhosha 1.
Ukuba kwelinye icala sebenzisa a IMac, cinezela iqhosha myalelo kunye neqhosha 1. Ukusuka kwifestile evelayo, ebizwa Iiseli zefomathi, khetha udidi ekhohlo inaniEmva koko bhala kwibhokisi ephakathi Iindawo ezintle Ufuna ukubona kwaye ekugqibeleni kwibhokisi engezantsi yefomathi yokubonisa Amanani angalunganga. Xa uqinisekile ukuba wenze ngokufanelekileyo umboniso jikelele wamanani, cofa iqhosha Bueno, ezantsi ekunene.
Enye indlela yenkqubo esele ikhankanyiweyo (ikwasebenza Excel kwi-intanethi ) kukuvula kwikhadi ekhaya Imenyu eyehlayo esezantsi ngokucinezela utolo ngasekunene kwamagama jikelele, emva koko ukhethe ukhetho lokugqibela Ezinye iifomati zamanani. Ukususela ngefestile Ifomathi yenani ukuvula, khetha inqanaba lasekhohlo inaniUkwenza ngokwezifiso inani eliqhelekileyo kubonisiwe njengoko kunqwenelwa kwidesktop. Okokugqibela cofa Bueno, ezantsi ngasekunene, ukuguqula iseli efunekayo okanye iiseli zibe ngamanani.
Ukuba usebenzisa i-Excel ngokusebenzisa usetyenziso Android kweyakhe ifowuni, Cinezela endaweni yoko utolo ibekwe ezantsi ngasekunene (ukuqinisekisa ukuba imenyu ekhohlo isetiweyo ekhaya ), okanye ukuba isebenza njengecwecwe, cofa kwithebhu ekhaya ibekwe ngaphezulu. Emva koko skrolela kuzo zonke iindlela uze ukhethe ufikelele kumhlathi Ifomathi yenaniCinezela kwaye uchukumise inani, icacisa indlela ofuna ukubonisa ngayo amanani amabi
Sebenzisa i-Excel usetyenziso kwi iOS okanye i-iPadOS, kuya kufuneka uye kwicandelo ekhaya (ngokusebenzisa imenyu esezantsi kwe iPhone okanye isithuba phezulu iPad), cinezela iqhosha ABC123 ibekwe ngezantsi kweqhosha vista kwaye ekugqibeleni ukhethe ukhetho inani.
Inguquko nge «Ixabiso» umsebenzi
Njengolunye uhlobo lwento esiyibonileyo kwisahluko esudlulileyo, ungasebenzisa ifomula yomdabu yase-Excel ukuguqula oonobumba babe ngamanani: yeyona Ixabiso lomsebenzi, ebuyisela ixabiso lenani lesicatshulwa esingenisiweyo. Le nkqubo ilandelayo isebenza kuzo zombini iinguqulelo zedesktop kakhulu i Excel kwi-intanethi, ngelixa yahlukile kwi iinguqulelo ezihambayo.
Okokuqala faka ikholamu entsha ecaleni kweeseli ezinonobumba oza kuguqulwa ngokunqakraza iqhosha le mouse kwileta yokuchonga ikholam, emva koko ukhetha ukhetho ngena kwimenyu eyehlayo. Qiniseka ukuba ungenzi enye entsha ofuna ukuyiguqula; Ngaphandle koko ifomula ayinakusebenza.
Ngaphakathi kwiseli kwikholamu entsha, thayipha igama = IXABISO () kwaye emva koko, ukubeka isikhombisi semouse phakathi kweebakaki ezimbini, cofa kwiseli enexabiso ofuna ukuliguqulela kwifomathi yamanani (kule meko, iseli E3); ireferensi yeseli kufuneka ivele phakathi kweebakaki ezimbini. Okokugqibela cinezela u-Enter ukuze ixabiso ekugqibeleni libonakale kwifomathi yamanani.
Hambisa isikhombisi semouse kuyo ikona esezantsi ngasekunene iseli esandula ukuguqulwa, kude kube kuthatha uhlobo lwe kunye nophawu (+) : Cofa kwaye uhudule phantsi, usebenzisa i iqhosha lemouse lasekhohlo, ngaloo ndlela kuphindwe kwifomula kwiiseli ezingezantsi.
Okwangoku, uya kufumana ikholam entsha yamaxabiso ngendlela yokubala; ungazisebenzisa ngokuthe ngqo, okanye ungazikopa kwaye uzincamathisele kwikholamu yantlandlolo ngokulula kwakho.
Ukuba ufuna ukuzikopa kwikholamu oqale kuyo, Khetha iiseli ugcwalise nje ngexabiso lomsebenzi, cinezela Ctrl kunye neqhosha C ( myalelo kunye neqhosha c, ukuba usebenzisa iMac), cofa kwiseli yokuqala ikholamu yoqobo. Kwi inguqulelo yedesktop khetha ikhadi ekhaya, kwikona ephezulu ngasekhohlo, emva koko ucofe utolo kufutshane neqhosha Namathisela, khetha umba wokugqibela kwimenyu eyehlayo Cola okhethekileyo kwaye ukhethe intsimi xabiso, phezulu ngasekhohlo, ekugqibeleni ngokunqakraza amkele ngaphakathi inguqulelo ekwi-intanethi khetha ikhadi ekhaya, ngasentla ngasekhohlo, cofa u- utolo phantsi kweqhosha Namathisela kwaye ukhethe ngokuthe ngqo Ncamathelisa amaxabiso.
Kwimeko ukuba usebenzisa i Uhlobo lwe-Android lwe-Excel, faka ikholamu entsha ecaleni kweeseli eziqukethe iileta, uchukumisa ikholamu esele ikho ngaphandle kwale eguqulwayo, yiya kwicandelo Indlu, cinezela Faka kwaye ucimeemva koko uchukumise faka iikholamu
Ngoku cofa kabini kwiseli kwikholamu entsha, chwetheza igama usebenzisa i ikhibhodi ngamanani = IXABISO (), beka ikhesa phakathi kweebakaki ezimbini zesikwere, cinezela iseli ngexabiso lokuguqula kwaye ekugqibeleni uchukumise iqhosha ngokukhombisa. green phezulu ekunene. Phinda le misebenzi ingentla ngokukodwa kwiseli nganye ofuna ukuyiguqula, ude ufumane ikholamu entsha yamaxabiso ngendlela yokubala.
Ukuba ufuna ukuzikopa kwikholamu yokuqala, khetha iseli yokuqala osandula ukuguqula, emva koko bonke abanye ngokudonsa ichaphaza eluhlaza ezantsi ngasekunene kwesisele kuyo yonke ikholamu; kwimenyu eza kuvula, khetha ukhetho ikopi (imelwe kunye amaphepha amabini ecaleni ). Emva koko cofa kabini kwiseli yokuqala, khetha utolo olusezantsi ecaleni kwenkcazo kwimenyu evulayo, uze ukhethe ukhetho ixabiso.
Ukuba ungumsebenzisi endaweni yoko IOS / IPOS, ucofe ikholamu esele ikho ngaphandle kweyokuguqulwa, emva koko ukhethe ukhetho ngena. Cofa kabini kwiseli yokuqala yekholamu entsha, chwetheza igama ngekhibhodi = IXABISO (), beka ikhesa phakathi kweebakaki ezimbini ezisikwere, khetha iseli ukuguqula emva koko ucinezele iqhosha eliluhlaza elinophawu lokujonga ibekwe phezulu ekunene. Ukufumana ikholamu entsha ezaliswe ngamanani amanani, kuya kufuneka uphinde amabakala ngalinye elichazwe apha ngasentla.
Ukukhuphela amaxabiso amatsha kwikholamu yokuqala, cofa iseli yokuqala eguqulweyo, emva koko ukhethe bonke abanye, utsale ichaphaza eluhlaza ezantsi ekunene kwesisele ecaleni lonke ikholamu. Ukusuka kwimenyu eza kuvula, khetha ukhetho ikopi, emva koko ucofe isibini sokuqala, ukhethe ukhetho Cola okhethekileyo kwaye ekugqibeleni ukhetho ixabiso.
Inguquko usebenzisa i "Cola ngokukodwa" kunye no "Phinda" imisebenzi
Ukuba awukwazanga ukuguqula iileta ibe ngamanani kwi-Excel ngeendlela ezingasentla ngoku kunokuba zezakho kuwe - ziluncedo ikakhulu ekuguquleni iikholamu ezininzi ngaxeshanye.
Qala ukhethe enye iseli engenanto engabandakanyekanga kwingxaki yokuguqula, uhlobo iqhosha 1 ngaphakathi kwaye cinezela iqhosha okhoyo Awards Ctrl kunye neqhosha C ( myalelo nesitshixo c, ukuba usebenzisa iMac) ukuyikopa, khetha iiseli oza kuziguqula ukusuka koonobumba ukuya kwifomathi yamanani.
Ekhadini ekhaya, kwikona ephezulu ngasekhohlo, emva koko ucofe utolo ecaleni iqhosha Namathiselacofa kwinto yokugqibela Cola okhethekileyo, emva koko kwimenyu ukusebenza cofa ebaleni Ngokuphindaphindiweyo kwaye ekugqibeleni cinezela phezulu Bueno (ezantsi ngasekunene).
Ngokwenza njalo, uyalele i-Excel ukuba iphindaphindwe iseli nganye ngo-1, ngokuguqula oonobumba babe ngamanani. Ukuba ufuna ukutshintsha ifomathi yayo, cofa Ctrl kunye neqhosha 1 ( myalelo kunye neqhosha 1, ukuba usebenzisa iMac) ukuvula iwindow Iiseli zefomathi, khetha ifomathi oyikhethileyo kwimenyu udidi shiya okokugqibela kwaye nqakraza Bueno ezantsi ekunene.
Le ndlela ilungele uguqulelo. desktop Excel; ngaphezulu kweenguqulelo endaweni yoko kwi-intanethi, Android e iOS, ungasebenzisa ezi zikhokelo zilandelayo ngokusekwe kwisifundo sam sendlela yokuphindaphinda kwi-Excel.
Ungakhubaza njani ukukhangela kwempazamo
Ukuba xa ufaka inombolo kwiseli ubona a unxantathu oluhlaza kwicala elingasentla leseli ngokwayo, oko kuthetha ukuba ukukhangela impazamo kuyasebenza (ukusebenza kuphela kuhlobo desktop Excel). Ungamisa umboniso ngokukhetha umba wemenyu ngokubanzi iifomula, emva koko ucofe iqhosha Impazamo ekuqinisekiseni, emva koko kwiqhosha ukhetho, ezantsi ngasekhohlo, kwaye ekugqibeleni ususe itshekhi yento Amanani afomathwe njengesicatshulwa.
Guqula iileta ukuya kwiinombolo zebhambari
Ukuba ujonga endaweni Guqula iileta zibe ngamanani akwebhambithi,, ngenxa yolonwabo okanye umsebenzi, yazi ukuba kukho izixhobo ezininzi ezilungele le njongo: masifumanise ezona zinto zinomdla kwaye uya kubona ukuba uza kuyifumana elungele wena. Nokuba usebenzela kwiprojekthi ye-IT yokusika okanye ufuna ukufunda iziseko ze-binary crypto, ndiqinisekile ukuba uya kwaneliswa.
Guqula isicatshulwa sibe yibhinari (kwi-intanethi)
Ukuguqula isicatshulwa sibe yibhinari kuyinkonzo esebenzayo kwi-intanethi evumela ukuguqulwa koonobumba ibe ngamanani kanambambili. Ngokucofa kwikhonkco endikunikileyo, uyakufika kwiphepha elungele ukufumana isicatshulwa ofuna ukusiguqula, ukuze sifakwe enkundleni Igalelo ledatha.
Okokuqala qinisekisa ukuba isixhobo guqula, embindini lwephepha, libekwe ngokhetho isicatshulwa kumanani mna (Njengoko unokuqikelela, ukhetho lwezinye iinombolo zebhini ezingaphezulu kokubhaliweyo lwenza into echaseneyo), ke thayipha ngesandla okanye ukhuphele uncamathisele oonobumba ofuna ukuguqula. Uya kuyiphawula kwangoko, kwicandelo elingezantsi. isalida, umbhalo owungenileyo waguqulwa ukuba ube yikhowudi yokubini.
Umguquleli weKhowudi yeKhowudi (i-Android)
Umguquleli weKhowudi yeKhowudi yenkonzo esebenzayo yokuguqula iileta kwiinombolo ezingamanani ezifumaneka kubasebenzisi Android Ukuba uchukumisa kwifowuni yakho okanye ithebhulethi yakho kwikhonkco elingasentla, uya kudibanisa ngokukhawuleza Play Store, ukusuka apho unokukhuphela usetyenziso ngokucinezela iqhosha faka.
Nje ukuba ufake kwifowuni yakho, cofa iqhosha vula Uya kujongana ubuso ngobuso noMguquli weKhowudi yeBhinary: jonga ukuba ukweliphi icandelo Isicatshulwa ukuya kwi-binary (eyokuqala ngasekhohlo) kwaye hayi kwi "Binary to text", ke chwetheza okanye uncamathisele isicatshulwa oza kusifaka kwi-binary. Xa ugqibile, cofa umyalelo encode Kubekwe emazantsi ngasekhohlo: Uya kuqaphela ngokukhawuleza isicatshulwa esiguquliweyo ngezantsi kwento oyibhalileyo ngoku.
Isicelo sinemiyalelo emibini eluncedo kakhulu: ikopi (ungayifumana kanye ecaleni kweKhowudi) ikuvumela ukuba ukope umbhalo oguqulweyo kwifayile yakho ye- ibhodi yokunamathisela kwaye uncamathisele ngesandla kwezinye iifowuni kwifowuni yakho ephathekayo, ngelixa isabelo (eyokugqibela ngasekunene) iphinda ikuncede ukwabelane ngokuthe ngqo ngekhowudi yakho yebhinari kunye nezinye iinkqubo ezifakiweyo.
Isicatshulwa esiya kwiBhinary
Isicatshulwa esiya kwi-Binary kwakhona sisixhobo esifanelekileyo sokuguqula iileta zibe ngamanani kanambambili, kodwa ezinikezelwe ngokukodwa kubasebenzisi abathanda ukusetyenziswa kwe-iPhone okanye i-iPad. Ukuyisebenzisa, cofa kwikhonkco endikunikezile, emva koko ucofe iqhosha Fumana / Faka de la Ivenkile yosetyenziso, qinisekisa isazisi sakho ngoku I-ID yobuso, Ukuchukumisa i-ID okanye iphasiwedi ye-ID ye-Apple (ukuba kukho imfuneko) kwaye ekugqibeleni ucofe iqhosha vula.
Ndiyakwazi ubhale kwangoko into oyithandayo kwibar ebekwe phezulu, nokuba kunyanzelekile ngokukopa kunye nokuncamathisela isicatshulwa sesinye isicelo esisetyenziswayo. Usenokuba uqaphele ukuba usetyenziso luguqula into oyichwethezayo ngexesha lokwenyani, ke akukho mfuneko yokuba wenze igalelo okanye wenze eminye imisebenzi-elula, akunjalo?
Ungayikopa ngokulula ikhowudi ebini onayo, usebenzisa umyalelo Khuphela kwibhodi eqhotyoshwayo ibekwe nje ngezantsi kwesicatshulwa esiguquliweyo. Uya kuba nesiqinisekiso sokuba uyikope ngokuchanekileyo ukuba ukuvela kubonakala ngomyalezo obhaliweyo Ikopishwe ngempumelelo kwibhodi eqhotyoshwayo.