Ukufaka idatha ku-Microsoft Works Spreadsheets

01 ka-06

Ukuhlela Ama-Spreadsheets wakho we-Microsoft Works Works

Ukuhlela i-Work Spreadsheet

Ukufaka idatha kwi-Microsoft Works spreadsheet kulula njengokuchofoza kuseli , ukuthayipha inombolo, usuku, noma umbhalo bese ucindezela inkinobho ENTER ekhibhodi.

Yize kulula ukufaka idatha , umqondo omuhle ukwenza okuncane kokuhlela ngaphambi kokuthi uqale ukuthayipha.

Amaphuzu okucatshangelwayo :

1. Iyini injongo yespredishithi ?
   
   
2. Yiluphi ulwazi oludingeka lufakwe?
   
   
3. Yiziphi izihloko ezidingekayo ukuze uchaze ulwazi ku-Works spreadsheet?
   
   
4. Iyiphi indlela engcono kakhulu yolwazi?

02 ka 06

Izinkomba Zezinhlamvu ku-Microsoft Works Spreadsheets

Ama-Cell Facts

• Idatha igcinwa emasethini ku-Microsoft Works spreadsheet.
• Itheksthi ngayinye encane ku-Spreadsheet Works iseli.
• Iseli yikhasi lezinhlangothi zekholomu nomugqa kuspredishithi.

Ama-Spreadsheet Amaqiniso

• Amakholomu asebenza ngokuzenzakalelayo kuspredishithi futhi abonakala ngencwadi.
  
• Imigqa isebenza ngokuqondile futhi ibonakala ngenombolo.
• Kunemigqa engu-16,384, ngaphezu kwamakholomu angu-200, namasentimitha angaba ngu-4 emisebenzini ngayinye ye-Works spreadsheet.

Ama-Reference Reference Cell

• Ukuze ulandelele wonke lawa maseli, iseli ngalinye linombhalo weselula noma ikheli.
• Isithenjwa se-cell yinhlanganisela yombhalo wekholomu nenombolo yomugqa.
• Isithenjwa seseli esebenzayo siboniswa ebhokisini legama ngenhla kwekholomu A.

03 ka 06

Izinhlobo zeDispredishithi ze-Microsoft Works Spreadsheets

Kunezinhlobo ezintathu ezisemqoka zedatha ezisetshenziswe ku-Microsoft Works Spreadsheets:

• amalebula
• amanani
• izinsuku / izikhathi

Ilebula yinto yokungena evame ukusetshenziselwa izihloko, amagama, nokukhomba amakholomu wedatha. Amalebula angaqukatha izinhlamvu nezinombolo.

Inani liqukethe izinombolo futhi lingasetshenziswa ekubalweni.

Idatha / idatha yilelo kuphela, usuku noma isikhathi esangena esitokisini.

04 ka 06

Vula Amakholomu ku-Microsoft Works Spreadsheets

Vula Amakholomu ku-Microsoft Works Spreadsheets

Ngezinye izikhathi idatha idlula kakhulu ukuthi iseli itholakala. Uma lokhu kwenzeka, idatha kungenzeka noma ingadluli esitokisini eceleni kwayo.

• Uma ilebula ilinde kakhulu kuseli kodwa akukho lutho esitokisini ngakwesokudla kwalo ilebuli ivele igcwale isikhala ngakwesokudla (bona iseli B2 esithombeni ngenhla).
  
  
• Uma ilebula ivaliwe kakhulu esitokisini kodwa kukhona idatha esitokisini ngakwesokudla, ilebula inqunywe. Okunye kwelebula kusesekhona, kukhona indawo engenayo yokuyiveza (bheka iseli B4 esithombeni ngenhla).

Uma ilebula inqunywe, ungavula ikholomu ukuze uyibonise. Ku-Microsoft Works Spreadsheets, awukwazi ukuvula amaseli ngayinye, kufanele ukhulise lonke ikholomu.

Isibonelo - Khulisa Ikholomu B:

• Beka inkinobho yakho yegundane emgqeni phakathi kwamakholomu B no-C kusihlokweni sekholomu .
• Uma i-pointer ishintsha kumcibisholo ohlosiwe kabili, chofoza inkinobho yegundane bese uhudula ngakwesokudla.

05 ka 06

Vula Amakholomu ku-Microsoft Works Spreadsheets (con't)

Vula Amakholomu ku-Microsoft Works Spreadsheets (con't)

• Ku-Microsoft Works Spreadsheets, uma inani lide kakhulu kwiseli, alichitheli ngaphezu kwamaseli aseduze ngisho noma lawo maseli engenalutho. Ikholomu idinga ukukhululwa ngaphambi kokuthi inani liboniswe.

Esithombeni esingenhla, inombolo ibonakala esitokisini B2 (####) ikhombisa ukuthi kunenani (inombolo) kuleso seli.

Isibonelo - Khulisa Ikholomu B:

• Beka inkinobho yakho yegundane emgqeni phakathi kwamakholomu B no-C kusihlokweni sekholomu .
• Uma i-pointer ishintsha kumcibisholo ohlosiwe kabili, chofoza inkinobho yegundane bese uhudula ngakwesokudla.

06 ka-06

Ukuhlela Amaseli ku-Microsoft Works Spreadsheets

Shintsha i-Complete Cell Okuqukethwe

• Ku-Microsoft Works amaspredishithi ukushintsha okuqukethwe kweseli, chofoza kuseli, thayipha ngaphezulu kokungenayo, bese ucindezela inkinobho ENTER ekhibhodi.

Shintsha Ingxenye Yomphakathi Okuqukethwe

• Indlela 1
  • Chofoza kuseli ukuze wenze iseli esebenzayo .
  • Chofoza idatha ku-bar yefomula.
  • Susa ingxenye okumele ishintshwe bese uthayipha idatha entsha.
  • Cindezela inkinobho ENTER .
• Indlela 2
  • Chofoza kabili kuseli.
  • Hlela ingxenye yeseli ofuna ukuyishintsha.
  • Cindezela inkinobho ENTER .

Esikhathini esingenhla, izinombolo ezigqanyisiwe 5,6 no-7 ku- bar yefomula zingasuswa ngokucindezela ukhiye we- DELETE kukhibhodi uphinde uthunyelwe ngezinombolo ezahlukene. Ezinye izihloko kulolu chungechunge

• I-Microsoft Works Task Launcher
• I-MS Works Spreadsheet Ifomula