Kune nzira dzakawanda dzekuyera kuvepo kwetsika kana, sezvinowanzonzi kazhinji, mavhareji, kwehutano hwehutsika.
Chiyero chinonyanya kuverengwa chechimiro chetsika ndechokuti aritemi inoreva - kana iri nyore-uye inoratidzirwa nekuwedzera boka re nhamba pamwe chete uye kugoverwa nhamba yezviyero izvozvo. Somuenzaniso, muvhareji we4, 20, uye 6 akawedzerwa pamwe ndeye 10 sezvazvinoratidzwa mumutsara 4.
Google Spreadsheets ine mabasa akawanda anoita kuti zvive nyore kuwana zvimwe zvezvinowanzoshandiswa zviyero zvepakati. Izvi zvinosanganisira:
- IAVERAGE basa - inowana arithmetic inoreva kureva mazita ehuwandu.
- Basa reMEDIAN - rinoona kukosha kwepakati pane runyorwa rwemashamba.
- Iyo MODE inoshanda - inowana kukosha kunowanzoitika kune yakanyorwa nhamba.
Iko Syntax Kushanda neMagariro
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara weAVERAGE basa ndewokuti:
= AVERAGE (number_1, number_2, ... number_30)
- nhamba_1 - (inofanirwa) data kuti ienzaniswe nebasa racho
- nhamba_2 kuverenga_30 - (kusarudza) mamwe mazano emitemo kuti aiswe mukati. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndeye 30
Nhamba dzemibvunzo dzinogona kuva:
- Runyora rwemajeri runotarwa;
- Sero rinotaura nezvekunzvimbo kwedata iri mubasa rekushanda;
- Mhando yezvikamu zvinyorwa;
- A zita rakarongwa.
Cherechedza: Zvinyorwa zvinyorwa uye masero ane maBoolean maonero (TRUE kana FALSE) haana hanya nebasa sezvaratidzwa mumiganhu 8 ne9 mumufananidzo uri pamusoro.
Kana masero ayo asina ruvara kana ane mavara kana maBoolean maitiro akazochinjwa kuti aite nhamba, musereji achadzokorora zvakare kuti agone kuchinja.
Masero asina kuchena vs. Zero
Kana zvasvika pakutsvaga muhomwe mazano muGoogle Spreadsheets, kune musiyano pakati pekusavhara kana masero asina chinhu neavo ane zero kukosha.
Masero asina kujeka haatauri neAVERAGE basa, iyo inogona kuva yakasimba sezvo ichiita kuti pave nekuenzanisa kwemasero asina kubatana e data zvakanyanya nyore sezvinoratidzwa mumutsara 6 pamusoro.
Masero ane zero kukosha, zvisinei, akabatanidzwa mumwero wakatarwa sezvinoratidzwa mumutsara 7.
Kutsvaga KUTAURWA Kushanda
Kufanana nemamwe ose akavakwa mumabasa muGoogle Spreadsheets, basa reAVERAGE rinogona kuwanikwa kuburikidza kuisa Ita > Basa mumamenu kuti uzarure rondedzero yezvinyorwa zvinowanzoshandiswa zvinosanganisira AVERAGE basa.
Zvimwewo, nokuti iyo inowanzoshandiswa, nzira shoma kune basa yakange yawedzerwa pakuronga chepurogiramu, kuitira kuti zvive nyore nyore kuwana nekushandisa.
Chiratidzo pane toolbar yeizvi uye mamwe mabasa akawanda anozivikanwa ndeyechiGiriki tsamba Sigma ( Σ ).
Google Spreadsheets MASHOKO EBASA MUMWE Muenzaniso
Matanho ari pasi apa anokwanisa kupinda muAVERAGE basa rinoratidzwa mumutsara wechina mumuenzaniso uri mumufananidzo pamusoro apa uchishandisa nzira yekutsvaga kuAVERAGE basa inotaurwa pamusoro apa.
Kupinda muAVERAGE Function
- Dzvanya pane sero D4 - nzvimbo iyo migumisiro yefomu icharatidzwa.
- Dzvanya Pikicha yeMabasa pane bharakiti chepamusoro pane pepa rekushanda kuti uzarure rondedzero yezvinyorwa zvemabasa.
- Sarudza Avhareji kubva pakurongwa kuisa kopi isina chinhu yebasa iri muchitokisi D4.
- Simbisai ma- cell A4 kusvika kuC4 kuti uise zvinyorwa izvi sezvikonzero zvebasa racho uye divhai muIno yeKuisa pane keyboard.
- Nhamba yegumi inofanira kuonekwa muchikamu cheD4. Iyi ivhareji yenhamba nhatu - 4, 20, uye 6.
- Paunenge uchitarisa pane cell A8 basa rakakwana = AVERAGE (A4: C4) inowanikwa mubhairi yepamusoro pane pepa pepaji.
Notes:
- Masero ega ega, panzvimbo peurongwa hunoramba huripo hunogona kuwedzerwa semafungiro asi sero rega rega rinofanirwa kuparadzana nekma.
- Mushure mokupinda mubasa racho, kana kuchinja kunogadzirwa kune data mumasero akasarudzwa, basa racho, nekutadza, rinongoratidzira zvakare kuratidza kuchinja.