Kanjani ukuze ungeze Iyunithi Excel: izincomo, izibonelo

I "Excel" kusuka e-Microsoft Office - isipredishithi editor onamandla, okuvumela idatha hhayi kuphela esitolo e imigqa namakholomu, kodwa futhi zangisiza ekwenzeni izibalo eziyinkimbinkimbi bese ukuhambisa imiphumela ngefomethi sokuqhafaza.

Lesi sihloko sihlaziya ngokuningiliziwe indlela yokuqhuba emigqeni esisogwini ishidi ezivamile amabhuku ngaphakathi ipuleti eziklanyelwe, futhi ngesikhathi esifanayo funda indlela ukubeka ikholomu Excel-irowu. Njengoba isizathu sithatha 2007 Microsoft Office ukukhululwa.

Izinhlobo imisebenzi wezintambo "Excel"

Imisebenzi etholakalayo ziyasetshenziswa imigqa is kunalokho kungagcini (hhayi othinta imibuzo format nekhophi):

• Ukukhetha;
• namathisela;
• nokusula;
• ukufuduka;
• transposition.

Ake sibone ngaziphi izindlela ukuze sixazulule lezi zinkinga in the "Excel 2007", futhi ukuze uqale nge, njengenkulumo evelele Excel umugqa.

ka Ukufiphaza

Isikhathi esining impela, uhlelo abasebenzisi 'Excel' kudidaniswe elithi "Gqamisa" ukukhethwa ethile oyifunayo ukuba ibanga lamaseli.

Esikhathini "Excel 2007" umugqa etholakalayo ehlanganisa 16.384 amaseli, kanye ukugqamisa kwaso, chofoza inkinobho kwesokunxele kwanele uchofoze kwezihloko olunezinombolo, wahlela thwi emaphethelweni kwesokunxele ishidi.

Uma udinga ukwaba ezimbalwa kuphela imigqa namaseli, ulandele Ukukhetha, ucindezele inkinobho yesinxele. Noma ungathola kunoma iyiphi iseli, cindezela bese ubamba u-Shift + Ctrl ukhiye bese, ngaphandle ukukhulula khona, cindezela umcibisholo "kwesokudla" noma "elivulekile ngomqondo", kuye ngokuthi yiziphi indlela kuthanda ukukhethwa.

Isexwayiso! Nazi ezinye umehluko wemisindo nemiqondo yamagama. Uma yonke imigqa kuseli elikhethiwe alinalutho noma egcwele idatha ke uphawu emgqeni ngokushesha ngaphambi kokuphela ishidi, isb. E. kuseli inombolo 16, 384. Uma kwakuba khona "iphethini igebe" (wonke amaseli ayengenalutho futhi ugcwale wahlangana, noma okuphambene nalokho) , ukukhethwa siphela kuseli "ohlukaniswa" futhi yena, futhi, kuzoya esikhethiwe. Ngakho-ke, ukuhlanganiswa okhiye «Shift + Ctrl Left / Right" Kufanele uqaphele.

Manje vula kanjani ukwengeza irowu Excel.

Ifaka umugqa omusha

Good ukwazi! Ulayini "Eksele" njalo wanezela ngesikhathi isihlobo phezulu yeseli akhethiwe (s), amakholomu - kwesokunxele.

Isinyathelo One. Gqamisa iseli noma ububanzi bamaseli, noma sonke string lapho uhlela ukwengeza umugqa omusha.

Isinyathelo Sesibili. Wasebenzise kahle amathuba ezingxoxo yokukhetha omunye imisebenzi emibili:

• Ngokucindezela inkinobho yegundane kwesokudla ukuvula imenyu yengqikithi, okuyinto Ungaya "Faka" bese usebenzisa izinkinobho zomsakazo ukuze ukhethe 'string'. Chofoza u- "KULUNGILE", bese phezu kweseli yakho ekhethiwe (s) kuyoba umugqa omusha, ezingenalutho ngokuphelele.
• On the "Ekhaya" ukunqamulela iribhoni umqulu eqenjini "Amaseli" - "Faka" - ". Imigqa Faka eshidini"

Uqedile!

Njengoba ubona, emva ukuqaliswa lezi zincomo uthola idatha yakho umugqa omusha ngokuphelele nalutho.

Ngakho, indlela ukuze ungeze Iyunithi Excel, siyazwisisa.

Ukususa umugqa

Njengomhlaba umugqa omusha sifakwe, nokususa ngokwanele ukwenza izenzo ezimbili nje.

Isinyathelo One. Wena ukugqamisa umugqa ufuna ukukhipha, noma uma sikubeka kalula isikhombisi kwakho kunoma iyiphi iseli emgqeni ukuthi ongasakudingi.

Kubaluleke kakhulu! Kungakhathaliseki ukuthi usuthole iseli noma ububanzi izosuswa yonke umugqa yencwadi ngokuphelele - okungukuthi, endabeni le "Excel 2007" kuyinto cell ne 1st 16384 th. Uma ufuna ukususa idatha yakho kusukela cell, kwanele ukusebenzisa ngemuva kokukhetha inkinobho Susa phezu ikhibhodi.

