Momwe mungatulutsire mu Google Spreadsheets

Gwiritsani ntchito ma fomu a Google Spreadsheet kuti muchotse nambala ziwiri kapena zingapo

01 a 02

Kugwiritsira ntchito Fomu Kuchotsa Numeri mu Google Magulu

Kuti muchotse ziwerengero ziwiri kapena zingapo mu Google Spreadsheets, mukufunika kupanga mayendedwe .

Mfundo zofunikira kukumbukira za ma fomu a Google Spreadsheet:

• Mafomu a Google Spreadsheets nthawi zonse amayamba ndi chizindikiro chofanana ( = ).
• Chizindikiro chofanana chimaikidwa nthawi zonse mu selo kumene mukufuna yankho liwonekere.
• Chizindikiro chochotseramo mu Google Spreadsheets ndi dash (-).
• Fomuyi imatsirizidwa mwa kukanikiza fungulo lolowamo ku kibokosilo kapena kusuntha khungu la selo ku selo lina ndi makina kapena mitsuko yaviki pa keyboard.

Kuwona Yankho, Osati Mpangidwe

Mukadalowa mu selo lamasewero, yankho kapena zotsatira za fomuzi zikuwonetsedwa mu selo osati mndandanda womwewo.

Kuwona Mndandanda, Osati Yankho

Pali njira ziwiri zosavuta kuti muwone njirayi mutatha kulowa:

1. Dinani kamodzi ndi ndondomeko yamagulu pa selo yomwe ili ndi yankho - fomuyi imasonyezedwa mu barolo lazenera pamwamba pa tsamba.
2. Dinani kawiri pa selo yomwe ili ndi ndondomekoyi - izi zimapanga pulogalamu mu kusintha mode ndikukuthandizani kuti muwone ndikusintha ndondomekoyo mu selo lokha.

02 a 02

Kupititsa patsogolo Makhalidwe Oyambirira

Ngakhale kuti akulowa manambala mwachindunji, monga = 20 - 10 ntchito, si njira yabwino yopanga mafomu.

Njira yabwino ndi:

1. Lowetsani manambala kuti achotsedwe m'maselo ogawisi apadera;
2. Lowetsani mafotokozedwe a maselo kwa maselo omwe ali ndi deta mu ndondomeko yochotsa.

Kugwiritsira ntchito zizindikiro za magulu mu mafomu

Google Spreadsheets ili ndi maselo zikwi mu tsamba limodzi. Kuti muzindikire zonsezi zili ndi adiresi kapena zolembera zomwe zimagwiritsidwa ntchito kuti mudziwe malo a selo mu pepala la zolemba.

Mndandanda wa maselowa ndi ophatikizana ndi kalata yowongoka ndi mzere wowerengeka wa mzere ndi kalata yachonde yomwe inalembedwa yoyamba - monga A1, D65, kapena Z987.

Mafotokozedwe a maselowa angagwiritsidwenso ntchito kuti adziwe malo a deta yomwe ikugwiritsidwa ntchito mu njira. Pulogalamuyi imayang'ana mafotokozedwe a selo ndikuwongolera deta mu maselowo m'malo oyenera mu njirayi.

Kuonjezerapo, kusinthira deta mu selo lofotokozedwa mu chidule kumabweretsa yankho lachindunji kumangosinthidwa komanso.

Kuwonetsera pa Deta

Kuphatikiza pa kujambula, kugwiritsa ntchito mfundo ndi kudula (kudumpha ndi ndondomeko ya mouse) pa maselo okhala ndi deta angagwiritsidwe ntchito kulowa ma selo omwe akugwiritsidwa ntchito m'mafomu.

Lembani ndi kudinkhani kuli ndi phindu lochepetsera zolakwa zomwe zimapangidwa ndi zolakwika zojambula mukalowetsa ma selo.

Chitsanzo: Chotsani Manambala Awiri Pogwiritsa Ntchito Fomu

Masitepe omwe ali m'munsiwa akuthandizira momwe angapangire ndondomeko yobweretsera yomwe ili mu selo C3 mu chithunzi pamwambapa.

Kulowa Mndandanda

Kuchotsa 10 kuchokera pa 20 ndikupeza yankho likuwoneka mu selo C3:

1. Dinani pa selo C3 ndi pointer ya mouse kuti mupange selo yogwira ntchito ;
2. Lembani chizindikiro chofanana ( = ) mu selo C3;
3. Dinani pa selo A3 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chofanana;
4. Lembani chizindikiro chochepa ( - ) chotsatira selo la A1;
5. Dinani pa selo B3 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chochepa;
6. Dinani ku key lolowamo pa khibhodi
7. Yankho 10 liyenera kupezeka mu selo C3
8. Kuti muwone njirayi, dinani pa selo C3 kachiwiri, ndondomekoyi ikuwonetsedwa muzenera yapamwamba pamwamba pa tsamba

Kusintha Makhalidwe Zotsatira

1. Poyesa ubwino wogwiritsira ntchito ma selo pamasamu, sintha chiwerengero mu selo B3 kuyambira 10 mpaka 5 ndikusindikizira Enter key pa makiyi.
2. Mayankho mu selo C3 ayenera kusinthidwa mpaka 15 kuti asonyeze kusintha kwa deta.

Kukulitsa Makhalidwe

Kuwonjezera njirayi kuphatikizapo ntchito zina monga kuwonjezera, kuchulukitsa, kapena kugawa kwakukulu komwe kumawonetsedwa mizere inayi ndi zisanu mu chitsanzo - pitirizani kuwonjezera olemba masamu omwe akutsatira ndondomekoyi.

Madipatimenti a Google Spreadsheets Order of Operations

Musanayambe kugwira ntchito zosiyanasiyana za masamu, onetsetsani kuti mukumvetsa momwe ntchito ikugwiritsira ntchito Google Spreadsheets poyesa fomu.