Engeza futhi Hlanganisa Inkinobho Yomsakazo ku-Excel

Isibuyekezo sokugcina: 04/10/2024

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.

Inkinobho yokukhetha ku-Excel

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.

Dala inkinobho yomsakazo ku-Excel

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.

Engeza inkinobho yomsakazo ku-Excel

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

Engeza inkinobho yomsakazo ku-Excel

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.

  Ungawusula Kanjani Umugqa Wokuphrinta ku-Windows

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.

Shintsha umbhalo wenkinobho yomsakazo

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

Shintsha umbhalo wenkinobho yomsakazo

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.

Hlanganisa inkinobho yomsakazo kuseli

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

Hlanganisa inkinobho yomsakazo kuseli

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

Hlanganisa inkinobho yomsakazo kuseli

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

Hlanganisa inkinobho yomsakazo kuseli

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.

Faka izinkinobho zezinketho eziningi

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

Faka izinkinobho zezinketho eziningi

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.

  Yenza amashadi abe ngokuzenzakalelayo anamabanga aqanjwe ngamagama kanye nochungechunge olushintshashintshayo ku-Excel

Faka izinkinobho zezinketho eziningi

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

Faka izinkinobho zezinketho eziningi

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.

Izinkinobho zomsakazo weqembu

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.

Izinkinobho zomsakazo weqembu

  • 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.

Izinkinobho zomsakazo weqembu

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.

Izinkinobho zomsakazo weqembu

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.

  Bala i-Sine ne-Cosine ku-Excel. Amafomula Nezibonelo
Javier Chirinos

Javier Chirinos

Igama lami ngingu-Javier Chirinos futhi ngizifela ngobuchwepheshe. Kusukela kudala, ngangithanda ama-computer nemidlalo ye-video futhi leyo nto yokuzilibazisa yagcina isiwumsebenzi.

Bengilokhu ngishicilela mayelana nobuchwepheshe namagajethi ku-inthanethi iminyaka engaphezu kwe-15, ikakhulukazi ku- mundobytesPlay

Nginguchwepheshe futhi kwezokuxhumana nokumaketha ku-inthanethi, futhi nginolwazi ngokuthuthukiswa kwe-WordPress.