Tsanangudzo yeshoko rekare uye kushandisa mu Excel neGoogle Sheetsiti
Sero rinoreva mapurogiramu eparamheetti seExcel neGoogle Sheets dzinoratidza nzvimbo yekamuri mune pepa rekushanda .
Sero imwe yebhokisi-sezvivako zvinozadza pepa rekuita uye sero imwe neimwe inogona kuwanikwa kuburikidza nezvikamu zvayo zvemasero - zvakadai seA1, F26 kana W345 - iri nemutsetse wemutsara nemutsara wepamutsara unopindira pane sero. Paunenge uchitarisa sero reference, tsamba yekhoma inogara ichinyorwa
Maferensi emunzvimbo anoshandiswa mumashonga , mabasa, marati , nemamwe mirairo ye Excel.
Updating Formulas and Charts
Chimwe chekushandisa kushandiswa kwemasero mune pesperesheet maforamu ndeyokuti, kazhinji, kana data iri mumasero akataridzirwa achichinja, chimiro kana chati chinongororwa zvinyorwa kuratidza kuchinja.
Kana bhuku rebasa rakagadzirirwa kuti rirege kuongororwa zvichishandurwa kana kuchinja kunogadzirirwa pane pepa rekushandura, rondedzero yezvinyorwa inogona kuitwa nekusimudzira kiyi F9 pane keyboard.
Kusiyana kwemashizha emabasa uye mabhuku eBasa
Shanduro dzinoshandiswa pamagetsi hazvirevi kudivi rimwe chete remashoko apo data iripo. Mitsara inogona kutsanangurwa kubva pamashizha akasiyana.
Kana izvi zvikaitika, zita rebasa racho rinowanikwa sezvinoratidzwa mumutsetse uri mumutsara wechitatu mumufananidzo uri pamusoro apa unosanganisira kutaridzirwa kusero reA2 pane Sheet 2 yemabhuku mamwechete.
Saizvozvowo, kana dhiyabhorosi iri mune rimwe bhuku rebhuku rinotsanangurwa, zita rebhuku rebhuku uye pepa rekushandura rinowanikwa mumutsara pamwe chete nesero nzvimbo. Nzira iri mumutsara wechitatu mumufananidzo inosanganisira kutaridzirwa kune cell A1 iri pa peji 1 yeBhuku2 - zita rebhuku rechipiri.
Range reCells A2: A4
Kunyange zvazvo zvinyorwa zvinowanzoreva masero ega - zvakadai seA1, zvinogonawo kureva boka kana mararamiro emasero.
Mapanga anozivikanwa nesero zvinyorwa zvemasero ari kumusoro nechekumucheto uye kumakona ekurudyi kumakona.
Izvo zvikamu zviviri zvemasero zvinoshandiswa pakureba zvakaparadzaniswa nekoloni (:) inotaurira Excel kana Google Spreadsheets kuti iise yese masero pakati pekutanga uye ekupedzisira.
Muenzaniso wemhando dzakasiyana dzemasero inoratidzwa mumutsara wechitatu wechifananidzo pamusoro apa apo basa reSUM rinoshandiswa kukwana nhamba dziri mumakero A2: A4.
Relative, Absolute, uye Mixed Cell References
Kune marudzi matatu ezvinyorwa zvinogona kushandiswa muExcel neGoogle Sheets uye zvinowanikwa nyore nyore nekuvapo kana kusavapo kwema dollar zviratidzo ($) mukati memutsara rinoshandiswa:
- relative cell cell references haina zviratidzo zvemadhora - sezvinoratidzwa mumutsetse uri mumutsara 2: = A2 + A4;
- Mhedziso yakakwana inofanirwa neodhora zviratidzo zvakabatanidzwa netsamba imwe neimwe kana nhamba inotaridzirwa - sezvinoratidzwa mumutsetse uri mumutsara 4: = $ A $ 2 + $ A $ 4;
- kusanganiswa kwesero rinodhindwa rine dhora zviratidzo zvakabatanidzwa kune tsamba kana kuti nhamba iri kutaurwa asi kwete zviviri - sezvinoratidzwa mumutsetse mumutsara 5: = $ A2 + A $ 4.
Kunyora Mafomu uye Mamwe Masero References
Chinhu chechipiri chekushandisa sero rinorondedzerwa mune zvinyorwa ndechokuti vanoita kuti zvive nyore kukopa mazano kubva kune imwe nzvimbo kuenda kune imwe mune pepa rekushanda kana mubhuku rebhuku .
Relative cell references inoshandura apo yakakonzerwa kuratidza nzvimbo itsva yefomu. Somuenzaniso, kana chirevo chacho
= A2 + A4
yakakumbwa kubva muchitokisi B2 kusvika kuB3, zvinyorwa zvichange zvichishandurwa kuitira kuti chirevo chacho chive che:
= A3 + A5
Zita rokuti hama rinobva kunekuti inoshandura maererano nenzvimbo yayo kana ikakopizwa. Izvi kazhinji chinhu chakanaka uye ndechikonzero nei hama dzemuferensi zvinyorwa ndezverudzi rwekutsvaga runoshandiswa mumashonga.
Dzimwe nguva, kunyange zvinyorwa zvese zvichitarisirwa kugara zvakasimba apo mazano akatevedzwa. Kuti uite izvi, mhedziso yakakwana (= $ A $ 2 + $ A $ 4) inoshandiswa iyo isingashanduki kana ikakopizwa.
Kunyange zvakadaro, pane dzimwe nguva, iwe ungada chikamu cheseferensi yekushandura-yakadai seyemutsamba yemakorinhe - apo ine mutsara wenhamba ugare uripo - kana kuti kana zvinyorwa apo fomu yakakopihwa.
Iyi ndiyo apo kusanganiswa kwemazana kushandiswa kunoshandiswa (= $ A2 + A $ 4). Chero chikamu chetsanangudzo ine chiratidzo chechirairi chakaiswa pairi chinogara chakasimba, asi imwe chikamu chinoshandiswa apo chakakumbwa.
Nokuda kwe $ A2, kana yakakopihwa, tsamba yekhomoni ichagara iri A, asi nhamba dzemutsara dzichashandurwa kusvika $ A3, $ A4, $ A5, nezvimwewo.
Chisarudzo chekushandisa sendima dzakasiyana-siyana zvinorondedzerwa paunenge uchigadzira rondedzero yakabva pane nzvimbo yedata ichashandiswa nemakopi aya.
Shandisa F4 kuwedzera Dhilar Signs
Nzira yakareruka yekushandura zviyero zvemasero kubva kune zvakakwana kana zvakavhenganiswa ndeyekufambisa F4 key pane keyboard:
Kuti uchinje pane zviripo zvekare zvinyorwa, Excel inofanira kunge iri kuchinja mode, iyo inogona kuitwa nekukanda-kaviri pane imwe sero ine mouse pointer kana nekudhinda F2 key pa keyboard.
Kuti uchinje nhengo dzemaoko zvinyorwa kune zvakakwana kana zvakakanganiswa zvinyorwa zvemashoko:
- Dhinda F4 kamwe chete kuti uite sero rinonyatsokwana zvakakwana se $ A $ 6
- Dhinda F4 kechipiri kuti uite ruzivo rwakavhenganiswa apo rutsara ruregerero rwakakwana seA $ 6
- Dhinda F4 kechipiri kuti uite ruzivo rwakavhenganiswa apo tsamba yemutsara yakakwana se $ A6
- Dhinda F4 yechina kuti uite sero rinotaura zvakare zvakare seA6.