Gutunganya amakuru nicyegeranyo, gutumiza, rusange no gusesengura amakuru hamwe nibishoboka byo kumenya icyerekezo kandi giteganijwe kubitekerezo byize. Excel afite umubare munini w'imanza ibikoresho ubufasha n'imyifatire ubushakashatsi muri ako karere. Impinduro zigezweho ziyi gahunda mubijyanye namahirwe ntabwo ziruta kubisabwa byihariye mu bijyanye n'imibare. Ibikoresho byingenzi byo kurangiza kubara no gusesengura nibikorwa. Reka inyigisho peculiarities rusange gukorana na bo, ndetse mu buryo burambuye ku giti ibikoresho cyane akamaro.
Imikorere y'ibarurishamibare
Kimwe nindi mirimo iyo ari yo yose muri Excel, imikorere y'ibarurishamibare ikorera impaka zishobora kugira uburyo bwo guhuza buri gihe, ihuza selile cyangwa inkuta.
Imvugo irashobora gutangwa intoki muri selile yihariye cyangwa mumurongo wa formula, niba uzi syntax yihariye muri zo. Ariko byoroshye gukoresha idirishya ryihariye ryimpaka, ririmo ibisobanuro kandi bimaze gukorwa imirima yinjira. Urashobora kujya mu mbaraga zibarurishamibare idirishya unyuze muri "imikorere wizard" cyangwa ukoresheje "amasomero yimikorere" buto kuri kaseti.
Tangira imirimo wizard muburyo butatu:
- Kanda kuri "Shyiramo imikorere" ibumoso bwumurongo wa formula.
- Kuba muri tab "formula", kanda kuri kaseti kuri buto "shyiramo imikorere" muburyo bwa Toolbar.
- Hamagara shift + f3 urufunguzo kuri clavier.
Iyo ukora kimwe mumahitamo yavuzwe haruguru, idirishya rya "imikorere" rifungura.
Noneho ugomba gukanda kuri "icyiciro" hanyuma uhitemo agaciro "imibare".
Nyuma yibyo, urutonde rwibisobanuro byibarurishamibare bizagaragara. Hariho amajana. Kugirango ujye mu idirishya rya buri wese muri bo, ukeneye kubigaragaza hanyuma ukande kuri buto ya "OK".
Kugirango wimuke mubintu ukeneye ukoresheje kaseti, twimukira muri tab "formula". Mu itsinda ryibikoresho byisomero ryibitabo byibikorwa, kanda buto "Ibindi bikorwa". Kurutonde rufungura, hitamo icyiciro "ibarurishamibare". Urutonde rwibintu bihari byicyerekezo ukeneye bizagaragara. Kujya mu idirishya ryimpaka, birahagije gukanda kuri kimwe muri byo.
Isomo: Umukozi wa Wizard muri Excel
Max
Umukoresha wa Max yashizweho kugirango umenye umubare ntarengwa kurugero. Ifite syntax ikurikira:
= Max (Umubare1; Umubare2; ...)
Mu murima wa impaka, ugomba kwinjira mu Ibice Bya Utudirishya in A Urubariro Bikurikije umubare iherereye. Inzira Ibi bizana umubare munini wa mu ko kagari bikaba ubwe iherereye.
Min.
Mu izina rya Umumaro min, biragaragara ko imirimo yayo butaziguye warwanyije Inzira Ibanjirije - ni gushakisha indiri umubare muto no kugaragarizanya ko mu kagari bahawe. Ifite nk'uwo Igaragaza:
= Min (number1; number2; ...)
Srnzoke
Umumaro wa ugenzura SRVNAH kuko umubare mu Urutonde vyashinzwe, ni hafi agaciro hagati riyigize. Ingaruka imibare ni in A Akazu bitandukanye aho Inzira ifite. Ni ibi bikurikira:
= SRNVOV (number1; number2; ...)
Srvanchesli
Igihe ubwikorezi imirimo kimwe kimwe mbere, ariko afite ubushobozi bwo gushyiraho imimerere andi. Urugero, more, munsi, atangana umubare runaka. Ni in murima bitandukanye kuko mwatonganaga. Uretse, ugereranyije Urutonde Kyongewe Nka Bitari ngombwa. Syntax ni izi zikurikira:
= Сростовичисти (number1; number2; ...; imimerere; [range_))
Ukogiteye
Formula Fashion.One aragaragaza umubare Kuva: A Gushyiraho iteranira kenshi. Mu mpinduro kera, Excel hariho Fashion Umumaro, ariko mu nyuma yari icukurwa babiri:. Fashion UKO (kuko imibare giti) na fashion NSK (kuko tutabonwa).. Ariko, ku Ihitamo ashaje yagumye mu itsinda bitandukanye mu Ibintu yakusanyijwe mu mpinduro za kera gahunda kugira Bihuye inyandiko.
= Moda.One (number1; number2; ...)
= MATA.NSK (number1; number2; ...)
w'Abamedi
Umukoresha w'Abamedi igena igiciro mpuzandengo mu umubare Imibare. Ni ukuvuga ko rishyiraho si mpuzandengo riyigize, ariko gusa agaciro mpuzandengo hagati mukuru na hasi umubare karere indangagaciro. Igaragaza nka iyi:
= W'Abamedi (number1; number2; ...)
Standotclona
Formula Standotlaglon ndetse fashion ni amasigarira verisiyo ishaje gahunda. Ubu hamwe cyatangiye gukoreshwa na subspecies yayo kijyambere - Standotclona.V na Standotclona.g. Mbere abo bigenewe kubara Bisanzwe gutandukira ya enyanjura ku, na i ISEGONDA ni abaturage rusange. Imimaro Abo kandi gukoreshwa kugira ngo abare mpuzandengo gutandukira quadratic. Igaragaza ni ibi bikurikira:
= VeritClonil.V (Umubare1; Umubare2; ...)
= Seriatecloning.g (Umubare1; Umubare2; ...)
Isomo: Gutandukana kwa Quadratic Thiadet muri Excel
Gallest
Uyu mukoresha yerekana umubare uvuye kurishyizweho ryerekanwe muri selire yatoranijwe. Ni ukuvuga, niba dufite ihuriro rya 12.97.89.65, kandi ingingo 3 yo gutongana, noneho imikorere yo mu Kagari izasubiza umubare wa gatatu munini. Muri iki kibazo, ni 65. Syntax ikora ni:
= Nini (array; k)
Muri uru rubanza, K numubare ukurikirana wagaciro.
Byibuze
Iyi mikorere nindorerwamo yerekana umukoresha wabanjirije. Nubundi mpaka ya kabiri numubare ukurikirana numero. Ariko muriki gihe, gahunda ifatwa nkibito. Syntax ni:
= Ntoya (array; k)
Rank.sr.
Iyi mikorere ifite ingaruka mbi. Mu kagari kagenwe, itanga umubare ukurikirana wumubare wihariye kurugero ukurikije imiterere yerekanwe mu mpaka zitandukanye. Birashobora kuba itegeko ryo kwiyongera cyangwa kumanuka. Iheruka gushyirwaho muburyo busanzwe niba "itegeko" ririmo ubusa cyangwa shyira imibare 0 ngaho. Syntax yiyi mvugo ni izi zikurikira:
= Stak.sr (umubare; array; gutumiza)
Hejuru yimikorere izwi cyane kandi isaba kuba indashyikirwa zasobanuwe haruguru. Mubyukuri, ni inshuro nyinshi. Ariko, ihame nyamukuru rirasa nabo: gutunganya amakuru array hanyuma usubire muri selile yagenwe ibisubizo byo kubara ibikorwa.