Mmene Mungachulukitsire Numeri mu Google Spreadsheets

Njira yosavuta yowonjezera manambala awiri mu Google Spreadsheets ndiyo kupanga chikhomo mu selo lamasewera.

Mfundo zofunikira kukumbukira za ma fomu a Google Spreadsheet:

• mayendedwe nthawi zonse amayamba ndi chizindikiro chofanana ( = );
• chizindikiro chofanana nthawi zonse chimapita mu selo komwe mukufuna yankho kuti mupite;
• wochulukitsa ndi asterisk ( * );
• Fomuyi imatsirizidwa mwa kukanikiza fungulo lolowamo pa makiyi.

01 ya 06

Kugwiritsira ntchito zizindikiro za magulu mu mafomu

Ngakhale akulowa manambala mwachindunji, monga:

= 20 * 10

amagwira ntchito - monga momwe tawonetsera mzere wachiwiri mu chitsanzo - si njira yabwino yopanga mafomu.

Njira yabwino - monga momwe ikusonyezedwera m'mizere isanu ndi sikisi - ndi:

1. Lowani manambala kuti awonjezeke kukhala maselo ofiira apadera;
2. Lowetsani mafotokozedwe a maselo kwa maselo omwe ali ndi deta mu njira yowonjezera.

Maumboni a magulu ali ophatikiza ndi kalata yowongoka ndi mzere wotsatira wa mzere ndi kalata yachonde yomwe inalembedwa yoyamba - monga A1, D65, kapena Z987.

02 a 06

Zowonjezeredwa za Cell Cell

Zizindikiro za magulu zimagwiritsidwa ntchito pozindikira malo omwe deta imagwiritsidwa ntchito mu njira. Pulogalamuyi imayang'ana mafotokozedwe a selo ndikuwongolera deta mu maselowo m'malo oyenera mu njirayi.

Pogwiritsira ntchito ma selo m'malo mndondomeko yeniyeni - kenako, ngati pakufunika kusintha deta , ndi chinthu chophweka chotsatira deta m'maselo mmalo molembanso machitidwewo.

Kawirikawiri, zotsatira za fomuyi zidzasinthidwa pokhapokha ngati deta isintha.

03 a 06

Kuchulukitsa Chitsanzo Chitsanzo

Monga momwe tawonetsera pa chithunzi pamwambapa, chitsanzo ichi chimapanga ndondomeko mu selo C4 yomwe idzachulukitsa deta mu selo A4 ndi data mu A5.

Fomu yomalizidwa mu selo C4 idzakhala:

= A4 * A5

04 ya 06

Kulowa Mndandanda

1. Dinani pa selo C4 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za fomuyi zidzawonetsedwa;
2. Lembani chizindikiro chofanana ( = ) mu selo C4;
3. Dinani pa selo A4 ndi ndondomeko ya mbewa kuti mulowetse selolo mu chikhomo;
4. Lembani chizindikiro cha asterisk ( * ) pambuyo pa A4;
5. Dinani pa selo A5 ndi ndondomeko yamagulu kuti mulowetse selolo;
6. Lembani fungulo lolowamo lolowamo mubokosilo kuti mukwaniritse fomulo;
7. Yankho la 200 liyenera kupezeka mu selo C4;
8. Ngakhale yankho likuwonetsedwa mu selo C4, kudumphira pa seloyo kudzawonetsa malemba enieni = A4 * A5 mu barra yodutsa pamwamba pa tsamba.

05 ya 06

Kusintha Dongosolo la Fomu

Kuyezetsa ubwino wogwiritsa ntchito zigawo zapangidwe mu fomu:

• Sinthani chiwerengero chake mu selo A4 kuchokera 20 t o 5 ndikusindikizira Enter key pa makiyi.

Yankho lake mu selo C4 liyenera kusintha mpaka 50 kuti liwonetse kusintha kwa deta mu selo A4.

06 ya 06

Kusintha Fomu

Ngati pakufunika kukonza kapena kusintha fomu, njira ziwiri zabwino kwambiri ndizo:

• Dinani kawiri pa ndondomekoyi pa tsamba lanu kuti muike Google Spreadsheets mu Edit mode ndikupanga kusintha kwa njira - zimakhala zabwino pa kusintha pang'ono.
• Dinani kamodzi pa selo yomwe ili ndi ndondomekoyi ndi kulembetsanso mndandanda wonse - zabwino koposa kusintha kwakukulu.