{"id":2762,"date":"2020-04-03T18:59:25","date_gmt":"2020-04-03T16:59:25","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2762"},"modified":"2022-08-07T19:17:58","modified_gmt":"2022-08-07T17:17:58","slug":"ecdl-tablazatkezeles-6-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2762","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 6. vizsgafeladat (#189\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2762\" class=\"elementor elementor-2762\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f2973ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f2973ed\" 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-c3b3a96\" data-id=\"c3b3a96\" 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-5db5a18 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"5db5a18\" 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: 2022 j\u00falius 23.<\/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-393757c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"393757c\" 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-d46667f\" data-id=\"d46667f\" 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-dd1fcf3 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"dd1fcf3\" 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\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/Vizsgafeladatok megold\u00e1sa, #1\" data-elementor-lightbox-description=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/Vizsgafeladatok megold\u00e1sa, #1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjUyMTcsInVybCI6Imh0dHBzOlwvXC93d3cuZmlhdGx1eGVmZWwuaW5mb1wvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyMlwvMDdcL0JlamVneXplc0ZhY2VUd2l0dGVyX0Npa2tGcmlzc2l0dmVFQ0RMX00wNF9TNl9WaXpzZ2FmZWxhZGF0b2tfMS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"420\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-1024x538.png\" class=\"elementor-animation-buzz-out attachment-large size-large wp-image-25217\" alt=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/Vizsgafeladatok megold\u00e1sa, #1\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-1024x538.png 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-300x158.png 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-768x404.png 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-150x79.png 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-250x131.png 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1.png 1231w\" 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\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-51bc891 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"51bc891\" 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-387bc52\" data-id=\"387bc52\" 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-5fab60c elementor-widget elementor-widget-text-editor\" data-id=\"5fab60c\" 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 a l\u00e1t\u00e1ss\u00e9r\u00fcltek sz\u00e1m\u00e1ra k\u00e9sz\u00fclt Microsoft Excel oktat\u00f3anyagban az ECDL T\u00e1bl\u00e1zatkezel\u00e9s modulhoz kiadott Vizsgap\u00e9ldat\u00e1r 6. feladat\u00e1t dolgozzuk fel a Windows 10 oper\u00e1ci\u00f3s rendszer \u00e9s a Microsoft Office 2016 irodai alkalmaz\u00e1scsomag aktu\u00e1lis kiad\u00e1s\u00e1nak felhaszn\u00e1l\u00e1s\u00e1val.<br \/>A vizsgafeladat megold\u00e1sa sor\u00e1n kiz\u00e1r\u00f3lag a billenty\u0171zetet haszn\u00e1ljuk.<\/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-e860509 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e860509\" 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-35616e1\" data-id=\"35616e1\" 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-3183915 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"3183915\" 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__3183915\" 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__3183915\" 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__3183915\" 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-1d7e97d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d7e97d\" 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-7fb2263\" data-id=\"7fb2263\" 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-f79ea1d elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"f79ea1d\" 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-bookmark\"><\/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>Felhaszn\u00e1lt forr\u00e1sok:<\/strong><\/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-bookmark\"><\/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\"><a href=\"https:\/\/njszt.hu\/hu\/ecdl\/modul\/tablazatkezeles\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A T\u00e1bl\u00e1zatkezel\u00e9s modul tartalma az NJSzT oldal\u00e1n.<\/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-bookmark\"><\/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\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 febru\u00e1r 1-t\u0151l \u00e9rv\u00e9nyes T\u00e1bl\u00e1zatkezel\u00e9s Syllabus 6 (PDF f\u00e1jl).<\/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-bookmark\"><\/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\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 m\u00e1rcius 1-t\u0151l \u00e9rv\u00e9nyes ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s (PDF f\u00e1jl).<\/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-bookmark\"><\/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\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A feladatokhoz tartoz\u00f3 munkaf\u00fczetek t\u00f6m\u00f6r\u00edtv\u00e9nye (ZIP f\u00e1jl).<\/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-bookmark\"><\/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\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/189-K-ECDLM04S6-Vizsgafeladat6.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 6. feladatsor Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban.<\/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-94bb2ee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94bb2ee\" 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-df8617f\" data-id=\"df8617f\" 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-d427aa1 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"d427aa1\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. El\\u0151k\\u00e9sz\\u00fcletek&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. El\u0151k\u00e9sz\u00fcletek<\/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-66bb7fe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"66bb7fe\" 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-ef08a19\" data-id=\"ef08a19\" 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-567c69a elementor-widget elementor-widget-text-editor\" data-id=\"567c69a\" 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>Az ECDL Excel vizsgafeladat megold\u00e1sa el\u0151tt a megjel\u00f6lt forr\u00e1sok k\u00f6z\u00fcl t\u00f6lts\u00fck le sz\u00fcks\u00e9g szerint az <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s 6.0<\/a> dokumentumot \u00e9s a <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">munkaf\u00e1jlokat<\/a> \u2013 az el\u0151bbit nyissuk meg, az ut\u00f3bbit pedig csomagoljuk ki c\u00e9lszer\u0171en a Dokumentumok mapp\u00e1ba. A vizsgap\u00e9ldat\u00e1r PDF dokumentum, amit a legt\u00f6bb internet b\u00f6ng\u00e9sz\u0151 k\u00e9pes megnyitni, de haszn\u00e1lhatjuk b\u00e1rmelyik PDF olvas\u00f3 alkalmaz\u00e1st is, p\u00e9ld\u00e1ul az Adobe Acrobat Readert. L\u00e1t\u00e1ss\u00e9r\u00fclt sorst\u00e1rsaink <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/189-K-ECDLM04S6-Vizsgafeladat6.txt\" target=\"_blank\" rel=\"noreferrer noopener\">Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban<\/a> is let\u00f6lthetik a feladatsort.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>Tekints\u00fck \u00e1t a feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismereteket \u00e9s a felhaszn\u00e1lt f\u00fcggv\u00e9nyeket:<\/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-ad74977 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad74977\" 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-472954b\" data-id=\"472954b\" 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-8265097 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8265097\" 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, ar\u00e1nysz\u00e1m\u00edt\u00e1s, diagram k\u00e9sz\u00edt\u00e9se \u00e9s form\u00e1z\u00e1sa, export\u00e1l\u00e1s PDF \u00e9s HTML form\u00e1tumban, 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, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, rel\u00e1ci\u00f3s oper\u00e1torok, sorba rendez\u00e9s, t\u00e1bl\u00e1zat form\u00e1z\u00e1sa, tartom\u00e1nyok kijel\u00f6l\u00e9se, weblap k\u00f6zz\u00e9t\u00e9tel.<\/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 f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, HA, 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-f440ee7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f440ee7\" 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-bb79585\" data-id=\"bb79585\" 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-007b883 elementor-widget elementor-widget-text-editor\" data-id=\"007b883\" 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 v\u00e9grehajt\u00e1sa el\u0151tt, k\u00f6zben \u00e9s ut\u00e1n vess\u00fck \u00f6ssze munk\u00e1nkat az al\u00e1bbi \u00e1br\u00e1k tartalm\u00e1val, amelyeken egy-egy szakasz (elk\u00e9sz\u00fclt t\u00e1bl\u00e1zat, diagram, export stb.) \u00e1llapot\u00e1t tekinthetj\u00fck meg.<\/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-21dfedb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21dfedb\" 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-59ba1b1\" data-id=\"59ba1b1\" 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-526516a elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"526516a\" 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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat.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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-1024x576.jpg\" class=\"attachment-large size-large wp-image-25755\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 6. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat.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-a09ecaa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a09ecaa\" 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-c640cc3\" data-id=\"c640cc3\" 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-a830acc elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"a830acc\" 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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram.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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-25756\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 6. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A k\u00e9sz csoportos\u00edtott oszlopdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram.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 k\u00e9sz csoportos\u00edtott oszlopdiagram.<\/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-86ffb0e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86ffb0e\" 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-9f43226\" data-id=\"9f43226\" 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-4a5b031 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"4a5b031\" 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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM.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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-1024x576.jpg\" class=\"attachment-large size-large wp-image-25757\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 6. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: Az elk\u00e9sz\u00fclt weblap a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM.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 elk\u00e9sz\u00fclt weblap 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-d42b173 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d42b173\" 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-28c4836\" data-id=\"28c4836\" 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-7ac5a49 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"7ac5a49\" 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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF.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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-25758\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 6. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: A PDF export a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_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\">4. \u00e1bra: A PDF export 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-44e13a4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"44e13a4\" 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-0ed6806\" data-id=\"0ed6806\" 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-abac564 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"abac564\" 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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok.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\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-25759\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 6. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok.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 feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\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-fc1cee2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fc1cee2\" 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-f3e84d0\" data-id=\"f3e84d0\" 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-c91a3f3 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"c91a3f3\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A vizsgafeladat megold\\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<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 vizsgafeladat megold\u00e1sa<\/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-8460915 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8460915\" 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-4d7bebe\" data-id=\"4d7bebe\" 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-3ff0cba elementor-widget elementor-widget-text-editor\" data-id=\"3ff0cba\" 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 (64 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-408c53a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"408c53a\" 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-af21ecd\" data-id=\"af21ecd\" 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-24f2a57 elementor-widget elementor-widget-text-editor\" data-id=\"24f2a57\" 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 szerkeszt\u00e9sre az M4-6.xlsx munkaf\u00fczetet!<\/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> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> gombot 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-419b463 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"419b463\" 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-5d29000\" data-id=\"5d29000\" 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-45e114e elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"45e114e\" 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-4e876e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e876e6\" 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-30132a5\" data-id=\"30132a5\" 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-3812255 elementor-widget elementor-widget-text-editor\" data-id=\"3812255\" 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 teend\u0151nk, hogy megismerkedj\u00fcnk a t\u00e1bl\u00e1zattal: az M4-6 munkalap d\u00e9zs\u00e1s egzotikus n\u00f6v\u00e9nyek import\u00e1lt mennyis\u00e9geit tartalmazza a 2007-2013 \u00e9vekben. A t\u00e1bl\u00e1zat az A1:H19 tartom\u00e1nyt foglalja el. Az els\u0151 sor az \u00e9vsz\u00e1mokat tartalmazza \u00c1ltal\u00e1nos, numerikus form\u00e1tumban. Az A oszlopban a n\u00f6v\u00e9nyek nevei sorakoznak, az oszlopnak nincs neve. Az import\u00e1lt mennyis\u00e9gek numerikus adatok, \u00e9s a B2:H19 tartom\u00e1nyt t\u00f6ltik ki.<\/li>\n<li>P\u00f3toljuk a n\u00f6v\u00e9nyek oszlopazonos\u00edt\u00f3j\u00e1t! G\u00e9pelj\u00fck be az A1 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: N\u00e9v<\/li>\n<li>Az els\u0151 feladatunk a list\u00e1t a n\u00f6v\u00e9nyek neve (A) oszlop szerint sorba rendezni. Mivel a feladat nem \u00edrja el\u0151, hogy emelked\u0151be vagy cs\u00f6kken\u0151be kell rendezn\u00fcnk a sorokat, \u00edgy mi \u00fagy d\u00f6nt\u00f6tt\u00fcnk, hogy emelked\u0151 sorrendbe fogunk rendezni!<\/li>\n<li>Jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel az A2:H19 tartom\u00e1nyt!<\/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-ed2b59b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ed2b59b\" 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-987de29\" data-id=\"987de29\" 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-bff8176 elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"bff8176\" 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 <i>F5<\/i> funkci\u00f3billenty\u0171t nem csak egy adott cell\u00e1ra ugr\u00e1sra, hanem cell\u00e1k, tartom\u00e1nyok, teljes sor, sorok, oszlop, illetve oszlopok kijel\u00f6l\u00e9s\u00e9re is haszn\u00e1lhatjuk, ak\u00e1r vegyesen is. Tartom\u00e1ny kijel\u00f6l\u00e9s\u00e9hez a tartom\u00e1nyhivatkoz\u00e1st, t\u00f6bb tartom\u00e1ny kijel\u00f6l\u00e9s\u00e9hez azok pontosvessz\u0151vel elv\u00e1lasztott hivatkoz\u00e1sait, sorn\u00e1l csak a sorsz\u00e1mot, sorokn\u00e1l a sorokat, oszlopn\u00e1l az oszlop bet\u0171jel\u00e9t, oszlopokn\u00e1l a bet\u0171jelekb\u0151l k\u00e9pzett tartom\u00e1nyhivatkoz\u00e1st kell megadnunk, p\u00e9ld\u00e1ul A1:C3 vagy A1:C3;E20:E22 vagy 5:5 vagy 5:10 vagy B:B vagy B:N.<\/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-00d3e9e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00d3e9e\" 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-495b86a\" data-id=\"495b86a\" 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-a0275fb elementor-widget elementor-widget-text-editor\" data-id=\"a0275fb\" 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=\"8\">\n<li>Adjuk ki a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+\u0150, \u00da, A)<\/em> vagy az <strong>Adatok \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+G, N)<\/em> parancsot!<\/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-59827a2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"59827a2\" 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-ee82656\" data-id=\"ee82656\" 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-1ec3566 elementor-widget elementor-widget-global elementor-global-17117 elementor-widget-text-editor\" data-id=\"1ec3566\" 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 \/>Tipikus feladat feliratokat \u00e9s\/vagy sz\u00e1m\u00edt\u00e1sokat tartalmaz\u00f3 t\u00e1bl\u00e1zatok adatsorainak rendez\u00e9se egy vagy t\u00f6bb oszlop szerint. Sokan elfelejtik a rendez\u00e9s el\u0151tt a megfelel\u0151 sorokat kijel\u00f6lni, teljesen \u00f6sszekeverve a sorokat. Ha azonnal lenyomjuk a <i>Ctrl+Z<\/i> billenty\u0171kombin\u00e1ci\u00f3t, meg nem t\u00f6rt\u00e9ntt\u00e9 tehetj\u00fck t\u00e9ved\u00e9s\u00fcnket, \u00e9s gyorsan elolvashatjuk a k\u00f6vetkez\u0151 bekezd\u00e9st, mit is kell ilyenkor tenn\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-fdfeb18 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fdfeb18\" 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-a9ee0fb\" data-id=\"a9ee0fb\" 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-f04c98f elementor-widget elementor-widget-global elementor-global-17149 elementor-widget-text-editor\" data-id=\"f04c98f\" 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> Ha egy t\u00e1bl\u00e1zat sorait rendezn\u00fcnk kell az egyik oszlop alapj\u00e1n, akkor csak a rendezni k\u00edv\u00e1nt adatokat tartalmaz\u00f3 tartom\u00e1nyt szabad kijel\u00f6ln\u00fcnk \u2013 ki kell hagynunk a k\u00e9pleteket, oszlopc\u00edmk\u00e9ket \u00e9s egy\u00e9b sz\u00e1rmaztatott adatokat tartalmaz\u00f3 cell\u00e1kat. Ezt szem el\u0151tt tartva, egy \u00f6sszef\u00fcgg\u0151 tartom\u00e1nyt fogunk kijel\u00f6lni.<br \/>Ha egy oszlop szerint kell rendezn\u00fcnk a sorokat, akkor a <i>Tab<\/i> billenty\u0171vel l\u00e9ptess\u00fck a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1t abba az oszlopba, amely szerint rendezni akarunk. Ezt k\u00f6vet\u0151en m\u00e1r haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s<\/strong> <i>(Alt+\u0150, \u00da)<\/i> men\u00fc vagy az <strong>Adatok \/Rendez\u00e9s \u00e9s sz\u0171r\u00e9s<\/strong><strong> csoport parancsait. Ha a helyi men\u00fct r\u00e9szes\u00edtj\u00fck el\u0151nyben, akkor a <i>Shift+F10<\/i> lenyom\u00e1s\u00e1t k\u00f6vet\u0151en a <\/strong><strong>Rendez\u00e9s<\/strong> almen\u00fc parancsaib\u00f3l v\u00e1logathatunk.<br \/>Ha t\u00f6bb oszlop szerint kell rendezn\u00fcnk, akkor m\u00e1r sz\u00fcks\u00e9g\u00fcnk lesz a <strong>Rendez\u00e9s<\/strong> (<i>Alt+\u0150, \u00da, E<\/i> vagy <i>Alt+G, R<\/i> vagy <i>Shift+F10, D, E<\/i>) p\u00e1rbesz\u00e9dablakra.<\/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-11bde52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"11bde52\" 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-c8d38b0\" data-id=\"c8d38b0\" 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-8afadce elementor-widget elementor-widget-text-editor\" data-id=\"8afadce\" 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=\"9\">\n<li>A k\u00f6vetkez\u0151 feladatunk az I oszlopban megjelen\u00edteni a n\u00f6v\u00e9nyek 2009-2013 \u00e9vekben import\u00e1lt mennyis\u00e9geinek \u00f6sszeg\u00e9t. Erre a SZUM f\u00fcggv\u00e9nyt fogjuk felhaszn\u00e1lni. A 2009 a D oszlop, a 2013 a H oszlop. Az I2 cell\u00e1ba teh\u00e1t a k\u00f6vetkez\u0151 k\u00e9plet ker\u00fcl majd: <strong>=SZUM(D2:H2)<\/strong><\/li>\n<li>El\u0151tte azonban g\u00e9pelj\u00fck be az I1 cell\u00e1ba az oszlop nev\u00e9t: \u00d6sszesen<\/li>\n<li>Jel\u00f6lj\u00fck ki az I2:I19 tartom\u00e1nyt!<\/li>\n<li>G\u00e9pelj\u00fck be a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba (I2) az <strong>=SZUM(D2:H2) <\/strong>k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171parancsot! Az Excel a k\u00e9pletet a tartom\u00e1ny minden cell\u00e1j\u00e1ba \u00e1tm\u00e1solja a relat\u00edv hivatkoz\u00e1snak k\u00f6sz\u00f6nhet\u0151en a megfelel\u0151 tartom\u00e1nyhivatkoz\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-2a4c3a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2a4c3a5\" 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-b733f1f\" data-id=\"b733f1f\" 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-001489a elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"001489a\" 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-1073058 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1073058\" 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-4cb8037\" data-id=\"4cb8037\" 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-dffe288 elementor-widget elementor-widget-text-editor\" data-id=\"dffe288\" 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=\"13\">\n<li>A J oszlopban a n\u00f6veked\u00e9s ar\u00e1ny\u00e1t kell kisz\u00e1molnunk 2012-re, a 2008-as \u00e9vhez viszony\u00edtva, teh\u00e1t sz\u00e1zal\u00e9k adatt\u00edpus\u00fa eredm\u00e9nyt v\u00e1runk. A feladat hasonl\u00edt az \u00c1FA kisz\u00e1m\u00edt\u00e1s\u00e1hoz, amikor rendelkez\u00e9s\u00fcnkre \u00e1ll a Brutt\u00f3, eset\u00fcnkben a 2012 \u00e9vi adat, valamint a nett\u00f3, vagyis a 2008 \u00e9vi adat. \u00cdgy m\u00e1r tudjuk is, milyen k\u00e9pletnek kell ker\u00fclnie a J2 cell\u00e1ba: 2012\/2008-1 vagy (2012\/2008-1)*100, att\u00f3l f\u00fcgg\u0151en, hogy sz\u00e1zal\u00e9kos vagy numerikus eredm\u00e9nyt v\u00e1runk el.<br \/>P\u00e9ld\u00e1ul, ha az eredm\u00e9ny 200%,akkor a n\u00f6veked\u00e9s 2008-hoz k\u00e9pest a 2008-as import mennyis\u00e9g\u00e9nek a k\u00e9tszerese, vagyis az eredm\u00e9ny a 2008-as \u00e9rt\u00e9k h\u00e1romszorosa lesz (2008 plusz a n\u00f6vekm\u00e9ny): \u00edgy lesz p\u00e9ld\u00e1ul a 32000 db-b\u00f3l 96000 darab. Ha negat\u00edv eredm\u00e9nyt kapunk, akkor 2012-ben a kisz\u00e1molt ar\u00e1nyban cs\u00f6kkent az import\u00e1lt mennyis\u00e9g 2008-hoz k\u00e9pest.<br \/>Miel\u0151tt tov\u00e1bbmenn\u00e9nk, el kell d\u00f6nten\u00fcnk, hogyan akarjuk az ar\u00e1nysz\u00e1mot megjelen\u00edteni a J oszlopban: ugyan a feladat nem \u00edrja el\u0151, de a n\u00f6veked\u00e9s ar\u00e1ny\u00e1t illik sz\u00e1zal\u00e9kos form\u00e1tumban megadni. A m\u00e1sik megold\u00e1s, hogy numerikusan adjuk meg, \u00e9s az oszlop fejl\u00e9c\u00e9ben jelen\u00edtj\u00fck meg a [%] m\u00e9rt\u00e9kegys\u00e9get, utalva arra, hogy az eredm\u00e9nyeket sz\u00e1zal\u00e9knak kell tekinteni. Ha net\u00e1n v\u00e1laszt\u00e1s el\u00e9 \u00e1ll\u00edtanak minket egy vizsg\u00e1n, akkor jobb, ha mindk\u00e9t megold\u00e1ssal tiszt\u00e1ban vagyunk:<br \/>Ha <strong>Sz\u00e1zal\u00e9k sz\u00e1mform\u00e1tumot akarunk alkalmazni<\/strong> a J oszlop cell\u00e1iban, akkor a J2 k\u00e9plete a k\u00f6vetkez\u0151 lesz: <strong>=G2\/C2-1<\/strong>, majd a cell\u00e1hoz hozz\u00e1rendelj\u00fck a <strong>Sz\u00e1zal\u00e9k<\/strong> sz\u00e1mform\u00e1tumot a <em>Ctrl+Shift+5<\/em> billenty\u0171paranccsal.<br \/>Ha az eredm\u00e9nyeket <strong>\u00c1ltal\u00e1nos sz\u00e1mform\u00e1tumban akarjuk hagyni<\/strong> a J oszlop cell\u00e1iban, akkor a J2 k\u00e9plete a k\u00f6vetkez\u0151 lesz: <strong>=(G2\/C2-1)*100<\/strong>, \u00e9s a J1 cell\u00e1ban t\u00fcntetj\u00fck fel a [%] m\u00e9rt\u00e9kegys\u00e9get.<\/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-47d8032 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"47d8032\" 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-d5fbd46\" data-id=\"d5fbd46\" 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-2a48269 elementor-widget elementor-widget-global elementor-global-17120 elementor-widget-text-editor\" data-id=\"2a48269\" 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> N\u00e9h\u00e1ny <strong>Sz\u00e1mform\u00e1tumot<\/strong> a k\u00f6vetkez\u0151 billenty\u0171kombin\u00e1ci\u00f3kkal tudunk gyorsan \u00e9s k\u00e9nyelmesen alkalmazni: <i>Ctrl+Shift+1<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> k\u00e9t tizedesjeggyel \u00e9s ezres tagol\u00e1ssal, <i>Ctrl+Shift+2<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> a cell\u00e1ban tal\u00e1lhat\u00f3 egyn\u00e9l kisebb tizedes t\u00f6rtet tartalmaz\u00f3 \u00e9rt\u00e9k \u00f3ra:perc form\u00e1tumra alak\u00edt\u00e1s\u00e1val, <i>Ctrl+Shift+3<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> a cell\u00e1ban tal\u00e1lhat\u00f3 \u00e9rt\u00e9k nn.hhh.\u00e9\u00e9 form\u00e1tumra alak\u00edt\u00e1s\u00e1val, <i>Ctrl+Shift+4<\/i> \u2013 form\u00e1z\u00e1s <strong>P\u00e9nznem Sz\u00e1mform\u00e1tumra<\/strong> k\u00e9t tizedesjeggyel \u00e9s ezres tagol\u00e1ssal (negat\u00edv \u00e9rt\u00e9k eset\u00e9n piros bet\u0171sz\u00ednnel), <i>Ctrl+Shift+5<\/i> \u2013 form\u00e1z\u00e1s <strong>Sz\u00e1zal\u00e9k Sz\u00e1mform\u00e1tumra<\/strong> tizedesjegyek n\u00e9lk\u00fcl eg\u00e9szre kerek\u00edt\u00e9ssel.<\/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-e7da412 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e7da412\" 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-5b362b8\" data-id=\"5b362b8\" 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-dfd175d elementor-widget elementor-widget-text-editor\" data-id=\"dfd175d\" 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=\"14\">\n<li>A k\u00e9t megold\u00e1s k\u00f6z\u00f6tt k\u00f6nny\u0171 v\u00e1lasztani, mi most az <strong>\u00c1ltal\u00e1nos <\/strong>sz\u00e1mform\u00e1tum alkalmaz\u00e1s\u00e1t mutatjuk be: g\u00e9pelj\u00fck be a J1 cell\u00e1ba a k\u00f6vetkez\u0151 feliratot: 2012\/2008 n\u00f6v. ar\u00e1ny [%]<\/li>\n<li>Jel\u00f6lj\u00fck ki a J2:J19 tartom\u00e1nyt!<\/li>\n<li>A J2 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=(G2\/C2-1)*100<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A K oszlopban a 2013-as \u00e9vi import 10,5%-al n\u00f6velt \u00e9rt\u00e9k\u00e9t kell megjelen\u00edteni, ez lesz a tervezett 2014 \u00e9vi importmennyis\u00e9g. Itt brutt\u00f3t sz\u00e1molunk nett\u00f3b\u00f3l, az \u00c1FA 10,5%: =2013*(1+10,5%) vagy =2013*1,105. A K2 cell\u00e1ba teh\u00e1t a k\u00f6vetkez\u0151 k\u00e9pletek egyike ker\u00fclhet: <strong>=G2*(1+10,5%)<\/strong> vagy <strong>=G2*1,105<\/strong> vagy <strong>=G2*(1+10,5\/100)<\/strong> vagy <strong>=G2*(1+0,105)<\/strong><\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t a K1 cell\u00e1ra, majd adjunk nevet az oszlopnak: 2014<\/li>\n<li>Jel\u00f6lj\u00fck ki a K2:K19 tartom\u00e1nyt!<\/li>\n<li>A K2 cell\u00e1ba g\u00e9pelj\u00fck be a fenti k\u00e9pletek egyik\u00e9t, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>Jel\u00f6lj\u00fck ki a B2:H19 tartom\u00e1nyt!<\/li>\n<li>A f\u00e9lk\u00f6v\u00e9r bet\u0171st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz \u00fcss\u00fck le a <em>Ctrl+B<\/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-42b8681 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"42b8681\" 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-54e2884\" data-id=\"54e2884\" 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-602e363 elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"602e363\" 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-6fe3321 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fe3321\" 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-ccfba92\" data-id=\"ccfba92\" 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-f3c317e elementor-widget elementor-widget-text-editor\" data-id=\"f3c317e\" 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=\"23\">\n<li>\u00c1ll\u00edtsuk be a <strong>Vil\u00e1gosk\u00e9k <\/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! A paletta <strong>Alapsz\u00ednek<\/strong> r\u00e9sz\u00e9ben a hetedik a <strong>Vil\u00e1gosk\u00e9k <\/strong>sz\u00edn, amit a ny\u00edlbillenty\u0171kkel l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li>\n<li>Jel\u00f6lj\u00fck ki a B2:K19 tartom\u00e1nyt!<\/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\u00f6vetkez\u0151 feladat, hogy az M1 cell\u00e1ba beg\u00e9pelj\u00fck, hogyan jelen\u00edthetj\u00fck meg a nyomtat\u00e1si k\u00e9pet: egyszer\u0171en g\u00e9pelj\u00fck be a cell\u00e1ba a Ctrl+P sz\u00f6veget!<\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t az L1 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 feliratot: \u00c1tlag<\/li>\n<li>Jel\u00f6lj\u00fck ki az L2:L19 tartom\u00e1nyt, hogy minden n\u00f6v\u00e9nyn\u00e9l \u00e1tlagolhassuk a 2007-2010 \u00e9vek import mennyis\u00e9geket!<\/li>\n<li>G\u00e9pelj\u00fck be a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba (L2) a k\u00f6vetkez\u0151 k\u00e9pletet:<br \/><strong>=\u00c1TLAG(B2:E2)<\/strong>. A k\u00e9sz t\u00e1bl\u00e1zatot mutatja az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_1_Tablazat.jpg\" target=\"_blank\" rel=\"noopener\">1. \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-4197ea2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4197ea2\" 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-db2f672\" data-id=\"db2f672\" 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-4951f78 elementor-widget elementor-widget-text-editor\" data-id=\"4951f78\" 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 \/>K\u00f6vetkez\u0151 feladatunk csoportos\u00edtott oszlopdiagram k\u00e9sz\u00edt\u00e9se a 2007-2009 \u00e9vekb\u0151l. A diagramon az \u00e9vsz\u00e1mokat is fel kell t\u00fcntetn\u00fcnk az adatsorok oszlopai alatt a kateg\u00f3riatengelyen (X-tengely). Azonban egy diagram k\u00e9sz\u00edt\u00e9se el\u0151tt mindig meg kell gy\u0151z\u0151dn\u00fcnk arr\u00f3l, hogy a kateg\u00f3riatengelyen megjelen\u00edteni k\u00edv\u00e1nt \u00e9rt\u00e9kek adatt\u00edpusa igazodik-e a kiv\u00e1lasztott diagramhoz. Ugyanis a mi eset\u00fcnkben ezek \u00e9vsz\u00e1mok, numerikus adatok, amit az is bizony\u00edt, hogy a cell\u00e1kban jobbra z\u00e1rtak. Ez pedig megzavarhatja az Excelt, ha kateg\u00f3riatengelyen megjelen\u0151 adatnak jel\u00f6lj\u00fck ki ezeket a cell\u00e1kat, ami hib\u00e1s adatmegjelen\u00edt\u00e9st eredm\u00e9nyez, az \u00e9vsz\u00e1mok helyett sorsz\u00e1mok jelennek meg \u2013 tapasztalataink szerint Excel verzi\u00f3t\u00f3l f\u00fcgg ez a jelens\u00e9g (tal\u00e1n szoftverhiba).<br \/>A megold\u00e1s a sz\u00e1mok sz\u00f6vegg\u00e9 alak\u00edt\u00e1sa. Azonban az \u00e9vsz\u00e1mokat hi\u00e1ba alak\u00edtjuk \u00e1t a Sz\u00f6veg form\u00e1tumk\u00f3ddal, ez nem el\u00e9g: az \u00e9vsz\u00e1mokat ki kell eg\u00e9sz\u00edten\u00fcnk egy karakterrel, amire mi a pontot javasoljuk.<\/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-0b434f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b434f5\" 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-8e10553\" data-id=\"8e10553\" 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-f1a8efa elementor-widget elementor-widget-text-editor\" data-id=\"f1a8efa\" 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>Helyezz\u00fck az akt\u00edv cell\u00e1t a B1-re, majd jav\u00edtsuk \u00e1t a 2007 \u00e9vet 2007.-re <em>(F2, ., Tab)<\/em>!<\/li>\n<li>Ism\u00e9telj\u00fck meg az el\u0151z\u0151 l\u00e9p\u00e9ssort a rend kedv\u00e9\u00e9rt minden \u00e9vsz\u00e1mot tartalmaz\u00f3 cell\u00e1ban (C1:H1 \u00e9s K1) pontot illesztve minden \u00e9vsz\u00e1m m\u00f6g\u00e9!<\/li>\n<li>Egy csoportos\u00edtott oszlopdiagramot kell k\u00e9sz\u00edten\u00fcnk a munkalapra a 2007-2009 \u00e9vekb\u0151l (B:D oszlopok) k\u00e9t n\u00f6v\u00e9ny, az Indiai mang\u00f3 (4. sor) \u00e9s a Mexik\u00f3i narancsvir\u00e1g (13. sor) adataib\u00f3l. A kateg\u00f3riatengely feliratait az A1:D1 tartom\u00e1ny adja, az Indiai mang\u00f3 \u00e9rt\u00e9ksor\u00e1t a n\u00f6v\u00e9ny nev\u00e9vel \u00e9s a h\u00e1rom \u00e9vvel egy\u00fctt az A4:D4 tartom\u00e1nyban tal\u00e1ljuk, a Mexik\u00f3i narancsvir\u00e1g \u00e9rt\u00e9ksora pedig a n\u00f6v\u00e9ny nev\u00e9vel \u00e9s a h\u00e1rom \u00e9vvel egy\u00fctt az A13:D13 tartom\u00e1nyban van. A\u00a0kijel\u00f6lend\u0151 tartom\u00e1nyok teh\u00e1t a k\u00f6vetkez\u0151k: A1:D1;A4:D4;A13:D13<\/li>\n<li>Az <em>F5<\/em> seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A1:D1;A4:D4;A13:D13 tartom\u00e1nyokat!<\/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-ccc672c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ccc672c\" 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-43c312b\" data-id=\"43c312b\" 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-f1c0dc8 elementor-widget elementor-widget-text-editor\" data-id=\"f1c0dc8\" 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> Amikor a diagramon megjelen\u00edtend\u0151 \u00e9rt\u00e9kek k\u00f6r\u00e9t meghat\u00e1rozzuk, \u00e1t kell gondolnunk, mely tartom\u00e1nyt kell kijel\u00f6ln\u00fcnk a diagram l\u00e9trehoz\u00e1sa el\u0151tt. T\u00f6bbnyire nem csak az \u00e9rt\u00e9keket, hanem az oszlopok, illetve sorok c\u00edmk\u00e9it is l\u00e1ttatni akarjuk a diagramon, \u00edgy ezeket is ki kell jel\u00f6ln\u00fcnk. Egyszer\u0171 esetben ez \u00e1ltal\u00e1ban a teljes t\u00e1bl\u00e1zat kijel\u00f6l\u00e9s\u00e9t jelenti.<br \/>Igen \u00e1m, de mi a helyzet akkor, mint a mostani feladatban is, ha ki kell hagynunk egy vagy t\u00f6bb sort \u00e9s\/vagy oszlopot \u2013 ebben a feladatban a 2:3 \u00e9s az 5:12 sorokat.<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve az A1:D1;A4:D4;A13:D13 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcletet, l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek val\u00f3ban egy folytonos t\u00e9glalapot mint\u00e1znak.<\/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-32fe86f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32fe86f\" 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-6b9d758\" data-id=\"6b9d758\" 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-0ddc786 elementor-widget elementor-widget-text-editor\" data-id=\"0ddc786\" 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=\"35\">\n<li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Oszlop- \u00e9s s\u00e1vdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, \u00da)<\/em> parancsot, majd a megjelen\u0151 palett\u00e1n keress\u00fck meg a <strong>Csoportos\u00edtott oszlop<\/strong> t\u00edpust \u00e9s v\u00e1lasszuk ki! Az Excel besz\u00farja a diagramot a munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9re \u00e9s kijel\u00f6li azt.<\/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-691592c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"691592c\" 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-2ebcc4d\" data-id=\"2ebcc4d\" 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-ac77d67 elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"ac77d67\" 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 diagram beilleszt\u00e9s\u00e9t k\u00f6vet\u0151en annak szerkeszt\u00e9s\u00e9hez kapunk egy <strong>Diagrameszk\u00f6z\u00f6k \/ Diagramtervez\u00e9s <\/strong><i>(Alt+JC)<\/i> \u00e9s egy <strong>Diagrameszk\u00f6z\u00f6k \/\u00a0<\/strong><strong>Form\u00e1tum<\/strong> <i>(Alt+JZ)<\/i> nev\u0171 men\u00fcszalag f\u00fclet. Term\u00e9szetesen rendelkez\u00e9s\u00fcnkre \u00e1ll a <i>Shift+F10<\/i>-el el\u00e9rhet\u0151 helyi men\u00fc is.<\/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-0ee1ea4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ee1ea4\" 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-267a535\" data-id=\"267a535\" 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-35a9054 elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"35a9054\" 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\u00e9p, \u00e9s m\u00e1s grafikus elem, mint p\u00e9ld\u00e1ul a diagram, \u00fagynevezett lebeg\u0151 objektumk\u00e9nt a munkalap cell\u00e1i felett, azokat eltakarva helyezkedik el. Egy lebeg\u0151 objektumot \u00fagy tudunk kijel\u00f6lni, illetve t\u00f6bb objektum eset\u00e9n k\u00f6z\u00fcl\u00fck v\u00e1lasztani, ha kiadjuk a <strong>Kezd\u0151lap \/ Keres\u00e9s \u00e9s kijel\u00f6l\u00e9s \/ Objektumok kijel\u00f6l\u00e9se<\/strong> <i>(Alt+\u0150, \u00d6E, O)<\/i> parancsot. Az Excel kijel\u00f6ltt\u00e9 teszi az els\u0151 objektumot, majd a <i>Tab<\/i> \u00e9s <i>Shift+Tab<\/i> billenty\u0171kombin\u00e1ci\u00f3kkal r\u00e1nk b\u00edzza a kezelni k\u00edv\u00e1nt objektum kijel\u00f6l\u00e9s\u00e9t. A munkalap cell\u00e1ihoz az <i>Esc<\/i> billenty\u0171 le\u00fct\u00e9s\u00e9vel t\u00e9rhet\u00fcnk vissza.<\/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-fc336a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fc336a8\" 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-2870ea6\" data-id=\"2870ea6\" 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-ada75b2 elementor-widget elementor-widget-text-editor\" data-id=\"ada75b2\" 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=\"36\">\n<li>A diagram eltakarhatja a t\u00e1bl\u00e1zatot, ami nagyon zavar\u00f3 lehet. Helyezz\u00fck \u00e1t p\u00e9ld\u00e1ul az A25 cell\u00e1ba: \u00fcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd l\u00e9ptess\u00fck az akt\u00edv cell\u00e1t az A25 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/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-e848e98 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e848e98\" 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-a3ab0f1\" data-id=\"a3ab0f1\" 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-1d02caa elementor-widget elementor-widget-global elementor-global-16948 elementor-widget-text-editor\" data-id=\"1d02caa\" 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> Ha feladatunk egy diagram besz\u00far\u00e1sa az aktu\u00e1lis munkalapra, akkor az t\u00f6bbnyire eltakarja a t\u00e1bl\u00e1zatot. Ez\u00e9rt c\u00e9lszer\u0171 sz\u00e1m\u00e1ra m\u00e1sik helyet keresni, p\u00e9ld\u00e1ul a t\u00e1bl\u00e1zat alatt: a <em>Ctrl+X<\/em> le\u00fct\u00e9s\u00e9vel helyezz\u00fck a V\u00e1g\u00f3lapra a diagramot, majd a visszakapott akt\u00edv cell\u00e1t mozgassuk a diagram bal fels\u0151 sark\u00e1nak helyet ad\u00f3 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t! A diagram kijel\u00f6lt \u00e1llapotban marad.<br \/>Persze, ha a vizsg\u00e1n ezt nem k\u00e9rik, vagy kifejezetten tiltj\u00e1k, akkor hagyjuk ki ezt a l\u00e9p\u00e9st.<\/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-1cabc63 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1cabc63\" 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-fb1f786\" data-id=\"fb1f786\" 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-b894694 elementor-widget elementor-widget-text-editor\" data-id=\"b894694\" 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>V\u00e1lasszuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ A diagram felett <\/strong>parancsot <em>(Alt+JC, D, C, A)<\/em>! Ezzel a c\u00edmet a diagram f\u00f6l\u00e9, k\u00f6z\u00e9pre helyezz\u00fck, egyben kijel\u00f6ltt\u00e9 tessz\u00fck azt a szerkeszt\u00e9shez.<\/li>\n<li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be az Indiai mang\u00f3 \u00e9s narancsvir\u00e1g importja c\u00edmet, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>V\u00e1lasszuk ki a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Tengelyc\u00edmek \/ Els\u0151dleges f\u00fcgg\u0151leges <\/strong>parancsot <em>(Alt+JC, D, M, E)<\/em>! Ezzel az \u00e9rt\u00e9ktengely c\u00edm\u00e9t megjelen\u00edtj\u00fck a tengelyt\u0151l balra, egyben kijel\u00f6ltt\u00e9 tessz\u00fck azt a szerkeszt\u00e9shez.<\/li>\n<li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be a db feliratot, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A f\u00fcgg\u0151leges \u00e9rt\u00e9ktengely feliratainak f\u00e9lk\u00f6v\u00e9r bet\u0171st\u00edlus\u00e1nak be\u00e1ll\u00edt\u00e1s\u00e1hoz el\u0151sz\u00f6r jel\u00f6lj\u00fck ki azt: keress\u00fck meg a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> kombin\u00e1lt listamez\u0151t, g\u00f6rd\u00edts\u00fck le, \u00e1lljunk r\u00e1 a <strong>F\u00fcgg\u0151leges (\u00c9rt\u00e9k) tengely<\/strong> elemre, v\u00e9g\u00fcl v\u00e1lasszuk ki az <em>Enter <\/em>billenty\u0171vel!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171parancsot a f\u00e9lk\u00f6v\u00e9r bet\u0171st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz! Az elk\u00e9sz\u00fclt diagramot mutatja a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_2_Diagram.jpg\" target=\"_blank\" rel=\"noopener\">2. \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-8f132f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f132f4\" 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-4ff37d8\" data-id=\"4ff37d8\" 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-ac6b051 elementor-widget elementor-widget-text-editor\" data-id=\"ac6b051\" 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 feladat, hogy weblapk\u00e9nt (HTML f\u00e1jlform\u00e1tum, *.htm vagy *.html f\u00e1jlkiterjeszt\u00e9s) k\u00e9sz\u00edts\u00fcnk ment\u00e9st a t\u00e1bl\u00e1zat k\u00e9t tartom\u00e1ny\u00e1r\u00f3l. Az Excel a weblap form\u00e1tumban ment\u00e9st <strong>k\u00f6zz\u00e9t\u00e9telnek<\/strong> h\u00edvja. Ehhez kapunk egy <strong>K\u00f6zz\u00e9t\u00e9tel weblapk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dpanelt, amelyben \u2013 t\u00f6bbek k\u00f6z\u00f6tt \u2013 el\u0151\u00edrhatjuk, hogy a munkaf\u00fczet mely r\u00e9sz\u00e9b\u0151l akarunk weblapot k\u00e9sz\u00edteni: ez lehet a teljes munkaf\u00fczet, egy kiv\u00e1lasztott munkalap, vagy kijel\u00f6lt tartom\u00e1ny. S\u0151t, am\u00edg dolgozunk a munkaf\u00fczettel, megjegyzi \u00e9s v\u00e1laszt\u00e1sra k\u00edn\u00e1lja fel a kor\u00e1bban mentett weblapokat is.<br \/><strong>Fontos felt\u00e9tel, hogy cellatartom\u00e1ny k\u00f6zz\u00e9t\u00e9tele eset\u00e9n annak folytonosnak kell lennie<\/strong>, teh\u00e1t nem tartalmazhat rejtett cell\u00e1kat, sorokat, oszlopokat, nem adhatunk meg t\u00f6bb tartom\u00e1nyt. Ennek k\u00f6vetkezt\u00e9ben el\u0151fordulhat, hogy k\u00f6zz\u00e9t\u00e9tel el\u0151tt egy \u00faj munkalapra, vagy a munkalap egy m\u00e1sik r\u00e9sz\u00e9re kell kigy\u0171jten\u00fcnk a nem szomsz\u00e9dos tartom\u00e1nyokat, egy \u00f6sszef\u00fcgg\u0151 tartom\u00e1nyt alkotva bel\u0151l\u00fck.<br \/>A mostani feladat ezt most nem v\u00e1rja el t\u0151l\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-a655570 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a655570\" 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-b0654c0\" data-id=\"b0654c0\" 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-d73d5ea elementor-widget elementor-widget-text-editor\" data-id=\"d73d5ea\" 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=\"43\">\n<li>A n\u00f6v\u00e9nyek nev\u00e9t \u00e9s a 2007 \u00e9vet tartalmaz\u00f3 A1:B19 tartom\u00e1nyt kell weblapk\u00e9nt menten\u00fcnk a megadott n\u00e9ven az el\u0151\u00edrt mapp\u00e1ba. Mi a munkaf\u00fczet mapp\u00e1j\u00e1ban a munkaf\u00fczet nev\u00e9vel fogjuk l\u00e9trehozni a HTM f\u00e1jlt a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> funkci\u00f3 seg\u00edts\u00e9g\u00e9vel: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel az A1:B19 tartom\u00e1nyt!<\/li>\n<li>\u00dcss\u00fck le az <em>F12<\/em> funkci\u00f3billenty\u0171t! A k\u00e9perny\u0151n megjelenik a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak. A f\u00f3kusz a <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151n \u00e1ll, amelyben a munkaf\u00fczet nev\u00e9t l\u00e1tjuk \u2013 ezt el is fogadhatjuk.<\/li>\n<li>L\u00e9pj\u00fcnk tov\u00e1bb a <em>Tab<\/em> seg\u00edts\u00e9g\u00e9vel a <strong>F\u00e1jl t\u00edpusa<\/strong> kombin\u00e1lt listamez\u0151re!<\/li>\n<li>Jel\u00f6lj\u00fck ki a <strong>Weblap (*.htm;*.html)<\/strong> elemet, p\u00e9ld\u00e1ul a <em>W<\/em> billenty\u0171 le\u00fct\u00e9s\u00e9vel!<\/li>\n<li>L\u00e9pj\u00fcnk tov\u00e1bb a <em>Tab<\/em> billenty\u0171vel a <strong>Ment\u00e9s<\/strong> v\u00e1laszt\u00f3gombig, amelyn\u00e9l a <strong>Teljes munkaf\u00fczet<\/strong> t\u00e9tel van kijel\u00f6lve. Nek\u00fcnk <strong>A kijel\u00f6lt: $A$1:$B$19<\/strong> v\u00e1laszt\u00f3gombra van sz\u00fcks\u00e9g\u00fcnk, amellyel a kijel\u00f6lt tartom\u00e1ny ment\u00e9s\u00e9t tudjuk el\u0151\u00edrni: v\u00e1lasszuk ki azt a <em>Le ny\u00edlbillenty\u0171vel<\/em>!<\/li>\n<li>Megadtunk minden sz\u00fcks\u00e9ges adatot, \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel weblapk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak. A f\u00f3kusz a\u00a0<strong>V\u00e1laszt\u00e1s<\/strong> kombin\u00e1lt listamez\u0151n van, amelyben a <strong>Cellatartom\u00e1ny<\/strong> elem a kijel\u00f6lt. Az alatta elhelyezked\u0151 kombin\u00e1lt szerkeszt\u0151mez\u0151ben pedig a tartom\u00e1ny c\u00edm\u00e9t tal\u00e1ljuk: =&#8217;M4-6&#8242;!$A$1:$B$19.<\/li>\n<li>Ha a k\u00f6zz\u00e9t\u00e9telt k\u00f6vet\u0151en azonnal meg akarjuk jelen\u00edteni a weboldalt egy b\u00f6ng\u00e9sz\u0151ben, akkor keress\u00fck meg <strong>A weblap megnyit\u00e1sa a b\u00f6ng\u00e9sz\u0151vel<\/strong> <em>(Alt+W)<\/em> jel\u00f6l\u0151n\u00e9gyzetet, \u00e9s kapcsoljuk be. Mi is ezt tessz\u00fck, hogy l\u00e1ssuk, bemutathassuk az eredm\u00e9nyt.<\/li>\n<li>\u00dcss\u00fck le az <em>Enter<\/em> billenty\u0171t vagy v\u00e1lasszuk ki a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> <em>(Alt+K)<\/em> gombot! Elindul az alap\u00e9rtelmezett b\u00f6ng\u00e9sz\u0151, megnyitva a mentett weboldalt. A c\u00edms\u00e1vban <em>(Ctrl+L)<\/em> megtal\u00e1ljuk a HTM f\u00e1jl teljes el\u00e9r\u00e9si \u00fatvonal\u00e1t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_3_HTM.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-d752059 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d752059\" 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-6b83182\" data-id=\"6b83182\" 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-5d9de31 elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"5d9de31\" 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 oper\u00e1ci\u00f3s rendszer \u00e9s az Excel kor\u00e1bbi haszn\u00e1lat\u00e1t\u00f3l f\u00fcgg\u0151en vagy azonnal megjelenik a tartalom az alap\u00e9rtelmezett PDF olvas\u00f3 alkalmaz\u00e1sban, vagy el\u0151tte r\u00e1k\u00e9rdez a Windows, hogy melyik alkalmaz\u00e1ssal akarjuk azt megnyitni. Ut\u00f3bbi esetben \u2013 ha m\u00e1s PDF olvas\u00f3 alkalmaz\u00e1s nincs telep\u00edtve \u2013, a Microsoft Edge b\u00f6ng\u00e9sz\u0151t k\u00edn\u00e1lja fel, amit egy <i>Enter<\/i> le\u00fct\u00e9ssel el is fogadhatunk.<\/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-82e6bb4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"82e6bb4\" 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-b70061e\" data-id=\"b70061e\" 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-4618e1f elementor-widget elementor-widget-text-editor\" data-id=\"4618e1f\" 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=\"52\">\n<li>Z\u00e1rjuk be a b\u00f6ng\u00e9sz\u0151t, \u00e9s t\u00e9rj\u00fcnk vissza a munkaf\u00fczet M4-6 munkalapj\u00e1hoz!<\/li>\n<li>Az M oszlopban minden n\u00f6v\u00e9ny eset\u00e9ben meg kell vizsg\u00e1lnunk, hogy a 2011-es import (F oszlop) legal\u00e1bb h\u00e9tszerese-e a 2007-ben (B oszlop) import\u00e1lt mennyis\u00e9gnek. Ha igen, akkor az adott sorban egy felki\u00e1lt\u00f3jelet kell megjelen\u00edten\u00fcnk, ha kisebb, akkor semmit. A megold\u00e1s a HA f\u00fcggv\u00e9ny haszn\u00e1lata, amelynek els\u0151 argumentumak\u00e9nt kell megadnunk a felt\u00e9telt, ami az M2 cella k\u00e9plet\u00e9ben a k\u00f6vetkez\u0151 lesz: F2&gt;=B2*7. Az\u00e9rt haszn\u00e1ljuk a nagyobb vagy egyenl\u0151 rel\u00e1ci\u00f3s oper\u00e1tort, mert a feladatban a &#8222;legal\u00e1bb&#8221; sz\u00f3 szerepel, ami azt jelenti, hogy vagy h\u00e9tszeres vagy ann\u00e1l nagyobb mennyis\u00e9g megl\u00e9t\u00e9t kell vizsg\u00e1lnunk.<br \/>Ha az el\u0151bbi felt\u00e9tel IGAZ eredm\u00e9nyt ad, akkor a HA f\u00fcggv\u00e9ny m\u00e1sodik argumentuma a &#8222;!&#8221;, ha HAMIS, akkor a harmadik argumentuma egy \u00fcres karakterl\u00e1nc, a &#8222;&#8221; kell legyen.<br \/>\u00c1ll\u00edtsuk \u00f6ssze a k\u00e9pletet az M2 cella sz\u00e1m\u00e1ra: <strong>=HA(F2&gt;B2*7;&#8221;!&#8221;;&#8221;&#8221;)<\/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-1d5190f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d5190f\" 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-6fb9347\" data-id=\"6fb9347\" 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-d4fb709 elementor-widget elementor-widget-global elementor-global-17165 elementor-widget-text-editor\" data-id=\"d4fb709\" 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> Ha egy feladat a semmi megjelen\u00edt\u00e9s\u00e9t \u00edrja el\u0151, akkor mindig egy \u00fcres karakterl\u00e1ncot kell megadnunk k\u00e9t id\u00e9z\u0151jellel: &#8222;&#8221; <i>(Shift+2, Shift+2)<\/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-5356666 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5356666\" 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-97d2047\" data-id=\"97d2047\" 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-4c736c0 elementor-widget elementor-widget-text-editor\" data-id=\"4c736c0\" 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=\"54\">\n<li>Az M1 cell\u00e1ba most nem tudunk oszlopazonos\u00edt\u00f3t g\u00e9pelni, mert a 7. feladat miatt m\u00e1r nem \u00fcres a cella.<\/li>\n<li>Jel\u00f6lj\u00fck ki az M2:M19 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1ny akt\u00edv cell\u00e1ja az M2, amibe g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet:<br \/><strong>=HA(F2&gt;B2*7;&#8221;!&#8221;;&#8221;&#8221;)<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! N\u00e9gy felki\u00e1lt\u00f3jeles cell\u00e1t kell kapnunk eredm\u00e9ny\u00fcl.<\/li>\n<li>Az <em>F5 <\/em>funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A1:E21 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1nyt 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>\u00a0<em>(Alt+N) <\/em>v\u00e1laszt\u00f3gombot, majd az <strong>OK<\/strong> gombot!<\/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-a0ed5fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a0ed5fc\" 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-41b5ec8\" data-id=\"41b5ec8\" 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-b9644d4 elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"b9644d4\" 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 pap\u00edrtakar\u00e9koss\u00e1g jegy\u00e9ben, valamint az elt\u00e9r\u0151 nyomtat\u00e1si k\u00f6rnyezetek miatt mi a gyakorlatok sor\u00e1n a nyomtat\u00e1si k\u00e9r\u00e9seket PDF exporttal helyettes\u00edtj\u00fck, term\u00e9szetesen az esetlegesen el\u0151\u00edrt oldalbe\u00e1ll\u00edt\u00e1sokkal. Aki tov\u00e1bbra is nyomtatni akar, az a <i>Ctrl+P<\/i>-vel ind\u00edthatja a <strong>F\u00e1jl \/ Nyomtat\u00e1s<\/strong> parancsot <i>(Alt+F, P)<\/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-1692b13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1692b13\" 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-4f663c8\" data-id=\"4f663c8\" 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-c93e7ee elementor-widget elementor-widget-text-editor\" data-id=\"c93e7ee\" 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=\"61\">\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><em>(Alt+F, E, A) <\/em>gombot!<\/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> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben l\u00e1tjuk a munkaf\u00fczet nev\u00e9t, amit el is fogadhatunk: ments\u00fcnk a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> gombot v\u00e1lasztva!<\/li>\n<li>Ha sz\u00e1m\u00edt\u00f3g\u00e9p\u00fcnk\u00f6n van PDF kezel\u0151 alkalmaz\u00e1s vagy b\u00f6ng\u00e9sz\u0151, akkor azt az Excel megpr\u00f3b\u00e1lja elind\u00edtani \u00e9s megjelen\u00edteni a f\u00e1jl tartalm\u00e1t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_4_PDF.jpg\" target=\"_blank\" rel=\"noopener\">(4. \u00e1bra)<\/a>.<\/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-0f5273f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f5273f\" 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-cf6fc71\" data-id=\"cf6fc71\" 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-64317b1 elementor-widget elementor-widget-text-editor\" data-id=\"64317b1\" 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 megold\u00e1sa sor\u00e1n 3 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet, egy HTML weblapot, valamint egy PDF dokumentumot <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/189-K-ECDLM04S6-Vizsgafeladat6_Megoldas1_5_Fajlok.jpg\" target=\"_blank\" rel=\"noopener\">(5. \u00e1bra)<\/a>.<\/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-654b442 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"654b442\" 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-f00dac1\" data-id=\"f00dac1\" 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-5c58c98 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"5c58c98\" 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-3a3705f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3a3705f\" 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-a425c32\" data-id=\"a425c32\" 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-608c9af elementor-widget elementor-widget-text-editor\" data-id=\"608c9af\" 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>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 \u00e1prilis 3.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (21H2, 2111b19044)<br \/>Irodai programcsomag: Microsoft Office 2016 v2206b15330.20266, Aktu\u00e1lis csatorna<br \/>Szint: kezd\u0151, ECDL modul\/tanmenet: T\u00e1bl\u00e1zatkezel\u00e9s\/S6<br \/>Kateg\u00f3ria: ECDL \u2192 T\u00e1bl\u00e1zatkezel\u00e9s \u2192 Vizsgafeladatok<\/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-09b7428 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"09b7428\" 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-2c1ee83\" data-id=\"2c1ee83\" 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-dfe8ae3 elementor-widget elementor-widget-shortcode\" data-id=\"dfe8ae3\" 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--2762 \"        data-post-id=\"2762\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2762\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2762\">                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-5150683 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5150683\" 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-7ae5794\" data-id=\"7ae5794\" 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-c616d88 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=\"c616d88\" 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: 2022 j\u00falius 23. Mir\u0151l sz\u00f3l ez a cikk?Ebben a l\u00e1t\u00e1ss\u00e9r\u00fcltek sz\u00e1m\u00e1ra k\u00e9sz\u00fclt Microsoft Excel oktat\u00f3anyagban az ECDL T\u00e1bl\u00e1zatkezel\u00e9s modulhoz kiadott Vizsgap\u00e9ldat\u00e1r 6. feladat\u00e1t dolgozzuk fel a Windows 10 oper\u00e1ci\u00f3s rendszer \u00e9s a Microsoft Office 2016 irodai alkalmaz\u00e1scsomag aktu\u00e1lis kiad\u00e1s\u00e1nak felhaszn\u00e1l\u00e1s\u00e1val.A vizsgafeladat megold\u00e1sa sor\u00e1n kiz\u00e1r\u00f3lag a billenty\u0171zetet haszn\u00e1ljuk. Tartalomjegyz\u00e9k Felhaszn\u00e1lt \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2762\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":25217,"parent":2642,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-2762","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2762","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=2762"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2762\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2642"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/media\/25217"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}