Mubikorwa byibikorwa byimibare bushobora gukora Microsoft Excel, mubisanzwe birahari kandi kugwiza. Ariko, ikibabaje, ntabwo abakoresha bose bazi uburyo bwo gukoresha byimazeyo kandi bakoresheje neza aya mahirwe. Reka tumenye uburyo bwo gukora uburyo bwo kugwiza muri Microsoft Excel.
Amahame yo Kugwiza muri Excel
Kimwe nibindi bikorwa byimibare muri gahunda ya Excel, kugwiza bikorwa ukoresheje formula idasanzwe. Ibikorwa byo kugwira byanditswe ukoresheje ikimenyetso - "*".Kugwiza imibare isanzwe
Gahunda ya Microsoft Excel irashobora gukoreshwa nkumubare, kandi igwira umubare utandukanye.
Kugirango ugwize numero imwe kurindi, andika muri selile iyo ari yo yose ku rupapuro, cyangwa mu mugozi wa formula, ikimenyetso kingana na (=). Ibikurikira, vuga ikintu cya mbere (umubare). Noneho, shyira ikimenyetso kugirango ugwire (*). Noneho, andika ikintu cya kabiri (umubare). Rero, inyandikorugero rusange yo kugwiza izareba ibi bikurikira: "= (umubare) * (umubare)".
Urugero rwerekana kugwiza kwa 564 kugeza 25. Igikorwa cyanditswe na formula ikurikira: "= 564 * 25".
Kugirango urebe ibisubizo byibarwa, ugomba gukanda kurutonde rwinyandiko.
Mugihe cyo kubara, ugomba kwibuka ko ibikorwa byingenzi byimibare muri Excel, kimwe no mumibare isanzwe. Ariko, ikimenyetso cyo kugwiza kigomba kongeramo uko byagenda kose. Niba iyo wanditse imvugo yemerewe kugabanya ikimenyetso cyo kugwiza imbere yumutwe, noneho muri Excel, kugirango ubarize neza, birasabwa. Kurugero, imvugo 45 + 12 (2 + 4), muri excel ugomba kwandikwa kuburyo bukurikira: "= 45 + 12 * (2 + 4)".
Kugwiza Akagari
Uburyo bwo kugwiza kwa Akagari ku Kagari karagabanijwe nihame rimwe nuburyo bwo kugwiza umubare. Mbere ya byose, ugomba guhitamo selile ibisubizo bizerekanwa. Muriyo shyira ikimenyetso kingana na (=). Ibikurikira, iyindi kanda kuri selile, ibikubiyemo ukeneye kugwira. Nyuma yo guhitamo buri selile, twashizeho ikimenyetso cyo kugwiza (*).
Kugwiza inkingi ku nkingi
Kugirango ugwize inkingi ku nkingi, ako kanya zikeneye kugwiza selile zo hejuru yizi nkingi, nkuko bigaragara kurugero hejuru. Noneho, duhinduka hepfo ibumoso bwuzuye. Ikimenyetso cyuzuye kiragaragara. Kubitekerezaho hamwe na buto yimbeba yibumoso yakubiswe. Rero, formula yo kugwiza yandukuwe na selile zose zinkingi.
Nyuma yibyo, inkingi zizagwira.
Mu buryo nk'ubwo, urashobora kugwiza inkingi eshatu cyangwa zirenga.
Kugwiza selile kumubare
Kugirango ugwize selile numubare, nkuko biri murwego rwavuzwe haruguru, mbere ya byose, shyira ikimenyetso kingana na (=) mu kagari uteganya kwerekana igisubizo cyibikorwa byimibare. Ibikurikira, ugomba kwandika ikigwiro cyumubare, shyira ikimenyetso cyo kugwiza (*), hanyuma ukande ku kagari ushaka kugwira.
Kugirango usohoke ibisubizo kuri ecran, kanda ahanditse Enter.
Ariko, urashobora gukora ibikorwa kandi muburyo butandukanye: ako kanya nyuma yikimenyetso kingana gukanda ku kagari, hanyuma, nyuma yikimenyetso cyo kugwiza, andika umubare. Nyuma ya byose, nkuko mubizi, akazi ntabwo karimo guhinduka kubantu bagwiza.
Muri ubwo buryo, urashobora, nibiba ngombwa, ugwize selile nyinshi numubare munini icyarimwe.
Kugwiza inkingi kumubare
Kugirango ugwize inkingi kumubare runaka, ugomba guhita ugwiza n'Akagari, nkuko byasobanuwe haruguru. Noneho, ukoresheje ikimenyetso cyuzuye, wandukure formula yerekeza muri selile zo hasi, kandi tubona ibisubizo.
Kugwiza inkingi kuri selire
Niba umubare uri mu kagari runaka kugirango ugwize inkingi, kurugero, hariho coefficient runaka, uburyo bwavuzwe haruguru ntabwo bukwiye. Ibi biterwa nuko iyo gukoporora bizahindurwa nurwego rwabagwiri, kandi dukeneye umwe mubagwiza uhoraho.
Ubwa mbere, meze nuburyo busanzwe selile yambere yinkingi ku kagari, ikubiyemo amasezerano. Byongeye, muri formula, dushyira ikimenyetso cyamadorari imbere yinsanganyamatsiko yinkingi n'imirongo yerekana selile hamwe na coeFent. Muri ubu buryo, twahinduye umuvandimwe kwerekeza kuri Byuzuye, imirongo ihoraho itazahinduka mugihe cyo gukoporora.
Noneho, iracyasigaye muburyo busanzwe, ikoresheje ikimenyetso cyuzuye, kopi formula mubindi bigo. Nkuko mubibona, ibisubizo byiteguye byahise bigaragara.
Isomo: Nigute ushobora gukora ihuriro ryuzuye
Umusaruro
Usibye uburyo busanzwe bwo kugwiza, hari amahirwe yo gukoresha umurimo wihariye kuriyi ntego muri Excel. Urashobora kubyita inzira zose nkizindi mikorere.
- Gukoresha imikorere wizard ushobora gukoresha ukanze kuri buto "Shyiramo imikorere".
- Binyuze muri formula. Kuba muri yo, ugomba gukanda kuri buto ya "imibare", iherereye kuri kaseti muri "Isomero ryibitabo byibitabo. Noneho, kurutonde rugaragara, hitamo "umusaruro".
- Hamagara izina ryimikorere, nintonde zayo, intoki, nyuma yikimenyetso kingana na (=) mu kagari wifuza, cyangwa mumirongo ya formula.
Noneho, ugomba kubona imikorere yibicuruzwa, mumadirishya yimyitozo yo gukora, hanyuma ukande buto "OK".
Imikorere yerekana intoki ni izi zikurikira: "= Umusaruro (umubare (cyangwa guhuza selile); nimero (cyangwa ihuza selile); ...)". Ni ukuvuga, niba kurugero, dukeneye 77 kugwira na 55, kandi tugwire na 23, hanyuma andika formula ikurikira: "= Yakozwe (77; 5)" 23) ". Kugaragaza ibisubizo, kanda kuri buto yinjira.
Mugihe ukoresheje amahitamo abiri yambere yo gukoresha imikorere (ukoresheje formula formulaires wizard), idirishya rizafungura kugirango ryinjire kugirango ryinjire muburyo bwimibare, cyangwa aderesi. Ibi birashobora gukorwa mugukanda gusa kuri selile wifuza. Nyuma yo kwinjira mu mpaka, kanda buto "OK" kugirango ukore kubara, no gusohoka ibisubizo kuri ecran.
Nkuko mubibona, muri gahunda ya Excel Hariho umubare munini wamahitamo yo gukoresha ibikorwa byimibare nko kugwiza. Ikintu nyamukuru nukumenya ibikoresho byo gukoresha formulaition muri buri kibazo.