{"id":6147,"date":"2020-07-14T08:37:52","date_gmt":"2020-07-14T06:37:52","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=6147"},"modified":"2022-08-07T14:29:19","modified_gmt":"2022-08-07T12:29:19","slug":"ecdl-tablazatkezeles-36-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=6147","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 36. vizsgafeladat (#242\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"6147\" class=\"elementor elementor-6147\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-40f5175 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"40f5175\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fb72eff\" data-id=\"fb72eff\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-137c997 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"137c997\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0Friss\u00edtve: 2022 j\u00falius 31.<\/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-7dc638e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7dc638e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-43494fa\" data-id=\"43494fa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0204196 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"0204196\" 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-b7ed1cd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b7ed1cd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-57da00a\" data-id=\"57da00a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5eb9fa5 elementor-widget elementor-widget-text-editor\" data-id=\"5eb9fa5\" 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 36. 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-0df844c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0df844c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-85e1ee6\" data-id=\"85e1ee6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-daa5bc5 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"daa5bc5\" 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__daa5bc5\" 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__daa5bc5\" 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__daa5bc5\" 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-5686d4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5686d4f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-88d4712\" data-id=\"88d4712\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-afbdbed elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"afbdbed\" 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\/242-K-ECDLM04S6-Vizsgafeladat36.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 36. 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-63c69bd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63c69bd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-53ce371\" data-id=\"53ce371\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fae337f elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"fae337f\" 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-6863f24 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6863f24\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-46779d9\" data-id=\"46779d9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3473bfc elementor-widget elementor-widget-text-editor\" data-id=\"3473bfc\" 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\/242-K-ECDLM04S6-Vizsgafeladat36.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-4f362a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f362a5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fa60812\" data-id=\"fa60812\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d8e16c6 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"d8e16c6\" 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, helyes\u00edr\u00e1s-ellen\u0151rz\u00e9s, 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, 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 href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MAX<\/a>, <a href=\"https:\/\/www.fiatluxefel.info\/?page_id=2851\">MIN<\/a>, SZUM.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-473a765 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"473a765\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f92dbfc\" data-id=\"f92dbfc\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9c2ca07 elementor-widget elementor-widget-text-editor\" data-id=\"9c2ca07\" 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-633f985 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"633f985\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4435025\" data-id=\"4435025\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1847028 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"1847028\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_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\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-26371\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 36. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat \u00e9s a vonaldiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_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 a vonaldiagram.<\/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-8302d8b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8302d8b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4d9add0\" data-id=\"4d9add0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a9ecd0 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"9a9ecd0\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-26372\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 36. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: 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-bb0e549 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb0e549\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5487d07\" data-id=\"5487d07\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dcd924c elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"dcd924c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-26373\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 36. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_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\">3. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1206468 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1206468\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-10d4189\" data-id=\"10d4189\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c1ffc03 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"c1ffc03\" 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-e07c8f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e07c8f6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-62185c5\" data-id=\"62185c5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-547b668 elementor-widget elementor-widget-text-editor\" data-id=\"547b668\" 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 (62 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-8dca7c1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8dca7c1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f923fa1\" data-id=\"f923fa1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8e4be1c elementor-widget elementor-widget-text-editor\" data-id=\"8e4be1c\" 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-36.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-cf71057 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf71057\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5fbfa67\" data-id=\"5fbfa67\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-544d132 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"544d132\" 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-32b118e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"32b118e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c5fce29\" data-id=\"c5fce29\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-27c0430 elementor-widget elementor-widget-text-editor\" data-id=\"27c0430\" 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-36 munkalap A1:J11 tartom\u00e1nya egy t\u0151zsde napi elad\u00e1sainak sz\u00e1m\u00e1t, valamint a t\u0151zsde indexeket mutatja k\u00e9t h\u00e9ten, vagyis t\u00edz munkanapon \u00e1t, 9-t\u0151l 16 \u00f3r\u00e1ig, \u00f3r\u00e1nk\u00e9nti l\u00e9p\u00e9sk\u00f6zzel. A munkanapok d\u00e1tumait az A oszlop, a napi elad\u00e1sok sz\u00e1m\u00e1t az Elad\u00e1sok sz\u00e1ma (B) oszlop tartalmazza. A napi t\u0151zsdeindexeket 9:00-t\u00f3l 16:00-ig a C:J oszlopokban tal\u00e1ljuk. Az A oszlop sz\u00e1mform\u00e1tuma <strong>R\u00f6vid d\u00e1tumforma<\/strong>, a C1:J1 tartom\u00e1nyban tal\u00e1lhat\u00f3 id\u0151pontok <strong>Id\u0151<\/strong> adatt\u00edpus\u00faak \u00d3\u00d3:PP form\u00e1tumban. A B2:J11 tartom\u00e1nyban tal\u00e1lhat\u00f3 sz\u00e1mok form\u00e1tuma <strong>\u00c1ltal\u00e1nos<\/strong>.<\/li>\n<li>Az els\u0151 feladat szerint a K oszlopban a t\u0151zsdeindexek, vagyis a C:J oszlopok \u00e1tlag\u00e1t kell k\u00e9pezn\u00fcnk. Helyezz\u00fck az akt\u00edv cell\u00e1t a K1 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li>\n<li>\u00dcss\u00fck le az <em>F5<\/em> funkci\u00f3billenty\u0171t, majd a k\u00e9perny\u0151n megjelen\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fck be a K2:K11 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-d0b1f85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d0b1f85\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8e3c947\" data-id=\"8e3c947\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b219dac elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"b219dac\" 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-dfa7f01 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dfa7f01\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-86b62ff\" data-id=\"86b62ff\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c80974 elementor-widget elementor-widget-text-editor\" data-id=\"0c80974\" 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>A K2 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=\u00c1TLAG(C2:J2)<\/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-e1aa0fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e1aa0fa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-376499d\" data-id=\"376499d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fe7b5b0 elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"fe7b5b0\" 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-dad65eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dad65eb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ce611e\" data-id=\"5ce611e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8311222 elementor-widget elementor-widget-text-editor\" data-id=\"8311222\" 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>Az L oszlopban a napi legmagasabb \u00e9rt\u00e9keket kell kisz\u00e1molnunk a MAX f\u00fcggv\u00e9ny seg\u00edts\u00e9g\u00e9vel. Helyezz\u00fck az akt\u00edv cell\u00e1t az L1 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Cs\u00facs<\/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 L2:L11 tartom\u00e1nyhivatkoz\u00e1st, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A K2 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=MAX(C2:J2)<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A B12 cell\u00e1ban a napi elad\u00e1sok \u00f6sszeg\u00e9t kell k\u00e9pezn\u00fcnk. Helyezz\u00fck az akt\u00edv cell\u00e1t a B12 cell\u00e1ra, majd adjuk ki a <strong>Kezd\u0151lap \/ AutoSzum \/ Szum <\/strong><em>(Alt+\u0150, D, Enter)<\/em> parancsot! A cell\u00e1ban megjelenik az <strong>=SZUM(B2:B11)<\/strong> k\u00e9plet, amit az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel el is fogadhatunk.<\/li>\n<li>Az M oszlopban a t\u0151zsdeindex napi ingadoz\u00e1s\u00e1t, vagyis a k\u00e9t sz\u00e9ls\u0151 \u00e9rt\u00e9k k\u00fcl\u00f6nbs\u00e9g\u00e9t kell megjelen\u00edten\u00fcnk. A k\u00e9t sz\u00e9ls\u0151 \u00e9rt\u00e9ket a MAX \u00e9s a MIN f\u00fcggv\u00e9nyekkel tal\u00e1ljuk meg, majd ezek k\u00fcl\u00f6nbs\u00e9g\u00e9t kell k\u00e9pezn\u00fcnk. Mivel a legnagyobb t\u0151zsdeindexeket m\u00e1r kisz\u00e1moltuk az L oszlopban, csak a MIN f\u00fcggv\u00e9ny haszn\u00e1lat\u00e1ra lesz sz\u00fcks\u00e9g\u00fcnk. N\u00e9zz\u00fck, hogyan n\u00e9z ki a k\u00e9plet az M2 cell\u00e1ban: <strong>=L2-MIN(C2:J2)<\/strong><\/li>\n<li>G\u00e9pelj\u00fck be az M1 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Napi ingadoz\u00e1s<\/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 M2:M11 tartom\u00e1nyhivatkoz\u00e1st, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az M2 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=L2-MIN(C2:J2)<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>Az els\u0151 h\u00e9t adatait <strong>Z\u00f6ld<\/strong> kit\u00f6lt\u0151sz\u00ednnel kell ell\u00e1tnunk. Jel\u00f6lj\u00fck ki az A2:M6 tartom\u00e1nyt!<\/li>\n<li>\u00c1ll\u00edtsuk be a <strong>Z\u00f6ld <\/strong>kit\u00f6lt\u0151sz\u00ednt a <strong>Kezd\u0151lap \/ Kit\u00f6lt\u0151sz\u00edn <\/strong><em>(Alt+\u0150, H1)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel! A paletta <strong>Alapsz\u00ednek <\/strong>r\u00e9sz\u00e9ben a hatodik a <strong>Z\u00f6ld <\/strong>sz\u00edn, amit a <em>ny\u00edlbillenty\u0171kkel<\/em> l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li>\n<li>A m\u00e1sodik h\u00e9t adatait <strong>Z\u00f6ld<\/strong> bet\u0171sz\u00ednnel kell ell\u00e1tnunk. Jel\u00f6lj\u00fck ki az A7:M11 tartom\u00e1nyt!<\/li>\n<li>\u00c1ll\u00edtsuk be a <strong>Z\u00f6ld <\/strong>bet\u0171sz\u00ednt a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel! A paletta <strong>Alapsz\u00ednek <\/strong>r\u00e9sz\u00e9ben a hatodik a <strong>Z\u00f6ld <\/strong>sz\u00edn, amit a <em>ny\u00edlbillenty\u0171kkel<\/em> l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li>\n<li>Az A oszlop d\u00e1tumainak form\u00e1tum\u00e1t \u00fagy kell m\u00f3dos\u00edtanunk, hogy a h\u00f3napnevek sz\u00f6vegesen jelenjenek meg. Jel\u00f6lj\u00fck ki az A2:A11 tartom\u00e1nyt!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+1<\/em> billenty\u0171kombin\u00e1ci\u00f3t a <strong>Cell\u00e1k form\u00e1z\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>L\u00e9pj\u00fcnk a <em>Ctrl+Tab<\/em> billenty\u0171kombin\u00e1ci\u00f3val a <strong>Sz\u00e1m<\/strong> lapf\u00fclre!<\/li>\n<li>A <em>Tab<\/em> billenty\u0171vel l\u00e9pj\u00fcnk a <strong>Kateg\u00f3ria<\/strong> list\u00e1ra, majd v\u00e1lasszuk ki a <strong>D\u00e1tum<\/strong> kateg\u00f3ri\u00e1t!<\/li>\n<li>\u00dcss\u00fck le a <em>Tab<\/em> billenty\u0171t, hogy a <strong>T\u00edpus<\/strong> list\u00e1ra l\u00e9pj\u00fcnk, majd a <em>Le <\/em>\u00e9s <em>Fel ny\u00edlbillenty\u0171kkel<\/em> v\u00e1lasszunk egy olyan d\u00e1tumform\u00e1tumot, amelyben benne van az \u00e9vsz\u00e1m, a h\u00f3nap neve sz\u00f6vegesen \u00e9s a nap! Ha megvan, l\u00e9pj\u00fcnk ki a p\u00e1rbesz\u00e9dablakb\u00f3l az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel!<\/li>\n<li>Mivel az oszlopok keskenynek bizonyulnak az \u00faj d\u00e1tumform\u00e1tum miatt, n\u00f6velj\u00fck meg a sz\u00e9less\u00e9g\u00fcket a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, U)<\/em> parancs kiad\u00e1s\u00e1val!<\/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> parancsot!<\/li>\n<li>A C2:J11 tartom\u00e1ny k\u00fcls\u0151 szeg\u00e9llyel kell ell\u00e1tnunk, valamint a cell\u00e1k \u00e9rt\u00e9keit <strong>Ezres csoport<\/strong> sz\u00e1mform\u00e1tumra kell alak\u00edtanunk. Jel\u00f6lj\u00fck ki a C2:J11 tartom\u00e1nyt!<\/li>\n<li>Adjuk ki p\u00e9ld\u00e1ul a <strong>Kezd\u0151lap \/ Szeg\u00e9lyek \/ Vastag k\u00fcls\u0151 szeg\u00e9ly <\/strong><em>(Alt+\u0150, GS, Y)<\/em> parancsot!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+Shift+1<\/em> billenty\u0171kombin\u00e1ci\u00f3t a <strong>Sz\u00e1m <\/strong>form\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3a163e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3a163e4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-24e23e4\" data-id=\"24e23e4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-89818bf elementor-widget elementor-widget-global elementor-global-17120 elementor-widget-text-editor\" data-id=\"89818bf\" 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-483a4f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"483a4f9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c2c3c48\" data-id=\"c2c3c48\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c50bc88 elementor-widget elementor-widget-text-editor\" data-id=\"c50bc88\" 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=\"30\">\n<li>A tizedeshelyek sz\u00e1m\u00e1t cs\u00f6kkents\u00fck null\u00e1ra a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se <\/strong><em>(Alt+\u0150, 9)<\/em> parancs k\u00e9tszeri kiad\u00e1s\u00e1val!<\/li>\n<li>Az A25 cell\u00e1ba be kell g\u00e9peln\u00fcnk a helyes\u00edr\u00e1s-ellen\u0151rz\u00e9s m\u00f3dj\u00e1t. Helyezz\u00fck az akt\u00edv cell\u00e1t az A25 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151t (m\u00e1soljuk le innen \u00e9s illessz\u00fck be): <strong>F7 (V\u00e9lem\u00e9nyez\u00e9s \/ Helyes\u00edr\u00e1s (Alt+O, 8))<\/strong><\/li>\n<li>Vonaldiagramot kell l\u00e9trehoznunk a munkalapon a szeptember 10-ei t\u0151zsdeindexekr\u0151l. A\u00a0d\u00e1tumot az A8 cella, a t\u0151zsdeindexeket a C8:J8 tartom\u00e1ny, a hozz\u00e1juk tartoz\u00f3 c\u00edmk\u00e9ket pedig az A1, illetve a C1:J1 tartom\u00e1ny tartalmazza. 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 az el\u0151bb felsorolt tartom\u00e1nyhivatkoz\u00e1sokat: A1;C1:J1;A8;C8:J8<\/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-5451273 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5451273\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20ecde5\" data-id=\"20ecde5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c347e47 elementor-widget elementor-widget-text-editor\" data-id=\"c347e47\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Amikor a diagramon megjelen\u00edtend\u0151 \u00e9rt\u00e9kek k\u00f6r\u00e9t meghat\u00e1rozzuk, \u00e1t kell gondolnunk, mely tartom\u00e1nyt kell kijel\u00f6ln\u00fcnk a diagram l\u00e9trehoz\u00e1sa el\u0151tt. T\u00f6bbnyire nem csak az \u00e9rt\u00e9keket, hanem az oszlopok, illetve sorok c\u00edmk\u00e9it is l\u00e1ttatni akarjuk a diagramon, \u00edgy ezeket is ki kell jel\u00f6ln\u00fcnk. Egyszer\u0171 esetben ez \u00e1ltal\u00e1ban a teljes t\u00e1bl\u00e1zat kijel\u00f6l\u00e9s\u00e9t jelenti.<br \/>Igen \u00e1m, de mi a helyzet akkor, mint a mostani feladatban is, ha ki kell hagynunk egy vagy t\u00f6bb sort \u00e9s\/vagy oszlopot \u2013 eset\u00fcnkben a B oszlopot \u00e9s a 2:7 sorokat?<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve az A1;C1:J1;A8;C8:J8 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcleteket, 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-36a5db6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36a5db6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-326ce0d\" data-id=\"326ce0d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d7b061 elementor-widget elementor-widget-text-editor\" data-id=\"6d7b061\" 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>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Vonal- \u00e9s ter\u00fcletdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, T1)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a <strong>Vonal <\/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-3a1c4c5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3a1c4c5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3e3df24\" data-id=\"3e3df24\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-58a11cc elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"58a11cc\" 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-41a4a02 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"41a4a02\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8a322e6\" data-id=\"8a322e6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5bc6891 elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"5bc6891\" 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-e342bb8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e342bb8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-01db44e\" data-id=\"01db44e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2cbe47c elementor-widget elementor-widget-text-editor\" data-id=\"2cbe47c\" 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=\"34\">\n<li>A diagram eltakarja a t\u00e1bl\u00e1zatot, ami nagyon zavar\u00f3. Helyezz\u00fck \u00e1t p\u00e9ld\u00e1ul a D13 cell\u00e1ba: \u00fcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd l\u00e9ptess\u00fck az akt\u00edv cell\u00e1t a D13 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-7d65fba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d65fba\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-701e017\" data-id=\"701e017\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3a36f90 elementor-widget elementor-widget-global elementor-global-16948 elementor-widget-text-editor\" data-id=\"3a36f90\" 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-8ca8b58 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ca8b58\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d536b36\" data-id=\"d536b36\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7180a01 elementor-widget elementor-widget-text-editor\" data-id=\"7180a01\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"35\">\n<li>Mivel a diagramon \u00e1br\u00e1zoltuk az A8 cella tartalm\u00e1t is, amib\u0151l a diagram c\u00edme lett, teljes\u00edtett\u00fck a feladat azon el\u0151\u00edr\u00e1s\u00e1t, hogy a diagram c\u00edme a d\u00e1tum legyen.<\/li>\n<li>A f\u00fcgg\u0151leges vezet\u0151r\u00e1csok bekapcsol\u00e1s\u00e1hoz adjuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ R\u00e1csvonalak \/ Els\u0151dleges f\u00fcgg\u0151leges f\u0151 vezet\u0151r\u00e1cs <\/strong><em>(Alt+JC, D, R, E, Enter)<\/em> parancsot! Az <strong>Els\u0151dleges v\u00edzszintes f\u0151 vezet\u0151r\u00e1csot<\/strong> m\u00e1r tartalmazza a diagram.<\/li>\n<li>Az y tengelyen helyezz\u00fck el a pont sz\u00f3t: adjuk ki a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Tengelyc\u00edmek \/ Els\u0151dleges f\u00fcgg\u0151leges <\/strong><em>(Alt+JC, D, M, E)<\/em> parancsot! Az y tengely mellett megjelenik a Tengelyc\u00edm felirat.<\/li>\n<li>\u00dcss\u00fck le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be a pont sz\u00f3t, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az A13 cell\u00e1ban azt a d\u00e1tumot kell megjelen\u00edten\u00fcnk k\u00e9plet seg\u00edts\u00e9g\u00e9vel, amely napon a legnagyobb volt a t\u0151zsdeindex mozg\u00e1sa, vagyis az M oszlop legnagyobb \u00e9rt\u00e9k\u00e9hez tartoz\u00f3 A oszlopbeli d\u00e1tumot kell megadnunk. Bontsuk r\u00e9szekre a probl\u00e9m\u00e1t: el\u0151sz\u00f6r ki kell keresn\u00fcnk az M2:M11 tartom\u00e1ny legnagyobb \u00e9rt\u00e9k\u00e9t. Ehhez a MAX f\u00fcggv\u00e9nyt h\u00edvjuk seg\u00edts\u00e9g\u00fcl: MAX(M2:M11). Ezut\u00e1n arra vagyunk k\u00edv\u00e1ncsiak, hogy ez az \u00e9rt\u00e9k h\u00e1nyadik cell\u00e1ban van az M2:M11 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(M2:M11);M2:M11;0). A kapott sz\u00e1m alkalmas lesz arra, hogy az A2:A11 tartom\u00e1nyban az INDEX f\u00fcggv\u00e9ny seg\u00edts\u00e9g\u00e9vel megkapjuk az \u00e9rt\u00e9khez tartoz\u00f3 d\u00e1tumot. Az INDEX f\u00fcggv\u00e9ny els\u0151 argumentuma a 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(A2:A11; HOL.VAN(MAX(M2:M11);M2:M11;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-313f80d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"313f80d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d3e10fa\" data-id=\"d3e10fa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f09cc2d elementor-widget elementor-widget-global elementor-global-17334 elementor-widget-text-editor\" data-id=\"f09cc2d\" 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-c5ae0ce elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c5ae0ce\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-94b6539\" data-id=\"94b6539\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-914582c elementor-widget elementor-widget-text-editor\" data-id=\"914582c\" 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>Helyezz\u00fck az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel az akt\u00edv cell\u00e1t az A13 cell\u00e1ra, egyben megsz\u00fcntetve a diagram kijel\u00f6l\u00e9s\u00e9t!<\/li>\n<li>G\u00e9pelj\u00fck be az <strong>=INDEX(A2:A11; HOL.VAN(MAX(M2:M11);M2:M11;0))<\/strong> k\u00e9pletet az A13 cell\u00e1ba!<\/li>\n<li>Mivel a kapott eredm\u00e9ny egy sz\u00e1m, form\u00e1zzuk meg ugyan\u00fagy, ahogy az A oszlop d\u00e1tumaival tett\u00fck kor\u00e1bban \u2013 \u00fcss\u00fck le a <em>Ctrl+1<\/em> billenty\u0171kombin\u00e1ci\u00f3t a <strong>Cell\u00e1k form\u00e1z\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>L\u00e9pj\u00fcnk a <strong>Sz\u00e1m<\/strong> lapf\u00fclre, ha nem az lenne az akt\u00edv lapf\u00fcl!<\/li>\n<li>\u00dcss\u00fck le a <em>Tab<\/em> billenty\u0171t a <strong>Kateg\u00f3ria<\/strong> list\u00e1ra l\u00e9p\u00e9shez, majd v\u00e1lasszuk ki a <strong>D\u00e1tum<\/strong> kateg\u00f3ri\u00e1t!<\/li>\n<li>A <em>Tab<\/em> billenty\u0171vel l\u00e9pj\u00fcnk a <strong>T\u00edpus<\/strong> list\u00e1ra, majd v\u00e1lasszunk ki ugyanazt a d\u00e1tumform\u00e1tumot, amit az A oszlop form\u00e1z\u00e1s\u00e1ra haszn\u00e1ltunk! Ha megvan, l\u00e9pj\u00fcnk ki a p\u00e1rbesz\u00e9dablakb\u00f3l az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel! Az eredm\u00e9ny 2013 szeptember 5., vagyis az M5 cella \u00e9rt\u00e9ke a legnagyobb.<\/li>\n<li>A k\u00e9sz t\u00e1bl\u00e1zatot \u00e9s vonaldiagramot l\u00e1thatjuk az <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_1_TablazatDiagram.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"1. \u00e1br\u00e1n (opens in a new tab)\">1. \u00e1br\u00e1n<\/a>.<\/li>\n<li>Utols\u00f3 feladatunk az A1:G11 tartom\u00e1ny nyomtat\u00e1sa fekv\u0151 t\u00e1jol\u00e1s\u00fa oldalra. L\u00e1bl\u00e9cet is k\u00e9sz\u00edten\u00fcnk kell, amely az aktu\u00e1lis d\u00e1tumot \u00e9s az oldalsz\u00e1mot tartalmazza! Jel\u00f6lj\u00fck ki az A1:G11 tartom\u00e1nyt!<\/li>\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 a <strong>Fekv\u0151 T\u00e1jol\u00e1st <\/strong><em>(Alt+F)<\/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\u00f3val l\u00e9pj\u00fcnk \u00e1t az <strong>\u00c9l\u0151fej \u00e9s \u00e9l\u0151l\u00e1b<\/strong> f\u00fclre!<\/li>\n<li>Keress\u00fck meg \u00e9s v\u00e1lasszuk ki az <strong>Egy\u00e9ni \u00e9l\u0151l\u00e1b<\/strong> <em>(Alt+B)<\/em> gombot! A\u00a0k\u00e9perny\u0151n megjelenik az <strong>\u00c9l\u0151l\u00e1b<\/strong> p\u00e1rbesz\u00e9dablak.<\/li>\n<li>\u00c9rj\u00fck el a megl\u00e9v\u0151 tartalom t\u00f6rl\u00e9s\u00e9vel <em>(Del)<\/em>, hogy a <strong>Bal oldalon<\/strong> <em>(Alt+A)<\/em>, a <strong>K\u00f6z\u00e9pen<\/strong> <em>(Alt+K)<\/em> \u00e9s a <strong>Jobb oldalon<\/strong> <em>(Alt+J)<\/em> szerkeszt\u0151mez\u0151k tartalma \u00fcres legyen!<\/li>\n<li>L\u00e9pj\u00fcnk p\u00e9ld\u00e1ul a <strong>K\u00f6z\u00e9pen<\/strong> <em>(Alt+K)<\/em> szerkeszt\u0151mez\u0151re!<\/li>\n<li>G\u00e9pelj\u00fck be a &amp;[D\u00e1tum], majd egy vessz\u0151t k\u00f6vetve az &amp;[Oldal] k\u00f3dokat!<\/li>\n<li>Keress\u00fck meg az <strong>OK<\/strong> gombot \u00e9s v\u00e1lasszuk ki az <strong>\u00c9l\u0151l\u00e1b<\/strong> p\u00e1rbesz\u00e9dablakb\u00f3l val\u00f3 kil\u00e9p\u00e9shez!<\/li>\n<li>\u00dcss\u00fck le az <em>Enter<\/em> billenty\u0171t az <strong>Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> ablakb\u00f3l val\u00f3 kil\u00e9p\u00e9shez!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-821ab92 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"821ab92\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-91e0488\" data-id=\"91e0488\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9efa33d elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"9efa33d\" 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-4b159aa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b159aa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9688de0\" data-id=\"9688de0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1a02c32 elementor-widget elementor-widget-text-editor\" data-id=\"1a02c32\" 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=\"58\">\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-4df9ac6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4df9ac6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c361acf\" data-id=\"c361acf\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-45e61b7 elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"45e61b7\" 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-0832d56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0832d56\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6b85c38\" data-id=\"6b85c38\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c5b5da elementor-widget elementor-widget-text-editor\" data-id=\"0c5b5da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"61\">\n<li>Ha sz\u00e1m\u00edt\u00f3g\u00e9p\u00fcnk\u00f6n van PDF kezel\u0151 alkalmaz\u00e1s vagy b\u00f6ng\u00e9sz\u0151, akkor azt az Excel megpr\u00f3b\u00e1lja elind\u00edtani \u00e9s megjelen\u00edteni a f\u00e1jl tartalm\u00e1t (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_2_PDF.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"2. \u00e1bra (opens in a new tab)\">2. \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-5775dd5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5775dd5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7936d50\" data-id=\"7936d50\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-965a85b elementor-widget elementor-widget-text-editor\" data-id=\"965a85b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A feladat megold\u00e1sa sor\u00e1n 2 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet \u00e9s egy PDF dokumentumot (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/242-K-ECDLM04S6-Vizsgafeladat36_Megoldas1_3_Fajlok.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"3. \u00e1bra (opens in a new tab)\">3. \u00e1bra<\/a>).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0b0f84f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b0f84f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fcf1db0\" data-id=\"fcf1db0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7cbf50f elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"7cbf50f\" 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-00008ba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00008ba\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0aae556\" data-id=\"0aae556\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dfd5726 elementor-widget elementor-widget-text-editor\" data-id=\"dfd5726\" 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 14.<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-0d7750f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0d7750f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-608bd57\" data-id=\"608bd57\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3783698 elementor-widget elementor-widget-shortcode\" data-id=\"3783698\" 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--6147 \"        data-post-id=\"6147\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-6147\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-6147\">                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-9fbfc15 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9fbfc15\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-decc6be\" data-id=\"decc6be\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-129c2a3 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=\"129c2a3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0Friss\u00edtve: 2022 j\u00falius 31. 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 36. 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=6147\">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-6147","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/6147","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=6147"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/6147\/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=6147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}