LibreOffice-Suite-Calc/C3/Linking-Calc-Data/Khasi
From Script | Spoken-Tutorial
|
|
---|---|
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:33 | 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. |