{"id":2825,"date":"2020-04-06T09:16:29","date_gmt":"2020-04-06T07:16:29","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=2825"},"modified":"2022-08-07T11:40:32","modified_gmt":"2022-08-07T09:40:32","slug":"ecdl-tablazatkezeles-8-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=2825","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 8. vizsgafeladat (#191\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"2825\" class=\"elementor elementor-2825\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6a06dc1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6a06dc1\" 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-e1885c0\" data-id=\"e1885c0\" 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-4272fce elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"4272fce\" 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 23.<\/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-0aca928 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0aca928\" 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-8f068a1\" data-id=\"8f068a1\" 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-9c1776d elementor-invisible elementor-widget elementor-widget-image\" data-id=\"9c1776d\" 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-4513582 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4513582\" 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-32a87cd\" data-id=\"32a87cd\" 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-2f57930 elementor-widget elementor-widget-text-editor\" data-id=\"2f57930\" 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 8. 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-5f8794b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f8794b\" 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-64acb44\" data-id=\"64acb44\" 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-9447969 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"9447969\" 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__9447969\" 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__9447969\" 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__9447969\" 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-b607653 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b607653\" 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-382a3fc\" data-id=\"382a3fc\" 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-01b30b8 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"01b30b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>Felhaszn\u00e1lt forr\u00e1sok:<\/strong><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/hu\/ecdl\/modul\/tablazatkezeles\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A T\u00e1bl\u00e1zatkezel\u00e9s modul tartalma az NJSzT oldal\u00e1n.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 febru\u00e1r 1-t\u0151l \u00e9rv\u00e9nyes T\u00e1bl\u00e1zatkezel\u00e9s Syllabus 6 (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 m\u00e1rcius 1-t\u0151l \u00e9rv\u00e9nyes ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A feladatokhoz tartoz\u00f3 munkaf\u00fczetek t\u00f6m\u00f6r\u00edtv\u00e9nye (ZIP f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/191-K-ECDLM04S6-Vizsgafeladat8.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 8. 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-1046b37 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1046b37\" 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-cc2916b\" data-id=\"cc2916b\" 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-fe12e20 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"fe12e20\" 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-313e108 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"313e108\" 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-296d473\" data-id=\"296d473\" 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-7cb9fff elementor-widget elementor-widget-text-editor\" data-id=\"7cb9fff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az ECDL Excel vizsgafeladat megold\u00e1sa el\u0151tt a megjel\u00f6lt forr\u00e1sok k\u00f6z\u00fcl t\u00f6lts\u00fck le sz\u00fcks\u00e9g szerint az <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s 6.0<\/a> dokumentumot \u00e9s a <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">munkaf\u00e1jlokat<\/a> \u2013 az el\u0151bbit nyissuk meg, az ut\u00f3bbit pedig csomagoljuk ki c\u00e9lszer\u0171en a Dokumentumok mapp\u00e1ba. A vizsgap\u00e9ldat\u00e1r PDF dokumentum, amit a legt\u00f6bb internet b\u00f6ng\u00e9sz\u0151 k\u00e9pes megnyitni, de haszn\u00e1lhatjuk b\u00e1rmelyik PDF olvas\u00f3 alkalmaz\u00e1st is, p\u00e9ld\u00e1ul az Adobe Acrobat Readert. L\u00e1t\u00e1ss\u00e9r\u00fclt sorst\u00e1rsaink <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/191-K-ECDLM04S6-Vizsgafeladat8.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-c6fa638 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6fa638\" 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-50ae4fc\" data-id=\"50ae4fc\" 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-d628996 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"d628996\" 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, akt\u00edv cella \u00e1thelyez\u00e9se, diagram k\u00e9sz\u00edt\u00e9se \u00e9s form\u00e1z\u00e1sa, export\u00e1l\u00e1s PDF form\u00e1tumban, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, munkalap hivatkoz\u00e1s, munkalap k\u00e9sz\u00edt\u00e9s, nett\u00f3 \u00c1FA brutt\u00f3 sz\u00e1m\u00edt\u00e1s, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, oszlopok \u00e9s sorok kezel\u00e9se, rel\u00e1ci\u00f3s oper\u00e1torok, t\u00e1bl\u00e1zat form\u00e1z\u00e1sa, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek:<\/strong> <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, HA, 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-8479973 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8479973\" 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-57d15d6\" data-id=\"57d15d6\" 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-5764749 elementor-widget elementor-widget-text-editor\" data-id=\"5764749\" 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-38fc83f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38fc83f\" 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-ce55ee8\" data-id=\"ce55ee8\" 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-1042e84 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"1042e84\" 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\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-1024x576.jpg\" class=\"attachment-large size-large wp-image-25811\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 8. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2c5b6b5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c5b6b5\" 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-b5a3f6a\" data-id=\"b5a3f6a\" 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-06c8d9c elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"06c8d9c\" 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\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-25812\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 8. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A k\u00e9sz csoportos\u00edtott oszlopdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: A k\u00e9sz csoportos\u00edtott oszlopdiagram.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d191cb0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d191cb0\" 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-51f7e44\" data-id=\"51f7e44\" 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-d0521f5 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d0521f5\" 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\/191-K-ECDLM04S6-Vizsgafeladat8_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\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-1024x576.jpg\" class=\"attachment-large size-large wp-image-25813\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 8. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat a Munka1 munkalapon.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_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 k\u00e9sz t\u00e1bl\u00e1zat a Munka1 munkalapon.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b4395d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b4395d6\" 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-a78fd5c\" data-id=\"a78fd5c\" 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-8cea169 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"8cea169\" 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\/191-K-ECDLM04S6-Vizsgafeladat8_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\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-25814\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 8. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: A Munka1 munkalap t\u00e1bl\u00e1zat\u00e1nak PDF exportja a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_4_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_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: A Munka1 munkalap t\u00e1bl\u00e1zat\u00e1nak PDF exportja 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-69be42a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"69be42a\" 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-7197fdf\" data-id=\"7197fdf\" 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-b3d329b elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"b3d329b\" 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\/191-K-ECDLM04S6-Vizsgafeladat8_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\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-25815\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 8. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_5_Fajlok.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d5ba69d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d5ba69d\" 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-cd5e531\" data-id=\"cd5e531\" 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-20bba56 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"20bba56\" 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-5eec16c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5eec16c\" 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-4a4668f\" data-id=\"4a4668f\" 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-84af791 elementor-widget elementor-widget-text-editor\" data-id=\"84af791\" 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 (70 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-2f937a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f937a8\" 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-3ba3228\" data-id=\"3ba3228\" 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-2a21381 elementor-widget elementor-widget-text-editor\" data-id=\"2a21381\" 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-8.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> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-46354d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"46354d0\" 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-11de231\" data-id=\"11de231\" 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-4e0f5dc elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"4e0f5dc\" 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-fe6ccf2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fe6ccf2\" 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-8230a8f\" data-id=\"8230a8f\" 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-f6a3ad4 elementor-widget elementor-widget-text-editor\" data-id=\"f6a3ad4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"4\">\n<li>Els\u0151 teend\u0151nk, hogy megismerkedj\u00fcnk a t\u00e1bl\u00e1zattal: az M4-8 munkalap d\u00e9zs\u00e1s egzotikus n\u00f6v\u00e9nyek exportmennyis\u00e9geit \u00e9s egys\u00e9g\u00e1rait tartalmazza a 2011, 2012 \u00e9s 2013 \u00e9vekben. A t\u00e1bl\u00e1zat az A1:E19 tartom\u00e1nyt foglalja el. Az els\u0151 sor az oszlopfeliratokat tartalmazza. Az A oszlopban a n\u00f6v\u00e9nyek nevei sorakoznak, a B oszlopban foglalnak helyet az egys\u00e9g\u00e1rak, m\u00edg a C:E oszlopokat az export\u00e1lt mennyis\u00e9gek numerikus adatai t\u00f6ltik ki. A 2011-2013 \u00e9vsz\u00e1m c\u00edmk\u00e9k Form\u00e1tumk\u00f3dja nem <strong>Sz\u00f6veg<\/strong>, hanem <strong>\u00c1ltal\u00e1nos<\/strong>, vagyis numerikus adatok, sz\u00e1mok. Ez a diagramk\u00e9sz\u00edt\u00e9sn\u00e9l elker\u00fclend\u0151 probl\u00e9m\u00e1t fog okozni, a megold\u00e1st majd ott t\u00e1rgyaljuk.<\/li>\n<\/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-10b7ce1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"10b7ce1\" 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-3509ee4\" data-id=\"3509ee4\" 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-e6506a5 elementor-widget elementor-widget-text-editor\" data-id=\"e6506a5\" 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 feladatsor exportmennyis\u00e9gekr\u0151l \u00edr, \u00e9s k\u00f6vetkezetesen k\u00f6lts\u00e9geket eml\u00edt. Amikor export\u00e1lunk (kivitel\/elad\u00e1s m\u00e1sik orsz\u00e1gba), akkor nem k\u00f6lts\u00e9g\u00fcnk, hanem bev\u00e9tel\u00fcnk sz\u00e1rmazik. Mi \u00e9ppen ez\u00e9rt a cikkben ahol lehet a k\u00f6lts\u00e9g sz\u00f3 helyett a bev\u00e9tel sz\u00f3t fogjuk alkalmazni.<\/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-64f00cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64f00cf\" 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-28f84fd\" data-id=\"28f84fd\" 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-9fd8339 elementor-widget elementor-widget-text-editor\" data-id=\"9fd8339\" 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 az F oszlopban kisz\u00e1molni minden n\u00f6v\u00e9ny export bev\u00e9tel\u00e9t az egys\u00e9g\u00e1r \u00e9s a h\u00e1rom \u00e9vi export alapj\u00e1n. Kisz\u00e1m\u00edt\u00e1s\u00e1nak menete, hogy az egys\u00e9g\u00e1rat megszorozzuk a h\u00e1rom \u00e9vi exportmennyis\u00e9g \u00f6sszeg\u00e9vel. Az F2 cell\u00e1ban a k\u00e9plet a k\u00f6vetkez\u0151 lesz: <strong>=B2*SZUM(C2:E2)<\/strong><\/li>\n<li>El\u0151tte azonban g\u00e9pelj\u00fck be az F1 cell\u00e1ba az oszlop nev\u00e9t: K\u00f6lts\u00e9g<\/li>\n<li>\u00dcss\u00fck le az <em>F5<\/em> funkci\u00f3billenty\u0171t az <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>A <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be g\u00e9pelj\u00fck be az F2:F19 tartom\u00e1nyhivatkoz\u00e1st, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eb51894 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eb51894\" 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-13309f2\" data-id=\"13309f2\" 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-e08c493 elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"e08c493\" 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-2c9c42d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c9c42d\" 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-04d3c23\" data-id=\"04d3c23\" 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-61b7feb elementor-widget elementor-widget-text-editor\" data-id=\"61b7feb\" 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=\"9\">\n<li>G\u00e9pelj\u00fck be a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba (F2) az <strong>=B2*SZUM(C2:E2) <\/strong>k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171parancsot! Az Excel a k\u00e9pletet a tartom\u00e1ny minden cell\u00e1j\u00e1ba \u00e1tm\u00e1solja a megfelel\u0151 tartom\u00e1nyhivatkoz\u00e1ssal, k\u00f6sz\u00f6nhet\u0151en a k\u00e9pletben alkalmazott relat\u00edv hivatkoz\u00e1snak.<\/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-78c2e30 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"78c2e30\" 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-37a3afc\" data-id=\"37a3afc\" 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-3b747df elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"3b747df\" 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-669d172 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"669d172\" 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-e6e17d8\" data-id=\"e6e17d8\" 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-9e6b51c elementor-widget elementor-widget-text-editor\" data-id=\"9e6b51c\" 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=\"10\">\n<li>A huszadik sorban a C:E oszlopok \u00f6sszegeit kell k\u00e9pezn\u00fcnk: g\u00e9pelj\u00fck be az A20 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00d6sszesen<\/li>\n<li>Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az C20:E20 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba, vagyis a C20 cell\u00e1ba g\u00e9pelj\u00fck be az \u00f6sszegz\u0151 k\u00e9pletet: <strong>=SZUM(C2:C19)<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A 21. sorban a C:E oszlopok \u00e1tlagait kell kisz\u00e1molnunk: g\u00e9pelj\u00fck be az A21 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li>\n<li>Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki a C21:E21 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba, vagyis a C21 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00e9pletet: <strong>=\u00c1TLAG(C2:C19)<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A C30:E30 tartom\u00e1nyban a Vadcitrom bev\u00e9teleit kell kisz\u00e1molnunk egyenk\u00e9nt, mind a h\u00e1rom \u00e9vre. A Vadcitrom a m\u00e1sodik sorban, egys\u00e9g\u00e1ra a B2 cell\u00e1ban, az export\u00e1lt mennyis\u00e9gek pedig a C2:E2 tartom\u00e1nyban tal\u00e1lhat\u00f3k. A C30 cell\u00e1ban a bev\u00e9telt \u00fagy tudjuk kisz\u00e1molni a 2011 \u00e9vre, hogy az egys\u00e9g\u00e1rat (B2) megszorozzuk a 2011 \u00e9vi export mennyis\u00e9ggel (C2). A C30 cell\u00e1ba ker\u00fcl\u0151 k\u00e9plet a k\u00f6vetkez\u0151 lesz: <strong>=$B$2*C2<\/strong>. Az abszol\u00fat c\u00edmz\u00e9sre az\u00e9rt van sz\u00fcks\u00e9g\u00fcnk, mert a k\u00e9pletet a 30. sorban jobbra m\u00e1solni fogjuk a m\u00e1sik k\u00e9t oszlop al\u00e1, \u00edgy meg kell akad\u00e1lyoznunk, hogy a B2 cell\u00e1ra mutat\u00f3 hivatkoz\u00e1s m\u00f3dosuljon.<\/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-cac824d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cac824d\" 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-129789f\" data-id=\"129789f\" 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-106a454 elementor-widget elementor-widget-text-editor\" data-id=\"106a454\" 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> Igaz\u00e1b\u00f3l elegend\u0151 lenne a vegyes hivatkoz\u00e1s, vagyis a $B2 c\u00edm haszn\u00e1lata, mivel a k\u00e9plet jobbra m\u00e1sol\u00e1sa sor\u00e1n a sor nem, csak az oszlop v\u00e1ltozik.<\/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-ec2c9b9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ec2c9b9\" 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-222367f\" data-id=\"222367f\" 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-13c90d0 elementor-widget elementor-widget-text-editor\" data-id=\"13c90d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"17\">\n<li>G\u00e9pelj\u00fck be az A30 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Vadcitrom bev\u00e9tel<\/li>\n<li>Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki a C30:E30 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba, vagyis a C30 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=$B$2*C2 <\/strong>k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A k\u00f6vetkez\u0151 feladat a sz\u00e1mokat tartalmaz\u00f3 cell\u00e1k form\u00e1z\u00e1sa: sz\u00e1mokat a k\u00f6vetkez\u0151 tartom\u00e1nyok tartalmaznak: B2:F21;C30:E30. Jel\u00f6lj\u00fck ki ezeket a cell\u00e1kat az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel!<\/li>\n<li>Az ezres csoport be\u00e1ll\u00edt\u00e1s\u00e1hoz v\u00e1lasszuk a <strong>Kezd\u0151lap \/ Ezres csoport<\/strong> <em>(Alt+\u0150, RE)<\/em> ikonj\u00e1t!<\/li>\n<li>A tizedeshelyek sz\u00e1m\u00e1t a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se<\/strong> <em>(Alt+\u0150, 9)<\/em> ikon k\u00e9tszeri haszn\u00e1lat\u00e1val tudjuk lenull\u00e1zni.<\/li>\n<li>Az egys\u00e9g\u00e1rak form\u00e1z\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki a B2:B19 tartom\u00e1nyt, majd nyomjuk le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t a f\u00e9lk\u00f6v\u00e9r bet\u0171st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-19622ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"19622ac\" 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-dbadcd1\" data-id=\"dbadcd1\" 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-206df7a elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"206df7a\" 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-d617106 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d617106\" 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-2497c73\" data-id=\"2497c73\" 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-44eda05 elementor-widget elementor-widget-text-editor\" data-id=\"44eda05\" 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>A p\u00e9nznem form\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz v\u00e1lasszuk ki a <strong>Kezd\u0151lap \/ K\u00f6nyvel\u00e9si sz\u00e1mform\u00e1tum \/ Ft magyar<\/strong> <em>(Alt+\u0150, AN, Enter)<\/em> parancsot!<\/li>\n<li>A 2011:2012 oszlopokban a <strong>S\u00e1rga <\/strong>kit\u00f6lt\u0151sz\u00edn \u00e9s a <strong>Piros <\/strong>bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz jel\u00f6lj\u00fck ki a C2:D19 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>A <strong>Piros <\/strong>bet\u0171sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz haszn\u00e1ljuk <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1t! A paletta <strong>Alapsz\u00ednek<\/strong> r\u00e9sz\u00e9ben a m\u00e1sodik a <strong>Piros <\/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 B2:E19 tartom\u00e1nyt k\u00fcls\u0151 piros szeg\u00e9llyel kell ell\u00e1tnunk \u2013 jel\u00f6lj\u00fck ki!<\/li>\n<li>Jelen\u00edts\u00fck meg a <strong>Cell\u00e1k form\u00e1z\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablakot, a <em>Ctrl+1<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>A <em>Ctrl+Tab<\/em> seg\u00edts\u00e9g\u00e9vel l\u00e9pj\u00fcnk a <strong>Szeg\u00e9ly<\/strong> f\u00fclre!<\/li>\n<li>Ugyan a feladat nem \u00edr el\u0151 vonalst\u00edlust, ett\u0151l f\u00fcggetlen\u00fcl \u00e9rdemes egy j\u00f3l l\u00e1that\u00f3 keretet k\u00e9sz\u00edten\u00fcnk, \u00edgy ne sajn\u00e1ljuk az id\u0151t a be\u00e1ll\u00edt\u00e1s\u00e1ra: \u00fcss\u00fck le a <em>Tab<\/em> billenty\u0171t a <strong>St\u00edlus<\/strong> list\u00e1ba <em>(Alt+S)<\/em> ugr\u00e1shoz, a <em>ny\u00edlbillenty\u0171kkel<\/em> keress\u00fck meg p\u00e9ld\u00e1ul a <strong>K\u00f6zepes<\/strong> vonalst\u00edlust \u00e9s jel\u00f6lj\u00fck ki a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel!<\/li>\n<li>L\u00e9pj\u00fcnk a <em>Tab<\/em> billenty\u0171vel a <strong>Sz\u00edn<\/strong> kombin\u00e1lt listamez\u0151re <em>(Alt+Z)<\/em>, \u00e9s a <em>Le ny\u00edlbillenty\u0171vel<\/em> jelen\u00edts\u00fck meg a sz\u00ednpalett\u00e1t! A paletta <strong>Alapsz\u00ednek<\/strong> r\u00e9sz\u00e9ben a m\u00e1sodik a <strong>Piros <\/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>L\u00e9pj\u00fcnk tov\u00e1bb a <em>Tab<\/em>-bal az <strong>Elhelyez\u00e9s<\/strong> r\u00e9szre (<strong>Nincs<\/strong>, <strong>K\u00f6r\u00fcl<\/strong>, <strong>Bel\u00fcl<\/strong>), ahol a <em>Jobb ny\u00edlbillenty\u0171vel<\/em> keress\u00fck meg a <strong>K\u00f6r\u00fcl<\/strong> <em>(Alt+K)<\/em> gombot \u00e9s v\u00e1lasszuk ki a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel \u2013 a be\u00e1ll\u00edtott vonalst\u00edlus \u00e9s sz\u00edn most jut \u00e9rv\u00e9nyre, teh\u00e1t a v\u00e9grehajt\u00e1s sorrendj\u00e9t be kell tartanunk: st\u00edlus, sz\u00edn, kerett\u00edpus.<\/li>\n<li>A p\u00e1rbesz\u00e9dablakb\u00f3l az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel l\u00e9pj\u00fcnk ki!<\/li>\n<li>Sz\u00e1mos cell\u00e1ban #-eket tal\u00e1lunk, mivel keskenyek az oszlopok az adatok megjelen\u00edt\u00e9s\u00e9hez. N\u00f6velj\u00fck meg az oszlopok sz\u00e9less\u00e9g\u00e9t a sz\u00fcks\u00e9ges m\u00e9rt\u00e9kben: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel az A:F oszlopokat, 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 az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_1_Tablazat1.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>.<\/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-9e6828d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e6828d\" 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-057df4a\" data-id=\"057df4a\" 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-b405f9b elementor-widget elementor-widget-text-editor\" data-id=\"b405f9b\" 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 \/>K\u00f6vetkez\u0151 feladatunk csoportos\u00edtott oszlopdiagram k\u00e9sz\u00edt\u00e9se a 2007-2011 \u00e9vekb\u0151l. A diagramon az \u00e9vsz\u00e1mokat is fel kell t\u00fcntetn\u00fcnk az adatsorok oszlopai alatt a kateg\u00f3riatengelyen (X-tengely). Azonban egy diagram k\u00e9sz\u00edt\u00e9se el\u0151tt mindig meg kell gy\u0151z\u0151dn\u00fcnk arr\u00f3l, hogy a kateg\u00f3riatengelyen megjelen\u00edteni k\u00edv\u00e1nt \u00e9rt\u00e9kek adatt\u00edpusa igazodik-e a kiv\u00e1lasztott diagramhoz. Ugyanis a mi eset\u00fcnkben ezek \u00e9vsz\u00e1mok, numerikus adatok, amit az is bizony\u00edt, hogy a cell\u00e1kban jobbra z\u00e1rtak. Ez pedig megzavarhatja az Excelt, ha kateg\u00f3riatengelyen megjelen\u0151 adatnak jel\u00f6lj\u00fck ki ezeket a cell\u00e1kat, ami hib\u00e1s adatmegjelen\u00edt\u00e9st eredm\u00e9nyez, az \u00e9vsz\u00e1mok helyett sorsz\u00e1mok jelennek meg \u2013 tapasztalataink szerint Excel verzi\u00f3t\u00f3l f\u00fcgg ez a jelens\u00e9g (tal\u00e1n szoftverhiba).<br \/>A megold\u00e1s a sz\u00e1mok sz\u00f6vegg\u00e9 alak\u00edt\u00e1sa. Azonban az \u00e9vsz\u00e1mokat hi\u00e1ba alak\u00edtjuk \u00e1t a <strong>Sz\u00f6veg<\/strong> form\u00e1tumk\u00f3ddal, ez nem el\u00e9g: az \u00e9vsz\u00e1mokat ki kell eg\u00e9sz\u00edten\u00fcnk egy karakterrel, amire mi a pontot javasoljuk.<\/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-014676d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"014676d\" 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-76e7689\" data-id=\"76e7689\" 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-e4c7bb2 elementor-widget elementor-widget-text-editor\" data-id=\"e4c7bb2\" 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=\"36\">\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t a C1-re, majd jav\u00edtsuk \u00e1t a 2011 \u00e9vet 2011.-ra <em>(F2, ., Tab)<\/em>!<\/li>\n<li>Ism\u00e9telj\u00fck meg az el\u0151z\u0151 l\u00e9p\u00e9ssort a D1 \u00e9s az E1 cell\u00e1ban, pontot illesztve minden \u00e9vsz\u00e1m m\u00f6g\u00e9!<\/li>\n<li>Egy csoportos\u00edtott oszlopdiagramot kell k\u00e9sz\u00edten\u00fcnk egy \u00faj munkalapra az els\u0151 n\u00e9gy n\u00f6v\u00e9ny (2:5 sorok) \u00e9s a 2011-2012 \u00e9vek (C:D oszlopok) adataib\u00f3l. A B oszlopot ki kell hagynunk, a kateg\u00f3riatengely feliratait az A1;C1:D1 tartom\u00e1nyok adj\u00e1k, a n\u00e9gy n\u00f6v\u00e9ny adatait pedig az A2:A5 \u00e9s a C2:D5 tartom\u00e1nyokban tal\u00e1ljuk. Mivel egym\u00e1s melletti tartom\u00e1nyokr\u00f3l van sz\u00f3, a\u00a0kijel\u00f6lend\u0151 tartom\u00e1nyok c\u00edme egyszer\u0171: A1:A5;C1:D5<\/li>\n<li>Az <em>F5<\/em> seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki az A1:A5;C1:D5 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-70d0816 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70d0816\" 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-f5f1a35\" data-id=\"f5f1a35\" 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-950277f elementor-widget elementor-widget-text-editor\" data-id=\"950277f\" 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 B oszlopot.<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve az A1:A5;C1:D5 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcletet, l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek val\u00f3ban egy folytonos t\u00e9glalapot mint\u00e1znak.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8d755c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d755c4\" 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-f884076\" data-id=\"f884076\" 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-dafb11c elementor-widget elementor-widget-text-editor\" data-id=\"dafb11c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"40\">\n<li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Oszlop- \u00e9s s\u00e1vdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, \u00da)<\/em> parancsot, majd a megjelen\u0151 palett\u00e1n keress\u00fck meg a <strong>Csoportos\u00edtott oszlop<\/strong> t\u00edpust \u00e9s v\u00e1lasszuk ki! Az Excel besz\u00farja a diagramot a munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9re \u00e9s kijel\u00f6li azt.<\/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-f5b5cad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5b5cad\" 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-a3a5617\" data-id=\"a3a5617\" 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-1793b84 elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"1793b84\" 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-25f8b4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"25f8b4f\" 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-2a6613b\" data-id=\"2a6613b\" 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-8e319db elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"8e319db\" 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-fd032b7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd032b7\" 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-95f991f\" data-id=\"95f991f\" 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-3bb65bc elementor-widget elementor-widget-text-editor\" data-id=\"3bb65bc\" 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=\"41\">\n<li>A diagram \u00f6n\u00e1ll\u00f3 diagramlapra helyez\u00e9s\u00e9hez adjuk ki a <strong>Tervez\u00e9s \/ Diagram \u00e1thelyez\u00e9se<\/strong> parancsot <em>(Alt+JV, I)<\/em>!<\/li>\n<li>A k\u00e9perny\u0151n megjelen\u0151 <strong>Diagram \u00e1thelyez\u00e9se<\/strong> p\u00e1rbesz\u00e9dablakban v\u00e1lasszuk ki az <strong>\u00daj munkalap<\/strong> szerkeszt\u0151mez\u0151t, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! Diagramunk \u00e1tker\u00fcl egy \u00faj, Diagram1 nev\u0171 diagramlapra, amely az M4-8 munkalapt\u00f3l balra, az el\u0151tt j\u00f6n l\u00e9tre.<\/li>\n<li>A diagram c\u00edm\u00e9nek megad\u00e1s\u00e1hoz v\u00e1lasszuk ki a <strong>Tervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ A diagram felett <\/strong>parancsot <em>(Alt+JV, D, C, A)<\/em>! Ezzel a c\u00edmet a diagram f\u00f6l\u00e9, k\u00f6z\u00e9pre helyezz\u00fck, egyben kijel\u00f6ltt\u00e9 tessz\u00fck azt a szerkeszt\u00e9shez.<\/li>\n<li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be az Export\u00e1lt mennyis\u00e9g 2011\u20132012 c\u00edmet, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>Az egyik adatsor \u2013 legyen a 2011 \u2013 oszlopainak sz\u00edn\u00e9t z\u00f6ldre kell m\u00f3dos\u00edtanunk. Ehhez v\u00e1lasszuk ki a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> kombin\u00e1lt listamez\u0151t, g\u00f6rd\u00edts\u00fck le, \u00e1lljunk r\u00e1 az <strong>Adatsor &#8222;2011.&#8221; <\/strong>elemre, v\u00e9g\u00fcl v\u00e1lasszuk ki az <em>Enter <\/em>billenty\u0171vel!<\/li>\n<li>A <strong>Z\u00f6ld<\/strong> kit\u00f6lt\u0151sz\u00edn be\u00e1ll\u00edt\u00e1s\u00e1hoz v\u00e1lasszuk ki a <strong>Form\u00e1tum \/ Kit\u00f6lt\u00e9s <\/strong><em>(Alt+JZ, \u00d6)<\/em> sz\u00ednpalett\u00e1t! 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>Diagramunkon n\u00e9gyszer 2-2 oszlopban helyezkednek el a 2011 \u00e9s a 2012 \u00e9vek export mennyis\u00e9geit mutat\u00f3 oszlopok: el\u00f6l a 2011, ut\u00e1na a 2012 \u00e9v adatsor\u00e1t tal\u00e1ljuk. Feladatunk ennek a sorrendnek a megford\u00edt\u00e1sa, hogy az els\u0151 n\u00e9gy oszlop ne a 2011, hanem a 2012 \u00e9v adatait mutassa mind a n\u00e9gy n\u00f6v\u00e9nyn\u00e9l. Adjuk ki a <strong>Tervez\u00e9s \/ Adatok kijel\u00f6l\u00e9se <\/strong><em>(Alt+JV, T)<\/em> parancsot, amelynek hat\u00e1s\u00e1ra a k\u00e9perny\u0151n megjelenik az <strong>Adatforr\u00e1s kiv\u00e1laszt\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablak!<\/li>\n<li>A p\u00e1rbesz\u00e9dablak lehet\u0151s\u00e9get biztos\u00edt az adatforr\u00e1s (adatsorok \u00e9s \u00e9rt\u00e9kek) kezel\u00e9s\u00e9re. Nek\u00fcnk a k\u00e9t adatsor sorrendj\u00e9t kell megcser\u00e9ln\u00fcnk egy, a 2011. \u00e9s 2012. adatsorokat felk\u00edn\u00e1l\u00f3 list\u00e1ban. Ebben a list\u00e1ban a 2011. adatsoron \u00e1ll a f\u00f3kusz, azaz ez van kijel\u00f6lt \u00e1llapotban, \u00edgy a sorrend m\u00f3dos\u00edt\u00e1s\u00e1ra szolg\u00e1l\u00f3 <strong>Lejjebb<\/strong> gombot kell mind\u00f6ssze egyszer kiv\u00e1lasztanunk: a <em>Tab<\/em> billenty\u0171 seg\u00edts\u00e9g\u00e9vel keress\u00fck meg, majd kiv\u00e1laszt\u00e1s\u00e1hoz \u00fcss\u00fck le a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t! A k\u00e9t adatsort siker\u00fclt megcser\u00e9ln\u00fcnk.<\/li>\n<li>Z\u00e1rjuk be a p\u00e1rbesz\u00e9dablakot az <strong>OK<\/strong> gombbal! A k\u00e9sz csoportos\u00edtott oszlopdiagramot mutatja a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_2_Diagram.jpg\" target=\"_blank\" rel=\"noopener\">2. \u00e1bra<\/a>.<\/li>\n<li>L\u00e9pj\u00fcnk vissza az M4-8 munkalapra a <em>Ctrl+PageDown<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>A k\u00f6vetkez\u0151 feladat szerint m\u00e1solatot kell k\u00e9sz\u00edten\u00fcnk a teljes t\u00e1bl\u00e1zatr\u00f3l egy \u00faj munkalapra: jel\u00f6lj\u00fck ki az A1:F30 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3t a t\u00e1bl\u00e1zat V\u00e1g\u00f3lapra m\u00e1sol\u00e1s\u00e1hoz!<\/li>\n<li>Nyomjuk le a <em>Shift+F11<\/em> billenty\u0171kombin\u00e1ci\u00f3t egy \u00faj munkalap k\u00e9sz\u00edt\u00e9s\u00e9hez! Az \u00faj, Munka1 munkalap az M4-8 munkalap el\u0151tt j\u00f6n l\u00e9tre, a kor\u00e1bban l\u00e9trehozott Diagram1 munkalap pedig a Munka1 munkalap el\u00e9 ker\u00fcl.<\/li>\n<li>A <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3val illessz\u00fck be a V\u00e1g\u00f3lap tartalm\u00e1t az A1 cell\u00e1ba! <strong>A tov\u00e1bbiakban ezen a Munka1 nev\u0171 munkalapon kell dolgoznunk.<\/strong> A beillesztett t\u00e1bl\u00e1zat kijel\u00f6l\u00e9s\u00e9t m\u00e9g ne sz\u00fcntess\u00fck meg!<\/li>\n<li>A t\u00e1bl\u00e1zat oszlopai keskenyek, mivel a beilleszt\u00e9s sor\u00e1n az Excel nem n\u00f6velte meg automatikusan az oszlopok sz\u00e9less\u00e9g\u00e9t. Ugyan a feladatsor nem k\u00e9ri, de illik ezen jav\u00edtanunk, \u00edgy adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, U)<\/em> parancsot!<\/li>\n<li>M\u00e9g k\u00e9t teend\u0151nk van: az export adatok cell\u00e1iban (C2:E19) az \u00e9rt\u00e9keket le kell cser\u00e9ln\u00fcnk egy olyan k\u00e9pletre, amelyben hivatkozunk az M4-8 munkalap ugyanazon cell\u00e1ira, de \u00fagy, hogy azoknak csak ezredr\u00e9sze jelenjen meg eredm\u00e9ny\u00fcl. Az els\u0151 hall\u00e1sra bonyolult el\u0151\u00edr\u00e1s egyr\u00e9szt egy t\u00e1vhivatkoz\u00e1st k\u00e9r t\u0151l\u00fcnk (hivatkoz\u00e1s m\u00e1sik munkalap cell\u00e1j\u00e1ra), m\u00e1sr\u00e9szt egy ezerrel val\u00f3 oszt\u00e1st. Hogy n\u00e9z ki ez a k\u00e9plet a C2-ben? Az M4-8 munkalap C2 cell\u00e1j\u00e1ra az \u2019M4-8\u2019!C2 hivatkoz\u00e1ssal mutatunk, \u00e9s ezt kell osztanunk ezerrel. Teh\u00e1t a C2 cell\u00e1ba ker\u00fcl\u0151 k\u00e9plet a k\u00f6vetkez\u0151: <strong>=&#8217;M4-8&#8242;!C2\/1000<\/strong><\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d6a90f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d6a90f\" 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-87d1515\" data-id=\"87d1515\" 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-6049d56 elementor-widget elementor-widget-text-editor\" data-id=\"6049d56\" 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 t\u00e1vhivatkoz\u00e1sok egyike a m\u00e1sik munkalap cell\u00e1j\u00e1ra hivatkoz\u00e1s, amely a k\u00f6vetkez\u0151k\u00e9ppen \u00e9p\u00fcl fel: aposztr\u00f3fok <i>(Shift+1)<\/i> k\u00f6z\u00e9 z\u00e1rva meg kell adnunk a munkalap nev\u00e9t, ut\u00e1na egy felki\u00e1lt\u00f3jel k\u00f6vetkezik, majd a cella vagy tartom\u00e1ny c\u00edme.<\/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-088dfd8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"088dfd8\" 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-e207a6c\" data-id=\"e207a6c\" 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-9428a79 elementor-widget elementor-widget-text-editor\" data-id=\"9428a79\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"56\">\n<li>Jel\u00f6lj\u00fck ki a C2:E19 tartom\u00e1nyt, majd a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1ba g\u00e9pelj\u00fck be az <strong>=&#8217;M4-8&#8242;!C2\/1000<\/strong> k\u00e9pletet, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! Minden cell\u00e1ban az M4-8 munkalapon tal\u00e1lhat\u00f3 \u00e9rt\u00e9kek ezredr\u00e9sze fog megjelenni. Ha az M4-8 munkalapon m\u00f3dos\u00edtjuk b\u00e1rmelyik export \u00e9rt\u00e9ket, akkor annak ezredr\u00e9sze fog megjelenni a Munka1 munkalap ugyanazon cell\u00e1j\u00e1ban.<\/li>\n<li>A k\u00f6vetkez\u0151 feladat a G oszlopban k\u00e9ri a Dr\u00e1ga sz\u00f3 megjelen\u00edt\u00e9s\u00e9t minden olyan n\u00f6v\u00e9ny sor\u00e1ban, amelynek Egys\u00e9g\u00e1ra (B oszlop) meghaladja az Egys\u00e9g\u00e1r \u00e1tlag\u00e1nak 130%-\u00e1t. Egy\u00e9b esetben ne jelenjen meg semmi.<br \/>A megold\u00e1s egy \u00f6sszetettnek t\u0171n\u0151 k\u00e9plet: sz\u00fcks\u00e9g\u00fcnk lesz a HA \u00e9s az \u00c1TLAG f\u00fcggv\u00e9nyekre. Az Egys\u00e9g\u00e1r oszlop \u00e1tlag\u00e1t a k\u00f6vetkez\u0151k\u00e9ppen sz\u00e1moljuk ki: <strong>\u00c1TLAG($B$2:$B$19)<\/strong>. Az abszol\u00fat c\u00edmz\u00e9sre az\u00e9rt van sz\u00fcks\u00e9g\u00fcnk, mert a k\u00e9pletet a G oszlopban lefel\u00e9 fogjuk sokszoros\u00edtani, \u00edgy meg kell akad\u00e1lyoznunk, hogy az Egys\u00e9g\u00e1r oszlopra hivatkoz\u00e1s m\u00f3dosuljon.<br \/>Az \u00e1tlag\u00e1r 130%-a nem m\u00e1s mint: <strong>\u00c1TLAG($B$2:$B$19)*1,3<\/strong><br \/>A HA f\u00fcggv\u00e9ny els\u0151 argumentuma egy felt\u00e9tel, ahol azt kell megvizsg\u00e1lnunk, hogy az adott sorban tal\u00e1lhat\u00f3 Egys\u00e9g\u00e1r nagyobb-e az \u00e1tlag\u00e1r 130%-\u00e1n\u00e1l. A G2 cell\u00e1ban a felt\u00e9tel \u00edgy fog kin\u00e9zni: <strong>B2&gt;\u00c1TLAG($B$2:$B$19)*1,3<\/strong><br \/>Ha az el\u0151bbi felt\u00e9tel IGAZ eredm\u00e9nyt ad, akkor a HA f\u00fcggv\u00e9ny m\u00e1sodik argumentuma a &#8222;Dr\u00e1ga&#8221; lesz, ha HAMIS, akkor a harmadik argumentuma egy \u00fcres karakterl\u00e1nc kell legyen. \u00c1ll\u00edtsuk \u00f6ssze a k\u00e9pletet, amely a G2 cell\u00e1ban a k\u00f6vetkez\u0151k\u00e9ppen fog kin\u00e9zni:<br \/><strong>=HA(B2&gt;\u00c1TLAG($B$2:$B$19)*1,3;&#8221;Dr\u00e1ga&#8221;;&#8221;&#8221;)<\/strong><\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c81f30 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c81f30\" 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-1e66177\" data-id=\"1e66177\" 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-169fbfc elementor-widget elementor-widget-global elementor-global-17165 elementor-widget-text-editor\" data-id=\"169fbfc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Ha egy feladat a semmi megjelen\u00edt\u00e9s\u00e9t \u00edrja el\u0151, akkor mindig egy \u00fcres karakterl\u00e1ncot kell megadnunk k\u00e9t id\u00e9z\u0151jellel: &#8222;&#8221; <i>(Shift+2, Shift+2)<\/i>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6b036c1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b036c1\" 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-275f15c\" data-id=\"275f15c\" 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-4269826 elementor-widget elementor-widget-text-editor\" data-id=\"4269826\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"58\">\n<li>A G1 cell\u00e1ba c\u00edmk\u00e9nek g\u00e9pelj\u00fck be a felt\u00e9telt a k\u00f6vetkez\u0151 form\u00e1ban: Egys\u00e9g\u00e1r&gt;\u00c1TLAG(Egys\u00e9g\u00e1r)*1,3<\/li>\n<li>Jel\u00f6lj\u00fck ki az G2:G19 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1ny akt\u00edv cell\u00e1ja a G2, amibe g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=HA(B2&gt;\u00c1TLAG($B$2:$B$19)*1,3;&#8221;Dr\u00e1ga&#8221;;&#8221;&#8221;)<\/strong>, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! H\u00e1rom sorban lesz &#8222;Dr\u00e1ga&#8221; eredm\u00e9ny\u00fcnk.<\/li>\n<li>A G1-be beg\u00e9pelt oszlopc\u00edmke helyig\u00e9nye miatt nyomjuk le a <em>Ctrl+Sz\u00f3k\u00f6z <\/em>billenty\u0171kombin\u00e1ci\u00f3t az oszlop kijel\u00f6l\u00e9s\u00e9hez, 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\/191-K-ECDLM04S6-Vizsgafeladat8_Megoldas1_3_Tablazat2.jpg\" target=\"_blank\" rel=\"noopener\">3. \u00e1bra<\/a>.<\/li>\n<li>Jel\u00f6lj\u00fck ki az A1:G25 tartom\u00e1nyt!<\/li>\n<li>A tartom\u00e1nyt nyomtat\u00e1si ter\u00fcletk\u00e9nt a <strong>Lapelrendez\u00e9s \/ Nyomtat\u00e1si ter\u00fclet \/ Nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se <\/strong><em>(Alt+P, I, K)<\/em> paranccsal tudjuk kijel\u00f6lni.<\/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>\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-c696fd6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c696fd6\" 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-5354b2d\" data-id=\"5354b2d\" 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-3df7ff7 elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"3df7ff7\" 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-0449d35 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0449d35\" 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-7623398\" data-id=\"7623398\" 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-0d5dc8c elementor-widget elementor-widget-text-editor\" data-id=\"0d5dc8c\" 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=\"67\">\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-83b0655 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"83b0655\" 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-844cf48\" data-id=\"844cf48\" 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-4d66aa0 elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"4d66aa0\" 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-81cd543 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"81cd543\" 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-103697f\" data-id=\"103697f\" 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-6eaf861 elementor-widget elementor-widget-text-editor\" data-id=\"6eaf861\" 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=\"69\">\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\/191-K-ECDLM04S6-Vizsgafeladat8_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-64bf9ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64bf9ac\" 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-4114d4e\" data-id=\"4114d4e\" 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-c66006e elementor-widget elementor-widget-text-editor\" data-id=\"c66006e\" 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 munka- \u00e9s egy diagramlappal, valamint egy PDF dokumentumot <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/191-K-ECDLM04S6-Vizsgafeladat8_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-f5685b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5685b0\" 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-f18dae4\" data-id=\"f18dae4\" 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-2f47d0b elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"2f47d0b\" 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-9bb91ff elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9bb91ff\" 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-cb4f61f\" data-id=\"cb4f61f\" 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-560d0ae elementor-widget elementor-widget-text-editor\" data-id=\"560d0ae\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 \u00e1prilis 6.<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<\/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-df3e1a9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"df3e1a9\" 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-17412ff\" data-id=\"17412ff\" 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-b00c19b elementor-widget elementor-widget-shortcode\" data-id=\"b00c19b\" 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--2825 \"        data-post-id=\"2825\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-2825\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-2825\">                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-e49bacb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e49bacb\" 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-90b0b92\" data-id=\"90b0b92\" 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-4da377f 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=\"4da377f\" 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 23. 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 8. 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=2825\">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-2825","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2825","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=2825"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2825\/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=2825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}