I-oda le-opharetha lisho imisebenzi ye-Excel Statistical. Umsebenzi wayo ophambili ukubala uhla olubekiwe lwamaseli lapho idatha yezinombolo iqukethe. Masifunde kabanzi ngemininingwane eminingi izici ezahlukahlukene zokusetshenziswa kwale formula.
Ukusebenza ne-akhawunti yomhlinzeki
I-akhawunti yokusebenza ibhekisa eqenjini elikhulu labasebenza bezibalo, okubandakanya ngamakhulu ezinto. Isondele kakhulu kuyo emisebenzini yakho umsebenzi we-akhawunti. Kepha, ngokungafani nendaba yengxoxo yethu, kudinga amaseli agcwele noma iyiphi idatha. I-akhawunti ye-opharetha esizoziphatha ngayo ingxoxo eningilizayo iholela kumaseli agcwele idatha ngefomethi yenombolo.Iyiphi idatha ehlobene nenombolo yenombolo? Lokhu nakanjani phakathi kwezinombolo zangempela, kanye nefomethi yesikhathi nesikhathi. Amanani we-Logic ("Iqiniso", "Amanga", njll.) I-akhawunti yokusebenza ibheka kuphela lapho seyiphikisana ngqo ngqo. Uma zimane nje zisendaweni yephepha, ebhekiswe yingxabano, khona-ke kulokhu opharetha akenzi. Isimo esifanayo nesibonakaliso esingumbhalo sezinombolo, okungukuthi, lapho izinombolo zibhalwe ngezingcaphuno noma ezizungezwe ezinye izibonakaliso. Lapha futhi, uma zinengxabano eqondile, zibamba iqhaza ekubalweni, futhi uma zimane nje ziseshidi, azikwamukeli.
Kepha maqondana nombhalo ohlanzekile lapho izinombolo zingekho, noma izinkulumo eziyiphutha ("# zamacala / 0! Izindinganiso ezinjalo i-akhawunti yokusebenza ayicabangi nganoma yiluphi uhlobo.
Ngaphezu kwemisebenzi, i-akhawunti kanye ne-akhawunti ekubaleni inani lamaseli agcwalisiwe lisabandakanyeka kuma-opharetha amamitha awela. Usebenzisa la mafomula, ungabala ngezimo ezingeziwe. Leli qembu labasebenzi bezibalo linikelwe esihlokweni esihlukile.
Isifundo: Indlela yokubala inani lamaseli agcwalisiwe ku-Efpelle
Isifundo: Imisebenzi yezibalo e-Excel
Indlela 1: I-Master of Imisebenzi
Ngomsebenzisi ongenalwazi, kulula ukubala amaseli aqukethe izinombolo usebenzisa i-Scorehold usebenzisa iWizard Yomsebenzi.
- Chofoza esitokisini esingenalutho eshidini lapho umphumela wokubalwa uzokhonjiswa. Chofoza inkinobho ethi "PASTE function".
Kukhona enye inketho yokuqala iWizard yemisebenzi. Ukuze wenze lokhu, ngemuva kokukhethwa kweseli, udinga ukuya kuthebhu ethi "Amafomu". Ethepheni kubha yamathuluzi "yomtapo wezincwadi", chofoza inkinobho ethi "PASTE function".
Kukhona enye inketho, mhlawumbe okulula, kepha ngasikhathi sinye kudinga inkumbulo enhle. Sigqamisa iseli eshidini bese sicindezela inhlanganisela yokhiye kukhibhodi ye-Shift + F3.
- Kuwo wonke amacala amathathu, iwindi lomsebenzi lizoqala. Ukuya efasiteleni lezimpikiswano esigabeni "sezibalo" noma "uhlu olugcwele lwezinhlamvu" Sifuna i-akhawunti "ye-Akhawunti". Siyigqabisisa bese uchofoza inkinobho ethi "Kulungile".
Futhi, iwindi lokuphikisana lingathunyelwa ngenye indlela. Siqokomisa iseli ukukhombisa umphumela bese iya kuthebhu "yefomula". Ku-Ribbon ku- "Work Library Library" Izilungiselelo Zeqembu, chofoza inkinobho "Eminye imisebenzi". Kusukela ohlwini oluvelayo, uzoletha isikhombisi esimweni esithi "Statistical". Kumenyu evula, khetha into "ye-akhawunti".
- Iwindi lezimpiko liqala. Ukuphela kwengxabano yale formula okungenziwa inani elethulwe njengesixhumanisi noma ukumane kuqoshwe enkundleni ehambisanayo. Kuliqiniso, kusukela ku-Excel 2007, amanani anjalo angaba ngu-255 kufakiwe. Ezinguqulweni zangaphambilini bekukhona kuphela ama-30.
Ungabeka imininingwane enkundleni ngokuthayipha amanani athile noma izixhumanisi zeseli kusuka kukhibhodi. Kepha lapho isethi yokuxhumanisa kulula kakhulu ukumane ifake isikhombisi enkundleni bese ukhetha iseli ehambisanayo noma ububanzi eshidini. Uma amabanga athile athile, ikheli lesibili lingasetshenziswa enkambu ye- "value2", njll. Ngemuva kwamanani abhalwe phansi, chofoza inkinobho ethi "Kulungile".
- Umphumela wokubala amaseli aqukethe amanani ezinombolo ebangeni elizinikezele azoboniswa endaweni yokuqala eshidini.
Isifundo: Imisebenzi yeWizard ku-Excel
Indlela 2: Ukubalwa kusetshenziswa impikiswano eyengeziwe
Esibonelweni esingenhla, sibheke leli cala lapho izingxabano zibhekiswe kuphela kumabanga eshidi. Manje ake sibheke inketho lapho amanani abhalwe khona ngqo enkundleni yokuphikisana nawo ayasetshenziswa.
- Kunoma yiziphi izinketho ezichazwe ngendlela yokuqala, gijimani iwindi lengxabano lomsebenzi we-akhawunti. In the "I-Value1" field, chaza ikheli ledatha yedatha, nakumomu we- "Value2" afanele inkulumo enengqondo ethi "Iqiniso". Chofoza inkinobho ethi "Kulungile" ukwenza ukubalwa.
- Umphumela uboniswa endaweni ekhethwe ngaphambili. Njengoba sikwazi ukubona, lolu hlelo lubale inani lamangqamuzana ngamanani ezinombolo futhi kwinani eliphelele elingezele kuwo elinye inani elithi "iqiniso" ensimini yokuphikisana. Uma le nkulumo iqoshwe ngqo esitokisini, nasensimini kuphela bekuzoba khona ukuxhumana kwayo, khona-ke bekungeke kwengezwe enanini eliphelele.
Indlela 3: Ukwethulwa Kwendlela Yefomula
Ngaphezu kokusebenzisa i-wizard yemisebenzi kanye namawindi okuphikisana, umsebenzisi angafaka isisho esizowo mathupha kunoma yisiphi iseli eshidini noma entanjeni yefomula. Kepha kulokhu udinga ukwazi i-syntax yalolu hlelo. Akunzima:
= Amanani (inani1; inani2; ...)
- Singenisa esitokisini isisho sefomula ngokuya nge-synntax yayo.
- Ukubala umphumela nokukhipha esikrinini, chofoza inkinobho ethi Faka, ibekwe kwikhibhodi.
Njengoba ubona, ngemuva kwalezi zenzo, imiphumela yokubalwa iyavezwa esikrinini esitokisini esikhethiwe. Kwabasebenzisi abanolwazi, le ndlela ingahle ibe lula kakhulu futhi isheshe. Kunangaphambili nokholo lwe-wizard yemisebenzi kanye newindows lezimpikiswano.
Kunezindlela eziningana zokusebenzisa umsebenzi we-akhawunti, umsebenzi oyinhloko wokuthi yikuphi okubalwa amaseli aqukethe idatha yezinombolo. Ngosizo lwefomula efanayo, imininingwane eyengeziwe ingenziwa ukubala ngqo enkambini yezimpikiswano zefomula noma ukuyiqopha ngqo esitokisini ngokuya ngesithombe salolu hlelo. Ngaphezu kwalokho, phakathi kwabasebenza bezibalo bakhona amanye amafomula ababandakanyeka ekubalweni kwamaseli agcwele ebangeni elizinikezele.