Ngenqubo yokubala okuhlukahlukene nokusebenza nedatha, imvamisa kuyadingeka ukubala inani labo eliphakathi. Ibalwa ngokungeza izinombolo futhi ihlukanise inani eliphelele ngenombolo yazo. Ake sibheke ukuthi singabalwa kanjani inani eliphakathi leqoqo lezinamba usebenzisa iMicrosoft Excel ngezindlela ezahlukahlukene.
Indlela ejwayelekile yokubala
Indlela elula futhi eyaziwa kunazo zonke yokuthola izinani ezisetshenziswayo zezibalo ukusebenzisa inkinobho ekhethekile kubambo lweMicrosoft Excel. Khetha uhla lwezinombolo ezitholakala kukholamu noma irowu ledokhumenti. Ukuba kuthebhu "Yasekhaya", chofoza inkinobho "AutoSum", ebekwe iribhoni ku "Ithuluzi" lokuvimba amathuluzi. Ukusuka ohlwini olwehlayo, khetha "Okumaphakathi".
Ngemuva kwalokho, kusetshenziswa umsebenzi "OBUHLEKILE", ukubalwa kuyenziwa. I-arithmetic isho lokhu kusethwa kwezinombolo esitokisini ngaphansi kwekholomu ekhethiwe, noma ngakwesokudla komugqa okhethiwe.
Le ndlela yinhle ngokulula nokulula. Kepha, futhi unobunzima obukhulu. Usebenzisa le ndlela, ungbala inani eliphakathi lalezo zinombolo ezitholakala kumugqa kukholamu eyodwa, noma umugqa owodwa. Kepha, ngamaseli amaningi, noma ngamaseli asakazekile eshidini, awukwazi ukusebenza ngale ndlela.
Isibonelo, uma kukhethwe amakholomu amabili, bese kusho ukuthi izibalo zibalwa ngendlela echazwe ngenhla, khona-ke impendulo izonikezwa ikholomu ngayinye ngokwahlukana, hhayi lonke uhlu lwamaseli.
Ukubalwa usebenzisa Umsebenzi Wizard
Okwamacala lapho udinga ukubala isilinganiso sokubala samalungu amangqamuzana, noma amaseli ahlukanisiwe, ungasebenzisa Umsebenzi Wizard. Usebenzisa umsebenzi ofanayo we- “AVERAGE”, esiwaziyo ukusuka kwindlela yokubala yokuqala, kepha ukwenze ngendlela ehlukile.
Sichofoza kuseli lapho sifuna khona umphumela wokubala inani eliphansi ukuthi liboniswe. Chofoza inkinobho ethi "Faka Umsebenzi", etholakala kwesokunxele sebha lefomula. Noma, sithayipha kukhibhodi inhlanganisela yeShift + F3.
Umsebenzi wizard uqala. Uhlu lwemisebenzi eyethuliweyo, funa i- "AVERAGE". Khetha lona, bese uchofoza inkinobho "Kulungile".
Iwindi lokuphikisana lalomsebenzi liyavula. Izimpikiswano zomsebenzi zifakiwe kumasimu ezinamba. Lezi kungaba yizinombolo ezijwayelekile noma amakheli amaseli lapho zitholakala khona lezi zinombolo. Uma kungenzeki kuwe ukufaka amakheli amaseli ngesandla, kuzofanela uchofoze inkinobho ebekwe ngakwesokunene senkambu yokufaka idatha.
Ngemuva kwalokho, iwindi lokuphikisana komsebenzi lizoncishiswa, futhi ungakhetha iqembu lamaseli eshidini olithatha ukubalwa. Ngemuva kwalokho, chofoza inkinobho engakwesokunxele yenkambu yokungena yedatha ukubuyela ewindini lokuphikisana lomsebenzi.
Uma ufuna ukubala okusho kokubala phakathi kwezinombolo ezitholakala emaqenjini ahlukanisiwe amaseli, bese wenza izinto ezifanayo ezishiwo ngenhla, zenze endimeni "yeNombolo 2". Futhi kuze kube yilapho wonke amaqembu adingekayo amaseli ekhethiwe.
Ngemuva kwalokho chofoza inkinobho "Kulungile".
Umphumela wokubala okushiwo yi-arithmetic uzoqokonyiswa esitokisini osikhethile ngaphambi kokuqala Umsebenzi Wizard.
Ibha Yefomula
Kunendlela yesithathu yokusebenzisa umsebenzi we-AVERAGE. Ukuze wenze lokhu, iya kuthebhu "yamaFomula". Khetha iseli lapho umphumela uzokhonjiswa khona. Ngemuva kwalokho, eqenjini leThuluzi le- "Function Library" eqenjini, chofoza inkinobho "Eminye Imisebenzi". Uhlu luyavela lapho udinga ukuya khona ngokulandelana kwezinto "Statistical" kanye ne "AVERAGE".
Ngemuva kwalokho, kusungulwa iwindi elifanayo lokuphikisana komsebenzi lapho kusetshenziswa i-Function Wizard, umsebenzi esichaze ngawo imininingwane engenhla.
Izenzo ezengeziwe ziyafana impela.
Ukungena komsebenzi wesandla
Kepha, ungakhohlwa ukuthi ungahlala ufake i-"AVERAGE" ngesandla uma ufisa. Kuzoba nephethini elandelayo: "= AVERAGE (cell_range_address (inombolo); cell_range_address (inombolo)).
Vele, le ndlela ayilungeki njengaleyo edlule, futhi idinga amafomula athile ukuthi agcinwe engqondweni yomsebenzisi, kepha iyaguquguquka.
Ukubalwa kwenani elijwayelekile lesimo
Ngokungeziwe ekubalweni okujwayelekile kwenani elijwayelekile, kungenzeka ukubala inani eliyisilinganiso ngokuya ngesimo. Kulokhu, kuphela lezo zinombolo ezivela ebangeni elikhethiwe elihambelana nesimo esithile ezizonakwa. Isibonelo, uma lezi zinombolo zikhulu noma zingaphansi kwenani elithile.
Ngalezi zinhloso, kusetshenziswa umsebenzi we- “AVERAGE”. Njengomsebenzi we- "AVERAGE", ungavulwa nge-Function Wizard, kusuka kubha formula, noma ngokungena esitokisini. Ngemuva kokuthi iwindi lokuphikisana nomsebenzi livulekile, udinga ukufaka amapharamitha alo. Ensimini ethi "Range", faka uhla lwamaseli amanani wawo azobandakanyeka ekunqumeni isilinganiso se-arithmetic. Lokhu sikwenza ngendlela efanayo nangomsebenzi we-AVERAGE.
Futhi lapha, endimeni "Isimo" kufanele sikhombe inani elithile, izinombolo ngaphezulu noma ngaphansi kwalokho kuzobandakanya ukubala. Lokhu kungenziwa kusetshenziswa izimpawu zokuqhathanisa. Isibonelo, sithathe isisho esithi "> = 15000". Okusho ukuthi, amaseli kuphela wobubanzi lapho izinombolo ezinkulu noma zilingana ne-15000 zithathwe ukubalwa. Uma kunesidingo, esikhundleni senombolo ethile, lapha ungacacisa ikheli leseli lapho inamba ehambelana nalo itholakala khona.
Inkambu ye-Averaging Range iyakhethwa. Ukufaka idatha kukho kuyimpoqo kuphela uma usebenzisa amaseli anokuqukethwe kombhalo.
Lapho yonke idatha ifakiwe, chofoza inkinobho "Kulungile".
Ngemuva kwalokho, umphumela wokubala isilinganiso sesibalo sebanga elikhethiwe sikhonjiswa kuseli elikhethwe ngaphambilini, ngaphandle kwamaseli anedatha engahlangabezani nemibandela.
Njengoba ukwazi ukubona, kuMicrosoft Excel, kunenombolo yamathuluzi ongabala ngayo inani eliphakathi kochungechunge lwezinombolo olukhethiwe. Ngaphezu kwalokho, kukhona umsebenzi okhetha ngokuzenzakalelayo izinombolo kusuka kubanga abangahlangabezani nenqubo ebekwe umsebenzisi ngaphambi kwesikhathi. Lokhu kwenza ukuba kwikhompyutha kube lula kakhulu kubasebenzisi be-Microsoft.
