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

From Script | Spoken-Tutorial
Jump to: navigation, search
Time
Narration
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.

Contributors and Content Editors

Meboreen Mary, PoojaMoolya