PoojaMoolya at 06:47, 18 April 2017

2017-04-18T06:47:13Z

Meboreen Mary: Created page with " {| Border = 1 ! Time ! Narration |- | 00:00 | Ngi Pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''Linking in Calc'''- ha '..."

2017-02-16T05:50:16Z

Created page with " {| Border = 1 ! <center>Time</center> ! <center>Narration</center> |- | 00:00 | Ngi Pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''Linking in Calc'''- ha '..."

New page

{| Border = 1
! <center>Time</center>
! <center>Narration</center>

|-
| 00:00
| Ngi Pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''Linking in Calc'''- ha '''LibreOffice Calc'''.

|-
| 00:06
| Ha kane ka jinghikai, ngin pule shaphang

|-
| 00:10
| Kumno ban reference ia kiwei ki sheets ha calc

|-
| 00:13
| Kumno ban pyndonkam ia ki hyperlink ha calc

|-
| 00:17
| Hangne ngi pyndonkam da ka '''Ubuntu Linux''' bershon '''10.04''' kum ka  '''operating system''' bad ka '''LibreOffice Suite''' bershon '''3.3.4'''.

|-
| 00:29
| LibreOfficeCalc ka ai lad ia phi ban reference

|-
| 00:033
| Ia ka cell jong kawei pat ka sheet sha ka cell jong ka current sheet

|-
| 00:37
| Ka cell na kawei ka spreadsheet, lada phi la dep save baroh artylli ki spreadsheet

|-
| 00:44
| To ngin plie ia ka file “Personal-Finance-Tracker.ods”.

|-
| 00:49
| Ka sheet 1 jong ka file jong ngi ka don ka spreadsheet na ka bynta “Personal Finance Tracker”.

|-
| 00:55
| Nga lah kynthup katto katne ki dor ha ki kolum “Spent” bad “Received”.

|-
| 01:04
| Mynta, to wad ia ka ka sum total jong ki bynta hapoh ka “Cost” and “Spent”

|-
| 01:11
| Nion ha ka cell ba kyrteng C9 bad pyndap ia ka formula : '''is equal to SUM''' bad hapoh braces '''C3 colon C7'''.

|-
| 01:24
| Nangta sa nion ia u Enter Key.

|-
| 01:27
| Nion ha ka cell ba kyrteng D9 bad da kaba pyndonkam ia ka juh ka formula sa wad ia ka total.

|-
| 01:36
| Mynta ngin pyni ia ka total balance hapoh ka “Cost” bad “Spent” ha kawei pat ka sheet da kaba pyndonkam ia ka '''cell referencing'''.

|-
| 01:45
| To ngin nion ha ka tab “Sheet 2”

|-
| 01:48
| Kane ka plie ia ka Sheet bathymmai.

|-
| 01:51
| Mynta , nion ha ka cell ba kyrteng A1 bad type ia ka heading “COMPONENT"hapoh jong ka.

|-
| 02:00
| Nion ha ka cell ba kyrteng B1 bad type ia ka heading “BALANCE” hapoh jong ka.

|-
| 02:07
| Mynta , to ngin pyndap ia ki kyrteng jong ki bynta hapoh ka heading.

|-
| 02:12
| Nion ha ka cell ba kyrteng A3 bad type “COST”. Nion '''Enter'''.

|-
| 02:19
| Hapoh “COST”, to ngin pyndap ia ka bynta ba bud kum “SPENT” ha ka cell ba kyrteng A4

|-
| 02:27
| Mynta , nion ha ka cell ba thylli kata B3.

|-
| 02:31
| Ki cell B3 bad B4 kin don ia ka total balance hapoh ka heading “COST” bad “SPENT”

|-
| 02:38
| Kaba ngi la dep khein ha “Sheet 1”.

|-
| 02:41
| Kane kan sa treikam da ka '''referencing'''.

|-
| 02:44
| Ban pynlong ia ka cell reference ha ka cel B3, nion ha '''equal to''' sign kaba don marbud jong ka '''Input line'''

|-
| 02:53
| Mynta, hapoh ka Sheet tab nion ha '''“Sheet 1”'''.

|-
| 02:59
| Ha kane ka sheet, ngin nion ha ka cell C9 kaba don ia ka total hapoh jong ka kolum “COST”

|-
| 03:07
| Peit ba ha ka '''“Input line”''', la pyni ia ka jingthoh “Sheet 1 dot C9”

|-
| 03:15
| Mynta, nion ha ka '''check mark''' kaba don marbud bad ka '''“Input line”'''.

|-
| 03:20
| Peit ba ka grandtotal jong ka data hapoh ka “Cost” ha ka tab “Sheet 1” ka la rung hi ha ka cell ba kyrteng B3 ha ka tab “Sheet 2”

|-
| 03:34
| Ha kajuh ka rukom, ngi lah ban pynrung ia ki grand totals jong kiwei ki bynta lyngba ka '''referencing'''.

|-
| 03:41
| Ka Referencing ka long kaba iarap shibun ban kyllum lang ia ki data lada don bun tylli ki sheet ryngkat bad ki jingthoh ba bun.

|-
| 03:49
| Mynta , to ngin pule kumno ban shna ia ki Hyperlinks ha '''Calc Sheets'''

|-
| 03:55
| Phi lah ban pyndonkam Hyperlinks ban leit sha kawei ka jaka hapoh ka Spreadsheet , Sha kiwei ki files lane sha ki websites ruh .

|-
| 04:06
| Ha ka “Personal-Finance-Tracker.ods”, ka personal finance tracker kadon ha “sheet 1” bad kiwei pat ki jingthoh kidon ha “Sheet 2”

|-
| 04:17
| To shu ong ngi kwah ban leit na Sheet 1 sha Sheet2

|-
| 04:22
| Nyngkong , nion ka tab “Sheet 1”

|-
| 04:25
| Hangne, to ngin nion ha ka cell ba kyrteng B14 bad pyndap “Sheet 2”

|-
| 04:33
| Phi iohi ba ka kyrteng “Sheet 2” la pyni ha ka '''Input line'''.

|-
| 04:38
| Mynta, jied ia ka text “Sheet 2” ha ka '''Input Line'''

|-
| 04:44
| Hadien ba la dep jied ia ka text, nion ha ikon Hyperlink ha ka toolbar

|-
| 04:51
| Ka Hyperlink dialog box ka paw.

|-
| 04:55
| Ha ka liang kadiang, to ngin jied ia ka opshon '''Document'''

|-
| 04:59
| Nion ha ka ikon '''Target in document '''ha ka dialog box.

|-
| 05:04
| Ka '''“Target in document”''' dialog-box ba thymmai ka paw.

|-
| 05:08
| Mynta , nion ha ka '''plus sign''' kaba marbud ia ka opshon '''“Sheet”''' 

|-
| 05:13
| Ha ka dialog box kaba paw, nion ha ka opshon '''“Sheet 2”''' 

|-
| 05:18
| Mynta, nion ka u '''Apply''' button bad nangta sa nion ha u '''Close''' button.

|-
| 05:24
| Mynta, na ka '''Hyperlink '''dialog box, nion ha''' Apply '''bad nangta sa nion ha '''Close'''

|-
| 05:32
| Ka “Sheet 1” tab ka paw hakhmat ryngkat ka text “Sheet 2” kaba thaba ha ka cell

|-
| 05:40
| Mynta, haba ngi nion ha ka text “Sheet 2”, kan sa ialam beit ia ngi sha ka sheet ha kaba ngi lah pyndap ia ka balance na bynta ka “Cost”

|-
| 05:51
| Ngi la dep shna ia ka hyperlink.

|-
| 05:55
| Ban weng ia ka hyperlink, nyngkong jied ia ka text ba don hyperlink kata “Sheet 2”

|-
| 06:01
| Mynta , nion ha ka liang kamon na ka context menu , nion ha ka opshon '''“Default Formatting”'''

|-
| 06:09
| Ka text kan sa nym long shuh ka hyperlink

|-
| 06:12
| Ka la shu long kum kiwei ki text kiba don ha ka document

|-
| 06:16
| To ngin phai biang lane undo ia ki jingpynkylla ba ngi la leh.

|-
| 06:20
| Bad da kane ngi la poi shaba kut jong ka Spoken Tutorial halor ka '''LibreOffice Calc'''.

|-
| 06:25
| Ban kyllum lang, ngi la pule shaphang kumno ban : '''Reference'''  sha kiwei ki sheet ha calc

|-
| 06:31
| Pyndonkam Hyperlinks ha Calc

|-
| 06:36
| Peit ia ka video ba don ka ka link ba la ai harum

|-
| 06:40
| Kane ka kyllum lang ia ka Spoken Tutorial project.

|-
| 06:43
| Lada phim don ia ka bandwidth kaba biang , phi lah ban shu download bad peit ia ka hadien.

|-
| 06:47
| Ka Kynhun jong ka Spoken Tutorial : Ka pynlong ia ki workshop da kaba pyndonkam ia ki Spoken Tutorials.

|-
| 06:52
| Ka ai sertiphikate sha kito kiba pass ha ka online test

|-
| 06:56
| Na ka bynta ki jingtip ba kham bniah sngewbha thoh sha '''contact at spoken hyphen tutorial dot org'''.

|-
| 07:03
| Ka Spoken Tutorial Project kadei ka bynta jong ka projek '''Talk to a Teacher''' 

|-
| 07:07
| Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
|-
| 07:15
| Kham bun ki jingtip halor kane ka mission ki don ha '''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
|-
| 07:25
| Ia kane ka jinghikai la pynkylla sha ka ktien khasi da I Meboreen Mary Thongni.
Khublei shibun ia ka jingiasnoh kti lang jong phi.

|}

@@ Line 29: / Line 29: @@
 |-
-| 00:033
+| 00:33
 |  Ia ka cell jong kawei pat ka sheet sha ka cell jong ka current sheet

LibreOffice-Suite-Calc/C3/Linking-Calc-Data/Khasi - Revision history

PoojaMoolya at 06:47, 18 April 2017

Meboreen Mary: Created page with " {| Border = 1 ! Time ! Narration |- | 00:00 | Ngi Pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''Linking in Calc'''- ha '..."