Kulesi sihloko, uzofunda ukuthi ungangeza kanjani futhi uhlanganise izinkinobho zomsakazo ku-Excel . Izinkinobho zomsakazo ziyisilawuli sokufaka esivamile kumafomu. Zivumela abasebenzisi ukuthi babone zonke izinketho ezitholakalayo futhi baqinisekise ukuthi kukhethwe eyodwa kuphela. Qhubeka ufunda ukuze ufunde ukuthi ungadala kanjani futhi uhlanganise lezi zinkinobho, ezibizwa nangokuthi izinkinobho zomsakazo.
Ithebhu Yonjiniyela kanye Nomyalo Wenkinobho Yerediyo
Umyalo wokwengeza izinkinobho zomsakazo ungatholakala kuthebhu kanjiniyela, engasebenzi ku-Excel ngokuzenzakalelayo. Le thebhu iqukethe amathuluzi amakhulu, kanye nezinye izilawuli ezithuthukile njengezinkinobho zomsakazo.

Uma ithebhu nayo ingekho ku-Excel yakho, landela lezi zinyathelo ezingezansi:
- Isinyathelo se-1: kuvulwe Excel ongakhetha en Faka kungobo yomlando.
- Isinyathelo se-2: Khetha Yenza iribhoni ngendlela oyifisayo.
- Isinyathelo se-3: Thola bese umaka ibhokisi lokuthikha Unjiniyela ebhokisini lohlu kwesokudla.
- Isinyathelo se-4: Cindezela inkinobho ukwamukela ukuze ukwazi ukubona ithebhu.

Ungase futhi ube nentshisekelo ku: Indlela Yokwenza Imisebenzi Yezibalo ku-Excel (Ukwengeza, Ukususa, Ukuphindaphinda, Nokuhlukanisa)
Engeza inkinobho yomsakazo ku-Excel
Ku-Excel, ungangeza izinkinobho zezinketho (ezibizwa nangokuthi izinkinobho zomsakazo) ukuze uqoqe impendulo yomsebenzisi embuzweni othize. Lokhu kwenziwa ngethebhu Yonjiniyela. Uma ungenayo, ungangeza ithebhu Yonjiniyela ngokuyenza ngokwezifiso njengoba kuchaziwe ngaphambilini. Ukuze ungeze inkinobho yomsakazo kuspredishithi yakho , landela lezi zinyathelo:
- Isinyathelo se-1: kuzinketho, yiya ku Unjiniyela > Faka bese ukhetha inkinobho yenketho en Izilawuli zefomu.

- Isinyathelo se-2: manje ikhesa iphenduka i-crosshair, futhi udinga ukubeka futhi udwebe ibhokisi lenkinobho yomsakazo.

Ngenxa yale nqubo, inkinobho yomsakazo idaliwe ku-Excel. Ngokuzenzakalelayo, izinkinobho zomsakazo ziqanjwa ngokulandelana ngokuthi Inkinobho Yomsakazo 1, 2, njalo njalo. Futhi, isihloko senkinobho yomsakazo siyefana negama layo.
Shintsha umbhalo wenkinobho yomsakazo ku-Excel
Ukushintsha umbhalo ovela eduze kwenkinobho yenketho ku-Excel, kufanele ulandele lezi zinyathelo:
- Isinyathelo se-1: chofoza kwesokudla inkinobho yenketho bese uchofoza lapho isho khona Hlela umbhalo.

- Isinyathelo se-2: shintsha umbhalo ube yilokho okudingayo. Lesi sibonelo sisebenzisa izinyanga, ngakho-ke le nkinobho yokuqala yomsakazo kufanele ibhalwe ngo-January.

Njengoba ubona, ngemva kwalesi sinyathelo, umbhalo wenkinobho yokukhetha kuphela ku-Excel oshintshayo ube nguJanuwari, kuyilapho igama lisafana (Inkinobho Yokukhetha 1).
Hlanganisa inkinobho yomsakazo kuseli
Ukuze uthole impendulo yomsebenzisi, udinga ukuxhumanisa inkinobho yomsakazo neseli ethile. Ngale ndlela, uzothola inombolo yenkinobho yomsakazo ayikhethile. Ake sithi ufuna ukugcina leli nani kuseli D2 . Bese:
- Isinyathelo se-1: chofoza kwesokudla inkinobho yenketho bese uchofoza lapho isho khona isilawuli sefomethi.

- Isinyathelo se-2: en la ventana Ifomethi into, iya kuthebhu Control, bese ufaka iseli lapho ufuna ukuthola khona umphumela ($D$2) bese uchofoza ukwamukela.

Manje, uma inkinobho yokukhetha ingakahlolwa, inani leseli D2 lingu - 0.

Uma ukhetha inkinobho yokukhetha, inani eliseli D2 lishintsha libe ngu -1.