Isinyathelo Sesibili. Ongakhetha kuzo:

• Ukucindezela inkinobho yegundane kwesokudla ukuze uveze imenyu yokuqukethwe, okuyinto ukuya "Susa", bese ngosizo wokushintsha ukhethe "Line". Cindezela u- "KULUNGILE", kanye string "curdle" njengokungathi yayingakaze.
• On the "Ekhaya" ukunqamulela ukuhambisa tape iqembu "Amaseli" - "susa" - ". Susa imigqa kusukela ishidi"

Ukuhambisa emgqeni

Yokuhamba emgqeni futhi, kakhulu ukuqonda ukunyakaza ezahlukene elincane ezithile amaseli. Kodwa kulokhu la ongakhetha Isimiso yesenzo lihlukile.

Khetha ulayini iyonke noma amaseli zayo ngazinye. Khona-ke hambisa isikhombisi ukukhethwa esibonakalayo, isikhombisi kufanele ushintshe futhi athathe isimo imicibisholo etshiyeneyo. Cindezela kwesokunxele inkinobho yegundane ukuba "uthwebule" amaseli akho, ukudlulela wendawo omusha oyifunayo bese uyekela. Uma indawo lapho ukuhambisa, kwakuvele egcwele noma iyiphi idatha, ngeke ngokuzenzakalelayo sithenjiswe esikhundleni okuqukethwe kuhlose amaseli.

imigqa ulimi

Abasebenzisi abaningi kukhona "Excel" ukuqonda ngokushesha kangakanani ukuze ungeze Iyunithi Excel, kanjani ukuhambisa noma ukukopisha, kodwa transposition kuseyimpicabadala kwabaningi, kanye ukuba khona kwezinceku umsebenzi onjalo ohlelweni.

Transposition umugqa - inqubo ekuguqulweni ovundlile set mpo amaseli. Ngenxa yalokho, transposition ikholomu - yinqubo reverse.

Inketho, njengoba ukuguqulwa engenziwa ngo ezimbili:

• Khetha ibanga lamaseli komugqa eyodwa bese ulandela (ngokucindezela inkinobho yegundane kwesokudla noma inhlanganisela Ctrl + C). Ngokulandelayo, ume phezu cell lapho ungathanda ukuqala ikholomu yakho entsha idatha, vula imenyu umongo "Namathisela okukhethekile", lapho lokumaka "transpose". Uqedile! String yaphenduka ikholomu.

• Excel 2007 has isici esikhethekile - ". Transpose" Uma uya ukuguqula ibanga lamaseli ezinhlanu ingaphandle leli banga kutsi uphindze ugcizelele ncamashi ezinhlanu kumaseli, kodwa wahlela ikholomu. Chofoza uphawu "alinganayo" bese ubhala "Transpose." Vula abakaki futhi ukugqamisa ububanzi bakho, okuyinto aguqule. Vala ubakaki bese ucindezela Faka esikhundleni nje Shift Ctrl + Enter. Uqedile!

Kufanele kuqondwe ukuthi samuntu sokuqala (nge faka ezikhethekile) kungcono ngoba akasebenzisi ifomula. Uma usebenzise inketho yesibili, bese ususa yezinhlamvu yokuqala, uthola yonke zeroes esikhundleni namagugu abo.

Amathebula ngaphakathi ncwadi kanye nezici zabo

Ngaphandle ishidi ejwayelekile lemigqa namakholomu sikhona Excel ithebula. Zibhale ilula - ". Ithebula" nje ukhetha uhla lesifanele amaseli, bese kuthebhu "Faka" ukhetha Cabanga umehluko phakathi nezinqubo lemigqa yokusebenza ithebula ezinjalo emigqeni ezisebenza encwadini ezivamile.

Kuyaqondakala ukuthi ukwabiwa amaseli efanayo. Ukufaka noma ukususa imigqa kusuka kwimenyu yokuqukethwe izinto etholakalayo "Insert - Ithebula imigqa ngenhla" futhi "Susa - Imigqa kwetafula." Ngaphezu kwalokho, ungakwazi ukwengeza umugqa omusha, ngokumane ezihambayo isikhombisi cell elingezansi kwesokudla etafuleni bese ucindezela Tab.

Kukhona futhi nomehluko omncane kule nhlangano, kodwa isebenza kuphela izihloko. Uma ukhetha amaseli eyodwa noma ngaphezulu equkethe unhlokweni etafuleni, bese ulandela ukunyakaza kwabo, uzobona ukuthi idatha nje ukopishe bese iziqu zokuqala ngihlalé endaweni. Uma sizama yisa yonke etafuleni, khona-ke alikho izici, wathutha ngaphandle kwezinkinga.

Sithemba ukuthi phendla you zonke izimfihlo sendlela ungeze Iyunithi Excel, indlela yokususa, ethutha njalo futhi transpose umugqa.