{"id":2615,"date":"2020-03-26T09:26:11","date_gmt":"2020-03-26T08:26:11","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2615"},"modified":"2021-10-30T08:54:12","modified_gmt":"2021-10-30T06:54:12","slug":"eurostat-a-v4-orszagainak-lakossagszama-2008-es-2019-kozott-181","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2615","title":{"rendered":"Excel gyakorlati feladat &#8211; B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata (#183\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2615\" class=\"elementor elementor-2615\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9a3c42c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a3c42c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7af2b17\" data-id=\"7af2b17\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2115b5e elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"2115b5e\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0Friss\u00edtve: 2020 j\u00falius 15.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-94c3559 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94c3559\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6b412b1\" data-id=\"6b412b1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1dc5067 elementor-widget elementor-widget-text-editor\" data-id=\"1dc5067\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Mir\u0151l sz\u00f3l ez a cikk?<br \/>Ebben az Excel gyakorlati feladatban egy b\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lattal kapcsolatos \u00fatnyilv\u00e1ntart\u00e1s\u00e1t k\u00e9sz\u00edtj\u00fck el.<br \/>A gyakorlat sor\u00e1n k\u00e9sz\u00edt\u00fcnk egy m\u00e1solatot a munkaf\u00fczetr\u0151l, t\u00f6r\u00f6lj\u00fck a felesleges sorokat, kieg\u00e9sz\u00edtj\u00fck a t\u00e1bl\u00e1zatot a sz\u00fcks\u00e9ges feliratokkal, k\u00e9pletekkel, ezt k\u00f6vet\u0151en megform\u00e1zzuk a t\u00e1bl\u00e1zatot, be\u00e1ll\u00edtjuk az oldaljellemz\u0151it, v\u00e9g\u00fcl export\u00e1ljuk azt PDF form\u00e1tumban.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6c3e59c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c3e59c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-899e79c\" data-id=\"899e79c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d4b7cb5 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"d4b7cb5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;fas fa-file-excel&quot;,&quot;library&quot;:&quot;fa-solid&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;no_headings_message&quot;:&quot;Ezen az oldalon nem tal\\u00e1lhat\\u00f3 c\\u00edmsor.&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTartalomjegyz\u00e9k\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__d4b7cb5\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__d4b7cb5\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__d4b7cb5\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-304a3f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"304a3f0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6d75b1f\" data-id=\"6d75b1f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2972415 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"2972415\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. A feladat ismertet\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">1. A feladat ismertet\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f01d18a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f01d18a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f680f06\" data-id=\"f680f06\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b6b09c elementor-widget elementor-widget-text-editor\" data-id=\"0b6b09c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A munkaf\u00fczet egy b\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lati \u00fatnyilv\u00e1ntart\u00e1s\u00e1t mutatja janu\u00e1r h\u00f3napra a k\u00f6vetkez\u0151 adatokkal: az utaz\u00e1s D\u00e1tuma, a g\u00e9pj\u00e1rm\u0171 Rendsz\u00e1ma a kilom\u00e9ter\u00f3ra-\u00e1ll\u00e1s indul\u00e1skor, a kilom\u00e9ter\u00f3ra \u00e1ll\u00e1sa \u00e9rkez\u00e9skor, valamint a sz\u00e1ll\u00edtm\u00e1ny k\u00f3dja. A munkalap egy k\u00fcl\u00f6n t\u00e1bl\u00e1zatban tartalmazza az \u00fczemanyag \u00e1r\u00e1t \u00e9s a sof\u0151r \u00e1ltal haszn\u00e1lt k\u00fcl\u00f6nb\u00f6z\u0151 rendsz\u00e1m\u00fa g\u00e9pj\u00e1rm\u0171vek fogyaszt\u00e1s\u00e1t is.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>A gyakorlat sor\u00e1n k\u00e9sz\u00edt\u00fcnk egy m\u00e1solatot a munkaf\u00fczetr\u0151l, t\u00f6r\u00f6lj\u00fck a t\u00e1bl\u00e1zat felesleges sorait, kieg\u00e9sz\u00edtj\u00fck a t\u00e1bl\u00e1zatot a sz\u00fcks\u00e9ges feliratokkal, elk\u00e9sz\u00edtj\u00fck a k\u00e9pleteket, megform\u00e1zzuk a t\u00e1bl\u00e1zatot, v\u00e9g\u00fcl az oldaljellemz\u0151k be\u00e1ll\u00edt\u00e1s\u00e1t k\u00f6vet\u0151en PDF form\u00e1tumban export\u00e1ljuk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-351bf6d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"351bf6d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6687421\" data-id=\"6687421\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4981824 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"4981824\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismeretek: <\/strong>abszol\u00fat hivatkoz\u00e1s, adatr\u00f6gz\u00edt\u00e9s, akt\u00edv cella \u00e1thelyez\u00e9se, export\u00e1l\u00e1s PDF \u00e9s TXT form\u00e1tumban, k\u00e9plet sokszoros\u00edt\u00e1sa, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, munkalap kezel\u00e9s, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet be\u00e1ll\u00edt\u00e1sa, oldalbe\u00e1ll\u00edt\u00e1s, t\u00e1bl\u00e1zat form\u00e1z\u00e1sa, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 Excel f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2929\">DARAB2<\/a>, DARABTELI, FKERES, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MAX<\/a>, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MIN<\/a>, SZUM.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dbe1df3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbe1df3\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b6a099b\" data-id=\"b6a099b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2dbfad7 elementor-widget elementor-widget-text-editor\" data-id=\"2dbfad7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A megold\u00e1shoz sz\u00fcks\u00e9ges f\u00e1jlokat t\u00f6lts\u00fck le a gyakorlati feladatoknak sz\u00e1nt mapp\u00e1ba!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4dea841 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4dea841\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b4a5db8\" data-id=\"b4a5db8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7d8d12f elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"7d8d12f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladatsor sz\u00f6vegf\u00e1jlban:<\/strong><br \/><a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.txt\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">183-K-Excel-P\u00e9ldat\u00e1r_#5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.txt<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat munkaf\u00fczete:<\/strong><br \/><a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">183-K-Excel-P\u00e9ldat\u00e1r_#5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.xlsx<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65a42c6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65a42c6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bbe0e6e\" data-id=\"bbe0e6e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6800dcb elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"6800dcb\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-1024x576.jpg\" class=\"attachment-large size-large wp-image-2623\" alt=\"Excel p\u00e9ldat\u00e1r 5, B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_1_T\u00e1bl\u00e1zat.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-708904b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"708904b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7ac209c\" data-id=\"7ac209c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-27c5d2f elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"27c5d2f\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-2624\" alt=\"Excel p\u00e9ldat\u00e1r 5, B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata, 2. \u00e1bra: A t\u00e1bl\u00e1zat PDF exportja a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_2_PDF.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: A t\u00e1bl\u00e1zat PDF exportja a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b785e8e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b785e8e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2bd0504\" data-id=\"2bd0504\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e688591 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"e688591\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A feladat&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2. A feladat<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6947312 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6947312\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-04636cb\" data-id=\"04636cb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8b33c50 elementor-widget elementor-widget-text-editor\" data-id=\"8b33c50\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A feladat sor\u00e1n a munkalapon elk\u00e9sz\u00edtend\u0151 t\u00e1bl\u00e1zatot az 1., a PDF exportot a 2. \u00e1bra mutatja.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5c03631 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c03631\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-43726be\" data-id=\"43726be\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9569db9 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"9569db9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2.1. A munkaf\\u00fczet megnyit\\u00e1sa \\u00e9s ment\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2.1. A munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-180f562 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"180f562\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d36292a\" data-id=\"d36292a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d26ef8 elementor-widget elementor-widget-text-editor\" data-id=\"4d26ef8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol>\n<li>Nyissa meg az al\u00e1bbi munkaf\u00fczetet \u00e9s mentse egy mapp\u00e1ba, a saj\u00e1t nev\u00e9t adva f\u00e1jln\u00e9vnek!<br \/><a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">183-K-Excel-P\u00e9ldat\u00e1r_#5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.xlsx<\/a><\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5274ddd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5274ddd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c6c678b\" data-id=\"c6c678b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-647a5d5 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"647a5d5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2.2. A t\\u00e1bl\\u00e1zatok el\\u0151k\\u00e9sz\\u00edt\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2.2. A t\u00e1bl\u00e1zatok el\u0151k\u00e9sz\u00edt\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0808088 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0808088\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-57b64d2\" data-id=\"57b64d2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fac3ed5 elementor-widget elementor-widget-text-editor\" data-id=\"fac3ed5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"2\">\n<li>T\u00f6r\u00f6lje az A14-t\u0151l kezd\u0151d\u0151 t\u00e1bl\u00e1zatban az \u00fcres, vagyis a h\u00e9tv\u00e9g\u00e9ket tartalmaz\u00f3 sorokat!<\/li>\n<li>Az A13 cell\u00e1ba g\u00e9pelje be a t\u00e1bl\u00e1zat c\u00edm\u00e9t:<br \/>A 2020 janu\u00e1ri sz\u00e1ll\u00edt\u00e1sok adatai<\/li>\n<li>Az F14 cell\u00e1ba g\u00e9pelje be: Megtett \u00fat [km]<\/li>\n<li>A G14 cell\u00e1ba g\u00e9pelje be: K\u00f6lts\u00e9g<\/li>\n<li>Az A37 cell\u00e1ba g\u00e9pelje be: \u00d6sszesen<\/li>\n<li>Az A38 cell\u00e1ba g\u00e9pelje be: Legkisebb<\/li>\n<li>Az A39 cell\u00e1ba g\u00e9pelje be: Legnagyobb<\/li>\n<li>Az A40 cell\u00e1ba g\u00e9pelje be: \u00c1tlag<\/li>\n<li>Az A42:A49 cell\u00e1kba g\u00e9pelje be egym\u00e1s al\u00e1 a k\u00f6vetkez\u0151 sz\u00e1ll\u00edtm\u00e1nyk\u00f3dokat:<br \/>ADI-18, BIN-10, BOK-25, BUDKE-05, EIM-M3, KII-1, SEW-BUD04, UT443<\/li>\n<li>A C4 cell\u00e1ba g\u00e9pelje be: Utak sz\u00e1ma<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fb04438 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb04438\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7259298\" data-id=\"7259298\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f3927e9 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"f3927e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2.3. A k\\u00e9pletek bevitele&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2.3. A k\u00e9pletek bevitele<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3cef6f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3cef6f0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-82df948\" data-id=\"82df948\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-780da6a elementor-widget elementor-widget-text-editor\" data-id=\"780da6a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"12\">\n<li>A Megtett \u00fat (F15:F36) oszlopban sz\u00e1m\u00edtsa ki az egyes napokon megtett \u00fat nagys\u00e1g\u00e1t! A megtett \u00fat az \u00c9rkez\u00e9s [km] \u00e9s az Indul\u00e1s [km] oszlopok k\u00fcl\u00f6nbs\u00e9ge.<\/li>\n<li>A K\u00f6lts\u00e9g (G15:G36) oszlopban k\u00e9plettel sz\u00e1m\u00edtsa ki az egyes napokon megtett \u00fat k\u00f6lts\u00e9g\u00e9t a megtett utat, az aut\u00f3 fogyaszt\u00e1s\u00e1t \u00e9s az \u00fczemanyag\u00e1rat figyelembe v\u00e9ve! A sz\u00e1m\u00edt\u00e1sn\u00e1l az adott rendsz\u00e1m\u00fa g\u00e9pj\u00e1rm\u0171 fogyaszt\u00e1s\u00e1t vegye figyelembe! A rendsz\u00e1mokhoz tartoz\u00f3 fogyaszt\u00e1sokat az A5:B10 tartom\u00e1ny tartalmazza.<br \/>Egy kis seg\u00edts\u00e9g: A k\u00f6lts\u00e9g a Megtett \u00fat (F oszlop), az \u00dczemanyag \u00e1r\u00e1nak (B1) \u00e9s a megfelel\u0151 rendsz\u00e1m\u00fa g\u00e9pj\u00e1rm\u0171 fogyaszt\u00e1sa\/100 szorzata.<br \/>Az adott sorban tal\u00e1lhat\u00f3 rendsz\u00e1mnak megfelel\u0151 fogyaszt\u00e1st az FKERES() f\u00fcggv\u00e9nnyel tudja kikeresni, vagyis az adott sorban tal\u00e1lhat\u00f3 rendsz\u00e1mot (1. argumentum) kell kikeresni az A5:B10 tartom\u00e1nyban (m\u00e1sodik argumentum), \u00e9s a tal\u00e1lathoz tartoz\u00f3 tartom\u00e1nybeli m\u00e1sodik oszlop (harmadik argumentum) adat\u00e1t kell visszaadni eredm\u00e9ny\u00fcl. A G15-be ker\u00fcl\u0151 k\u00e9plet teh\u00e1t a k\u00f6vetkez\u0151: <strong>=F15*$B$1*FKERES(B15;$A$5:$B$10;2)\/100<\/strong><\/li>\n<li>Ha az eredm\u00e9nyek d\u00e1tum form\u00e1tum\u00faak lettek, akkor t\u00f6r\u00f6lje a cell\u00e1k form\u00e1tum\u00e1t!<\/li>\n<li>Az E37 cell\u00e1ban k\u00e9plettel sz\u00e1molja ki, hogy a sof\u0151r h\u00e1ny napon vitt fuvart a h\u00f3nap sor\u00e1n!<\/li>\n<li>Az F37 cell\u00e1ban k\u00e9plettel sz\u00e1molja ki, hogy a sof\u0151r mekkora utat tett meg \u00f6sszesen a h\u00f3nap sor\u00e1n!<\/li>\n<li>A G37 cell\u00e1ban k\u00e9plettel sz\u00e1molja ki, mekkora volt az utak \u00f6sszk\u00f6lts\u00e9ge a h\u00f3nap sor\u00e1n!<\/li>\n<li>Az F38 cell\u00e1ban jelen\u00edtse meg k\u00e9plettel a legr\u00f6videbb utat!<\/li>\n<li>A G38 cell\u00e1ban jelen\u00edtse meg k\u00e9plettel a legkisebb k\u00f6lts\u00e9get!<\/li>\n<li>Az F39 cell\u00e1ban jelen\u00edtse meg k\u00e9plettel a leghosszabb utat!<\/li>\n<li>A G39 cell\u00e1ban jelen\u00edtse meg k\u00e9plettel a legnagyobb k\u00f6lts\u00e9get!<\/li>\n<li>Az F40 cell\u00e1ban jelen\u00edtse meg k\u00e9plettel a megtett utak \u00e1tlag\u00e1t!<\/li>\n<li>A G40 cell\u00e1ban jelen\u00edtse meg k\u00e9plettel az \u00e1tlagos k\u00f6lts\u00e9get!<\/li>\n<li>Az E42:E49 tartom\u00e1nyban k\u00e9plettel sz\u00e1molja ki, hogy a sof\u0151r h\u00e1ny darab utat tett meg az egyes sz\u00e1ll\u00edtm\u00e1nyk\u00f3dok alapj\u00e1n! Ellen\u0151rizze, hogy a kapott \u00e9rt\u00e9kek \u00f6sszege megegyezik-e az E22-ben sz\u00e1m\u00edtott \u00e9rt\u00e9kkel!<br \/>Egy kis seg\u00edts\u00e9g: a feladat sor\u00e1n meg kell sz\u00e1molni az E15:E36 tartom\u00e1nyban el\u0151fordul\u00f3 sz\u00e1ll\u00edtm\u00e1nyk\u00f3dokat, amelyeket az A42:A49 tartom\u00e1ny sorol fel. A sz\u00e1m\u00edt\u00e1shoz haszn\u00e1lja a DARABTELI() f\u00fcggv\u00e9nyt! Az E42 cell\u00e1ba ker\u00fcl\u0151 k\u00e9plet teh\u00e1t a k\u00f6vetkez\u0151: <strong>=DARABTELI($E$15:$E$36;A42)<\/strong><\/li>\n<li>A C5:C10 tartom\u00e1nyban k\u00e9plettel sz\u00e1molja ki minden g\u00e9pj\u00e1rm\u0171h\u00f6z a megtett utak sz\u00e1m\u00e1t! Ellen\u0151rizze, hogy a kapott \u00e9rt\u00e9kek \u00f6sszege megegyezik-e az E22-ben sz\u00e1m\u00edtott \u00e9rt\u00e9kkel!<br \/>Egy kis seg\u00edts\u00e9g: a feladat sor\u00e1n meg kell sz\u00e1molni a B15:B36 tartom\u00e1nyban el\u0151fordul\u00f3 rendsz\u00e1mokat, amelyeket az A5:A10 tartom\u00e1ny sorol fel. A sz\u00e1m\u00edt\u00e1shoz haszn\u00e1lja a DARABTELI() f\u00fcggv\u00e9nyt!<br \/>A C5 cell\u00e1ba ker\u00fcl\u0151 k\u00e9plet teh\u00e1t a k\u00f6vetkez\u0151: <strong>=DARABTELI($B$15:$B$36;A5)<\/strong><\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1e6b8be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1e6b8be\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16a3922\" data-id=\"16a3922\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-00dde72 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"00dde72\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2.4. A t\\u00e1bl\\u00e1zat form\\u00e1z\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2.4. A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c07a894 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c07a894\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-30cffda\" data-id=\"30cffda\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2f5ce1 elementor-widget elementor-widget-text-editor\" data-id=\"f2f5ce1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"26\">\n<li>M\u00f3dos\u00edtsa a munkalap nev\u00e9t a k\u00f6vetkez\u0151re: 2020janu\u00e1r<\/li>\n<li>Legyen a lapf\u00fclsz\u00edn Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00edn!<\/li>\n<li>Jel\u00f6lje ki az A14:G40 tartom\u00e1nyt!<\/li>\n<li>Rendelje hozz\u00e1 a k\u00f6vetkez\u0151 t\u00e1bl\u00e1zatst\u00edlust: Z\u00f6ld, K\u00f6zepes t\u00e1bl\u00e1zatst\u00edlus 7<\/li>\n<li>Az A14:G14 tartom\u00e1ny c\u00edmk\u00e9it igaz\u00edtsa v\u00edzszintesen k\u00f6z\u00e9pre!<\/li>\n<li>Egyes\u00edtse az A13:G13 tartom\u00e1ny cell\u00e1it!<\/li>\n<li>Az A13:G13 tartom\u00e1ny h\u00e1tter\u00e9nek kit\u00f6lt\u0151sz\u00edne legyen Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00edn, a bet\u0171sz\u00edn Feh\u00e9r, 1. h\u00e1tt\u00e9r, a st\u00edlus f\u00e9lk\u00f6v\u00e9r!<\/li>\n<li>A D\u00e1tum (A15:A36) oszlop \u00e9rt\u00e9keinek form\u00e1tum\u00e1t m\u00f3dos\u00edtsa a k\u00f6vetkez\u0151re: Hossz\u00fa d\u00e1tumforma, f\u00e9lk\u00f6v\u00e9r!<\/li>\n<li>Az E37 cella form\u00e1tuma legyen f\u00e9lk\u00f6v\u00e9r!<\/li>\n<li>A Megtett \u00fat (F15:F40) oszlop \u00e9rt\u00e9keinek form\u00e1tum\u00e1t m\u00f3dos\u00edtsa a k\u00f6vetkez\u0151re: Ezres sz\u00e1mform\u00e1tum, a tizedeshelyek sz\u00e1ma nulla, f\u00e9lk\u00f6v\u00e9r!<\/li>\n<li>A K\u00f6lts\u00e9g (G15:G40) oszlop \u00e9rt\u00e9keinek form\u00e1tum\u00e1t m\u00f3dos\u00edtsa a k\u00f6vetkez\u0151re: P\u00e9nznem, a tizedeshelyek sz\u00e1ma nulla, f\u00e9lk\u00f6v\u00e9r!<\/li>\n<li>Az A37:A40 h\u00e1tter\u00e9nek kit\u00f6lt\u0151sz\u00edne legyen Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00edn, a bet\u0171sz\u00edn Feh\u00e9r, 1. h\u00e1tt\u00e9r, a st\u00edlus f\u00e9lk\u00f6v\u00e9r!<\/li>\n<li>Az E37:G40 tartom\u00e1ny cell\u00e1inak bet\u0171sz\u00edne legyen Piros!<\/li>\n<li>M\u00f3dos\u00edtsa az A oszlop sz\u00e9less\u00e9g\u00e9t 25 karakterre!<\/li>\n<li>M\u00f3dos\u00edtsa a B:G oszlopok sz\u00e9less\u00e9g\u00e9t 15 karakterre!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a0b366b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a0b366b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a076cb0\" data-id=\"a076cb0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bf46557 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"bf46557\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2.5. A t\\u00e1bl\\u00e1zat oldalbe\\u00e1ll\\u00edt\\u00e1sa \\u00e9s export\\u00e1l\\u00e1sa PDF form\\u00e1tumban&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2.5. A t\u00e1bl\u00e1zat oldalbe\u00e1ll\u00edt\u00e1sa \u00e9s export\u00e1l\u00e1sa PDF form\u00e1tumban<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3391efb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3391efb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-310d290\" data-id=\"310d290\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f6a3579 elementor-widget elementor-widget-text-editor\" data-id=\"f6a3579\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"41\">\n<li>Jel\u00f6lje ki nyomtat\u00e1si ter\u00fcletnek a t\u00e1bl\u00e1zatot (A13:G40)!<\/li>\n<li>\u00c1ll\u00edtsa be a k\u00f6vetkez\u0151 oldaljellemz\u0151ket:<br \/>fekv\u0151 elrendez\u00e9s\u0171 oldal,<br \/>a t\u00e1bl\u00e1zat f\u00e9rjen el egy oldalon,<br \/>a marg\u00f3k legyenek 1-1cm sz\u00e9lesek,<br \/>az \u00c9l\u0151fej \u00e9s az \u00c9l\u0151l\u00e1b 0-0cm,<br \/>nincs \u00e9lf\u0151fej \u00e9s \u00e9l\u0151l\u00e1b,<br \/>a t\u00e1bl\u00e1zat az oldalon k\u00f6z\u00e9pen helyezkedjen el!<\/li>\n<li>Export\u00e1lja a munkaf\u00fczet mapp\u00e1j\u00e1ba a t\u00e1bl\u00e1zatot PDF form\u00e1tumban, a saj\u00e1t nev\u00e9t hagyva f\u00e1jln\u00e9vnek!<\/li>\n<li>A feladattal v\u00e9gzett, mentse \u00e9s z\u00e1rja be a munkaf\u00fczetet \u00e9s a PDF f\u00e1jlt!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-383e698 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"383e698\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0481d02\" data-id=\"0481d02\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1440dd9 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"1440dd9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. A megold\\u00e1s&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3. A megold\u00e1s<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9767988 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9767988\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a3f0fe5\" data-id=\"a3f0fe5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52532a6 elementor-widget elementor-widget-text-editor\" data-id=\"52532a6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Egy javaslat a v\u00e9grehajt\u00e1s menet\u00e9re a billenty\u0171zet haszn\u00e1lat\u00e1val (73 l\u00e9p\u00e9s):<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-18909e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"18909e4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fd2c31c\" data-id=\"fd2c31c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6faed1b elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"6faed1b\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.1. A munkaf\\u00fczet megnyit\\u00e1sa \\u00e9s ment\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.1. A munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6665f0c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6665f0c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d3238c0\" data-id=\"d3238c0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b07e33 elementor-widget elementor-widget-text-editor\" data-id=\"0b07e33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol>\n<li>Nyissuk meg a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">183-K-Excel-P\u00e9ldat\u00e1r_#5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat.xlsx<\/a> munkaf\u00fczetet szerkeszt\u00e9sre!<\/li>\n<li>Nyomjuk le az <em>F12<\/em> funkci\u00f3billenty\u0171t a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>G\u00e9pelj\u00fck be a <strong>F\u00e1jln\u00e9v<\/strong> szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> nyom\u00f3gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-786a438 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"786a438\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cb5818d\" data-id=\"cb5818d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-17ae7d3 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"17ae7d3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Jegyezz\u00fck meg, ha egy l\u00e9tez\u0151 munkaf\u00fczetet nyitunk meg, akkor a ment\u00e9s m\u00e1sk\u00e9nt funkci\u00f3 a munkaf\u00fczet mapp\u00e1j\u00e1t k\u00edn\u00e1lja fel a ment\u00e9shez. Azt is \u00e9rdemes megjegyezni, hogy a <strong>F\u00e1jln\u00e9v<\/strong> szerkeszt\u0151mez\u0151 tartalma, vagyis a munkaf\u00fczet neve kijel\u00f6lt \u00e1llapotban van, teh\u00e1t egy m\u00e1sik, teljesen m\u00e1s n\u00e9v megad\u00e1sakor azonnal fel\u00fclg\u00e9pelhetj\u00fck azt, nem kell el\u0151tte t\u00f6r\u00f6lni a <i>Del<\/i> vagy a <i>Backspace<\/i> billenty\u0171vel a szerkeszt\u0151mez\u0151 tartalm\u00e1t.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b61413b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b61413b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-79631d4\" data-id=\"79631d4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14bb98a elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"14bb98a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.2. A t\\u00e1bl\\u00e1zatok el\\u0151k\\u00e9sz\\u00edt\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.2. A t\u00e1bl\u00e1zatok el\u0151k\u00e9sz\u00edt\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f22eeb4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f22eeb4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8ef44ff\" data-id=\"8ef44ff\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63d8bc7 elementor-widget elementor-widget-text-editor\" data-id=\"63d8bc7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"4\">\n<li>Els\u0151 feladatunk, hogy t\u00f6r\u00f6lj\u00fck a t\u00e1bl\u00e1zat \u00fcres sorait, vagyis a h\u00e9tv\u00e9gei napokat, amelyeken nem volt g\u00e9pj\u00e1rm\u0171haszn\u00e1lat, \u00edgy a hozz\u00e1juk tartoz\u00f3 cell\u00e1k is \u00fcresek. Az A14 cell\u00e1t\u00f3l kezd\u0151d\u0151 t\u00e1bl\u00e1zatban \u00f6sszesen nyolc \u00fcres sor tal\u00e1lhat\u00f3. T\u00f6rl\u00e9s\u00fckh\u00f6z meg kell keresn\u00fcnk, ki kell jel\u00f6ln\u00fcnk, majd t\u00f6r\u00f6ln\u00fcnk kell ezeket a sorokat.<\/li>\n<li>Induljunk el a B14 cell\u00e1t\u00f3l lefel\u00e9, \u00e9s keress\u00fck meg az els\u0151 olyan cell\u00e1t, amely \u00fcres! Az els\u0151 k\u00e9t \u00fcres sor a 17:18-as. \u00dcss\u00fck le a <em>Shift+Sz\u00f3k\u00f6z, Shift+le ny\u00edlbillenty\u0171 <\/em>billenty\u0171kombin\u00e1ci\u00f3t a k\u00e9t sor kijel\u00f6l\u00e9s\u00e9hez, majd \u00fcss\u00fck le <em>Ctrl+NumPad \u2013 <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-833f5f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"833f5f9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1d11629\" data-id=\"1d11629\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-019b11a elementor-widget elementor-widget-text-editor\" data-id=\"019b11a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Ha k\u00e9perny\u0151olvas\u00f3 szoftverrel dolgozunk (p\u00e9ld\u00e1ul Jaws, ZoomText), a numerikus billenty\u0171zet val\u00f3sz\u00edn\u0171leg kurzormozgat\u00f3 \u00fczemm\u00f3dban, vagyis a <i>NumLock<\/i> kikapcsolt \u00e1llapotban van. Ha a numerikus billenty\u0171zethez k\u00f6thet\u0151 billenty\u0171kombin\u00e1ci\u00f3kkal akarunk dolgozni, akkor a <i>NumLock<\/i> kapcsol\u00f3nak bekapcsolt \u00e1llapotban kell lennie.<br \/>Ha nincs numerikus billenty\u0171zet\u00fcnk, akkor haszn\u00e1ljuk az alfanumerikus sziget k\u00f6t\u0151jel (m\u00ednusz) billenty\u0171j\u00e9t egy sor t\u00f6rl\u00e9s\u00e9hez: <i>Ctrl+ &#8211;<\/i>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-10dd0b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"10dd0b0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1c17a5a\" data-id=\"1c17a5a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-90a7bfb elementor-widget elementor-widget-global elementor-global-17146 elementor-widget-text-editor\" data-id=\"90a7bfb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Az akt\u00edv cella sor\u00e1nak kijel\u00f6l\u00e9s\u00e9re a <i>Shift+Sz\u00f3k\u00f6z<\/i>, oszlop\u00e1nak kijel\u00f6l\u00e9s\u00e9re a <i>Ctrl+Sz\u00f3k\u00f6z<\/i> haszn\u00e1lhat\u00f3. Ha t\u00f6bb sort\/oszlopot akarunk kijel\u00f6lni, akkor a szok\u00e1sos <i>Shift+ny\u00edlbillenty\u0171k<\/i> kijel\u00f6l\u00e9s kiterjeszt\u00e9ssel \u00e9lhet\u00fcnk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c397364 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c397364\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-58c7a5c\" data-id=\"58c7a5c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-83b1117 elementor-widget elementor-widget-text-editor\" data-id=\"83b1117\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"6\">\n<li>Az el\u0151bb le\u00edrtak szerint keress\u00fck meg a t\u00f6bbi \u00fcres sort, \u00e9s t\u00f6r\u00f6lj\u00fck (22:23, 27:28, 32:33)! Ha helyesen j\u00e1runk el, akkor a t\u00e1bl\u00e1zat utols\u00f3 sora a 36-os.<\/li>\n<li>A t\u00e1bl\u00e1zat c\u00edm\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: A 2020 janu\u00e1ri sz\u00e1ll\u00edt\u00e1sok adatai, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t az A13 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>Az F oszlop c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: Megtett \u00fat [km], majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t az F14 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A G oszlop c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: K\u00f6lts\u00e9g, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t a G14 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>Az oszlop\u00f6sszegeknek sz\u00e1nt 34-es sor c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: \u00d6sszesen, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t az A34 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A legkisebb \u00e9rt\u00e9k kikeres\u00e9s\u00e9re sz\u00e1nt 35-\u00f6s sor c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: Legkisebb, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t az A35 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A legnagyobb \u00e9rt\u00e9k kikeres\u00e9s\u00e9re sz\u00e1nt 36-os sor c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: Legnagyobb, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t az A36 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>Az \u00e1tlag kisz\u00e1mol\u00e1s\u00e1ra sz\u00e1nt 37-es sor c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: \u00c1tlag, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t az A37 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>L\u00e9pj\u00fcnk az A42 cell\u00e1ra, majd ebbe, \u00e9s az alatta l\u00e9v\u0151 h\u00e9t cell\u00e1ba g\u00e9pelj\u00fck be, vagy egyenk\u00e9nt jel\u00f6lj\u00fck ki \u00e9s illessz\u00fck be a sz\u00e1ll\u00edtm\u00e1ny k\u00f3dokat:<br \/>ADI-18, BIN-10, BOK-25, BUDKE-05, EIM-M3, KII-1, SEW-BUD04, UT443<\/li>\n<li>A sz\u00e1ll\u00edt\u00e1shoz haszn\u00e1lt g\u00e9pj\u00e1rm\u0171vek rendsz\u00e1m\u00e1t tartalmaz\u00f3 t\u00e1bl\u00e1zat harmadik (C) oszlop\u00e1ban a g\u00e9pj\u00e1rm\u0171vek \u00e1ltal megtett utak sz\u00e1m\u00e1t fogjuk megjelen\u00edteni. Az oszlop c\u00edmk\u00e9j\u00e9t m\u00e1soljuk v\u00e1g\u00f3lapra: Utak sz\u00e1ma, majd \u00e1ll\u00edtsuk az akt\u00edv cell\u00e1t a C4 cell\u00e1ra, \u00e9s nyomjuk le a <em>Ctrl+V <\/em>billenty\u0171kombin\u00e1ci\u00f3t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1.jpg\" target=\"_blank\" rel=\"noopener\">(3. \u00e1bra)<\/a>!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c4a9d34 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c4a9d34\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8e09808\" data-id=\"8e09808\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-68b6352 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"68b6352\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-1024x576.jpg\" class=\"attachment-large size-large wp-image-2625\" alt=\"Excel p\u00e9ldat\u00e1r 5, B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata, 3. \u00e1bra: Az el\u0151k\u00e9sz\u00edtett t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_3_Megold\u00e1s1_1.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">3. \u00e1bra: Az el\u0151k\u00e9sz\u00edtett t\u00e1bl\u00e1zat.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4894c50 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4894c50\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bc1cb12\" data-id=\"bc1cb12\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c9f476f elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"c9f476f\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.3. A k\\u00e9pletek bevitele&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.3. A k\u00e9pletek bevitele<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9cb2fce elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9cb2fce\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5f82e1a\" data-id=\"5f82e1a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f7c507f elementor-widget elementor-widget-text-editor\" data-id=\"f7c507f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"16\">\n<li>Az F15:F36 tartom\u00e1nyban a h\u00f3nap napjai sor\u00e1n megtett utak hossz\u00e1t kell megjelen\u00edten\u00fcnk. Ehhez az \u00c9rkez\u00e9s [km] (D) oszlopb\u00f3l ki kell vonni az Indul\u00e1s [km] (D) oszlop megfelel\u0151 \u00e9rt\u00e9k\u00e9t. El\u0151sz\u00f6r jel\u00f6lj\u00fck ki az F15:F36 tartom\u00e1nyt!<\/li>\n<li>Az F15 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=D15-C15<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! Az Excel a tartom\u00e1ny minden cell\u00e1j\u00e1ba elhelyezi a k\u00e9pletet a megfelel\u0151 hivatkoz\u00e1ssal.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2928b6b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2928b6b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31eda6d\" data-id=\"31eda6d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8cd4daa elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"8cd4daa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> A <i>Ctrl+Enter<\/i> az Excel egyik leghasznosabb billenty\u0171parancsa. Alkalmaz\u00e1s\u00e1val az el\u0151zetesen kijel\u00f6lt tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba beg\u00e9pelt tartalmat m\u00e1solhatjuk \u00e1t a tartom\u00e1ny t\u00f6bbi cell\u00e1j\u00e1ba. Ha a beg\u00e9pelt tartalom egy k\u00e9plet, akkor az Excel az abban tal\u00e1lhat\u00f3 (relat\u00edv, abszol\u00fat \u00e9s vegyes) hivatkoz\u00e1st\u00edpusokat figyelembe v\u00e9ve v\u00e9gzi el a m\u00e1sol\u00e1st. Ezzel helyettes\u00edthetj\u00fck a kit\u00f6lt\u00e9st vagy m\u00e1s sokszoros\u00edt\u00e1sra haszn\u00e1lt m\u00f3dszert.<br \/>Persze, el\u0151fordulhat, hogy elrontjuk a k\u00e9pletet, vagy m\u00e1s okb\u00f3l szerkeszteni akarjuk azt. Ilyenkor jel\u00f6lj\u00fck ki ism\u00e9t a tartom\u00e1nyt, nyomjuk le az <i>F2<\/i> funkci\u00f3billenty\u0171t az akt\u00edv cella szerkeszt\u00e9s\u00e9hez, v\u00e9gezz\u00fck el a jav\u00edt\u00e1st, v\u00e9g\u00fcl \u00fcss\u00fck le a <i>Ctrl+Enter<\/i> billenty\u0171kombin\u00e1ci\u00f3t!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b977742 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b977742\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-64536c9\" data-id=\"64536c9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7f6467a elementor-widget elementor-widget-text-editor\" data-id=\"7f6467a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A G15:G36 tartom\u00e1nyba az egyes g\u00e9pj\u00e1rm\u0171vek adott \u00fatra (F oszlop) es\u0151 k\u00f6lts\u00e9g\u00e9t kell kisz\u00e1molnunk. Ehhez a B1 cell\u00e1ban megkapjuk az \u00fczemanyag \u00e1r\u00e1t Ft\/l-ben, valamint a rendsz\u00e1mmal azonos\u00edtott g\u00e9pj\u00e1rm\u0171vek fogyaszt\u00e1s\u00e1t az A5:B10 tartom\u00e1nyban.<br \/><strong>A k\u00f6lts\u00e9g kisz\u00e1mol\u00e1sakor k\u00e9pezn\u00fcnk kell a megtett \u00fat [km], az \u00fczemanyag \u00e1r\u00e1nak [Ft\/liter] \u00e9s a megfelel\u0151 rendsz\u00e1m\u00fa g\u00e9pj\u00e1rm\u0171 fogyaszt\u00e1s\u00e1nak [liter\/100km] szorzat\u00e1t. Mivel az ut\u00f3bbit 100km-re kapjuk, a fogyaszt\u00e1st el kell osztani 100-al.<\/strong><br \/>A megtett \u00fat az F oszlopban tal\u00e1lhat\u00f3. Az \u00fczemanyag \u00e1r\u00e1t tartalmaz\u00f3 B1 cell\u00e1ra abszol\u00fat hivatkoz\u00e1ssal kell hivatkoznunk, hiszen a G oszlopban lefel\u00e9 sokszoros\u00edtani akarjuk a k\u00e9pleteket, \u00edgy a B1-re mutat\u00f3 hivatkoz\u00e1snak nem szabad v\u00e1ltoznia. Most m\u00e1r csak azt kell megoldanunk, hogy a t\u00e1bl\u00e1zat B oszlop\u00e1ban tal\u00e1lhat\u00f3 rendsz\u00e1mhoz tartoz\u00f3 fogyaszt\u00e1st keress\u00fck ki. A rendsz\u00e1m a B oszlopban tal\u00e1lhat\u00f3, a hozz\u00e1 tartoz\u00f3 fogyaszt\u00e1st pedig az A5:B10 tartom\u00e1nyban az FKERES f\u00fcggv\u00e9ny seg\u00edts\u00e9g\u00e9vel keress\u00fck ki. A tartom\u00e1ny els\u0151 oszlop\u00e1ban \u00e1b\u00e9c\u00e9 szerint emelked\u0151 sorrendben tal\u00e1lhat\u00f3 a rendsz\u00e1mok, m\u00edg a m\u00e1sodik oszlopban a hozz\u00e1juk tartoz\u00f3 fogyaszt\u00e1st tal\u00e1ljuk. Teh\u00e1t az FKERES els\u0151 param\u00e9tere a keresend\u0151 rendsz\u00e1m (B oszlop), m\u00e1sodik param\u00e9tere abszol\u00fat hivatkoz\u00e1ssal a $A$5:$B$10 tartom\u00e1nyhivatkoz\u00e1s, harmadik param\u00e9tere pedig a 2. A G15 cell\u00e1ba teh\u00e1t a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=F15*$B$1*FKERES(B15;$A$5:$B$10;2)\/100<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2ee2901 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2ee2901\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-83db0b1\" data-id=\"83db0b1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ad02dfa elementor-widget elementor-widget-text-editor\" data-id=\"ad02dfa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"18\">\n<li>Jel\u00f6lj\u00fck ki a G15:G36 tartom\u00e1nyt, majd g\u00e9pelj\u00fck be az akt\u00edv cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=F15*$B$1*FKERES(B15;$A$5:$B$10;2)\/100<\/strong><\/li>\n<li>Ha a tartom\u00e1nyban d\u00e1tum t\u00edpus\u00fa eredm\u00e9nyek jelennek meg, akkor adjuk ki a <strong>Kezd\u0151lap \/ T\u00f6rl\u00e9s \/ Form\u00e1tum t\u00f6rl\u00e9se <\/strong><em>(Alt+\u0150, R\u00d6, F)<\/em> parancsot!<\/li>\n<li>Az E37 cell\u00e1ban a fuvarok sz\u00e1m\u00e1t kell megjelen\u00edten\u00fcnk. Amivel minden napra egy fuvar esett, \u00edgy k\u00f6nny\u0171 a dolgunk, \u00f6ssze kell sz\u00e1molnunk az E oszlopban adatot tartalmaz\u00f3 cell\u00e1kat. Mivel a cell\u00e1k form\u00e1tumk\u00f3dja Sz\u00f6veg, \u00edgy a DARAB2 f\u00fcggv\u00e9nyt kell alkalmaznunk. G\u00e9pelj\u00fck be az E37 cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet:<br \/><strong>=DARAB2(E15:E36)<\/strong><\/li>\n<li>Az F37 cell\u00e1ban a megtett utak \u00f6sszeg\u00e9t kell k\u00e9pezn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=SZUM(F15:F36)<\/strong><\/li>\n<li>A G37 cell\u00e1ban az \u00f6sszk\u00f6lts\u00e9get kell k\u00e9pezn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=SZUM(G15:G36)<\/strong><\/li>\n<li>Az F38 cell\u00e1ban a legr\u00f6videbb utat kell kikeresn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=MIN(F15:F36)<\/strong><\/li>\n<li>A G38 cell\u00e1ban a legkisebb k\u00f6lts\u00e9get kell kikeresn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=MIN(G15:G36)<\/strong><\/li>\n<li>Az F39 cell\u00e1ban a leghosszabb utat kell kikeresn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=MAX(F15:F36)<\/strong><\/li>\n<li>A G39 cell\u00e1ban a legnagyobb k\u00f6lts\u00e9get kell kikeresn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=MAX(G15:G36)<\/strong><\/li>\n<li>Az F40 cell\u00e1ban az \u00e1tlagos utat kell kisz\u00e1molnunk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=\u00c1TLAG(F15:F36)<\/strong><\/li>\n<li>A G40 cell\u00e1ban az \u00e1tlagos k\u00f6lts\u00e9get kell kikeresn\u00fcnk, \u00edgy a cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet g\u00e9pelj\u00fck be: <strong>=\u00c1TLAG(G15:G36)<\/strong><\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1578893 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1578893\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7dfd841\" data-id=\"7dfd841\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-50308a1 elementor-widget elementor-widget-text-editor\" data-id=\"50308a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A k\u00f6vetkez\u0151 feladatunk, hogy az E42:E49 tartom\u00e1nyban t\u00fcntess\u00fck fel minden sz\u00e1ll\u00edtm\u00e1ny k\u00f3dhoz a megtett utak sz\u00e1m\u00e1t. Ehhez minden sz\u00e1ll\u00edtm\u00e1ny k\u00f3d sor\u00e1ban \u00f6ssze kell sz\u00e1molnunk, hogy az adott sz\u00e1ll\u00edtm\u00e1ny k\u00f3d h\u00e1nyszor fordul el\u0151 az E15:E36 tartom\u00e1nyban. A megfelel\u0151 f\u00fcggv\u00e9ny a DARABTELI, amelynek els\u0151 argumentuma lesz az E15:E36 tartom\u00e1ny, m\u00e1sodik argumentuma pedig az A42:A49 tartom\u00e1nyban sorakoz\u00f3 sz\u00e1ll\u00edtm\u00e1ny k\u00f3dok. Mivel a k\u00e9pletet sokszoros\u00edtani fogjuk, az E15:E36 tartom\u00e1nyhivatkoz\u00e1st abszol\u00fat hivatkoz\u00e1ssal fogjuk a k\u00e9pletben megjelen\u00edteni, a megfelel\u0151 sz\u00e1ll\u00edtm\u00e1ny k\u00f3d cell\u00e1j\u00e1ra pedig relat\u00edv hivatkoz\u00e1ssal fogunk hivatkozni. Az E42 cell\u00e1ba ker\u00fcl\u0151 k\u00e9plet a k\u00f6vetkez\u0151: <strong>=DARABTELI($E$15:$E$36;A42)<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2a4982b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2a4982b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cd27fbc\" data-id=\"cd27fbc\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-90e0d1e elementor-widget elementor-widget-text-editor\" data-id=\"90e0d1e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"29\">\n<li>Jel\u00f6lj\u00fck ki az E42:E49 tartom\u00e1nyt!<\/li>\n<li>G\u00e9pelj\u00fck be az akt\u00edv cell\u00e1ba az <strong>=DARABTELI($E$15:$E$36;A42) <\/strong>k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! A tartom\u00e1nyban megjelen\u0151 \u00e9rt\u00e9kek \u00f6sszeg\u00e9nek meg kell egyezni\u00fck az E37 cell\u00e1ban kisz\u00e1molt \u00f6sszeggel.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7507b27 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7507b27\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4b14254\" data-id=\"4b14254\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-da5344c elementor-widget elementor-widget-text-editor\" data-id=\"da5344c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Az Utak sz\u00e1ma (C5:C10) oszlopban ki kell sz\u00e1molnunk, hogy az egyes rendsz\u00e1m\u00fa g\u00e9pj\u00e1rm\u0171vekkel h\u00e1ny utat tettek meg. Ehhez minden rendsz\u00e1m sor\u00e1ban \u00f6ssze kell sz\u00e1molnunk, hogy az adott rendsz\u00e1m h\u00e1nyszor fordul el\u0151 a B15:B36 tartom\u00e1nyban. A megfelel\u0151 f\u00fcggv\u00e9ny a DARABTELI, amelynek els\u0151 argumentuma lesz a B15:B36 tartom\u00e1ny, m\u00e1sodik argumentuma pedig az A5:A10 tartom\u00e1nyban sorakoz\u00f3 rendsz\u00e1mok. Mivel a k\u00e9pletet sokszoros\u00edtani fogjuk, a B15:B36 tartom\u00e1nyhivatkoz\u00e1st abszol\u00fat hivatkoz\u00e1ssal fogjuk a k\u00e9pletben megjelen\u00edteni, a megfelel\u0151 rendsz\u00e1m\u00fa cell\u00e1ra pedig relat\u00edv hivatkoz\u00e1ssal fogunk hivatkozni. A C5 cell\u00e1ba ker\u00fcl\u0151 k\u00e9plet a k\u00f6vetkez\u0151: <strong>=DARABTELI($B$15:$B$36;A5)<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ceb74ba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ceb74ba\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-69de7aa\" data-id=\"69de7aa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c0afb4 elementor-widget elementor-widget-text-editor\" data-id=\"5c0afb4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"31\">\n<li>Jel\u00f6lj\u00fck ki a C5:C10 tartom\u00e1nyt!<\/li>\n<li>G\u00e9pelj\u00fck be az akt\u00edv cell\u00e1ba az <strong>=DARABTELI($B$15:$B$36;A5) <\/strong>k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! A tartom\u00e1nyban megjelen\u0151 \u00e9rt\u00e9kek \u00f6sszeg\u00e9nek meg kell egyezni\u00fck az E37 cell\u00e1ban kisz\u00e1molt \u00f6sszeggel <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2.jpg\" target=\"_blank\" rel=\"noopener\">(4. \u00e1bra)<\/a>.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b929cd2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b929cd2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-284292d\" data-id=\"284292d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-131c0a8 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"131c0a8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-1024x576.jpg\" class=\"attachment-large size-large wp-image-2626\" alt=\"Excel p\u00e9ldat\u00e1r 5, B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata, 4. \u00e1bra: A k\u00e9pletekkel kieg\u00e9sz\u00edtett t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_4_Megold\u00e1s1_2.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">4. \u00e1bra: A k\u00e9pletekkel kieg\u00e9sz\u00edtett t\u00e1bl\u00e1zat.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63ddb06 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63ddb06\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6c956e4\" data-id=\"6c956e4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-69500e0 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"69500e0\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.4. A t\\u00e1bl\\u00e1zat form\\u00e1z\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.4. A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8ed389f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ed389f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1c973f5\" data-id=\"1c973f5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-214ef16 elementor-widget elementor-widget-text-editor\" data-id=\"214ef16\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"33\">\n<li>M\u00e1soljuk v\u00e1g\u00f3lapra a munkalap nev\u00e9t: 2020janu\u00e1r<\/li>\n<li>Adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Munkalap \u00e1tnevez\u00e9se <\/strong><em>(Alt+\u0150, FF, N) <\/em>parancsot!<\/li>\n<li>A munkalap f\u00fcle szerkeszt\u0151mez\u0151v\u00e9 v\u00e1ltozik, \u00e9s a munkalap neve kijel\u00f6lt \u00e1llapotba ker\u00fcl: nyomjuk le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t, hogy lecser\u00e9lj\u00fck az \u00faj n\u00e9vre, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A munkalapf\u00fcl sz\u00edn\u00e9nek <strong>Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00ednre <\/strong>m\u00f3dos\u00edt\u00e1s\u00e1hoz adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Lapf\u00fclsz\u00edn <\/strong><em>(Alt+\u0150, FF, \u00dc) <\/em>parancsot, majd a megjelen\u0151 palett\u00e1n keress\u00fck meg a <strong>Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00ednt<\/strong> (az els\u0151 sor tizedik ikonja) \u00e9s v\u00e1lasszuk ki!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-322ea67 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"322ea67\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-db30027\" data-id=\"db30027\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-507f8b2 elementor-widget elementor-widget-text-editor\" data-id=\"507f8b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Ha a <strong>Kezd\u0151lap \/ Form\u00e1z\u00e1s t\u00e1bl\u00e1zatk\u00e9nt<\/strong> <i>(Alt+\u0150, M)<\/i> palett\u00e1j\u00e1n tal\u00e1lhat\u00f3 t\u00e1bl\u00e1zatst\u00edlusok k\u00f6z\u00fcl v\u00e1lasztva akarjuk t\u00e1bl\u00e1zatunk k\u00fclalakj\u00e1t gyorsan kialak\u00edtani, akkor a parancs haszn\u00e1lata el\u0151tt kiz\u00e1r\u00f3lag a t\u00e1bl\u00e1zat azon ter\u00fclet\u00e9t jel\u00f6lj\u00fck ki, amely csak az egysoros fejl\u00e9cet, az adatokat, illetve a sz\u00e1m\u00edt\u00e1sokat tartalmaz\u00f3 oszlopokat \u00e9s\/vagy sorokat tartalmazza \u2013 p\u00e9ld\u00e1ul a t\u00e1bl\u00e1zat felett elhelyezett c\u00edmsort ne!<br \/>Ha t\u00f6bb sorb\u00f3l (sors\u00e1vb\u00f3l), illetve oszlopb\u00f3l (oszlops\u00e1vb\u00f3l) \u00e1ll\u00f3 fejl\u00e9ceket tartalmaz a t\u00e1bl\u00e1zatunk, saj\u00e1t t\u00e1bl\u00e1zatst\u00edlust kell k\u00e9sz\u00edten\u00fcnk a <strong>Kezd\u0151lap \/ Form\u00e1z\u00e1s t\u00e1bl\u00e1zatk\u00e9nt \/ \u00daj t\u00e1bl\u00e1zatst\u00edlus<\/strong> <i>(Alt+\u0150, M, B)<\/i> paranccsal.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fa2dd31 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa2dd31\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20a6d81\" data-id=\"20a6d81\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-863d4c2 elementor-widget elementor-widget-text-editor\" data-id=\"863d4c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"37\">\n<li>Jel\u00f6lj\u00fck ki az A14:G40 tartom\u00e1nyt!<\/li>\n<li>A <strong>Z\u00f6ld, K\u00f6zepes t\u00e1bl\u00e1zatst\u00edlus 7 <\/strong>kiv\u00e1laszt\u00e1s\u00e1hoz adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1z\u00e1s t\u00e1bl\u00e1zatk\u00e9nt <\/strong><em>(Al+\u0150, M)<\/em> parancsot, majd a leny\u00edl\u00f3 palett\u00e1ban keress\u00fck meg \u00e9s v\u00e1lasszuk ki!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f43370a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f43370a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-864cd4e\" data-id=\"864cd4e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4f7d106 elementor-widget elementor-widget-text-editor\" data-id=\"4f7d106\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Az Excel jelenlegi kiad\u00e1s\u00e1ban a paletta 3 palettacsoportb\u00f3l (Vil\u00e1gos, K\u00f6zepesen s\u00f6t\u00e9t \u00e9s S\u00f6t\u00e9t) \u00e1ll, alul k\u00e9t paranccsal. A paletta \u00e9s a k\u00e9t parancs k\u00f6z\u00f6tt a Tab billenty\u0171vel l\u00e9pkedhet\u00fcnk. Az egyes palett\u00e1khoz tartoz\u00f3 t\u00e1bl\u00e1zatmint\u00e1k 7 oszlopban \u00e9s v\u00e1ltoz\u00f3 sz\u00e1m\u00fa sorban helyezkednek el, amelyek k\u00f6z\u00f6tt a ny\u00edlbillenty\u0171kkel l\u00e9pkedhet\u00fcnk. Egy minta neve az alkalmazott sz\u00edn megnevez\u00e9s\u00e9b\u0151l, a csoportn\u00e9vb\u0151l, \u00e9s a csoporton bel\u00fcli sorsz\u00e1mb\u00f3l \u00e1ll. Ha ezzel tiszt\u00e1ban vagyunk, nagyon k\u00f6nnyen megtal\u00e1lhatjuk a k\u00edv\u00e1nt t\u00e1bl\u00e1zatmint\u00e1t.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0edc8f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0edc8f2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-aeb4e96\" data-id=\"aeb4e96\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cc8e083 elementor-widget elementor-widget-text-editor\" data-id=\"cc8e083\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"39\">\n<li>A k\u00e9perny\u0151n megjelen\u0151 <strong>Form\u00e1z\u00e1s t\u00e1bl\u00e1zatk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablakban megjelenik a t\u00e1bl\u00e1zat tartom\u00e1nyhivatkoz\u00e1sa \u00e9s bekapcsoltan tal\u00e1ljuk a <strong>Fejl\u00e9ceket tartalmaz\u00f3 t\u00e1bl\u00e1zat<\/strong> opci\u00f3t. Mivel nek\u00fcnk ez \u00edgy j\u00f3, \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6cbe940 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6cbe940\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-beee57b\" data-id=\"beee57b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-701d198 elementor-widget elementor-widget-text-editor\" data-id=\"701d198\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> T\u00e1bl\u00e1zatunk most m\u00e1r nem egyszer\u0171 tartom\u00e1ny, hanem t\u00e1bl\u00e1zat. Ennek k\u00f6sz\u00f6nhet\u0151en kapjuk meg a <strong>Tervez\u00e9s<\/strong> <i>(Alt+\u0150, J\u00c9)<\/i> men\u00fcszalag f\u00fclet a t\u00e1bl\u00e1zat form\u00e1z\u00e1s\u00e1hoz, valamint a sz\u0171r\u0151 nyom\u00f3gombokat az A14:G14 cell\u00e1kban.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce0ed14 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce0ed14\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b7b4873\" data-id=\"b7b4873\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ee6239d elementor-widget elementor-widget-text-editor\" data-id=\"ee6239d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"40\">\n<li>Jel\u00f6lj\u00fck ki az A14:G14 tartom\u00e1nyt, majd a k\u00f6z\u00e9pre igaz\u00edt\u00e1shoz adjuk ki a <strong>Kezd\u0151lap \/ K\u00f6z\u00e9pre v\u00edzszintesen igaz\u00edt\u00e1s <\/strong><em>(Alt+\u0150, KZ)<\/em> parancsot!<\/li>\n<li>Jel\u00f6lj\u00fck ki az A13:G13 tartom\u00e1nyt a cell\u00e1k egyes\u00edt\u00e9s\u00e9hez!<\/li>\n<li>V\u00e1lasszuk ki a <strong>Kezd\u0151lap<\/strong> \/ <strong>Cellaegyes\u00edt\u00e9s<\/strong> <em>(Alt+\u0150, EG, A)<\/em> parancsot! Ha a <strong>Cell\u00e1k form\u00e1z\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablak <strong>Igaz\u00edt\u00e1s<\/strong> f\u00fcl\u00e9n tal\u00e1lhat\u00f3 <strong>Cell\u00e1k egyes\u00edt\u00e9s\u00e9vel<\/strong> opci\u00f3t akarjuk bekapcsolni, akkor nyomjuk le a <em>Ctrl+1, I, Alt+C, Enter<\/em> billenty\u0171parancsot!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t a t\u00e1bl\u00e1zat c\u00edm\u00e9nek f\u00e9lk\u00f6v\u00e9rre \u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fbaf105 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fbaf105\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3157844\" data-id=\"3157844\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0cc6572 elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"0cc6572\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> A k\u00f6vetkez\u0151 billenty\u0171kombin\u00e1ci\u00f3kat haszn\u00e1lhatjuk az elemi st\u00edlusok be\u00e1ll\u00edt\u00e1s\u00e1ra vagy kikapcsol\u00e1s\u00e1ra: f\u00e9lk\u00f6v\u00e9r <i>Ctrl+B<\/i> vagy <i>Ctrl+2<\/i>, d\u0151lt <i>Ctrl+I<\/i> vagy <i>Ctrl+3<\/i>, al\u00e1h\u00fazott <i>Ctrl+U<\/i> vagy <i>Ctrl+4<\/i>, \u00e1th\u00faz\u00e1s <i>Ctrl+5<\/i>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0119f6b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0119f6b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ebf45f\" data-id=\"5ebf45f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-658e6d9 elementor-widget elementor-widget-text-editor\" data-id=\"658e6d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"44\">\n<li>\u00c1ll\u00edtsuk be a <strong>Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00edn <\/strong>kit\u00f6lt\u0151sz\u00ednt a <strong>Kezd\u0151lap \/ Kit\u00f6lt\u0151sz\u00edn <\/strong><em>(Alt+\u0150, H1)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel!<\/li>\n<li>A <strong>Feh\u00e9r, 1. h\u00e1tt\u00e9r<\/strong> bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz haszn\u00e1ljuk a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1t!<\/li>\n<li>Jel\u00f6lj\u00fck ki az A15:A36 tartom\u00e1nyt!<\/li>\n<li>Keress\u00fck meg a <strong>Kezd\u0151lap \/ Sz\u00e1mform\u00e1tum <\/strong><em>(Alt+\u0150, SS)<\/em> kombin\u00e1lt listamez\u0151t, abban pedig a <strong>Hossz\u00fa d\u00e1tumforma<\/strong> elemet, majd v\u00e1lasszuk ki! (Az A oszlop nem lesz el\u00e9g sz\u00e9les az adatok megjelen\u00edt\u00e9s\u00e9hez, \u00edgy csupa kett\u0151skeresztet fogunk tal\u00e1lni a cell\u00e1kban. Ezen majd az oszlop sz\u00e9less\u00e9g\u00e9nek megn\u00f6vel\u00e9s\u00e9vel fogunk seg\u00edteni.)<\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t az E37 cell\u00e1ra, majd \u00fcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t a f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<li>A Megtett \u00fat oszlop form\u00e1z\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki az F15:F40 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t a f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<li>Az ezres csoport be\u00e1ll\u00edt\u00e1s\u00e1hoz v\u00e1lasszuk a <strong>Kezd\u0151lap \/ Ezres csoport<\/strong> <em>(Alt+\u0150, RE)<\/em> ikonj\u00e1t!<\/li>\n<li>A tizedeshelyek sz\u00e1m\u00e1t a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se<\/strong> <em>(Alt+\u0150, 9)<\/em> ikon k\u00e9tszeri haszn\u00e1lat\u00e1val tudjuk lenull\u00e1zni.<\/li>\n<li>A K\u00f6lts\u00e9g oszlop form\u00e1z\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki a G15:G40 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t a f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<li>A P\u00e9nznem sz\u00e1mform\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz keress\u00fck meg a <strong>Kezd\u0151lap \/ Sz\u00e1mform\u00e1tum <\/strong><em>(Alt+\u0150, SS)<\/em> kombin\u00e1lt listamez\u0151t, abban pedig a <strong>P\u00e9nznem <\/strong>elemet, majd v\u00e1lasszuk ki!<\/li>\n<li>A tizedeshelyek sz\u00e1m\u00e1t a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se<\/strong> <em>(Alt+\u0150, 9)<\/em> ikon k\u00e9tszeri haszn\u00e1lat\u00e1val tudjuk lenull\u00e1zni.<\/li>\n<li>Jel\u00f6lj\u00fck ki az A37:A40 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171parancsot f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<li>\u00c1ll\u00edtsuk be a <strong>Z\u00f6ld, 6. jel\u00f6l\u0151sz\u00edn <\/strong>kit\u00f6lt\u0151sz\u00ednt a <strong>Kezd\u0151lap \/ Kit\u00f6lt\u0151sz\u00edn <\/strong><em>(Alt+\u0150, H1)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel!<\/li>\n<li>A <strong>Feh\u00e9r, 1. h\u00e1tt\u00e9r<\/strong> bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz haszn\u00e1ljuk a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1t!<\/li>\n<li>Jel\u00f6lj\u00fck ki az E37:G40 tartom\u00e1nyt, majd a <strong>Piros<\/strong> bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz haszn\u00e1ljuk a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1t!<\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t az A1-re, majd adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, O)<\/em> parancsot!<\/li>\n<li>A k\u00e9perny\u0151n megjelen\u0151 p\u00e1rbesz\u00e9dablak <strong>Oszlopsz\u00e9less\u00e9g<\/strong> p\u00e1rbesz\u00e9dpanel szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fcnk be 25-\u00f6t, majd \u00fcss\u00fcnk <em>Enter<\/em>-t!<\/li>\n<li>Jel\u00f6lj\u00fck ki a B1:G1 tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, O)<\/em> parancsot!<\/li>\n<li>A k\u00e9perny\u0151n megjelen\u0151 p\u00e1rbesz\u00e9dablak <strong>Oszlopsz\u00e9less\u00e9g<\/strong> p\u00e1rbesz\u00e9dpanel szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fcnk be 15-\u00f6t, majd \u00fcss\u00fcnk <em>Enter<\/em>-t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3.jpg\" target=\"_blank\" rel=\"noopener\">(5. \u00e1bra)<\/a>!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1439b17 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1439b17\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7d0980b\" data-id=\"7d0980b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8293b7a elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"8293b7a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-1024x576.jpg\" class=\"attachment-large size-large wp-image-2627\" alt=\"Excel p\u00e9ldat\u00e1r 5, B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata, 5. \u00e1bra: A megform\u00e1zott t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_5_Megold\u00e1s1_3.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">5. \u00e1bra: A megform\u00e1zott t\u00e1bl\u00e1zat.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-16dded2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"16dded2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c4edf29\" data-id=\"c4edf29\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-904b911 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"904b911\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3.5. A t\\u00e1bl\\u00e1zat oldalbe\\u00e1ll\\u00edt\\u00e1sa \\u00e9s export\\u00e1l\\u00e1sa PDF form\\u00e1tumban&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3.5. A t\u00e1bl\u00e1zat oldalbe\u00e1ll\u00edt\u00e1sa \u00e9s export\u00e1l\u00e1sa PDF form\u00e1tumban<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-93afd50 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"93afd50\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-941ace7\" data-id=\"941ace7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b95ec53 elementor-widget elementor-widget-text-editor\" data-id=\"b95ec53\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"63\">\n<li>Jel\u00f6lj\u00fck ki az A13:G40 tartom\u00e1nyt!<\/li>\n<li>A t\u00e1bl\u00e1zatot nyomtat\u00e1si ter\u00fcletk\u00e9nt a <strong>Lapelrendez\u00e9s \/ Nyomtat\u00e1si ter\u00fclet \/ Nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se <\/strong><em>(Alt+P, I, K)<\/em> paranccsal tudjuk kijel\u00f6lni.<\/li>\n<li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> <em>(Alt+P, O)<\/em> parancsot!<\/li>\n<li>Az <strong>Oldal<\/strong> f\u00fcl\u00f6n v\u00e1lasszuk ki a <strong>Fekv\u0151 T\u00e1jol\u00e1st <\/strong><em>(Alt+F)<\/em>, a <strong>Nagy\u00edt\u00e1s<\/strong> r\u00e9szben a <strong>Legyen<\/strong> opci\u00f3t <em>(Alt+N)<\/em>.<\/li>\n<li>L\u00e9pj\u00fcnk \u00e1t a <em>Ctrl+Tab<\/em> billenty\u0171kombin\u00e1ci\u00f3val a <strong>Marg\u00f3k<\/strong> f\u00fclre, ahol \u00e1ll\u00edtsunk be 1-1cm-t a n\u00e9gy marg\u00f3 sz\u00e1m\u00e1ra, \u00e9s 0-0cm-t az <strong>\u00c9l\u0151fej<\/strong> \u00e9s az <strong>\u00c9l\u0151l\u00e1b<\/strong> szerkeszt\u0151mez\u0151kben!<\/li>\n<li>L\u00e9pj\u00fcnk tov\u00e1bb <em>Tab<\/em>-bal a <strong>V\u00edzszintesen<\/strong> \u00e9s a <strong>F\u00fcgg\u0151legesen<\/strong> opci\u00f3kra, \u00e9s kapcsoljuk be mindkett\u0151t a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171 seg\u00edts\u00e9g\u00e9vel!<\/li>\n<li>Z\u00e1rjuk be a p\u00e1rbesz\u00e9dablakot az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel!<\/li>\n<li>Adjuk ki a <strong>F\u00e1jl \/ Export\u00e1l\u00e1s<\/strong> parancsot, \u00e9s keress\u00fck meg a <strong>PDF\/XPS l\u00e9trehoz\u00e1sa<\/strong> nyom\u00f3gombot <em>(Alt+F, E, A)<\/em>!<\/li>\n<li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel PDF vagy XPS form\u00e1tumban<\/strong> p\u00e1rbesz\u00e9dablak, amelynek <strong>F\u00e1jln\u00e9v<\/strong> szerkeszt\u0151mez\u0151j\u00e9ben l\u00e1tjuk a munkaf\u00fczet nev\u00e9t, amit el is fogadhatunk: ments\u00fcnk a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> nyom\u00f3gombot v\u00e1lasztva!<\/li>\n<li>Ha sz\u00e1m\u00edt\u00f3g\u00e9p\u00fcnk\u00f6n van PDF kezel\u0151 alkalmaz\u00e1s, b\u00f6ng\u00e9sz\u0151 vagy Adobe Reader, akkor azt az Excel megpr\u00f3b\u00e1lja elind\u00edtani \u00e9s megjelen\u00edteni a f\u00e1jl tartalm\u00e1t (6. \u00e1bra).<\/li>\n<li>A feladattal v\u00e9gezt\u00fcnk, ments\u00fcnk \u00e9s z\u00e1rjunk be minden f\u00e1jlt \u00e9s alkalmaz\u00e1st!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5e3be59 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e3be59\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-45ce580\" data-id=\"45ce580\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4dcc1f2 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"4dcc1f2\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-1024x576.jpg\" class=\"attachment-large size-large wp-image-2628\" alt=\"Excel p\u00e9ldat\u00e1r 5, B\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lata, 6. \u00e1bra: A PDF form\u00e1tumban export\u00e1lt t\u00e1bl\u00e1zat a Microsoft Edge b\u00f6ng\u00e9sz\u0151ben.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/03\/183-K-Excel-P\u00e9ldat\u00e1r_5_G\u00e9pj\u00e1rm\u0171haszn\u00e1lat_6_Megold\u00e1s1_4.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">6. \u00e1bra: A PDF form\u00e1tumban export\u00e1lt t\u00e1bl\u00e1zat a Microsoft Edge b\u00f6ng\u00e9sz\u0151ben.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-80255ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"80255ed\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8541a6b\" data-id=\"8541a6b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d2c392 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"9d2c392\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>V\u00c9GE.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9043224 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9043224\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-401974d\" data-id=\"401974d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c9665a7 elementor-widget elementor-widget-text-editor\" data-id=\"c9665a7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 m\u00e1rcius 26.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (19H2, 1909b18363)<br \/>Irodai programcsomag: Microsoft Office 2016 v2003b12624.20320, Aktu\u00e1lis csatorna<br \/>Szint: kezd\u0151, ECDL: M04\/S6<br \/>Kateg\u00f3ria: T\u00e1bl\u00e1zatkezel\u00e9s \u2192 P\u00e9ldat\u00e1r<\/b><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1d09e1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d09e1d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0d43540\" data-id=\"0d43540\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-efdf7ee elementor-widget elementor-widget-shortcode\" data-id=\"efdf7ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><!-- FeedbackWP Plugin --><div        class=\"rmp-widgets-container rmp-wp-plugin rmp-main-container js-rmp-widgets-container js-rmp-widgets-container--2615 \"        data-post-id=\"2615\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2615\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2615\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8dd9506 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8dd9506\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-126ce51\" data-id=\"126ce51\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-50b65c1 elementor-share-buttons--skin-flat elementor-share-buttons--view-icon-text elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-global elementor-global-15485 elementor-widget-share-buttons\" data-id=\"50b65c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0Friss\u00edtve: 2020 j\u00falius 15. Mir\u0151l sz\u00f3l ez a cikk?Ebben az Excel gyakorlati feladatban egy b\u00e9rsof\u0151r g\u00e9pj\u00e1rm\u0171haszn\u00e1lattal kapcsolatos \u00fatnyilv\u00e1ntart\u00e1s\u00e1t k\u00e9sz\u00edtj\u00fck el.A gyakorlat sor\u00e1n k\u00e9sz\u00edt\u00fcnk egy m\u00e1solatot a munkaf\u00fczetr\u0151l, t\u00f6r\u00f6lj\u00fck a felesleges sorokat, kieg\u00e9sz\u00edtj\u00fck a t\u00e1bl\u00e1zatot a sz\u00fcks\u00e9ges feliratokkal, k\u00e9pletekkel, ezt k\u00f6vet\u0151en megform\u00e1zzuk a t\u00e1bl\u00e1zatot, be\u00e1ll\u00edtjuk az oldaljellemz\u0151it, v\u00e9g\u00fcl export\u00e1ljuk azt PDF \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2615\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":2623,"parent":516,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-2615","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2615"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2615\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/516"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/media\/2623"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}