Gukuraho imizi hagati yikibazo kimeze neza. Bisaba kubara bitandukanye mumeza. Microsoft Excel ifite uburyo bwinshi bwo kubara agaciro. Reka dusuzume mu buryo burambuye kumvikana ku bibarirwa muri iyi gahunda.
Uburyo bwo gukuramo
Hariho uburyo bubiri bwibanze bwo kubara iki kimenyetso. Imwe muribi irakwiriye gusa kubara imizi ya kare, naho iya kabiri irashobora gukoreshwa mukubara agaciro kamwe.Uburyo 1: Igikorwa cyo gusaba
Kugirango ukureho imizi ya kare, imikorere ikoreshwa, yitwa umuzi. Syntax yayo isa nkiyi:
= Umuzi (umubare)
Kugirango ukoreshe ubu buryo, birahagije kwandika kuri selire cyangwa mumirongo ya porogaramu iyi mvugo, gusimbuza ijambo "nimero" cyangwa kuri aderesi ya selile aho iherereye.
Gukora kubara no gusohoka kubisubizo kuri ecran, kanda buto yimtonde.
Mubyongeyeho, urashobora gukoresha iyi fomulare binyuze mumutware wimikorere.
- Kanda kuri selire kurupapuro aho ibisubizo byibarwa bizerekanwa. Genda unyuze kuri buto "andika imikorere", washyizwe hafi yumurongo wimikorere.
- Kurutonde rufungura, hitamo umuzi. Kanda kuri buto ya "OK".
- Idirishya ry'impaka rifungura. Mu rwego rwonyine rw'iyi idirishya, ugomba kwinjiza agaciro runaka uzakurwaho cyangwa imirongo ya selire aho iherereye. Birahagije gukanda kuri selile kugirango adresse yayo yinjizwe mumurima. Nyuma yo kwinjira kuri data, kanda buto "OK".
Nkigisubizo, ibisubizo byibarwa bizerekanwa mu kagari kagenwe.
Kandi, imikorere irashobora guhamagarwa binyuze muri tab "formula".
- Hitamo selile kugirango werekane ibisubizo byo kubara. Jya kuri tab "formulaire".
- Mu gitabo cya "Imikorere Isomero" kumurongo kuri kaseti kanda kuri buto "imibare". Kurutonde rugaragara, hitamo agaciro "umuzi".
- Idirishya ry'impaka rifungura. Ibindi bikorwa byose neza ni kimwe no mubikorwa binyuze muri buto "yanditseho".
Uburyo 2: Ishyirwaho
Kubara imizi ya cubic ukoresheje amahitamo yavuzwe haruguru ntabwo bizafasha. Muri iki gihe, ubunini bugomba kubakwa murwego rwo kugabana. Ubwoko rusange bwa formula yo kubara ni:
= (umubare) ^ 1/3
Ni ukuvuga, ntabwo ari no gukuramo, ariko kubaka agaciro ka 1/3. Ariko iyi mpamyabumenyi kandi ni imizi cubic rero, iki gikorwa muri excel gikoreshwa kugirango wabyakire. Aho kuba umubare runaka, birashoboka kandi kwinjira kumurongo wa selile ufite amakuru yumubare. Inyandiko ikorwa ahantu hose h'urupapuro cyangwa muri formula.
Ntigomba gutekerezwa ko ubu buryo bushobora gukoreshwa gusa kugirango dukure umuzi uva muri. Muri ubwo buryo, kare kandi izindi mizi iyo ari yo yose irashobora kubarwa. Ariko muriki gihe gusa hagomba gukoresha formula ikurikira:
= (umubare) ^ 1 / n
n ni urwego rwo kubyutsa.
Rero, iyi option ni nyinshi cyane kuruta gukoresha uburyo bwa mbere.
Nkuko tubibona, nubwo nta gikorwa cyihariye muri Excel kigomba gukuramo imizi cubique, iyi mibare irashobora gukorerwa ukoresheje ubwubatsi bwimpamyabumenyi, aribyo 1/3. Kugirango ukureho imizi ya kare, urashobora gukoresha imikorere idasanzwe, ariko hariho umwanya wo kubikora ushyiraho numero. Iki gihe uzakenera kwinjiza kugeza 1/2. Umukoresha ubwe agomba kumenya uburyo bwo kubara bunosoye.