Indlela yokubala inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-Ekstel

Imvamisa, phambi kwabasebenzisi bomhleli wethebula, umbuzo uphakama okuhlobene nokubala inani lezinkomba kwikholamu. Ngamanye amagama, kuyadingeka ukubala inani lamasimu kwikholamu eligcwele umbhalo othize noma imininingwane yezinombolo. Isihleli setafula sinokuhlukahluka okuningi okuvumela ukuthi wenze lesi sici.

Inqubo yokubala kwikholamu

Ngokuya ngezinhloso zomsebenzisi esihlotsheni setafula, ungasebenzisa ukubala kwayo yonke imininingwane kwikholomu. Sizohlaziya indlela ngayinye ngemininingwane eminingi.

Indlela 1: Ibonisa inani lamanani kubha yesimo

Le ndlela ilula ukuyisebenzisa. Isebenzisa ukubala imininingwane yezinombolo kanye nemibhalo, kepha ayikwazi ukusetshenziswa lapho usebenza nemibandela. I-General Action algorithm:

1. Khetha indawo edingekayo yedatha.
2. Sibheke emugqeni wombuso.
3. Sifunda inani lamagugu.

okukodwa

Indlela elula ukuyisebenzisa kuphela uma usebenza nge-aughtage yedatha, uma kungenjalo udinga ukusebenzisa ezinye izinketho. Enye indlela yendlela - umphumela ubonakala kuphela ngesikhathi sokuhlukaniswa, ngakho-ke udinga ukususwa noma ngekhanda noma ukulungiswa kwenye indawo. Umhlahlandlela wesinyathelo ngesinyathelo sokufaka inkomba "yenombolo":

1. Chofoza i-PCM kubha yesimo.
2. Isikrini sibonisa uhlu. Lapha kubalulekile ukubheka ukuthi ngabe uphawu lumayelana nepharamitha "yenani". Uma kungenjalo, khona-ke kufanele kufakwe ngokuchofoza inkinobho yegundane kwesobunxele.

2.

1. Silungele! Manje inkomba "yenombolo" isendaweni yesimo se-processor yetafula.

Indlela 2: Ukusetshenziswa komsebenzi we-RC

Lo opharetha ufaka into efanayo nendlela edlule, kepha ngasikhathi sinye ngaphezu kwalokho alungisa umphumela. Amanye amaphutha asele, ngoba ukusebenza kwe-invoice akunakusebenza nemibandela.

Kunezinhlobo ezimbili ezivamile zo-opharetha:

1. = Ibha (cell1; cell2; ... iseli).
2. = Blossom (cell1: iseli).

Ngefomu le-1, opharetha abalwa iseli ngalinye elikhethiwe. Ngefomu lesi-2, inani lezinkambu ezigcwalisiwe libalwa ebangeni kusuka kwinombolo yeseli 1 kuya esitokisini ngenombolo N. Isinyathelo ngesinyathelo ngesinyathelo:

1. Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
2. Ukuhamba esigatshaneni "amafomula". Chofoza u- "Faka umsebenzi."

3.

1. Inketho ehlukile - Ukucindezela isithonjana esithi "Insert Function", esitholakala eduze komugqa weqoqo lamafomula.

okune

1. Imisebenzi emincane "yokufaka" yavela esikrinini. Vula uhlu olutholakala eduze kwesigaba "sesigaba" esibhaliwe. Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha Umsebenzi:" Insimu, sithola opharetha we-invoice bese uchofoza kuwo yi-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".

isihlanu

1. Isibonisi sibonisa iwindi ukubhala ama-opharetha okuphikisana. Lapha kuyadingeka ngokudlulisa amaseli noma ibanga lokufaka ukusetha izimpikiswano. Kuyaqapheleka ukuthi ibanga lingasethwa ngesihloko. Ngemuva kwakho konke ukukhohlisa, chofoza entweni ethi "Kulungile", etholakala ezansi kwewindi.

6.

1. Silungele! Ngenxa yalokho, sathola umphumela wokubala esitokisini esinqunyelwe kusengaphambili. Kucatshangelwe ngokuphelele sonke iseli eligcwele eligcwele.

7 Indlela 3: Usebenzisa umsebenzi we-akhawunti

I-akhawunti ilungele ukusebenza ngezinkomba zamanani. Kunezinhlobo ezimbili ezivamile zo-opharetha:

1. = I-akhawunti (cell1; cell2; ... iseli).
2. = I-Akhawunti (iseli1: iseli).

Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
2. Ukuhamba esigatshaneni "amafomula". Chofoza entweni ethi "Faka umsebenzi". Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba esithi "isigaba" esibhaliwe. Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha Umsebenzi:" Insimu, sithola i-akhawunti opharetha bese sichofoza kuwo nge-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".

isishiyagalombili

1. Iwindi lezimpikiswano ligcwalisa izixhumanisi zamaseli adingekayo. Ngemuva kwakho konke ukukhohlisa, chofoza entweni ethi "Kulungile", etholakala ezansi kwewindi.

isishiyagalolunye

