Nzira yekuvandudza kusarudzwa kweboka kana bhokisi remasero
Mhando yeboka kana bhokisi remasero mune pepa rekushandira rakasarudzwa kana rakasimbiswa. Apo masero akasarudzwa iwo akakomberedzwa nehurukuro kana muganhu sezvinoratidzwa mumufananidzo kuruboshwe.
Mhando inogonawo kuva boka kana kubvisa kwemaferensi esero anogona kuva, somuenzaniso:
- akapinda senharo yebasa.
- akashandisa kugadzira girafu.
- yakashandiswa kugadzira mabhukukiti kune mamwe mashoko mubhuku rebhuku .
Nokusingaperi, iri rondedzero kana muganhu unopoteredza sero imwechete chete mumushandi webasa pane imwe nguva, iyo inozivikanwa senhengo inoshandiswa . Kuchinja pane pepa rekushandura, zvakadai sekugadzirisa deta kana kufungidzirwa, nekutadza, kuchinja sangano rinoshanda.
Kana boka reasero rimwe rakasarudzwa, rinoshandiswa kuhwhepa rekushanda - nezvimwe zvisiri izvo zvakadai sokupinda kwepasita nekugadzirisa - zvinoshandura masero ose muhutano hwakasarudzwa.
Zvinogutsa uye Zvisingabatsiri Ranges
Ruzhinji rwemasero ndiro boka remasero akasimbiswa ari pedo kune mumwe nemumwe, zvakadai seyeri C1 kusvika C5 inoratidzwa mumufananidzo pamusoro apa.
Rutivi rwusingaregi runosanganisira mabhii maviri kana kupfuura akazvimirira masero. Izvi zvinogona kuparadzaniswa nemitsara kana mapuranga sezvinoratidzwa nemitambo A1 kusvika A5 uye C1 kusvika C5.
Zvose zviri zviviri zvinokonzera uye zvisingaenzaniswi zvinogona kusanganisira mazana emakore kana kunyange zviuru zvemasero uye mapepa emafashoni emabhuku uye mabhuku ebasa.
Kutumidza zita Range
Mapangiro anokosha zvikuru muExcel neGoogle Spreadsheets ayo mazita anogona kupiwa kumativi akasiyana kuti aite kuti zvive nyore kushanda pamwe nekushandisa zvakare pazvinenge zvichitsanangurwa mune zvimwe zvinhu zvakadai sematare nemafomu.
Kusarudza Range mune Pepa Rokushanda
Ikoko nzira dzakasiyana-siyana dzokusarudza bhanhire mune pepa rekushanda. Izvi zvinosanganisira kushandisa:
- the mouse.
- the keyboard.
- Bhokisi Razita muExcel.
- Kubatanidzwa kwevatatu.
Rimwe rutivi rwuri pedyo nemasero anogona kuumbwa nekukwevera nemushonga kana kushandisa kusanganiswa kweShift uye maneki dzeArrow pane keyboard.
Mapangiro anowanikwa asiri ari pedyo masero anogona kugadzirwa kuburikidza achishandisa mouse uye keyboard kana keyboard.
Kusarudza Range Kuti Ushandise muRomu kana Chati
Paunopinda mazamu ezvinyorwa zvinoshandiswa segakava rebasa kana pakagadzira chati, kuwedzera pakuchengeta mumakero nemaoko, urongwa hunogonawo kusarudzwa uchitsanangura.
Mapanga anozivikanwa nesero zvinyorwa kana mazita emasero ari kumusoro kwekumucheto uye kumucheto kumakona ekurudyi emurwi. Aya mabhuku maviri akaparadzaniswa nekoloni (:) iyo inotaurira Excel kuti iise masero ose pakati pekutanga uye ekupedzisira.
Range vs. Array
Pane dzimwe nguva mitemo yakareba uye yakaita seyo inoshandiswa kushandiswa zvakasiyana-siyana kuExcel neGoogle Spreadsheets, sezvo mazwi maviri ari akaenzana nekushandiswa kwemasero akawanda mubhuku rebhuku kana faira.
Kuti zvive zvakananga, mutsauko uripo pakuti chokwadi chinoreva kusarudzwa kana kuzivikanwa kwemasero akawanda akadai seA1: A5, asi mhando inogona kureva maitiro ari mumasero akadai se {1; 2; 5; 4; ; 3}.
Mamwe mabasa - akadai seSUMPRODUCT uye INDEX anotora mapepa semafungiro, asi vamwe - saSUMIF uye COUNTIF vanobvuma zvikamu zvemashoko.
Izvozvo hazvirevi kuti rutivi rwemaferensi ezvitokoni harungapindi semazano eSUMPRODUCT uye INDEX sezvo basa iri rinogona kubvisa mazano kubva pamararamiro uye kuvashandura mumhando.
Somuenzaniso, maitiro
= SUMPRODUCT (A1: A5, C1: C5)
= SUMPRODUCT ({1; 2; 5; 4; 3}, {1; 4; 8; 2; 4})
zvose zvinodzoka mugumisiro we 69 sezvinoratidzwa mumasero E1 neE2 mumufananidzo.
Kune rumwe rutivi, SUMIF uye COUNTIF haagamuchiri magwaro semashoko. Saka, apo chirevo chacho
= COUNTIF (A1: A5, "<4") inodzorera mhinduro ye3 (cell E3 mumufananidzo);
the formula
= COUNTIF ({1; 2; 5; 4; 3}, "<4")
hazvigamuchirwi neExcel nokuti inoshandisa nzira yekukakavadzana. Somugumisiro, purogiramu inoratidza bhokisi remashoko rinogona kutadza matambudziko uye kugadziriswa.