Ikintu cyingirakamaro cyane muri gahunda ya Microsoft Excel ni ugutoranya ibipimo. Ariko, ntabwo buri mukoresha azi kubijyanye nibikoresho. Hamwe nacyo, urashobora guhitamo agaciro kambere, usunika ibisubizo byanyuma ugomba kubigeraho. Reka tumenye uburyo bwo gukoresha ibiranga ibipimo bya parameter muri Microsoft Excel.
Ishingiro ryimikorere
Niba byoroshe kuvuga kubyerekeye ishingiro ryimikorere yo guhitamo ibipimo, noneho birariba mubyukuri ko umukoresha ashobora kubara amakuru akenewe kugirango agere kubisubizo runaka. Iyi mikorere isa nigikoresho cyibikoresho byo gufata ibyemezo, ariko ni inzira yoroshye. Irashobora gukoreshwa gusa muburyo bumwe, ni ukuvuga kuri buri seliri ukeneye gukora igihe cyose iki gikoresho. Byongeye kandi, imikorere yo guhitamo parameter irashobora gukorerwa gusa kuntangiriro imwe gusa, kandi kimwe mubisobanuro byifuzwa, bikabigaragaza, nkigikoresho gifite imikorere mike.Imikorere yo gusaba mubikorwa
Kugirango wumve uko iyi mikorere ikora, nibyiza gusobanura ishingiro ryayo murugero rufatika. Tuzasobanura ibikorwa byigikoresho kurugero rwa gahunda ya Microsoft 2010, ariko ibikorwa algorithm mubyukuri muri verisiyo yakurikiyeho nyuma yiyi gahunda, no mu 2007.
Dufite umushahara wumushahara wumushahara nabakozi bakomeye. Hariho ibihembo byabakozi gusa. Kurugero, bonus imwe murimwe - Nikolaev A. d, ni 6035.68. Kandi, birazwi ko premium ibarwa mugwiza umushahara kuri coekelet ya 0.28. Tugomba kubona umushahara w'abakozi.
Kugirango utangire imikorere mugihe muri tab "data", kanda kuri "gusesengura" niba "", uherereye muri "gukorana na" gukora hamwe na data "kuri kaseti. Ibikubiyemo bigaragara aho ushaka guhitamo "guhitamo ibipimo ...".
Nyuma yibyo, idirishya ryo guhitamo parameter rifungura. Muri "shyira mu murima", ugomba kwerekana aderesi yayo ikubiyemo amakuru yanyuma azwi, ibyo tuzahitamo kubara. Muri iki gihe, iyi ni selile aho umukozi wumukozi wa Nikolaev yashizwemo. Aderesi irashobora guterwa intoki mugukiza guhuza umurima uhuye. Niba ubona bigoye gukora, cyangwa ukabitekereza bitoroshye, hanyuma ukande kuri selile wifuza, kandi aderesi izinjira mumurima.
Umurima "Agaciro" usaba kwerekana agaciro kadasanzwe k'igihembo. Ku bitureba, bizaba 6035.68. Muri "guhinduranya indangagaciro", winjiza adresse yayo irimo amakuru yinkomoko dukeneye kubara, ni ukuvuga umushahara wumukozi. Ibi birashobora gufatwa inzira zimwe twavuze haruguru: gutwara imirongo itandukanye, cyangwa ukande kuri selire ikwiye.
Iyo ibipimo byose byagati byuzuye, kanda kuri buto ya OK.
Nyuma yibyo, kubara bikorwa, hamwe nindangagaciro zatoranijwe zihuye na selile, nkuko byatangajwe nidirishya ryihariye ryamakuru.
Igikorwa nkiki kirashobora gukorwa kubandi mirongo y ameza, niba agaciro ka premium yabandi basigaye bizwi.
Gukemura ibingana
Mubyongeyeho, nubwo iyi atari ikintu cyumwirondoro cyiki gikorwa, birashobora gukoreshwa mugukemura ibingana. Nibyo, igikoresho cyo guhitamo parameter kirashobora gukoreshwa gusa kubijyanye no kugaburira hamwe numwe utazwi.
Dufate ko dufite ikigereranyo: 15x + 18x = 46. Andika igice cyacyo cyibumoso, nka formula, muri kamwe muri kalls. Naho formulayo zose zirenze, mbere yo kugereranya, dushyira ikimenyetso "=". Ariko, icyarimwe, aho kuba ikimenyetso X, washyizeho aderesi ya selile aho ibisubizo byigihe wifuza bizerekanwa.
Ku bitureba, twandika formula muri C2, kandi agaciro kagiye kugaragara muri B2. Rero, ibyanditswe mu kagari ka C2 bizaba bifite urupapuro rukurikira: "= 15 * B2 + 18 * b2".
Dutangira imikorere muburyo bumwe nkuko byasobanuwe haruguru, ni ukuvuga ukanze ku "gusesengura" ko niba "" "kuri kaseti," hanyuma uhitemo ibipimo "guhitamo ibipimo ...".
Mu idirishya ryo gutoranya ibipimo rifungura, muri "Kwinjiza mu murima", byerekana aderesi twanditse kugereranya (C2). Mu rwego rwa "Agaciro", andika umubare wa 45, kubera ko twibuka ko ikigereranyo ari gukurikira: 15x + 18x = 46. Mumwanya wa "Guhindura Akagurisha ka Akagari", tugaragaza aderesi aho X agaciro igaragara, ni ukuvuga, mubyukuri, igisubizo cyikigereranyo (B2). Tumaze kwinjira muri aya makuru, kanda buto "OK".
Nkuko mubibona, Microsoft Excel yakemuye neza ikigereranyo. Agaciro ka x bizaba 1.39 mugihe.
Nyuma yo gusuzuma igikoresho cyo gutoranya parameter, twasanze byoroshye, ariko mugihe kimwe cyingirakamaro kandi byoroshye kubona umubare utazwi. Irashobora gukoreshwa haba kumeza no gukemura ikigereranyo hamwe numwe utazwi. Muri icyo gihe, ukurikije imikorere, ni munsi yikikoresho gikomeye cyo gukemura.