Nzira Yokuwedzera Nhamba muGoogle Spreadsheets

Nzira yakareruka yekuwanza nhamba mbiri muGoogle Spreadsheets ndeyekuumba fomu mumusero webasa.

Pfungwa dzinokosha dzekuyeuka pamusoro peGoogle Spreadsheet fomu:

• maitiro anogara achitanga nechiratidzo chakaenzana ( = );
• chiratidzo chinokwana nguva dzose chinopinda muchitokisi umo unoda kuti mhinduro iende;
• uyo anowedzera kuwedzera ndiyo asteriski ( * );
• Icho chinyorwa chinopedzerwa nekudhinda Enter key pane keyboard.

01 of 06

Achishandisa Cell References muFormulas

Kunyangwe nekupinda nhamba nenyota zvakananga mumushonga, zvakadai se:

= 20 * 10

mabasa - sezvinoratidzwa mumutsara wechipiri mumuenzaniso - haisi iyo nzira yakanakisisa yokugadzira mafomu.

Nzira yakanakisisa - sezvinoratidzwa mumitsara mitanhatu nematanhatu - ndeyokuti:

1. Pinda ma nhamba kuti awedzere mumasero epapaji akasiyana;
2. Pinda zvinyorwa zvemasero zvemasero aya ane data pane fomu yekuwedzera.

Maferensi efoni ari kusanganiswa kwetsamba yemutsetse yemutsara uye nhamba yakakoshesa yemutsara pamwe netsamba yemutsetse yakanyorwa kare-yakadai seA1, D65, kana Z987.

02 of 06

Cell Reference Reference Mazano

Nhamba dzemaferensi dzinoshandiswa kuzivisa nzvimbo ye data inoshandiswa mumutambo. Purogiramu inoverenga sero zvinyorwa uye inobva yavhara munharaunda iri mumasero panzvimbo yakakodzera mumutambo.

Nokushandisa sero zvinyorwa panzvimbo yezviripo data mumusarudzo - gare gare, kana zvichizodikanwa kuchinja data , iri nyaya yakanyanyisa yekutsvaga deta mumasero panzvimbo yekunyorazve chirevo.

Kazhinji, migumisiro yechipfuva ichadzoka pakarepo kana data ichichinja.

03 of 06

Kuwandisa Formula Example

Sezvinoratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unogadzira fomu muchitsetse C4 iyo inowedzera deta iri muchitokisi A4 nedheta iri muA5.

Iyo yakagadzirwa mazai muchitokisi C4 ichava:

= A4 * A5

04 of 06

Kupinda Muforomo

1. Dzvanya pachitokisi C4 kuti uite sero rinoshandiswa - izvi ndiko kuti migumisiro yechirongwa icharatidzwa;
2. Tora chikamu chakaenzana ( = ) mu cell C4;
3. Dzvanya pane sero A4 ine mouse pointer kuti uise iyo seferensi iri muyamu;
4. Tora imwe chimiro chekaristiki ( * ) mushure meA4;
5. Dzvanya pane sero A5 ine mouse pointer kuti uise iyo cell reference;
6. Dhinda pikicha inopinda mubhokisi kuti upedze fomu;
7. Mhinduro 200 inofanira kuva iri muchitokisi C4;
8. Kunyange zvazvo mhinduro yacho inoratidzwa muchitokisi C4, kuvhara pachitanda ichocho kucharatidza rondedzero chaiye = A4 * A5 mubhadharo yepamusoro pane pepa pepaji.

05 of 06

Kuchinja Data Formula

Kuti uedze kukosha kwekushandisa sero zvinyorwa mumutsara:

• Shandura t iyo nhamba muchitokisi A4 kubva pa20 t o 5 uye pinda muIndiniti paikhibhodi.

Mhinduro yacho muchitokisi C4 inofanira kuenderera mberi kusvika kune makumi mashanu kuti iratidze kuchinja kwe data muchitokisi A4.

06 of 06

Kuchinja Mutemo

Kana zvichizodiwa kugadzirisa kana kushandura chirevo, zviviri zvezvakanakisisa zvinosarudzwa ndezvi:

• Tora kaviri pane mazano mumashandiro ekuisa maGoogle Spreadsheets muHindu mode uye oita shanduko pamutemo - unoshanda zvakanakisisa kuchinja kuduku.
• Kamwe kamwe pane sero rine chinyorwa uye wonyora zvakare fomu yose - yakanakisisa nokuda kwekuchinja kukuru.