I-Google Spreadsheet yeTomorial Tutorial

01 ngo-06

I-Google Spreadsheet Isinyathelo ngeSigaba soThutho loThutho

I-Google Spreadsheet yeTomorial Tutorial - Siboniso

Le tutorial ihlanganisa amanyathelo okudala nokusebenzisa iifomula kwiSpredishithi se-Google Docs. Kujoliswe kulabo abanamava amancinci okanye abangenalutho ekusebenzeni ngeeprogram ze- spreadsheet .

Ifom ye-Google Docs Spreadsheet ikuvumela ukuba wenze izibalo kwidatha efakwe kwispredishithi.

Ungasebenzisa ifom ye-crunching yenombolo eyisiseko, njengokungeza okanye ukukhupha, kunye nokubala okunzima kunjengeentlawulo zokuhlawula umvuzo okanye ukulinganisela iziphumo zokuvavanya umfundi.

Ukongeza, ukuba utshintshe idatha i-spreadsheet iya kuhlaziya ngokuzenzekelayo impendulo ngaphandle kokuba uphinde ufake ifom.

Ukulandela imiyalelo yesinyathelo ngesinyathelo kumaphepha alandelayo kubandakanya indlela yokwakha nokusebenzisa ifomu esisiseko kwi-Google Doc Spreadsheet.

02 we-06

I-Google Spreadsheet I-Formula Tutorial: Isinyathelo 1 se-3

I-Google Spreadsheet I-Formula Tutorial: Isinyathelo 1 se-3

Umzekelo olandelayo udala ifom ye siseko. Amanyathelo asetshenziselwa ukudala le fomyula eyisiseko ayafana nokulandela xa ebhala iifomula eziyinkimbinkimbi. I-formula iya kuqala idibanise iinombolo 5 + 3 ize ikhuphe 4. Ifom yokugqibela iya kubonakala ngathi:

= A1 + A2 - A3

Inyathelo 1: Ukufaka idatha

Qaphela : Ukuba uncedo ngale khokelo ubhekisela kumfanekiso ongentla.

Thayipha idatha elandelayo kwiseli efanelekileyo.

A1: 3
A2: 2
A3: 4

03 we-06

I-Google Spreadsheet I-Tutorial yeFomula: Isinyathelo 2 se-3

I-Google Spreadsheet I-Tutorial yeFomula: Isinyathelo 2 se-3

Xa udala ifomu kwiGoogle Spreadsheet, UYAQALA ngokuqala ukuthayipha uphawu olulinganayo. Ulufake kwisisele apho ufuna impendulo ivele khona.

Qaphela : Uncedo kulo mzekelo ubhekisela kumfanekiso ongentla.

1. Cofa kwiseli A4 (echazwe kumnyama emfanekisweni) kunye nesalathisi sakho semouse.
   
   
2. Thayipha uphawu olulinganayo ( = ) kwiseli ye-A4.

04 we-06

I-Google Spreadsheet Tutorial Formula: Isinyathelo 3 se-3

I-Google Spreadsheet Tutorial Formula: Isinyathelo 3 se-3

Ukulandela uphawu olulinganayo, songeza kwiingxelo zeeseli zeeseli eziqulethe idatha yethu.

Ngokusebenzisa iiferensi zesisele zeenkcukacha zethu kwifomula , ifomula iya kuhlaziya ngokuzenzekelayo impendulo ukuba idatha kwiiseli ze-A1, A2, okanye i-A3 zitshintsha.

Indlela engcono kakhulu yokongeza iiferensi zesetyenzisi ngokusebenzisa i-Google Spreadsheets ifowuni ekuthiwa ikhomba .

Ukutshintshwa kukuvumela ukuba ucofe kunye nemouse yakho kwiseli equle idatha yakho ukuze ungeze ifowuni yayo kwifomula.

Emva kokuba uphawu olulinganayo lufakwe kwisinyathelo 2

1. Cofa kwifowuni A1 kunye ne-pointer ye mouse ukuqinisekisa ukungena kweseli yesalathisi kwifom.
   
   
2. Thayipha uphawu lokuhlanganisa ( + ).
   
   
3. Cofa kwi-cell A2 kunye nekhompi ye mouse ukuqinisekisa ukungena kwifom yeselom.
   
   
4. Thayipha uphawu lweminus ( - ).
   
   
5. Cofa kwiseli A3 kunye nekhompi ye mouse ukuze ufake ifowuni yesalathisi kwifom.
   
   
6. Cinezela i- ENTER iqhosha kwikhibhodi.
   
   
7. Impendulo 1 kufuneka ibonakale kwiseli A4.
   
   
8. Cofa kwiseli A4. Ifom epheleleyo = A1 + A2 - A3 iboniswe kwibha yefomula ngaphezu kwephepha lokusebenzela .

05 ka 06

AbaSebenzi beMathematika kwiSpredishithi yeGoogle Spreadsheet

AbaSebenzi beMathematika asetyenziswa kwiFomula

Njengoko kuboniswe kumanyathelo angaphambili, ukubhala ifomu kwi-Google Spreadsheet ayinzima. Hlanganisa iinkcukacha zeseli zedatha yakho kunye nomqhubi weemathematika ochanekileyo.

Abaqhubi beemathematika asetyenziswa kwiifomula ze-Excel zifana nezo zisetyenziswa kwizifundo zamatriki.

• Ukukhupha - uphawu lokunciphisa ( - )
• Ukongeza - kunye nomqondiso ( + )
• Ulwahlulo - ukuqhuma phambili ( / )
• Ukuphindaphinda - i-asterisk ( * )
• Exponentiation - caret ( ^ )

06 we-06

I-Google Spreadsheet Order of Operations

I-Google Spreadsheet Order of Operations

Ukuba ngaphezulu komsebenzisi omnye kusetyenziswa kwifomu , kukho umyalelo othile othi i-Google Spreadsheet iya kulandela ukwenza le misebenzi yemathematika.

Lo myalelo wezenzo unokutshintshwa ngokufaka amabakaki kwi-equation. Indlela elula yokukhumbula umyalelo wemisebenzi kukusebenzisa isichazi:

BEDMAS

UMyalelo weMisebenzi ngu:

• B rackets
  E xponents
  D ivision
  M ultiplication
  Isibhengezo
  S ubtraction

Indlela uMyalelo weMisebenzi oSebenza ngayo

Naliphi na imisebenzi (e) equlethwe kwiibakaki iya kwenziwa emva kokuqala.

Emva koko, i-Google Spreadsheet ithatha imisebenzi yokwahlula okanye yokuphindaphinda ukuba ibaluleke ngokulinganayo, kwaye iqhuba le mi sebenzi ngokulandelelana kwayo isekho kwesokunxele kwi-equation.

Okufanayo kuya kwizinto ezimbini ezilandelayo-ukongeza nokukhupha. Zibhekwa njengelilinganayo ngendlela yokusebenza. Naluphi na umntu ovela kuqala kwi-equation, nokuba ukongeza okanye ukukhupha, ngumsebenzi owenziwa kuqala.