LibreOffice-Suite-Calc/C2/Working-with-Cells/Khasi

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 ba kan pyndap hi iaki serial nombar, klik ha ka cell ”A4”. Ka box barit ba iong sha trai na kamon sha kyndong jong ki cell ka la mih. Tan iaka haduh ka cell “A7” bad sa pyllait noh ia u mouse button.
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 mailto: 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