01 of 06
Google Spreadsheet Shandisa Nhanho yeTomiti YeTutori
Google Spreadsheet Murairo Wekudzidzisa - Overview
Iyi tutori inosanganisira matanho ekusika nekushandisa mazano muGoogle Docs Spreadsheet. Izvo zvakagadzirirwa kune avo vane zvishoma kana kuti vasina ruzivo mukushanda nemapurogiramu epadheseti .
Tsanangudzo yeGoogle Docs Spreadsheet inokubvumira kuti uite maverengi pane data yakapinda muparapariti.
Iwe unogona kushandisa rondedzero yekunyora nhamba yakakosha, yakadai sekuwedzera kana kubvisa, pamwe chete nezvakaoma zvakawandisa zvakadai sekubhadharwa kwemabhadharo kana kujekesa mhinduro dzevadzidzi.
Mukuwedzera, kana ukashandura dhesi racho shanduro ichadzokororazve mhinduro yacho pasina iwe unofanirwa kupinda zvakare.
Kutevera nhanho nhanhatu mirayiridzo pamapeji anotevera anotaura nzira yekusika uye kushandisa shanduko yekutanga muGoogle Doc Spreadsheet.
02 of 06
Google Spreadsheet Timu yekudzidzisa: Step 1 ye3
Google Spreadsheet Timu yekudzidzisa: Step 1 ye3
Muenzaniso unotevera unoumba chimiro chekutanga. Nhanho dzinoshandiswa kugadzira ichi chimiro chekutanga ndeyezvinofanirwa kutevera paunonyora mazita akaoma kunzwisisa. Chirevo chekutanga chichawedzera ma nhamba 5 + 3 uye ozobvisa 4. Chimiro chekupedzisira chichaita seizvi:
= A1 + A2 - A3
Nhanho 1: Kuisa data
Cherechedza : Kuti rubatsiro nerudzidzisi urwu ruratidze mufananidzo uri pamusoro.
Tora iyo inotevera data pane yakakodzera sero .
A1: 3
A2: 2
A3: 4
03 of 06
Google Spreadsheet Murairo Wekudzidzisa: Step 2 wechitatu
Google Spreadsheet Murairo Wekudzidzisa: Step 2 wechitatu
Paunenge uumba mazano muGoogle Spreadsheet, iwe WOSE unotanga nokunyora chiratidzo chakaenzana. Iwe unoridza iyo muchitokisi apo iwe unoda kuti mhinduro ioneke.
Cherechedza : Kubatsirwa nemuenzaniso uyu kunoreva chifananidzo chiri pamusoro.
- Dzvanya pachitokisi A4 (yakarondedzerwa mumusi mufananidzo) pamwe nemushonga wako wepiguru.
- Tora chikamu chakaenzana ( = ) muchitokisi A4.
04 of 06
Google Spreadsheet Timu yekudzidzisa: Step 3 of 3
Google Spreadsheet Timu yekudzidzisa: Step 3 of 3
Titevera chiratidzo chakaenzana, tinowedzera mune zvinyorwa zvese zvemasero ane data yedu.
Nokushandisa sero zvinyorwa zve data yedu mumutsetse , fomu yacho ichadzosera mhinduro pakarepo kana data iri mumasero A1, A2, kana A3 ichichinja.
Nzira yakanakisisa yokuwedzera masero ndeyekushandisa shanduro yeGoogle Spreadsheets inonzi inotsanangura .
Kutaura kunokubvumira kuti ukwanise newaini yako pane sero ine deta yako kuti uwedzere sero rinotaridzirwa.
Mushure mokunge chiratidzo chakafanana chakawedzerwa muchitsauko 2
- Dzvanya pachitokisi A1 ine mouse pointer kuti uise seferensi yechipinda mumutsetse.
- Tora imwe ( + ) chiratidzo.
- Dzvanya pachitokisi A2 neine mouse pointer kuti uise seferensi yesero mufomu.
- Tora minus ( - ) chiratidzo.
- Dzvanya pane sero A3 ine mouse pointer kuti uise seferensi yechipinda mumutsetse.
- Dhinda iri ENTER kiyi pane keyboard.
- Mhinduro 1 inofanira kuonekwa muchitokisi A4.
- Dzvanya pane sero A4. Zvose zvakakwana = A1 + A2 - A3 inoratidzwa mubhadha yefomula pane pepa rekushanda .
05 of 06
Mathematical Operators muGoogle Spreadsheet Formula
Mathematical Operators Inoshandiswa muRomu
Sezvakaratidzwa mumatanho ekutanga, kunyora fomu muGoogle Spreadsheet haisi nyore. Ingosonganisa zvinyorwa zvemasero zve data yako neyakakodzera mashematical operator .
Mathematical operators anoshandiswa mu Excel mazwi akafanana neaya anoshandiswa mumatunhu ekirasi.
- Kubvisa - kudisa chiratidzo ( - )
- Kuwedzera - pamwe nechiratidzo ( + )
- Kurambidza - mberi slash ( / )
- Kuwedzera - asterisk ( * )
- Exponentiation - caret ( ^ )
06 of 06
IGoogle Spreadsheet Order of Operations
IGoogle Spreadsheet Order of Operations
Kana vakawanda kupfuura imwe yevashandi vari kushandiswa mumurairo, kune urongwa hunoenderana neGoogle Spreadsheet inotevera kutevera masvomhu ekushanda.
Iri urongwa hwekushanda rinogona kuchinjwa nekuwedzera mabhakiti kune equation. Nzira iri nyore yekuyeuka kurongeka kwekushanda ndekushandisa shanduro iyi:
BEDMAS
Mutemo wekushanda ndewe:
- B rackets
E xponents
D ivision
M kukurumidza
A ddition
S ubtraction
Kuti Mutemo weKushanda Unoshanda sei
Chero basa chero ripi zvaro riri mune mabheji richaitwa kutanga rinoteverwa nemamwe mavara.
Mushure mezvo, Google Spreadsheet inofunga mabasa ekuparadzanisa kana kupararira kuti ave akaenzana zvakakosha, uye inoita mabasa aya muchirongwa iyo inoitika kuruboshwe kurudyi mu equation.
Izvo zvinoenda kumabasa maviri anotevera - kuwedzera nekubvisa. Vanonzi vanoenzana muhutano hwekushanda. Iyo ipi zvayo inotanga kuonekwa pakutanga muy equation, kana kuwedzera kana kubvisa, ndiyo inoshanda yakatanga.