{"id":2648,"date":"2020-03-31T21:19:45","date_gmt":"2020-03-31T19:19:45","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2648"},"modified":"2022-07-18T20:54:05","modified_gmt":"2022-07-18T18:54:05","slug":"ecdl-tablazatkezeles-1-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2648","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat (#185\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2648\" class=\"elementor elementor-2648\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-83c93d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"83c93d5\" 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-dd4cfc9\" data-id=\"dd4cfc9\" 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-ec0f155 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"ec0f155\" 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 18.<\/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-0cd2369 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0cd2369\" 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-56a410f\" data-id=\"56a410f\" 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-257d165 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"257d165\" 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-7413bc9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7413bc9\" 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-368bb66\" data-id=\"368bb66\" 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-fbee0e1 elementor-widget elementor-widget-text-editor\" data-id=\"fbee0e1\" 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 1. 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-6d812a6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6d812a6\" 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-4a7d3e6\" data-id=\"4a7d3e6\" 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-28ae19d elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"28ae19d\" 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__28ae19d\" 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__28ae19d\" 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__28ae19d\" 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-946c1d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"946c1d0\" 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-90b0c0a\" data-id=\"90b0c0a\" 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-93626d9 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"93626d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>Felhaszn\u00e1lt forr\u00e1sok:<\/strong><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/hu\/ecdl\/modul\/tablazatkezeles\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A T\u00e1bl\u00e1zatkezel\u00e9s modul tartalma az NJSzT oldal\u00e1n.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 febru\u00e1r 1-t\u0151l \u00e9rv\u00e9nyes T\u00e1bl\u00e1zatkezel\u00e9s Syllabus 6 (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 m\u00e1rcius 1-t\u0151l \u00e9rv\u00e9nyes ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A feladatokhoz tartoz\u00f3 munkaf\u00fczetek t\u00f6m\u00f6r\u00edtv\u00e9nye (ZIP f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/185-K-ECDLM04S6-Vizsgafeladat1.txt\" target=\"_blank\" rel=\"noopener noreferrer\">Az 1. 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-aec80f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aec80f1\" 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-9d8bdec\" data-id=\"9d8bdec\" 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-61e8a21 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"61e8a21\" 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-7d3185d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d3185d\" 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-1c01028\" data-id=\"1c01028\" 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-d19c180 elementor-widget elementor-widget-text-editor\" data-id=\"d19c180\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az ECDL Excel vizsgafeladat megold\u00e1sa el\u0151tt a megjel\u00f6lt forr\u00e1sok k\u00f6z\u00fcl t\u00f6lts\u00fck le sz\u00fcks\u00e9g szerint az <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s 6.0<\/a> dokumentumot \u00e9s a <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">munkaf\u00e1jlokat<\/a> \u2013 az el\u0151bbit nyissuk meg, az ut\u00f3bbit pedig csomagoljuk ki c\u00e9lszer\u0171en a Dokumentumok mapp\u00e1ba. A vizsgap\u00e9ldat\u00e1r PDF dokumentum, amit a legt\u00f6bb internet b\u00f6ng\u00e9sz\u0151 k\u00e9pes megnyitni, de haszn\u00e1lhatjuk b\u00e1rmelyik PDF olvas\u00f3 alkalmaz\u00e1st is, p\u00e9ld\u00e1ul az Adobe Acrobat Readert. L\u00e1t\u00e1ss\u00e9r\u00fclt sorst\u00e1rsaink <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/185-K-ECDLM04S6-Vizsgafeladat1.txt\" target=\"_blank\" rel=\"noopener\">Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban<\/a> is let\u00f6lthetik a feladatsort.<\/p><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-04f84da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"04f84da\" 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-2921670\" data-id=\"2921670\" 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-57000af elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"57000af\" 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> akt\u00edv cella \u00e1thelyez\u00e9se, diagram k\u00e9sz\u00edt\u00e9se \u00e9s form\u00e1z\u00e1sa, export\u00e1l\u00e1s PDF \u00e9s TXT form\u00e1tumban, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, munkaf\u00fczet ment\u00e9se m\u00e1s f\u00e1jlt\u00edpusk\u00e9nt, munkalap k\u00e9sz\u00edt\u00e9se, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, oszlopok \u00e9s sorok kezel\u00e9se, sorba rendez\u00e9s, t\u00e1bl\u00e1zat form\u00e1z\u00e1sa, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, OSZLOP, SZ\u00d6VEG, 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-8f9c3bf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f9c3bf\" 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-16cf51a\" data-id=\"16cf51a\" 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-9ab7c8b elementor-widget elementor-widget-text-editor\" data-id=\"9ab7c8b\" 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-09959ee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"09959ee\" 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-c9465df\" data-id=\"c9465df\" 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-4cd39b8 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"4cd39b8\" 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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1.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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-1024x576.jpg\" class=\"attachment-large size-large wp-image-25178\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1.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-0eee3ae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0eee3ae\" 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-467eeab\" data-id=\"467eeab\" 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-a282297 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"a282297\" 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\/185-K-ECDLM04S6-Vizsgafeladat1_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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-25179\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A k\u00e9sz k\u00f6rdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_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 k\u00f6rdiagram.<\/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-a96eb54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a96eb54\" 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-32be591\" data-id=\"32be591\" 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-d243abd elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d243abd\" 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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT.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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-1024x576.jpg\" class=\"attachment-large size-large wp-image-25180\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A t\u00e1bl\u00e1zat exportja a Jegyzett\u00f6mb ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT.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 t\u00e1bl\u00e1zat exportja a Jegyzett\u00f6mb 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-f5a0f8c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5a0f8c\" 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-4340549\" data-id=\"4340549\" 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-63eb7dd elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"63eb7dd\" 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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2.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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-1024x576.jpg\" class=\"attachment-large size-large wp-image-25181\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: A 2008 munkalap t\u00e1bl\u00e1zata.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">4. \u00e1bra: A 2008 munkalap t\u00e1bl\u00e1zata.<\/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-2b073d4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2b073d4\" 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-6d747cc\" data-id=\"6d747cc\" 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-9e140bb elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"9e140bb\" 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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-25182\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A PDF export a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_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\">5. \u00e1bra: A PDF export a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-805fa5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"805fa5d\" 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-2a759a4\" data-id=\"2a759a4\" 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-3f71110 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"3f71110\" 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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_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\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-25183\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 1. vizsgafeladat, 1. megold\u00e1s, 6. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_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\">6. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-28084f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28084f8\" 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-c737ac9\" data-id=\"c737ac9\" 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-64cc769 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"64cc769\" 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-9d6e9bf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d6e9bf\" 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-bdc2dd3\" data-id=\"bdc2dd3\" 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-08b5f34 elementor-widget elementor-widget-text-editor\" data-id=\"08b5f34\" 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 (65 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-b6c3c78 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b6c3c78\" 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-0980fb5\" data-id=\"0980fb5\" 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-a1fb340 elementor-widget elementor-widget-text-editor\" data-id=\"a1fb340\" 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-1.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\u00e9dpanel megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>G\u00e9pelj\u00fck be a <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-132fba0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"132fba0\" 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-014a9ca\" data-id=\"014a9ca\" 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-ec2a2a3 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"ec2a2a3\" 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-078e227 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"078e227\" 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-cc569dc\" data-id=\"cc569dc\" 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-36801fd elementor-widget elementor-widget-text-editor\" data-id=\"36801fd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"4\">\n<li>Els\u0151 teend\u0151nk, hogy megismerkedj\u00fcnk a t\u00e1bl\u00e1zattal: a t\u00e1bl\u00e1zat \u00e1ltal elfoglalt tartom\u00e1ny c\u00edme A2:J35. A m\u00e1sodik sorban, az A2:J2 tartom\u00e1nyban tal\u00e1lhat\u00f3k az oszlopazonos\u00edt\u00f3k. A 3. sort\u00f3l a 35. sorig sorakoznak a gy\u00f3gyszerek kiszerel\u00e9si \u00e9s elad\u00e1si adatai: Term\u00e9k, Kiszerel\u00e9s, Term\u00e9kk\u00f3d \u00e9s \u00e9vek 2007-2013 k\u00f6z\u00f6tt h\u00e9t oszlopban. A 2001-2013 \u00e9vsz\u00e1m c\u00edmk\u00e9k Form\u00e1tumk\u00f3dja nem Sz\u00f6veg, hanem \u00c1ltal\u00e1nos, vagyis numerikus adatok, sz\u00e1mok. Ez a diagramk\u00e9sz\u00edt\u00e9sn\u00e9l elker\u00fclend\u0151 probl\u00e9m\u00e1t fog okozni, a megold\u00e1st majd ott t\u00e1rgyaljuk.<\/li>\n<li>Miel\u0151tt hozz\u00e1fogn\u00e1nk a munk\u00e1hoz, alak\u00edtsunk egy kicsit a t\u00e1bl\u00e1zaton n\u00e9h\u00e1ny feladat v\u00e9grehajt\u00e1s\u00e1t megk\u00f6nny\u00edtve! A D2:J2 tartom\u00e1nyban elhelyezett \u00e9vsz\u00e1mok nem <strong>Sz\u00f6veg<\/strong>, hanem <strong>\u00c1ltal\u00e1nos<\/strong> form\u00e1tum\u00fa sz\u00e1mok. Ez egyes k\u00e9pletek \u00e9s diagramok k\u00e9sz\u00edt\u00e9s\u00e9n\u00e9l \u00f6sszetett megold\u00e1sokat k\u00f6vetel \u2013 emiatt a feladatokat k\u00e9sz\u00edt\u0151k alkalmasint sz\u00e1nd\u00e9kosan helyeznek el sz\u00e1mokat oszlop \u00e9s\/vagy sorazonos\u00edt\u00f3k\u00e9nt \u2013 ami egy\u00e9bk\u00e9nt ker\u00fclend\u0151 gyakorlat. Teh\u00e1t alak\u00edtsuk sz\u00f6vegg\u00e9 a cell\u00e1k tartalm\u00e1t \u2013 azonban a <strong>Sz\u00f6veg<\/strong> form\u00e1tumk\u00f3d cell\u00e1khoz rendel\u00e9se nem megold\u00e1s, mert az Excel a m\u0171velett\u0151l f\u00fcgg\u0151en sz\u00e1mk\u00e9nt fogja \u00e9rtelmezni az \u00e9rt\u00e9keket. Ad\u00f3dik, hogy valamilyen nem zavar\u00f3 karakterrel, p\u00e9ld\u00e1ul egy-egy ponttal eg\u00e9sz\u00edts\u00fck ki az \u00e9vsz\u00e1mokat. Ez azonban l\u00e1that\u00f3 v\u00e1ltoz\u00e1st eredm\u00e9nyez, ami nem felt\u00e9tlen\u00fcl el\u0151ny\u00f6s. Az eleg\u00e1ns megold\u00e1st a SZ\u00d6VEG f\u00fcggv\u00e9ny szolg\u00e1ltatja, amely karakterl\u00e1ncc\u00e1 alak\u00edtja az argumentumak\u00e9nt megadott sz\u00e1mot vagy sz\u00e1mot eredm\u00e9nyez\u0151 kifejez\u00e9st. Alak\u00edtsuk \u00e1t a sz\u00e1mokat a SZ\u00d6VEG f\u00fcggv\u00e9nnyel \u00f6ssze\u00e1ll\u00edtva a k\u00e9pletet a D2 cella sz\u00e1m\u00e1ra: <strong>=SZ\u00d6VEG(OSZLOP()+2003;&#8221;0&#8243;)<\/strong>. Az argumentum n\u00e9lk\u00fcli OSZLOP f\u00fcggv\u00e9nnyel az akt\u00edv cella oszlopsz\u00e1m\u00e1t kapjuk meg (D oszlop = 4. oszlop), ehhez adunk 2003-at, \u00edgy kapjuk meg a 2007 stb. karakterl\u00e1ncot. Jel\u00f6lj\u00fck ki a D2:J2 tartom\u00e1nyt!<\/li>\n<li>A D2 cell\u00e1ba g\u00e9pelj\u00fck be a fenti k\u00e9pletet, 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-bce2458 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bce2458\" 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-ad638d2\" data-id=\"ad638d2\" 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-c8f0b43 elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"c8f0b43\" 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-9b7ac0b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b7ac0b\" 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-50bf6e9\" data-id=\"50bf6e9\" 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-a745f05 elementor-widget elementor-widget-text-editor\" data-id=\"a745f05\" 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>Az els\u0151 feladat szerint egy \u00faj sort kell besz\u00farnunk az els\u0151 term\u00e9k (harmadik sor) el\u00e9, amit tetsz\u0151leges adatokkal t\u00f6lthet\u00fcnk fel. Helyezz\u00fck az akt\u00edv cell\u00e1t a harmadik sorba, nyomjuk le a <em>Shift+Sz\u00f3k\u00f6z<\/em>, majd a <em>Ctrl+NumPad+<\/em> billenty\u0171parancsot!<\/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-8cc83a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8cc83a3\" 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-a2618ec\" data-id=\"a2618ec\" 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-35e9a2f elementor-widget elementor-widget-global elementor-global-17159 elementor-widget-text-editor\" data-id=\"35e9a2f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Ha k\u00e9perny\u0151olvas\u00f3 szoftverrel dolgozunk (p\u00e9ld\u00e1ul Jaws, ZoomText), a numerikus billenty\u0171zet val\u00f3sz\u00edn\u0171leg kurzormozgat\u00f3 \u00fczemm\u00f3dban, vagyis a <i>NumLock<\/i> kikapcsolt \u00e1llapotban van. Ha a numerikus billenty\u0171zethez k\u00f6thet\u0151 billenty\u0171kombin\u00e1ci\u00f3kkal akarunk dolgozni, akkor a <i>NumLock<\/i> kapcsol\u00f3nak bekapcsolt \u00e1llapotban kell lennie.<br \/>Ha nincs numerikus billenty\u0171zet\u00fcnk, mert p\u00e9ld\u00e1ul TKL laptoppal dolgozunk, akkor haszn\u00e1ljuk a helyi men\u00fc <strong>Besz\u00far\u00e1s<\/strong> <i>(Shift+F10, S, Enter) <\/i>parancs\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-bfb6f0d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bfb6f0d\" 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-09dce8b\" data-id=\"09dce8b\" 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-d89d57c elementor-widget elementor-widget-global elementor-global-17146 elementor-widget-text-editor\" data-id=\"d89d57c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Az akt\u00edv cella sor\u00e1nak kijel\u00f6l\u00e9s\u00e9re a <i>Shift+Sz\u00f3k\u00f6z<\/i>, oszlop\u00e1nak kijel\u00f6l\u00e9s\u00e9re a <i>Ctrl+Sz\u00f3k\u00f6z<\/i> haszn\u00e1lhat\u00f3. Ha t\u00f6bb sort\/oszlopot akarunk kijel\u00f6lni, akkor a szok\u00e1sos <i>Shift+ny\u00edlbillenty\u0171k<\/i> kijel\u00f6l\u00e9s kiterjeszt\u00e9ssel \u00e9lhet\u00fcnk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8985ce2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8985ce2\" 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-d4704a0\" data-id=\"d4704a0\" 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-a3f8b74 elementor-widget elementor-widget-text-editor\" data-id=\"a3f8b74\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"8\">\n<li>Mivel tetsz\u0151leges adatokkal felt\u00f6lthetj\u00fck a sort, nemes egyszer\u0171s\u00e9ggel k\u00e9sz\u00edts\u00fcnk m\u00e1solatot a negyedik sorr\u00f3l: helyezz\u00fck az akt\u00edv cell\u00e1t a negyedik sorba, \u00fcss\u00fck le a <em>Shift+Sz\u00f3k\u00f6z<\/em>, majd a <em>Ctrl+C<\/em> billenty\u0171parancsot a negyedik sor V\u00e1g\u00f3lapra m\u00e1sol\u00e1s\u00e1hoz!<\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t az A3 cell\u00e1ra, majd \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171parancsot a sor beilleszt\u00e9s\u00e9hez!<\/li>\n<li>A k\u00f6vetkez\u0151 feladat \u00f6sszegz\u0151 sor k\u00e9sz\u00edt\u00e9se a t\u00e1bl\u00e1zat al\u00e1: helyezz\u00fck az akt\u00edv cell\u00e1t az A37 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be c\u00edmk\u00e9nek a k\u00f6vetkez\u0151 sz\u00f3t: \u00d6sszesen<\/li>\n<li>Nyomjuk le az <em>F5<\/em> funkci\u00f3billenty\u0171t az <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dpanel megjelen\u00edt\u00e9s\u00e9hez, \u00e9s a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be g\u00e9pelj\u00fck be a D37:J37 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-f4458b5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f4458b5\" 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-951dd16\" data-id=\"951dd16\" 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-1db3a4e elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"1db3a4e\" 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-f23a5a0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f23a5a0\" 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-5f32d99\" data-id=\"5f32d99\" 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-e7c2230 elementor-widget elementor-widget-text-editor\" data-id=\"e7c2230\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"12\"><li>Adjuk ki a <strong>Kezd\u0151lap \/ AutoSzum <\/strong><em>(Alt+\u0150,D, Enter)\u00a0<\/em>parancsot a SZUM k\u00e9pletek r\u00f6gz\u00edt\u00e9s\u00e9hez! Nos, itt az egyik el\u0151nye a sz\u00f6vegg\u00e9 tett \u00e9vsz\u00e1moknak, ugyanis elker\u00fclt\u00fck, hogy a SZUM f\u00fcggv\u00e9ny a m\u00e1sodik sor cell\u00e1it\u00f3l \u00e9rtelmezze az \u00f6sszeadand\u00f3 \u00e9rt\u00e9keket.<\/li><li>A k\u00f6vetkez\u0151 feladat \u00e1tlagol\u00f3 sor k\u00e9sz\u00edt\u00e9se a 38. sorba: helyezz\u00fck az akt\u00edv cell\u00e1t az A38 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be c\u00edmk\u00e9nek a k\u00f6vetkez\u0151 sz\u00f3t: \u00c1tlag<\/li><li>Jel\u00f6lj\u00fck ki a D38:J38 tartom\u00e1nyt!<\/li><li>A tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba (D38) g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet:<br \/><strong>=\u00c1TLAG(D3:D36)<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171t!<\/li><li>A K oszlopban a 2010 ut\u00e1ni, vagyis a 2011-2013 \u00e9vek (H:J oszlopok) \u00f6sszegeit kell kisz\u00e1m\u00edtanunk minden gy\u00f3gyszerhez (3:36 sorok): helyezz\u00fck az akt\u00edv cell\u00e1t a K2 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be c\u00edmk\u00e9nek a k\u00f6vetkez\u0151 sz\u00f3t: \u00d6sszesen<\/li><li>Jel\u00f6lj\u00fck ki a K3:K36 tartom\u00e1nyt az \u00f6sszegek sz\u00e1m\u00e1ra!<\/li><li>A tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba (K3) g\u00e9pelj\u00fck be az <strong>=SZUM(H3:J3)<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171t!<\/li><li>A k\u00f6vetkez\u0151 l\u00e9p\u00e9sben egy k\u00f6rdiagramot kell k\u00e9sz\u00edten\u00fcnk egy \u00faj diagramlapra a GOSTIV term\u00e9k elad\u00e1si adataib\u00f3l. A GOSTIV a 18. sorban tal\u00e1lhat\u00f3, a hozz\u00e1 tartoz\u00f3 c\u00edmk\u00e9k pedig a 2. sorban. Ugyanakkor vigy\u00e1znunk kell a kijel\u00f6l\u00e9ssel, mivel a B:C oszlopokra nincs sz\u00fcks\u00e9g\u00fcnk, teh\u00e1t ki kell hagynunk azokat. L\u00e1thatjuk, hogy az \u00e1br\u00e1zolni k\u00edv\u00e1nt adatokat tartalmaz\u00f3 cell\u00e1k nem szomsz\u00e9dosak, \u00edgy az <em>F5<\/em> funkci\u00f3billenty\u0171t h\u00edvjuk seg\u00edts\u00e9g\u00fcl, megadva a k\u00f6vetkez\u0151 tartom\u00e1nyhivatkoz\u00e1sokat: A2;D2:J2;A18;D18:J18<\/li><\/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-b43fd2c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b43fd2c\" 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-5123823\" data-id=\"5123823\" 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-8eecfff elementor-widget elementor-widget-text-editor\" data-id=\"8eecfff\" 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 eset\u00fcnkben a B:C oszlopokat \u00e9s a 3:17 sorokat?<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve az A2;D2:J2;A18;D18:J18 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcleteket, akkor l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek val\u00f3ban egy folytonos t\u00e9glalapot mint\u00e1znak.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2bd89d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2bd89d0\" 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-96730c0\" data-id=\"96730c0\" 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-802e43d elementor-widget elementor-widget-text-editor\" data-id=\"802e43d\" 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=\"20\"><li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ K\u00f6r- vagy perecdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, KK)<\/em> parancsot, majd a megjelen\u0151 palett\u00e1n keress\u00fck meg a <strong>2D K\u00f6r <\/strong>gombot \u00e9s v\u00e1lasszuk ki! A munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9n a t\u00e1bl\u00e1zat felett megjelenik a Diagram1 \u00e1bra. Itt a m\u00e1sik el\u0151nye az \u00e9vsz\u00e1mok sz\u00f6vegg\u00e9 alak\u00edt\u00e1s\u00e1nak, ugyanis a diagram k\u00e9sz\u00edt\u00e9se sor\u00e1n az Excel a D2:J2 \u00e9vsz\u00e1mait nem az y tengelyen \u00e1br\u00e1zoland\u00f3 adatpontoknak, hanem az x tengely feliratainak tekinti.<\/li><\/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-fd27e79 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd27e79\" 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-ceac566\" data-id=\"ceac566\" 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-ac42827 elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"ac42827\" 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-a3c5b99 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3c5b99\" 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-b207254\" data-id=\"b207254\" 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-dc32099 elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"dc32099\" 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-2724e77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2724e77\" 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-5a11f83\" data-id=\"5a11f83\" 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-bdfe17d elementor-widget elementor-widget-text-editor\" data-id=\"bdfe17d\" 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\"><li>A diagram \u00f6n\u00e1ll\u00f3 diagramlapra helyez\u00e9s\u00e9hez adjuk ki a <strong>Diagramtervez\u00e9s \/ Diagram \u00e1thelyez\u00e9se<\/strong> parancsot <em>(Alt+JC, I)<\/em>!<\/li><li>A k\u00e9perny\u0151n megjelen\u0151 <strong>Diagram \u00e1thelyez\u00e9se<\/strong> p\u00e1rbesz\u00e9dpanelben v\u00e1lasszuk ki az <strong>\u00daj munkalap<\/strong> szerkeszt\u0151mez\u0151t, g\u00e9pelj\u00fck be a diagramlap nev\u00e9t: GOSTIV, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! A diagram \u00e1tker\u00fcl egy \u00faj diagramlapra, amely az M4-1 munkalapt\u00f3l balra j\u00f6n l\u00e9tre.<\/li><li>A diagram c\u00edm\u00e9t (GOSTIV) nem kell megadnunk, mivel az azt tartalmaz\u00f3 cell\u00e1t kijel\u00f6lt\u00fck a diagramon \u00e1br\u00e1zoland\u00f3 tartom\u00e1ny r\u00e9szek\u00e9nt, \u00edgy automatikusan diagramc\u00edm lett bel\u0151le.<\/li><li>Ugyan\u00edgy, az egysoros jelmagyar\u00e1zat is m\u00e1r r\u00e9sze a diagramnak a fenti l\u00e9p\u00e9seknek k\u00f6sz\u00f6nhet\u0151en, mivel az Excel alapesetben megjelen\u00edt a diagram alatt, egy egysoros jelmagyar\u00e1zatot.<\/li><li>Az \u00e9rt\u00e9kfeliratok helye nincs el\u0151\u00edrva, csak megjelen\u00edt\u00e9s\u00fck, \u00edgy v\u00e1laszthatjuk a k\u00f6rcikken bel\u00fcli megjelen\u00edt\u00e9st, aminek be\u00e1ll\u00edt\u00e1s\u00e1hoz v\u00e1lasszuk ki a <strong>Tervez\u00e9s<\/strong> \/ <strong>Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Adatfeliratok \/ \u00c9rt\u00e9kn\u00e9l, bel\u00fcl <\/strong>parancs\u00e1t <em>(Alt+JV, D, A, R)<\/em>!<\/li><li>A diagramot elk\u00e9sz\u00edtett\u00fck (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_2_Diagram.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"2. \u00e1bra (opens in a new tab)\">2. \u00e1bra<\/a>), folytassuk a t\u00e1bl\u00e1zat form\u00e1z\u00e1s\u00e1val: t\u00e9rj\u00fcnk vissza az M4-1 munkalapra a <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3val, \u00e9s \u00fcss\u00fck le az <em>Esc<\/em> billenty\u0171t, hogy visszakapjuk az akt\u00edv cell\u00e1t!<\/li><li>A teljes t\u00e1bl\u00e1zatot <strong>K\u00e9k<\/strong> szeg\u00e9llyel kell k\u00f6rbevenn\u00fcnk. Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A2:K38 tartom\u00e1nyt!<\/li><li>Jelen\u00edts\u00fck meg a <strong>Cell\u00e1k form\u00e1z\u00e1sa<\/strong> p\u00e1rbesz\u00e9dpanelt a <em>Ctrl+1<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li><li>A <em>Ctrl+Tab<\/em> seg\u00edts\u00e9g\u00e9vel l\u00e9pj\u00fcnk a <strong>Szeg\u00e9ly<\/strong> f\u00fclre!<\/li><li>\u00dcss\u00fck le a <em>Tab<\/em> billenty\u0171t a <strong>St\u00edlus<\/strong> list\u00e1ba <em>(Alt+S)<\/em> ugr\u00e1shoz, a <em>ny\u00edlbillenty\u0171kkel<\/em> v\u00e1lasszunk ki egy tetsz\u0151leges vonalst\u00edlust \u00e9s jel\u00f6lj\u00fck ki a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel! Mi a <strong>Vastag <\/strong>szeg\u00e9lyt v\u00e1lasztottuk ki.<\/li><li>L\u00e9pj\u00fcnk a <em>Tab <\/em>billenty\u0171vel a <strong>Sz\u00edn <\/strong>kombin\u00e1lt listamez\u0151re <em>(Alt+Z)<\/em>, \u00e9s a <em>Sz\u00f3k\u00f6z <\/em>billenty\u0171vel jelen\u00edts\u00fck meg a sz\u00ednpalett\u00e1t! A paletta <strong>Alapsz\u00ednek <\/strong>r\u00e9sz\u00e9ben a nyolcadik a <strong>K\u00e9k <\/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!<\/li><li>L\u00e9pj\u00fcnk tov\u00e1bb a <em>Tab-<\/em>bal az <strong>Elhelyez\u00e9s <\/strong>r\u00e9szre (<strong>Nincs<\/strong>, <strong>K\u00f6r\u00fcl<\/strong>, <strong>Bel\u00fcl<\/strong>), ahol a <em>Jobb ny\u00edlbillenty\u0171vel<\/em><em>\u00a0<\/em>keress\u00fck meg a <strong>K\u00f6r\u00fcl <\/strong>gombot <em>(Alt+K) <\/em>\u00e9s v\u00e1lasszuk ki a <em>Sz\u00f3k\u00f6z <\/em>billenty\u0171vel \u2013 a be\u00e1ll\u00edtott vonalst\u00edlus \u00e9s sz\u00edn most jut \u00e9rv\u00e9nyre, teh\u00e1t a v\u00e9grehajt\u00e1s sorrendj\u00e9t be kell tartanunk: st\u00edlus, sz\u00edn, kerett\u00edpus.<\/li><li>A p\u00e1rbesz\u00e9dpanelb\u0151l az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel l\u00e9pj\u00fcnk ki!<\/li><li>A t\u00e1bl\u00e1zat els\u0151 sor\u00e1nak form\u00e1z\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki az A2:K2 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+B<\/em>-t a f\u00e9lk\u00f6v\u00e9r, v\u00e9g\u00fcl a <em>Ctrl+I<\/em>-t a d\u0151lt bet\u0171st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li><\/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-ca6ce12 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ca6ce12\" 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-b391b96\" data-id=\"b391b96\" 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-7741a06 elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"7741a06\" 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-a599263 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a599263\" 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-d9de325\" data-id=\"d9de325\" 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-b2b24ec elementor-widget elementor-widget-text-editor\" data-id=\"b2b24ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"35\"><li>Jel\u00f6lj\u00fck ki az A37:J37 tartom\u00e1nyt a h\u00e1tt\u00e9r- \u00e9s a bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li><li>\u00c1ll\u00edtsuk be a <strong>S\u00f6t\u00e9tk\u00e9k <\/strong>kit\u00f6lt\u0151sz\u00ednt a <strong>Kezd\u0151lap \/ Kit\u00f6lt\u0151sz\u00edn <\/strong><em>(Alt+\u0150, H1)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel! A paletta <strong>Alapsz\u00ednek<\/strong> r\u00e9sz\u00e9ben a kilencedik a <strong>S\u00f6t\u00e9tk\u00e9k<\/strong> sz\u00edn, amit a <i>ny\u00edlbillenty\u0171kkel<\/i> l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li><li>A <strong>Feh\u00e9r, 1. h\u00e1tt\u00e9r<\/strong> bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz haszn\u00e1ljuk <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1t! A paletta <strong>Sz\u00edn\u00f6ssze\u00e1ll\u00edt\u00e1s<\/strong> r\u00e9sz\u00e9ben az els\u0151 a <strong>Feh\u00e9r, 1. h\u00e1tt\u00e9r<\/strong> sz\u00edn, amit a <i>ny\u00edlbillenty\u0171kkel <\/i>l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li><li>A numerikus \u00e9rt\u00e9kek form\u00e1tumk\u00f3dj\u00e1nak be\u00e1ll\u00edt\u00e1s\u00e1hoz az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki a D3:K38 tartom\u00e1nyt!<\/li><li>Az ezres csoport be\u00e1ll\u00edt\u00e1s\u00e1hoz \u00fcss\u00fck le a <em>Ctrl+Shift+1<\/em> billenty\u0171kombin\u00e1ci\u00f3t! Vegy\u00fck \u00e9szre, hogy ha ehelyett a <strong>Kezd\u0151lap \/ Ezres csoport<\/strong> gombj\u00e1t <em>(Alt+\u0150, RE)<\/em> haszn\u00e1ljuk, akkor a nulla \u00e9rt\u00e9kek helyett m\u00ednusz jel jelenik meg a null\u00e1t tartalmaz\u00f3 cell\u00e1kban!<\/li><\/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-745c9a6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"745c9a6\" 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-2d847f5\" data-id=\"2d847f5\" 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-e504456 elementor-widget elementor-widget-global elementor-global-17120 elementor-widget-text-editor\" data-id=\"e504456\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> N\u00e9h\u00e1ny <strong>Sz\u00e1mform\u00e1tumot<\/strong> a k\u00f6vetkez\u0151 billenty\u0171kombin\u00e1ci\u00f3kkal tudunk gyorsan \u00e9s k\u00e9nyelmesen alkalmazni: <i>Ctrl+Shift+1<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> k\u00e9t tizedesjeggyel \u00e9s ezres tagol\u00e1ssal, <i>Ctrl+Shift+2<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> a cell\u00e1ban tal\u00e1lhat\u00f3 egyn\u00e9l kisebb tizedes t\u00f6rtet tartalmaz\u00f3 \u00e9rt\u00e9k \u00f3ra:perc form\u00e1tumra alak\u00edt\u00e1s\u00e1val, <i>Ctrl+Shift+3<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> a cell\u00e1ban tal\u00e1lhat\u00f3 \u00e9rt\u00e9k nn.hhh.\u00e9\u00e9 form\u00e1tumra alak\u00edt\u00e1s\u00e1val, <i>Ctrl+Shift+4<\/i> \u2013 form\u00e1z\u00e1s <strong>P\u00e9nznem Sz\u00e1mform\u00e1tumra<\/strong> k\u00e9t tizedesjeggyel \u00e9s ezres tagol\u00e1ssal (negat\u00edv \u00e9rt\u00e9k eset\u00e9n piros bet\u0171sz\u00ednnel), <i>Ctrl+Shift+5<\/i> \u2013 form\u00e1z\u00e1s <strong>Sz\u00e1zal\u00e9k Sz\u00e1mform\u00e1tumra<\/strong> tizedesjegyek n\u00e9lk\u00fcl eg\u00e9szre kerek\u00edt\u00e9ssel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-790f1f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"790f1f5\" 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-7e46aff\" data-id=\"7e46aff\" 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-e8aa0cc elementor-widget elementor-widget-text-editor\" data-id=\"e8aa0cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"40\"><li>A tizedeshelyek sz\u00e1m\u00e1t a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se<\/strong> <em>(Alt+\u0150, 9)<\/em> ikon k\u00e9tszeri haszn\u00e1lat\u00e1val tudjuk lenull\u00e1zni. A k\u00e9sz t\u00e1bl\u00e1zatot l\u00e1thatjuk az <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_1_Tablazat1.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"1. \u00e1br\u00e1n (opens in a new tab)\">1. \u00e1br\u00e1n<\/a>.<\/li><li>A Term\u00e9kk\u00f3d (C) oszlop szerint emelked\u0151 sorba kell rendezn\u00fcnk a gy\u00f3gyszerek sorait. Ehhez az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A3:J36 tartom\u00e1nyt!<\/li><\/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-5ada736 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ada736\" 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-481f7bd\" data-id=\"481f7bd\" 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-bc02b35 elementor-widget elementor-widget-global elementor-global-17149 elementor-widget-text-editor\" data-id=\"bc02b35\" 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-0336377 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0336377\" 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-ca5a221\" data-id=\"ca5a221\" 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-296575b elementor-widget elementor-widget-text-editor\" data-id=\"296575b\" 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=\"42\"><li>A tartom\u00e1nyon bel\u00fcl az akt\u00edv cella A3 cell\u00e1n \u00e1ll. Nek\u00fcnk viszont a C oszlop szerint kell rendezn\u00fcnk, \u00edgy \u00fcss\u00fck le k\u00e9tszer a <em>Tab<\/em> billenty\u0171t, hogy az akt\u00edv cella a C3-ba ker\u00fclj\u00f6n!<\/li><li>Most m\u00e1r kiadhatjuk a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s (A-Z) <\/strong><em>(Alt+\u0150, \u00da, A) <\/em>vagy az<strong> Adatok \/ Rendez\u00e9s (A-Z) <\/strong><em>(Alt+G, N)<\/em> parancsot!<\/li><li>Az eg\u00e9sz t\u00e1bl\u00e1zatot (A2:K38) TXT sz\u00f6vegf\u00e1jlba kell export\u00e1lnunk. Ha nincs el\u0151\u00edrva, m\u00e1rpedig a feladatle\u00edr\u00e1s szerint nincs, hogy ehhez kiz\u00e1r\u00f3lag az Excelt haszn\u00e1lhatjuk, akkor elind\u00edthatjuk a Jegyzett\u00f6mb alkalmaz\u00e1st, \u00e9s a V\u00e1g\u00f3lap seg\u00edts\u00e9g\u00e9vel k\u00e9sz\u00edthet\u00fcnk m\u00e1solatot a tartom\u00e1nyr\u00f3l a Jegyzett\u00f6mb alkalmaz\u00e1sba. Ha a vizsg\u00e1n csak az Excellel dolgozhatunk, akkor az <em>F12<\/em> seg\u00edts\u00e9g\u00e9vel mentj\u00fck a munkalapot a megadott mapp\u00e1ba a megadott n\u00e9ven, <strong>F\u00e1jl t\u00edpusak\u00e9nt<\/strong> a <strong>Sz\u00f6veg (MS-DOS)<\/strong> form\u00e1tumot v\u00e1lasztva. A k\u00f6vetkez\u0151 l\u00e9p\u00e9sekben az els\u0151 m\u00f3dszer szerint j\u00e1runk el.<\/li><li>Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A2:K38 tartom\u00e1nyt, majd k\u00e9sz\u00edts\u00fcnk r\u00f3la m\u00e1solatot a V\u00e1g\u00f3lapra a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li><li>Ind\u00edtsuk el a Jegyzett\u00f6mb alkalmaz\u00e1st: \u00fcss\u00fck le a <em>Start<\/em> billenty\u0171t, a keres\u0151mez\u0151be g\u00e9pelj\u00fck be a <em>jegyzett\u00f6mb<\/em> sz\u00f3t, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li><li>A k\u00e9perny\u0151n megjelen\u0151 Jegyzett\u00f6mb ablakba illessz\u00fck be a V\u00e1g\u00f3lap tartalm\u00e1t a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3val! A sz\u00f6vegf\u00e1jl tartalm\u00e1t mutatja a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_3_TXT.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"3. \u00e1bra (opens in a new tab)\">3. \u00e1bra<\/a>.<\/li><li>Adjuk ki a <strong>F\u00e1jl \/ Ment\u00e9s m\u00e1sk\u00e9nt <\/strong><em>(Alt+F, S)<\/em> parancsot vagy \u00fcss\u00fck le a <em>Ctrl+S<\/em> billenty\u0171kombin\u00e1ci\u00f3t a ment\u00e9shez!<\/li><li>A k\u00e9perny\u0151n megjelen\u0151 <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dpanel <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben adjuk meg a k\u00e9rt nevet, esetleg v\u00e1lasszuk ki a megadott mapp\u00e1t, v\u00e9g\u00fcl a <strong>Ment\u00e9s<\/strong> gombot!<\/li><li>Z\u00e1rjuk be a Jegyzett\u00f6mb alkalmaz\u00e1st \u00e9s t\u00e9rj\u00fcnk vissza a munkaf\u00fczethez!<\/li><\/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-9b1e526 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b1e526\" 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-c69831f\" data-id=\"c69831f\" 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-c538472 elementor-widget elementor-widget-text-editor\" data-id=\"c538472\" 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 sorba rendez\u00e9s elrontotta a kor\u00e1bban k\u00e9sz\u00edtett k\u00f6rdiagramunkat, mivel a diagramon megjelen\u0151 \u00e9rt\u00e9kekre abszol\u00fat c\u00edmz\u00e9ssel hivatkozik az Excel. A rendez\u00e9s \u00e1thelyezte a GOSTIV adatait a 18. sorb\u00f3l a negyedik sorba. A megold\u00e1s, hogy a sorba rendez\u00e9st \u00e9s az export\u00e1l\u00e1st k\u00f6vet\u0151en helyre\u00e1ll\u00edtjuk az eredeti sorrendet a visszavon\u00e1ssal.<\/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-e88a2e9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e88a2e9\" 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-beaf8e6\" data-id=\"beaf8e6\" 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-fde46bd elementor-widget elementor-widget-text-editor\" data-id=\"fde46bd\" 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=\"51\"><li>Az eredeti sorrend, egyben a diagram helyre\u00e1ll\u00edt\u00e1s\u00e1hoz \u00fcss\u00fck le a <em>Ctrl+Z<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li><li>K\u00e9sz\u00edts\u00fcnk egy \u00faj munkalapot a <em>Shift+F11<\/em> billenty\u0171kombin\u00e1ci\u00f3val vagy adjuk ki a <strong>Kezd\u0151lap \/ Besz\u00far\u00e1s \/ Munkalap besz\u00far\u00e1sa <\/strong><em>(Alt+\u0150, BB, B)<\/em> parancsot! A <strong>Munka1<\/strong> munkalap az <strong>M4-1<\/strong> munkalap el\u0151tt, att\u00f3l balra j\u00f6n l\u00e9tre.<\/li><li>A munkalap nev\u00e9nek m\u00f3dos\u00edt\u00e1s\u00e1hoz el\u0151sz\u00f6r adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Munkalap \u00e1tnevez\u00e9se <\/strong><em>(Alt+\u0150, FF, N)<\/em> parancsot, majd \u00edrjuk \u00e1t a munkalap nev\u00e9t 2008-ra, v\u00e9g\u00fcl \u00fcss\u00fck le az Enter billenty\u0171t!<\/li><li>L\u00e9pj\u00fcnk vissza az M4-1 munkalapra a <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li><li>A Term\u00e9kk\u00f3d \u00e9s a 2008 oszlop \u00e1tm\u00e1sol\u00e1s\u00e1hoz el\u0151sz\u00f6r jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel a C:C;E:E oszlopokat, majd nyomjuk le a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li><li>L\u00e9pj\u00fcnk a 2008 munkalapra, majd \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t a V\u00e1g\u00f3lap tartalm\u00e1nak besz\u00far\u00e1s\u00e1hoz!<\/li><li>Ahhoz, hogy minden adat l\u00e1tsz\u00f3djon, n\u00f6velj\u00fck meg az oszlopok sz\u00e9less\u00e9g\u00e9t a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, U)<\/em> paranccsal (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_4_Tablazat2.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"4. \u00e1bra (opens in a new tab)\">4. \u00e1bra<\/a>)!<\/li><li>L\u00e9pj\u00fcnk vissza az M4-1 munkalapra a <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3val, majd az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A2:K38 tartom\u00e1nyt!<\/li><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><li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> <em>(Alt+P, O)<\/em> parancsot! A k\u00e9perny\u0151n megjelenik az <strong>Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> p\u00e1rbesz\u00e9dpanel.<\/li><li>Az <strong>Oldal<\/strong> f\u00fcl\u00f6n v\u00e1lasszuk ki a <strong>Fekv\u0151 <\/strong><em>(Alt+F)<\/em> t\u00e1jol\u00e1st, a <strong>Nagy\u00edt\u00e1s<\/strong> r\u00e9szben a <strong>Legyen<\/strong> <em>(Alt+N)<\/em> v\u00e1laszt\u00f3gombot, majd az <strong>OK<\/strong> gombot!<\/li><\/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-5adba3b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5adba3b\" 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-0660469\" data-id=\"0660469\" 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-cf66dd6 elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"cf66dd6\" 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-f1bd2ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f1bd2ab\" 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-17a56a4\" data-id=\"17a56a4\" 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-e78c948 elementor-widget elementor-widget-text-editor\" data-id=\"e78c948\" 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=\"62\"><li>Adjuk ki a <strong>F\u00e1jl \/ Export\u00e1l\u00e1s<\/strong> <em>(Alt+F, E)<\/em> parancsot, \u00e9s keress\u00fck meg a <strong>PDF\/XPS l\u00e9trehoz\u00e1sa<\/strong> \u00a0<em>(A)<\/em> gombot!<\/li><li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel PDF vagy XPS form\u00e1tumban<\/strong> p\u00e1rbesz\u00e9dpanel, amelynek <strong>F\u00e1jln\u00e9v<\/strong> <em>(Alt+N)<\/em> 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, K)<\/em> gombot v\u00e1lasztva!<\/li><\/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-9f82ebc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9f82ebc\" 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-96e88fc\" data-id=\"96e88fc\" 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-e15399f elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"e15399f\" 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-26f9d11 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"26f9d11\" 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-81b23c5\" data-id=\"81b23c5\" 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-760a0cf elementor-widget elementor-widget-text-editor\" data-id=\"760a0cf\" 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=\"64\"><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 class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_5_PDF.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"5. \u00e1bra (opens in a new tab)\">5. \u00e1bra<\/a>).<\/li><li>A feladattal v\u00e9gezt\u00fcnk, ments\u00fcnk \u00e9s z\u00e1rjunk be minden f\u00e1jlt \u00e9s alkalmaz\u00e1st!<\/li><\/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-6ef1a90 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ef1a90\" 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-e0487e7\" data-id=\"e0487e7\" 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-f8eb340 elementor-widget elementor-widget-text-editor\" data-id=\"f8eb340\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A feladat megold\u00e1sa sor\u00e1n 3 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet egy-egy munka- \u00e9s diagramlappal, egy TXT sz\u00f6vegf\u00e1jlt, valamint egy PDF dokumentumot (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/185-K-ECDLM04S6-Vizsgafeladat1_Megoldas1_6_Fajlok.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"6. \u00e1bra (opens in a new tab)\">6. \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-8dd0e44 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8dd0e44\" 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-fb900e3\" data-id=\"fb900e3\" 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-4eae459 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"4eae459\" 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-140cad0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"140cad0\" 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-fe53480\" data-id=\"fe53480\" 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-6c53363 elementor-widget elementor-widget-text-editor\" data-id=\"6c53363\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 m\u00e1rcius 31.<br \/>Oper\u00e1ci\u00f3s rendszer: <b>Windows 10 (21H2, 2111b19044)<\/b><br \/>Irodai programcsomag: <b>Microsoft Office 2016 v2206b15330.20246, Aktu\u00e1lis csatorna<\/b><br \/>Szint: kezd\u0151, ECDL modul\/tanmenet: <b>T\u00e1bl\u00e1zatkezel\u00e9s<\/b>\/S6<br \/>Kateg\u00f3ria: ECDL \u2192 T\u00e1bl\u00e1zatkezel\u00e9s \u2192 Vizsgafeladatok<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-924cb7c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"924cb7c\" 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-fe2e5b5\" data-id=\"fe2e5b5\" 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-3738dec elementor-widget elementor-widget-shortcode\" data-id=\"3738dec\" 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--2648 \"        data-post-id=\"2648\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2648\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2648\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6f7c75c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f7c75c\" 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-2c588bb\" data-id=\"2c588bb\" 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-b0f466a 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=\"b0f466a\" 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 18. 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 1. 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=2648\">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-2648","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2648","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=2648"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2648\/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=2648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}