{"id":5049,"date":"2020-06-13T21:09:09","date_gmt":"2020-06-13T19:09:09","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=5049"},"modified":"2022-08-07T16:56:40","modified_gmt":"2022-08-07T14:56:40","slug":"ecdl-tablazatkezeles-16-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=5049","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 16. vizsgafeladat (#218\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"5049\" class=\"elementor elementor-5049\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ec2835 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ec2835\" 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-68bc445\" data-id=\"68bc445\" 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-98845aa elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"98845aa\" 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 25.<\/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-9edaf21 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9edaf21\" 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-a1599d7\" data-id=\"a1599d7\" 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-0b66ba1 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"0b66ba1\" 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-f98b4f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f98b4f5\" 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-0cd7f9d\" data-id=\"0cd7f9d\" 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-426ccc2 elementor-widget elementor-widget-text-editor\" data-id=\"426ccc2\" 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 16. 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-a783f3e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a783f3e\" 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-4ebb425\" data-id=\"4ebb425\" 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-6b9e279 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"6b9e279\" 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__6b9e279\" 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__6b9e279\" 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__6b9e279\" 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-cd51d0c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd51d0c\" 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-160a20d\" data-id=\"160a20d\" 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-8ba6591 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8ba6591\" 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\/06\/218-K-ECDLM04S6-Vizsgafeladat16.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 16. 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-50347cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50347cb\" 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-2b29829\" data-id=\"2b29829\" 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-b50822a elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"b50822a\" 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-75684f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"75684f6\" 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-262ace8\" data-id=\"262ace8\" 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-ffe3806 elementor-widget elementor-widget-text-editor\" data-id=\"ffe3806\" 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\/06\/218-K-ECDLM04S6-Vizsgafeladat16.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-2939912 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2939912\" 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-f420705\" data-id=\"f420705\" 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-b85cd98 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b85cd98\" 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>adatr\u00f6gz\u00edt\u00e9s, akt\u00edv cella \u00e1thelyez\u00e9se, diagram k\u00e9sz\u00edt\u00e9s \u00e9s form\u00e1z\u00e1s, export\u00e1l\u00e1s PDF form\u00e1tumban, k\u00e9plet sokszoros\u00edt\u00e1sa, k\u00e9pletk\u00e9sz\u00edt\u00e9s, k\u00fcls\u0151 hivatkoz\u00e1s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, munkalap kezel\u00e9se, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, sorba rendez\u00e9s, t\u00e1bl\u00e1zat form\u00e1z\u00e1s, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, HA, <a href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MAX<\/a>, SZUM.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b0c1cb2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b0c1cb2\" 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-4ca63b1\" data-id=\"4ca63b1\" 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-44a1013 elementor-widget elementor-widget-text-editor\" data-id=\"44a1013\" 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-37b904e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37b904e\" 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-9413863\" data-id=\"9413863\" 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-e3a67dd elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"e3a67dd\" 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\/218-K-ECDLM04S6-Vizsgafeladat16_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\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-1024x576.jpg\" class=\"attachment-large size-large wp-image-25970\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 16. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_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-95643b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"95643b3\" 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-7e194eb\" data-id=\"7e194eb\" 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-6a02498 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"6a02498\" 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\/218-K-ECDLM04S6-Vizsgafeladat16_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\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-25971\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 16. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A k\u00e9sz csoportos\u00edtott oszlopdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_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-1207e82 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1207e82\" 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-149646f\" data-id=\"149646f\" 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-81be1ad elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"81be1ad\" 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\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas.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\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-1024x576.jpg\" class=\"attachment-large size-large wp-image-25972\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 16. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A csatolt t\u00e1bl\u00e1zat a Munka1 munkalapon.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas.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: A csatolt t\u00e1bl\u00e1zat a Munka1 munkalapon.<\/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-3d22b9d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d22b9d\" 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-cbf8f2f\" data-id=\"cbf8f2f\" 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-d247f3a elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d247f3a\" 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\/218-K-ECDLM04S6-Vizsgafeladat16_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\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-25973\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 16. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_4_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_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: Az export\u00e1lt PDF dokumentum 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-9208e62 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9208e62\" 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-f7a8aac\" data-id=\"f7a8aac\" 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-9ec6ec4 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"9ec6ec4\" 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\/218-K-ECDLM04S6-Vizsgafeladat16_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\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-25974\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 16. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_5_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_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 2 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-631d508 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"631d508\" 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-1c66ef6\" data-id=\"1c66ef6\" 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-7d8d216 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"7d8d216\" 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-94fff43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"94fff43\" 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-55f7056\" data-id=\"55f7056\" 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-efa7de5 elementor-widget elementor-widget-text-editor\" data-id=\"efa7de5\" 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 (57 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-d828def elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d828def\" 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-da0e430\" data-id=\"da0e430\" 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-ee84d8b elementor-widget elementor-widget-text-editor\" data-id=\"ee84d8b\" 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-16.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> <em>(Alt+N)<\/em> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> <em>(Alt+S)<\/em> 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-048013d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"048013d\" 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-b084aef\" data-id=\"b084aef\" 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-5ebd81c elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"5ebd81c\" 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-e866e7e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e866e7e\" 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-7d6f74e\" data-id=\"7d6f74e\" 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-6caf68f elementor-widget elementor-widget-text-editor\" data-id=\"6caf68f\" 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 munkaf\u00fczettel. Az M4-16 munkalap A4:H13 tartom\u00e1ny\u00e1ban egy t\u00e1bl\u00e1zatot tal\u00e1lunk, amely facsemet\u00e9k sz\u00e1ll\u00edt\u00e1s\u00e1r\u00f3l tartalmaz adatokat 2012-t\u0151l 2013-ig, megy\u00e9k szerinti bont\u00e1sban. Az A5:A13 tartom\u00e1nyban helyezkednek el a facsemet\u00e9k nevei (9 db), a B4:H4 tartom\u00e1nyban tal\u00e1ljuk a megy\u00e9ket (7 db), m\u00edg a darabsz\u00e1mokat a B5:H13 tartom\u00e1ny (63 db cella) \u0151rzi. A t\u00e1bl\u00e1zatban megjelen\u00edtett megy\u00e9k mind dun\u00e1nt\u00faliak, egyed\u00fcl N\u00f3gr\u00e1d megye (G oszlop) tal\u00e1lhat\u00f3 a Dunakanyart\u00f3l \u00e9szak-keletre. A t\u00e1bl\u00e1zat c\u00edm\u00e9t az A2 cell\u00e1ban tal\u00e1ljuk.<\/li>\n<li>Az I oszlopban a facsemet\u00e9k elad\u00e1si darabsz\u00e1mainak \u00e1tlagait kell kisz\u00e1molnunk. Helyezz\u00fck az akt\u00edv cell\u00e1t az I4 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li>\n<li>\u00dcss\u00fck le az <em>F5<\/em> funkci\u00f3billenty\u0171t, majd a k\u00e9perny\u0151n megjelen\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fck be az I5:I13 tartom\u00e1nyhivatkoz\u00e1st, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-320ca5e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"320ca5e\" 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-a8633e1\" data-id=\"a8633e1\" 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-6fde9ad elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"6fde9ad\" 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-cee0b50 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cee0b50\" 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-28b544e\" data-id=\"28b544e\" 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-1a5adbe elementor-widget elementor-widget-text-editor\" data-id=\"1a5adbe\" 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=\"7\">\n<li>Adjuk ki a <strong>Kezd\u0151lap \/ AutoSzum \/ \u00c1tlag <\/strong><em>(Alt+\u0150, D, L)<\/em> parancsot! A tartom\u00e1ny cell\u00e1iban megjelennek a sorok \u00e1tlagai.<\/li>\n<li>A J oszlopban a dun\u00e1nt\u00fali megy\u00e9k elad\u00e1si darabsz\u00e1mainak \u00f6sszegeit kell kisz\u00e1molnunk. Helyezz\u00fck az akt\u00edv cell\u00e1t a J4 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00d6sszesen<\/li>\n<li>\u00dcss\u00fck le az <em>F5<\/em> funkci\u00f3billenty\u0171t, majd a k\u00e9perny\u0151n megjelen\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fck be a J5:J13 tartom\u00e1nyhivatkoz\u00e1st, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A J5 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=SZUM(B5:F5;H5)<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! \u00cdgy kihagytuk az \u00f6sszes\u00edt\u00e9sb\u0151l N\u00f3gr\u00e1d megye (G oszlop) adat\u00e1t.<\/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-d82baee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d82baee\" 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-98e2e21\" data-id=\"98e2e21\" 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-72b7814 elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"72b7814\" 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-542c227 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"542c227\" 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-43ea743\" data-id=\"43ea743\" 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-569088b elementor-widget elementor-widget-text-editor\" data-id=\"569088b\" 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=\"11\">\n<li>A k\u00f6vetkez\u0151 feladat a t\u00e1bl\u00e1zat sorainak a facsemet\u00e9k neve (A oszlop) szerint emelked\u0151 sorba rendez\u00e9se. Ehhez elegend\u0151 a facsemet\u00e9k neveit \u00e9s a sz\u00e1ll\u00edt\u00e1si mennyis\u00e9geket, vagyis az A5:H13 tartom\u00e1nyt kijel\u00f6lni. Tegy\u00fck ezt meg!<\/li>\n<li>Az akt\u00edv cella az A5 cell\u00e1n \u00e1ll. Ezzel kijel\u00f6lt\u00fck, hogy mely oszlop szerint akarunk rendezni, \u00edgy azonnal kiadhatjuk az <strong>Adatok \/ Rendez\u00e9s (A-Z) <\/strong><em>(Alt+G, N)<\/em> parancsot. A rendez\u00e9shez haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s (A-Z) <\/strong><em>(Alt+\u0150, \u00da, A)<\/em> parancsot is.<\/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-f263f08 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f263f08\" 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-a162973\" data-id=\"a162973\" 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-f465df3 elementor-widget elementor-widget-global elementor-global-17117 elementor-widget-text-editor\" data-id=\"f465df3\" 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-bca2748 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bca2748\" 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-22c886d\" data-id=\"22c886d\" 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-a925977 elementor-widget elementor-widget-global elementor-global-17149 elementor-widget-text-editor\" data-id=\"a925977\" 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-ab26f5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ab26f5c\" 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-d7a17ad\" data-id=\"d7a17ad\" 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-2cdbb84 elementor-widget elementor-widget-text-editor\" data-id=\"2cdbb84\" 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 J2 cell\u00e1ban az \u00f6sszes darabsz\u00e1mot kell k\u00e9pezn\u00fcnk: helyezz\u00fck az akt\u00edv cell\u00e1t a J2 cell\u00e1ra, majd g\u00e9pelj\u00fck be az <strong>=SZUM(B5:H13)<\/strong> k\u00e9pletet, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! Eredm\u00e9ny\u00fcl 2037-et kell kapnunk.<\/li>\n<li>A 14. sorban egy \u00e1ltalunk megadott facsemet\u00e9vel kell b\u0151v\u00edten\u00fcnk a t\u00e1bl\u00e1zatot. Helyezz\u00fck az akt\u00edv cell\u00e1t az A14 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be p\u00e9ld\u00e1ul az Ak\u00e1c nevet!<\/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-7187907 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7187907\" 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-dddd5c5\" data-id=\"dddd5c5\" 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-34d57bd elementor-widget elementor-widget-text-editor\" data-id=\"34d57bd\" 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> P\u00e9lda n\u00e9h\u00e1ny magyarorsz\u00e1gi facsemet\u00e9re: Berkenye, Di\u00f3, \u00c9ger, Gyerty\u00e1n, H\u00e1rs, Juhar, K\u0151ris, Ny\u00e1r, Ny\u00edr, Szil, Tiszafa, Vadalma, Vadk\u00f6rte, Zselnice meggy.<\/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-2083a11 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2083a11\" 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-c04c6a5\" data-id=\"c04c6a5\" 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-e436676 elementor-widget elementor-widget-text-editor\" data-id=\"e436676\" 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=\"15\">\n<li>Darabsz\u00e1mk\u00e9nt a Feny\u0151 50%-t kell megadnunk minden megy\u00e9ben. A Feny\u0151 darabsz\u00e1mait a 7. sorban tal\u00e1ljuk (B7:H7), az 50% val\u00f3j\u00e1ban valaminek a fel\u00e9t, vagyis a kett\u0151vel oszt\u00e1st jelenti. Jel\u00f6lj\u00fck ki az B14:H14 tartom\u00e1nyt!<\/li>\n<li>A B14 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=B7\/2<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/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-863b0f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"863b0f9\" 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-5641a98\" data-id=\"5641a98\" 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-e321509 elementor-widget elementor-widget-text-editor\" data-id=\"e321509\" 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 a vizsg\u00e1n az 50%-al val\u00f3 sz\u00e1m\u00edt\u00e1st \u00edrj\u00e1k el\u0151, akkor a k\u00f6vetkez\u0151 k\u00e9pletet helyezz\u00fck el a B14 cell\u00e1ban: <strong>=B7*50%<\/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-1b726a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b726a5\" 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-00e217c\" data-id=\"00e217c\" 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-dc280a2 elementor-widget elementor-widget-text-editor\" data-id=\"dc280a2\" 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=\"17\">\n<li>A H14 cella <strong>Sz\u00e1mform\u00e1tuma D\u00e1tum<\/strong> lett, t\u00f6r\u00f6lj\u00fck ezt a <strong>Kezd\u0151lap \/ T\u00f6rl\u00e9s \/ Form\u00e1tum t\u00f6rl\u00e9se <\/strong><em>(Alt+\u0150, R\u00d6, F)<\/em> parancs kiad\u00e1s\u00e1val!<\/li>\n<li>Ne feledkezz\u00fcnk meg a 14. sorhoz tartoz\u00f3 \u00e1tlag kisz\u00e1m\u00edt\u00e1s\u00e1r\u00f3l: jel\u00f6lj\u00fck ki az I13:I14 tartom\u00e1nyt, \u00fcss\u00fck le az <em>F2<\/em> funkci\u00f3billenty\u0171t, majd a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! Az \u00f6sszegk\u00e9plet p\u00f3tl\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki a J13:J14 tartom\u00e1nyt, \u00fcss\u00fck le az <em>F2<\/em> funkci\u00f3billenty\u0171t, majd a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A k\u00f6vetkez\u0151 teend\u0151nk az A2 cell\u00e1ban tal\u00e1lhat\u00f3 c\u00edm t\u00e1bl\u00e1zat f\u00f6l\u00f6tt k\u00f6z\u00e9pre z\u00e1r\u00e1sa: jel\u00f6lj\u00fck ki az A2:H2 tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ Cellaegyes\u00edt\u00e9s \/ Cellaegyes\u00edt\u00e9s <\/strong><em>(Alt+\u0150, EG, A)<\/em> parancsot!<\/li>\n<li>A c\u00edm st\u00edlus\u00e1t a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3val \u00e1ll\u00edtsuk f\u00e9lk\u00f6v\u00e9rre!<\/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-ed39f3e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ed39f3e\" 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-6ed7182\" data-id=\"6ed7182\" 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-6ff5252 elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"6ff5252\" 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-332c1ee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"332c1ee\" 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-96466ef\" data-id=\"96466ef\" 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-b619d4c elementor-widget elementor-widget-text-editor\" data-id=\"b619d4c\" 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=\"21\">\n<li>Meg kell n\u00f6veln\u00fcnk a c\u00edm bet\u0171m\u00e9ret\u00e9t is. Mivel a feladat nem \u00edr el\u0151 konkr\u00e9t \u00e9rt\u00e9ket, \u00edgy a <strong>Kezd\u0151lap \/ Bet\u0171m\u00e9ret n\u00f6vel\u00e9se <\/strong><em>(Alt+\u0150, \u00c9)<\/em> parancs k\u00e9tszeri haszn\u00e1lat\u00e1val n\u00f6velj\u00fck meg 12 pontra! Term\u00e9szetesen m\u00e1s m\u00f3dszerrel m\u00e1s bet\u0171m\u00e9retet is be\u00e1ll\u00edthatunk.<\/li>\n<li>A megy\u00e9ket tartalmaz\u00f3 oszlopc\u00edmk\u00e9ket k\u00f6z\u00e9pre kell z\u00e1rnunk \u00e9s a cell\u00e1k h\u00e1tter\u00e9nek sz\u00edn\u00e9t <strong>S\u00e1rg\u00e1ra<\/strong> kell sz\u00ednezn\u00fcnk. Jel\u00f6lj\u00fck ki a B4:H4 tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ K\u00f6z\u00e9pre v\u00edzszintesen igaz\u00edt\u00e1s <\/strong><em>(Alt+\u0150, KZ)<\/em> parancsot!<\/li>\n<li>\u00c1ll\u00edtsuk be a <strong>S\u00e1rga <\/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 negyedik a <strong>S\u00e1rga <\/strong>sz\u00edn, amit a <em>ny\u00edlbillenty\u0171kkel<\/em> 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! A k\u00e9sz t\u00e1bl\u00e1zatot mutatja az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>.<\/li>\n<li>A k\u00f6vetkez\u0151 feladat egy csoportos\u00edtott oszlopdiagram k\u00e9sz\u00edt\u00e9s\u00e9t k\u00e9ri Zala (B oszlop), Vas (C oszlop) \u00e9s Veszpr\u00e9m (E oszlop) megye adatair\u00f3l egy \u00faj diagramlapra. A diagram elk\u00e9sz\u00edt\u00e9s\u00e9nek egyik felt\u00e9tele, hogy az x tengelyen legyenek l\u00e1that\u00f3k a megy\u00e9k, \u00e9s az y tengelyen, vagyis oszlopokkal legyenek \u00e1br\u00e1zolva az egyes facsemet\u00e9k darabsz\u00e1mai. Mivel az adatokat tartalmaz\u00f3 cell\u00e1k nem szomsz\u00e9dosak, egyben nem, csak k\u00e9t k\u00fcl\u00f6n tartom\u00e1nyk\u00e9nt tudjuk kijel\u00f6lni a sz\u00fcks\u00e9ges cell\u00e1kat: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel az A4:C14;E4:E14 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-ce149a4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce149a4\" 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-930b9f3\" data-id=\"930b9f3\" 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-479df84 elementor-widget elementor-widget-text-editor\" data-id=\"479df84\" 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 D oszlopot.<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 A4:C14;E4:E14 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcletet, akkor l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek 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-1b9ed75 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b9ed75\" 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-a064124\" data-id=\"a064124\" 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-a05bc9b elementor-widget elementor-widget-text-editor\" data-id=\"a05bc9b\" 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=\"25\">\n<li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Oszlop- \u00e9s s\u00e1vdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, \u00da)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a <strong>Csoportos\u00edtott oszlop<\/strong> kiv\u00e1laszt\u00e1s\u00e1hoz! A munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9n megjelenik a kijel\u00f6lt diagram.<\/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-0b1cfd7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b1cfd7\" 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-20e7b4a\" data-id=\"20e7b4a\" 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-55cd48e elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"55cd48e\" 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-a16ec96 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a16ec96\" 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-dc2c624\" data-id=\"dc2c624\" 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-f293e3f elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"f293e3f\" 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-6ea9b6e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ea9b6e\" 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-0f302c0\" data-id=\"0f302c0\" 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-413a216 elementor-widget elementor-widget-text-editor\" data-id=\"413a216\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"26\">\n<li>Helyezz\u00fck \u00e1t a diagramot egy diagramlapra a <strong>Diagramtervez\u00e9s \/ Diagram \u00e1thelyez\u00e9se <\/strong><em>(Alt+JC, I)<\/em> parancsot kiadva! A k\u00e9perny\u0151n megjelen\u0151 <strong>Diagram \u00e1thelyez\u00e9se<\/strong> p\u00e1rbesz\u00e9dablakban keress\u00fck meg \u00e9s v\u00e1lasszuk ki az <strong>\u00daj munkalap<\/strong> <em>(Alt+M)<\/em> v\u00e1laszt\u00f3gombot, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! Az Excel \u00e1thelyezi a diagramot \u00e9s minket is a Diagram1 n\u00e9vvel ell\u00e1tott diagramlapra, amely az M4-16 munkalap el\u0151tt, att\u00f3l balra jelenik meg. A diagram kijel\u00f6lt \u00e1llapotban marad, \u00edgy v\u00e9grehajthatjuk a tov\u00e1bbi feladatokat.<\/li>\n<li>A diagram c\u00edmek\u00e9nt az A2 cella tartalm\u00e1t kell megadnunk. V\u00e1lasszuk ki a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ A diagram felett <\/strong><em>(Alt+JC, D, C, A)<\/em> parancsot! 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 <strong>=&#8217;M4-16&#8242;!A2:H2<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4eca8b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4eca8b2\" 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-63bd8a3\" data-id=\"63bd8a3\" 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-c533318 elementor-widget elementor-widget-global elementor-global-17196 elementor-widget-text-editor\" data-id=\"c533318\" 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 diagramon egy sz\u00f6veges objektum, mint a diagramc\u00edm megad\u00e1s\u00e1t tervezz\u00fck, akkor j\u00f3, ha tudjuk, hogy a munkaf\u00fczet megadott cell\u00e1j\u00e1nak vagy tartom\u00e1ny\u00e1nak tartalm\u00e1ra is tudunk hivatkozni k\u00fcls\u0151 hivatkoz\u00e1ssal. A fenti k\u00e9pletben szerepl\u0151 k\u00fcls\u0151 hivatkoz\u00e1s aposztr\u00f3fok <i>(Shift+1)<\/i> k\u00f6z\u00f6tt a munkalap nev\u00e9t, majd egy felki\u00e1lt\u00f3jelet k\u00f6vet\u0151en a t\u00e1bl\u00e1zatc\u00edmet tartalmaz\u00f3 tartom\u00e1ny abszol\u00fat hivatkoz\u00e1s\u00e1t tartalmazza. A cella- vagy tartom\u00e1nyhivatkoz\u00e1st abszol\u00fat c\u00edmz\u00e9ssel kell megadnunk.<\/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-14245af elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14245af\" 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-528093c\" data-id=\"528093c\" 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-7c94463 elementor-widget elementor-widget-text-editor\" data-id=\"7c94463\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"29\">\n<li>A diagram x tengely\u00e9n a facsemet\u00e9k nevei sorakoznak, y tengely\u00e9n minden facsemet\u00e9hez 3-3 oszloppal a 3 megye darabsz\u00e1mai l\u00e1that\u00f3k. A feladat azonban azt k\u00e9ri, hogy az x tengelyen a megy\u00e9k, az y tengelyen, vagyis oszlopokkal az egyes facsemet\u00e9k darabsz\u00e1mai legyenek \u00e1br\u00e1zolva. Igen, ez pont ford\u00edtva van, \u00edgy h\u00e1t adjuk ki a <strong>Tervez\u00e9s \/ Sor\/oszlop v\u00e1lt\u00e1sa <\/strong><em>(Alt+JV, S)<\/em> parancsot a cser\u00e9hez! Az Excel megcser\u00e9li az x \u00e9s az y tengelyen \u00e1br\u00e1zolt adatsorokat.<\/li>\n<li>Ha m\u00e1r tengely, akkor forgassuk el 45\u00b0-al az x tengely feliratait! Adjuk ki a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> parancsot, majd a kombin\u00e1lt listamez\u0151ben keress\u00fck meg a <strong>V\u00edzszintes (Kateg\u00f3ria) tengely<\/strong> elemet, v\u00e9g\u00fcl v\u00e1lasszuk ki az <em>Enter<\/em> billenty\u0171t le\u00fctve!<\/li>\n<li>Az elforgat\u00e1shoz meg kell jelen\u00edten\u00fcnk a <strong>Tengely form\u00e1z\u00e1sa<\/strong> panelt, a munkater\u00fclet jobb sz\u00e9l\u00e9n. Ehhez adjuk ki a <strong>Form\u00e1tum \/ Kijel\u00f6l\u00e9s form\u00e1z\u00e1sa <\/strong><em>(Alt+JZ, B)<\/em> parancsot!<\/li>\n<li>A f\u00f3kusz a panel <strong>Tengely be\u00e1ll\u00edt\u00e1sai<\/strong> gombj\u00e1ra ker\u00fcl, de ha m\u00e9gsem, akkor a panelra l\u00e9p\u00e9shez addig \u00fct\u00f6gess\u00fck az <em>F6<\/em> funkci\u00f3billenty\u0171t, am\u00edg a <strong>Tengely be\u00e1ll\u00edt\u00e1sa<\/strong> gombot ki nem v\u00e1lasztjuk!<\/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-cb59690 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb59690\" 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-af2c53b\" data-id=\"af2c53b\" 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-814dbf0 elementor-widget elementor-widget-global elementor-global-17123 elementor-widget-text-editor\" data-id=\"814dbf0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Az Excel m\u00e1r r\u00e9gen alkalmazza a be\u00e1ll\u00edt\u00e1spaneleket, amelyek a munkater\u00fclet (munkalap, diagramlap) jobb sz\u00e9l\u00e9n foglalnak el egy terjedelmes sz\u00e9less\u00e9g\u0171 ter\u00fcletet. Alkalmasint t\u00f6bb panelt is nyithatunk, nyitnak egyes parancsok, amelyek egym\u00e1s mellett helyezkednek el, \u00edgy a munkater\u00fclet egy kisebb felbont\u00e1s\u00fa k\u00e9perny\u0151n nagyon \u00f6sszesz\u0171k\u00fclhet.<br \/>A panelek, valamint az Excel alkalmaz\u00e1sablak\u00e1nak r\u00e9szei k\u00f6z\u00f6tt (men\u00fcszalag, akt\u00edv cella vagy diagramlap, lapf\u00fcl, panelek stb.) az <i>F6<\/i> \u00e9s a <i>Shift+F6<\/i> seg\u00edts\u00e9g\u00e9vel l\u00e9pkedhet\u00fcnk. A panelb\u00f3l a munkalapra vagy a diagramlapra t\u00f6rt\u00e9n\u0151 visszal\u00e9p\u00e9shez haszn\u00e1ljuk az <i>Esc<\/i> billenty\u0171t!<br \/>A panelben val\u00f3 mozg\u00e1sra a <i>Tab<\/i> \u00e9s <i>Shift+Tab<\/i> billenty\u0171ket haszn\u00e1lhatjuk.<br \/>A panelek billenty\u0171zettel t\u00f6rt\u00e9n\u0151 kezel\u00e9s\u00e9r\u0151l k\u00fcl\u00f6n cikkben olvashatunk.<\/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-b4b717c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b4b717c\" 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-1902f75\" data-id=\"1902f75\" 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-d3241e0 elementor-widget elementor-widget-text-editor\" data-id=\"d3241e0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"33\">\n<li>\u00dct\u00f6gess\u00fck a <em>Tab<\/em> billenty\u0171t, am\u00edg nem tal\u00e1lunk egy \u00fajabb <strong>Tengely be\u00e1ll\u00edt\u00e1sai<\/strong> gombot! Itt n\u00e9gy gombot tal\u00e1lunk egym\u00e1s mellett (<strong>Kit\u00f6lt\u00e9s \u00e9s vonal<\/strong>, <strong>Effektusok<\/strong>, <strong>M\u00e9ret \u00e9s tulajdons\u00e1gok<\/strong>, <strong>Tengely be\u00e1ll\u00edt\u00e1sai<\/strong>), amelyek k\u00f6z\u00fcl az utols\u00f3ra l\u00e9pt\u00fcnk az el\u0151bb. A gombok k\u00f6z\u00fcl a <em>ny\u00edlbillenty\u0171kkel<\/em> v\u00e1laszthatunk. L\u00e9pj\u00fcnk egyet balra a <strong>M\u00e9ret \u00e9s tulajdons\u00e1gok<\/strong> gombot kijel\u00f6lve!<\/li>\n<li>\u00dcss\u00fck le a <em>Tab<\/em> billenty\u0171t az <strong>Igaz\u00edt\u00e1s<\/strong> gombra l\u00e9p\u00e9shez!<\/li>\n<li>Ha becsukott \u00e1llapotban tal\u00e1ljuk, akkor a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel nyissuk ki!<\/li>\n<li>A <em>Tab<\/em> billenty\u0171vel keress\u00fck meg az <strong>Egy\u00e9ni sz\u00f6g<\/strong> szerkeszt\u0151mez\u0151t, majd g\u00e9pelj\u00fck be a -45 \u00e9rt\u00e9ket, \u00e9s \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! (A 45\u00b0 jobbra lefel\u00e9, a -45\u00b0 jobbra felfel\u00e9 d\u00f6nti meg a feliratokat.)<\/li>\n<li>Az \u00e1ltalunk haszn\u00e1lt Excel, ahogy az a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram.jpg\" target=\"_blank\" rel=\"noopener\">2. \u00e1br\u00e1n<\/a> is l\u00e1tszik, k\u00e9t facsemete oszlop\u00e1t is vil\u00e1gos \u00e9s s\u00f6t\u00e9tsz\u00fcrke kit\u00f6lt\u0151sz\u00ednnel l\u00e1tta el, \u00edgy annak a feladatnak, hogy az egyik adatsor kit\u00f6lt\u0151sz\u00edne legyen sz\u00fcrke, eleget tett\u00fcnk. Ha m\u00e9gis magunk akarjuk be\u00e1ll\u00edtani egy kiv\u00e1lasztott adatsor kit\u00f6lt\u0151sz\u00edn\u00e9t, akkor hajtsuk v\u00e9gre a k\u00f6vetkez\u0151 l\u00e9p\u00e9seket: adjuk ki a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> parancsot, majd v\u00e1lasszunk az egyik <strong>Adatsor\u2026<\/strong> elem k\u00f6z\u00fcl. A kit\u00f6lt\u0151sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz pedig a <strong>Form\u00e1tum \/ Alakzat kit\u00f6lt\u00e9se <\/strong><em>(Alt+JZ, \u00d6)<\/em> parancsra lesz sz\u00fcks\u00e9g\u00fcnk, amelynek <strong>Sz\u00edn\u00f6ssze\u00e1ll\u00edt\u00e1s<\/strong> palett\u00e1j\u00e1nak harmadik \u00e9s hetedik oszlop\u00e1ban tal\u00e1lunk sz\u00fcrke \u00e1rnyalatokat. V\u00e1lasszunk k\u00f6z\u00fcl\u00fck! A k\u00e9sz diagramot a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_2_Diagram.jpg\" target=\"_blank\" rel=\"noopener\">2. \u00e1br\u00e1n<\/a> tekinthetj\u00fck meg.<\/li>\n<li>Az M4-16 munkalapra l\u00e9p\u00e9shez \u00fcss\u00fck le az <em>Esc<\/em> billenty\u0171t, majd <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>Csatolt m\u00e1solatot kell k\u00e9sz\u00edten\u00fcnk a t\u00e1bl\u00e1zatr\u00f3l egy \u00faj munkalapra. Jel\u00f6lj\u00fck ki az A2:J14 tartom\u00e1nyt, majd a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val k\u00e9sz\u00edts\u00fcnk r\u00f3la m\u00e1solatot a V\u00e1g\u00f3lapra!<\/li>\n<li>\u00dcss\u00fck le a <em>Shift+F11<\/em> billenty\u0171kombin\u00e1ci\u00f3t egy \u00faj munkalap k\u00e9sz\u00edt\u00e9s\u00e9hez! Haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Besz\u00far\u00e1s \/ Munkalap besz\u00far\u00e1sa <\/strong><em>(Alt+\u0150, BB, B)<\/em> parancsot is. Az \u00faj \u00e9s akt\u00edv munkalap Munka1 n\u00e9ven az M4-16 munkalap el\u0151tt j\u00f6n l\u00e9tre.<\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t az A2 cell\u00e1ra!<\/li>\n<li>Adjuk ki a helyi men\u00fc <strong>Csatolt beilleszt\u00e9s<\/strong> parancs\u00e1t <em>(Shift+F10, A, Enter)<\/em>! Haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Beilleszt\u00e9s\/ Csatolt beilleszt\u00e9s<\/strong> <em>(Alt+\u0150, A, Enter)<\/em> parancsot is. A beillesztett m\u00e1solat cell\u00e1iban k\u00e9pleteket tal\u00e1lunk, amelyek a forr\u00e1s t\u00e1bl\u00e1zat megfelel\u0151 cell\u00e1ira hivatkoznak. \u00cdgy, ha a forr\u00e1s t\u00e1bl\u00e1zat adatain v\u00e1ltoztatunk, akkor az \u00faj tartalom megjelenik az \u00faj munkalap t\u00e1bl\u00e1zat\u00e1ban is.<\/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-e629de4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e629de4\" 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-0ee5635\" data-id=\"0ee5635\" 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-a037141 elementor-widget elementor-widget-text-editor\" data-id=\"a037141\" 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 csatolt beilleszt\u00e9s a forr\u00e1s t\u00e1bl\u00e1zat \u00fcres cell\u00e1ira is k\u00e9pletekkel hivatkozik, valamint elhagyja a form\u00e1tumjegyeket. Ez az oka a sz\u00e1mos nulla \u00e9rt\u00e9knek \u00e9s a form\u00e1zatlan t\u00e1bl\u00e1zatnak. Ha ez gond, vagy a vizsg\u00e1n el\u0151\u00edrj\u00e1k a forr\u00e1s t\u00e1bl\u00e1zattal megegyez\u0151 alakot, akkor a form\u00e1tumjegyek \u00e1tm\u00e1sol\u00e1s\u00e1hoz a csatolt beilleszt\u00e9st k\u00f6vet\u0151en r\u00f6gt\u00f6n adjuk ki a Kezd\u0151lap \/ Beilleszt\u00e9s \/ Form\u00e1z\u00e1s (Alt+\u0150, V, F, F, Enter) parancsot, ezt k\u00f6vet\u0151en pedig t\u00f6r\u00f6lj\u00fck a sz\u00fcks\u00e9gtelen cell\u00e1k tartalm\u00e1t (p\u00e9ld\u00e1ul a harmadik sorban). Mi is \u00edgy tett\u00fcnk, t\u00f6r\u00f6lt\u00fck a null\u00e1kat \u00e9s \u00e1tm\u00e1soltuk a form\u00e1tumjegyeket is <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_3_Csatolas.jpg\" target=\"_blank\" rel=\"noopener\">(3. \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-16c85c5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"16c85c5\" 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-6aa5c55\" data-id=\"6aa5c55\" 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-9976271 elementor-widget elementor-widget-text-editor\" data-id=\"9976271\" 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>T\u00e9rj\u00fcnk vissza az M4-16 munkalapra a <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>A 11. feladat szerint egy olyan k\u00e9pletet kell k\u00e9sz\u00edten\u00fcnk, amely egy csillagot jelen\u00edt meg az A17 cell\u00e1ban, ha a legt\u00f6bb facsemete Zala megy\u00e9be ker\u00fclt, egy\u00e9bk\u00e9nt maradjon \u00fcres a cella. Nyilv\u00e1n a HA f\u00fcggv\u00e9nyre lesz sz\u00fcks\u00e9g\u00fcnk, amelynek m\u00e1sodik argumentuma a &#8222;*&#8221;, harmadik argumentuma az \u00fcres sztring, a &#8222;&#8221;. De mi legyen az els\u0151 argumentum, a felt\u00e9tel? El\u0151sz\u00f6r sz\u00fcks\u00e9g\u00fcnk van minden megye sz\u00e1ll\u00edt\u00e1sainak \u00f6sszeg\u00e9re, hogy megn\u00e9zz\u00fck, Zala megye \u00e9rt\u00e9ke-e a legnagyobb. Ha nem akarunk nagyon \u00f6sszetett felt\u00e9telt k\u00e9sz\u00edteni, amely minden megye oszlop\u00e1nak \u00f6sszeg\u00e9t kisz\u00e1molja a SZUM f\u00fcggv\u00e9nnyel, akkor c\u00e9lszer\u0171 a 15. sorban kisz\u00e1molni az oszlop\u00f6sszegeket. Sz\u00e1moljuk h\u00e1t ki minden oszlop \u00f6sszeg\u00e9t! Jel\u00f6lj\u00fck ki a B15:H15 tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ Szum <\/strong><em>(Alt+\u0150, D, Enter)<\/em> parancsot! A tartom\u00e1ny cell\u00e1iban megjelennek az \u00f6sszegek. 17. A H14 cella <strong>Sz\u00e1mform\u00e1tuma D\u00e1tum<\/strong> lett, t\u00f6r\u00f6lj\u00fck ezt a <strong>Kezd\u0151lap \/ T\u00f6rl\u00e9s \/ Form\u00e1tum t\u00f6rl\u00e9se<\/strong> <em>(Alt+\u0150, R\u00d6, F)<\/em> parancs kiad\u00e1s\u00e1val!<\/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-f793800 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f793800\" 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-f6253f4\" data-id=\"f6253f4\" 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-02e47d2 elementor-widget elementor-widget-global elementor-global-17165 elementor-widget-text-editor\" data-id=\"02e47d2\" 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-2a0274d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2a0274d\" 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-aa52811\" data-id=\"aa52811\" 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-b89d385 elementor-widget elementor-widget-text-editor\" data-id=\"b89d385\" 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=\"45\">\n<li>Most m\u00e1r egyszer\u0171 feladat a felt\u00e9tel \u00f6ssze\u00e1ll\u00edt\u00e1sa, amely \u00edgy hangzik: a B15:H15 cell\u00e1kban tal\u00e1lhat\u00f3 sz\u00e1mok legnagyobbika egyenl\u0151-e a Zala megye \u00f6sszeg\u00e9t tartalmaz\u00f3 B15 \u00e9rt\u00e9k\u00e9n\u00e9l. A B15:H15 cell\u00e1i k\u00f6z\u00fcl a legnagyobb \u00e9rt\u00e9ket a MAX f\u00fcggv\u00e9nnyel kapjuk meg: MAX(B15:H15). Ennek eredm\u00e9ny\u00e9t kell \u00f6sszehasonl\u00edtani Zala megye \u00f6sszeg\u00e9vel: MAX(B15:H15)=B15. Megvan a felt\u00e9tel, az els\u0151 argumentum, \u00e1ll\u00edtsuk most m\u00e1r \u00f6ssze a teljes k\u00e9pletet: <strong>=HA(MAX(B15:H15)=B15;&#8221;*&#8221;;&#8221;&#8221;)<\/strong><\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t az A17 cell\u00e1ra, majd g\u00e9pelj\u00fck be a fenti k\u00e9pletet! Az eredm\u00e9ny egy csillag, hiszen a B15 cell\u00e1ban tal\u00e1lhat\u00f3 797-es \u00e9rt\u00e9k a legnagyobb a B15:H15 tartom\u00e1nyb\u00f3l. Teh\u00e1t Zala megy\u00e9be sz\u00e1ll\u00edtott\u00e1k a legt\u00f6bb facsemet\u00e9t.<\/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-5f4336d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f4336d\" 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-7742ef1\" data-id=\"7742ef1\" 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-9dc96d5 elementor-widget elementor-widget-text-editor\" data-id=\"9dc96d5\" 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 a felt\u00e9telt az \u00f6sszegz\u0151sor n\u00e9lk\u00fcl akarjuk \u00f6ssze\u00e1ll\u00edtani, akkor a k\u00f6vetkez\u0151 k\u00e9pletet kell besz\u00farnunk: <strong>=HA(MAX(SZUM(B5:B14); SZUM(C5:C14); SZUM(D5:D14); SZUM(E5:E14); SZUM(F5:F14); SZUM(G5:G14); SZUM(H5:H14))=SZUM(B5:B14);&#8221;*&#8221;;&#8221;&#8221;)<\/strong>. A MAX f\u00fcggv\u00e9ny argumentumait az egyes oszlop\u00f6sszegek k\u00e9pezik a SZUM f\u00fcggv\u00e9ny felhaszn\u00e1l\u00e1s\u00e1val, a B15 hely\u00e9n pedig Zala megye oszlop\u00f6sszeg\u00e9t tal\u00e1ljuk. Mi ezt a k\u00e9pletet illesztett\u00fck be az A17 cell\u00e1ba, de a 15. sorban elk\u00e9sz\u00edtett\u00fck az oszlop\u00f6sszegeket is. A k\u00e9sz t\u00e1bl\u00e1zatot mutatja az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_Megoldas1_1_Tablazat.jpg\" target=\"_blank\" rel=\"noopener\">1. \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-ade524e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ade524e\" 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-bbd6455\" data-id=\"bbd6455\" 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-147de8f elementor-widget elementor-widget-text-editor\" data-id=\"147de8f\" 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=\"47\">\n<li>Az utols\u00f3 feladat az A1:H20 tartom\u00e1ny kinyomtat\u00e1sa egy oldalra, f\u00fcgg\u0151legesen k\u00f6z\u00e9pre z\u00e1rva. Jel\u00f6lj\u00fck ki az A1:H20 tartom\u00e1nyt!<\/li>\n<li>Jel\u00f6lj\u00fck meg nyomtat\u00e1si ter\u00fcletnek a tartom\u00e1nyt a <strong>Lapelrendez\u00e9s \/ Nyomtat\u00e1si ter\u00fclet \/ Nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se <\/strong><em>(Alt+P, I, K)<\/em> paranccsal!<\/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> v\u00e1laszt\u00f3gombot <em>(Alt+N)<\/em>!<\/li>\n<li>A <em>Ctrl+Tab<\/em> seg\u00edts\u00e9g\u00e9vel l\u00e9pj\u00fcnk \u00e1t a <strong>Marg\u00f3k<\/strong> f\u00fclre!<\/li>\n<li>Keress\u00fck meg a <strong>F\u00fcgg\u0151legesen<\/strong> <em>(Alt+N)<\/em> jel\u00f6l\u0151n\u00e9gyzetet \u00e9s kapcsoljuk be a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171 seg\u00edts\u00e9g\u00e9vel!<\/li>\n<li>\u00dcss\u00fck le az <em>Enter<\/em> billenty\u0171t az <strong>Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> ablakb\u00f3l val\u00f3 kil\u00e9p\u00e9shez!<\/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-6e0d2de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e0d2de\" 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-fa39958\" data-id=\"fa39958\" 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-99167a3 elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"99167a3\" 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-d9dd896 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d9dd896\" 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-4ded9a3\" data-id=\"4ded9a3\" 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-eb8cdaa elementor-widget elementor-widget-text-editor\" data-id=\"eb8cdaa\" 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>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> <em>(Alt+K)<\/em> 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-5c97545 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c97545\" 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-66a53d0\" data-id=\"66a53d0\" 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-b9ea89f elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"b9ea89f\" 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-cd152fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd152fa\" 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-0daecee\" data-id=\"0daecee\" 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-70edd01 elementor-widget elementor-widget-text-editor\" data-id=\"70edd01\" 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=\"56\">\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\/218-K-ECDLM04S6-Vizsgafeladat16_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-60de4f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"60de4f9\" 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-c3ece08\" data-id=\"c3ece08\" 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-873d8e4 elementor-widget elementor-widget-text-editor\" data-id=\"873d8e4\" 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 2 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet kett\u0151 munkalappal \u00e9s egy diagramlappal, valamint egy PDF dokumentumot <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/218-K-ECDLM04S6-Vizsgafeladat16_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-9999a40 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9999a40\" 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-a3a2601\" data-id=\"a3a2601\" 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-085f823 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"085f823\" 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-6a2c002 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a2c002\" 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-7e83ae1\" data-id=\"7e83ae1\" 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-748c257 elementor-widget elementor-widget-text-editor\" data-id=\"748c257\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 j\u00fanius 13.<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<\/b><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-da140eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"da140eb\" 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-2b51ec2\" data-id=\"2b51ec2\" 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-0c12f0d elementor-widget elementor-widget-shortcode\" data-id=\"0c12f0d\" 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--5049 \"        data-post-id=\"5049\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-5049\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-5049\">                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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 \">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">1<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">5<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated rmp-rating-widget__not-rated--hidden\">                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-eaea02c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eaea02c\" 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-4b93b1f\" data-id=\"4b93b1f\" 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-f321fbf 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=\"f321fbf\" 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 25. 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 16. 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=5049\">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-5049","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/5049","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=5049"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/5049\/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=5049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}