Njengoko "Eksele" endaweni ingongoma comma? Qwalasela Excel

Ukubanjwa sebenzisa umyalelo ezikhoyo zinto, abazikhathazi kangako into yokuba umntu uyakwazi ukuphila phantsi kwezinye imithetho. Enyanisweni, oku asitsho UDalai Lama, kwaye inkcazelo enye yeengxaki ofisi ezinokubangela isicwangciso zengingqi Excel. kubume bayo usendleleni yokuba kumazwe amaninzi, nkqu usebenzisa neenyumerali ezifanayo Arabic, inani idla ebhaliweyo noko ngolunye uhlobo. Umzekelo olothusayo lobuninzi kwalo mahluko, oko kukhokelela iingxaki, na umqondiso wokuba ukuluma inxalenye iqhezu yonke. ERashiya, yaye okunene kwindawo eyayisakuba yiSoviet, oko kusoloko ikoma, kodwa kumazwe Western - ingongoma.

Intsingiselo lwesigama Excel

Makhe sijonge indlela engathandekiyo imiphumo kungakhokelela phambi kwenkqubo "ephosakeleyo," okanye, kunokuba uthi, isinqandi ezingachanekanga. Kwiimeko ezininzi, inani equlathe ingongoma, Excel iya ukuchazwa njenge umhla, kwaye ngokufanelekileyo, endaweni "25.11" ufumana "25.noyab" cell.

Xa sisebenza kunye izixa ezikhulu data kwi itafile, awukwazi nangoko phawula le nguqu. Ngakumbi kuba yonke can be zonakaliswa. Umzekelo, "25.13 'iya kuhlala injalo. Njengoko sele mhlawumbi ukuyichaza ukuguquka kuya kuchaphazela kuphela ezo amanani leyo, ngaphambi okanye emva kokuba ingongoma la amanani ukusuka ku-1 ukuya 12 Yiyo le Uluhlu lisetyenziswa ukubhekisela iinyanga zonyaka kunye, ngoko, oko kubonwa mhla. Ukuba inani uya kuwa enye okanye ezimakhulu mabini, uya kuzibonakalisa ngokwayo ndedwa kubalo bakala.

indawo indawo

Kukho iinketho ezininzi ukubeka indlela iikoma kwi "Eksele". Sicinga kuphela elula kakhulu kwaye esebenzayo, enokusetyenziselwa yi na umsebenzisi, kungakhathaliseki kwinqanaba lokufunda nokubhala computer.

• Njengoko "Eksele" endaweni ingongoma ikoma, esebenzisa yoMgaqo-nkqubo? Ukuze wenze oku, yiya kwicandelo "Iparameters" Umhleli itafile kwaye yiya kwi "Advanced" menu. Kweli candelo, kufuneka ukususa ibhokisi yokukhangela phantsi "Sebenzisa sahluli inkqubo". Ngaloo uvula amanqaku amabini ezayo, uyakwazi ukutshintsha amanqaku kwisahlulo kwimfuneko ukusebenza data yakho.

• Njengoko "Eksele" endaweni ingongoma ikoma, esebenzisa intsebenzo yokusebenza nkqubo? In the Control Panel Windows kuya kufuneka ukuba ufumane kwicandelo "zoMmandla Iinketho Language." Njengoko kwi "Fomatha 'lwesithuba soqwalaselo window evulayo, atshintshele ukuya submenu" Izicwangciso Ezibhekisa phambili "tab kunye' Amanani 'ukutshintsha inxalenye wokugqibela ukuba kuyimfuneko.

• Njengoko "Eksele" ukubuyisela kwindawo isiphumlisi usebenzisa i "Fumana ze sako" function? Le menyu mhlawumbi uqhelene kubasebenzisi abaninzi, nokusetyenziswa kwayo ayifuni izimvo ezongezelelweyo. Eyona kuphela ebalulekileyo kuya kufuneka ukuba uyenze ukuze zibonakalisa ukuba kukho isidingo kwindawo pre-ukuhlelwa. Ukuba ngaba wenze lo msebenzi, "Excel" uya utshintshe zonke iingongoma ezikhoyo kwimakhishithi yaye ukuphelisa ukungalingani kwenye inxalenye etafileni, ungayifumana kwi enye.

