Chii chinonzi Bhokisi uye Chii chandingazoshandisa nayo muExcel?
Bhokisi Razita rinowanikwa pedyo nebharuti yepemu yepamusoro pepamusoro pebasa rebasa sezvaratidzwa mumufananidzo kuruboshwe.
Simba reBhokisi Razita rinogona kugadziriswa nekutsvaga pa ellipses (matatu matatu akajeka) ari pakati peZita reBhokisi uye bharamu yebhumu sezvinoratidzwa mumufananidzo.
Kunyange zvazvo basa rawo nguva dzose riri kuratidza sero rinoshandiswa sero rinoshandiswa - tsvaga pane cell D15 mubasa rekushanda uye kuti sero rinoratidzwa muZita reBhokisi - rinogona kushandiswa kune guru zvimwe zvimwe zvinhu zvakadai se:
- kutumidza uye kutarisa mabheji emasero akasarudzwa kana zvimwe zvinhu;
- kusarudza rimwe kana kuti mamwe mabheji emasero mune pepa rekushanda;
- kuenderera kumasero akasiyana mune pepaji kana bhuku rebhuku.
Kutumidza uye Kuziva Makiromita Emagetsi
Kutsanangura zita remasero akawanda kunogona kuita kuti zvive nyore kushandisa uye kuziva mazera aya mumazamu nemasharu uye zvinogona kuita kuti zvive nyore kusarudza iyo bhora neBhokisi Razita.
Kufananidza zita remutambo uchishandisa Bhokisi Razita:
- Dzvanya pane sero mune pepaji - seB2;
- Tora zita - rakafanana neRateRate;
- Dhinda pikicha inopinda mubhokisi.
Sero reB2 iye zvino rine zita reTraRRate . Chero pose apo sero B2 rakasarudzwa mune pepa rekushanda , zita rokuti TaxRate rinoratidzwa muBhokisi Razita .
Sarudza uwandu hwemasero panzvimbo pane imwe chete, uye zita rose richapiwa zita rakanyorwa muBhokisi Razita.
Kune mazita ane mararamiro einopfuura imwe kero, yose yakatarwa inofanira kusarudzwa zita risati rawanikwa muZita reBhokisi.
3R x 2C
Sezvo masero akawanda akawanda akasarudzwa mune pepa rekushanda, achishandisa mutsara kana Shift + majekiti mutsara, Bhokisi reZita rinoratidza nhamba yemakoroni nemitsetse pakusarudzwa kwezvino - zvakadai se 3R x 2C - kwemitsara mitatu nemirasi miviri.
Kana imwechete bhodhi kana Shift key iri kusunungurwa, Bhokisi reZita rinoratidza zvakare rondedzero yegasa rinoshandiswa - iro richava sero yekutanga yakasarudzwa mumutambo.
Kutumidza Mifananidzo uye Mifananidzo
Chero nguva kana chati kana zvimwe zvinhu - zvakadai sezvikwangwani kana mifananidzo - zvichange zvichisirwa pane pepa rekushanda, ivo vakapa zita racho purogiramu. Chati yekutanga yakatumidzwa inonzi Chart 1 nekusara, uye mufananidzo wokutanga: Mufananidzo 1.
Kana pepa rinoshanda rine zvinhu zvakadai, mazita anowanzotsanangurirwa kuti aite kuti zvive nyore kuenda kwavari - zvakare kushandisa Bhokisi rezita.
Kudzokorora zvinhu izvi kunogona kuitwa neBhokisi Razita vachishandisa matanho mamwechete anoshandiswa kutsanangura zita remazana emasero:
- Dzvanya pa chati kana mufananidzo;
- Tora zita racho muZita reBhokisi;
- Dhinda pikicha yePinda mukibhodi kuti upedze mushanduro.
Kusarudza Ranges nemazita
Bhokisi Razita rinogona kushandiswa kusarudza kana kusimbisa zvikamu zvemasero - kushandura kana mazita akarondedzerwa kana nekunyora mukati mezvakanyorwa.
Tora zita re defined defined muBhokisi uye Excel richasarudza iyo bhanhire mubasa rekushandisa iwe.
Bhokisi RaZita rinewo kuburitsa pasi runyorwa rine mazita ose akatsanangurwa pane peji rekushandira riripo. Sarudza zita kubva pane urongwa urwu uye Excel ichasarudza zvakare urongwa hwakakodzera
Ichi chikamu cheBhokisi reZita chinoita kuti zvive nyore kwazvo kusarudza mararamiro akakodzera vasati vaita kusarudza mabasa kana vasati vashandisa mamwe mabasa akadai saVLOOKUP, iyo inoda kushandiswa kwesarudzo yakasarudzwa.
Kusarudza Ranges ne References
Kusarudza masero ega ega kana ibha rinoshandisa Bhokisi reZita rinowanzoitwa senhanho yekutanga mukutsanangura zita remurwi.
Rimwe sero rinogona kusarudzwa nekunyora sero yaro seZita reBhokisi uye kuvhara muIndo yekupinda pane keyboard.
Rutivi rwakawandisa (hapana mazamu ari mukati-kati) yemasero anogona kuiswa pachena achishandisa Bhokisi rezita ne:
- Kushandura pane sero rekutanga mumugero nemushonga kuitira kuti iite sero rinoshanda - rakafanana neB3;
- Kunyora ruzivo rwekupedzisira chemukati mumutsetse muZita Raiti - seE6;
- Kushingairira Shift + Pinda makii pane keyboard
Chigumisiro chichava kuti masero ose ari muB3: E6 anosimbiswa.
Multiple Ranges
Nhamba dzakasiyana-siyana dzinogona kusarudzwa mune pepa rekuita nekudziisa muBhokisi Razita:
- kuverenga D1: D15, F1: F15 muZita reBhokisi richasimudza masero gumi nemashanu ari mumakamuri D uye F;
- kuverenga A4: F4, A8: F8 ichasimbisa mazana matanhatu ekutanga mumasara mana neasere;
- kuverenga D1: D15, A4: F4 ichasimbisa masero gumi nemashanu ari muchitsime D uye ma 6 ekutanga mumutsara mana.
Nzira dzakasiyana-siyana
Kusiyana pakusarudza nzvimbo dzakasiyana-siyana ndiko kungosarudza chikamu chemaviri akabatana. Izvi zvinoitwa nekuparadzanisa zvikamu zvakatsanangurwa muBhokisi reShoko nechinzvimbo panzvimbo yekombera. Semuyenzaniso,
- kuverenga D1: D15 A4: F12 muZita reBhokisi richasimbisa huwandu hwemasero D4: D12 - masero anowirirana kumativi ose maviri.
Cherechedza : Kana mazita ainge atsanangurwa pamatanda ari pamusoro apa, izvi zvingadai zvakashandiswa panzvimbo yezvinyorwa zvese.
Somuenzaniso, kana d1 D1: D15 yainzi zita rekuedzwa uye fani F1: F15 inonzi test2 , kuisa:
- kuedza, test2 muZita Razita raizosimudza mararamiro D1: D15 uye F1: F15
Yese Columns kana Rows
Zvose mapuranga kana mitsara inogonawo kusarudzwa achishandisa Bhokisi Razita, chero bedzi vari pedyo nemumwe:
- kuisa B: D kupinda muZita Zita Bhokisi rinoratidzira sero rimwe nerimwe mumakamuri B, C, uye D,
- kuverenga 2: 4 inosarudza yese sero mumitsara 2, 3, uye 4.
Kufambisa Pepa Rokushanda
Kusiyana pakusarudza masero nekunyora rondedzero yavo kana zita rakatsanangurwa muZita reBhokisi nderokushandisa matanho akafanana kuti uende kuchitokisi kana kutarisa mune pepa rekushanda.
Semuyenzaniso:
- Tora iyo reference Z345 muZita reBhokisi;
- Dhinda pikicha yoKuisa pane keyboard;
uye iyo inoshandiswa sero inosimudzira kusvitsa kwero Z345.
Nzira iyi inowanzoitwa mumashizha makuru sezvo ichichengetedza nguva kupfugama pasi kana kupfuura makumi mapfumbamwe kana kunyange mazana emiromo kana mapoka.
Zvisinei, sezvo pasina chaipo chinotsinhanisa keyboard kuti uise insertion point (iyo yakanamatira kubwinya line) mukati meZita reBhokisi, nzira yakakurumidza, iyo inozadzisa mhinduro imwechete ndeyokudhinda:
F5 kana Ctrl + G pabhobhoyo kuti ubudise GoTo dialog box .
Kunyora kudhindwa kwechitsauko kana zita rinotsanangurwa mubhokisi rino uye kuvhara muIno yeKuisa pane keyboard kunokuendesa kunzvimbo yaunoda.