Faka izinkinobho zezinketho eziningi
Njengoba izinkinobho zomsakazo zilindele impendulo eyodwa kuphela, kuyadingeka ukuthi kube nezinkinobho zomsakazo ezimbili noma ngaphezulu zombuzo. Ake sithi ufuna ukuba nezinkinobho zomsakazo eziyi-12 ukuvumela umsebenzisi ukuthi akhethe inyanga.
Ungakopisha futhi unamathisele inkinobho yomsakazo ekhona, ufake izinkinobho ezengeziwe kusuka kuthebhu yonjiniyela , noma uhudule bese uphonsa amaseli ngezinkinobho ezengeziwe. Inketho yokugcina ilula kakhulu, ngakho-ke sizobonisa leyo ndlela. Ungangeza izinkinobho zomsakazo eziningi ngokulandela lezi zinyathelo:
- Isinyathelo se-1: Uma kwenzeka inkinobho yokuqala yomsakazo ibekwe kuseli (kulokhu, B2), ungabeka ikhesa ekhoneni elingezansi kwesokudla seseli B2 ize ishintshele esiphambanweni esimnyama.

- Isinyathelo se-2: manje hudula ikhesa bese uyidedela kokuthi Umugqa 13, njengoba udinga ukudala ezinye izinkinobho zomsakazo eziyi-11.

Njengoba ubona, unengqikithi yezinkinobho zomsakazo eziyi-12. Njengoba zonke zikopishwe kweyokuqala, isihloko siyefana (ngoJanuwari), kodwa amagama ahlukile (kusuka ku-Radio Button 1 kuya ku-Radio Button 12). Ukwengeza, zonke izinkinobho zomsakazo zixhunywe kuseli efanayo neyokuqala (D2). Ngakho-ke, uma ukhetha inkinobho yesihlanu, uzothola 5 ku-D2.

Okokugcina, kufanele uguqule ngokwakho umbhalo wenkinobho ngayinye yomsakazo ube inyanga efanele. Ngemva kwalokho, iqembu lezinkinobho zomsakazo libukeka kanje:

Ungase uthande nokwazi: Indlela Yokusebenzisa Izinkulumo Ezivamile ku-Excel - Umhlahlandlela Ophelele
Izinkinobho zomsakazo weqembu
Uma unemibuzo eminingi kanye nezinkinobho zomsakazo eziningi zombuzo ngamunye, uzodinga ukuqoqa izinkinobho zomsakazo ngombuzo ngamunye. Ake sithi ngaphezu kwezinyanga, unezinkinobho zomsakazo womkhiqizo kukholomu C. Kulokhu, ungathanda ukuthola inyanga (kuseli D2) kanye nomkhiqizo (ku-D3) njengempendulo. Manje, uma ukhetha uMeyi nezipikha, uthola eziyi-16 kuseli D2.

Lokhu kwenzeka ngoba i-Excel ibeka zonke izinkinobho zomsakazo eqenjini futhi, kulokhu, ungakhetha inketho eyodwa kwezingu-17 ezikhona. Uma ufuna ukwakha amaqembu amabili ezinkinobho zomsakazo (eyodwa ngezinyanga neyodwa ngemikhiqizo), kufanele wengeze ibhokisi leqembu leqembu ngalinye. Ukuze wenze lokhu, landela lezi zinyathelo:
- Isinyathelo se-1: Eqenjini lezinketho, yiya ku Unjiniyela > Faka bese ukhetha ibhokisi leqembu ku ukulawula ifomu.

- Isinyathelo se-2: manje ikhesa iphenduka i-crosshair, futhi kufanele ubeke futhi udwebe ibhokisi leqembu. Ebhokisini leqembu lokuqala, udinga ukubeka zonke izinkinobho zomsakazo izinyanga. Ngakho-ke, kufanele udwebe ibhokisi leqembu lokuqala elizungeze amaseli B2:B13.

Njengomphumela walesi sinyathelo, ibhokisi leqembu lezinyanga liyakhiwa. Manje udinga ukuphinda lezi zinyathelo ezimbili bese udala ibhokisi leqembu elizungeze izinkinobho zomsakazo zemikhiqizo (amaseli B2:B6). Uma manje uxhumanisa izinkinobho zomsakazo womkhiqizo kuseli D3, kufanele ukhethe inkomba yezinyanga eziku-D2 kanye nemikhiqizo eku-D3.

Njengoba ubona eqenjini leNyanga , u-Okthoba ukhethiwe , ngakho iseli D2 lingu-10. Futhi, eqenjini lomkhiqizo , uMonitor ukhethiwe , ngakho u-2 ungumphumela ku-D3. Ngale ndlela, ungakha amaqembu amaningi ezinkinobho zomsakazo zemibuzo ehlukene.
Bheka: Indlela Yokufihla Imigqa ku-Excel Kalula. Izindlela Ezi-3 Ezilula
Pensamientos finales
Kulungile, manje sesiyazi ukuthi singayidala kanjani inkinobho yomsakazo ku-Excel noma siyibeke eqenjini. Ungaxhumanisa izinkinobho zakho zomsakazo neseli ukuze uthole inani lenkomba yenketho ekhethiwe. Udinga ithebhu ethi Unjiniyela , futhi idinga ukubonakala. Uma ungayitholi, ungayenza ibonakale. Sazise esigabeni sokuphawula uma uyithandile le tutorial; sithemba ukukubona futhi maduze.