{"id":6293,"date":"2020-07-18T13:51:57","date_gmt":"2020-07-18T11:51:57","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=6293"},"modified":"2022-08-07T15:54:27","modified_gmt":"2022-08-07T13:54:27","slug":"ecdl-tablazatkezeles-41-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=6293","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 41. vizsgafeladat (#247\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"6293\" class=\"elementor elementor-6293\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce662a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce662a3\" 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-3f995b7\" data-id=\"3f995b7\" 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-5c490d2 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"5c490d2\" 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 augusztus 1.<\/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-b37c815 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b37c815\" 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-8dca881\" data-id=\"8dca881\" 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-2973429 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"2973429\" 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-15d669d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"15d669d\" 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-4ca50ec\" data-id=\"4ca50ec\" 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-adac756 elementor-widget elementor-widget-text-editor\" data-id=\"adac756\" 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 41. 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-472ac96 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"472ac96\" 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-8151189\" data-id=\"8151189\" 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-bacfc29 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"bacfc29\" 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__bacfc29\" 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__bacfc29\" 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__bacfc29\" 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-6511f25 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6511f25\" 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-66cdef5\" data-id=\"66cdef5\" 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-65aa654 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"65aa654\" 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\/07\/247-K-ECDLM04S6-Vizsgafeladat41.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 41. 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-35088f3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"35088f3\" 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-3008a9d\" data-id=\"3008a9d\" 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-9dbc5cb elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"9dbc5cb\" 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-4c9582d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c9582d\" 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-3a4eabc\" data-id=\"3a4eabc\" 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-c44f117 elementor-widget elementor-widget-text-editor\" data-id=\"c44f117\" 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 class=\"rank-math-link\" href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\" aria-label=\" (opens in a new tab)\">ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s 6.0<\/a> dokumentumot \u00e9s a <a class=\"rank-math-link\" href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\" aria-label=\" (opens in a new tab)\">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 class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/07\/247-K-ECDLM04S6-Vizsgafeladat41.txt\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban<\/a> is let\u00f6lthetik a feladatsort.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>Tekints\u00fck \u00e1t a feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismereteket \u00e9s a felhaszn\u00e1lt f\u00fcggv\u00e9nyeket:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f9cc449 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f9cc449\" 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-6cd1daf\" data-id=\"6cd1daf\" 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-4977c14 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"4977c14\" 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\u00e9s \u00e9s form\u00e1z\u00e1s, export\u00e1l\u00e1s PDF form\u00e1tumban, k\u00e9plet sokszoros\u00edt\u00e1sa, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, oszlopok \u00e9s sorok kezel\u00e9se, sz\u00e1zal\u00e9ksz\u00e1m\u00edt\u00e1s, t\u00e1bl\u00e1zat form\u00e1z\u00e1s, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, HOL.VAN, INDEX, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MAX<\/a>, SZUM.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-36d1305 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36d1305\" 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-6002eec\" data-id=\"6002eec\" 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-25c6447 elementor-widget elementor-widget-text-editor\" data-id=\"25c6447\" 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-8afee02 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8afee02\" 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-50c69ad\" data-id=\"50c69ad\" 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-d89bf87 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d89bf87\" 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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram.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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-26428\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 41. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat \u00e9s csoportos\u00edtott oszlopdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram.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 \u00e9s csoportos\u00edtott oszlopdiagram.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9e39ff5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e39ff5\" 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-2863914\" data-id=\"2863914\" 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-8581939 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"8581939\" 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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt.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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-1024x576.jpg\" class=\"attachment-large size-large wp-image-26429\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 41. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A csatolt t\u00e1bl\u00e1zat az \u00faj munkaf\u00fczetben.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt.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 csatolt t\u00e1bl\u00e1zat az \u00faj munkaf\u00fczetben.<\/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-65946f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65946f2\" 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-7add65c\" data-id=\"7add65c\" 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-d2ff45c elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d2ff45c\" 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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-26430\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 41. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_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\">3. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ff8fc2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ff8fc2\" 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-c5b8e19\" data-id=\"c5b8e19\" 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-d7a73e4 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d7a73e4\" 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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-26431\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 41. vizsgafeladat, 1. megold\u00e1s, 4. \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\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_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\">4. \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-630394c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"630394c\" 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-b302999\" data-id=\"b302999\" 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-d81dbfe elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"d81dbfe\" 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-0b44e5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b44e5d\" 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-232e94e\" data-id=\"232e94e\" 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-78565e6 elementor-widget elementor-widget-text-editor\" data-id=\"78565e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Egy javaslat a v\u00e9grehajt\u00e1s menet\u00e9re a billenty\u0171zet haszn\u00e1lat\u00e1val (57 l\u00e9p\u00e9s):<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-285c7a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"285c7a5\" 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-e85af66\" data-id=\"e85af66\" 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-3083fbe elementor-widget elementor-widget-text-editor\" data-id=\"3083fbe\" 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-41.xlsx munkaf\u00fczetet!<\/li>\n<li>Nyomjuk le az <em>F12<\/em> funkci\u00f3billenty\u0171t a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>G\u00e9pelj\u00fck be a <strong>F\u00e1jln\u00e9v<\/strong> <em>(Alt+N)<\/em> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> <em>(Alt+S)<\/em> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f3db105 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3db105\" 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-b8478e4\" data-id=\"b8478e4\" 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-eb52863 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"eb52863\" 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-d48e5a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d48e5a5\" 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-95e3716\" data-id=\"95e3716\" 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-9e59fc0 elementor-widget elementor-widget-text-editor\" data-id=\"9e59fc0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"4\">\n<li>Els\u0151 teend\u0151nk, hogy megismerkedj\u00fcnk a munkaf\u00fczettel. Az M4-41 munkalap A1:C20 tartom\u00e1nya egy k\u00e9pzeletbeli git\u00e1rkeresked\u00e9s hangszereit, azok nett\u00f3 \u00e9s brutt\u00f3 \u00e1rait, valamint a v\u00e1s\u00e1rl\u00e1skor \u00e9rv\u00e9nyes\u00edthet\u0151 kedvezm\u00e9nyeket tartalmazza. A Kateg\u00f3ria (A) oszlopban a hangszerek neveit, a Cikkn\u00e9v (B) oszlopban a hangszerek term\u00e9kk\u00f3dj\u00e1t, a Nett\u00f3 \u00e1r (C) \u00e9s a Brutt\u00f3 \u00e1r (D) oszlopokban az \u00e1rakat, m\u00edg a Kedvezm\u00e9ny (E) oszlopban a kedvezm\u00e9nyek m\u00e9rt\u00e9k\u00e9t tal\u00e1ljuk <strong>Sz\u00e1zal\u00e9k<\/strong> form\u00e1tumban. Az oszlopc\u00edmk\u00e9k az A1:E1 tartom\u00e1nyban, az adatok az A2:E20 tartom\u00e1nyban helyezkednek el.<\/li>\n<li>Els\u0151 feladatunk a kedvezm\u00e9nnyel cs\u00f6kkentett Brutt\u00f3 \u00e1r kisz\u00e1m\u00edt\u00e1sa minden hangszerhez az F oszlopban. A kedvezm\u00e9nyes \u00e1r kisz\u00e1mol\u00e1s\u00e1hoz a Brutt\u00f3 \u00e1rb\u00f3l ki kell vonnunk a brutt\u00f3 \u00e1r megadott sz\u00e1zal\u00e9k\u00e1t: brutt\u00f3-brutt\u00f3*kedvezm\u00e9ny. Ennek alapj\u00e1n az F2 cell\u00e1ban a k\u00e9plet a k\u00f6vetkez\u0151 lesz: <strong>=D2-D2*E2<\/strong>. G\u00e9pelj\u00fck be az F1 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Kedvezm\u00e9nyes brutt\u00f3 \u00e1r<\/li>\n<li>\u00dcss\u00fck le az <em>F5<\/em> funkci\u00f3billenty\u0171t, majd a k\u00e9perny\u0151n megjelen\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fck be az F2:F20 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-ee1fcc5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ee1fcc5\" 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-69fec7e\" data-id=\"69fec7e\" 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-3359833 elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"3359833\" 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-baf0706 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"baf0706\" 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-e25bb7b\" data-id=\"e25bb7b\" 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-d28e072 elementor-widget elementor-widget-text-editor\" data-id=\"d28e072\" 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 F2 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=D2-D2*E2 <\/strong>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-eb96788 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eb96788\" 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-7f12f1f\" data-id=\"7f12f1f\" 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-4794924 elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"4794924\" 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-c84692f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c84692f\" 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-6649b05\" data-id=\"6649b05\" 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-0bf22fb elementor-widget elementor-widget-text-editor\" data-id=\"0bf22fb\" 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>A C21:E21 tartom\u00e1nyban a h\u00e1rom oszlop \u00e9rt\u00e9keinek \u00e1tlag\u00e1t kell kisz\u00e1molnunk. G\u00e9pelj\u00fck be az A21 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li>\n<li>Jel\u00f6lj\u00fck ki a C21:E21 tartom\u00e1nyt!<\/li>\n<li>Az \u00e1tlagsz\u00e1m\u00edt\u00f3 k\u00e9pletek l\u00e9trehoz\u00e1s\u00e1hoz adjuk ki a <strong>Kezd\u0151lap \/ AutoSzum \/ \u00c1tlag <\/strong><em>(Alt+\u0150, D, L)<\/em> parancsot! \u00c1lljunk az E21 cell\u00e1ra, majd \u00fcss\u00fck le a <em>Ctrl+Shift+5<\/em> billenty\u0171kombin\u00e1ci\u00f3t a <strong>Sz\u00e1zal\u00e9k Sz\u00e1mform\u00e1tum<\/strong> be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<li>A C25 cell\u00e1ban ki kell sz\u00e1molnunk, hogy mennyi lenne a nett\u00f3 fizetend\u0151 \u00f6sszeg, ha minden git\u00e1rb\u00f3l 3-3 darabot v\u00e1s\u00e1roln\u00e1nk! Egyszer\u0171en adjuk \u00f6ssze a C2:C20 tartom\u00e1ny \u00e9rt\u00e9keit, \u00e9s szorozzuk meg h\u00e1rommal: <strong>=SZUM(C2:C20)*3<\/strong>. Helyezz\u00fck az akt\u00edv cell\u00e1t a C25 cell\u00e1ra, majd g\u00e9pelj\u00fck be ezt a k\u00e9pletet!<\/li>\n<li>A G2:G20 tartom\u00e1nyban a brutt\u00f3 (D oszlop) \u00e9s a nett\u00f3 \u00e1rak (C oszlop) k\u00fcl\u00f6nbs\u00e9g\u00e9t kell k\u00e9pezn\u00fcnk. G\u00e9pelj\u00fck be a G1 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Brutt\u00f3-Nett\u00f3<\/li>\n<li>Az\u00a0<em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki a G2:G20 tartom\u00e1nyt!<\/li>\n<li>A G2 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=D2-C2 <\/strong>k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A B26 cell\u00e1ban a legdr\u00e1g\u00e1bb git\u00e1r nev\u00e9t kell megjelen\u00edten\u00fcnk k\u00e9plet seg\u00edts\u00e9g\u00e9vel, vagyis a Nett\u00f3 \u00e1r (C) oszlop legnagyobb \u00e9rt\u00e9k\u00e9hez tartoz\u00f3 B oszlopbeli Cikknevet kell megadnunk. Bontsuk r\u00e9szekre a probl\u00e9m\u00e1t: el\u0151sz\u00f6r ki kell keresn\u00fcnk a C2:C20 tartom\u00e1ny legnagyobb \u00e9rt\u00e9k\u00e9t. Ehhez a MAX f\u00fcggv\u00e9nyt h\u00edvjuk seg\u00edts\u00e9g\u00fcl: MAX(C2:C20). Ezut\u00e1n arra vagyunk k\u00edv\u00e1ncsiak, hogy ez az \u00e9rt\u00e9k h\u00e1nyadik cell\u00e1ban van a C2:C20 tartom\u00e1nyon bel\u00fcl. Erre val\u00f3 a HOL.VAN f\u00fcggv\u00e9ny, amely az els\u0151 argumentumak\u00e9nt megadott \u00e9rt\u00e9ket megkeresi a m\u00e1sodik argumentumak\u00e9nt megadott tartom\u00e1nyban (a harmadik argumentum 0, ami a keres\u00e9s m\u00f3dj\u00e1t szab\u00e1lyozza): HOL.VAN(MAX(C2:C20);C2:C20;0). A\u00a0kapott sz\u00e1m alkalmas lesz arra, hogy a B2:B20 tartom\u00e1nyban az INDEX f\u00fcggv\u00e9ny seg\u00edts\u00e9g\u00e9vel megkapjuk az \u00e9rt\u00e9khez tartoz\u00f3 Cikknevet. Az INDEX f\u00fcggv\u00e9ny els\u0151 argumentuma a B2:B20 tartom\u00e1nyc\u00edm, m\u00e1sodik pedig annak a cell\u00e1nak a sz\u00e1ma, amelynek \u00e9rt\u00e9k\u00e9t eredm\u00e9ny\u00fcl v\u00e1rjuk. A k\u00e9sz k\u00e9plet a k\u00f6vetkez\u0151: <strong>=INDEX(B2:B20; HOL.VAN(MAX(C2:C20);C2:C20;0))<\/strong><\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c3df4b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c3df4b\" 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-f3abfc0\" data-id=\"f3abfc0\" 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-6d0df50 elementor-widget elementor-widget-global elementor-global-17334 elementor-widget-text-editor\" data-id=\"6d0df50\" 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 olyan feladatot kapunk, amelynek sor\u00e1n egy tartom\u00e1nynak <strong>nem az els\u0151 sor\u00e1ban vagy oszlop\u00e1ban<\/strong> kell egy \u00e9rt\u00e9ket kikeresn\u00fcnk, majd az \u00e9rt\u00e9khez tartoz\u00f3 megadott sz\u00e1m\u00fa oszlop vagy sor cell\u00e1j\u00e1nak tartalm\u00e1t visszaadnunk, akkor a fenti k\u00e9plet egy lehets\u00e9ges megold\u00e1s.<br \/>A fenti k\u00e9pletet oszlopban keres\u00e9s eset\u00e9n a k\u00f6vetkez\u0151k\u00e9ppen haszn\u00e1ljuk: <strong>=INDEX(visszaadand\u00f3 \u00e9rt\u00e9k oszlop\u00e1nak tartom\u00e1nyc\u00edme; HOL.VAN(keresett \u00e9rt\u00e9k;a keresett \u00e9rt\u00e9ket tartalmaz\u00f3 oszlop tartom\u00e1nyc\u00edme;0))<\/strong><br \/>Ha egy sorban keres\u00fcnk egy \u00e9rt\u00e9ket, \u00e9s egy m\u00e1sik sor ugyanazon oszlop\u00e1ban tal\u00e1lhat\u00f3 \u00e9rt\u00e9ket kell visszaadnunk, akkor a k\u00e9plet a k\u00f6vetkez\u0151: <strong>=INDEX(visszaadand\u00f3 \u00e9rt\u00e9k sor\u00e1nak tartom\u00e1nyc\u00edme;HOL.VAN(keresett \u00e9rt\u00e9k;a keresett \u00e9rt\u00e9ket tartalmaz\u00f3 sor tartom\u00e1nyc\u00edme;0))<\/strong><br \/>Ne feledj\u00fck, a fenti k\u00e9plet csak akkor haszn\u00e1lhat\u00f3, ha a visszaadand\u00f3 \u00e9s a keresett \u00e9rt\u00e9ket tartalmaz\u00f3 sor\/oszlop tartom\u00e1nya azonos sz\u00e1m\u00fa cell\u00e1b\u00f3l \u00e1ll.<\/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-4b85b85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b85b85\" 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-72c2e8d\" data-id=\"72c2e8d\" 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-44a8560 elementor-widget elementor-widget-text-editor\" data-id=\"44a8560\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"16\">\n<li>Helyezz\u00fck az az akt\u00edv cell\u00e1t a B26 cell\u00e1ra, majd g\u00e9pelj\u00fck be az <strong>=INDEX(B2:B20; HOL.VAN(MAX(C2:C20);C2:C20;0))<\/strong> k\u00e9pletet!<\/li>\n<li>Az eredeti t\u00e1bl\u00e1zatr\u00f3l (A1:E20) csatolt m\u00e1solatot kell k\u00e9sz\u00edten\u00fcnk egy \u00faj, megadott helyen \u00e9s n\u00e9vvel l\u00e9trehozand\u00f3 munkaf\u00fczetbe. A m\u0171velet sor\u00e1n m\u00e1solatot k\u00e9sz\u00edt\u00fcnk a tartom\u00e1nyr\u00f3l a V\u00e1g\u00f3lapra, majd k\u00e9sz\u00edt\u00fcnk egy \u00faj munkaf\u00fczetet, \u00e9s ir\u00e1ny\u00edtott beilleszt\u00e9ssel besz\u00farjuk a V\u00e1g\u00f3lap tartalm\u00e1t, v\u00e9g\u00fcl mentj\u00fck a munkaf\u00fczetet (a Dokumentumok mapp\u00e1ba, Felhaszn\u00e1l\u00f3Csatolt.xlsx n\u00e9ven). Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A1:E20 tartom\u00e1nyt!<\/li>\n<li>K\u00e9sz\u00edts\u00fcnk m\u00e1solatot a V\u00e1g\u00f3lapra a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+N<\/em> billenty\u0171kombin\u00e1ci\u00f3t egy \u00faj, \u00fcres munkaf\u00fczet k\u00e9sz\u00edt\u00e9s\u00e9hez!<\/li>\n<li>\u00dcss\u00fck le a <em>Shift+F10<\/em> billenty\u0171kombin\u00e1ci\u00f3t, \u00e9s a helyi men\u00fcb\u0151l v\u00e1lasszuk a <strong>Csatolt beilleszt\u00e9s (A)<\/strong> gombot! Az A1 cell\u00e1t\u00f3l megjelenik a t\u00e1bl\u00e1zat. Igaz\u00edtsunk az oszlopok sz\u00e9less\u00e9g\u00e9n a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g<\/strong> <em>(Alt+\u0150, FF, U)<\/em> paranccsal! Ha b\u00e1rmelyik cell\u00e1ra l\u00e9p\u00fcnk, l\u00e1tjuk, hogy mindegyik az \u00e1ltalunk k\u00e9sz\u00edtett munkaf\u00fczet megfelel\u0151 cell\u00e1j\u00e1ra hivatkozik, \u00fagynevezett k\u00fcls\u0151 hivatkoz\u00e1ssal.<\/li>\n<li>Nyomjuk le az <em>F12<\/em> funkci\u00f3billenty\u0171t a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>G\u00e9pelj\u00fck be a <strong>F\u00e1jln\u00e9v<\/strong> <em>(Alt+L)<\/em> kombin\u00e1lt szerkeszt\u0151mez\u0151be a megadott nevet, majd \u2013 ha sz\u00fcks\u00e9ges, \u2013 v\u00e1lasszuk ki a f\u00e1jl hely\u00e9nek sz\u00e1nt mapp\u00e1t, v\u00e9g\u00fcl ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> <em>(Alt+E)<\/em> gombot v\u00e1lasztva! A munkaf\u00fczet tartalm\u00e1t mutatja a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_2_TablazatCsatolt.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"2. \u00e1bra (opens in a new tab)\">2. \u00e1bra<\/a>.<\/li>\n<li>Z\u00e1rjuk be ezt a munkaf\u00fczetet az <em>Alt+F4<\/em> billenty\u0171kombin\u00e1ci\u00f3val, majd t\u00e9rj\u00fcnk vissza az M4-41 munkalapra!<\/li>\n<li>A k\u00f6vetkez\u0151 feladat a Nett\u00f3 \u00e1r \u00e9s a Brutt\u00f3 \u00e1r oszlopok form\u00e1tum\u00e1t k\u00e9ri <strong>P\u00e9nznem<\/strong> t\u00edpus\u00fara m\u00f3dos\u00edtani, nulla tizedeshellyel. Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki a C2:D20 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+Shift+4<\/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-a879c59 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a879c59\" 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-6369956\" data-id=\"6369956\" 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-a95ecf5 elementor-widget elementor-widget-global elementor-global-17120 elementor-widget-text-editor\" data-id=\"a95ecf5\" 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-7fc80da elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7fc80da\" 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-2bf33ac\" data-id=\"2bf33ac\" 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-ef87bf0 elementor-widget elementor-widget-text-editor\" data-id=\"ef87bf0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"25\">\n<li>A tizedeshelyek sz\u00e1m\u00e1t a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se <\/strong><em>(Alt+\u0150, 9)<\/em> parancs k\u00e9tszeri kiad\u00e1s\u00e1val null\u00e1zzuk le!<\/li>\n<li>Egy-egy v\u00edzszintes szeg\u00e9llyel el kell v\u00e1lasztanunk egym\u00e1st\u00f3l a t\u00e1bl\u00e1zat sorait az F oszlopig, vagyis az A1:F20 tartom\u00e1ny sorainak fels\u0151 \u00e9s als\u00f3 sz\u00e9l\u00e9n fogunk be\u00e1ll\u00edtani egy-egy <strong>K\u00f6zepes<\/strong> szeg\u00e9lyt. Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A1:F20 tartom\u00e1nyt!<\/li>\n<li>Jelen\u00edts\u00fck meg a <strong>Cell\u00e1k form\u00e1z\u00e1sa <\/strong>p\u00e1rbesz\u00e9dablakot a <em>Ctrl+1<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>L\u00e9pj\u00fcnk a <em>Ctrl+Tab<\/em> billenty\u0171kombin\u00e1ci\u00f3val a <strong>Szeg\u00e9ly<\/strong> f\u00fclre!<\/li>\n<li>L\u00e9pj\u00fcnk a <em>Tab<\/em> billenty\u0171vel a <strong>St\u00edlus<\/strong> <em>(Alt+S)<\/em> list\u00e1ra, \u00e9s a <em>Le-Fel ny\u00edlbillenty\u0171kkel <\/em>v\u00e1lasszuk ki p\u00e9ld\u00e1ul a <strong>K\u00f6zepes <\/strong>v\u00e1laszt\u00f3gombot, majd a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel jel\u00f6lj\u00fck ki!<\/li>\n<li>A <strong>Szeg\u00e9ly<\/strong> r\u00e9szben tal\u00e1lhat\u00f3 jel\u00f6l\u0151n\u00e9gyzetekkel ki kell v\u00e1lasztanunk, hol akarunk vonalakat h\u00fazni. Nek\u00fcnk a <strong>Fent<\/strong>, a <strong>V\u00edzszintesen<\/strong> \u00e9s a <strong>Lent<\/strong> jel\u00f6l\u0151n\u00e9gyzeteket kell bejel\u00f6ln\u00fcnk. Keress\u00fck meg ezeket a jel\u00f6l\u0151n\u00e9gyzeteket a <em>Tab<\/em> billenty\u0171vel, majd a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel egyenk\u00e9nt jel\u00f6lj\u00fck be azokat, vagy sorban egym\u00e1s ut\u00e1n \u00fcss\u00fck le az <em>Alt+T<\/em>, az <em>Alt+I<\/em> \u00e9s az <em>Alt+L<\/em> billenty\u0171kombin\u00e1ci\u00f3kat!<\/li>\n<li>A be\u00e1ll\u00edt\u00e1sok \u00e9rv\u00e9nyre juttat\u00e1s\u00e1hoz \u00e9s a <strong>Cell\u00e1k form\u00e1z\u00e1sa <\/strong>p\u00e1rbesz\u00e9dablakb\u00f3l val\u00f3 kil\u00e9p\u00e9shez \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az A1 cell\u00e1ba a Git\u00e1r kateg\u00f3ri\u00e1k kifejez\u00e9st kell k\u00e9t sorba t\u00f6rdelve megjelen\u00edten\u00fcnk. Helyezz\u00fck az akt\u00edv cell\u00e1t az A1-re, g\u00e9pelj\u00fck be a Git\u00e1r sz\u00f3t, \u00fcss\u00fck le az <em>Alt+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd g\u00e9pelj\u00fck be a kateg\u00f3ri\u00e1k sz\u00f3t, 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-640e273 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"640e273\" 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-b3893e0\" data-id=\"b3893e0\" 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-e0e0a80 elementor-widget elementor-widget-global elementor-global-17410 elementor-widget-text-editor\" data-id=\"e0e0a80\" 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>Alt+Enter<\/i> billenty\u0171kombin\u00e1ci\u00f3val t\u00f6bb sorba t\u00f6rdelt sz\u00f6veget g\u00e9pelhet\u00fcnk a cell\u00e1ba. A t\u00f6rdel\u00e9sen nem v\u00e1ltoztat a cell\u00e1k sz\u00e9less\u00e9g\u00e9nek v\u00e1ltoz\u00e1sa. A sormagass\u00e1got viszont t\u00f6bbnyire meg kell n\u00f6veln\u00fcnk, ha a teljes sz\u00f6veget l\u00e1tni akarjuk.<br \/>Ezt a billenty\u0171kombin\u00e1ci\u00f3t akkor \u00e9rdemes haszn\u00e1lnunk, ha a t\u00f6rdel\u00e9st magunk akarjuk szab\u00e1lyozni. Ha az Excelre akarjuk b\u00edzni a t\u00f6rdel\u00e9st, akkor a <strong>Cell\u00e1k form\u00e1z\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablak <strong>Igaz\u00edt\u00e1s<\/strong> lapf\u00fcl\u00e9n tal\u00e1lhat\u00f3 <strong>Sort\u00f6r\u00e9ssel t\u00f6bb sorba <\/strong><i>(Alt+S)<\/i> jel\u00f6l\u0151n\u00e9gyzetet kell bekapcsolnunk. Ezt a jel\u00f6l\u0151n\u00e9gyzetet az Excel akkor is bekapcsolja, ha az <i>Alt+Enter<\/i> billenty\u0171kombin\u00e1ci\u00f3val magunk t\u00f6rdelj\u00fck be a cella 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-8ce4020 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ce4020\" 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-174b766\" data-id=\"174b766\" 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-287ee61 elementor-widget elementor-widget-text-editor\" data-id=\"287ee61\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"33\">\n<li>Az A1:E1 tartom\u00e1ny cell\u00e1inak tartalm\u00e1t f\u00fcgg\u0151legesen \u00e9s v\u00edzszintesen k\u00f6z\u00e9pre kell igaz\u00edtanunk, \u00e9s meg kell dupl\u00e1znunk a sormagass\u00e1got. Mi azonban adtunk nevet az F \u00e9s a G oszlopoknak is, \u00edgy ink\u00e1bb az A1:G1 tartom\u00e1nyt jel\u00f6lj\u00fck ki!<\/li>\n<li>Kezdj\u00fck a sormagass\u00e1ggal: adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Sormagass\u00e1g <\/strong><em>(Alt+\u0150, FF, G)<\/em> parancsot! Ezzel a be\u00e1ll\u00edt\u00e1ssal most m\u00e1r l\u00e1tszani fog az A1 cell\u00e1ba beg\u00e9pelt k\u00e9tsoros c\u00edmke.<\/li>\n<li>A k\u00e9perny\u0151n megjelen\u0151 <strong>Sormagass\u00e1g<\/strong> p\u00e1rbesz\u00e9dablak szerkeszt\u0151mez\u0151j\u00e9ben tal\u00e1lhat\u00f3 13,5 \u00e9rt\u00e9ket jav\u00edtsuk \u00e1t 27-re, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A k\u00f6z\u00e9pre igaz\u00edt\u00e1shoz adjuk ki a <strong>Kezd\u0151lap \/ K\u00f6z\u00e9pre v\u00edzszintesen igaz\u00edt\u00e1s<\/strong> <em>(Alt+\u0150, KZ)<\/em> \u00e9s a <strong>Kezd\u0151lap \/ K\u00f6z\u00e9pre f\u00fcgg\u0151legesen igaz\u00edt\u00e1s<\/strong> <em>(Alt+\u0150, KK)<\/em> parancsokat!<\/li>\n<li>Csoportos\u00edtott oszlopdiagramot kell l\u00e9trehoznunk a munkalapon a sz\u00f3l\u00f3git\u00e1rok nett\u00f3 \u00e1r\u00e1t a cikknev\u00fckkel \u00e1br\u00e1zolva. Az x tengelyen a cikkek nev\u00e9t (B17:B20), az y tengelyen pedig a nett\u00f3 \u00e1rakat (C17:C20) kell megjelen\u00edten\u00fcnk. Term\u00e9szetesen sz\u00fcks\u00e9g\u00fcnk van az adatsorok megnevez\u00e9s\u00e9re, vagyis a B1:C1 cell\u00e1k tartalm\u00e1ra is. 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: B1:C1;B17:C20<\/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-6ab53d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ab53d5\" 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-1174333\" data-id=\"1174333\" 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-1adee87 elementor-widget elementor-widget-text-editor\" data-id=\"1adee87\" 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 2:16 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 a B1:C1;B17:C20 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcletet, akkor l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek egy folytonos t\u00e9glalapot mint\u00e1znak.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fd91486 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd91486\" 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-9b2c8f1\" data-id=\"9b2c8f1\" 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-6972e0f elementor-widget elementor-widget-text-editor\" data-id=\"6972e0f\" 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=\"38\">\n<li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Oszlop- \u00e9s s\u00e1vdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, \u00da)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a <strong>Csoportos\u00edtott oszlop <\/strong>kiv\u00e1laszt\u00e1s\u00e1hoz! A munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9n megjelenik a kijel\u00f6lt diagram.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a3e25ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3e25ef\" 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-c42318c\" data-id=\"c42318c\" 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-a979901 elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"a979901\" 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-50b3ad3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50b3ad3\" 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-9fb87b4\" data-id=\"9fb87b4\" 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-733ec2d elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"733ec2d\" 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-3bd71ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3bd71ea\" 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-575a575\" data-id=\"575a575\" 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-b1f4a36 elementor-widget elementor-widget-text-editor\" data-id=\"b1f4a36\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"39\">\n<li>A diagram eltakarja a t\u00e1bl\u00e1zatot, ami nagyon zavar\u00f3. Helyezz\u00fck \u00e1t p\u00e9ld\u00e1ul az I2 cell\u00e1ba: \u00fcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd l\u00e9ptess\u00fck az akt\u00edv cell\u00e1t az I2 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0948047 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0948047\" 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-c5b8a57\" data-id=\"c5b8a57\" 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-3482310 elementor-widget elementor-widget-global elementor-global-16948 elementor-widget-text-editor\" data-id=\"3482310\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Ha feladatunk egy diagram besz\u00far\u00e1sa az aktu\u00e1lis munkalapra, akkor az t\u00f6bbnyire eltakarja a t\u00e1bl\u00e1zatot. Ez\u00e9rt c\u00e9lszer\u0171 sz\u00e1m\u00e1ra m\u00e1sik helyet keresni, p\u00e9ld\u00e1ul a t\u00e1bl\u00e1zat alatt: a <em>Ctrl+X<\/em> le\u00fct\u00e9s\u00e9vel helyezz\u00fck a V\u00e1g\u00f3lapra a diagramot, majd a visszakapott akt\u00edv cell\u00e1t mozgassuk a diagram bal fels\u0151 sark\u00e1nak helyet ad\u00f3 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t! A diagram kijel\u00f6lt \u00e1llapotban marad.<br \/>Persze, ha a vizsg\u00e1n ezt nem k\u00e9rik, vagy kifejezetten tiltj\u00e1k, akkor hagyjuk ki ezt a l\u00e9p\u00e9st.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9346b58 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9346b58\" 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-dc13197\" data-id=\"dc13197\" 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-af8b411 elementor-widget elementor-widget-text-editor\" data-id=\"af8b411\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"40\">\n<li>A diagram c\u00edm\u00e9nek megad\u00e1s\u00e1hoz adjuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ A diagram felett <\/strong><em>(Alt+JC, D, C, A)<\/em> parancsot! Ezzel a c\u00edmet a diagram f\u00f6l\u00e9, k\u00f6z\u00e9pre helyezz\u00fck, egyben kijel\u00f6ltt\u00e9 tessz\u00fck azt a szerkeszt\u00e9shez.<\/li>\n<li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be az \u00c1rak Ft-ban kifejez\u00e9st, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az x tengely felirat\u00e1ul a Sz\u00f3l\u00f3git\u00e1rok sz\u00f3t kell megjelen\u00edten\u00fcnk. Adjuk ki a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Tengelyc\u00edmek \/ Els\u0151dleges v\u00edzszintes <\/strong><em>(Alt+JC, D, M, S)<\/em> parancsot! Az x tengely alatt megjelenik a Tengelyc\u00edm felirat.<\/li>\n<li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be a Sz\u00f3l\u00f3git\u00e1rok sz\u00f3t, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az adatpontokhoz tartoz\u00f3 \u00e9rt\u00e9kek megjelen\u00edt\u00e9s\u00e9hez adjuk ki p\u00e9ld\u00e1ul a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Adatfeliratok \/ \u00c9rt\u00e9kn\u00e9l, k\u00edv\u00fcl <\/strong><em>(Alt+JC, D, A, K)<\/em> parancsot!<\/li>\n<li>Az\u00a0elk\u00e9sz\u00fclt t\u00e1bl\u00e1zatot \u00e9s diagramot \u00e9s mutatja az <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_1_TablazatDiagram.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"1. \u00e1bra (opens in a new tab)\">1. \u00e1bra<\/a>.<\/li>\n<li>Utols\u00f3 feladatunk az A1:D20 tartom\u00e1ny nyomtat\u00e1sa a sor- \u00e9s oszlopfejl\u00e9cekkel. Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki ezt a tartom\u00e1nyt, egyben megsz\u00fcntetve a diagram kijel\u00f6lt \u00e1llapot\u00e1t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1a9171c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a9171c\" 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-0049a91\" data-id=\"0049a91\" 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-04c2c23 elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"04c2c23\" 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-7bd2b07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7bd2b07\" 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-4e69eef\" data-id=\"4e69eef\" 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-9effd56 elementor-widget elementor-widget-text-editor\" data-id=\"9effd56\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"47\">\n<li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Nyomtat\u00e1si ter\u00fclet \/ Nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se<\/strong> <em>(Alt+P, I, K)<\/em> parancsot!<\/li>\n<li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> <em>(Alt+P, O)<\/em> parancsot!<\/li>\n<li>Az <strong>Oldal<\/strong> f\u00fcl\u00f6n v\u00e1lasszuk ki az <strong>\u00c1ll\u00f3 T\u00e1jol\u00e1st <\/strong><em>(Alt+L)<\/em>, a <strong>Nagy\u00edt\u00e1s<\/strong> r\u00e9szben a <strong>Legyen <\/strong><em>(Alt+N) <\/em>v\u00e1laszt\u00f3gombot!<\/li>\n<li>A <em>Ctrl+Tab<\/em> billenty\u0171kombin\u00e1ci\u00f3 seg\u00edts\u00e9g\u00e9vel l\u00e9pj\u00fcnk a <strong>Munkalap<\/strong> lapf\u00fclre!<\/li>\n<li>Keress\u00fck meg a <strong>Sor- \u00e9s oszlopfejl\u00e9cekkel<\/strong> <em>(Alt+E)<\/em> jel\u00f6l\u0151n\u00e9gyzetet, \u00e9s kapcsoljuk be a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel!<\/li>\n<li>\u00dcss\u00fck le az <em>Enter<\/em> billenty\u0171t az <strong>Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> ablakb\u00f3l val\u00f3 kil\u00e9p\u00e9shez!<\/li>\n<li>Adjuk ki a <strong>F\u00e1jl \/ Export\u00e1l\u00e1s<\/strong> parancsot, \u00e9s keress\u00fck meg a <strong>PDF\/XPS l\u00e9trehoz\u00e1sa<\/strong> <em>(Alt+F, E, A) <\/em>gombot!<\/li>\n<li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel PDF vagy XPS form\u00e1tumban<\/strong> p\u00e1rbesz\u00e9dablak, amelynek <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben l\u00e1tjuk a munkaf\u00fczet nev\u00e9t, amit el is fogadhatunk.<\/li>\n<li>Ments\u00fcnk a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> <em>(Alt+K)<\/em> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-77b7e84 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77b7e84\" 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-475c753\" data-id=\"475c753\" 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-aeee06e elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"aeee06e\" 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-a2594a7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a2594a7\" 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-03a54f7\" data-id=\"03a54f7\" 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-df559d4 elementor-widget elementor-widget-text-editor\" data-id=\"df559d4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"56\">\n<li>Ha sz\u00e1m\u00edt\u00f3g\u00e9p\u00fcnk\u00f6n van PDF kezel\u0151 alkalmaz\u00e1s vagy b\u00f6ng\u00e9sz\u0151, akkor azt az Excel megpr\u00f3b\u00e1lja elind\u00edtani \u00e9s megjelen\u00edteni a f\u00e1jl tartalm\u00e1t (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_3_PDF.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"3. \u00e1bra (opens in a new tab)\">3. \u00e1bra<\/a>).<\/li>\n<li>A feladattal v\u00e9gezt\u00fcnk, ments\u00fcnk \u00e9s z\u00e1rjunk be minden f\u00e1jlt \u00e9s alkalmaz\u00e1st!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5f98500 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f98500\" 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-8779e3b\" data-id=\"8779e3b\" 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-4b963ca elementor-widget elementor-widget-text-editor\" data-id=\"4b963ca\" 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: kett\u0151 Excel munkaf\u00fczetet \u00e9s egy PDF dokumentumot (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/08\/247-K-ECDLM04S6-Vizsgafeladat41_Megoldas1_4_Fajlok.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"4. \u00e1bra (opens in a new tab)\">4. \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-038f34a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"038f34a\" 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-0cd9cdf\" data-id=\"0cd9cdf\" 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-d1f4dd6 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"d1f4dd6\" 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-c3c6cb9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3c6cb9\" 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-c39a371\" data-id=\"c39a371\" 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-7c6cbd0 elementor-widget elementor-widget-text-editor\" data-id=\"7c6cbd0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 j\u00falius 18.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (21H2, 2111b19044)<br \/>Irodai programcsomag: Microsoft Office 2016 v2206b15330.20266, Aktu\u00e1lis csatorna<br \/>Szint: kezd\u0151, ECDL modul\/tanmenet: T\u00e1bl\u00e1zatkezel\u00e9s\/S6<br \/>Kateg\u00f3ria: ECDL \u2192 T\u00e1bl\u00e1zatkezel\u00e9s \u2192 Vizsgafeladatok<\/b><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ae06901 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae06901\" 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-ab5e656\" data-id=\"ab5e656\" 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-9526b1d elementor-widget elementor-widget-shortcode\" data-id=\"9526b1d\" 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--6293 \"        data-post-id=\"6293\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-6293\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-6293\">                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-37d07fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37d07fc\" 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-b2f1aca\" data-id=\"b2f1aca\" 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-4fa20f6 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=\"4fa20f6\" 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 augusztus 1. 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 41. 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=6293\">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-6293","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/6293","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=6293"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/6293\/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=6293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}