01 ya 06
Google Spreadsheet Yambani Pang'onopang'ono Phunziro Lopanga
Google Spreadsheet Makhalidwe Amula - Mwachidule
Phunziroli likuphatikizapo njira zopangira ndi kugwiritsa ntchito mafomu mu Google Docs Spreadsheet. Cholinga cha anthu omwe ali ndi zochepa kapena zosavuta kugwira ntchito ndi mapulogalamu a spreadsheet .
Fomu ya Google Docs Spreadsheet imakulolani kupanga mawerengedwe pa deta yomwe yatulutsidwa mu spreadsheet.
Mungagwiritse ntchito ndondomeko yowonongeka kwa nambala, monga kuwonjezera kapena kuchotsa, komanso kuwerengetsa kovuta kwambiri monga kuchotsera malipiro kapena kupereka zotsatira za mayesero a wophunzira.
Kuonjezerapo, ngati mutasintha deta , tsambalo lidzayambiranso yankho lanu popanda kubwezeretsanso.
Kutsatira ndondomeko ya magawo ndi magawo m'masamba otsatirawa akuphatikiza momwe mungapangire ndikugwiritsa ntchito njira yofunikira mu Google Doc Spreadsheet.
02 a 06
Maphunziro a Zowonjezera Google: Step 1 of 3
Maphunziro a Zowonjezera Google: Step 1 of 3
Chitsanzo chotsatira chimapanga chiyambi chofunikira. Njira zomwe zimagwiritsidwa ntchito popanga mfundo zoyambirirazi ndizofanana ndizo polemba zovuta zambiri. Njirayi iyamba kuwonjezera manambala 5 + 3 ndiyeno nkuchotsani 4. Njira yomaliza idzawoneka ngati iyi:
= A1 + A2 - A3
Khwerero 1: Kulowa deta
Zindikirani : Kuti chithandizo ndi phunziroli liwonetse chithunzi pamwambapa.
Lembani deta zotsatirazi mu selo yoyenera.
A1: 3
A2: 2
A3: 4
03 a 06
Maphunziro a Zowonjezera Google: Step 2 of 3
Maphunziro a Zowonjezera Google: Step 2 of 3
Pogwiritsa ntchito ndondomeko mu Google Spreadsheet, nthawi zonse mumayamba polemba chizindikiro chofanana. Mukuzijambula mu selo kumene mukufuna yankho liwonekere.
Zindikirani : Kuti muthandizidwe ndi chitsanzo ichi mutchule chithunzi pamwambapa.
- Dinani pa selo A4 (tawonetsedwa mu zakuda mu chithunzi) ndi chojambula chanu cha mouse.
- Sakani chizindikiro chofanana ( = ) mu selo A4.
04 ya 06
Maphunziro a Zopangira Mauthenga a Google: Gawo 3 la 3
Maphunziro a Zopangira Mauthenga a Google: Gawo 3 la 3
Potsatira chizindikiro chofanana, timayika mu mafotokozedwe a maselo a maselo omwe ali ndi deta yathu.
Pogwiritsira ntchito mafotokozedwe a maselo a deta yathuyi, mayendedwewo adzasintha yankho lake ngati deta m'maselo A1, A2, kapena A3 akusintha.
Njira yabwino yowonjezeramo ma selo ndi kugwiritsa ntchito mbali ya Google Spreadsheets yotchedwa kukopa .
Kulongosola kumakulolani kuti muchoke ndi ndondomeko yanu mu selo yomwe ili ndi deta yanu kuti muwonjezere selo yake yowonjezeredwa ndi ndondomekoyi.
Pambuyo pa chizindikiro chofanana chiwonjezeredwa mu sitepe yachiwiri
- Dinani pa selo A1 ndi ndondomeko ya mbewa kuti mulowetsere selolo mu njirayi.
- Lembani chizindikiro chowonjezera ( + ).
- Dinani pa selo A2 ndi ndondomeko ya mbewa kuti mulowetse selolo mu njirayi.
- Lembani chizindikiro chochepera ( - ).
- Dinani pa selo A3 ndi ndondomeko ya mbewa kuti mulowetsere selolo mu njirayi.
- Onetsetsani ENTER yowonjezera pa kambokosi.
- Yankho 1 liyenera kuoneka mu selo A4.
- Dinani pa selo A4. Mndandanda wathunthu = A1 + A2 - A3 amasonyezedwa mu barolo lazenera pamwamba pa tsamba .
05 ya 06
Masamu Ogwira Ntchito mu Google Spreadsheet Mpangidwe
Mathematical Operators Amagwiritsidwa Ntchito Mu Fomu
Monga tawonera kumayendedwe apitayi, kulemba ndondomeko mu Google Spreadsheet sivuta. Ingosinthanitsani mafotokozedwe a maselo a deta yanu ndi olemba masamu oyenera.
Olemba masamu omwe amagwiritsidwa ntchito mu Excel mawonekedwe ali ofanana ndi omwe amagwiritsidwa ntchito pa masamu.
- Kuchotsa - kusayina chizindikiro ( - )
- Kuwonjezera - kuphatikiza chizindikiro ( + )
- Gawani - kutsogolo kutsogolo ( / )
- Kuwonjezeka - asteriski ( * )
- Kutsatsa - chisamaliro ( ^ )
06 ya 06
Google Spreadsheet Order of Operations
Google Spreadsheet Order of Operations
Ngati oposa angapo akugwiritsidwa ntchito muzondomeko , pali dongosolo lomwe Google Spreadsheet idzatsatila kuti achite masamu macchito.
Kukonzekera uku kwa ntchito kungasinthidwe mwa kuwonjezera makina ku equation. Njira yosavuta kukumbukira dongosolo la ntchito ndikugwiritsa ntchito mawu ofotokozera:
BEDMAS
Order of Operation ndi:
- B rackets
E xponents
D ivision
M kuwonjezera
Chidziwitso
S kubweza
Momwe Ntchito Yogwirira Ntchito imagwirira ntchito
Ma opaleshoni aliwonse omwe ali nawo mabakita adzakonzedwa koyambirira kutsatiridwa ndi zovumbulutsidwa zilizonse.
Pambuyo pake, Google Spreadsheet imaganiza ntchito zogawanika kapena kuchulukitsa kuti zikhale zofanana, ndipo zimayendetsa ntchito izi kuti zikhalepo kumanzere.
Zomwezo zimapita ku ntchito ziwiri zotsatira - Kuwonjezera ndi kuchotsa. Amaonedwa kuti ndi ofanana mu dongosolo la ntchito. Chomwe chimakhala choyamba choyamba mu mgwirizano, kaya kuwonjezera kapena kuchotsa, ndiye ntchito yoyamba.