Kupinda Dhidhi muMicrosoft Works Spreadsheets

01 of 06

Kuronga Mirairo Yenyu yeMicrosoft

Kuronga Basa reSpreadsheet

Kuisa dhipatimendi mukati meMicrosoft Works spreadsheet kwakaoma sekunyorera pane seki , kuverenga nhamba, zuva, kana mamwe mavara uye nekufambisa ENTER kiyi pane keyboard.

Kunyange zvazvo zviri nyore kupinda deta , iri pfungwa yakanaka yekuita zvishoma kuronga usati watanga kuisa.

Points to consider :

1. Chinangwa chepadhetiti chii ?
   
   
2. Ndeupi ruzivo rwunoda kuiswa?
   
   
3. Ndezvipi zvinyorwa zvinodiwa kuti utsanangure ruzivo rweMabasa spreadsheet?
   
   
4. Ndeipi nzvimbo yakanakisisa yemashoko?

02 of 06

Cell References muMicrosoft Works Spreadsheets

Cell Facts

• Dhiyabhorosi inochengeterwa mumasero muSpanish Works spreadsheet.
• Rimwe rectangle shoma muSeji spreadsheet isero.
• Sero ndiyo nharo yepakati yekorodhe uye mutsara mune pepadheetiti.

Mashoko eSpreadsheet

• Columns inotenderera mukati pepasiteteti uye inozivikanwa netsamba.
  
• Rwizi runomhanya rwakananga uye runoratidzwa nenhamba.
• Kune mitsara 16,384, inopfuura 200 columns, uye inenge mamiriyoni mana emasero mune rimwe rega Works spreadsheet.

Cell References Facts

• Kuti uchengetedze yese idzi masero, sero rimwe nerimwe rinotarisa sero kana kuti kero.
• Sero rinoreva kusanganiswa kwemutsara wechikamu uye nhamba yemutsara.
• Iko kushanda cell reference inoratidzwa mubhokisi rezita riri pamusoro pendarira A.

03 of 06

Microsoft Works Works Spreadsheets Data Types

Iko kune mitatu mikuru yemhando yakashandiswa muMicrosoft Works Spreadsheets:

• mavara
• tsika
• mazuva / nguva

Chirairo inopinda inowanzoshandiswa pamusoro, mazita, uye pakutsvaga mapuranga e data. Mavara aya anogona kunyora tsamba netsamba.

Nhamba ine nhamba uye inogona kushandiswa mukuverenga.

Zuva / nguva dhenda ndeyekuti, zuva kana nguva yakapinda muchitokisi.

04 of 06

Wedzera Mapuranga muMicrosoft Works Spreadsheets

Wedzera Mapuranga muMicrosoft Works Spreadsheets

Dzimwe nguva dhamari yakawandisa zvokuti sero iri iri. Kana izvi zvikaitika, deta inogona kana kuti isingasviki mukati memusero pedyo nayo.

• Kana hodhi yakareba kwenguva refu kune sero asi hapana chinhu chiri muchitokisi kusvika kurudyi kwayo iyo inoratidzirwa inongoputira kusvika munzvimbo yakarurama (ona sero B2 mumufananidzo uri pamusoro).
  
  
• Kana hodhi yakareba kwenguva refu kune sero asi kune dhegi iri muchitokisi kuenda kurudyi, chirairo chacho chakabviswa. Zvose zvisiri izvo zvinenge zviripo, pane imwe nzvimbo yekamuri yekuiratidza (ona sero B4 mumufananidzo uri pamusoro).

Kana hodhi yakabviswa, unogona kuwedzera iyo korumoni kuti iratidze. MuMicrosoft Works spreadsheets, haukwanisi kuwedzera masero ega, unofanira kuwedzera iyo yose koromo.

Muenzaniso - Wedzera Column B:

• Isa mushonga wako mutsara pamuganhu pakati peColumns B uye C mumusoro we column .
• Apo pointer inoshanduka kune mutsara wepamusoro maviri, dhura nebhokisi redu uye tira kurudyi.

05 of 06

Wedzera Ma Columns muMicrosoft Works Spreadsheets (con't)

Wedzera Ma Columns muMicrosoft Works Spreadsheets (con't)

• MuMicrosoft Works Spreadsheets, kana huwandu hwakareba kwenguva refu kune sero, haukwanisi kupera kumasero ari pedyo kunyange kana masero aya asina chinhu. Iyo chinyorwa inoda kuwedzerwa vasati vayo inogona kuiswa.

Mumufananidzo wepamusoro, nhamba inowanikwa muchitokisi B2 (####) inoratidza kuti pane kukosha (nhamba) mune iyo seki.

Muenzaniso - Wedzera Column B:

• Isa mushonga wako mutsara pamuganhu pakati peColumns B uye C mumusoro we column .
• Apo pointer inoshanduka kune mutsara wepamusoro maviri, dhura nebhokisi redu uye tira kurudyi.

06 of 06

Kugadziridza Kero muMicrosoft Works Spreadsheets

Shandura Complete Cell Zviri Mukati

• MuMicrosoft Works spreadsheets kuti uchinje zviri mukati memusero, chengetera pane sero, tonga pane pane zviripo, uye shandisa ENTER kiyi pane keyboard.

Shandura Chikamu cheSunhare Zviri Mukati

• Method 1
  • Dzvanya pane sero kuti uite sero rinoshanda .
  • Dzvanya pane data iri mubhadharo yebhu.
  • Bvisa chikamu chaunofanira kuchinjwa uye chengetedza mune data itsva.
  • Dhinda re ENTER key.
• Method 2
  • Dzoka kaviri pane sero.
  • Isa chikamu chesero chaunoda kuchinja.
  • Dhinda re ENTER key.

Mumuenzaniso wepamusoro, nhamba dzakasimbiswa 5,6 uye 7 mubha yebhurasi dzinogona kubviswa nekusimudzira kUSI KUTEZA pane keyboard uye shandiswa nemhando dzakasiyana. Zvimwe Zvinyorwa munyaya ino

• Microsoft Works Task Launcher
• MS Works Spreadsheet Mafomu