01 ea 06
Google Spreadsheet Mohato ka Mekhoa ea Thuto ea Mochini
Tataiso ea mekhoa ea Google Spreadsheet - Tlhaloso
Thupelo ena e akaretsa mehato ea ho theha le ho sebelisa mekhoa ho Google Docs Spreadsheet. E reretsoe ba nang le phihlelo e fokolang kapa e se nang thuso ho sebetsa le mananeo a spreadsheet .
Foromo ea Google Docs Spreadsheet eu lumella hore u etse lipalo ho data e kenngoeng spreadsheet.
U ka sebelisa foromo ea palo ea motheo ea palo, e kang ho phaella kapa ho tlosa, hammoho le lipalo tse rarahaneng tse kang ho nkuoa ha moputso kapa ho lekanya liphello tsa liteko tsa seithuti.
Ho phaella moo, haeba o fetola data , spreadsheet e tla khutlisetsa karabo ka potlako ntle le hore o kene hape.
Ho latela litaelo tsa mohato le mohato maqepheng a latelang ho akaretsa mokhoa oa ho bopa le ho sebelisa moralo oa motheo ho Google Doc Spreadsheet.
02 ea 06
Tataiso ea Mochini oa Google Spreadsheet: Mohato oa 1 oa 3
Tataiso ea Mochini oa Google Spreadsheet: Mohato oa 1 oa 3
Mohlala o latelang o etsa moralo oa motheo. Mehato e sebelisetsoang ho etsa mokhoa ona oa motheo ke eona e tšoanang le eo u lokelang ho e latela ha u ngola litlhaloso tse rarahaneng haholoanyane. Morero o tla qala ho eketsa linomoro 5 + 3 ebe o tlosa 4. Morero oa ho qetela o tla shebahala tjena:
= A1 + A2 - A3
Mohato oa 1: Ho kenya data
Tlhokomeliso : Bakeng sa thuso ka thupelo ena e bua ka setšoantšo se ka holimo.
Ngola data e latelang ka seleng e loketseng.
A1: 3
A2: 2
A3: 4
03 ea 06
Tataiso ea mekhoa ea Google Spreadsheet: Mohato oa 2 ho oa 3
Tataiso ea mekhoa ea Google Spreadsheet: Mohato oa 2 ho oa 3
Ha u theha foromo ka Google Spreadsheet, U TSOELA ka ho qapa letšoao le lekanang. Ua e taka ka seleng moo u batlang hore karabo e hlahe.
Tlhokomeliso : Bakeng sa thuso ka mohlala ona o bua ka setšoantšo se ka holimo.
- Tobetsa seleng ea A4 (e hlalositsoeng ka batsho setšoantšong) ka pointer ea mouse.
- Tšoaea letšoao le lekanang ( = ) ka seleng ea A4.
04 ea 06
Tataiso ea mekhoa ea Google Spreadsheet: Mohato oa 3 ho oa 3
Tataiso ea mekhoa ea Google Spreadsheet: Mohato oa 3 ho oa 3
Ho latela letšoao le lekanang, re kenya likarolo tsa lisele tsa lisele tse nang le data ea rona.
Ka ho sebelisa likarolo tsa lisele tsa data ea rona ka foromo , mochine ona o tla tsosolosa karabo habonolo haeba lintlha tsa lisele tsa A1, A2, kapa A3 li fetoha.
Tsela e molemo ka ho fetisisa ea ho eketsa litšupiso tsa sele ke ka ho sebelisa karolo ea Google Spreadsheets e bitsoang ho supa .
Ho supa ho u lumella hore u tobetse ka mouse ea hau ka seleng e nang le data ea hau bakeng sa ho eketsa seleng ea eona ea sebopeho.
Ka mor'a hore pontšo e lekanang e kenngoe mohato oa 2
- Tobetsa seleng ea A1 ka pointer ea mouse ho kenya moelelo oa sele ka mokhoa ona.
- Tšoaea letšoao le leng ( + ).
- Tobetsa seleng ea A2 le pointer ea mouse ho kenya mohala oa sele ka mokhoa ona.
- Tšoaea letšoao le letšo ( - ).
- Tobetsa seleng ea A3 e nang le pointer ea mouse hore u kene ka har'a sele ea selefouno.
- Tobetsa konter ENTER ho lebokose.
- Karabo ea 1 e lokela ho hlaha seleng ea A4.
- Tobetsa seleng ea A4. Tsela e feletseng = A1 + A2 - A3 e bontsitsoe kahare ea foromo ka holim'a leqephe la mosebetsi .
05 ea 06
Mathematical Operators ho Google Spreadsheet Formula
Basebetsi ba Mathematical ba Sebelisitsoe Molaong
Joalokaha ho bonngoe mehatong e fetileng, ho ngola foromo ka Google Spreadsheet ha ho thata. Tlanya feela litemana tsa lisele tsa data ea hau le setsebi se nepahetseng sa lipalo .
Litsebi tsa lipalo tse sebelisitsoeng ho Excel liforomo li tšoana le tse sebelisitsoeng sehlopheng sa lipalo.
- Ho tlosa - tlosa letšoao ( - )
- Ho phaella - ho feta pontšo ( + )
- Karohano - pele slash ( / )
- Ho pharalla - asterisk ( * )
- Exponentiation - caret ( ^ )
06 ea 06
Taelo ea Ts'ebetso ea Google Spreadsheet
Taelo ea Ts'ebetso ea Google Spreadsheet
Haeba ho feta lisebelisoa tse fetang tse le 'ngoe ho sebelisitsoe foromo , ho na le taelo e khethehileng eo Google Spreadsheet e tla e latela ho etsa lipalo tsena tsa lipalo.
Taelo ena ea ts'ebetso e ka fetoloa ka ho eketsa likoti ho equation. Tsela e bonolo ea ho hopola taelo ea ts'ebetso ke ho sebelisa mantsoe a hlalosang mantsoe:
BEDMAS
Molao oa Tshebetso ke:
- B rackets
E xponents
D ivision
M tlhaloso
Tlhaloso
S ubtraction
Mokhoa oa Ts'ebetso oa Mesebetsi
Ts'ebetso leha e le efe e nang le li-brackets e tla etsoa pele e lateloa ke li-exponents leha e le life.
Ka mor'a moo, Google Spreadsheet e nka mesebetsi ea likarohano kapa ea ho ikatisa e le ea bohlokoa ka ho lekanang, 'me e etsa mesebetsi ena ka tatellano eo e hlahang ka letsohong le letona ho ea ho lekana.
E tšoanang e ea bakeng sa liketso tse peli tse latelang - ho phaella le ho ntša. Li nkoa li lekana ka tatellano ea ts'ebetso. Eo e kileng ea hlaha pele ho equation, ebang ke ho phaella kapa ho ntša, mosebetsi o etsoa pele.