{"id":5036,"date":"2020-06-13T08:01:35","date_gmt":"2020-06-13T06:01:35","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=5036"},"modified":"2022-08-07T16:54:17","modified_gmt":"2022-08-07T14:54:17","slug":"ecdl-tablazatkezeles-15-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=5036","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 15. vizsgafeladat (#217\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"5036\" class=\"elementor elementor-5036\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7cd7817 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7cd7817\" 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-bf1c5b7\" data-id=\"bf1c5b7\" 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-8a1ba38 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"8a1ba38\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0Friss\u00edtve: 2022 j\u00falius 25.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f4020bc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f4020bc\" 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-d33f9b0\" data-id=\"d33f9b0\" 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-1a6d125 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"1a6d125\" 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-229300e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"229300e\" 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-a3c2c06\" data-id=\"a3c2c06\" 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-08929d7 elementor-widget elementor-widget-text-editor\" data-id=\"08929d7\" 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 15. 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-2615ff1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2615ff1\" 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-667ba62\" data-id=\"667ba62\" 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-43fc9a1 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"43fc9a1\" 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__43fc9a1\" 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__43fc9a1\" 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__43fc9a1\" 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-4802c77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4802c77\" 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-e7d8d9d\" data-id=\"e7d8d9d\" 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-e564624 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"e564624\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>Felhaszn\u00e1lt forr\u00e1sok:<\/strong><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/hu\/ecdl\/modul\/tablazatkezeles\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A T\u00e1bl\u00e1zatkezel\u00e9s modul tartalma az NJSzT oldal\u00e1n.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 febru\u00e1r 1-t\u0151l \u00e9rv\u00e9nyes T\u00e1bl\u00e1zatkezel\u00e9s Syllabus 6 (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 m\u00e1rcius 1-t\u0151l \u00e9rv\u00e9nyes ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A feladatokhoz tartoz\u00f3 munkaf\u00fczetek t\u00f6m\u00f6r\u00edtv\u00e9nye (ZIP f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/06\/217-K-ECDLM04S6-Vizsgafeladat15.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 15. 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-52a8aa5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"52a8aa5\" 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-f9c6e51\" data-id=\"f9c6e51\" 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-5a0b462 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"5a0b462\" 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-fafa19b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fafa19b\" 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-935db7f\" data-id=\"935db7f\" 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-1b36754 elementor-widget elementor-widget-text-editor\" data-id=\"1b36754\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az ECDL Excel vizsgafeladat megold\u00e1sa el\u0151tt a megjel\u00f6lt forr\u00e1sok k\u00f6z\u00fcl t\u00f6lts\u00fck le sz\u00fcks\u00e9g szerint az <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s 6.0<\/a> dokumentumot \u00e9s a <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">munkaf\u00e1jlokat<\/a> \u2013 az el\u0151bbit nyissuk meg, az ut\u00f3bbit pedig csomagoljuk ki c\u00e9lszer\u0171en a Dokumentumok mapp\u00e1ba. A vizsgap\u00e9ldat\u00e1r PDF dokumentum, amit a legt\u00f6bb internet b\u00f6ng\u00e9sz\u0151 k\u00e9pes megnyitni, de haszn\u00e1lhatjuk b\u00e1rmelyik PDF olvas\u00f3 alkalmaz\u00e1st is, p\u00e9ld\u00e1ul az Adobe Acrobat Readert. L\u00e1t\u00e1ss\u00e9r\u00fclt sorst\u00e1rsaink <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/06\/217-K-ECDLM04S6-Vizsgafeladat15.txt\" target=\"_blank\" rel=\"noreferrer noopener\">Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban<\/a> is let\u00f6lthetik a feladatsort.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>Tekints\u00fck \u00e1t a feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismereteket \u00e9s a felhaszn\u00e1lt f\u00fcggv\u00e9nyeket:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8542a2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8542a2\" 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-582e791\" data-id=\"582e791\" 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-9954377 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"9954377\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismeretek: <\/strong>abszol\u00fat hivatkoz\u00e1s, adatr\u00f6gz\u00edt\u00e9s, akt\u00edv cella \u00e1thelyez\u00e9se, bev\u00e9tel-kiad\u00e1s-ad\u00f3-profit fogalmak, diagram k\u00e9sz\u00edt\u00e9s \u00e9s form\u00e1z\u00e1s, export\u00e1l\u00e1s PDF form\u00e1tumban, k\u00e9plet sokszoros\u00edt\u00e1sa, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, munkalap kezel\u00e9se, nyomtat\u00e1s, oldalbe\u00e1ll\u00edt\u00e1s, sz\u00e1zal\u00e9ksz\u00e1m\u00edt\u00e1s, t\u00e1bl\u00e1zat form\u00e1z\u00e1s, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, DARABTELI, 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-85199df elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"85199df\" 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-91049f6\" data-id=\"91049f6\" 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-b2b0d3f elementor-widget elementor-widget-text-editor\" data-id=\"b2b0d3f\" 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-cca9696 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cca9696\" 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-66cd84e\" data-id=\"66cd84e\" 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-fcd5599 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"fcd5599\" 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\/217-K-ECDLM04S6-Vizsgafeladat15_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\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-25956\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 15. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zatok \u00e9s a csoportos\u00edtott oszlopdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_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\u00e1zatok \u00e9s a csoportos\u00edtott oszlopdiagram.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-352ad4a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"352ad4a\" 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-d087eed\" data-id=\"d087eed\" 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-17e553a elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"17e553a\" 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\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT.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\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-1024x576.jpg\" class=\"attachment-large size-large wp-image-25957\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 15. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: Az export\u00e1lt t\u00e1bl\u00e1zat a Jegyzett\u00f6mb ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: Az export\u00e1lt t\u00e1bl\u00e1zat a Jegyzett\u00f6mb ablak\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-524e2d2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"524e2d2\" 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-9c0f17a\" data-id=\"9c0f17a\" 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-1b994f8 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"1b994f8\" 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\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-1024x576.jpg\" class=\"attachment-large size-large wp-image-25958\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 15. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A bev\u00e9tel-kiad\u00e1s-profit t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">3. \u00e1bra: A bev\u00e9tel-kiad\u00e1s-profit t\u00e1bl\u00e1zat.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8d1d270 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d1d270\" 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-8ab88fe\" data-id=\"8ab88fe\" 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-a3d2c84 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"a3d2c84\" 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\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-25959\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 15. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">4. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d94cc2e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d94cc2e\" 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-a7dc01b\" data-id=\"a7dc01b\" 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-a441126 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"a441126\" 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\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-25960\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 15. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f14b31f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f14b31f\" 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-81d59b6\" data-id=\"81d59b6\" 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-8fe7e15 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"8fe7e15\" 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-d2e8f04 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2e8f04\" 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-31b3081\" data-id=\"31b3081\" 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-bc9b0bc elementor-widget elementor-widget-text-editor\" data-id=\"bc9b0bc\" 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 (60 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-387ccd5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"387ccd5\" 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-1cfa7d7\" data-id=\"1cfa7d7\" 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-ac16c9a elementor-widget elementor-widget-text-editor\" data-id=\"ac16c9a\" 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-15.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-66989a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"66989a8\" 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-55f6b11\" data-id=\"55f6b11\" 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-b5bfba4 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"b5bfba4\" 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-bfd4e33 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bfd4e33\" 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-ea17a01\" data-id=\"ea17a01\" 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-ec74841 elementor-widget elementor-widget-text-editor\" data-id=\"ec74841\" 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 az M4-15 munkaf\u00fczettel, amely az A1:F31 tartom\u00e1nyban a 2000-ben nyilv\u00e1ntartott els\u0151 harminc Messier-katal\u00f3gusban r\u00f6gz\u00edtett m\u00e9ly\u00e9g-objektum NGC sz\u00e1m\u00e1t, \u00e9gi koordin\u00e1t\u00e1it \u00e9s t\u00edpusmegjel\u00f6l\u00e9s\u00e9t tartalmazza. Az A oszlopban a katal\u00f3gus els\u0151 30 objektum\u00e1nak azonos\u00edt\u00f3it tal\u00e1ljuk M1-t\u0151l M30-ig, a B oszlop ezen objektumok \u00fagynevezett NGC sz\u00e1mait, a C:E oszlopok az \u00e9gi koordin\u00e1t\u00e1kat, m\u00edg az F oszlop az objektumok t\u00edpus\u00e1t tartalmazza.<\/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-3302bc8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3302bc8\" 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-5d8e5aa\" data-id=\"5d8e5aa\" 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-5fee415 elementor-widget elementor-widget-text-editor\" data-id=\"5fee415\" 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 \u00e9rdekelnek minket a t\u00e1bl\u00e1zat adatai, akkor olvassuk el ezt a tippet \u2013 figyelem, kiss\u00e9 tudom\u00e1nyos \u00e9s hossz\u00fa, a feladat v\u00e9grehajt\u00e1s\u00e1hoz nem sz\u00fcks\u00e9ges csillag\u00e1szati alapismereteket tartalmaz!<br \/>A <strong>Messier-katal\u00f3gus<\/strong> Charles Messier (1730-1817) francia csillag\u00e1sz \u00e1ltal 1758 \u00e9s 1782 k\u00f6z\u00f6tt \u00f6ssze\u00e1ll\u00edtott, \u00e9s t\u00f6bb alkalommal, folyamatosan kieg\u00e9sz\u00edtett katal\u00f3gus, amely a legf\u00e9nyesebb 110 m\u00e9ly\u00e9g-objektumot tartalmazza, M1-t\u0151l M110-ig. A XVIII. sz\u00e1zadi megfigyel\u00e9si korl\u00e1toknak, illetve Messier Franciaorsz\u00e1gban v\u00e9gzett megfigyel\u00e9seinek k\u00f6sz\u00f6nhet\u0151en a katal\u00f3gus csak az \u00e9szaki \u00e9gbolt elhanyagolhat\u00f3an kev\u00e9s sz\u00e1m\u00fa m\u00e9ly\u00e9g-objektum\u00e1nak list\u00e1j\u00e1t tartalmazza. Ma a 110 m\u00e9ly\u00e9g-objektum k\u00f6z\u00fcl kiv\u00e9teles esetben szabad szemmel mind\u00f6ssze 38 figyelhet\u0151 meg.<br \/>A B oszlopban felt\u00fcntetett <strong>NGC<\/strong> (New General Catalogue \u2013 \u00daj \u00c1ltal\u00e1nos Katal\u00f3gus) sz\u00e1m az amat\u0151rcsillag\u00e1szok k\u00f6r\u00e9ben legelterjedtebb, m\u00e9ly\u00e9g-objektumokat tartalmaz\u00f3 katal\u00f3gus. N\u00e9gy kiv\u00e9tellel minden Messier objektum megtal\u00e1lhat\u00f3 az NGC-katal\u00f3gusban. Az NGC-katal\u00f3gust az 1880-as \u00e9vekben \u00e1ll\u00edtotta \u00f6ssze J. L. E. Dreyer, nagyr\u00e9szt William Herschel kor\u00e1bbi megfigyel\u00e9sei alapj\u00e1n.<br \/>A C oszlopban felt\u00fcntetett RA, vagyis <strong>rektaszcenzi\u00f3<\/strong> (egyenes emelked\u00e9s) a csillag\u00e1szati c\u00e9lokra haszn\u00e1lt \u00fagynevezett II. ekvatori\u00e1lis koordin\u00e1ta-rendszer egyik, hossz\u00fas\u00e1gi koordin\u00e1t\u00e1ja \u2013 a f\u00f6ldrajzi hossz\u00fas\u00e1g \u00e9gi megfelel\u0151je. A rektaszcenzi\u00f3 egy id\u0151pont, a tavaszpontb\u00f3l kiindulva m\u00e9rik \u00f3ra:perc:m\u00e1sodpercben, az \u00e9szaki \u00e9gi p\u00f3lusr\u00f3l n\u00e9zve az \u00f3ramutat\u00f3 j\u00e1r\u00e1s\u00e1val ellent\u00e9tes, teh\u00e1t a Nap \u00e9vi mozg\u00e1s\u00e1val megegyez\u0151 ir\u00e1nyban. Tulajdonk\u00e9ppen a nap 24 \u00f3r\u00e1j\u00e1t osztj\u00e1k fel a n\u00e9gy nevezetes nap\u00e1ll\u00e1s k\u00f6z\u00f6tt \u2013 \u00edgy a 0. \u00f3ra a tavaszi nap-\u00e9j egyenl\u0151s\u00e9g (m\u00e1rcius 20., amikor a Nap a Halak csillagk\u00e9pben j\u00e1r), a 6. \u00f3ra a ny\u00e1ri napfordul\u00f3 (j\u00fanius 21., amikor a Nap az Ikrek csillagk\u00e9pben j\u00e1r), a 12. \u00f3ra az \u0151szi nap-\u00e9j egyenl\u0151s\u00e9g (szeptember 23., amikor a Nap a Sz\u0171z csillagk\u00e9pben j\u00e1r), \u00e9s a 18. \u00f3ra a t\u00e9li napfordul\u00f3 (december 21., amikor a Nap a Nyilas csillagk\u00e9pben j\u00e1r).<br \/>A D:E oszlopokban a D bet\u0171vel jelzett <strong>deklin\u00e1ci\u00f3t<\/strong> (elhajl\u00e1st) tal\u00e1ljuk, amely a csillag\u00e1szati c\u00e9lokra haszn\u00e1lt \u00fagynevezett II. ekvatori\u00e1lis koordin\u00e1ta-rendszer m\u00e1sik, fok, perc, m\u00e1sodpercben megadott sz\u00e9less\u00e9gi koordin\u00e1t\u00e1ja. Egy adott \u00e9gi objektum deklin\u00e1ci\u00f3ja nem m\u00e1s, mint az objektum \u00e9gi ir\u00e1nya \u00e9s az \u00e9gi egyenl\u00edt\u0151 \u00e1ltal bez\u00e1rt sz\u00f6g. Az \u00e9gi egyenl\u00edt\u0151t\u0151l \u00e9szakra elhelyezked\u0151 objektumok deklin\u00e1ci\u00f3ja 0\u00b0-t\u00f3l 90\u00b0-ig, az att\u00f3l d\u00e9lre elhelyezked\u0151k deklin\u00e1ci\u00f3ja pedig -0\u00b0-t\u00f3l -90\u00b0-ig terjedhet. A t\u00e1bl\u00e1zat D oszlop\u00e1ban a fokokat, E oszlop\u00e1ban pedig a perceket tal\u00e1ljuk. (Az <strong>\u00e9gi egyenl\u00edt\u0151<\/strong> a F\u00f6ld egyenl\u00edt\u0151s\u00edkj\u00e1nak az \u00e9gg\u00f6mbbel alkotott metsz\u00e9svonala. Mer\u0151leges a F\u00f6ld forg\u00e1stengely\u00e9re, \u00e9s ~23,5\u00b0-kal hajlik el az ekliptik\u00e1t\u00f3l, vagyis a Nap p\u00e1ly\u00e1j\u00e1t\u00f3l.)<br \/>V\u00e9g\u00fcl az F oszlop a Messier objektumok t\u00edpus\u00e1t tartalmazza. Az egyes t\u00edpusok r\u00f6viden a k\u00f6vetkez\u0151ket jelentik: a <strong>g\u00f6mbhalmaz<\/strong> csillagok g\u00f6mb alak\u00fa t\u00e9rr\u00e9szben tal\u00e1lhat\u00f3, szoros gravit\u00e1ci\u00f3s kapcsolatban \u00e1ll\u00f3 csoportja; a <strong>ny\u00edlthalmaz<\/strong> egy csillagk\u00f6zi g\u00e1zfelh\u0151b\u0151l kialakult csillagcsoportosul\u00e1s, amelyek tagjai laza gravit\u00e1ci\u00f3s kapcsolatban \u00e1llnak egym\u00e1ssal; a <strong>diff\u00faz k\u00f6d<\/strong> saj\u00e1t vagy visszavert f\u00e9nnyel rendelkez\u0151 csillagk\u00f6zi porb\u00f3l, g\u00e1zb\u00f3l \u00e9s plazm\u00e1b\u00f3l \u00e1ll\u00f3 csillagk\u00f6zi felh\u0151; \u00e9s a <strong>planet\u00e1ris k\u00f6d<\/strong> egy haldokl\u00f3 csillag k\u00f6r\u00fcl kialakult g\u00e1zburok, amely az ioniz\u00e1lt anyaga miatt l\u00e1that\u00f3 f\u00e9nyt is kibocs\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-623f29a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"623f29a\" 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-d77d4a3\" data-id=\"d77d4a3\" 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-a21d7fb elementor-widget elementor-widget-text-editor\" data-id=\"a21d7fb\" 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=\"5\">\n<li>Els\u0151 feladatunk a t\u00e1bl\u00e1zat fejl\u00e9c n\u00e9lk\u00fcli export\u00e1l\u00e1sa egy TXT sz\u00f6vegf\u00e1jlba. Ha nincs el\u0151\u00edrva, m\u00e1rpedig a feladatle\u00edr\u00e1s szerint nincs, hogy ehhez kiz\u00e1r\u00f3lag az Excelt haszn\u00e1lhatjuk, akkor elind\u00edthatjuk a Jegyzett\u00f6mb alkalmaz\u00e1st, \u00e9s a V\u00e1g\u00f3lap seg\u00edts\u00e9g\u00e9vel beilleszthetj\u00fck az A2:F31 tartom\u00e1nyt. Ha a vizsg\u00e1n csak az Excellel dolgozhatunk, akkor egy \u00faj munkalapra m\u00e1solatot k\u00e9sz\u00edt\u00fcnk az A2:F31 tartom\u00e1nyr\u00f3l, majd az <em>F12<\/em> seg\u00edts\u00e9g\u00e9vel mentj\u00fck <strong>Sz\u00f6veg (MS-DOS)<\/strong> form\u00e1tumban. A k\u00f6vetkez\u0151 l\u00e9p\u00e9sekben az els\u0151 m\u00f3dszer szerint j\u00e1runk el.<\/li>\n<li>Jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel az A2:F31 tartom\u00e1nyt!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ac01e1a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ac01e1a\" 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-2bed490\" data-id=\"2bed490\" 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-90f52e8 elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"90f52e8\" 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-157fc80 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"157fc80\" 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-26b208d\" data-id=\"26b208d\" 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-9dbde70 elementor-widget elementor-widget-text-editor\" data-id=\"9dbde70\" 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>K\u00e9sz\u00edts\u00fcnk r\u00f3la m\u00e1solatot a V\u00e1g\u00f3lapra a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>Ind\u00edtsuk el a Jegyzett\u00f6mb alkalmaz\u00e1st: \u00fcss\u00fck le a <em>Start<\/em> billenty\u0171t, a keres\u0151mez\u0151be g\u00e9pelj\u00fck be a jegyzett\u00f6mb sz\u00f3t, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A k\u00e9perny\u0151n megjelen\u0151 Jegyzett\u00f6mb ablakba illessz\u00fck be a V\u00e1g\u00f3lap tartalm\u00e1t a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+S<\/em> billenty\u0171kombin\u00e1ci\u00f3t a ment\u00e9shez!<\/li>\n<li>A k\u00e9perny\u0151n megjelen\u0151 <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak <strong>F\u00e1jln\u00e9v<\/strong> <em>(Alt+L)<\/em> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben adjuk meg a nev\u00fcnket, esetleg v\u00e1lasszunk m\u00e1sik mapp\u00e1t, v\u00e9g\u00fcl a <strong>Ment\u00e9s<\/strong> <em>(Alt+E)<\/em> gombot! Az export\u00e1lt t\u00e1bl\u00e1zatot mutatja a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_2_TXT.jpg\" target=\"_blank\" rel=\"noopener\">2. \u00e1bra<\/a>.<\/li>\n<li>Z\u00e1rjuk be a Jegyzett\u00f6mb alkalmaz\u00e1st az <em>Alt+F4<\/em> billenty\u0171kombin\u00e1ci\u00f3val, majd t\u00e9rj\u00fcnk vissza a munkaf\u00fczethez!<\/li>\n<li>A m\u00e1sodik feladat szerint a G1 cell\u00e1ban k\u00e9plettel ki kell sz\u00e1molnunk a ny\u00edlthalmazok sz\u00e1m\u00e1t. Egy adott felt\u00e9telnek megfelel\u0151 cell\u00e1kat a DARABTELI f\u00fcggv\u00e9nnyel tudjuk megsz\u00e1molni. Az objektumok t\u00edpus\u00e1t az F2:F31 tartom\u00e1ny tartalmazza, a felt\u00e9tel pedig a ny\u00edlthalmaz sz\u00f3 lesz. G\u00e9pelj\u00fck be a G1 cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=DARABTELI(F2:F31;&#8221;ny\u00edlthalmaz&#8221;)<\/strong>. Az eredm\u00e9ny 10.<\/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-64faa19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64faa19\" 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-4c07044\" data-id=\"4c07044\" 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-cf01d5a elementor-widget elementor-widget-text-editor\" data-id=\"cf01d5a\" 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 felt\u00e9telt rel\u00e1ci\u00f3s oper\u00e1torral is fel\u00edrhatjuk a k\u00f6vetkez\u0151 form\u00e1ban: &#8222;=ny\u00edlthalmaz&#8221;, s\u0151t, ha kin\u00e9z\u00fcnk magunknak egy ny\u00edlthalmazt tartalmaz\u00f3 cell\u00e1t, p\u00e9ld\u00e1ul az F7-et, akkor alkalmazhatjuk az F7 felt\u00e9telt is. A k\u00e9pletek a k\u00e9t esetben \u00edgy n\u00e9znek ki: <strong>=DARABTELI(F2:F31;&#8221;=ny\u00edlthalmaz&#8221;)<\/strong> vagy <strong>=DARABTELI(F2:F31;F7)<\/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-e37216b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e37216b\" 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-c60482d\" data-id=\"c60482d\" 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-ef917fa elementor-widget elementor-widget-text-editor\" data-id=\"ef917fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"14\">\n<li>A k\u00f6vetkez\u0151 feladat szerint a koordin\u00e1t\u00e1kat tartalmaz\u00f3 cell\u00e1k, vagyis a C2:E31 tartom\u00e1ny kit\u00f6lt\u0151sz\u00edn\u00e9t <strong>S\u00e1rga <\/strong>sz\u00ednre kell m\u00f3dos\u00edtanunk, \u00e9s nem meghat\u00e1rozott tulajdons\u00e1g\u00fa szeg\u00e9lyt kell a tartom\u00e1ny cell\u00e1i k\u00f6r\u00e9 vonnunk. Jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel a C2:E31 tartom\u00e1nyt!<\/li>\n<li>\u00c1ll\u00edtsuk be a <strong>S\u00e1rga <\/strong>kit\u00f6lt\u0151sz\u00ednt a <strong>Kezd\u0151lap \/ Kit\u00f6lt\u0151sz\u00edn <\/strong><em>(Alt+\u0150, H1)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel! A paletta <strong>Alapsz\u00ednek<\/strong> r\u00e9sz\u00e9ben a negyedik a <strong>S\u00e1rga <\/strong>sz\u00edn, amit a <em>ny\u00edlbillenty\u0171kkel<\/em> l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li>\n<li>Az \u00f6sszes cella bekeretez\u00e9s\u00e9hez adjuk ki a <strong>Kezd\u0151lap \/ Szeg\u00e9lyek \/ Minden szeg\u00e9ly <\/strong><em>(Alt+\u0150, GS, M)<\/em> parancsot!<\/li>\n<li>Az M sz\u00e1mok form\u00e1z\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki az A2:A31 tartom\u00e1nyt!<\/li>\n<li>A f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz \u00fcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e191f09 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e191f09\" 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-8f698bd\" data-id=\"8f698bd\" 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-3ef4c8d elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"3ef4c8d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> A k\u00f6vetkez\u0151 billenty\u0171kombin\u00e1ci\u00f3kat haszn\u00e1lhatjuk az elemi st\u00edlusok be\u00e1ll\u00edt\u00e1s\u00e1ra vagy kikapcsol\u00e1s\u00e1ra: f\u00e9lk\u00f6v\u00e9r <i>Ctrl+B<\/i> vagy <i>Ctrl+2<\/i>, d\u0151lt <i>Ctrl+I<\/i> vagy <i>Ctrl+3<\/i>, al\u00e1h\u00fazott <i>Ctrl+U<\/i> vagy <i>Ctrl+4<\/i>, \u00e1th\u00faz\u00e1s <i>Ctrl+5<\/i>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4169dd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4169dd9\" 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-0d6c733\" data-id=\"0d6c733\" 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-8cd418d elementor-widget elementor-widget-text-editor\" data-id=\"8cd418d\" 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=\"19\">\n<li>A <strong>Z\u00f6ld<\/strong> bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz adjuk ki a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancsot! 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 k\u00f6vetkez\u0151 feladat egy seg\u00e9dt\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se a B35:C39 tartom\u00e1nyban, majd annak felhaszn\u00e1l\u00e1s\u00e1val egy csoportos\u00edtott oszlopdiagram elhelyez\u00e9se a munkalapon. L\u00e1ssunk munk\u00e1hoz!<\/li>\n<li>A B35:B39 cell\u00e1kba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9ket: g\u00f6mbhalmaz, diff\u00faz k\u00f6d, planet\u00e1ris k\u00f6d, egy\u00e9b, ny\u00edlthalmaz<\/li>\n<li>A C35:C39 cell\u00e1kba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 \u00e9rt\u00e9keket: 14, 3, 1, 2, 10<\/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-28e8914 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28e8914\" 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-164ea23\" data-id=\"164ea23\" 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-9e60628 elementor-widget elementor-widget-text-editor\" data-id=\"9e60628\" 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> B\u00e1r a feladat nem k\u00e9ri, de mind a n\u00e9gy \u00e9rt\u00e9ket kisz\u00e1m\u00edthatjuk a DARABTELI f\u00fcggv\u00e9ny alkalmaz\u00e1s\u00e1val. Jel\u00f6lj\u00fck ki a C35:C39 tartom\u00e1nyt, majd g\u00e9pelj\u00fck be a C35 cell\u00e1ba a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=DARABTELI($F$2:$F$31;B35)<\/strong><strong>, v\u00e9g\u00fcl \u00fcss\u00fck le a <i>Ctrl+Enter<\/i> billenty\u0171kombin\u00e1ci\u00f3t! A $F$2:$F$31 tartom\u00e1ny az\u00e9rt lett abszol\u00fat hivatkoz\u00e1s, hogy a k\u00e9plet m\u00e1sik h\u00e1rom cell\u00e1ba m\u00e1sol\u00e1sakor a tartom\u00e1nyhivatkoz\u00e1s ne m\u00f3dosuljon.<\/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-ca47385 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ca47385\" 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-1dc625c\" data-id=\"1dc625c\" 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-04c64ca elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"04c64ca\" 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-0587563 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0587563\" 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-3a40c0d\" data-id=\"3a40c0d\" 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-f9f74b2 elementor-widget elementor-widget-text-editor\" data-id=\"f9f74b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"23\">\n<li>Csoportos\u00edtott oszlopdiagramot kell k\u00e9sz\u00edten\u00fcnk a munkalapra a g\u00f6mbhalmazok \u00e9s a ny\u00edlthalmazok adatait \u00e1br\u00e1zolva. Mivel az adatokat tartalmaz\u00f3 cell\u00e1k nem szomsz\u00e9dosak, egyben nem, csak k\u00e9t k\u00fcl\u00f6n tartom\u00e1nyk\u00e9nt tudjuk kijel\u00f6lni a sz\u00fcks\u00e9ges cell\u00e1kat: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel a B35:C35;B39:C39 tartom\u00e1nyokat!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-585b0f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"585b0f7\" 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-9dc9052\" data-id=\"9dc9052\" 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-bc1a904 elementor-widget elementor-widget-text-editor\" data-id=\"bc1a904\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Amikor a diagramon megjelen\u00edtend\u0151 \u00e9rt\u00e9kek k\u00f6r\u00e9t meghat\u00e1rozzuk, \u00e1t kell gondolnunk, mely tartom\u00e1nyt kell kijel\u00f6ln\u00fcnk a diagram l\u00e9trehoz\u00e1sa el\u0151tt. T\u00f6bbnyire nem csak az \u00e9rt\u00e9keket, hanem az oszlopok, illetve sorok c\u00edmk\u00e9it is l\u00e1ttatni akarjuk a diagramon, \u00edgy ezeket is ki kell jel\u00f6ln\u00fcnk. Egyszer\u0171 esetben ez \u00e1ltal\u00e1ban a teljes t\u00e1bl\u00e1zat kijel\u00f6l\u00e9s\u00e9t jelenti.<br \/>Igen \u00e1m, de mi a helyzet akkor, mint a mostani feladatban is, ha ki kell hagynunk egy vagy t\u00f6bb sort \u00e9s\/vagy oszlopot \u2013 ebben a feladatban a k\u00e9t k\u00f6z\u00e9ps\u0151 sort.<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve a B35:C35;B39:C39 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-411da05 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"411da05\" 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-da462c3\" data-id=\"da462c3\" 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-d4d7792 elementor-widget elementor-widget-text-editor\" data-id=\"d4d7792\" 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=\"24\">\n<li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Oszlop- \u00e9s s\u00e1vdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, \u00da)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a <strong>Csoportos\u00edtott oszlop<\/strong> kiv\u00e1laszt\u00e1s\u00e1hoz! A munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9n megjelenik a kijel\u00f6lt diagram.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0c714d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0c714d0\" 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-5cb527b\" data-id=\"5cb527b\" 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-d513a09 elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"d513a09\" 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-0547f48 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0547f48\" 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-e0124f8\" data-id=\"e0124f8\" 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-9b0e6ad elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"9b0e6ad\" 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-78a4d5b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"78a4d5b\" 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-3e00efa\" data-id=\"3e00efa\" 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-799f363 elementor-widget elementor-widget-text-editor\" data-id=\"799f363\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"25\">\n<li>A diagram eltakarhatja a t\u00e1bl\u00e1zatot, ami nagyon zavar\u00f3 lehet. Helyezz\u00fck \u00e1t p\u00e9ld\u00e1ul az F35 cell\u00e1ba: \u00fcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd l\u00e9ptess\u00fck az akt\u00edv cell\u00e1t az F35 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-fbbd301 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fbbd301\" 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-7c82f0d\" data-id=\"7c82f0d\" 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-aabb085 elementor-widget elementor-widget-global elementor-global-16948 elementor-widget-text-editor\" data-id=\"aabb085\" 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-8d7f5e2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d7f5e2\" 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-926cbbb\" data-id=\"926cbbb\" 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-cb7ddec elementor-widget elementor-widget-text-editor\" data-id=\"cb7ddec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"26\">\n<li>V\u00e1lasszuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ A diagram felett <\/strong><em>(Alt+JC, D, C, A)<\/em> parancsot! Ezzel a c\u00edmet a diagram f\u00f6l\u00e9, k\u00f6z\u00e9pre helyezz\u00fck, egyben kijel\u00f6ltt\u00e9 tessz\u00fck azt a szerkeszt\u00e9shez.<\/li>\n<li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be Halmazok sz\u00e1ma c\u00edmet, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az \u00e1ltalunk k\u00e9sz\u00edtett diagram nem tartalmaz jelmagyar\u00e1zatot, de ha m\u00e9gis, akkor a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Jelmagyar\u00e1zat \/ Nincs <\/strong><em>(Alt+JC, D, J, N)<\/em> paranccsal kapcsolhatjuk ki. L\u00e1t\u00e1ss\u00e9r\u00fcltk\u00e9nt \u00fagy tudunk meggy\u0151z\u0151dni a jelmagyar\u00e1zat l\u00e9t\u00e9r\u0151l vagy hi\u00e1ny\u00e1r\u00f3l, hogy a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> paranccsal megn\u00e9zz\u00fck a <strong>Diagramelemek<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151 list\u00e1j\u00e1nak tartalm\u00e1t. Ha nincs benne a <strong>Jelmagyar\u00e1zat<\/strong>, akkor diagramunk nem tartalmazza ezt az elemet.<\/li>\n<li>Az oszlopokhoz tartoz\u00f3 feliratok megjelen\u00edt\u00e9s\u00e9hez adjuk ki a <strong>Diagramtervez\u00e9s <\/strong><strong>\/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Adatfeliratok \/ \u00c9rt\u00e9kn\u00e9l, k\u00edv\u00fcl <\/strong><em>(Alt+JC, D, A, K)<\/em> parancsot! A k\u00e9sz t\u00e1bl\u00e1zatot \u00e9s csoportos\u00edtott oszlopdiagramot mutatja az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_1_TablazatDiagram.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>.<\/li>\n<li>\u00dajabb t\u00e1bl\u00e1zatot kell k\u00e9sz\u00edten\u00fcnk, azt azonban egy \u00faj munkalapon kell elhelyezn\u00fcnk: \u00fcss\u00fck le a <em>Shift+F11<\/em> billenty\u0171kombin\u00e1ci\u00f3t egy \u00faj munkalap l\u00e9trehoz\u00e1s\u00e1hoz! Haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Besz\u00far\u00e1s \/ Munkalap besz\u00far\u00e1sa <\/strong><em>(Alt+\u0150, BB, B)<\/em> parancsot is. Az \u00faj munkalap Munka1 n\u00e9ven az M4-15 munkalap el\u0151tt j\u00f6n l\u00e9tre.<\/li>\n<li>G\u00e9pelj\u00fck be az A11:A14 tartom\u00e1ny cell\u00e1iba a k\u00f6vetkez\u0151ket: bev\u00e9tel, kiad\u00e1s, profit ad\u00f3 el\u0151tt, profit ad\u00f3 ut\u00e1n<\/li>\n<li>G\u00e9pelj\u00fck be a B10:F10 tartom\u00e1ny cell\u00e1iba a k\u00f6vetkez\u0151ket: jan, febr, m\u00e1rc, \u00f6sszesen, \u00e1tlag<\/li>\n<li>G\u00e9pelj\u00fck be a B11:D11 tartom\u00e1ny cell\u00e1iba a k\u00f6vetkez\u0151ket: 100, 120, 115<\/li>\n<li>G\u00e9pelj\u00fck be a B12:D12 tartom\u00e1ny cell\u00e1iba a k\u00f6vetkez\u0151ket: 50, 50, 90<\/li>\n<li>G\u00e9pelj\u00fck be az A16 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Ad\u00f3<\/li>\n<li>G\u00e9pelj\u00fck be a B16 cell\u00e1ba a k\u00f6vetkez\u0151 \u00e9rt\u00e9ket: 64%<\/li>\n<li>A 13. sorban a profit ad\u00f3 el\u0151tti \u00e9rt\u00e9k\u00e9t, vagyis a bev\u00e9tel \u00e9s a kiad\u00e1s k\u00fcl\u00f6nbs\u00e9g\u00e9t kell kisz\u00e1molnunk. Jel\u00f6lj\u00fck ki a B13:D13 tartom\u00e1nyt!<\/li>\n<li>A B13 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=B11-B12<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A 14. sorban a profit ad\u00f3 ut\u00e1ni \u00e9rt\u00e9k\u00e9t kell kisz\u00e1molnunk, amely a bev\u00e9tel \u00e9s a kiad\u00e1s k\u00fcl\u00f6nbs\u00e9g\u00e9nek a B16-os cell\u00e1ban l\u00e9v\u0151 ad\u00f3kulccsal cs\u00f6kkentett r\u00e9sze. A k\u00fcl\u00f6nbs\u00e9get m\u00e1r kisz\u00e1moltuk a 13. sorban, az ad\u00f3 m\u00e9rt\u00e9k\u00e9t pedig megtal\u00e1ljuk a B16 cell\u00e1ban, amely 64%. A bonyolult megfogalmaz\u00e1s m\u00f6g\u00f6tt egyszer\u0171 sz\u00e1zal\u00e9ksz\u00e1m\u00edt\u00e1s \u00e1ll: a profit ad\u00f3 el\u0151tti \u00e9rt\u00e9k\u00e9b\u0151l ki kell vonnunk a profit 64%-\u00e1t \u2013 a k\u00fcl\u00f6nbs\u00e9g lesz az ad\u00f3z\u00e1s ut\u00e1ni profit. A B14 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=B13-B13*$B$16<\/strong>. Az abszol\u00fat c\u00edmz\u00e9sre az\u00e9rt van sz\u00fcks\u00e9g, mert a k\u00e9pletet \u00e1t fogjuk m\u00e1solni a mellette l\u00e9v\u0151 k\u00e9t cell\u00e1ba, vagyis a B16 cell\u00e1ra t\u00f6rt\u00e9n\u0151 hivatkoz\u00e1s m\u00f3dosul\u00e1s\u00e1t meg akarjuk akad\u00e1lyozni.<\/li>\n<li>Mivel a feladat a k\u00e9pletek m\u00e1sol\u00e1s\u00e1t \u00edrja el\u0151 a C14:D14 cell\u00e1kba, \u00edgy el\u0151sz\u00f6r k\u00e9sz\u00edts\u00fcnk m\u00e1solatot a B14 cell\u00e1r\u00f3l a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>Jel\u00f6lj\u00fck ki a C14:D14 tartom\u00e1nyt, majd illessz\u00fck be a V\u00e1g\u00f3lap tartalm\u00e1t a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>Az E11:E14 tartom\u00e1nyban a sorok \u00f6sszeg\u00e9t kell k\u00e9pezn\u00fcnk. Jel\u00f6lj\u00fck ki a tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ AutoSzum \/ Szum <\/strong><em>(Alt+\u0150, D, Enter)<\/em> parancsot!<\/li>\n<li>Az F11:F14 tartom\u00e1nyban az \u00e1tlagokat kell kisz\u00e1molnunk. Jel\u00f6lj\u00fck ki a tartom\u00e1nyt, majd az F11 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=\u00c1TLAG(B11:D11)<\/strong> k\u00e9pletet, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A p\u00e9nz\u00fcgyi \u00e9rt\u00e9kek form\u00e1z\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki a B11:F14 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+Shift+4<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-801c2d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"801c2d5\" 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-7644b8f\" data-id=\"7644b8f\" 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-a49a2e4 elementor-widget elementor-widget-global elementor-global-17120 elementor-widget-text-editor\" data-id=\"a49a2e4\" 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-dbc396b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbc396b\" 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-1525cd6\" data-id=\"1525cd6\" 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-858f580 elementor-widget elementor-widget-text-editor\" data-id=\"858f580\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"45\">\n<li>A tizedeshelyek sz\u00e1m\u00e1t a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se <\/strong><em>(Alt+\u0150, 9)<\/em> parancs k\u00e9tszeri kiad\u00e1s\u00e1val tudjuk null\u00e1ra \u00e1ll\u00edtani.<\/li>\n<li>Jel\u00f6lj\u00fck ki a t\u00e1bl\u00e1zat oszlopainak c\u00edmk\u00e9it tartalmaz\u00f3 B10:F10 tartom\u00e1nyt!<\/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>Az A oszlop c\u00edmk\u00e9inek jobbra z\u00e1r\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki az A11:A16 tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ Jobbra igaz\u00edt\u00e1s <\/strong><em>(Alt+\u0150, OO)<\/em> parancsot!<\/li>\n<li>B\u00e1r a feladat nem k\u00e9ri, c\u00e9lszer\u0171 az A oszlop sz\u00e9less\u00e9g\u00e9n n\u00f6velni, hogy minden c\u00edmke l\u00e1that\u00f3 legyen: hagyjuk kijel\u00f6lve az el\u0151z\u0151 tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, U)<\/em> parancsot! A k\u00e9sz t\u00e1bl\u00e1zatot mutatja a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_3_Tablazat2.jpg\" target=\"_blank\" rel=\"noopener\">3. \u00e1bra<\/a>.<\/li>\n<li>T\u00e9rj\u00fcnk vissza az M4-15 munkalapra a <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3val, majd az <em>Esc<\/em> billenty\u0171vel sz\u00fcntess\u00fck meg a diagram kijel\u00f6l\u00e9s\u00e9t, hogy visszakaphassuk az akt\u00edv cell\u00e1t.<\/li>\n<li>Az utols\u00f3 feladat a munkalap kinyomtat\u00e1sa. Mivel nem csak a k\u00e9t t\u00e1bl\u00e1zatot, hanem a diagramot is szeretn\u00e9nk \u2013 \u00e9s lehets\u00e9ges \u2013 egy oldalra nyomtatni, c\u00e9lszer\u0171 fekv\u0151 t\u00e1jol\u00e1st \u00e9s egy oldalra nyomtat\u00e1st be\u00e1ll\u00edtani.<\/li>\n<li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> <em>(Alt+P, O)<\/em> parancsot!<\/li>\n<li>Az <strong>Oldal<\/strong> f\u00fcl\u00f6n v\u00e1lasszuk ki a <strong>Fekv\u0151 T\u00e1jol\u00e1st <\/strong><em>(Alt+F)<\/em>, a <strong>Nagy\u00edt\u00e1s<\/strong> r\u00e9szben a <strong>Legyen<\/strong> v\u00e1laszt\u00f3gombot <em>(Alt+N)<\/em>!<\/li>\n<li>A <em>Ctrl+Tab<\/em> billenty\u0171kombin\u00e1ci\u00f3val l\u00e9pj\u00fcnk \u00e1t a <strong>Munkalap<\/strong> f\u00fclre!<\/li>\n<li>A <em>Tab<\/em> billenty\u0171vel l\u00e9pj\u00fcnk a <strong>R\u00e1csvonalakkal <\/strong><em>(Alt+R) <\/em>jel\u00f6l\u0151n\u00e9gyzetre \u00e9s a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel kapcsoljuk be!<\/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-b2fe783 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b2fe783\" 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-80fd102\" data-id=\"80fd102\" 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-b300437 elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"b300437\" 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-02c78c3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"02c78c3\" 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-27798db\" data-id=\"27798db\" 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-c174a74 elementor-widget elementor-widget-text-editor\" data-id=\"c174a74\" 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=\"57\">\n<li>Adjuk ki a <strong>F\u00e1jl \/ Export\u00e1l\u00e1s<\/strong> parancsot, \u00e9s keress\u00fck meg a <strong>PDF\/XPS l\u00e9trehoz\u00e1sa<\/strong> <em>(Alt+F, E, A) <\/em>gombot!<\/li>\n<li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel PDF vagy XPS form\u00e1tumban<\/strong> p\u00e1rbesz\u00e9dablak, amelynek <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben l\u00e1tjuk a munkaf\u00fczet nev\u00e9t, amit el is fogadhatunk: ments\u00fcnk a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> <em>(Alt+K)<\/em> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c546e2b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c546e2b\" 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-d35b3a8\" data-id=\"d35b3a8\" 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-e967ace elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"e967ace\" 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-f5f0fd0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5f0fd0\" 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-1e17042\" data-id=\"1e17042\" 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-68d30ad elementor-widget elementor-widget-text-editor\" data-id=\"68d30ad\" 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=\"59\">\n<li>Ha sz\u00e1m\u00edt\u00f3g\u00e9p\u00fcnk\u00f6n van PDF kezel\u0151 alkalmaz\u00e1s vagy b\u00f6ng\u00e9sz\u0151, akkor azt az Excel megpr\u00f3b\u00e1lja elind\u00edtani \u00e9s megjelen\u00edteni a f\u00e1jl tartalm\u00e1t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_4_PDF.jpg\" target=\"_blank\" rel=\"noopener\">(4. \u00e1bra)<\/a>.<\/li>\n<li>A feladattal v\u00e9gezt\u00fcnk, ments\u00fcnk \u00e9s z\u00e1rjunk be minden f\u00e1jlt \u00e9s alkalmaz\u00e1st!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7346cad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7346cad\" 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-7d1212c\" data-id=\"7d1212c\" 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-80f054b elementor-widget elementor-widget-text-editor\" data-id=\"80f054b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A feladat megold\u00e1sa sor\u00e1n 2 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet kett\u0151 munkalappal, valamint egy PDF dokumentumot <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/217-K-ECDLM04S6-Vizsgafeladat15_Megoldas1_5_Fajlok.jpg\" target=\"_blank\" rel=\"noopener\">(5. \u00e1bra)<\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9d7fce5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d7fce5\" 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-1d8cc95\" data-id=\"1d8cc95\" 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-aa141c8 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"aa141c8\" 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-1c95433 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c95433\" 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-374f48d\" data-id=\"374f48d\" 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-5082db5 elementor-widget elementor-widget-text-editor\" data-id=\"5082db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 j\u00fanius 13.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (21H2, 2111b19044)<br \/>Irodai programcsomag: Microsoft Office 2016 v2206b15330.20266, Aktu\u00e1lis csatorna<br \/>Szint: kezd\u0151, ECDL modul\/tanmenet: T\u00e1bl\u00e1zatkezel\u00e9s\/S6<br \/>Kateg\u00f3ria: ECDL \u2192 T\u00e1bl\u00e1zatkezel\u00e9s \u2192 Vizsgafeladatok<\/b><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b797a54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b797a54\" 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-20bc515\" data-id=\"20bc515\" 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-3dddd3e elementor-widget elementor-widget-shortcode\" data-id=\"3dddd3e\" 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--5036 \"        data-post-id=\"5036\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-5036\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-5036\">                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-05af7c0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"05af7c0\" 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-dcc5cfd\" data-id=\"dcc5cfd\" 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-df3b0c8 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=\"df3b0c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0Friss\u00edtve: 2022 j\u00falius 25. Mir\u0151l sz\u00f3l ez a cikk?Ebben a l\u00e1t\u00e1ss\u00e9r\u00fcltek sz\u00e1m\u00e1ra k\u00e9sz\u00fclt Microsoft Excel oktat\u00f3anyagban az ECDL T\u00e1bl\u00e1zatkezel\u00e9s modulhoz kiadott Vizsgap\u00e9ldat\u00e1r 15. 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=5036\">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-5036","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/5036","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=5036"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/5036\/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=5036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}