Umsebenzi weAkhawunti ye-Excel

Iakhawunti ye-operator ibhekisa kwimisebenzi ye-Excel. Umsebenzi wayo ophambili kukubala uluhlu lweeseli eziqulathwe kwidatha yamanani. Masifunde ngakumbi ngakumbi kwiinkalo ezahlukeneyo zokusetyenziswa kwale forala.

Ukusebenza ngeakhawunti yomqhubi

Iakhawunti yomsebenzi ibhekisa kwiqela elikhulu labasebenzi beenkcukacha-manani, kubandakanya malunga namakhulu ezinto. Isondele kakhulu kuyo kwimisebenzi yakho umsebenzi weakhawunti. Kodwa, ngokuchasene nomxholo wengxoxo yethu, ithathela ingqalelo iiseli zefowuni zizaliswe yinkcukacha. Iakhawunti ye-operator ekufuneka siziphathe ngendlela eneenkcukacha sikhokelela kwiiseli ezizaliswe yidatha kwifomathi yamanani.

Yeyiphi idatha ehambelana nenombolo? Ngokuqinisekileyo oku kuphakathi kwamanani okwenyani, kunye nomhla kunye nexesha lexesha. Amaxabiso emxholo ("Inyaniso", "Lala", njl.njl) Iakhawunti yomsebenzi ithatha ingqalelo kuphela xa zichanekile ngokuchanekileyo. Ukuba bakwindawo yephepha, ebizwa ngokuba yingxoxo, emva koko kule meko umqhubi akaziphenduli. Imeko efanayo nommeli obhaliweyo wamanani, oko kukuthi, xa amanani abhalwe kuyo iikowuteshini okanye ejikelezwe zezinye iimpawu. Apha, kwakhona, ukuba ziingxabano ezingqalileyo, zithatha inxaxheba kubalo, kwaye ukuba zikwiphepha, azamkeli.

