Funda "Eksele" njani ukubala inani

Njani ukuba abantu sasingabhekisi utshintsho ezinxulumene neenkqubo ofisi, inyani kukuba baye, kwaye uya kuba, yaye ke ngoko kuya kufuneka ukuba ziziqhelanise kubo inkangeleko kunokuba esiguquguqukayo. Njengoko usazi, sithetha iinguqulelo ezidlulileyo MS Office, ezahlukileyo kakhulu langaphambili. Makhe sibone enoba inkangeleko kuphela kuphela kubabhekisi eli xesha.

ulwimi Russian iye ekugqibeleni waba ngomnye zimelwe kuluhlu, ukuze ungakhathazeki yobunzima ukudluliswa mfuneko. Ukongeza, badwelisi benkqubo kuba kanye wasigcina isithembiso sakhe waza waliqengqa uluntu ukuba version x64 ngokupheleleyo. Noko ke, wona ngokunyanisekileyo alumkise ukuba ukungabikho imfuneko ukusebenza kwifayile Excel Isanti 2GB yaye kuyimfuneko ngakumbi ukuba ukusebenzisa uguqulelo bit-32 lixesha.

Makhe ushiye bucala amazwi. Namhlanje siza kufunda ukuba "Eksele" Bala ngayo imali. Ewe, kuba abasebenzisi ezinamava oku kungekho deal enkulu, kodwa inkoliso la matyendyana oku abazange bajamelane.

Inkqubo yokubala

Kubulungisa kufanele kuqatshelwe ukuba ekubaleni ixabiso lilonke - enye imisebenzi zilula kunye neefomula ukuba ube nje eli umhleli spreadsheet. Makhe sihlolisise lo mzekelo sabaqalayo.

Makhe sicinge ukuba umsebenzi oluqhutywa ikholam kule uluhlu A4 A9. Phambi kokuba ku, "Eksele" Ungabala udibaniso lamagugu kufuneka nje ukuba ukhethe zonke iiseli kunye engenanto enye kuzo (oko kukuthi, uluhlu le A4 phezu A10), uze ucofe kwi sum iqhosha. Le program ngokuzenzekelayo ukubakhangelela isiphumo, wambeka kuseli A10.

Kukho nenye indlela. Ukucinga ukuba amaxabiso ezinqwenelwayo iiseli efanayo. Kodwa kufuneka ukuba ubani afumane oko akufunayo waba kwenye iseli uluhlu (B7, umzekelo). Indlela yokuphumeza oku?

Okokuqala, kandziyisa iseli B7 iqhosha lasekhohlo le mouse, ngoku nqakraza kwi sum iqhosha. Emva koko, i ekhohlo iqhosha le mouse ukhankanye ulungiso equlathe idata oyifunayo. Yeseli lokugqibela ixabiso olifunayo. Ukuba kuyimfuneko, uluhlu elabelwe iiseli zingatshintshwa.

Inguqulo nobunzima kakhulu

Konke esiye sayiqwalasela ngasentla, woba kudidi ezo iinkcukacha banal, leyo ukunika abafundi kwizifundo zokuqala ezimbalwa yokwazisa. Kodwa kuthekani kwimeko xa ixabiso efunekayo ukuze ingafunyanwa ngokususela kwidatha, abakulo kwizibophelelo eyahlukileyo ngokupheleleyo?

Phambi kokuba ku, "Eksele" Bala isixa kwiimeko ezinjalo, kuya kufuneka wenze okungakumbi kancinci. Okokuqala, ubeke isikhombisi kwi kwiseli apho imali iyonke iya kuba. Beka khona isibonakaliso "=", ngoko ke ekhohlo iqhosha le mouse khetha iseli ixabiso ogama kufuneka adityaniswe namanye amanani.

Emva kokuba "ilingana 'phawu ixabiso layo (A6, umzekelo). Beka i A6 emva "+", ngoko siya kuthi gqolo ukuzibhiyozela uluhlu yakho oyithandayo. Xa ugqibile, cinezela nje «Ngena»: ixabiso olifunayo kwi kwindawo efunekayo.

"Sum Quick"

Yaye njengokuba "Eksele" Bala imali xa ufuna kuphela ngokukhawuleza ujonge ixabiso elipheleleyo iiseli ezininzi, ayengaziqokeleli le amabinzana ezintsonkothileyo? Kaloku, lo Abenzi bemeko-nkqubo (Ndizakuyibiza eluncedo akazokumguqula ulwimi), yaye isimo esinjalo.

Emazantsi lokusebenza ukuze umgca ilizwi yi "Kwenziwe." Nqakraza kuyo iqhosha lemawusi lasekunene, yaye kwi popup menu khetha umba "Imali". Emva koko kufuneka ukubalaselisa leseli iqhosha lemawusi lasekhohlo ngelixa ngokubamba phantsi i Ctrl isitshixo kwi yezitshixo.

Apho ungajonga khona impendulo?

Ukukhetha i iseli kwaye ukhupha iqhosha le keyboard, thina ukutsalela ingqalelo kwikona esezantsi ekunene umsebenzi wekhusi apho kuya kubakho umgca "Sum =", nto leyo ibonisa ixabiso ngenxa.

Njengoko ubona, usebenzisa sokubala yobalo intermediate musa ukuba, ngenxa yokuba Excel ngokulula ibetha naye zonke izibalo. Ewe, ngenxa yokuba e-Excel ukubala imali alinikwa bonke, zimali kunye namava badla ukusebenzisa le ndlela ethile.

ngenye indlela

Ukuba ufunda ngenyameko inqaku lethu, wena uye waqaphela inani iifomyula ezisetyenziswe kule izibalo. Ewe, wena ekunene: ukuba ngesandla ukungena entsimini efanelekileyo, kunokwenzeka ukuba angamchukumisi le mouse. Makhe sibone indlela isebenza oku practice.

Ukuba wangena indlela kwi "Excel", kufuneka ufunde kuqala (imali amagama aziyi kusebenza ngaphandle) apho ukungena kuwo onke. Ngoko nangoko ngaphantsi toolbar (okanye ngaphantsi ibhanti kwiinguqulelo entsha) ibe yintsimi elide. Ekuqaleni kwalo kukho icon FX, ukuze uhambe okungalungile.

Apha nje wangena imisebenzi efunekayo. Masithi kufuneka ukuba ufumane udibaniso inani leeseli ukuba asasazwa ngokufanayo kuzo itafile. Okokuqala, khetha entsimini, nto leyo iya kubalwa equation. Emva koko, siya ubhale endle "=" neefomula, uze amisele ezo seli eziquka idata ezinqwenelekayo, ezahlulwe i "+".

Umzekelo: = A1 + B2 + C3. Xa ugqibile, klikha kwi ikuyo Faka. Entsimini yakho ukhethe inani elifunekayo ivela. Ekubeni "Eksele" ukubala inani nto idla ezifunekayo ngale ndlela, kufuneka kuwo ukuba ukukhumbula.