Nzira Yokubvisa Sei muGoogle Spreadsheets

Shandisa maGoogle Spreadsheet mafomu kuti ubvise nhamba mbiri kana kupfuura

01 ye 02

Kushandisa Fomu yekubvisa Nhamba muGoogle Spreadsheets

Kuti ubudise nhamba mbiri kana kupfuura muGoogle Spreadsheets, unoda kugadzira fomu .

Pfungwa dzinokosha dzekuyeuka pamusoro peGoogle Spreadsheet fomu:

• Mafomu muGoogle Spreadsheets anogara achitanga nechiratidzo chakaenzana ( = ).
• Chiratidzo chakafanana chinogara chichiiswa muchitokisi umo unoda kuti mhinduro ionekwe.
• Chiratidzo chokubvisa muGoogle Spreadsheets ndiro dash (-).
• Icho chimiro chinopedzerwa nekudhinda muIno yeKuisa pabhobhoyo kana nekufambisa kushevedza kwechisera kune imwe sero ine mouse kana mutsara museki pabhobho.

Kuona Mhinduro, Kwete Iforomu

Kana uchinge wapinda musero rekushanda, mhinduro kana mhinduro yefomu yacho inoratidzwa musero panzvimbo yeyo maitiro pachayo.

Kuona Mutemo, Kwete Mhinduro

Pane nzira mbiri dzakaoma dzekutarisa fomu mushure mekunge dzapinda:

1. Dzokorora kamwe chete neine mouse pointer pane sero ine mhinduro - chirevo chinoratidzwa mubhairi yepamusoro pane pepa rekushanda.
2. Dzoka kaviri pane sero rine chirairo - izvi zvinogadzirisa purogiramu mu edit mode uye zvinokubvumira kuti uone uye uchinje fomu iri mumusero pachayo.

02 of 02

Kuvandudza Nheyo Yokutanga

Kunyangwe zvazvo kupinda nhamba nenyota zvakananga mune imwe nzira, yakadai = 20 - 10 inoshanda, haisi iyo nzira yakanakisisa yokugadzira mafomu.

Nzira yakanakisisa ndeyokuti:

1. Pinda nhamba kuti ubudiswe mumasero epapaji akasiyana;
2. Pinda zvinyorwa zvemasero zvemasero aya ane deta mumusanganisi wokubvisa.

Achishandisa Cell References muFormulas

Google Spreadsheets ine zviuru zvemasero mune rimwe pepa pepaji . Kuchengetedza mazita avo ose ane rimwe kero kana rekushandisa iyo inoshandiswa kuzivisa nzvimbo yesero mune pepa rekushanda.

Izvi zvinyorwa zvesero ndezvekubatanidzwa kwetsamba yemutsetse yemutsara uye nhamba yakakoshesa yemutsara pamwe netsamba yemutsetse yakanyorwa kare-yakadai seA1, D65, kana Z987.

Izvi zvinyorwa zvemasero zvinogonawo kushandiswa kuzivisa nzvimbo ye data inoshandiswa mumutambo. Purogiramu inoverenga sero zvinyorwa uye inobva yavhara munharaunda iri mumasero panzvimbo yakakodzera mumutambo.

Mukuwedzera, kuvandudza data iri mune imwe sero inotsanangurwa mumutevedzeri unoguma mumhinduro yefomu zvinongorongedzwa zvakare.

Kutaura paData

Mukuwedzera pakuchengetedza, kushandisa nhomwe uye kuvhara (kudonha ne mouse mouse) pane masero ane data anogona kushandiswa kuisa sero rekushandisa rinoshandiswa mumashonga.

Point nekodha ine zvakakosha yekuderedza kukanganisa kunokonzerwa nekukanganisa mafungiro paunopinda maonesero ezvinyorwa.

Muenzaniso: Bvisa Nhamba mbiri Nhamba uchishandisa Fomu

Matanho ari pasi apa anogadzira nzira yekuumba shanduro yekudzinga iri muchitokisi C3 mumufananidzo uri pamusoro.

Kupinda Muforomo

Kuti abvise 10 kubva pa20 uye ivai nemhinduro inowanikwa muchitokisi C3:

1. Dzvanya pachitokisi C3 pamwe nehope pointer kuti iite iyo inoshandiswa seki ;
2. Tora chikamu chakaenzana ( = ) muchitokisi C3;
3. Dzvanya pachitokisi A3 ine mouse pointer kuti uwedzere kuti sero rinotarisa kumutsetse mushure mokunge chiratidzo chakaenzana;
4. Tora minus sign ( - ) inotevera sero reference A1;
5. Dzvanya pachitokisi B3 neine mouse pointer kuti uwedzere kuti sero rinotarisa kumushure mushure mekutsvaga chiratidzo;
6. Dhinda pikicha inopinda mubhokisi
7. Mhinduro 10 inofanira kuva iri muchitokisi C3
8. Kuti uone chimiro, chengetera pane cell C3 zvakare, chirevo chacho chinoratidzwa mubhairi yepamusoro pane pepa rekushanda

Kushandura Mutemo Wakawanikwa

1. Kuti uedze kukosha kwekushandisa masero ekufambisa mune chirevo, shandura nhamba muchitokisi B3 kubva pa10 kusvika ku 5 uye tapinza muIno yeKuisa pane keyboard.
2. Mhinduro yacho muchitokisi C3 inofanira kuongororwazve kusvika 15 kuratidzira kuchinja kwe data.

Kuwedzera Chirafu

Kuwedzera huwandu hunoita kuti uwedzere mamwe mabasa - akadai, kuwedzerwa, kuwedzera, kana kuparadzanisa zvakaratidzwa mumitsara mana neyishanu mumuenzaniso - kungoenderera mberi kuwedzera yakakodzera mashematical operator inoteverwa nesero rinenge rine data.

Google Spreadsheets Order of Operations

Usati wavhiringidza maitiro emasvomhu akasiyana, iva nechokwadi chokuti unonzwisisa maitiro ekushanda ayo Google Spreadsheets anotevera kana achiongorora fomu.