Kulowa Dongosolo mu Microsoft Works Spreadsheets

01 ya 06

Kukonzekera Anu Ntchito Zachipangizo za Microsoft

Kukonzekera Zowonjezera Ntchito

Kulowetsa deta mu Microsoft Works spreadsheet ndi kosavuta monga kuwonekera pa selo , kuwerengera nambala, tsiku, kapena malemba ndikukankhira ENTER kwa makiyi.

Ngakhale n'zosavuta kulowa deta , ndi bwino kupanga mapulani pang'ono musanayambe kulemba.

Mfundo zofunikira kuziganizira :

1. Kodi cholinga cha spreadsheet n'chiyani?
   
   
2. Ndi chidziwitso chiti chomwe chiyenera kuphatikizidwa?
   
   
3. Kodi ndizofunika zotani kuti mufotokoze zomwe zili mu Works spreadsheet?
   
   
4. Kodi ndondomeko yabwino yotani yowonjezerayi?

02 a 06

Maofesi a Mapepala mu Microsoft Works Spreadsheets

Mfundo za Cell

• Deta imasungidwa m'maselo a Microsoft Works spreadsheet.
• Mzere uliwonse waung'ono mu Works spreadsheet ndi selo.
• Selo ndilo gawo lopatiliza pakati pa mzere ndi mzere mu spreadsheet.

Mfundo Zachidule

• Mizere imayenda mozungulira pa tsamba lamasamba ndipo imadziwika ndi kalata.
  
• Mizere imayenda mozungulira ndipo imadziwika ndi nambala.
• Pali mizere 16,384, pamwamba pa columns 200, ndi pafupifupi 4 miliyoni maselo pa Ntchito iliyonse spreadsheet.

Mfundo Zolemba za Cell

• Kuti muzindikire maselo onsewa, selo iliyonse ili ndi malo kapena ma adiresi.
• Chiwerengero cha selo ndi kuphatikiza kalata ya mzere ndi nambala ya mzere.
• Mawu ogwira ntchito omwe akugwiritsidwa ntchito akuwonetsedwa mubokosi la mayina pamwamba pa ndime A.

03 a 06

Mankhwala a Dongosolo la Microsoft Works Spreadsheets

Pali mitundu itatu yaikulu ya deta yogwiritsidwa ntchito mu Microsoft Works Spreadsheets:

• malemba
• miyezo
• masiku / nthawi

Chilembo ndicholowetsamo chomwe chimagwiritsidwa ntchito pamutu, mayina, ndi pozindikira ndondomeko za deta. Malemba angakhale ndi makalata ndi manambala.

Phindu liri ndi manambala ndipo lingagwiritsidwe ntchito powerengera.

Deta / tsiku ladatha ndilo, tsiku kapena nthawi yalowa mu selo.

04 ya 06

Yambani Zikhoma mu Microsoft Works Spreadsheets

Yambani Zikhoma mu Microsoft Works Spreadsheets

Nthawi zina deta ndi yayikulu kwambiri kuti selo ilo likhalemo. Pamene izi zichitika, deta ikhoza kapena sichidzalowa mu selo pambali pake.

• Ngati chizindikiro chiri kutali kwambiri kwa selo koma palibe kalikonse kamene kali m'kachipinda kamene kalipo kalikonse kamene kamangoyambira kumene kumalo kumanja (onani selo B2 mu chithunzi pamwambapa).
  
  
• Ngati chizindikiro chiri kutali kwambiri kwa selo koma pali deta mu selo kumanja, chizindikirocho chathetsedwa. Zina zonsezo zilipobe, pali chipinda chokha choti chiwonetsetse (onani selo B4 mu chithunzi pamwambapa).

Ngati chizindikiro chatsekedwa, mungathe kukulitsa chithunzicho kuti chiwonetsedwe. Mu Microsoft Works spreadsheets, simungathe kukulitsa maselo ena, muyenera kuwonjezera chigawo chonsecho.

Chitsanzo - Yambani Phukusi B:

• Ikani pointerani yanu pamsana pa mzere pakati pa Mizati B ndi C mu mutu wa mutu .
• Pamene pointer ikusintha pavivi chophindikizira chachiwiri, dinani ndi bokosi la mbewa ndikukoka kumanja.

05 ya 06

Yambani Zikhoma mu Microsoft Works Spreadsheets (con't)

Yambani Zikhoma mu Microsoft Works Spreadsheets (con't)

• Mu Microsoft Works Spreadsheets, ngati mtengo ndi wautali kwambiri kwa selo, sizimataya maselo oyandikana ngakhale ngati maselowo alibe. Chigawocho chiyenera kukulitsidwa mtengo usanawonetsedwe.

Mu chithunzi pamwambapa, chiwerengero cha zizindikiro mu selo B2 (####) chikusonyeza kuti pali chiwerengero (chiwerengero) mu selo limenelo.

Chitsanzo - Yambani Phukusi B:

• Ikani pointerani yanu pamsana pa mzere pakati pa Mizati B ndi C mu mutu wa mutu .
• Pamene pointer ikusintha pavivi chophindikizira chachiwiri, dinani ndi bokosi la mbewa ndikukoka kumanja.

06 ya 06

Maselo Kusintha mu Microsoft Works Spreadsheets

Sinthani Mzere Wosatha mkati

• Mu Microsoft Works spreadsheets kuti musinthe zomwe zili mu selo, dinani pa selo, yesani pazowonjezerapo, ndipo yesani ku ENTER kwa makiyi.

Sinthani gawo la Cell Zamkatimu

• Njira 1
  • Dinani mu selo kuti mupange selo yogwira ntchito .
  • Dinani pa deta mu bar.
  • Chotsani gawolo kuti lisinthidwe ndi kujambula mu deta yatsopano.
  • Dinani ku ENTER .
• Njira 2
  • Dinani kawiri pa selo.
  • Sinthani mbali ya selo yomwe mukufuna kusintha.
  • Dinani ku ENTER .

Mu chitsanzo pamwambapa, nambala zisanu ndi ziwiri 5,6 ndi 7 mu barra yazenera zingachotsedwe mwa kukankhira chotsekera DELETE pa kambokosi ndikusintha ndi nambala zosiyana. Nkhani zina mu Nkhaniyi

• Mkonzi Woyambitsa Ntchito wa Microsoft
• MS Works Spreadsheet Mafomu