Difference between revisions of "LibreOffice-Suite-Calc/C2/Working-with-Cells/Khasi"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with '{| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Khublei ngi pdiang sngewbha iaphi sha ka Spoken tutorial LibreOffice Calc ha kaba iadei bad ka rukom pyndonkam iaki cells. |…')
 
Line 1: Line 1:
{| border=1
+
 
|| VISUAL CUE
+
 
|| NARRATION
+
{|Border=1
 +
|'''Time'''
 +
|'''Narration'''
 +
 
 
|-
 
|-
|| 00:00
+
| 00:00
|| Khublei ngi pdiang sngewbha iaphi sha ka Spoken tutorial LibreOffice Calc ha kaba iadei bad ka rukom pyndonkam iaki cells.
+
| | Khublei ngi pdiang sngewbha iaphi sha ka Spoken tutorial halor ka LibreOffice Calc ha kaba iadei bad ka rukom pyndonkam iaki cells.
 +
 
 
|-
 
|-
|| 00:06
+
| 00:06
|| Ha kane ka tutorial ngin pule shaphang:
+
| | Ha kane kajinghikai ngin pule shaphang:
 +
 
 
|-
 
|-
|| 00:08
+
| 00:08
|| Kumno ban thep iaki nombar, ki jingthoh, ki nombar kum ka jingthoh, ka tarik bad kapor ha ka spreadsheet.
+
| | Kumno ban pynrung iaki nombar, ki jingthoh, ki nombar kum ka jingthoh, ka tarik bad kapor ha ka spreadsheet.
 +
 
 
|-
 
|-
|| 00:16
+
| 00:16
||Kumno ban pyndonkam iaka Format cells dialog box
+
| | Kumno ban pyndonkam iaka Format cells dialog box
 +
 
 
|-
 
|-
|| 00:19
+
| 00:19
||Kumno ban kdew ban phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
+
| | Kumno ban kdew ban phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
 +
 
 
|-
 
|-
|| 00:23
+
| 00:23
||Kumno ban jied iaki item ha ki rows, columns bad sheets.
+
| | Kumno ban jied iaki item ha ki rows, columns bad sheets.
 +
 
 
|-
 
|-
|| 00:29
+
| 00:29
|| Hangne ngin pyndonkam da ka Ubuntu 10.04 Operating system bad LibreOffice Suite version 3.3.4.
+
| | Hangne ngin pyndonkam da ka Ubuntu 10.04 kum ka Operating system bad LibreOffice Suite version 3.3.4.
 +
 
 
|-
 
|-
|| 00:39
+
| 00:39
|| Te to mynta ngin sdang ban pule kumno ban thep iaki data ha ki cells.
+
| | Te to mynta ngin sdang ban pule kumno ban pynrung iaki data ha ki cells.
 +
 
 
|-
 
|-
|| 00:43
+
| 00:43
||Ngin plié iaka Personal finance tracker.ods
+
| | Ngin plié iaka Personal finance tracker.ods
 +
 
 
|-
 
|-
|| 00:49
+
| 00:49
|| Phi lah ban type kino kino ki jingthoh ha kawei kawei ka cell da kaba click ha kato ka cell nangta sa type da kaba pyndonkam ka keyboard jong phi.
+
| | Phi lah ban type kino kino ki jingthoh ha kawei ka cell da kaba click ha kato ka cell nangta sa type da kaba pyndonkam da ka keyboard.
|-
+
 
|| 00:59
+
||Ha kaba nyngkong ki jingthoh kiba phi type kin phai ha kaliang kadiang. Phi lah ban pynkylla iaka jaka jong ka da kaba click ha uno uno u Alignment tabs ha u Formatting Bar.
+
 
|-
 
|-
|| 01:08
+
| 00:59
||To ngin phaidien biang kumba kalong nyngkong.
+
| | Ki jingthoh ki la shah pynryntih sha kadiang. Phi lah ban pynkylla iaka jaka jong ka da kaba click ha uno uno u Alignment tabs ha u Formatting Bar.
 +
 
 
|-
 
|-
|| 01:11
+
| 01:08
||Mynta click ha u cell uba pyni A1 ha ka spreadsheet.
+
| | To ngin phaidien biang kumba kalong nyngkong.
 +
 
 
|-
 
|-
|| 01:15
+
| 01:11
||Phi iohi hangne ba ka cell ba phi kdew kalah thaba.
+
| | Mynta click ha u cell uba pyni A1 ha ka spreadsheet.
 +
 
 
|-
 
|-
|| 01:20
+
| 01:15
|| Hangne ngi lah dep type lypa iaka heading jong ka column.
+
| | Phi iohi hangne ba ka cell ba phi kdew ka la thaba.
 +
 
 
|-
 
|-
|| 01:24
+
| 01:20
||Hapoh ha heading, “Items” ngin type kato katne kiwei pat ki items hapoh jong ka kum “Salary”, “House rent”, “Electricity bill”, “Phone bill”, “Laundry” and “Miscellaneous”.
+
| | Hangne ngi lah dep type lypa iaka heading jong ka column.
 +
 
 
|-
 
|-
|| 01:38
+
| 01:24
||Ban ioh ban pynrung iaki nombar ha ka cell, klik ha ka cell bad type iaki nombar
+
| | Hapoh ka heading, “Items” ngin type kato katne kiwei pat ki items hapoh jong ka kum “Salary”, “House rent”, “Electricity bill”, “Phone bill”, “Laundry” and “Miscellaneous”.
|-
+
 
|| 01:43
+
||Ban pynrung ia u negatib nombar, phi lah ban buh da u dak minos hashwa jong u ne phi lah ban buh ia u hapdeng ki braket.
+
 
|-
 
|-
|| 01:53
+
| 01:38
||Kum ka rukom, ki nombar lah pynryntih sha kamon, ban ki negatib nombar ki bud hadien u dak minos.
+
| | Ban ioh ban pynrung iaki nombar ha ka cell, klik ha ka cell bad type iaki nombar
 +
 
 
|-
 
|-
|| 02:01
+
| 01:43
||To ngin phaidien biang ia baroh ki jingpynkylla.
+
| | Ban pynrung ia u negatib nombar, phi lah ban buh da u dak minos hashwa jong u ne phi lah ban buh ia u hapdeng ki braket.
 +
 
 
|-
 
|-
|| 02:04
+
| 01:53
||Mynta hapoh u heading Serial Number, ba la thoh “SN” ha ka spreadsheet “personal finance tracker.ods”, ngi kwah ba u serial nombar jong uwei pa uwei u item ban un long hapoh jong uwei pat.  
+
| | Kum ka rukom, ki nombar la pynryntih sha kamon, bad ki negatib nombar ki bud hadien u dak minos.
 +
 
 
|-
 
|-
|| 02:17
+
| 02:01
||Te klik ha ka cell ba iahap bad “A2” bad pynrung iaki nombar kum 1, 2,3 uwei hapoh jong uwei pat.
+
| | To ngin phaidien biang ia baroh ki jingpynkylla.
 +
 
 
|-
 
|-
|| 02:27
+
| 02:04
||Ban ioh ban pyndap iaki serial nombar ha ka rukom automatic, klik ha ka cell ”A4”. Kawei ka box barit balong rong iong ha kaliang kamon sha ka bynta ba shapoh. Drag iaka cell haduh “A7” bad sa pyllait noh ia u buton jong u mouse.
+
| | Mynta hapoh u heading Serial Number, ba la thoh “SN” ha ka spreadsheet “personal finance tracker.ods”jong ngi , ngi kwah ba u serial nombar jong uwei pa uwei u item ban un long hapoh jong uwei pat.
 +
 
 
|-
 
|-
|| 02:42
+
| 02:17
||Phin sa iohi ba ki cell “A5” haduh”A7” kin sa dap da ki serial nombar.
+
| | Te klik ha ka cell ba iahap bad “A2” bad pynrung iaki nombar kum 1, 2,3 uwei hapoh jong uwei pat.
 +
 
 
|-
 
|-
|| 02:51
+
| 02:27
||Hadien ba phi lah dep pynrung iaki serial nombar jongki item, mynta ngin pynrung ia kador lane “cost” jong kawei pa kawei ka item hapoh ka heading” cost”
+
| | Khnang ban pyndap iaki serial nombar ha ka rukom automatic, klik ha ka cell ”A4”. Kawei ka box barit balong rong iong ha kaliang kamon sha ka bynta ba shapoh ka paw. Tan iaka cell haduh “A7” bad sa pyllait noh ia u buton jong u mouse.
 +
 
 
|-
 
|-
|| 02:59
+
| 02:42
|| Te ngi klik ha ka cell ba la ai kyrteng “C3” bad type ia ka dor jinglut na ka bynta “ House rent ” kum “Rupees 6000”
+
| | Phin sa iohi ba ki cell “A5” haduh”A7” kin sa dap da ki serial nombar.
 +
 
 
|-
 
|-
|| 03:07
+
| 02:51
||Mynta kan jia aiu lada ngi kwah ban thoh ha shwa jong u nombar da u dak na bynta pisa.
+
| | Hadien ba phi la dep pynrung iaki serial nombar jongki item, mynta ngin pynrung ia kador jong kawei pa kawei ka item hapoh ka heading” cost”
 +
 
 
|-
 
|-
|| 03:11
+
| 02:59
||Shubuh, ngi kwah ban pynrung ”Rupees 800” na ka bynta “Electricity bill”. Te, klik ha kaliang kamon jong u mouse bad nangta klik ha u opshon ”Format Cells”
+
| | Te ngi klik ha ka cell ba la ai kyrteng “C3” bad type ia ka dor jinglut na ka bynta “ House rent ” kum “Rupees 6000”
 +
 
 
|-
 
|-
|| 03:23
+
| 03:07
||Kane kan sa plie iaka “Format Cells” dialog box.
+
| | Mynta, kan jia aiu lada ngi kwah ban thoh ha shwa jong u nombar da u dak na bynta pisa.
 +
 
 
|-
 
|-
|| 03:27
+
| 03:11
||U tab ba nyngkong u dei “Numbers”. Te klik hangta lada ym pat dep select iaka.
+
| | Shubuh, ngi kwah ban pynrung ”Rupees 800” na ka bynta “Electricity bill”. Te, klik ha kaliang kamon jong u mouse bad nangta klik ha u opshon ”Format Cells”
 +
 
 
|-
 
|-
|| 03:32
+
| 03:23
||Shibun kiwei pat ki bynta phi iohi hapoh “Category” kum Number, Percent, Currency, Date, Time bad sa kiwei pat.
+
| | Kane kan sa plie iaka “Format Cells” dialog box.
 +
 
 
|-
 
|-
|| 03:41
+
| 03:27
||To ngin jied Currency.
+
| | U tab ba nyngkong u dei “Numbers”. Te klik hangta lada ym pat dep select iaka.
 +
 
 
|-
 
|-
|| 03:44
+
| 03:32
||Mynta hapoh jong u Format opshon, klik ha u khnam ba shapoh. Kane kan sa plie ia shibun ki dak symbol jongki currency kylleng ka pyrthei.
+
| | Shibun kiwei pat ki bynta phi lah ban iohi hapoh “Category” kum Number, Percent, Currency, Date, Time bad sa kiwei pat.
 +
 
 
|-
 
|-
|| 03:53
+
| 03:41
||To ngin scroll ne kiew shajrong bad jied INR Rupees English India. Ka Rupee 1,234 ba lah dep jied lypa kan sa paw ha ka drop down ba shapoh.
+
| | To ngin jied Currency.
 +
 
 
|-
 
|-
|| 04:04
+
| 03:44
||Phi lah ban iohi ia ka rukom long jong ka ha ka bynta ba sha kaliang kamon.
+
| | Mynta hapoh jong u Format opshon, klik ha u khnam ba shapoh. Kane kan sa plie ia shibun ki dak symbol jongki pisa kylleng ka pyrthei.
 +
 
 
|-
 
|-
|| 04:10
+
| 03:53
||Hapoh Options, ngi don ia u opshon ban pynrung ia u nombar jongki Desimal bad ki nombar jongki zero ki ban bud hadien jong u katkum ka jingkwah jong ngi.  
+
| | To ngin scroll shajrong bad jied INR Rupees English India. Ka Rupee 1,234 ba lah dep jied lypa kan sa paw ha ka drop down ba shapoh.
 +
 
 
|-
 
|-
|| 04:20
+
| 04:04
||Ngin khmih mynta katba ngi nang pynbun iaki zero, ka bynta hapoh ka Format kan kylla sha Rupees 1,234 desimal zero zero kaba pyni ba don artylli ki jaka decimal.
+
| | Phi lah ban iohi ia ka rukom long jong ka ha ka bynta ba sha kaliang kamon.
 +
 
 
|-
 
|-
|| 04:35
+
| 04:10
||Phin shem iaki jingpynkylla ha ka jaka ba khot preview area.
+
| | Hapoh Options, ngi don ia u opshon ban pynrung ia u nombar jongki Desimal bad ki nombar jongki zero ki ban bud hadien jong u katkum ka jingkwah jong ngi.
 +
 
 
|-
 
|-
|| 04:40
+
| 04:20
||Klik ha Thousands Separator ban ioh ban pynsnoh da u ”comma” ha man ka thousand. Sa shisien phin shem ia ki jingkylla ha ka jaka ba lah pyni.
+
| | Peit bha katba ngi nang pynbun iaki zero, ka bynta hapoh ka Format ka la kylla sha Rupees 1,234 desimal zero zero kaba pyni ba don artylli ki jaka decimal.
 +
 
 
|-
 
|-
|| 04:50
+
| 04:35
||Lah ruh ban pynkylla iaki font style da kaba klik ha u Font tab. U don shibun ki opshon na bynta Font, Typeface bad ka Size.
+
| | Phin shem iaki jingpynkylla ha ka jaka ba la pyni.
 +
 
 
|-
 
|-
|| 05:00
+
| 04:40
||Peit bad khmih ia Ki Font Effects bad kiwei pat ki tab ban tip bha shaphang jongki.
+
| | Klik ha Thousands Separator ban ioh ban pynsnoh da u ”comma” ha man ka thousand. Sa shisien phin shem ia ki jingkylla ha ka jaka ba la pyni.
 +
 
 
|-
 
|-
|| 05:05
+
| 04:50
||Ngin sa pule shaphang ki opshon ha Alignment tab ha kawei pat ka tutorial.
+
| | Lah ruh ban pynkylla iaki font style da kaba klik ha u Font tab. U don shibun ki opshon na bynta Font, Typeface bad ka Size.
  
 
|-
 
|-
|| 05:11
+
| 05:00
||To ngin iaklik ha OK.
+
| | Peit bad khmih ia Ki Font Effects bad kiwei pat ki tab ban tip bha shaphang jongki.
 +
 
 
|-
 
|-
||05:15
+
| 05:05
||To ngin type 800 bad pres Enter. Phin sa iohi ba u nombar 800 un sa paw kum Rupees 800 bad 2 tylli ki decimal.
+
| | Ngin sa pule shaphang ki opshon ha Alignment tab ha kawei pat ka jinghikai.
 +
 
 
|-
 
|-
|| 05:26
+
| 05:11
||Mynta to ngin jied iaki cell C5 haduh C7. Nion ia u CTRL key bad sa jied iaka cell G2 ruh. Phin sa iohi ba baroh ki cell ki lah thaba.
+
| | To ngin iaklik ha OK.
 +
 
 
|-
 
|-
|| 05:39
+
| 05:15
||Klik u mouse kamon ha kano kano ka cell ba thaba bad jied Format Cells.
+
| | To ngin type 800 bad nion Enter. Phin sa iohi ba u nombar 800 un sa paw kum Rupees 800 bad 2 tylli ki decimal.
 +
 
 
|-
 
|-
|| 05:46
+
| 05:26
||Jied iaki juh ki opshon kumba ha shwa. Klik ha OK.
+
| | Mynta to ngin jied iaki cell C5 haduh C7. Nion ia u CTRL key bad sa jied iaka cell G2 ruh. Phin sa iohi ba baroh ki cell ki lah thaba.
 +
 
 
|-
 
|-
|| 05:51
+
| 05:39
||Mynta ngi thoh iaki jinglut jong kiwei pat ki items kawei hapoh jong kawei pat kum “Rupees 600” na bynta ka “Phone bill”, ”Rupees 300” na bynta ki jinglut ha “Laundry” bad “Rupees 2000”kum kita kiwei pat ki jinglut ne “Miscellaneous”
+
| | Klik ha u mouse na kamon ha kano kano ka cell ba thaba bad jied Format Cells.
  
 
|-
 
|-
|| 06:06
+
| 05:46
||Hapoh ka heading “Accounts” ngi type iaka salary na ka bynta kato ka bnai kum “Rupees 30000”
+
| | Jied iaki juh ki opshon kumba ha shwa. Klik ha OK.
 +
 
 
|-
 
|-
|| 06:13
+
| 05:51
||Ban pynrung iaka tarik ha Calc, jied iaka cell bad type iaka tarik. 
+
| | Mynta ngi thoh iaki jinglut jong kiwei pat ki items kawei hapoh jong kawei pat kum “Rupees 600” na bynta ka “Phone bill”, ”Rupees 300” na bynta ki jinglut ha “Laundry” bad “Rupees 2000”kum kita kiwei pat ki jinglut ne “Miscellaneous”
 +
 
 
|-
 
|-
|| 06:18
+
| 06:06
||Phi lah ruh ban phiah iaki bynta jongki tarik da kaba thoh ia u forward slash ne u hyphen ne phi lah ban thoh kum 10 October 2011.
+
| | Hapoh ka heading “Accounts” ngi type iaka salary na ka bynta kato ka bnai kum “Rupees 30000”
 +
 
 
|-
 
|-
|| 06:27
+
| 06:13
||Ka Calc kalah ban ithuh ia shibun tylli ki rukom thoh tarik.
+
| | Ban pynrung iaka tarik ha Calc, jied iaka cell bad type iaka tarik.
 +
 
 
|-
 
|-
|| 06:32
+
| 06:18
||Ha kawei pat ka rukom, klik u mouse kamon ha ka cell bad jied ia u opshon “Format Cells”
+
| | Phi lah ruh ban phiah iaki bynta jongki tarik da kaba thoh ia u forward slash ne u hyphen ne phi lah ban thoh kum 10 October 2011.
 +
 
 
|-
 
|-
|| 06:38
+
| 06:27
||Hapoh kato ka bynta jied “Date” bad ka format ba phi kwah hapoh “Format”. Ngin jied 12,31,1999. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
+
| | Ka Calc kalah ban ithuh ia shibun tylli ki rukom thoh tarik.
 +
 
 
|-
 
|-
|| 06:51
+
| 06:32
||Ka Format code ka paw hapoh kum MM, DD bad YYYY. Lah ban jied iaka Format code katkum ka jingkwah jong phi.
+
| | Ha kawei pat ka rukom, klik na kamon ha ka cell bad jied ia u opshon “Format Cells”
 +
 
 
|-
 
|-
|| 07:02
+
| 06:38
||Ngan type DD,MM bad YYYY. Phi lah ban iohi iaki jingpynkylla ha ka jaka preview.  
+
| | Hapoh kato ka bynta jied “Date” bad ka format ba phi kwah hapoh “Format”. Ngin jied 12,31,1999. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
Klik OK.
+
 
 
|-
 
|-
||07:12
+
| 06:51
||Ban pynrung iaka por ha Calc, Jied iaka cell bad type iaka por.
+
| | Ka Format code ka paw hapoh kum MM, DD bad YYYY. Lah ban jied iaka Format code katkum ka jingkwah jong phi.
 +
 
 
|-
 
|-
|| 07:18
+
| 07:02
||Phi lah ban phiah iaki bynta jong kapor da kaba buh iaki colon kum 10 colon 43 colon 20.
+
| | Ngan type DD,MM bad YYYY. Phi lah ban iohi iaki jingpynkylla ha ka jaka preview. Klik OK.
 +
 
 
|-
 
|-
|| 07:24
+
| 07:12
||Ha kawei pat ka rukom, klik u mouse kamon ha ka cell bad jied ia u opshon “Format Cells”
+
| | Ban pynrung iaka por ha Calc, Jied iaka cell bad type iaka por.
 +
 
 
|-
 
|-
|| 07:31
+
| 07:18
||Hapoh kato ka bynta jied “Time” bad ka format ba phi kwah hapoh “Format”. Ngin jied 13,37,46. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.  
+
| | Phi lah ban phiah iaki bynta jong kapor da kaba buh iaki colon kum 10 colon 43 colon 20.
 +
 
 
|-
 
|-
|| 07:43
+
| 07:24
||Ka Format code ka paw hapoh kum HH:MM: SS. Lah ban jied iaka Format code katkum ka jingkwah jong phi. Ngan type HH:MM
+
| | Ha kawei pat ka rukom, klik na kamon ha ka cell bad jied ia u opshon “Format Cells”
 +
 
 
|-
 
|-
|| 07:57
+
| 07:31
||Phi lah ban iohi iaki jingpynkylla ha ka jaka preview.
+
| | Hapoh kato ka bynta jied “Time” bad ka format ba phi kwah hapoh “Format”. Ngin jied 13,37,46. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
Klik OK.
+
 
 
|-
 
|-
|| 08:03
+
| 07:43
||To ngin phaidien biang ia baroh ki jingpynkylla.
+
| | Ka Format code ka paw hapoh kum HH:MM: SS. Lah ban jied iaka Format code katkum ka jingkwah jong phi. Ngan type HH:MM
 +
 
 
|-
 
|-
|| 08:06
+
| 07:57
|| Hadien ba ngi lah dep pule kumno ban thoh ia ki jingthoh, nombar bad tarik ha ka Calc, mynta ngin pule kumno ban kdew bad ban phai ha kajuh ka spreadsheet na kawei ka cell sha kawei bad na kawei ka sheet sha kawei pat.
+
| | Phi lah ban iohi iaki jingpynkylla ha ka jaka preview. Klik OK.
 +
 
 
|-
 
|-
|| 08:17
+
| 08:03
||Te ngin ia peit shwa mynta kumno ban kdew bad phai na kawei ka cell sha kawei pat ha ka spreadsheet.
+
| | To ngin phaidien biang ia baroh ki jingpynkylla.
 +
 
 
|-
 
|-
|| 08:23
+
| 08:06
|| Phi lah ban treikam hapoh jong uno uno u cell da kaba shu click ha uto u cell da u cursor.
+
| | Hadien ba ngi la dep pule kumno ban thoh ia ki jingthoh, nombar bad tarik ha ka Calc, mynta ngin pule kumno ban kdew bad ban phai ha kajuh ka spreadsheet na kawei ka cell sha kawei bad na kawei ka sheet sha kawei pat.
 +
 
 
|-
 
|-
|| 08:29
+
| 08:17
||Phin iohi ba kato kawei ka cell kan sa thaba.
+
| | Te ngin ia peit shwa mynta kumno ban kdew bad phai na kawei ka cell sha kawei pat ha ka spreadsheet.
 +
 
 
|-
 
|-
|| 08:32
+
| 08:23
|| Kawei pat ka rukom ban pyndonkam ia u cell ngi pyndonkam da ka cell kaba don ka jingiadei ne jingiasnoh bad kata cell kaba ngi pyndonkam lane Cell Reference.  
+
| | Phi lah ban treikam hapoh jong uno uno u cell da kaba shu click ha uto u cell da u cursor.
 +
 
 
|-
 
|-
|| 08:38
+
| 08:29
||Click ha u khnam barit bad ba iong sha kamon jong ka “Name Box”
+
| | Phin iohi ba kato kawei ka cell ka la shah pynthaba.
 +
 
 
|-
 
|-
|| 08:43
+
| 08:32
||Mynta type ka cell Reference jong ka cell sha kaba phi kwah ban phai bad sa press “Enter”
+
| | Kawei pat ka rukom ban pyndonkam ia u cell kadei da kaba ngi pyndonkam ia ka Cell Reference.
 +
 
 
|-
 
|-
|| 08:49
+
| 08:38
||Phi lah ruh ban click ha ka name box, pyndam noh ia ka Cell Reference ba lah don lypa bad sa type ia ka Cell reference ba phi kwah bad sa press enter
+
| | Click ha u khnam barit bad ba iong sha kamon jong ka “Name Box”
 +
 
 
|-
 
|-
|| 08:58
+
| 08:43
|| Mynta pat ngin pule kumno ban kdew bad phai na kawei cell sha kawei ha ka spreadsheet.
+
| | Mynta type ka cell Reference jong ka cell sha kaba phi kwah ban phai bad sa press “Enter”
 +
 
 
|-
 
|-
|| 09:03
+
| 08:49
||Ka rukom kaba nyngkong ban kdew bad phai na uwei u cell sha uwei ngi pyndonkam da u cursor.
+
| | Phi lah ruh ban click ha ka name box, pyndam noh ia ka Cell Reference ba la don lypa bad sa type ia ka Cell reference ba phi kwah bad sa nion enter
 +
 
 
|-
 
|-
||09:09
+
| 08:58
|| Ban buhdak da kaba pyndonkam da u cursor, ngi lah da kaba suk ban leh ia kane da kaba shu pyniaid ia u cursor sha ki cell kiba phi kwah ban duh dak bad sa click hangta da u button ba sha ka diang jong u mouse jong phi.
+
| | Mynta pat ngin pule kumno ban kdew bad phai na kawei cell sha kawei ha ka spreadsheet.
 +
 
 
|-
 
|-
|| 09:18
+
| 09:03
||Kane ka pynkylla ia ka rukom buhdak jong phi sha u cell uba thymmai.
+
| | Ka rukom kaba nyngkong ban kdew bad phai na uwei u cell sha uwei ka dei da kaba ngi pyndonkam da u cursor.
 +
 
 
|-
 
|-
|| 09:22
+
| 09:09
||Kane ka rukom ngi shait kham pyndonkam haba ki cells kiba ngi pyndonkam ki ia jngai uwei na uwei pat.
+
| | Ban buhdak da kaba pyndonkam da u cursor, ngi lah da kaba suk ban leh ia kane da kaba shu pyniaid ia u cursor sha ki cell kiba phi kwah ban buh dak bad sa click sha ka diang jong u mouse .
 +
 
 
|-
 
|-
|| 09:28
+
| 09:18
|| Sa kawei pat ka rukom ban phai na uwei u cell sha uwei ngi pyndonkam da u “Tab” key, ban iaid na uwei u cell sha uwei ha ka rukom pynkiang ne row.
+
| | Kane ka pynkylla ia ka rukom buhdak jong phi sha u cell uba thymmai.
 +
 
 
|-
 
|-
|| 09:35
+
| 09:22
||“Shift + Tab” ban phaidien sha u cell uba don hashwa ha ka row kaba hakmat.
+
| | Kane ka rukom ngi kham pyndonkam haba ki ar tylli ki cells kiba ngi pyndonkam ki ia jngai uwei na uwei pat.
 +
 
 
|-
 
|-
|| 09:39
+
| 09:28
||“Enter” ban iaid biang sha khmat jong uwei pat u cell ha kawei pat ka column.
+
| | Sa kawei pat ka rukom ban phai hapdeng uwei u cell sha uwei kadei u “Tab” key, ban iaid na uwei u cell sha uwei ha ka row.
 +
 
 
|-
 
|-
|| 09:42
+
| 09:35
||“Shift + Enter” ban phaidien sha u cell uba don hashwa ha ka column.
+
| | “Shift + Tab” ban phaidien sha u cell uba don hashwa ha ka row kaba hakmat.
 +
 
 
|-
 
|-
|| 09:46
+
| 09:39
|| Mynta pat ngin pule kumno ban phai na kawei ka spreadsheets sha kawei ha ka Calc da kaba pyndonkam da ka keyboard.
+
| | “Enter” ban iaid biang sha khmat jong uwei pat u cell ha kawei pat ka column.
 +
 
 
|-
 
|-
|| 09:53
+
| 09:42
|| Ban ioh rung pyndonkam ha kawei pat ka sheet sha kamon jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Down” key ha kajuh kapor.
+
| | “Shift + Enter” ban phaidien sha u cell uba don hashwa ha ka column.
 +
 
 
|-
 
|-
|| 10:00
+
| 09:46
||Ban ioh rung pyndonkam ha kawei pat ka sheet sha kadiang jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Up” key ha kajuh kapor.
+
| | Mynta pat ngin pule kumno ban phai na kawei ka spreadsheets sha kawei ha ka Calc da kaba pyndonkam da ka keyboard.
 +
 
 
|-
 
|-
|| 10:08
+
| 09:53
|| Phi lah ruh ban phai na kawei ka sheet sha kawei pat da kaba pyndonkam da u cursor.
+
| | Ban ioh rung pyndonkam sha kawei pat ka sheet sha kamon jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Down” key ha kajuh kapor.
 +
 
 
|-
 
|-
|| 10:13
+
| 10:00
||Ka jingbatai ka kham bniah kadon ha ka tutorial kaba iadei bad ka “Working with Sheets”.
+
| | Ban ioh rung pyndonkam ha kawei pat ka sheet sha kadiang jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Up” key ha kajuh kapor.
 +
 
 
|-
 
|-
|| 10:19
+
| 10:08
|| Lada phi don bun ki sheets palat ia ka lai tylli, kiwei kin nym lah ban paw hynrei kidon bad rieh hapoh u scrool bar ba thiah hapoh jong ka screen.
+
| | Phi lah ruh ban phai na kawei ka sheet sha kawei pat da kaba pyndonkam da u cursor.
 +
 
 
|-
 
|-
|| 10:28
+
| 10:13
||Lada kane ka long kumta, te ki 4tylli ki buton hapoh bad sha kadiang jong ka sheet tab lah ban pyndonkam ban peit ia ki sheet kiba rieh.
+
| | Ka jingbatai ka kham bniah kadon ha ka jinghikai kaba iadei bad ka “Working with Sheets”.
 +
 
 
|-
 
|-
|| 10:36
+
| 10:19
||To mynta ngin phai dien ia kaei kaba ngi lah dep pynkylla.
+
| | Lada phi don buntylli ki sheet ,te ki katto katne ki sheet ki lah ban rieh hapoh u scrool bar ba thiah hapoh jong ka screen.
 +
 
 
|-
 
|-
||10:39
+
| 10:28
|| Ban jied ia ki cell ha ka rukom kaba bteng pynieng bad pynkiang, ngin click shwa nyngkong ha uwei u cell.
+
| | Lada kane ka long kumta, te ki 4tylli ki buton ba don shatrai na kadiang jong ka sheet tab ki lah ban pynkynriah ia ki tab sha kaban iohi.
 +
 
 
|-
 
|-
|| 10:45
+
| 10:36
||Nangta press bad tan sharum ia u button kadiang jong u mouse.
+
| | To mynta ngin phai dien ia kaei kaba ngi la dep pynkylla.
 +
 
 
|-
 
|-
|| 10:48
+
| 10:39
||Pyniaid ia u cursor ha ka screen bad ynda phi lah ioh katkum ka jingkwah jong phi, pyllait noh ia u button kadiang jong u mouse. Mynta phin iohi ba kito ki cells ba phi jied ki lah thaba.
+
| | Ban jied ia ki cell ha ka rukom kaba bteng pynieng bad pynkiang bad u cursor, ngin click shwa nyngkong ha uwei u cell.
 +
 
 
|-
 
|-
|| 11:00
+
| 10:45
|| Mynta kumno ban jied ki columns bad ki rows ha kajuh ka bynta bad ialong kawei, ngi click ha ka column lane row kaba nyngkong ha ka group.
+
| | Nangta nion bad tan sharum ia u button na kadiang jong u mouse.
 +
 
 
|-
 
|-
|| 11:09
+
| 10:48
||Nangta nion ia u “Shift” key.
+
| | Pyniaid ia u cursor ha ka screen bad ynda ki la thaba ki cell katkum ka jingkwah jong phi, pyllait noh ia u button kadiang jong u mouse. Mynta phi iohi ba kito ki cells ba phi jied ki la thaba.
 +
 
 
|-
 
|-
|| 11:12
+
| 11:00
||klik ia ka column ne row kaba khatduh ha ka group.
+
| | Na ka bynta ban jied ia kiba bun ki columns bad ki rows ha kajuh ka bynta bad ialong kawei, ngi click ha ka column lane row kaba nyngkong ha ka group.
 +
 
 
|-
 
|-
|| 11:15
+
| 11:09
||Ban jied ia ki columns bad ki rows kiba iaphiah, click ha ka column lane row kaba nyngkong ha ka group.
+
| | Nangta nion ia u “Shift” key.
 +
 
 
|-
 
|-
|| 11:23
+
| 11:12
||Nion bad wat pyllait ia u “Control” Key bad sa click ha baroh ki column ki row ba iaphiah.
+
| | klik ia ka column ne row kaba khatduh ha ka group.
 +
 
 
|-
 
|-
|| 11:31
+
| 11:15
|| Ban jied ia ar ne palat ia ar tylli ki sheets ban ialong kawei, click ha u sheet tab uba nyngkong uba kham donkam napdeng jong ki.
+
| | Ban jied khambun ia ki columns bad ki rows kiba iaphiah, click ha ka column lane row kaba nyngkong ha ka group.
 +
 
 
|-
 
|-
|| 11:39
+
| 11:23
||Nangta iaid shadien duh jong u sheet tab uba phi pyndonkam.  
+
| | Bat sah ia u “Control” Key bad sa click ha baroh ki column ki row ba iaphiah .
 +
 
 
|-
 
|-
|| 11:43
+
| 11:31
||Nion ia u “Shift” key bad sa click ha u sheet tab.
+
| | Ban jied ia ar ne palat ia ar tylli ki sheets ban ialong kawei, click ha ka sheet tab kaba nyngkong kaba kham donkam napdeng jong ki.
 +
 
 
|-
 
|-
|| 11:48
+
| 11:39
|| Baroh ki tab kiba hap hapdeng jong kito ki sheet tab kiba phi click ki kylla lieh bad thaba kaba mut ba kito baroh ki sheets ngi lah jied kyllum lang kawei.  
+
| | Nangta buh ia u cursor halor ka sheet tab kaba phin buh hadien.
 +
 
 
|-
 
|-
|| 11:56
+
| 11:43
||Mynta kiei kiei baroh ba phi treikam ha kawei ka sheets ka lah trei lang ruh ha baroh kiwei pat.  
+
| | Nion ia u “Shift” key bad sa click ha u sheet tab.
 +
 
 
|-
 
|-
|| 12:01
+
| 11:48
|| Ban jied ia ki sheets kiba ia phiah, click ha u sheet tab uba nyngkong.
+
| | Baroh ki tab kiba hap hapdeng jong kine ki sheet kin kylla lieh bad thaba kaba pyni ba baroh ki la shah jied.
 +
 
 
|-
 
|-
|| 12:08
+
| 11:56
||Nangta pyniaid ia u cursor ha u sheet tab uba lai.  
+
| | Kino kino ki jingpynkylla kiba phi la pynkylla mynta kan ktah ia baroh ki sheet kiba thaba.
 +
 
 
|-
 
|-
|| 12:12
+
| 12:01
||Nion ia u “Control” key bad sa click.
+
| | Ban jied ia ki katto katne ki sheets kiba ia phiah, click ha u sheet tab na ka bynta ka sheet nyngkong .  
 +
 
 
|-
 
|-
|| 12:16
+
| 12:08
||Mynta ki sheets kiba phi lah jied ki lah kylla lieh bad kiei kiei baroh ba phi treikam ne leh kan ktah lang ia baroh kiwei pat ki sheets kiba thaba.
+
| | Nangta pyniaid ia u cursor ha ka sheet tab kaba lai.
|-
+
 
|| 12:24
+
|| Mynta ngi lah poi sha kaba kut ha kane ka Spoken Tutorial on LibreOffice Calc.
+
 
|-
 
|-
|| 12:30
+
| 12:12
||Kum ban shu pynkynmaw iaphi, ngi la dep pule shaphang :
+
| | Bat ia u “Control” key bad sa click ha ka sheet tab
 +
 
 
|-
 
|-
|| 12:33
+
| 12:16
||Kumno ban thep iaki nombar, ki jingthoh, ki nombar kumka jingthoh, ka tarik bad kapor ha ka calc.
+
| | Mynta ki sheets kiba phi la jied ki la kylla lieh bad kino kino ki kam kiba phi pynkylla ne leh kan ktah lang ia baroh kiwei pat ki sheets kiba thaba.
 +
 
 
|-
 
|-
|| 12:40
+
| 12:24
||Kumno ban pyndonkam iaka Format cells dialog box
+
| | Mynta ngi la poi sha kaba kut ha kane ka Spoken Tutorial on LibreOffice Calc.
 +
 
 
|-
 
|-
|| 12:43
+
| 12:30
||Kumno ban kdew bad phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
+
| | Ba batai kyllum, ngi la dep pule shaphang :
 +
 
 
|-
 
|-
|| 12:47
+
| 12:33
||Kumno ban jied iaki item ha ki rows, columns bad sheets.
+
| | Kumno ban thep iaki nombar, ki jingthoh, ki nombar kumka jingthoh, ka tarik bad kapor ha ka calc.
 +
 
 
|-
 
|-
|| 12:52
+
| 12:40
|| COMPREHENSIVE ASSIGNMENT
+
| | Kumno ban pyndonkam iaka Format cells dialog box
 +
 
 
|-
 
|-
|| 12:55
+
| 12:43
||Plie ia ka “Spreadsheet Practice.ods”
+
| | Kumno ban kdew bad phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
 +
 
 
|-
 
|-
|| 12:58
+
| 12:47
||Hapoh jong “Serial Numbers” type ki nombar naduh 1 haduh 5 uwei hapoh jong uwei pat.
+
| | Kumno ban jied iaki item ha ki rows, columns bad sheets.
 +
 
 
|-
 
|-
|| 13:04
+
| 12:52
||Kumno ban phai na uwei u cell sha uwei da kaba pyndonkam ia ki keys.
+
| | COMPREHENSIVE ASSIGNMENT
 +
 
 
|-
 
|-
|| 13:09
+
| 12:55
||Jied ia baroh ki items hapoh jong serial number.
+
| | Plie ia ka “Spreadsheet Practice.ods”
 +
 
 
|-
 
|-
|| 13:13
+
| 12:58
||Pyndap sa kawei ka column na ka bynta ka Date and Time.  
+
| | Hapoh jong “Serial Numbers” type ki nombar naduh 1 haduh 5 uwei hapoh jong uwei pat.
 +
 
 
|-
 
|-
|| 13:16
+
| 13:04
||Pyndap katto katne ki nombar da kaba pyndonkam da ka Format Cells dialog box opshon.
+
| | Kumno ban phai na uwei u cell sha uwei da kaba pyndonkam ia ki keys.
 +
 
 
|-
 
|-
|| 13:21
+
| 13:09
||* Peit iaka video kaba don ha ka link ba lah ai harum
+
| | Jied ia baroh ki items hapoh jong serial number.
 +
 
 
|-
 
|-
|| 13:24
+
| 13:13
||* Kane ka kyllum lang iaka Projek jongka Spoken Tutorial
+
| | Pyndap sa kawei ka column na ka bynta ka Date and Time.
 +
 
 
|-
 
|-
|| 13:27
+
| 13:16
||*Lada phim don ka jingstet jongka rukom phah bad iohpdiang iaki webpage lyngba ka internet kaba biang jong phi, phi dang iai lah hi ban download bad ban peit iaka.
+
| | Pyndap katto katne ki nombar da kaba pyndonkam da ka Format Cells dialog box opshon.
  
 
|-
 
|-
|| 13:32
+
| 13:21
||Ka kynhun jongka Spoken Tutorial
+
| | <nowiki>* Peit iaka video kaba don ha ka link ba la ai harum</nowiki>
 +
 
 
|-
 
|-
|| 13:35
+
| 13:24
||*Ka pyniaid iaki workshop da kaba pyndonkam iaki spoken tutorial
+
| | <nowiki>* Kane ka batai kyllum lang iaka Projek jongka Spoken Tutorial</nowiki>
 +
 
 
|-
 
|-
|| 13:38
+
| 13:27
||*Ka ai sertiphikate sha kito kiba pass ha ka online test
+
| | <nowiki>*Lada phim don ka bandwidth kaba biang phi lah ban shu download bad peit ia ka hadien</nowiki>
 +
 
 
|-
 
|-
|| 13:41
+
| 13:32
||*Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka kontak ha ka spoken hiphen tutorial dor org
+
| | Ka kynhun jongka Spoken Tutorial
 +
 
 
|-
 
|-
|| 13:48
+
| 13:35
||*Spoken Tutorial kadei ka bynta jongka project Talk To A Teacher.
+
| | <nowiki>*Ka pyniaid iaki workshop da kaba pyndonkam iaki spoken tutorial</nowiki>
 +
 
 
|-
 
|-
|| 13:52
+
| 13:38
||*Ia kane la kyrshan da ka National Mission on Education lyngba ICT, MHRD, Sorkar India.
+
| | <nowiki>*Ka ai sertiphikate sha kito kiba pass ha ka online test</nowiki>
 +
 
 
|-
 
|-
|| 14:00
+
| 13:41
||*Ki jingtip ba kham bniah ha kane ka Mission ki don ha
+
| | <nowiki>*Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka </nowiki>[mailto:contact@spoken-tutorial.org contact@spoken-tutorial.org]
 +
 
 
|-
 
|-
|| 14:03
+
| 13:48
||*spoken hyphen tutorial dot org slash NMEICT hyphen Intro
+
| | <nowiki>*Spoken Tutorial kadei ka bynta jongka project Talk To A Teacher.</nowiki>
 +
 
 
|-
 
|-
|| 14:11
+
| 13:52
||* Ia kane ka turorial la pynkylla sha ka ktien Khasi da I Meboreen Mary Thongni. Bad nga dei I Pdiangburom Nongrum.  
+
| | <nowiki>*Ia kane la kyrshan da ka National Mission on Education lyngba ICT, MHRD, Sorkar India.</nowiki>
 +
 
 
|-
 
|-
|| 14:16
+
| 14:00
||*Khublei Shibun iaka jing ia snohkti jong phi.
+
| | <nowiki>*Ki jingtip ba kham bniah halor kane ka Mission ki don ha</nowiki>
 +
 
 
|-
 
|-
 +
| 14:03
 +
| | <nowiki>*spoken hyphen tutorial dot org slash NMEICT hyphen Intro</nowiki>
 +
 +
|-
 +
| 14:11
 +
| | <nowiki>* Ia kane ka turorial la pynkylla sha ka ktien Khasi da I Meboreen Mary Thongni. </nowiki>
 +
 +
|-
 +
| 14:16
 +
| | <nowiki>*Khublei Shibun iaka jing ia snohkti jong phi.</nowiki>
 +
 
|}
 
|}

