I-Learning LibreOffice: Izinqamuleli zekhibhodi ze-LibreOffice Calc
Ngaphezulu nje kwezinyanga ezi-2 ezedlule (April, 2025), siqale uchungechunge olusha lokuthunyelwe mayelana ne-LibreOffice, ihhovisi elaziwa kakhulu nelisetshenziswa kakhulu ku-Linuxverse. Isihloko sayo sithi "Ukufunda i-LibreOffice", futhi kulesi sokuqala siyinike inhloso yokukhuluma nokwenza kwaziwe isihloko se «Izinqamuleli zekhibhodi zethuluzi ngalinye le-LibreOffice: Umbhali, Calc, Impress, Draw, Math, kanye ne-Base..
Okungukuthi, sikubone njengethuba kakhulu futhi into ebaluleke kakhulu esivuna Ihhovisi lethu le-LibreOffice eliyisakhiwo sodumo, ngaphezu kwakho konke, lapho kuziwa ekusebenzeni okuphumelelayo nokukhiqizayo lapho kudingeka sisebenzisela ukulungiselela nokuphatha amaspredishithi ethu okutadisha nomsebenzi. Futhi ngaphezu kwakho konke, uhlale ucabanga ngalabo abangakakwazi noma okungenzeka ukuthi baqala ukuyisebenzisela izinjongo zokufunda nomsebenzi.
I-Learning LibreOffice - Isifundo 1: Izinqamuleli zekhibhodi zoMlobi
Kodwa, ngaphambi kokuqala ukwazi ngayinye yamanje «Izinqamuleli zekhibhodi ze-LibreOffice Calc, sincoma ukuthi uhlole i Okuthunyelwe kwangaphambilini nokokuqala kochungechunge lwethu lwangaphambilini kuleli hhovisi elifanayo, ekugcineni kwalo:
Uma ungomunye walabo abangakayazi futhi usebenzise i-LibreOffice—ngoba cishe usebenzisa i-MS Office noma enye yezindlela ezimbalwa zokuphathelene, ezivaliwe, nezikhokhelwayo/zamahhala zeWindows—kubalulekile ukuthi wazi izinto ezimbalwa. Isibonelo, i-LibreOffice ibukeka ifana ne-MS Office. Futhi, ihambisana kakhulu namafomethi wobunikazi be-MS Office, okungukuthi i-Doc, i-Docx, i-Xls, i-Xlsx, i-Ppt, i-Pptx, namanye aziwa kwamanye amathuluzi ayo.
I-Learning LibreOffice: Izinqamuleli zekhibhodi ze-LibreOffice Calc
Izinqamuleli zekhibhodi zamanje ze-LibreOffice Calc 25.2
Izinqamuleli zekhibhodi ziyinhlanganisela yokhiye ekuvumela ukuthi wenze izenzo ezithile kusistimu yokusebenza, uhlelo lokusebenza noma uhlelo ngokushesha, ngaphandle kokusebenzisa igundane noma uzulazule kumamenyu. Inhloso yayo eyinhloko ukukhulisa ukukhiqiza, ukunciphisa isikhathi esichithwa emisebenzini ephindaphindwayo nokwenza kube lula ukufinyelela emisebenzini esetshenziswa njalo.
Ukuzulazula kuspredishithi
Ngemuva kwalokho Lezi izinqamuleli ezikhona zekhibhodi zokuzulazula kuspredishithi.Nokho, ziningi ezinye. Isibonelo, kukhona ahlukene okukopisha nokuqamba kabusha amashidi, okwenza izenzo noma imisebenzi enokhiye bokusebenza kumaspredishithi, wokufometha amaseli kusetshenziswa izinhlanganisela zokhiye, ngisho nokusetshenziswa kumathebula e-pivot. Futhi ungakubona konke lokhu ngefomethi yethu elandekayo etholakala ku- Izinqamuleli zekhibhodi ye-LibreOffice Calc: Landa.
| IKHIBHODI LESINCANE | IMPUMELELO |
|---|---|
| Ctrl + Ikhaya | Ihambisa isikhombisi kuseli lokuqala eshidini (A1). |
| Ctrl + Ukuphela | Ihambisa isikhombisi kuseli lokugcina eliqukethe idatha. |
| Inicio | Ihambisa isikhombisi kuseli lokuqala lomugqa wamanje. |
| ekupheleni | Ihambisa ikhesa kukholamu yokugcina equkethe idatha kunoma yimuphi umugqa. |
| Shift + Ikhaya | Khetha amaseli kusuka kwamanje kuye kuseli lokuqala lomugqa wamanje. |
| Shift + End | Ikhetha wonke amaseli kusukela kuseli lamanje kuya kukholomu yokugcina equkethe idatha kunoma yimuphi umugqa. |
| Shift + Ikhasi Phezulu | Khetha amaseli ukusuka ekhasini lamanje kuye ekhasini elilodwa ngenhla kwekholomu yamanje noma wandise ukukhetha kwamanje ikhasi elilodwa phezulu. |
| Shift + Ikhasi Phansi | Khetha amaseli kusuka kwamanje kuye ekhasini elilodwa ngezansi kwekholomu yamanje noma nweba ukukhetha kwamanje phansi ekhasini elilodwa. |
| Shift + Isikhala | Ikhetha irowu yamanje noma inwebe okukhethiwe okukhona kuyo yonke imigqa efanele. |
| Ctrl + Isikhala | Ikhetha ikholomu yamanje noma inwebe ukukhetha okukhona kuwo wonke amakholomu afanele. |
| Ctrl + Shift + Isikhala | Khetha wonke amaseli eshidini. |
| Ctrl + ← | Ihambisa ikhesa kwesokunxele ekuqaleni nasekupheleni kwamabhulokhi amaseli anedatha. Uma iseli elingakwesokunxele sekhesa lingenalutho noma iseli elinekhesa lingenalutho, ikhesa ihamba kwesokunxele kumugqa wamanje ize ifike kuseli elandelayo enokuqukethwe. Uma wonke amaseli kumugqa ofanayo ukuya kwesokunxele sekhesa engenalutho, ikhesa iya kuseli lokuqala kumugqa. |
| ctrl + → | Hambisa ikhesa kwesokudla ekuqaleni nasekupheleni kwamabhulokhi eseli ngedatha. Uma iseli elingakwesokudla sekhesa lingenalutho noma iseli elinekhesa lingenalutho, ikhesa iya kwesokudla kumugqa wamanje ize ifike kuseli elandelayo enokuqukethwe. Uma wonke amaseli akumugqa ofanayo oya kwesokudla sekhesa engenalutho, ikhesa iya kuseli lokugcina kumugqa. |
| Ctrl + ↑ | Ihambisa ikhesa ekuqaleni nasekupheleni kwamabhulokhi amaseli ngedatha. Uma iseli elingenhla kwekhesa lingenalutho noma iseli elinekhesa lingenalutho, ikhesa iya phezulu kukholomu yamanje ize ifike kuseli elandelayo enokuqukethwe. Uma wonke amaseli akukholomu efanayo ngenhla kwekhesa engenalutho, ikhesa iya kuseli lokuqala kukholomu. |
| Ctrl + ↓ | Ihambisa ikhesa phansi ekuqaleni nasekupheleni kwamabhulokhi eseli ngedatha. Uma iseli elingaphansi kwekhesa lingenalutho noma iseli elinekhesa lingenalutho, ikhesa yehlisa ikholomu yamanje ize ifike kuseli elandelayo enokuqukethwe. Uma wonke amaseli akukholomu efanayo ngaphansi kwekhesa engenalutho, ikhesa iya kuseli lokugcina kukholomu. |
| Ctrl + Shift + umcibisholo | Ikhetha wonke amaseli kububanzi obudalwe ukunyakaza kwekhesa lapho usebenzisa u-Ctrl + ↑, ↓, ←, noma → izinhlanganisela zokhiye. Uma kusetshenziselwa ukukhetha imigqa namakholomu aseduze, ububanzi bamaseli obunxande bayakhiwa. Uma ikhesa ikuseli elingenalutho, okukhethiwe kuzosuka kuseli yamanje kuye kuseli lokuqala elinenani eliqonde kumcibisholo ocindezelweyo. |
| Ctrl + Page Up | Shift ishidi elilodwa ngakwesokunxele.
Ekubukeni kuqala kokuphrinta: Ithuthela ekhasini eledlule ukuze iphrinte. |
| Ctrl + Ikhasi Phansi | Shift ishidi elilodwa ngakwesokudla.
Ekubukeni kuqala kokuphrinta: Ithuthela ekhasini elilandelayo ukuze uphrinte. |
| I-Alt + Ikhasi Phezulu | Iskrola isikrini esisodwa ngakwesokunxele. |
| Ikhasi le-Alt Phansi | Iskrola isikrini esisodwa kwesokudla. |
| Ctrl + Ikhasi Phezulu | Yengeza ishidi langaphambili ekukhethweni kweshidi lamanje. Uma wonke amashidi encwadini yokusebenzela ekhethiwe, le nhlanganisela yokhiye ikhetha kuphela ishidi langaphambilini. Yenza ishidi langaphambili libe ngelimanje. |
| Ctrl + Ikhasi Phansi | Yengeza ishidi elilandelayo ekukhethweni kweshidi lamanje. Uma wonke amashidi encwadini yokusebenzela ekhethiwe, le nhlanganisela yokhiye ikhetha kuphela ishidi elilandelayo. Yenza ishidi elilandelayo libe ngelimanje. |
| I-Ctrl + * | SIfaka (*) uphawu lokuphindaphinda ekhiphedi yezinombolo
Sikhetha indawo yedatha lapho ikhesa itholakala khona. Indawo yedatha iqukethe uchungechunge lwamaseli ahlangene; iqukethe idatha futhi iboshwe imigqa namakholomu angenalutho. |
| I-Ctrl + / | Susebenzisa (/) uphawu lokuhlukanisa ekhiphedi yezinombolo
SIkhetha ububanzi befomula yamalungu afanayo lapho ikhesa itholakala khona. |
| Ctrl + ukhiye wokuhlanganisa | Faka amaseli (njengemenyu ethi Faka ▸ Amaseli) |
| Ctrl + ukhiye wokukhipha | Susa amaseli (njengemenyu ethi Hlela ▸ Susa Amaseli) |
| Isingeniso (ngesikhathi esikhethiwe) | Ihambisa ikhesa iseli elilodwa ebangeni elikhethiwe. Ukuze ucacise lapho ikhesa ihamba khona, yiya kokuthi Amathuluzi ▸ Izinketho ▸ I-LibreOffice Calc ▸ Okujwayelekile bese ushintsha inani likakhiye othi Enter uhambisa okukhethiwe kukho. |
| Faka (ngemuva kokukopisha okuqukethwe kweseli) | Uma okuqukethwe kweseli kusanda kukopishwa ebhodini lokunamathisela futhi akukho ukuhlela okwengeziwe okwenziwe efayelini lamanje, ukucindezela u-Enter kuzonamathisela okuqukethwe kwebhodi lokunamathisela endaweni yamanje yekhesa. |
| Shift + Faka | Uma ibhodi lokunamathisela liqukethe okuqukethwe kweseli futhi kungekho ukuhlelwa okwenziwe efayelini, ukucindezela okuthi Shift+Enter kuzosebenza ngendlela efanayo nokuthi Enter futhi kuzonamathisela okuqukethwe kwebhodi lokunamathisela endaweni yamanje yekhesa.
Uma ingekho iseli ekhethiwe, i-Shift + Enter ihambisa ikhesa kwelinye icala elichazwe kokuthi Cindezela u-Enter ukuze uhambise inketho yokukhetha etholakala kokuthi Amathuluzi ▸ Izinketho ▸ I-LibreOffice Calc ▸ Okujwayelekile. Ngenkathi kukhethwa uhla lwamaseli, okuthi Shift+Enter ihambisa ikhesa phakathi kokukhethiwe kwamanje iye ohlangothini oluphambene oluchazwe ku-Cindezela u-Enter ukuze uhambise inketho yokukhetha. |
| Ctrl+ | ` (ukhiye ongenhla kwethebhu, bheka inothi elingezansi kwaleli thebula) | Bonisa noma fihla ifomula esikhundleni senani kuwo wonke amaseli. |
Okokugcina, futhi uma ufuna ukwazi okwengeziwe mayelana nesimanje kanye nekusasa «Izinqamuleli zekhibhodi ze-LibreOffice Calc Khumbula ukuthi ungaya endaweni yakho kokuthi “LibreOffice Calc” uye kubha yemenyu ephezulu futhi uhlole indlela ethi “Amathuluzi / Enza Ngokwezifiso / Ikhibhodi”; njenge-inthanethi (nge-inthanethi) ukuya ku- ingxenye yewebhu yosizo ye-LibreOffice esemthethweni mane uchofoze okulandelayo isixhumanisi ukuya ngqo kumadokhumenti ngalesi sihloko.
I-LibreOffice Calc iyithuluzi elinothile elinothile lokukhohlisa idatha (okungcono ibe izinombolo) kusipredishithi. Ukuze kukhiqizwe imiphumela ethile, kokubili ngesimo sombhalo kanye nesithombe. Futhi inamandla okwenza izenzo ngokuzenzakalelayo, ukuze uguqule kuphela inani ledatha ethile ukuze uthole imiphumela ehlukile. Okuphinde kuvumele ukusetshenziswa kwemisebenzi namafomula athuthukisa futhi athuthukise ukusebenza kwezibalo eziyinkimbinkimbi kudatha. Ngaphezu kwalokho, ihlanganisa imisebenzi yedathabheyisi, enikeza amandla okuhlela, ukugcina nokuhlunga idatha; imisebenzi yehluzo eguqukayo, kumafomethi we-2D ne-3D; kanye nemisebenzi ye-Macro, evame ukuba usizo kakhulu ekurekhodeni nasekwenzeni imisebenzi ephindaphindwayo.
Isifingqo
Ngamafuphi, sithemba ukuthi lesi sifundo sesibili kulolu chungechunge sizinikele ekufundeni okwengeziwe "I-LibreOffice nezinqamuleli zayo zekhibhodi" uyayithanda futhi iwusizo, ngokufundisayo nangokoqobo, ukukwazi Dala futhi uphathe amafayela akho okutadisha noma omsebenzi kangcono futhi ngokushesha mayelana ne-office suite edumile. Futhi ikakhulukazi kulesi senzakalo mayelana I-LibreOffice Calc, okuyithuluzi lehhovisi imisebenzi yalo esivumela ukuthi sikhiqize futhi siguqule zonke izinhlobo zolwazi kumaspredishithi asetshenziswa njalo (izinombolo, amanani, amagrafu, amathebula).
Okokugcina, khumbula vakashela wethu «ikhasi lasekhaya» ngeSpanishi. Noma, nganoma yiluphi olunye ulimi (ngokwengeza nje izinhlamvu ezi-2 ekupheleni kwe-URL yethu yamanje, isibonelo: ar, de, en, fr, ja, pt kanye no-ru, phakathi kwezinye eziningi) ukuze ufunde okuqukethwe kwamanje okwengeziwe. Ukwengeza, sikumema ukuthi ujoyine yethu Isiteshi socingo esisemthethweni ukufunda nokwabelana ngezindaba eziningi, imihlahlandlela kanye nezifundo ezivela kuwebhusayithi yethu.