Ukulawula umsebenzi kwi-Excel

Anonim

Isityalo se-AutO kwi-Microsoft Excel

Xa uthayipha kumaxwebhu ohlukeneyo, unokwenza i-typo okanye wenze impazamo ngokungazi. Ukongeza, ezinye iimpawu kwikhibhodi ayikho, kwaye indlela eziqokele ngayo imixube ebandakanyiweyo, kwaye isebenzisa njani, ayinguye wonke umntu owaziyo. Ke ngoko, abasebenzisi bathabathela indawo enjalo ngokucacileyo, ngokoluvo lwabo, i-analouves. Umzekelo, endaweni yokuba "©" bhala "(c)", kwaye endaweni yoko "- (e). Ngethamsanqa, iMicrosoft Excel inenqaku lentengiselwano ethatha indawo ngokuzenzekelayo ithatha indawo eyiyo ngokuzenzekelayo ukuthotyelwa ngokuchanekileyo, kwaye ikwalungisa ezona mpazamo ziqhelekileyo kunye ne-typos.

Imigaqo yeGunya lokuSebenza

Kwimemori yenkqubo ye-Excel, ezona mpazamo zixhaphakileyo ngokubhala amagama zigcinwa. Igama ngalinye lenzelwe ukuthotyelwa ngokuchanekileyo. Ukuba umsebenzisi ungene kwinketho engalunganga, ngenxa ye-typo okanye impazamo, itshintshwa ngokuzenzekelayo sisicelo esichanekileyo. Le yeyona nto iphambili yombhali.

Ezona mpazamo ziphambili ezisusa lo msebenzi zibandakanya oku kulandelayo: Ukuqala kwesicelo esivela kwiileta ezisezantsi, oonobumba ababini abanobumba abalandelelanayo, i-typos engalunganga ye-CAPS kunye neempazamo.

Ukucima kwaye ukubandakanywa ngokuzenzekelayo

Kufuneka iqatshelwe ukuba ngokuzenzekelayo ipeni ye-Auto ihlala isebenza. Ke ngoko, ukuba uhlala okanye okwethutyana akadingi mntu, kufuneka unyanzelwe ukuba ucime. Umzekelo, inokubangelwa sisibakala sokuba uhlala ubhale ngabom amagama ngempazamo, okanye uchaze abalinganiswa abaphawulwe nge-Excel, njengento echanekileyo, kunye nentengiso ye-Auto rhoqo. Ukuba utshintsha isimboli olungiswe ngumbhali, kuye owufunayo, ke awuyi kuyilungisa ukuyilungisa. Kodwa, ukuba kukho okuninzi kwezi datha ongenayo, emva koko ubabhekise kubo kabini, ulahlekelwe lixesha. Kule meko, kungcono ukukhubaza umbhali okwethutyana.

  1. Yiya kwi "Ifayile" yethebhu;
  2. Yiya kwi-theb yefayile kwi-Microsoft Excel

  3. Khetha icandelo "Parameter".
  4. Tshintshela kwiiParemetros kwiNkqubo ye-Microsoft Excel

  5. Emva koko, yiya kwicandelwana "upelo".
  6. Yiya kwicandelo lopelo lweeparameter kwiNkqubo ye-Microsoft Excel

  7. Cofa kwi "Parameters ye-Auto".
  8. Inguqu kwiiParameter ezi-Auto kwiMicrosoft Excel

  9. Kwifestile yeparameter evula, sibona into "Faka xa ungenelelwa". Susa ibhokisi yokukhangela kuyo kwaye ucofe iqhosha "Kulungile".

Khubaza ukuguqulelwa ngokungazenzisiyo kwiMicrosoft Excel

Ukuze ujike kwakhona, ngokuzenzekelayo, sibeka i-tick back kwaye sicinezele iqhosha u "Kulungile" kwakhona.

Ukwenza i-Auto ikhuthaza kwiMicrosoft Excel

Ingxaki ngomhla womhla

Kukho amatyala xa umsebenzisi engena kwinani elinamanqaku, kwaye ilungiswa ngokuzenzekelayo ngomhla, nangona ingayifuni. Kule meko, ayikho kwaphela ukuba ingekayicini icime ngokupheleleyo umbhali. Ukuyilungisa, sabela indawo yeseli zeseli esiza kubhala ngamanani ngamanqaku. Kwithebhu yasekhaya, sikhangela ibhloko "yenombolo". Kuluhlu olusezantsi, olubekwe kule bhlokhi, setha "isicatshulwa".

Ukufaka ifomathi yokubhaliweyo kwiMicrosoft Excel

Ngoku amanani anamachaphaza awayi kutshintshwa yimihla.

Ukuhlela uluhlu lweentengiselwano ezizenzekelayo

