Indlela yokubala inani leeseli ezaliswe zigqogqe

Xa usenza imisebenzi ethile ngelixa usebenza netafile, kuyimfuneko ukubala iiseli ezaliswe yidatha. I-Excel ibonelela ngamathuba anjalo usebenzisa izixhobo ezingenisiweyo. Masifumanise ukuba senze inkqubo ethile kule nkqubo.

Ukubala iiseli

Kwinkqubo ye-Excel, inani leeseli ezaliswe zeseli linokubonwa lisebenzisa ikhawuntara kwi-bar yendawo okanye inani lemisebenzi, nganye ibala izinto ezizaliswe luhlobo oluthile lwedatha.

Indlela yoku-1: I-counter kumqolo wenqanaba

Eyona ndlela ilula yokubala iiseli ezineenkcukacha kukusebenzisa ulwazi olusuka kwimitha, ekwakwicala lasekunene lomtya oshiyekileyo kumaqhosha okujonga e-Excel. Ngelixa uluhlu lukhethiwe kwiphepha, apho zonke izinto zingenanto okanye inye kuphela iqukethe ixabiso elithile, esi siphithiphithi siyafihla. I-conter ivele ngokuzenzekelayo xa iiseli ezimbini okanye ngaphezulu ezingenanto ziyinto eyodwa, kwaye ngoko nangoko zibonisa inombolo yazo emva kwegama "ubuninzi".

Kodwa, nangona ngokuzenzekelayo, le mitha ivuliwe, kwaye ilindelwe ngumsebenzisi ukuba iqaphele izinto ezithile, kwezinye iimeko inokubakhubazeke ngesandla. Emva koko umbuzo wokubandakanywa kwayo ufanelekile. Ukwenza oku, cofa ngasekunene Cofa kwi-bar yendawo kunye noluhlu oluvula, setha uphawu malunga "nenani". Emva koko, ikhawuntari iya kuphinda ibonakaliswe kwakhona.

Indlela 2: Umsebenzi weNtlanganiso

Bala inani leeseli ezaliswe seli zinokubalwa kusetyenziswa umsebenzi weakhawunti. Yahluke kwindlela edlulileyo yokuvumela ukubalwa koluhlu oluthile kwisisele esahlukileyo. Oko kukuthi, ukujonga ulwazi ngayo, le ndawo ayiyi kwabelwa rhoqo.

1. Khetha indawo apho isiphumo sokubulela siya kuboniswa khona. Cofa kwindawo ethi "Faka umsebenzi" icon.



2. Inkosi yomsebenzi yeWizard ivula. Sikhangela uluhlu lwe "akhawunti" engenisiweyo. Emva kokuba eli gama libalaselisiwe, cofa kwiqhosha "Kulungile".



3. Iwindows iqale iwindow. Iimpikiswano zalo msebenzi zinxibelelana kwiiseli. Ikhonkco kuluhlu linokumiselwa ngesandla, kodwa kungcono ukuseta isikhombisi kwintsimi "yexabiso1", apho ufuna ukufaka idatha, kwaye ukhethe indawo efanelekileyo ephethini. Ukuba ufuna ukubala iiseli ezigcwalisiweyo kwi-ranges ezikude omnye komnye, ukulungelelaniswa komgangatho wesibini, wesithathu kunye noluhlu olulandelayo kufuneka kungeniswe "Ixabiso2", njl. Xa yonke idatha ifakiwe. Cofa kwiqhosha "Kulungile".



4. Eli nqaku linokungeniswa ngesandla kwiseli okanye umtya wefomula, ukubambelela kwi-syntax elandelayo:

   = Iakhawunti (ixabiso1; ixabiso2; ...)



5. Emva kokuba kungeniswe ifomula, inkqubo kwindawo ebekiweyo ibonisa isiphumo sokubala iiseli ezigcwalisiweyo zoluhlu oluchaziweyo.

Indlela 3: Iakhawunti yomsebenzi

Ukongeza, ukubala iiseli ezigcwalisiweyo kwi-Excel kusemsebenzini weakhawunti. Ngokwahlukileyo kwifomula yangaphambili, ithathela ingqalelo iiseli kuphela zedatha.