Enye indlela endala kodwa esiqinisekisiweyo kukuba pre-replacement sahluli nangayiphi umhleli wokubhaliweyo elula. Abasebenzi "Iphetshan lokubhala" ukususela umgangatho weenkqubo Windows managers ukumelana nalo msebenzi. Indlela yokusebenza uyafana ndlela yokugqibela echazwe bubonakala ukutshintshwa elula kweempawu ngemihla umhleli wakho spreadsheet.

Umahluko kwi menu ye abandwendweli ofisi

Lweenkqubo kwisuti ofisi kwi Microsoft nenguqulo entsha nganye lilungiselelo ngandlel ezahlukeneyo izinto menu. Kwaba kunye Excel 2013. Ukongeza ukuyila iinguqu yachukumisa Umbala kunye ukubonakala icon kwi iribhoni umyalelo sele isukile umba "Nketho". Waya ezantsi kwi main menu yotsalo- phantsi kwi ecaleni inxalenye yawo.

Kuzo zonke ezinye iintshukumo umsebenzisi in Excel 2013 usebenzisa iingcebiso kwicandelo edlulileyo, fanekiso ngokupheleleyo ukusebenza kunye neenguqulelo ngaphambili. Emva kokuba uvule itshintshele useto menu, uya kufumana okomntu ujongano eziqhelekileyo.

Ngamafuphi, ngoko zonke iinguqulelo Office, kunye imibala eyahlukileyo kwinkqubo nganye iqulathe i parameters umba kwi bar. Ezi ziquka uguqulelo-2013 yaye zonke ezilandelayo, iinketho phambili ngakumbi.

imigibe

Ngoku, ukuqonda njengoko "Eksele" ithathwa indawo ikoma, ukumelana awohluke zendlela ezichazwe. Ukutshintsha useto indlela yokusebenza okanye imimiselo yenkqubo, Kakade ke, ukuba bakuncede kwimeko ngexesha elinye-imfuneko, kodwa uhlala kule imo ayisebenzi kamnandi kakhulu.

Kokukhona kungcono ngokwembono ukuba nokusebenziseka ukhangela data exchange ngexesha elinye-kwindawo efunekayo xa usebenzisa menu search. Kulo mzekelo, ukuba ningabaleki umngcipheko uhlaba idatha yazo ezinye iitheyibhile kwaye abangaboniyo ukulawula inkqubo sokutshintshwa Izahluli iqhezu.

kwifomati yokubhaliweyo nokubalwa

Ngaphandle bonke echazwe, kukho enye inkalo umdla umhleli itafile "Excel". Okubhaliweyo wangena uyihlele, ukuze agqalwe ulwazi yedijithali kwezinye iimeko. Iseli apho inani lokugqitha lizakugcinwa njengo kubhaliweyo, uya ziphawulwe unxantathu eluhlaza kwikona ephezulu ekhohlo. Xa ubajongile, yonke into ibukeka enesidima, amanani na nembono, kodwa iingxelo musa ukuya xa uzama ukuvelisa uqikelelo lwedatha iseli enjalo.

Ngoko ke, le theyibhile ekunene-ukukhangela kumnika isiphumo ephosakeleyo, ukuba uyibambile kubalo. Le ngxaki isonjululwe ngendlela rhoqo "Excel". Ukukhetha iseli kunye kwikona eluhlaza kufuphi supernatant kungabonwa uphawu lokhuzo kwi unxantathu omthubi. Ukunqakraza ku oko kuya kubangela i menu yentsingiselo encinane. Ngokukhetha it phezulu ukhetho "Guqulela kwinani", wena ngaphandle kwelahleko data, ukutshintsha imbono yabo.

Emva umsebenzi singqale hlobo, zonke izibalo ziya kwenziwa ngokuchanekileyo. Ukuze kukhawuleziswe ungakhetha ngaphezu kwesinye iseli onjalo, yaye ezikufutshane eziliqela yaye ngoko nangoko ukutshintsha izicwangciso zabo besebenzisa umongo menu.

Ekuphetheni

Kweli nqaku siyibuyisele iindlela zokusebenza ngok ngokwenene ukulungisa imifanekiso uhlobo lwe data yedijithali kwi "Excel". isicelo sabo practice kuya kukunceda ugcine luvo zakho kunye nexesha xa esebenza spreadsheet.