Kodwa, emva kwayo yonke loo nto, umsebenzi osisiseko wesixhobo awuphazamisi umsebenzisi, kodwa ngokuchasene nokumnceda. Ukongeza kuluhlu lwamabinzana enzelwe umsebenzisi, umsebenzisi ngokwawo ungongeza okwalo ukhetho.

  1. Vula isiqhezu kuthi ngefestile yeeparameter zesityalo se-Auto.
  2. Kwindawo ethi "Shenxisa" intsimi, chaza iseti yabalinganiswa abaya kwakhiwa yinkqubo njengempazamo. Kwintsimi ethi "Kwi" ntsimi, bhala igama okanye uphawu lokufaka endaweni. Cofa kwiqhosha le-copt.

Ukongeza igama kwi-Microsoft Excel Dictionary

Ke, unokongeza ukhetho lwakho kwisichazi-magama.

Ukongeza, kwifestile enye kukho i-theb "yesicwangciso se-Auto se-Auto sofuba iimpawu zemathematics". Kukho uluhlu lwamaxabiso, xa ungena kwizimbo zemathematics, kubandakanya ezo zisetyenziswa kwifomula ye-Excel. Ewe, ayinguye wonke umsebenzisi oya kuba nakho ukufaka i-α (i-alpha) etyikitya ikhibhodi, kodwa nganye inokungena kwixabiso "\ Alfa", eliza kuguqulwa ngokuzenzekelayo ibe yisimboli efunekayo. Ngomfanekiso, iBeta (\ Beta) ibhaliwe, kunye neminye imiqondiso. Kuluhlu olufanayo, umsebenzisi ngamnye ungongeza ukuthotyelwa kwabo, njengoko kwakuboniswa kwisichazi-magama esiphambili.

Iimpawu zemathematics ezenzekelayo kwiMicrosoft Excel

Cima nakuphi na ukuthotyelwa kwesichazi magama nawo ulula kakhulu. Sibonisa ukuba into, ipeni ye-auto ayidingeki, kwaye icofe iqhosha elithi "Cima".

Ukususa intetho evela kwi-Automane kwiNkqubo ye-Microsoft Excel

Ukususwa kuya kuqwalaselwa kwangoko.

Useto oluphambili

Kwithebhu ephambili yeeparamitha ezizenzekelayo, useto ngokubanzi lweli nqaku. Iimpawu ezingagqibekanga zibandakanya ezi mpawu zilandelayo: Ukulungiswa koonobumba ababini abalandelelayo, ukubeka ileta yokuqala kwisicelo semali, igama leentsuku zeveki, ukulungisa umshicileli we-caps Kodwa, zonke ezi mpawu, njengabantu, zinokukhubazeka, zisusa nje ibhokisi yokukhangela kufutshane neeparamitha ezihambelanayo kwaye ucofe iqhosha "Kulungile".

Nqamla iiparameter ze-AUTO kwi-Microsoft Excel

Ngaphandle

Ukongeza, inqaku lentengiselwano le-Auto-Translation inesichazi-magama sayo esikhethekileyo. Inamagama kunye nabalinganiswa, ekufuneka zitshintshwe, nokuba iisetingi ngokubanzi zibandakanya umgaqo obonisa ukuba eli gama okanye intetho ixhomekeke ekutshintweni.

Ukuya kwesi sichazi magama, cofa iqhosha u- "PROSEPENOPENS ..." iqhosha.

Inguqu kwi-Exdings kwiMicrosoft Excel

Ivula iwindow engafaniyo. Njengoko ubona, ine-tabs ezimbini. Kokuqala kubo kukho amagama, emva kokuba inqaku lingekathethi ukuphela kwesivakalisi, kunye nenyani yokuba igama elilandelayo kufuneka liqale ngoonobumba abalandelayo. Oku ikakhulu kukusika (umzekelo, "hlasela."), Okanye iinxalenye zamabinzana azinzileyo.

Ngaphandle kwencwadi yokuqala yeMicrosoft Excel

Ithebhu yesibini ibandakanya okwahlukileyo apho kungekho mfuneko yokutshintsha oonobumba ababini abalandelelana. Ngokungagqibekanga, eligama elibonisiweyo kweli candelo lesichazi-magama yi- "CCLEAR". Kodwa, unokongeza inani elingenamda lamanye amagama kunye namabinzana, njengoko kubonakale ngokuzenzekelayo, indlela efanayo eyayixoxwe ngayo apha ngasentla.

Ngaphandle kwe-auto ekhuthaza oonobumba ababini beMicrosoft Excel

Njengoko ubona, i-auto-indiza sisixhobo esifanelekileyo esinceda ngokuzenzekelayo iimpazamo okanye i-typos eyenziwe xa kungeniswa amagama, oonobumba okanye amabinzana e-Excel. Ngoqwalaselo olufanelekileyo, eli nqaku liya kuba ngumncedi olungileyo, kwaye iya konga ixesha lokujonga kunye nokulungisa iimpazamo.

Funda ngokugqithisileyo