1. Silungele! Ngenxa yalokho, sathola umphumela wokubala esitokisini esinqunyelwe kusengaphambili. Lapha kubhekwa amaseli agcwele ama-akhawunti, ngaphandle kokungenalutho naleyo lapho imininingwane yombhalo itholakala khona.

Indlela engu-10: opharetha 8

Lo osebenza ngo-opharetha ukuvumela ukubala inani lamanani wemibandela ethile. Ukubukwa okujwayelekile kopharetha: = 8 (Range; inqubomgomo).

1. Ububanzi - Lokhu kukhombisa indawo okudingeka ukubala inani lenhlamvu ngesimo esithile.
2. Isikhombisi yisimo lapho okwenzeka khona okuzohlukaniswa khona.

Sizohlaziya konke esibonelweni esithile. Isiqondisi Sokuma kwesinyathelo:

1. Isibonelo, sizonquma inani legama elithi "Running" kwikholamu nezemidlalo. Ukuhamba emkhakheni ozowubonisa kuyo.
2. Ukuhamba esigatshaneni "amafomula". Chofoza entweni ethi "Faka umsebenzi". Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba "Sokubhaliwe:". Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha umsebenzi:" Insimu, sithola opharetha bese sichofoza kuwo nge-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".

ishumi nanye

1. Isikrini sivela "izimpikiswano zomsebenzi". Kulayini wobubanzi, sethula izixhumanisi zamaseli abambe iqhaza ekubalweni. Emgqeni "Criterion" sibuza isimo uqobo. Shayela lapha: "Run". Ngemuva kokwenza konke ukusebenzisana, chofoza kwinto ethi "Kulungile".

Okuqophele imali

1. I-opharetha ibalwe futhi ikhombise inani lenhlamvu ensimini egqanyisiwe ngegama elithi "run". Sinezinhlobonhlobo eziyishumi nesithupha.

13

Ake sizame ukuhlela isimo ukuze siqonde kangcono umsebenzi we-opharetha. Isiqondisi Sokuma kwesinyathelo:

1. Masenze ukubala amanye amanani kule kholamu, ngaphandle kwenani elithi "Run".
2. Siphinda iphuzu lesibili kusuka ekufundisweni okungenhla.
3. Emgqeni wobubanzi, sifaka amakheli afanayo nakulesi sibonelo esingenhla. Kulayini "Criterion" Sishayela uphawu lokungalingani "" ngaphambi kwenani elithi "run". Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

ishumi nane

1. Ngenxa yalokho, sathola inqwaba yakwa-Seven - inani lamagama kwikholamu elikhethiwe ngaphandle kokucabanga igama elithi "Running".

Ekupheleni kokucatshangelwa kwendlela, sithola ukuthi opharetha basebenza kanjani nemibandela lapho izinhlamvu ">" kanye "

1. Usebenzisa imiyalo engenhla, faka opharetha ukubheka iseli elidingekayo.
2. Kulayini wobubanzi, sifaka izixhumanisi ezidingekayo zamaseli kaSomlomo. Emugqeni we- "Criterion", faka inani "> 350". Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

ishumi nanhlanu

1. Ngenxa yalokhu, sathola inani leshumi - inani lezinombolo likhulu kune-350 kukholamu ekhethiwe.

Izibonelo eziyi-16 zokusebenzisa umsebenzi wokusebenza ku-Excel

Sizohlaziya esinye isibonelo sokuqonda okuphelele komsebenzi we-opharetha. Isibonelo, sinamamaki alandelayo anemininingwane yokuthengisa:

17.

Injongo: Thola ukuthi zingaki izimpahla ezithengiswayo ziyimikhiqizo evela kwa-Samsung. Sisebenzisa ifomula elandelayo: = C3: C17; "Samsung") / A17. Ngenxa yalokho, sithola umphumela ka-40%:

Izici eziyi-18 zokusebenzisa umsebenzi wokusebenza kwe-Excel

Khuluma ngezinye izici zo-opharetha:

• Irejista yezimpawu ayinandaba ukuthi ngabe umugqa wezinhlobo zemibhalo wahlelwa njengendlela yokufunda;
• Umphumela wokubala uzoba zero uma kubhekiswa kwiseli elingenalutho noma kulayini ongenalutho kuzokwethulwa njengesikhombisi;
• U-opharetha ungafakwa njengefomula yamalungu, lapho inani lamaseli anolwazi oluhambisana nemibandela eminingana luzokwenzeka.

Indlela 5: Ukusebenzisa opharetha kungu-8 opharetha

I-opharetha iyafana nomsebenzi oshiwo ngenhla. Kuhluka ngoba kukuvumela ukuthi ungeze inombolo ethile yamabanga anezimo ezahlukahlukene noma ezifanayo. Isibonelo, kudingeka sibala inani lemikhiqizo ethengiswa ngenani lezingcezu ezingaphezu kwamakhulu amathathu. Ngokwengeziwe, kuyadingeka ukubala ukuthi intengo yomkhiqizo idlula inani lama-ruble ayizinkulungwane eziyisithupha. Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
2. Ukuhamba esigatshaneni "amafomula". Chofoza u- "Faka umsebenzi." Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba esithi "isigaba" esibhaliwe. Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha umsebenzi:" Insimu, sithola isinali opharetha bese sichofoza kukho nge-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".

