{"id":3488,"date":"2022-07-08T12:14:12","date_gmt":"2022-07-08T12:14:12","guid":{"rendered":"https:\/\/megnyitasa.com\/blog\/?p=3488"},"modified":"2022-07-08T12:14:12","modified_gmt":"2022-07-08T12:14:12","slug":"nyissa-meg-az-office-calc-basic-spreadsheet-tutorial-alkalmazast","status":"publish","type":"post","link":"https:\/\/megnyitasa.com\/blog\/nyissa-meg-az-office-calc-basic-spreadsheet-tutorial-alkalmazast\/","title":{"rendered":"Nyissa meg az Office Calc Basic Spreadsheet Tutorial alkalmaz\u00e1st"},"content":{"rendered":"<p>\nAz Open Office Calc egy elektronikus t\u00e1bl\u00e1zatkezel\u0151 program, amelyet az openoffice.org ingyenesen k\u00edn\u00e1l. A program k\u00f6nnyen haszn\u00e1lhat\u00f3, \u00e9s a t\u00e1bl\u00e1zatokban, p\u00e9ld\u00e1ul a Microsoft Excelben tal\u00e1lhat\u00f3 leggyakrabban haszn\u00e1lt funkci\u00f3k k\u00f6z\u00fcl a legt\u00f6bb, ha nem az \u00f6sszeset tartalmazza.\n<\/p>\n<p>\nEz az oktat\u00f3anyag bemutatja az alap t\u00e1bl\u00e1zat l\u00e9trehoz\u00e1s\u00e1nak l\u00e9p\u00e9seit az Open Office Calc alkalmaz\u00e1sban.\n<\/p>\n<p>A cikk utas\u00edt\u00e1sai az OpenOffice Calc v.4.1.6 verzi\u00f3ra vonatkoznak.<\/p>\n<h2>  Oktat\u00f3 t\u00e9m\u00e1k  <\/h2>\n<p>\nN\u00e9h\u00e1ny t\u00e1rgyalt t\u00e9ma:\n<\/p>\n<ul>\n<li>Adatok hozz\u00e1ad\u00e1sa egy t\u00e1bl\u00e1zathoz<\/li>\n<li>Oszlopok sz\u00e9les\u00edt\u00e9se<\/li>\n<li>D\u00e1tumf\u00fcggv\u00e9ny \u00e9s tartom\u00e1nyn\u00e9v hozz\u00e1ad\u00e1sa<\/li>\n<li>K\u00e9pletek hozz\u00e1ad\u00e1sa<\/li>\n<li>Adatok igaz\u00edt\u00e1s\u00e1nak m\u00f3dos\u00edt\u00e1sa a cell\u00e1kban<\/li>\n<li>Sz\u00e1m form\u00e1z\u00e1sa - sz\u00e1zal\u00e9k \u00e9s p\u00e9nznem<\/li>\n<li>A cella h\u00e1tt\u00e9rsz\u00edn\u00e9nek megv\u00e1ltoztat\u00e1sa<\/li>\n<li>A bet\u0171sz\u00edn megv\u00e1ltoztat\u00e1sa<\/li>\n<\/ul>\n<h2>  Adatok bevitele az Open Office Calc alkalmaz\u00e1sba  <\/h2>\n<p>\nAz adatok bevitele egy t\u00e1bl\u00e1zatba mindig h\u00e1rom l\u00e9p\u00e9sb\u0151l \u00e1ll. Ezek a l\u00e9p\u00e9sek:\n<\/p>\n<ol>\n<li>\n<p>\nV\u00e1lassza ki azt a cell\u00e1t, ahov\u00e1 az adatokat el szeretn\u00e9 vinni.\n<\/p>\n<\/li>\n<li>\n<p>\n\u00cdrja be adatait a cell\u00e1ba.\n<\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nNyomja meg a <strong>meg az ENTER<\/strong> gombot, vagy kattintson az eg\u00e9rrel egy m\u00e1sik cell\u00e1ra.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  Ehhez az oktat\u00f3anyaghoz  <\/h2>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/M0_iMMDLUPdFGRwtdbD-GinKnzY=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/03-openoffice-calc-basic-spreadsheet-tutorial-db80ed7f8ec24968a71efaca716f97a5.jpg\"><\/p>\n<p>\nAz oktat\u00f3anyag k\u00f6vet\u00e9s\u00e9hez \u00edrja be az adatokat a fentiek szerint pontosan egy \u00fcres t\u00e1bl\u00e1zatba a k\u00f6vetkez\u0151 l\u00e9p\u00e9sekkel:\n<\/p>\n<ol>\n<li>\n<p>\nNyisson meg egy \u00fcres Calc t\u00e1bl\u00e1zatf\u00e1jlt.\n<\/p>\n<\/li>\n<li>\n<p>\nV\u00e1lassza ki a megadott cellahivatkoz\u00e1ssal jel\u00f6lt cell\u00e1t.\n<\/p>\n<\/li>\n<li>\n<p>\n\u00cdrja be a megfelel\u0151 adatokat a kiv\u00e1lasztott cell\u00e1ba.\n<\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nNyomja meg a <strong>bel\u00e9p<\/strong> billenty\u0171t, vagy v\u00e1lassza ki az eg\u00e9rrel a lista k\u00f6vetkez\u0151 cell\u00e1j\u00e1t.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  Oszlopok sz\u00e9les\u00edt\u00e9se  <\/h2>\n<p>\nAz adatok be\u00edr\u00e1sa ut\u00e1n val\u00f3sz\u00edn\u0171leg azt tapasztalja, hogy t\u00f6bb sz\u00f3, p\u00e9ld\u00e1ul a dedukci\u00f3, t\u00fal sz\u00e9les egy cell\u00e1hoz. Ennek kijav\u00edt\u00e1s\u00e1hoz, hogy az eg\u00e9sz sz\u00f3 l\u00e1that\u00f3 legyen az oszlopban:\n<\/p>\n<ol>\n<li>\n<p class=\"gt-block\">\nHelyezze az eg\u00e9rmutat\u00f3t az oszlopok k\u00f6z\u00f6tti vonalra <strong>C<\/strong> \u00e9s <strong>D<\/strong> az oszlopfejl\u00e9cben. (A mutat\u00f3 k\u00e9tfej\u0171 ny\u00edll\u00e1 v\u00e1ltozik.)\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/wVTvFDxvmItKaxeQgS64LwrSR9M=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/03-openoffice-calc-basic-spreadsheet-tutorial-a389ba9e191c4b0a9c7b03d579f10ffe.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nV\u00e1lassza ki a bal eg\u00e9rgombbal, \u00e9s h\u00fazza a k\u00e9tfej\u0171 ny\u00edl jobbra a C oszlop kisz\u00e9les\u00edt\u00e9s\u00e9hez.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/lfzdZGwYwQSZDWWT85LXdoaV_uM=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/04-openoffice-calc-basic-spreadsheet-tutorial-bd53d66ea0a042ffbc133a6cb313db55.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nSz\u00e9les\u00edtsen m\u00e1s oszlopokat az adatok sz\u00fcks\u00e9g szerinti megjelen\u00edt\u00e9s\u00e9hez.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  A d\u00e1tum \u00e9s a tartom\u00e1nyn\u00e9v hozz\u00e1ad\u00e1sa  <\/h2>\n<p class=\"gt-block\">\nNorm\u00e1lis, ha a d\u00e1tumot hozz\u00e1adja egy t\u00e1bl\u00e1zathoz. Az Open Office Calcba be\u00e9p\u00edtve sz\u00e1mos <strong>D\u00c1TUM <\/strong>az erre haszn\u00e1lhat\u00f3 funkci\u00f3k. Ebben az oktat\u00f3anyagban a TODAY funkci\u00f3t fogjuk haszn\u00e1lni.\n<\/p>\n<ol>\n<li>\n<p>\nV\u00e1lassza ki a C4 cell\u00e1t.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/28W0nM6AVGpgsb9q4urMvAoeozo=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/05-openoffice-calc-basic-spreadsheet-tutorial-a90e19eea2d84f0ca5b03c52611e5c4c.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nbel\u00e9p <strong>= MA ()<\/strong>\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/nulQJdiaaem1-NR54HcMJIdFopY=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/06-openoffice-calc-basic-spreadsheet-tutorial-9f7a8b8fe7594958b29251a12e2a7d65.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nNyomja meg a <strong>meg az ENTER<\/strong> gombot a billenty\u0171zeten.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/0xbRkibG_eMHQKG6002tNMrCkXM=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/07-openoffice-calc-basic-spreadsheet-tutorial-25cfe11ae0134e4689be9bf50409f1ad.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nAz aktu\u00e1lis d\u00e1tumnak a cell\u00e1ban kell megjelennie <strong>C4<\/strong>\n<\/p>\n<\/li>\n<\/ol>\n<h2>  Tartom\u00e1nyn\u00e9v hozz\u00e1ad\u00e1sa az Open Office Calc alkalmaz\u00e1sban  <\/h2>\n<p>\nTartom\u00e1nyn\u00e9v hozz\u00e1ad\u00e1s\u00e1hoz az Open Office Calc alkalmaz\u00e1sba tegye a k\u00f6vetkez\u0151ket:\n<\/p>\n<ol>\n<li>\n<p class=\"gt-block\">\nV\u00e1lassza ki a cell\u00e1t <strong>C6 <\/strong>a t\u00e1bl\u00e1zatban.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/26zH0S2IGwG3mGeZ3BcbBbZC3sw=\/1600x872\/filters:no_upscale():max_bytes(150000):strip_icc()\/08-openoffice-calc-basic-spreadsheet-tutorial-4733a2db0374436e913ce0ecb4c908ed.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nKattintson a N\u00e9v mez\u0151re.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/3jq5MFfv-4r86wZu8d-UIxFuLtc=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/09-openoffice-calc-basic-spreadsheet-tutorial-19334bbf0fc34656b37b5c3410be6cde.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nAdja meg az \u00e1rfolyamot a <strong>n\u00e9v Box<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/U4aCd8R03aGsZ-qv1ZXs9ilBvTU=\/1600x867\/filters:no_upscale():max_bytes(150000):strip_icc()\/10-openoffice-calc-basic-spreadsheet-tutorial-ac05d8dffa5a437fa63308f9d9fb1c77.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nSejt <strong>C6 <\/strong>most megvan az ar\u00e1ny neve. A nevet a k\u00f6vetkez\u0151 l\u00e9p\u00e9sben egyszer\u0171s\u00edtj\u00fck a k\u00e9pletek l\u00e9trehoz\u00e1s\u00e1val.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  K\u00e9pletek hozz\u00e1ad\u00e1sa  <\/h2>\n<ol>\n<li>\n<p>\nV\u00e1lassza ki a C9 cell\u00e1t.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/Kl3XWgDM3xI-0AgD1-S6nxMNa_g=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/11-openoffice-calc-basic-spreadsheet-tutorial-281b10f18c1d49439f1506a9f1c17905.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\n\u00cdrja be a k\u00e9pletet <strong> <\/strong>= B9 * ar\u00e1ny.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/vnz48YZNBJZWssEp0ud_8lOM4hE=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/12-openoffice-calc-basic-spreadsheet-tutorial-2091022aeef0486a86106864ac6d45ea.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nnyomja meg <strong>bel\u00e9p<\/strong>\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/6uM7LcxDauFkExCeOhZUZEJMn4Q=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/13-openoffice-calc-basic-spreadsheet-tutorial-98f6b5e63237411cb5a4e432997389fa.jpg\"><\/p>\n<\/li>\n<\/ol>\n<h2>  A nett\u00f3 fizet\u00e9s kisz\u00e1m\u00edt\u00e1sa  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nV\u00e1lassza ki a cell\u00e1t <strong>D9<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/k0b6gDxsvlVhC2M7LPhRSYvUVb0=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/14-openoffice-calc-basic-spreadsheet-tutorial-4cbf4862dbcb4dd68efcb4c716b309a1.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\n\u00cdrja be a k\u00e9pletet <strong> <\/strong>= B9 - C9.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/YNQH5_U3sfhvOPReuR8CJYy0_v0=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/15-openoffice-calc-basic-spreadsheet-tutorial-7054627b179b44eea9c08bbb95633842.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nnyomja meg <strong>bel\u00e9p<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/VtUFtfova-j3ozX-4pvqVsoYYwo=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/16-openoffice-calc-basic-spreadsheet-tutorial-972ad7d5224a4abc95c0964f06e58666.jpg\"><\/p>\n<\/li>\n<\/ol>\n<ul>\n<li>Tov\u00e1bbi k\u00e9plet inform\u00e1ci\u00f3k: Nyissa meg az Office Calc k\u00e9pletek oktat\u00f3anyag\u00e1t<\/li>\n<\/ul>\n<h2>  A C9 \u00e9s D9 cell\u00e1k k\u00e9pleteinek m\u00e1sol\u00e1sa m\u00e1s cell\u00e1kba  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nV\u00e1lassza ki a cell\u00e1t <strong>C9 <\/strong>\u00fajra.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/6uM7LcxDauFkExCeOhZUZEJMn4Q=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/13-openoffice-calc-basic-spreadsheet-tutorial-98f6b5e63237411cb5a4e432997389fa.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nVigye az eg\u00e9rmutat\u00f3t az akt\u00edv cella jobb als\u00f3 sark\u00e1ban l\u00e9v\u0151 kit\u00f6lt\u0151foganty\u00fa (egy kis fekete pont) f\u00f6l\u00e9.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/AKvqPp_L71f-aGwoSdZNqFiKKmY=\/1600x867\/filters:no_upscale():max_bytes(150000):strip_icc()\/17-openoffice-calc-basic-spreadsheet-tutorial-e0d67f151fc44bbba40fd88943f74d94.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nAmikor a mutat\u00f3 fekete sz\u00ednre v\u00e1ltozik <strong>Plusz jel<\/strong>, v\u00e1lassza ki \u00e9s tartsa lenyomva az eg\u00e9r bal gombj\u00e1t, \u00e9s h\u00fazza a kit\u00f6lt\u0151 foganty\u00fat a cell\u00e1ba <strong>C12<\/strong>. A k\u00e9plet <strong>C9 <\/strong>cell\u00e1kba m\u00e1solja <strong>C10 <\/strong>kereszt\u00fcl <strong>C12<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/_l7-nxY5UHirs9aN1q4Rvs_RXMc=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/18-openoffice-calc-basic-spreadsheet-tutorial-b4020c279c0f4a52826486fcfcf5124a.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nV\u00e1lassza ki a cell\u00e1t <strong>D9<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/57Zal8PgELqTbS9r-gNJFU2j8BI=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/20-openoffice-calc-basic-spreadsheet-tutorial-3517a36fdb724fb5963b0da115665000.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nIsm\u00e9telje meg a 2. \u00e9s 3. l\u00e9p\u00e9st, \u00e9s h\u00fazza a kit\u00f6lt\u0151 foganty\u00fat a cell\u00e1ba <strong>D12<\/strong>. A k\u00e9plet <strong>D9 <\/strong>cell\u00e1kba m\u00e1solja <strong>D10 <\/strong>- <strong>D12<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/RyIoFBuy-w-vNYdCzVjMOm7XCL8=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/22-openoffice-calc-basic-spreadsheet-tutorial-10fa048119794a3db1c2248ca441694b.jpg\"><\/p>\n<\/li>\n<\/ol>\n<h2>  Az adatok igaz\u00edt\u00e1s\u00e1nak m\u00f3dos\u00edt\u00e1sa  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>A2 <\/strong>- <strong>D2<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/LsZs-4YnK-Et418R4tOAHDql3Hk=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/23-openoffice-calc-basic-spreadsheet-tutorial-eb7656937c7a42e5ad2f346cb09bc1ac.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Sejtek egyes\u00edt\u00e9se<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a kijel\u00f6lt cell\u00e1k egyes\u00edt\u00e9s\u00e9hez.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/IMIH_bKeuwHN_AbBqokH-KhmtGQ=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/001-open-office-calc-basic-spreadsheet-tutorial-3123949-a97e545f8195492a9bf33a6b3d439b08.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Igaz\u00edtsa k\u00f6z\u00e9pre v\u00edzszintesen<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a c\u00edm k\u00f6z\u00e9pre igaz\u00edt\u00e1s\u00e1hoz a kijel\u00f6lt ter\u00fcleten.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/6Iz-3Wp6dsSfYosw1ccr1qjsxLI=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/002-open-office-calc-basic-spreadsheet-tutorial-3123949-458b9e0658a742b58e857204c2d2f706.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>B4 <\/strong>- <strong>B6<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/bRIttG070yETyItnvXWYNpwpxVY=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/26-openoffice-calc-basic-spreadsheet-tutorial-203258105bef4089b123454e701433f4.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Igaz\u00edts jobbra<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a cell\u00e1k adatainak jobb igaz\u00edt\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/osHLKTFVjwpt6snQYivtJq9HstM=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/003-open-office-calc-basic-spreadsheet-tutorial-3123949-c7c2879d185b4a5fa10ff978ac1f906b.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>A9 <\/strong>- <strong>A12<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/M_6tDkhIOuhDDrRjmDhrgweuTWQ=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/28-openoffice-calc-basic-spreadsheet-tutorial-0b37e4837f8a47208d8f836eac54f46d.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Igaz\u00edts jobbra<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a cell\u00e1k adatainak jobb igaz\u00edt\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/52X91RBTZmIFxyG0lKp2X4bSaBg=\/1600x866\/filters:no_upscale():max_bytes(150000):strip_icc()\/29-openoffice-calc-basic-spreadsheet-tutorial-458d9a143f6140e28a02a550d5430609.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>A8 <\/strong>- <strong>D8<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/1BShAoip3Q92DTJ_IZsBONJoHk4=\/1600x867\/filters:no_upscale():max_bytes(150000):strip_icc()\/30-openoffice-calc-basic-spreadsheet-tutorial-40741199383a43b29facba4284c8ba1b.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Igaz\u00edtsa k\u00f6z\u00e9pre v\u00edzszintesen<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r az adatok ezen cell\u00e1kba t\u00f6rt\u00e9n\u0151 k\u00f6zpontos\u00edt\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/G3Vl2T-Ym5qB0OdLU6Xqwg6qeo0=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/31-openoffice-calc-basic-spreadsheet-tutorial-f6dd027fc73b4487af78d0a7bb0a5397.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>C4 <\/strong>- <strong>C6<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/6aQHeyjEkmQKffIKgsZW0XAGOjo=\/1600x865\/filters:no_upscale():max_bytes(150000):strip_icc()\/32-openoffice-calc-basic-spreadsheet-tutorial-19cfc7b353f444c69e689df501daf726.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Igaz\u00edtsa k\u00f6z\u00e9pre v\u00edzszintesen<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r az adatok ezen cell\u00e1kba t\u00f6rt\u00e9n\u0151 k\u00f6zpontos\u00edt\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/6ydz7BLEMatOcqUJazLvJ-64_JY=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/33-openoffice-calc-basic-spreadsheet-tutorial-3af82d83f26d4843b61c4e9eb5b359b8.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>B9 <\/strong>- <strong>D12<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/4kTZ9rXU3N4S41W3FiJg-cHSO6o=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/34-openoffice-calc-basic-spreadsheet-tutorial-d81e90adfe284353810b3166f5bb1aa0.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Igaz\u00edtsa k\u00f6z\u00e9pre v\u00edzszintesen<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r az adatok ezen cell\u00e1kba t\u00f6rt\u00e9n\u0151 k\u00f6zpontos\u00edt\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/FPuKMda4075qb_OjUyc4uAr2-mo=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/35-openoffice-calc-basic-spreadsheet-tutorial-4f20bec148c44d60b244b13bfbc835e9.jpg\"><\/p>\n<\/li>\n<\/ol>\n<h2>  Sz\u00e1mform\u00e1z\u00e1s hozz\u00e1ad\u00e1sa  <\/h2>\n<p>\nA sz\u00e1mform\u00e1tum a p\u00e9nznem szimb\u00f3lumok, tizedesjelek, sz\u00e1zal\u00e9kjelek \u00e9s egy\u00e9b szimb\u00f3lumok hozz\u00e1ad\u00e1s\u00e1ra utal, amelyek seg\u00edtenek azonos\u00edtani a cell\u00e1ban l\u00e9v\u0151 adatok t\u00edpus\u00e1t \u00e9s megk\u00f6nny\u00edtik az olvas\u00e1st.\n<\/p>\n<p>\nEbben a l\u00e9p\u00e9sben sz\u00e1zal\u00e9kjeleket \u00e9s p\u00e9nznemszimb\u00f3lumokat adunk az adatainkhoz.\n<\/p>\n<h2>  A sz\u00e1zal\u00e9kjel hozz\u00e1ad\u00e1sa  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nV\u00e1lassza ki a cell\u00e1t <strong>C6<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/rqQ0zO6Ii7DJKNdyWSJkxfFuv3k=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/36-openoffice-calc-basic-spreadsheet-tutorial-599f0be867e9479f8773977cfbcc979e.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Sz\u00e1mform\u00e1tum: Sz\u00e1zal\u00e9k<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a sz\u00e1zal\u00e9k szimb\u00f3lum hozz\u00e1ad\u00e1s\u00e1hoz a kijel\u00f6lt cell\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/8xFQLP0i6rqO9v31IpYVDT5Zxj0=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/004-open-office-calc-basic-spreadsheet-tutorial-3123949-16d4ae54fb4641ccb98dc354be2a8333.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Sz\u00e1mform\u00e1tum: Tizedesjegy t\u00f6rl\u00e9se<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r k\u00e9tszer a k\u00e9t tizedesjegy elt\u00e1vol\u00edt\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/q4Yfh_feNHbsvwBnF5KAONa369g=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/005-open-office-calc-basic-spreadsheet-tutorial-3123949-053d443157804c55b1f732816a3e4de5.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nAz adatok a cell\u00e1ban <strong>C6 <\/strong>most 6% -nak kell lennie.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  A p\u00e9nznem szimb\u00f3lum hozz\u00e1ad\u00e1sa  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>B9 <\/strong>- <strong>D12<\/strong>.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/7DxBWztO2cs48TijoTzIUIJqZ5I=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/39-openoffice-calc-basic-spreadsheet-tutorial-5fdedb8ad009464ebf68e573ccecc039.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>Sz\u00e1mform\u00e1tum: P\u00e9nznem<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a doll\u00e1rjel hozz\u00e1ad\u00e1s\u00e1hoz a kijel\u00f6lt cell\u00e1khoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/JjmoQ2SLcGr-_4oK36Ncz9ndBzg=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/006-open-office-calc-basic-spreadsheet-tutorial-3123949-6fea83f2b36b41f089f1b57947529047.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nAz adatok a cell\u00e1kban <strong>B9 <\/strong>- <strong>D12 <\/strong>most a doll\u00e1r szimb\u00f3lumot ($) \u00e9s k\u00e9t tizedesjegyet kell tartalmaznia.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  A cella h\u00e1tt\u00e9rsz\u00edn\u00e9nek megv\u00e1ltoztat\u00e1sa  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nJel\u00f6lje ki az egyes\u00edtett cell\u00e1kat <strong>A2 <\/strong>- <strong>D2 <\/strong>a t\u00e1bl\u00e1zatban.\n<\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>H\u00e1tt\u00e9rsz\u00edn<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r (fest\u00e9kkann\u00e1nak t\u0171nik) a h\u00e1tt\u00e9rsz\u00edn leg\u00f6rd\u00fcl\u0151 lista megnyit\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/2-Bu2woW3fngbpC9QV7LhR9iIzk=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/007-open-office-calc-basic-spreadsheet-tutorial-3123949-c7feb6891864453ebee3eacd59f60a8c.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nV\u00e1lasszon <strong>Tengeri k\u00e9k<\/strong> a list\u00e1b\u00f3l az egyes\u00edtett cell\u00e1k h\u00e1tt\u00e9rsz\u00edn\u00e9nek megv\u00e1ltoztat\u00e1s\u00e1hoz <strong>A2 <\/strong>- <strong>D2 <\/strong>k\u00e9kre.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/2rljDbO5DiYCbR-Qi03csIV75EI=\/1600x869\/filters:no_upscale():max_bytes(150000):strip_icc()\/42-openoffice-calc-basic-spreadsheet-tutorial-341ccad9a4ce4f27a446b6bbe66b11a9.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nH\u00fazza az A8 - D8 kijel\u00f6lt cell\u00e1kat a t\u00e1bl\u00e1zaton.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/-gyH-RG1HiyB-pyjrYh4mzfILYM=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/43-openoffice-calc-basic-spreadsheet-tutorial-a8fbdb243ae54932bb727937f468437d.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nIsm\u00e9telje meg az 2 \u00e9s az 3 l\u00e9p\u00e9seket.\n<\/p>\n<\/li>\n<\/ol>\n<h2>  Bet\u0171sz\u00edn megv\u00e1ltoztat\u00e1sa  <\/h2>\n<ol>\n<li>\n<p class=\"gt-block\">\nV\u00e1lassza ki az egyes\u00edtett cell\u00e1kat <strong>A2 <\/strong>- <strong>D2 <\/strong>a t\u00e1bl\u00e1zatban.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/wngplDR_789HE2s3PrAvfzYAJdM=\/1600x866\/filters:no_upscale():max_bytes(150000):strip_icc()\/44-openoffice-calc-basic-spreadsheet-tutorial-b8b48a26742b44ae9cae0e9a63ad2ed7.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>font color<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r (ez egy nagy bet\u0171 <strong>A<\/strong>) a bet\u0171sz\u00edn leg\u00f6rd\u00fcl\u0151 list\u00e1j\u00e1nak megnyit\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/ITL_BtO6ITL5zCovdxiRYffsV7Y=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/008-open-office-calc-basic-spreadsheet-tutorial-3123949-cd7274e69045462dab5bb055a1151456.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>feh\u00e9r <\/strong>a list\u00e1r\u00f3l az egyes\u00edtett cell\u00e1k sz\u00f6veg\u00e9nek megv\u00e1ltoztat\u00e1s\u00e1hoz <strong>A2 <\/strong>- <strong>D2 <\/strong>feh\u00e9rre.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/iTIiLBfsQjsa7P4nqwC-spCXE2k=\/1600x867\/filters:no_upscale():max_bytes(150000):strip_icc()\/46-openoffice-calc-basic-spreadsheet-tutorial-c49e8abd09d54de08585d512bbb476f6.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>A8 <\/strong>- <strong>D8 <\/strong>a t\u00e1bl\u00e1zatban.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/alnnDOWp23-Tuty0kh5EgLK0nVM=\/1600x865\/filters:no_upscale():max_bytes(150000):strip_icc()\/47-openoffice-calc-basic-spreadsheet-tutorial-42d29cbb210d4262b1bf91f3d7aa684b.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nIsm\u00e9telje meg a fenti 2. \u00e9s 3. l\u00e9p\u00e9st.\n<\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>B4 <\/strong>- <strong>C6 <\/strong>a t\u00e1bl\u00e1zatban.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/NC2bRmeU5pzazpj0eixx4pl8kQY=\/1600x867\/filters:no_upscale():max_bytes(150000):strip_icc()\/48-openoffice-calc-basic-spreadsheet-tutorial-9bc30da9579040bf84099f28283bc7f6.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nv\u00e1laszt <strong>font color<\/strong> a <strong>form\u00e1z\u00e1s<\/strong> eszk\u00f6zt\u00e1r a bet\u0171sz\u00edn leg\u00f6rd\u00fcl\u0151 lista megnyit\u00e1s\u00e1hoz.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/rTwL_8JvCnHuFqxdauQm0YZ70P8=\/1600x868\/filters:no_upscale():max_bytes(150000):strip_icc()\/49-openoffice-calc-basic-spreadsheet-tutorial-51e4e0a89cfe4547b5248372d2e4aec4.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nV\u00e1lasszon <strong>Tengeri k\u00e9k<\/strong> a list\u00e1b\u00f3l a sz\u00f6veg sz\u00edn\u00e9nek megv\u00e1ltoztat\u00e1s\u00e1hoz a cell\u00e1kban <strong>B4 <\/strong>- <strong>C6 <\/strong>k\u00e9kre.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/jidbrj6R1N3Dlo-aVgVJv1I_ARs=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/50-openoffice-calc-basic-spreadsheet-tutorial-98c33c6411b64e34996ca925d883cc81.jpg\"><\/p>\n<\/li>\n<li>\n<p class=\"gt-block\">\nH\u00fazza a kijel\u00f6lt cell\u00e1kat <strong>A9 <\/strong>- <strong>D12 <\/strong>a t\u00e1bl\u00e1zatban.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/CePLCr2Or6nPFlRinMFhYbt0rEI=\/1600x871\/filters:no_upscale():max_bytes(150000):strip_icc()\/51-openoffice-calc-basic-spreadsheet-tutorial-656ee264d9864706911793b15dde576f.jpg\"><\/p>\n<\/li>\n<li>\n<p>\nIsm\u00e9telje meg a fenti 7. \u00e9s 8. l\u00e9p\u00e9st.\n<\/p>\n<\/li>\n<\/ol>\n<p>\nEzen a ponton, ha helyesen k\u00f6vette az oktat\u00f3anyag \u00f6sszes l\u00e9p\u00e9s\u00e9t, akkor a t\u00e1bl\u00e1zatnak hasonl\u00edtania kell az al\u00e1bb l\u00e1that\u00f3 k\u00e9pre.\n<\/p>\n<p><img decoding=\"async\" class=\"postimg\" src=\"https:\/\/www.lifewire.com\/thmb\/-H5lbk-LW7ydVyqgDFSZ3rZkhHk=\/1600x870\/filters:no_upscale():max_bytes(150000):strip_icc()\/52-openoffice-calc-basic-spreadsheet-tutorial-8781005badea457491e71dba7d396125.jpg\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az Open Office Calc egy elektronikus t\u00e1bl\u00e1zatkezel\u0151 program, amelyet az openoffice.org ingyenesen k\u00edn\u00e1l. A program k\u00f6nnyen haszn\u00e1lhat\u00f3, \u00e9s a t\u00e1bl\u00e1zatokban, p\u00e9ld\u00e1ul a Microsoft Excelben tal\u00e1lhat\u00f3 leggyakrabban haszn\u00e1lt funkci\u00f3k k\u00f6z\u00fcl a legt\u00f6bb, ha nem az \u00f6sszeset tartalmazza. Ez az oktat\u00f3anyag bemutatja az alap t\u00e1bl\u00e1zat l\u00e9trehoz\u00e1s\u00e1nak l\u00e9p\u00e9seit az Open Office Calc alkalmaz\u00e1sban. A cikk utas\u00edt\u00e1sai az OpenOffice &#8230; <a title=\"Nyissa meg az Office Calc Basic Spreadsheet Tutorial alkalmaz\u00e1st\" class=\"read-more\" href=\"https:\/\/megnyitasa.com\/blog\/nyissa-meg-az-office-calc-basic-spreadsheet-tutorial-alkalmazast\/\" aria-label=\"Read more about Nyissa meg az Office Calc Basic Spreadsheet Tutorial alkalmaz\u00e1st\">Olvass tov\u00e1bb<\/a><\/p>\n","protected":false},"author":1568,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3488","post","type-post","status-publish","format-standard","hentry","category-wiki"],"_links":{"self":[{"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/posts\/3488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/users\/1568"}],"replies":[{"embeddable":true,"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/comments?post=3488"}],"version-history":[{"count":0,"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/posts\/3488\/revisions"}],"wp:attachment":[{"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/media?parent=3488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/categories?post=3488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/megnyitasa.com\/blog\/wp-json\/wp\/v2\/tags?post=3488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}