1. Njengakwimeko yangaphambili, sibonisa iseli apho idatha iya kuboniswa kwaye isungule i-wizard yemisebenzi ngendlela efanayo. Kuyo, khetha umqhubi ngegama "akhawunti". Cofa kwiqhosha "Kulungile".



2. Iwindows iqale iwindow. Iimpikiswano ziyafana xa usebenzisa indlela yangaphambili. Iindima zabo zibhekiswa kwiiseli. Faka ulungelelwaniso lwe-ranges ephepheni apho ufuna ukubala inani leeseli ezigcwalisa ngedatha yamanani. Cofa iqhosha "Kulungile".

   

   Ukufakwa kwencwadi yesethilethi, kunamathele kwi-syntax elandelayo:

   = Iakhawunti (ixabiso1; ixabiso2; ...)



3. Emva koko, kule ndawo ifumaneka kuyo ifomula, inani leeseli ezizaliswe ziidatha zamanani ziya kuvela.

Indlela 4: Umsebenzi weMeckel

Lo msebenzi kukuvumela ukuba ubale kuphela inani leeseli ezizaliswe ngamabinzana aphezulu, kodwa ezo kuphela ezihambelana nemeko ethile. Umzekelo, ukuba ucinga ukuba imeko ">>, kuphela, kuphela iiseli eziya kuthathelwa ingqalelo, ezinokuthathwa njengexabiso elingaphezu kwama-50. Ungabeka amaxabiso" "(akalingani), njl.

1. Emva kokuba iseli yabelwe ukuba ibonise isiphumo kwaye isungule i-Wizards imisebenzi, khetha irekhodi "ski". Cofa kwiqhosha "Kulungile".



2. Iwindow yempikiswano ivula. Lo msebenzi unezimpikiswano ezimbini: uluhlu apho ubalwa lweseli kwenzeka khona, kunye nenqanaba, oko kukuthi, imeko esithethile ngayo ngasentla. Kwintsimi "ye" ", sazisa ngokunxibelelanisa indawo ephathwayo, kwaye kwi-cogrierions" intsimi eyingqinelana nemeko. Emva koko, cofa kwiqhosha "Kulungile".

   

   Igalelo lencwadi, itemplate ikhangeleka ngathi:

   = Iishedyuli (uluhlu; I-cogrierion)



3. Emva koko, le nkqubo ibala iiseli ezigcwalisiweyo zoluhlu olunikezelweyo, oluhambelana nemeko echaziweyo, kwaye lizibonisa kwindawo echazwe kumhlathi wokuqala wendlela.

Indlela yesi-5: Umsebenzi wendlela yokubala

Ukubalwa komqhubi kukhetho oluphambili lomsebenzi wekhawuntara. Isetyenziselwa xa kufuneka uchaze ngaphezulu kwemeko enye yokuvumelana ne-ranges ezahlukeneyo. Unokuchaza kuphela iimeko ezili-126.

1. Sibonisa iseli apho iziphumo eziya kuboniswa khona kwaye ziqhube imisebenzi yemisebenzi. Ifuna into "ebaleke". Siyibonisa kwaye sicinezela iqhosha u "Kulungile".



2. Ukuvulwa kwefestile yempikiswano yenzeka. Ngokwenyani, impikiswano yomsebenzi iyafana neyangaphambili-"Uluhlu" kunye "nemeko". Umahluko kukuba i-ranges kunye neemeko ezihambelanayo zinokuba lukhulu. Singena kwiidilesi ze-ranges kunye neemeko ezihambelanayo kubo, emva koko cinezela iqhosha u "Kulungile.

   

   I-syntax yeli nqaku yile ilandelayo:

   = Ibaliwe (Uluhlu_longs1; Imeko1; Uluhlu_longs2; Imeko2; ...)



3. Emva koko, isicelo sibala iiseli ezaliswe zizinto ezichaziweyo ezihambelana neemeko ezimiselweyo. Isiphumo siboniswe kwindawo ephawulwe kwangaphambili.

Njengoko ubona, ukubalwa ngokulula kwenani leeseli ezigcwalisiweyo zoluhlu olukhethiweyo kunokubonwa kumtya we-Excel State. Ukuba ufuna ukurhoxisa iziphumo kwindawo eyahlukileyo eshiti, kwaye ngaphezulu njengabala iimeko ezithile, emva koko kule meko, imisebenzi ekhethekileyo iya kuza kuhlangulo.