ishumi nesishiyagalolunye

1. Iwindi elisijwayele ngaphansi kwegama elithi "Izimpikiswano Zokusebenza" kwavela. Lapha, lapho ungena esimweni esisodwa, kuvela umugqa omusha ngokushesha ukugcwalisa esinye isimo. Kulayini "Range 1", sishayela ikheli lekholomu lapho imininingwane yokuthengisa itholakala khona. Emugqeni "Isimo 1", sishayela inkomba "> 300". Kulayini "Range 2", shayela ikheli lekholomu lapho imininingwane yezindleko itholakala khona. Emugqeni we- "Isimo 2", engeza inani "> 6000". Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

amashumi amabili

1. Ngenxa yalokhu, sathola umphumela okhombisa ukuthi yimaphi amaseli alungele ukwakheka kwezimo ezifakiwe. Sithole inani leshumi nane.

21 Indlela 6: Umsebenzi we-CLOM

Inketho elandelayo ikuvumela ukubala inani lamaseli angenalutho. Ukusebenzisa le nqubo, kulungele ngokuphelele. Ukubukwa okujwayelekile kopharetha: = Ukuhlanza (ibanga). Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza ukukhetha kweseli lapho ukubalwa kuzo kukhonjiswa khona.
2. Ukuhamba esigatshaneni "amafomula". Chofoza entweni ethi "Faka umsebenzi". Isikrini sibonisa iwindi elincane elibizwa nge- "Function Faka". Zembula uhlu olutholakala eduze kwesigaba "Sokubhaliwe:". Ohlwini olunqatshiwe, khetha i- "Statistical" element. In the "Khetha umsebenzi:" Insimu, sithola opharetha ukuze ahlanze futhi achofoze kuyo yi-LKM. Ngemuva kwakho konke ukukhohlisa, chofoza into "OK".

22.

1. E "Ukuphikisana komsebenzi" kwavela, sishayela izixhumanisi ezidingekayo zamaseli, bese uqhafaza kwinto ethi "Kulungile".

23.

1. Ngenxa yalokho, sathola umphumela lapho inani lamaseli angenalutho lizokhonjiswa.

24.

Ukubala Amanani Emibhalo Ehlukile ku-MS Excel

Isibonelo, cabanga ngesibonakaliso esilandelayo:25.

Injongo: Bala inani lamapharamitha wombhalo ahlukile ku-A7: A15. Ukuze wenze lokhu, sisebenzisa ifomula: = i-sumpy ((A7: A15 "") / 8: A7: A15; A15)).

Ungawathola kanjani amanani aphindaphindayo ku-Excel.

Isibonelo, sinepuleti elilandelayo:

26.

Ukubala amanani aphindaphindwayo, kuyadingeka ukwethula ifomula elandelayo ku-G5: = Uma (ne- $ 5: a5: A5)> A5; A5; A5); 1). Ngemuva kwalokho udinga ukukopisha le formula kuyo yonke ikholomu.

Bala inani lamanani aphindaphindwayo kwikholomu

Ukuze ubale inani elidingekayo lokuphindwa kabili kukholamu, kufanele wenze okulandelayo:

1. Sebenzisa sonke isibonakaliso esifanayo esibonelweni esingenhla. Sikhiqiza ukukhethwa kwamangqamuzana ekholomu.
2. Hlanganisa ngendlela yokufometha.
3. Ku- "Khetha Indlela Yesici:" Inkambu, chofoza into "Sebenzisa ifomula ukuthola amaseli aphathelene".
4. Emgqeni "format formula ukunquma amaseli ezinsizakusebenza", drive = 8 ($ a: $ a5 a; A5)> 1.

27.

1. Silungele! Sisebenzise ukubalwa kwezinkomba ezifanayo kwikholamu, futhi sabela kabusha imininingwane ephindaphindwayo kweminye imibala.

Kubalwa inani lenani elithile leseli ku-Excel enikeziwe

Cabanga ngalesi sikhathi esibonelweni esithile. Ake sithi sinalo ipuleti lethebula elilandelayo:

28.

Sabela i-E2: E5 Range futhi wethula ifomula: = 8: B3: B19; D2: D5). B3: B19 - Amaseli aqukethe izilinganiso, kanye ne-D2: D5 - amaseli, lapho inqubo itholakala ngokubala inani lezincwadi. Ngenxa yalokho, sithola umphumela onjalo:

29.

Ukugcina

Isihleli sethebula le-Exel wuhlelo olusebenzayo olukuvumela ukuthi uxazulule inani elikhulu lemisebenzi ehlukahlukene. Uhlelo luhlinzeka ngemisebenzi eminingana evumela ukuba ubale inani lamanani kububanzi obucacisiwe. Umsebenzisi ngamunye uzokwazi ukukhetha ngokuzimela indlela elula elungele imisebenzi yakhe.

Umlayezo wokuthi ubala kanjani inani lamagugu kukholamu ye-Excel. Izindlela ezi-6 zokubala inani lamagugu kukholamu ye-eksel yavela kuqala kubuchwepheshe bolwazi.