01 ngo-06
Ukucwangcisa iMicrosoft Works Works Spreadsheets
Ukucwangcisa iMisebenzi yeSpreadsheet
Ukufaka idatha kwi-Microsoft Works spreadsheet kulula nje ngokuchofoza kwiseli , ukuthayipha inombolo, umhla, okanye enye itekisi uze ucindezele i- ENTER iqhosha kwikhibhodi.
Nangona kulula ukungena kwedatha , yinto efanelekileyo ukwenza isicwangciso esithile ngaphambi kokuba uqale ukuthayipha.
Iingqalelo zokuqwalasela :
- Iyintoni injongo yespredishithi ?
- Ziziphi iinkcukacha ezifunekayo ukuba zifakwe?
- Ziziphi iintloko ezifunekayo ukucacisa ulwazi kwi-Works spreadsheet?
- Yiyiphi indlela engcono yokufumana ulwazi?
02 we-06
Iingxelo zoLuntu kwiMicrosoft Works Spreadsheets
Iinkcukacha zeSeli
- Idatha igcinwa kwiiseli kwiSpredishithi yeMisebenzi yeMicrosoft.
- Inxalenye nganye encinci kwi-Works spreadsheet iseli.
- Isisele yinqanaba le-intersection kwikholam kunye nomqolo kwi-spreadsheet.
Amaxwebhu eSpreadsheet
- Iikholam zihamba ngokuzenzekelayo kwispredishithi kwaye zichongwa yileta.
- Iimilo zihamba ngokuzenzekelayo kwaye zichongiwe ngenani.
- Kukho imiqolo engama-16,384, ngaphezu kwee-columns ezingama-200, kunye neeseli ezizigidi ezi-4 kwi-Works spreadsheet nganye.
IiNkcukacha zeSeli Reference
- Ukugcina umkhondo wezo zonke iiseli, iseli nganye isereferensi yeseli okanye idilesi.
- Isalathiso seeselumdibaniso yombhalo wekholomu kunye nenombolo yomqolo.
- Inkalo yesalathisi esebenzayo iboniswa kwibhokisi yegama ngasentla kwikholam A.
03 we-06
IiMicrosoft Work Spreadsheets Types of Data
Kukho iintlobo ezintathu eziphambili zedatha ezisetyenziswa kwiMicrosoft Works Spreadsheets:
- iilebula
- xabiso
- imihla / amaxesha
Ileta yinto yokungena esetyenziswa rhoqo kwizihloko, amagama, kunye nokuchonga iikholomu zedatha. Iilebula zingabhala neeleta kunye namanani.
Ixabiso liqulethe iinombolo kwaye linokusetyenziswa kwizibalo.
Idatha / idatha yinto nje, umhla okanye ixesha elifakwe kwiseli.
04 we-06
Yandisa Amakholomu kwiMicrosoft Works Spreadsheets
Yandisa Amakholomu kwiMicrosoft Works Spreadsheets
Ngamanye amaxesha idatha likhulu kakhulu ukuba iseli lifumaneka kuyo. Xa le nto yenzeka, idatha inakho okanye ingadluli kwisisele esecaleni kwayo.
- Ukuba ileyibhile ilinde ixesha kuseli kodwa akukho nto kwiselenki ngakwesokunene sayo ilebula itshabalalisa kwisithuba sokunene (bona iseli B2 kumfanekiso ongentla).
- Ukuba ileyibhile ilinde ixesha kuseli kodwa kukho idatha kwiseli ngakwesokudla, ilebula iyacinywa. Ezinye iilebula zikhoyo, akukho ndawo yokuzibonisa (jonga iseli B4 kumfanekiso ongentla).
Ukuba ilebula inqanyulwa, unokwandisa ikholomu ukuyibonisa. KwiMicrosoft Works spreadsheets, awukwazi ukwandisa iiseli nganye, kufuneka ukwandise lonke ikholomu.
Umzekelo - Khulisa ikholomu B:
- Beka i-pointer yakho yemouse kumgca phakathi kwamaColom B no-C kwintloko yekholomu .
- Xa i-pointer ishintshela kwisicatshulwa esiphindwe kabini, nqakraza nge mouse kwaye udibe ngakwesokudla.
05 ka 06
Yandisa Amakholomu kwiMicrosoft Works Spreadsheets (con't)
Yandisa Amakholomu kwiMicrosoft Works Spreadsheets (con't)
- KwiMicrosoft Works Spreadsheets, ukuba ixabiso lide kakhulu kwiseli, aliyi kuchitha iiseli eziseduze nokuba loo maseli ayinalutho. Ikholamu kufuneka ikhuliswe ngaphambi kokuba ixabiso lingabonakaliswa.
Kulo mfanekiso ungentla, inani leempawu kwifowuni B2 (####) ibonisa ukuba kukho inani (inombolo) kweso sisele.
Umzekelo - Khulisa ikholomu B:
- Beka i-pointer yakho yemouse kumgca phakathi kwamaColom B no-C kwintloko yekholomu .
- Xa i-pointer ishintshela kwisicatshulwa esiphindwe kabini, nqakraza nge mouse kwaye udibe ngakwesokudla.
06 we-06
Ukuhlela iiseli kwiMicrosoft Works Spreadsheets
Shintsha Gcwalisa iSiqulatho seSilimu
- KwiMicrosoft Works spreadsheet ukutshintsha okuqukethwe kweseli, nqakraza kwiseli, thayipha ngaphaya kokungena, kwaye cinezela ENTER kwikhibhodi.
Shintsha iNgxenye yeZiqulatho zeSeli
- Indlela 1
- Cofa kwiseli ukwenzela ukuba yenze iseli esebenzayo .
- Cofa kwiedatha kwibha yefomula.
- Cima inxalenye ekufuneka ishintshwe kwaye uthayiphe idatha entsha.
- Cinezela i- ENTER iqhosha.
- Indlela 2
- Cofa kabini kwiseli.
- Hlela inxalenye yeseli ofuna ukuyitshintsha.
- Cinezela i- ENTER iqhosha.
Kumzekelo ongentla, iinombolo ezi-5,6 no-7 ezigqityiweyo kwibhar yomfomula zingasuswa ngokucinezela ukucima ukhiye kwibhodibhodi uze utshintshwe ngamanani ahlukeneyo. Ezinye iiNqaku kwiChungechunge