Revision as of 15:27, 29 December 2016


Time Narration
00:00 Khublei ngi pdiang sngewbha iaphi sha ka Spoken tutorial halor ka LibreOffice Calc ha kaba iadei bad ka rukom pyndonkam iaki cells.
00:06 Ha kane kajinghikai ngin pule shaphang:
00:08 Kumno ban pynrung iaki nombar, ki jingthoh, ki nombar kum ka jingthoh, ka tarik bad kapor ha ka spreadsheet.
00:16 Kumno ban pyndonkam iaka Format cells dialog box
00:19 Kumno ban kdew ban phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
00:23 Kumno ban jied iaki item ha ki rows, columns bad sheets.
00:29 Hangne ngin pyndonkam da ka Ubuntu 10.04 kum ka Operating system bad LibreOffice Suite version 3.3.4.
00:39 Te to mynta ngin sdang ban pule kumno ban pynrung iaki data ha ki cells.
00:43 Ngin plié iaka Personal finance tracker.ods
00:49 Phi lah ban type kino kino ki jingthoh ha kawei ka cell da kaba click ha kato ka cell nangta sa type da kaba pyndonkam da ka keyboard.
00:59 Ki jingthoh ki la shah pynryntih sha kadiang. Phi lah ban pynkylla iaka jaka jong ka da kaba click ha uno uno u Alignment tabs ha u Formatting Bar.
01:08 To ngin phaidien biang kumba kalong nyngkong.
01:11 Mynta click ha u cell uba pyni A1 ha ka spreadsheet.
01:15 Phi iohi hangne ba ka cell ba phi kdew ka la thaba.
01:20 Hangne ngi lah dep type lypa iaka heading jong ka column.
01:24 Hapoh ka heading, “Items” ngin type kato katne kiwei pat ki items hapoh jong ka kum “Salary”, “House rent”, “Electricity bill”, “Phone bill”, “Laundry” and “Miscellaneous”.
01:38 Ban ioh ban pynrung iaki nombar ha ka cell, klik ha ka cell bad type iaki nombar
01:43 Ban pynrung ia u negatib nombar, phi lah ban buh da u dak minos hashwa jong u ne phi lah ban buh ia u hapdeng ki braket.
01:53 Kum ka rukom, ki nombar la pynryntih sha kamon, bad ki negatib nombar ki bud hadien u dak minos.
02:01 To ngin phaidien biang ia baroh ki jingpynkylla.
02:04 Mynta hapoh u heading Serial Number, ba la thoh “SN” ha ka spreadsheet “personal finance tracker.ods”jong ngi , ngi kwah ba u serial nombar jong uwei pa uwei u item ban un long hapoh jong uwei pat.
02:17 Te klik ha ka cell ba iahap bad “A2” bad pynrung iaki nombar kum 1, 2,3 uwei hapoh jong uwei pat.
02:27 Khnang ban pyndap iaki serial nombar ha ka rukom automatic, klik ha ka cell ”A4”. Kawei ka box barit balong rong iong ha kaliang kamon sha ka bynta ba shapoh ka paw. Tan iaka cell haduh “A7” bad sa pyllait noh ia u buton jong u mouse.
02:42 Phin sa iohi ba ki cell “A5” haduh”A7” kin sa dap da ki serial nombar.
02:51 Hadien ba phi la dep pynrung iaki serial nombar jongki item, mynta ngin pynrung ia kador jong kawei pa kawei ka item hapoh ka heading” cost”
02:59 Te ngi klik ha ka cell ba la ai kyrteng “C3” bad type ia ka dor jinglut na ka bynta “ House rent ” kum “Rupees 6000”
03:07 Mynta, kan jia aiu lada ngi kwah ban thoh ha shwa jong u nombar da u dak na bynta pisa.
03:11 Shubuh, ngi kwah ban pynrung ”Rupees 800” na ka bynta “Electricity bill”. Te, klik ha kaliang kamon jong u mouse bad nangta klik ha u opshon ”Format Cells”
03:23 Kane kan sa plie iaka “Format Cells” dialog box.
03:27 U tab ba nyngkong u dei “Numbers”. Te klik hangta lada ym pat dep select iaka.
03:32 Shibun kiwei pat ki bynta phi lah ban iohi hapoh “Category” kum Number, Percent, Currency, Date, Time bad sa kiwei pat.
03:41 To ngin jied Currency.
03:44 Mynta hapoh jong u Format opshon, klik ha u khnam ba shapoh. Kane kan sa plie ia shibun ki dak symbol jongki pisa kylleng ka pyrthei.
03:53 To ngin scroll shajrong bad jied INR Rupees English India. Ka Rupee 1,234 ba lah dep jied lypa kan sa paw ha ka drop down ba shapoh.
04:04 Phi lah ban iohi ia ka rukom long jong ka ha ka bynta ba sha kaliang kamon.
04:10 Hapoh Options, ngi don ia u opshon ban pynrung ia u nombar jongki Desimal bad ki nombar jongki zero ki ban bud hadien jong u katkum ka jingkwah jong ngi.
04:20 Peit bha katba ngi nang pynbun iaki zero, ka bynta hapoh ka Format ka la kylla sha Rupees 1,234 desimal zero zero kaba pyni ba don artylli ki jaka decimal.
04:35 Phin shem iaki jingpynkylla ha ka jaka ba la pyni.
04:40 Klik ha Thousands Separator ban ioh ban pynsnoh da u ”comma” ha man ka thousand. Sa shisien phin shem ia ki jingkylla ha ka jaka ba la pyni.
04:50 Lah ruh ban pynkylla iaki font style da kaba klik ha u Font tab. U don shibun ki opshon na bynta Font, Typeface bad ka Size.
05:00 Peit bad khmih ia Ki Font Effects bad kiwei pat ki tab ban tip bha shaphang jongki.
05:05 Ngin sa pule shaphang ki opshon ha Alignment tab ha kawei pat ka jinghikai.
05:11 To ngin iaklik ha OK.
05:15 To ngin type 800 bad nion Enter. Phin sa iohi ba u nombar 800 un sa paw kum Rupees 800 bad 2 tylli ki decimal.
05:26 Mynta to ngin jied iaki cell C5 haduh C7. Nion ia u CTRL key bad sa jied iaka cell G2 ruh. Phin sa iohi ba baroh ki cell ki lah thaba.
05:39 Klik ha u mouse na kamon ha kano kano ka cell ba thaba bad jied Format Cells.
05:46 Jied iaki juh ki opshon kumba ha shwa. Klik ha OK.
05:51 Mynta ngi thoh iaki jinglut jong kiwei pat ki items kawei hapoh jong kawei pat kum “Rupees 600” na bynta ka “Phone bill”, ”Rupees 300” na bynta ki jinglut ha “Laundry” bad “Rupees 2000”kum kita kiwei pat ki jinglut ne “Miscellaneous”
06:06 Hapoh ka heading “Accounts” ngi type iaka salary na ka bynta kato ka bnai kum “Rupees 30000”
06:13 Ban pynrung iaka tarik ha Calc, jied iaka cell bad type iaka tarik.
06:18 Phi lah ruh ban phiah iaki bynta jongki tarik da kaba thoh ia u forward slash ne u hyphen ne phi lah ban thoh kum 10 October 2011.
06:27 Ka Calc kalah ban ithuh ia shibun tylli ki rukom thoh tarik.
06:32 Ha kawei pat ka rukom, klik na kamon ha ka cell bad jied ia u opshon “Format Cells”
06:38 Hapoh kato ka bynta jied “Date” bad ka format ba phi kwah hapoh “Format”. Ngin jied 12,31,1999. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
06:51 Ka Format code ka paw hapoh kum MM, DD bad YYYY. Lah ban jied iaka Format code katkum ka jingkwah jong phi.
07:02 Ngan type DD,MM bad YYYY. Phi lah ban iohi iaki jingpynkylla ha ka jaka preview. Klik OK.
07:12 Ban pynrung iaka por ha Calc, Jied iaka cell bad type iaka por.
07:18 Phi lah ban phiah iaki bynta jong kapor da kaba buh iaki colon kum 10 colon 43 colon 20.
07:24 Ha kawei pat ka rukom, klik na kamon ha ka cell bad jied ia u opshon “Format Cells”
07:31 Hapoh kato ka bynta jied “Time” bad ka format ba phi kwah hapoh “Format”. Ngin jied 13,37,46. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
07:43 Ka Format code ka paw hapoh kum HH:MM: SS. Lah ban jied iaka Format code katkum ka jingkwah jong phi. Ngan type HH:MM
07:57 Phi lah ban iohi iaki jingpynkylla ha ka jaka preview. Klik OK.
08:03 To ngin phaidien biang ia baroh ki jingpynkylla.
08:06 Hadien ba ngi la dep pule kumno ban thoh ia ki jingthoh, nombar bad tarik ha ka Calc, mynta ngin pule kumno ban kdew bad ban phai ha kajuh ka spreadsheet na kawei ka cell sha kawei bad na kawei ka sheet sha kawei pat.
08:17 Te ngin ia peit shwa mynta kumno ban kdew bad phai na kawei ka cell sha kawei pat ha ka spreadsheet.
08:23 Phi lah ban treikam hapoh jong uno uno u cell da kaba shu click ha uto u cell da u cursor.
08:29 Phin iohi ba kato kawei ka cell ka la shah pynthaba.
08:32 Kawei pat ka rukom ban pyndonkam ia u cell kadei da kaba ngi pyndonkam ia ka Cell Reference.
08:38 Click ha u khnam barit bad ba iong sha kamon jong ka “Name Box”
08:43 Mynta type ka cell Reference jong ka cell sha kaba phi kwah ban phai bad sa press “Enter”
08:49 Phi lah ruh ban click ha ka name box, pyndam noh ia ka Cell Reference ba la don lypa bad sa type ia ka Cell reference ba phi kwah bad sa nion enter
08:58 Mynta pat ngin pule kumno ban kdew bad phai na kawei cell sha kawei ha ka spreadsheet.
09:03 Ka rukom kaba nyngkong ban kdew bad phai na uwei u cell sha uwei ka dei da kaba ngi pyndonkam da u cursor.
09:09 Ban buhdak da kaba pyndonkam da u cursor, ngi lah da kaba suk ban leh ia kane da kaba shu pyniaid ia u cursor sha ki cell kiba phi kwah ban buh dak bad sa click sha ka diang jong u mouse .
09:18 Kane ka pynkylla ia ka rukom buhdak jong phi sha u cell uba thymmai.
09:22 Kane ka rukom ngi kham pyndonkam haba ki ar tylli ki cells kiba ngi pyndonkam ki ia jngai uwei na uwei pat.
09:28 Sa kawei pat ka rukom ban phai hapdeng uwei u cell sha uwei kadei u “Tab” key, ban iaid na uwei u cell sha uwei ha ka row.
09:35 “Shift + Tab” ban phaidien sha u cell uba don hashwa ha ka row kaba hakmat.
09:39 “Enter” ban iaid biang sha khmat jong uwei pat u cell ha kawei pat ka column.
09:42 “Shift + Enter” ban phaidien sha u cell uba don hashwa ha ka column.
09:46 Mynta pat ngin pule kumno ban phai na kawei ka spreadsheets sha kawei ha ka Calc da kaba pyndonkam da ka keyboard.
09:53 Ban ioh rung pyndonkam sha kawei pat ka sheet sha kamon jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Down” key ha kajuh kapor.
10:00 Ban ioh rung pyndonkam ha kawei pat ka sheet sha kadiang jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Up” key ha kajuh kapor.
10:08 Phi lah ruh ban phai na kawei ka sheet sha kawei pat da kaba pyndonkam da u cursor.
10:13 Ka jingbatai ka kham bniah kadon ha ka jinghikai kaba iadei bad ka “Working with Sheets”.
10:19 Lada phi don buntylli ki sheet ,te ki katto katne ki sheet ki lah ban rieh hapoh u scrool bar ba thiah hapoh jong ka screen.
10:28 Lada kane ka long kumta, te ki 4tylli ki buton ba don shatrai na kadiang jong ka sheet tab ki lah ban pynkynriah ia ki tab sha kaban iohi.
10:36 To mynta ngin phai dien ia kaei kaba ngi la dep pynkylla.
10:39 Ban jied ia ki cell ha ka rukom kaba bteng pynieng bad pynkiang bad u cursor, ngin click shwa nyngkong ha uwei u cell.
10:45 Nangta nion bad tan sharum ia u button na kadiang jong u mouse.
10:48 Pyniaid ia u cursor ha ka screen bad ynda ki la thaba ki cell katkum ka jingkwah jong phi, pyllait noh ia u button kadiang jong u mouse. Mynta phi iohi ba kito ki cells ba phi jied ki la thaba.
11:00 Na ka bynta ban jied ia kiba bun ki columns bad ki rows ha kajuh ka bynta bad ialong kawei, ngi click ha ka column lane row kaba nyngkong ha ka group.
11:09 Nangta nion ia u “Shift” key.
11:12 klik ia ka column ne row kaba khatduh ha ka group.
11:15 Ban jied khambun ia ki columns bad ki rows kiba iaphiah, click ha ka column lane row kaba nyngkong ha ka group.
11:23 Bat sah ia u “Control” Key bad sa click ha baroh ki column ki row ba iaphiah .
11:31 Ban jied ia ar ne palat ia ar tylli ki sheets ban ialong kawei, click ha ka sheet tab kaba nyngkong kaba kham donkam napdeng jong ki.
11:39 Nangta buh ia u cursor halor ka sheet tab kaba phin buh hadien.
11:43 Nion ia u “Shift” key bad sa click ha u sheet tab.
11:48 Baroh ki tab kiba hap hapdeng jong kine ki sheet kin kylla lieh bad thaba kaba pyni ba baroh ki la shah jied.
11:56 Kino kino ki jingpynkylla kiba phi la pynkylla mynta kan ktah ia baroh ki sheet kiba thaba.
12:01 Ban jied ia ki katto katne ki sheets kiba ia phiah, click ha u sheet tab na ka bynta ka sheet nyngkong .
12:08 Nangta pyniaid ia u cursor ha ka sheet tab kaba lai.
12:12 Bat ia u “Control” key bad sa click ha ka sheet tab
12:16 Mynta ki sheets kiba phi la jied ki la kylla lieh bad kino kino ki kam kiba phi pynkylla ne leh kan ktah lang ia baroh kiwei pat ki sheets kiba thaba.
12:24 Mynta ngi la poi sha kaba kut ha kane ka Spoken Tutorial on LibreOffice Calc.
12:30 Ba batai kyllum, ngi la dep pule shaphang :
12:33 Kumno ban thep iaki nombar, ki jingthoh, ki nombar kumka jingthoh, ka tarik bad kapor ha ka calc.
12:40 Kumno ban pyndonkam iaka Format cells dialog box
12:43 Kumno ban kdew bad phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
12:47 Kumno ban jied iaki item ha ki rows, columns bad sheets.
12:52 COMPREHENSIVE ASSIGNMENT
12:55 Plie ia ka “Spreadsheet Practice.ods”
12:58 Hapoh jong “Serial Numbers” type ki nombar naduh 1 haduh 5 uwei hapoh jong uwei pat.
13:04 Kumno ban phai na uwei u cell sha uwei da kaba pyndonkam ia ki keys.
13:09 Jied ia baroh ki items hapoh jong serial number.
13:13 Pyndap sa kawei ka column na ka bynta ka Date and Time.
13:16 Pyndap katto katne ki nombar da kaba pyndonkam da ka Format Cells dialog box opshon.
13:21 * Peit iaka video kaba don ha ka link ba la ai harum
13:24 * Kane ka batai kyllum lang iaka Projek jongka Spoken Tutorial
13:27 *Lada phim don ka bandwidth kaba biang phi lah ban shu download bad peit ia ka hadien
13:32 Ka kynhun jongka Spoken Tutorial
13:35 *Ka pyniaid iaki workshop da kaba pyndonkam iaki spoken tutorial
13:38 *Ka ai sertiphikate sha kito kiba pass ha ka online test
13:41 *Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka contact@spoken-tutorial.org
13:48 *Spoken Tutorial kadei ka bynta jongka project Talk To A Teacher.
13:52 *Ia kane la kyrshan da ka National Mission on Education lyngba ICT, MHRD, Sorkar India.
14:00 *Ki jingtip ba kham bniah halor kane ka Mission ki don ha
14:03 *spoken hyphen tutorial dot org slash NMEICT hyphen Intro
14:11 * Ia kane ka turorial la pynkylla sha ka ktien Khasi da I Meboreen Mary Thongni.
14:16 *Khublei Shibun iaka jing ia snohkti jong phi.

Contributors and Content Editors

Devraj, Meboreen Mary, PoojaMoolya