Funda indlela "Eksele" ukubala inani

Ungakuchaza kanjani abantu ayibhekiseli izinguquko ezihlobene izinhlelo ehhovisi, iqiniso liwukuthi lokho abakwenzile, futhi kuyoba, ngakho-ke kuyodingeka ukuzivumelanisa nazo ukubukeka kunalokho iyashintsha. Njengoba wazi, sikhuluma izinguqulo MS Office, okuyinto zihluke kakhulu ezincwadini ababengaphambi zabo. Make sibone ukuthi ukubukeka kuphela nomkhawulo Onjiniyela sikhathi.

isiRashiya uye wagcina ebe omunye emelelwa ohlwini, ukuze ukhathazeke ubunkimbinkimbi ukudluliswa akudingekile. Ngaphezu kwalokho, i program for once wasigcina isithembiso sakhe futhi ikhishwa emphakathini ukuze okufushane umnyuziki x64. Noma kunjalo, ngokwethembeka baxwayisa ngokuthi ngokungabi bikho isidingo ukusebenza ifayela le-Excel osayizi 2GB futhi abafiseleka ngokwengeziwe ukusebenzisa esiphelelwe-32-bit version.

Ake ushiye eceleni isosha esihlatshelelwayo. Namuhla sizofunda indlela "Eksele" Bala lemali. Yebo, kubasebenzisi abanolwazi lesi akusona inkinga enkulu, kodwa namanje iningi zifiki lokhu akukaze babhekana.

Inqubo yokubala

Uzokwenza kufanele kuphawulwe ukuthi ukubala inani - omunye imisebenzi elula nge amafomula ukuthi kuphela lo mhleli spreadsheet. Ake sihlole isibonelo sikaJesu aphansi kakhulu.

Ake ucabange ukuthi umsebenzi wenziwa ikholomu ku ezahlukene A4 A9. Ngaphambi kokuya e, "Eksele" ukubala isamba lezi zimiso kuyokwenza kuphela kudingeka ukhethe wonke amaseli nokukodwa nalutho ngabo (ie, ububanzi A4 phezu A10), bese uchofoza inkinobho isamba. Uhlelo ngokuzenzakalelayo wanaka umphumela wamfaka esitokisini A10.

Kukhona enye indlela esingathola. Ucabange ukuthi amagugu oyifunayo kukhona kumaseli efanayo. Kodwa kungase kudingeke ukuba elamukelekile kwaba nabo kwesinye isitokisi senhlobo (B7, isibonelo). Njani ukwenza lokhu?

Okokuqala, ukugqamisa iseli B7 inkinobho kwesokunxele igundane, bese uchofoza inkinobho isamba. Ngemva kwalokho, inkinobho yesinxele ucacise ububanzi equkethe idatha okudingayo. Iseli sokugcina ukubaluleka olufunayo. Uma kudingekile, ububanzi esabelwe amaseli kungashintshwa.

Inguqulo ezingcono

Zonke esikuhlolile ngenhla, kungokwalabo esigabeni yaleyo mininingwane banal, anikeza abafundi sezifundo zokuqala ezimbalwa Informatics. Kodwa kuthiwani endabeni lapho ukubaluleka oyifunayo lutholakala esekelwe idatha, okuyizinto endaweni bands ehluke ngokuphelele?

Ngaphambi kokuya e, "Eksele" Bala lemali ezimweni ezinjalo, kuyodingeka wenze kancane xaxa. Okokuqala, wafaka isikhombisi ngesikhathi cell lapho inani kuyoba. Beka lapho ngemvume "=", bese inkinobho yesinxele uyikhethe ogama value kumele kwengezwe kanye nezinye izibalo.

Emva "kulingana" uphawu livela ukudayiswa kwayo ngemali eyifanele (A6, isibonelo). Beka A6 ngemva "+", bese siqhubeka ukugubha ububanzi osithandayo. Lapho usuqedile, umane cindezela «Faka»: ukubaluleka olufunayo endaweni oyifunayo.

"Isamba Quick"

Njengalapho "Eksele" Bala lemali uma kuphela kudingeka ngokushesha sibheke inani amaseli eziningana, hhayi lokuqoqa salokhu izinkulumo eziyinkimbinkimbi? Nokho, abadali uhlelo (ukuyibiza Umbuso ingavuli ulimi), futhi enikeziwe Esimeni esinjalo.

Ezansi ekhasini lokusebenza ukuze izwi umugqa "Qedile." Chofoza kuyo inkinobho yegundane kwesokudla, futhi umongo kumenyu evelile ukhethe into "Inani". Ngemva kwalokho kudingeka ukugqamisa ibanga leseli inkinobho yesinxele ngenkathi ebambe phansi inkinobho Ctrl on the ikhibhodi.

Lapho ukubheka impendulo?

Ukukhetha iseli nokukhulula ukhiye on the keyboard, thina ukuziqhakambisa ekhoneni elingezansi kwesokudla kwesikrini ukusebenza lapho kuyoba umugqa "Sum =", okukhombisa ukubaluleka okuholela.

Njengoba ubona, kusetshenziswa wokubala for izibalo Lesisemkhatsini akudingeki, ngoba Excel ishaya kalula kuye kuzo zonke izici. Yebo, ngoba Excel ukubala inani alinikwa kuwo wonke umuntu, ezimali abanolwazi ngokuvamile zisebenzisa le ndlela ethile.

enye indlela

Uma ufundisisa athikili yethu, cishe waphawula isibalo amafomula esetshenziswa izibalo. Yebo, uqinisile: uma ufake nabo emkhakheni ezifanele, kungenzeka yini ukuba uthinte igundane. Ake sibone ukuthi lokhu kusebenza practice.

Ukuze ufake ifomula ku "Excel", kumelwe siqale sifunde (lemali ngamagama ngeke isebenze ngaphandle kwalo) kuphi angena kuwo. Ngokushesha ngezansi yamathuluzi (noma ngaphansi ibhande izinguqulo amasha) zinenkundla eside. Ngezinye ekuqaleni kwawo Fx isithonjana, ngakho ngeke ukwazi yonakale.

Lapha ukuthi Usanda imisebenzi edingekayo. Ake sithi udinga ukuthola isamba inani lamaseli ukuthi nombala basakaza kwetafula. Okokuqala, khetha zasendle, ezikhona izobalwa equation. Ngemva kwalokho, sibhala emkhakheni "=" amafomula, bese linqume labo amaseli aqukethe idatha efiswayo, ahlukaniswe "+".

Ngokwesibonelo: = A1 + B2 + C3. Lapho usuqedile, chofoza ku ikuyo yonke indawo Faka. Kwi-career oyikhethayo inani elidingekayo livela. Njengoba "Eksele" ukubala inani ngokuvamile kudingeka ngale ndlela, ngo-ke kufanele akhumbule.