Kodwa ngokunxulumene nesicatshulwa esicocekileyo apho amanani angabikho khona, okanye amabinzana aneempazamo ("# yamatyala / 0., # Imeko yahlukile. Amaxabiso anjalo Iakhawunti yomsebenzi ayithathi ingqalelo nangayiphi na indlela.

Ukongeza kwimisebenzi, i-akhawunti kunye neakhawunti ibala inani leeseli ezaliswe zibandakanyekile kubaqhubi beziimitha kwaye zibaliwe. Sebenzisa ezi fomula, ungabala ngeemeko ezongezelelweyo. Eli qela labasebenzi beenkcukacha-manani linikezelwe kwisihloko esahlukileyo.

Isifundo: Indlela yokubala inani leeseli ezaliswe zigqogqe

Isifundo: Imisebenzi yeenkcukacha-manani

Indlela yoku-1: Inkosi yemisebenzi

Ngomsebenzisi ongenamava, kulula ukubala iiseli ezinamanani usebenzisa inqaku usebenzisa i-Wizard yomsebenzi.

1. Cofa kwiseli engenanto kwiphepha apho iziphumo zobalo ziya kubonakala. Cofa kwiqhosha "Colas Fun".

   

   Kukho enye indlela yokuqalisa i-wizard yemisebenzi. Ukwenza oku, emva kokukhethwa kweseli, kufuneka uye kwithebhu "yefomula". Kwiteyiphu kwi-"yethala lencwadi yomsebenzi" ye-Toolbar, cofa kwiqhosha "Cola Compay".

   

   Kukho enye inketho, mhlawumbi elula, kodwa kwangaxeshanye efuna imemori elungileyo. Sibonisa iseli ephepheni kwaye sicinezele umdibaniso ophambili kwi-Shift + F3 ikhibhodi.

2. Kuwo onke amatyala amathathu, i-Master Connit Window iya kuqala. Ukuya kwifestile yeempikiswano kwicandelo "le-farimocical" okanye "i-alfabhethi epheleleyo ye-alfabhethi" Sikhangela i-Akhawunti ". Siyibalaselisa kwaye ucofe iqhosha "Kulungile".

   

   Kwakhona, iwindow yempikiswano inokusungulwa ngenye indlela. Sibonisa iseli ukubonisa umphumo kwaye uye kwi-formoulas "ithebhu. Kwi-ribbon kwi "umsebenzi wethala leencwadi", cofa iqhosha "lenye imisebenzi". Ukusuka kolu luhlu luvelayo, uya kuzisa isikhombisi kwisikhundla "esiyimfuneko". Kwimenyu evula, khetha i-akhawunti "yento".



3. Iwindows iqale iwindow. Ekuphela kwengxoxo yale formula inokuba lixabiso eliboniswe njengekhonkco okanye lirekhodwe kwicandelo elihambelanayo. Kuyinyani, ukuqala kwe-Excel 2007, amaxabiso anjalo anokubandakanya i-255 ukubandakanywa. Kwiinguqulelo zangaphambili kwakukho i-30 kuphela.

   Ungayibeka idatha ebaleni ngokuchwetheza iinqobo ezithile okanye amasiko asesini kwikhibhodi. Kodwa xa iseti yokulungelelanisa ilula kakhulu kukufaka isikhombisi ebaleni kwaye ukhethe iseli ehambelanayo okanye uluhlu kwiphepha. Ukuba imijikelezo yeyodwa, idilesi yesibini inokusetyenziswa kwintsimi ethi "Ixabiso2", njl. Emva kokuba amaxabiso adwelisiwe, cofa kwiqhosha "Kulungile".



4. Isiphumo sokulwa kweeseli ezinamaxabiso amanani kuluhlu olunikezelweyo kuya kubonakala kwindawo yoqobo ephepheni.

Isifundo: I-Wizard imisebenzi kwi-Excel

Indlela 2: Ukubala usebenzisa impikiswano eyongezelelweyo

Kumzekelo ongentla, siyithathele ingqalelo le meko xa iimpikiswano zibhekiswa kuphela kwiphepha. Ngoku makhe sijonge ukhetho xa amaxabiso abhalwe ngokuthe ngqo kwicandelo lempikiswano iyasetyenziswa.

1. Kuyo nayiphi na indlela ekukhetho echazwe ekuqaleni, qhuba iwindow yempikiswano yomsebenzi weakhawunti. Kwintsimi ethi "Ixabiso1", chaza idilesi yoluhlu lwedatha, kwaye kwintsimi ethi "Ixabiso2" lifanelekile ibinzana elithi "Inyaniso". Cofa kwiqhosha "Kulungile" ukwenza ukubala.



2. Isiphumo siboniswe kwindawo ekhethiweyo. Njengoko sibona, le nkqubo ibalwe inani leeseli ezinamaxabiso amanani kunye nenani lilonke elongeziweyo kubo elinye ixabiso, elilibhale igama elithi "inyani" kwicandelo "lenyani" kwintsimi yempikiswano. Ukuba eli binzana lalirekhodwa ngqo kwiseli, nasentsimini kuphela apho kuya kubakho ikhonkco kuyo, loo nto ayizukuyongezwa kwinani lilonke.

Indlela 3: INTSHAYELELO SESIFUNDO SEFOMU

Ukongeza ekusebenziseni i-wizard yemisebenzi kunye nengxoxo yeewindows, umsebenzisi unokungena kwimbonakalo eyalo kwiseli ephepheni okanye kumtya wefomula. Kodwa koku kufuneka uyazi i-syntax yomsebenzi. Ayinzima:

= Izibalo (ixabiso1; ixabiso2; ...)

1. Sizise kwiseli intetho yefomula ngokwe-syntax yayo.



2. Ukubala iziphumo kwaye kuphume kwiscreen, cofa iqhosha lokungena, ubekwe kwikhibhodi.

Njengoko ubona, emva kwezi zenzo, iziphumo zokubala ziboniswa kwiscreen kwiseli ekhethiweyo. Kubasebenzisi abanamava, le ndlela inokuba lula ngakumbi kwaye ikhawulezile. Kudlulile ngefowuni ye-wizard yemisebenzi kunye nefestile yeempikiswano.

Zininzi iindlela zokusebenzisa umsebenzi weakhawunti, owona msebenzi uphambili kuwo ubalwa iiseli eziqukethe idatha yenombolo. Ngoncedo lwefomula efanayo, idatha eyongezelelweyo inokwenziwa ukubala ngokuthe ngqo kwicandelo le-formula ifilthi okanye irekhodishe ngokuthe ngqo kwiseli ngokwe-syntax yale nkonzo. Ukongeza, phakathi kwabaqhubi beenkcukacha-manani kukho ezinye iifomula ezibandakanyeka kubalo lweeseli ezigcwalisiweyo kuluhlu olunikezelweyo.