{"id":5633,"date":"2020-07-06T10:08:23","date_gmt":"2020-07-06T08:08:23","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=5633"},"modified":"2022-08-07T19:12:22","modified_gmt":"2022-08-07T17:12:22","slug":"ecdl-tablazatkezeles-29-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=5633","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 29. vizsgafeladat (#235\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"5633\" class=\"elementor elementor-5633\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-515b89d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"515b89d\" 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-8cf5533\" data-id=\"8cf5533\" 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-24604f6 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"24604f6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0Friss\u00edtve: 2022 j\u00falius 31.<br \/><\/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-7f46db2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f46db2\" 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-cf71c54\" data-id=\"cf71c54\" 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-d408600 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"d408600\" 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-6795277 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6795277\" 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-7b3fac7\" data-id=\"7b3fac7\" 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-28d3fef elementor-widget elementor-widget-text-editor\" data-id=\"28d3fef\" 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 29. 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-9c09086 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9c09086\" 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-fe042e2\" data-id=\"fe042e2\" 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-3690d6a elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"3690d6a\" 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__3690d6a\" 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__3690d6a\" 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__3690d6a\" 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-8b8b235 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b8b235\" 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-5ac7eb7\" data-id=\"5ac7eb7\" 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-9f8ffc4 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"9f8ffc4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>Felhaszn\u00e1lt forr\u00e1sok:<\/strong><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/hu\/ecdl\/modul\/tablazatkezeles\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A T\u00e1bl\u00e1zatkezel\u00e9s modul tartalma az NJSzT oldal\u00e1n.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 febru\u00e1r 1-t\u0151l \u00e9rv\u00e9nyes T\u00e1bl\u00e1zatkezel\u00e9s Syllabus 6 (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 m\u00e1rcius 1-t\u0151l \u00e9rv\u00e9nyes ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A feladatokhoz tartoz\u00f3 munkaf\u00fczetek t\u00f6m\u00f6r\u00edtv\u00e9nye (ZIP f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/07\/235-K-ECDLM04S6-Vizsgafeladat29.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 29. 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-fda65d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fda65d0\" 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-e77f581\" data-id=\"e77f581\" 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-664c735 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"664c735\" 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-0f658c0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f658c0\" 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-30fe846\" data-id=\"30fe846\" 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-fbfc6d6 elementor-widget elementor-widget-text-editor\" data-id=\"fbfc6d6\" 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\/07\/235-K-ECDLM04S6-Vizsgafeladat29.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-258be98 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"258be98\" 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-e2a2b89\" data-id=\"e2a2b89\" 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-dd88825 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"dd88825\" 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\u00e9s \u00e9s form\u00e1z\u00e1s, export\u00e1l\u00e1s PDF form\u00e1tumban, k\u00e9plet sokszoros\u00edt\u00e1sa, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, nyomtat\u00e1s, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, oszlopok \u00e9s sorok kezel\u00e9se, rel\u00e1ci\u00f3s oper\u00e1torok, sorba rendez\u00e9s, t\u00e1bl\u00e1zat form\u00e1z\u00e1s, tartom\u00e1nyok kijel\u00f6l\u00e9se, weblap k\u00f6zz\u00e9t\u00e9tel.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek: <\/strong><a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, DARABTELI, SZ\u00d6VEG, SZUM.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8953e7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8953e7d\" 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-749fa63\" data-id=\"749fa63\" 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-6ec914e elementor-widget elementor-widget-text-editor\" data-id=\"6ec914e\" 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-47c91db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"47c91db\" 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-71354d6\" data-id=\"71354d6\" 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-8fc1e60 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"8fc1e60\" 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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-26300\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 29. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat \u00e9s a csoportos\u00edtott oszlopdiagram.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat \u00e9s a 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-277bc63 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"277bc63\" 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-f903a44\" data-id=\"f903a44\" 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-91a4ae6 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"91a4ae6\" 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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2.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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-1024x576.jpg\" class=\"attachment-large size-large wp-image-26301\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 29. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A weblap k\u00f6zz\u00e9t\u00e9telre v\u00e1rakoz\u00f3 t\u00e1bl\u00e1zatr\u00e9szlet a Munka1 munkalapon.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_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\">2. \u00e1bra: A weblap k\u00f6zz\u00e9t\u00e9telre v\u00e1rakoz\u00f3 t\u00e1bl\u00e1zatr\u00e9szlet 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-2286b7b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2286b7b\" 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-4c8a2fe\" data-id=\"4c8a2fe\" 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-28dc180 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"28dc180\" 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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML.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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-1024x576.jpg\" class=\"attachment-large size-large wp-image-26302\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 29. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A t\u00e1bl\u00e1zatr\u00e9szlet HTML oldalk\u00e9nt a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">3. \u00e1bra: A t\u00e1bl\u00e1zatr\u00e9szlet HTML oldalk\u00e9nt 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-e134dd4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e134dd4\" 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-81f67bd\" data-id=\"81f67bd\" 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-66de9ce elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"66de9ce\" 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\/235-K-ECDLM04S6-Vizsgafeladat29_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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-26303\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 29. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">4. \u00e1bra: Az export\u00e1lt PDF dokumentum a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-18b0686 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"18b0686\" 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-922f85a\" data-id=\"922f85a\" 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-887e602 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"887e602\" 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\/235-K-ECDLM04S6-Vizsgafeladat29_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\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-26304\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 29. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 3 db f\u00e1jl a Dokumentumok mapp\u00e1ban.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8795785 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8795785\" 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-70bd8fe\" data-id=\"70bd8fe\" 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-da4d6ec elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"da4d6ec\" 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-4ad9b4c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ad9b4c\" 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-a8d9060\" data-id=\"a8d9060\" 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-291addd elementor-widget elementor-widget-text-editor\" data-id=\"291addd\" 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-0e5bec7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0e5bec7\" 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-8e51754\" data-id=\"8e51754\" 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-796fce1 elementor-widget elementor-widget-text-editor\" data-id=\"796fce1\" 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-29.xlsx munkaf\u00fczetet!<\/li>\n<li>Nyomjuk le az <em>F12<\/em> funkci\u00f3billenty\u0171t a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li>\n<li>G\u00e9pelj\u00fck be a <strong>F\u00e1jln\u00e9v<\/strong> <em>(Alt+N)<\/em> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> <em>(Alt+S)<\/em> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b7dac61 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b7dac61\" 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-24bc5cb\" data-id=\"24bc5cb\" 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-77e2a68 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"77e2a68\" 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-d2d7843 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2d7843\" 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-16ed067\" data-id=\"16ed067\" 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-beb302d elementor-widget elementor-widget-text-editor\" data-id=\"beb302d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"4\">\n<li>Els\u0151 teend\u0151nk, hogy megismerkedj\u00fcnk a munkaf\u00fczettel. Az M4-29 munkalap A1:E26 tartom\u00e1ny\u00e1ban a vil\u00e1g 25 legmagasabb hegycs\u00facs\u00e1nak nev\u00e9t, magass\u00e1g\u00e1t, helyez\u00e9s\u00e9t \u00e9s hely\u00e9t tal\u00e1ljuk. A Helyez\u00e9s (A) oszlop sz\u00f6veg form\u00e1tumban a magass\u00e1g szerinti sorrendet, a Hegycs\u00facs (B) oszlop a hegycs\u00facsok neveit, a C oszlop m\u00e9terben a hegycs\u00facsok tengerszint feletti magass\u00e1g\u00e1t mutatja. A\u00a0D oszlop \u00fcres, angolsz\u00e1sz l\u00e1bban v\u00e1rja a hegycs\u00facsok magass\u00e1g\u00e1t, amit majd nek\u00fcnk kell kisz\u00e1molni. Az utols\u00f3, E oszlopban a hegycs\u00facs orsz\u00e1g\u00e1t tal\u00e1ljuk. Az oszlopc\u00edmk\u00e9ket az A1:E1, az adatokat az A2:E26 tartom\u00e1ny tartalmazza.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e8f56dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e8f56dc\" 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-68a0d92\" data-id=\"68a0d92\" 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-ab6028c elementor-widget elementor-widget-text-editor\" data-id=\"ab6028c\" 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 l\u00e1b (foot) angolsz\u00e1sz eredet\u0171 hossz- \u00e9s magass\u00e1g m\u00e9rt\u00e9kegys\u00e9g. Jel\u00f6l\u00e9s\u00e9re az Ft vagy az \u2019 (aposztr\u00f3f, <i>Shift+1<\/i>) jelet haszn\u00e1lj\u00e1k. Els\u0151sorban az US\u00c1-ban \u00e9s az Egyes\u00fclt Kir\u00e1lys\u00e1gban haszn\u00e1latos, illetve sz\u00e1mos volt angol gyarmati ter\u00fcleten, ahol a metrikus rendszer m\u00e1ig nem tudott gy\u00f6keret verni.<br \/>A l\u00e1b defin\u00edci\u00f3j\u00e1t utolj\u00e1ra 1959-ben, az USA \u00e9s a Brit Nemzetk\u00f6z\u00f6ss\u00e9g k\u00f6z\u00f6tt k\u00f6ttetett Nemzetk\u00f6zi yard \u00e9s font egyezm\u00e9ny (International Yard and Pound Agreement) alapj\u00e1n defini\u00e1lt\u00e1k \u2013 \u00e9rdekes m\u00f3don a metrikus rendszerb\u0151l levezetve.<br \/><strong>Eszerint ma 1 l\u00e1b = 0,3048 m\u00e9ter (1 \u2019 = 0,3048 m), illetve 1 m\u00e9ter = 3,2808 l\u00e1b (1 m = 3,2808 Ft). A feladatban ennek ezredre kerek\u00edtett \u00e9rt\u00e9k\u00e9t, a 3,281-et haszn\u00e1ljuk.<\/strong><br \/>A Windows 10 oper\u00e1ci\u00f3s rendszer jelenlegi kiad\u00e1s\u00e1ban a Sz\u00e1mol\u00f3g\u00e9p seg\u00edts\u00e9g\u00e9vel tudunk \u00e1tv\u00e1ltani a metrikus \u00e9s az angolsz\u00e1sz eredet\u0171 m\u00e9rt\u00e9kegys\u00e9grendszer, \u00edgy a m\u00e9ter \u00e9s a l\u00e1b k\u00f6z\u00f6tt.<\/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-8905ef0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8905ef0\" 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-8cd1b9d\" data-id=\"8cd1b9d\" 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-268db1d elementor-widget elementor-widget-text-editor\" data-id=\"268db1d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"5\">\n<li>Els\u0151 feladatunk a D oszlop hi\u00e1nyz\u00f3 adatainak p\u00f3tl\u00e1sa. A D2:D26 tartom\u00e1nyban a C oszlopban m\u00e9terben megadott magass\u00e1got kell \u00e1tv\u00e1ltanunk l\u00e1bba. Jel\u00f6lj\u00fck ki a D2:D26 tartom\u00e1nyt!<\/li>\n<li>G\u00e9pelj\u00fck be a D2 cell\u00e1ba az <strong>=C2*3,281<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1b311c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b311c2\" 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-049c612\" data-id=\"049c612\" 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-be71707 elementor-widget elementor-widget-global elementor-global-16844 elementor-widget-text-editor\" data-id=\"be71707\" 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-21e83a2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21e83a2\" 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-a36184b\" data-id=\"a36184b\" 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-9a24288 elementor-widget elementor-widget-text-editor\" data-id=\"9a24288\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"7\">\n<li>A t\u00e1bl\u00e1zat sorait az egyik magass\u00e1g oszlop tartalma alapj\u00e1n emelked\u0151 sorba kell rendezn\u00fcnk. \u00dcss\u00fck le a <em>Ctrl+T<\/em> billenty\u0171kombin\u00e1ci\u00f3t az eg\u00e9sz t\u00e1bl\u00e1zat (A1:E26) kijel\u00f6l\u00e9s\u00e9hez!<\/li>\n<li>Mivel az akt\u00edv cella a tartom\u00e1nyban az A1 cell\u00e1n \u00e1ll, \u00fcss\u00fck le k\u00e9tszer a <em>Tab<\/em> billenty\u0171t, hogy \u00e1tker\u00fclj\u00f6n a C1 cell\u00e1ra. Ezzel kijel\u00f6lt\u00fck a rendez\u00e9s alapj\u00e1ul szolg\u00e1l\u00f3 oszlopot.<\/li>\n<li>Adjuk ki az <strong>Adatok \/ Rendez\u00e9s m\u00e9ret szerint (n\u00f6vekv\u0151)<\/strong> <em>(Alt+G, N)<\/em> parancsot! A rendez\u00e9shez haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s m\u00e9ret szerint (n\u00f6vekv\u0151)<\/strong> <em>(Alt+\u0150, \u00da, E)<\/em> vagy a helyi men\u00fc <strong>Rendez\u00e9s \/ Rendez\u00e9s m\u00e9ret szerint (n\u00f6vekv\u0151)<\/strong> <em>(Shift+F10, D, Enter)<\/em> parancsokat is.<\/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-11a9eda elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"11a9eda\" 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-2dee919\" data-id=\"2dee919\" 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-f13bfb1 elementor-widget elementor-widget-global elementor-global-17117 elementor-widget-text-editor\" data-id=\"f13bfb1\" 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 \/>Tipikus feladat feliratokat \u00e9s\/vagy sz\u00e1m\u00edt\u00e1sokat tartalmaz\u00f3 t\u00e1bl\u00e1zatok adatsorainak rendez\u00e9se egy vagy t\u00f6bb oszlop szerint. Sokan elfelejtik a rendez\u00e9s el\u0151tt a megfelel\u0151 sorokat kijel\u00f6lni, teljesen \u00f6sszekeverve a sorokat. Ha azonnal lenyomjuk a <i>Ctrl+Z<\/i> billenty\u0171kombin\u00e1ci\u00f3t, meg nem t\u00f6rt\u00e9ntt\u00e9 tehetj\u00fck t\u00e9ved\u00e9s\u00fcnket, \u00e9s gyorsan elolvashatjuk a k\u00f6vetkez\u0151 bekezd\u00e9st, mit is kell ilyenkor tenn\u00fcnk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1a098a4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a098a4\" 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-ab40fa2\" data-id=\"ab40fa2\" 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-33c85cc elementor-widget elementor-widget-global elementor-global-17149 elementor-widget-text-editor\" data-id=\"33c85cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Ha egy t\u00e1bl\u00e1zat sorait rendezn\u00fcnk kell az egyik oszlop alapj\u00e1n, akkor csak a rendezni k\u00edv\u00e1nt adatokat tartalmaz\u00f3 tartom\u00e1nyt szabad kijel\u00f6ln\u00fcnk \u2013 ki kell hagynunk a k\u00e9pleteket, oszlopc\u00edmk\u00e9ket \u00e9s egy\u00e9b sz\u00e1rmaztatott adatokat tartalmaz\u00f3 cell\u00e1kat. Ezt szem el\u0151tt tartva, egy \u00f6sszef\u00fcgg\u0151 tartom\u00e1nyt fogunk kijel\u00f6lni.<br \/>Ha egy oszlop szerint kell rendezn\u00fcnk a sorokat, akkor a <i>Tab<\/i> billenty\u0171vel l\u00e9ptess\u00fck a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1t abba az oszlopba, amely szerint rendezni akarunk. Ezt k\u00f6vet\u0151en m\u00e1r haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s<\/strong> <i>(Alt+\u0150, \u00da)<\/i> men\u00fc vagy az <strong>Adatok \/Rendez\u00e9s \u00e9s sz\u0171r\u00e9s<\/strong><strong> csoport parancsait. Ha a helyi men\u00fct r\u00e9szes\u00edtj\u00fck el\u0151nyben, akkor a <i>Shift+F10<\/i> lenyom\u00e1s\u00e1t k\u00f6vet\u0151en a <\/strong><strong>Rendez\u00e9s<\/strong> almen\u00fc parancsaib\u00f3l v\u00e1logathatunk.<br \/>Ha t\u00f6bb oszlop szerint kell rendezn\u00fcnk, akkor m\u00e1r sz\u00fcks\u00e9g\u00fcnk lesz a <strong>Rendez\u00e9s<\/strong> (<i>Alt+\u0150, \u00da, E<\/i> vagy <i>Alt+G, R<\/i> vagy <i>Shift+F10, D, E<\/i>) p\u00e1rbesz\u00e9dablakra.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f80828b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f80828b\" 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-60d43e4\" data-id=\"60d43e4\" 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-afab60b elementor-widget elementor-widget-text-editor\" data-id=\"afab60b\" 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 C27 cell\u00e1ban az oszlop \u00e9rt\u00e9keinek \u00e1tlag\u00e1t kell kisz\u00e1molnunk. Helyezz\u00fck az akt\u00edv cell\u00e1t a C27-re!<\/li>\n<li>Adjuk ki a <strong>Kezd\u0151lap \/ AutoSzum \/ \u00c1tlag <\/strong><em>(Alt+\u0150, D, L)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t a felk\u00edn\u00e1lt k\u00e9plet elfogad\u00e1s\u00e1hoz!<\/li>\n<li>Az F oszlopban azt kell kisz\u00e1molnunk, hogy az egyes hegycs\u00facsok magass\u00e1ga mennyiben t\u00e9r el az \u00e1tlagt\u00f3l. A megold\u00e1s egyszer\u0171, a hegycs\u00facs \u00e9rt\u00e9k\u00e9b\u0151l ki kell vonnunk az \u00e1tlag \u00e9rt\u00e9k\u00e9t. Ha pozit\u00edv sz\u00e1mot kapuk eredm\u00e9ny\u00fcl, akkor a hegycs\u00facs magasabb az \u00e1tlagn\u00e1l, a negat\u00edv \u00e9rt\u00e9k pedig az \u00e1tlagn\u00e1l alacsonyabb hegycs\u00facsot jelenti. Az \u00e1tlag a C27 cell\u00e1ban tal\u00e1lhat\u00f3, \u00e9s abszol\u00fat c\u00edmz\u00e9ssel fogunk hivatkozni r\u00e1, mivel a k\u00e9pletet sokszoros\u00edtanunk kell. Az F2-be teh\u00e1t a k\u00f6vetkez\u0151 k\u00e9pletet helyezz\u00fck majd: <strong>=C2-$C$27<\/strong><\/li>\n<li>Az F1 cell\u00e1ba g\u00e9pelj\u00fck be az elt\u00e9r\u00e9s az \u00e1tlagt\u00f3l c\u00edmk\u00e9t! Jel\u00f6lj\u00fck ki az F2:F26 tartom\u00e1nyt, majd az F2 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=C2-$C$27<\/strong> k\u00e9pletet, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-985f738 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"985f738\" 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-4cb88ce\" data-id=\"4cb88ce\" 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-1a02f08 elementor-widget elementor-widget-text-editor\" data-id=\"1a02f08\" 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 C27 beg\u00e9pel\u00e9se ut\u00e1n r\u00f6gt\u00f6n \u00fcss\u00fck le az <i>F4<\/i> funkci\u00f3billenty\u0171t! Ennek hat\u00e1s\u00e1ra a C27-b\u0151l $C$27 lesz. Az <i>F4<\/i> funkci\u00f3billenty\u0171 ism\u00e9telt le\u00fct\u00e9s\u00e9vel a kijel\u00f6lt hivatkoz\u00e1s t\u00edpus\u00e1t tudjuk m\u00f3dos\u00edtani a k\u00f6vetkez\u0151 sorrendben: C27 \u2192 $C$27 \u2192 C$27 \u2192 $C27 \u2192 C27.<\/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-6e92067 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e92067\" 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-ec50966\" data-id=\"ec50966\" 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-1090f52 elementor-widget elementor-widget-text-editor\" data-id=\"1090f52\" 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 C$27 haszn\u00e1lata, mivel a k\u00e9plet lefel\u00e9 m\u00e1sol\u00e1sa sor\u00e1n az oszlop nem, csak a sorsz\u00e1m 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-551bc03 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"551bc03\" 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-7404730\" data-id=\"7404730\" 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-d1b373a elementor-widget elementor-widget-text-editor\" data-id=\"d1b373a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"14\">\n<li>Mivel n\u00e9h\u00e1ny cella d\u00e1tum form\u00e1tum\u00fa, t\u00f6r\u00f6lj\u00fck a form\u00e1tumjegyeket a kijel\u00f6lve hagyott tartom\u00e1nyban a <strong>Kezd\u0151lap \/ T\u00f6rl\u00e9s \/ Form\u00e1tum t\u00f6rl\u00e9se <\/strong><em>(Alt+\u0150, R\u00d6, F)<\/em> parancs kiad\u00e1s\u00e1val!<\/li>\n<li>Jel\u00f6lj\u00fck ki a C2:C27 tartom\u00e1nyt, majd \u00fcss\u00fck le a <em>Ctrl+Shift+1<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<li>A tizedeshelyeket t\u00f6rl\u00e9s\u00e9hez adjuk ki k\u00e9tszer egym\u00e1s ut\u00e1n a <strong>Kezd\u0151lap \/ Tizedeshelyek cs\u00f6kkent\u00e9se <\/strong><em>(Alt+\u0150, 9)<\/em> parancsot!<\/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-b22bc8e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b22bc8e\" 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-c4a605a\" data-id=\"c4a605a\" 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-8bce27d elementor-widget elementor-widget-global elementor-global-17120 elementor-widget-text-editor\" data-id=\"8bce27d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> N\u00e9h\u00e1ny <strong>Sz\u00e1mform\u00e1tumot<\/strong> a k\u00f6vetkez\u0151 billenty\u0171kombin\u00e1ci\u00f3kkal tudunk gyorsan \u00e9s k\u00e9nyelmesen alkalmazni: <i>Ctrl+Shift+1<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> k\u00e9t tizedesjeggyel \u00e9s ezres tagol\u00e1ssal, <i>Ctrl+Shift+2<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> a cell\u00e1ban tal\u00e1lhat\u00f3 egyn\u00e9l kisebb tizedes t\u00f6rtet tartalmaz\u00f3 \u00e9rt\u00e9k \u00f3ra:perc form\u00e1tumra alak\u00edt\u00e1s\u00e1val, <i>Ctrl+Shift+3<\/i> \u2013 form\u00e1z\u00e1s <strong>Egy\u00e9ni Sz\u00e1mform\u00e1tumra<\/strong> a cell\u00e1ban tal\u00e1lhat\u00f3 \u00e9rt\u00e9k nn.hhh.\u00e9\u00e9 form\u00e1tumra alak\u00edt\u00e1s\u00e1val, <i>Ctrl+Shift+4<\/i> \u2013 form\u00e1z\u00e1s <strong>P\u00e9nznem Sz\u00e1mform\u00e1tumra<\/strong> k\u00e9t tizedesjeggyel \u00e9s ezres tagol\u00e1ssal (negat\u00edv \u00e9rt\u00e9k eset\u00e9n piros bet\u0171sz\u00ednnel), <i>Ctrl+Shift+5<\/i> \u2013 form\u00e1z\u00e1s <strong>Sz\u00e1zal\u00e9k Sz\u00e1mform\u00e1tumra<\/strong> tizedesjegyek n\u00e9lk\u00fcl eg\u00e9szre kerek\u00edt\u00e9ssel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-abed586 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"abed586\" 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-086d148\" data-id=\"086d148\" 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-b93fe83 elementor-widget elementor-widget-text-editor\" data-id=\"b93fe83\" 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>K\u00f6vetkezik a B oszlop form\u00e1z\u00e1sa! Jel\u00f6lj\u00fck ki a B2:B26 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>\u00c1ll\u00edtsuk be a <strong>K\u00e9k <\/strong>bet\u0171sz\u00ednt a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel! A paletta <strong>Alapsz\u00ednek <\/strong>r\u00e9sz\u00e9ben a nyolcadik a <strong>K\u00e9k <\/strong>sz\u00edn, amit a <em>ny\u00edlbillenty\u0171kkel<\/em> l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li>\n<li>A k\u00f6vetkez\u0151 feladat az E oszlop \u00e1thelyez\u00e9se a B:C oszlopok k\u00f6z\u00e9. Helyezz\u00fck az akt\u00edv cell\u00e1t az E1 cell\u00e1ra, majd \u00fcss\u00fck le a <em>Ctrl+Sz\u00f3k\u00f6z<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5f04ebd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f04ebd\" 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-8ab4b79\" data-id=\"8ab4b79\" 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-1b75875 elementor-widget elementor-widget-global elementor-global-17146 elementor-widget-text-editor\" data-id=\"1b75875\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Az akt\u00edv cella sor\u00e1nak kijel\u00f6l\u00e9s\u00e9re a <i>Shift+Sz\u00f3k\u00f6z<\/i>, oszlop\u00e1nak kijel\u00f6l\u00e9s\u00e9re a <i>Ctrl+Sz\u00f3k\u00f6z<\/i> haszn\u00e1lhat\u00f3. Ha t\u00f6bb sort\/oszlopot akarunk kijel\u00f6lni, akkor a szok\u00e1sos <i>Shift+ny\u00edlbillenty\u0171k<\/i> kijel\u00f6l\u00e9s kiterjeszt\u00e9ssel \u00e9lhet\u00fcnk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4389fb3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4389fb3\" 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-7e6ea7a\" data-id=\"7e6ea7a\" 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-08bce9d elementor-widget elementor-widget-text-editor\" data-id=\"08bce9d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"21\">\n<li>\u00dcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t az oszlop V\u00e1g\u00f3lapra helyez\u00e9s\u00e9hez!<\/li>\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t a C1 cell\u00e1ra!<\/li>\n<li>Jelen\u00edts\u00fck meg a helyi men\u00fct a <em>Shift+F10<\/em> billenty\u0171kombin\u00e1ci\u00f3val, majd v\u00e1lasszuk ki a <strong>Kiv\u00e1gott cell\u00e1k besz\u00far\u00e1sa<\/strong> <em>(K)<\/em> parancsot!<\/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-66c7bbb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"66c7bbb\" 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-478243a\" data-id=\"478243a\" 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-e0391e8 elementor-widget elementor-widget-text-editor\" data-id=\"e0391e8\" 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\u00f6vetkez\u0151 feladat, hogy weblapk\u00e9nt (HTML f\u00e1jlform\u00e1tum, *.htm vagy *.html f\u00e1jlkiterjeszt\u00e9s) k\u00e9sz\u00edts\u00fcnk ment\u00e9st a t\u00e1bl\u00e1zat B, D, E oszlopair\u00f3l. Az Excel a weblap form\u00e1tumban ment\u00e9st <strong>k\u00f6zz\u00e9t\u00e9telnek<\/strong> h\u00edvja. Ehhez kapunk egy <strong>K\u00f6zz\u00e9t\u00e9tel weblapk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dpanelt, amelyben \u2013 t\u00f6bbek k\u00f6z\u00f6tt \u2013 el\u0151\u00edrhatjuk, hogy a munkaf\u00fczet mely r\u00e9sz\u00e9b\u0151l akarunk weblapot k\u00e9sz\u00edteni: ez lehet a teljes munkaf\u00fczet, egy kiv\u00e1lasztott munkalap, vagy kijel\u00f6lt tartom\u00e1ny. S\u0151t, am\u00edg dolgozunk a munkaf\u00fczettel, megjegyzi \u00e9s v\u00e1laszt\u00e1sra k\u00edn\u00e1lja fel a kor\u00e1bban mentett weblapokat is.<br \/><strong>Fontos felt\u00e9tel, hogy cellatartom\u00e1ny k\u00f6zz\u00e9t\u00e9tele eset\u00e9n annak folytonosnak kell lennie<\/strong>, teh\u00e1t nem tartalmazhat rejtett cell\u00e1kat, sorokat, oszlopokat, nem adhatunk meg t\u00f6bb tartom\u00e1nyt. Ennek k\u00f6vetkezt\u00e9ben el\u0151fordulhat, hogy k\u00f6zz\u00e9t\u00e9tel el\u0151tt egy \u00faj munkalapra, vagy a munkalap egy m\u00e1sik r\u00e9sz\u00e9re kell kigy\u0171jten\u00fcnk a nem szomsz\u00e9dos tartom\u00e1nyokat, egy \u00f6sszef\u00fcgg\u0151 tartom\u00e1nyt alkotva bel\u0151l\u00fck.<br \/>A mostani feladat ilyen, a B, D, E oszlopokr\u00f3l el\u0151sz\u00f6r m\u00e1solatot kell k\u00e9sz\u00edten\u00fcnk egy \u00faj munkalapra.<\/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-0f55868 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f55868\" 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-e88bb77\" data-id=\"e88bb77\" 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-8400fea elementor-widget elementor-widget-text-editor\" data-id=\"8400fea\" 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>\u00dcss\u00fck le az <em>F5<\/em> funkci\u00f3billenty\u0171t, \u00e9s a k\u00e9perny\u0151n megjelen\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151j\u00e9be g\u00e9pelj\u00fck be a B1:B26;D1:E26 tartom\u00e1nyc\u00edmeket, 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-430e8ba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"430e8ba\" 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-e4cabb5\" data-id=\"e4cabb5\" 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-18f8bad elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"18f8bad\" 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-9adaaf9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9adaaf9\" 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-2adc081\" data-id=\"2adc081\" 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-45d03ff elementor-widget elementor-widget-text-editor\" data-id=\"45d03ff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"25\">\n<li>K\u00e9sz\u00edts\u00fcnk m\u00e1solatot a tartom\u00e1nyokr\u00f3l a V\u00e1g\u00f3lapra a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>K\u00e9sz\u00edts\u00fcnk egy \u00faj munkalapot: \u00fcss\u00fck le a <em>Shift+F11<\/em> billenty\u0171kombin\u00e1ci\u00f3t vagy adjuk ki a <strong>Kezd\u0151lap \/ Besz\u00far\u00e1s \/ Munkalap besz\u00far\u00e1sa <\/strong><em>(Alt+\u0150, BB, B)<\/em> parancsot! A Munka1 munkalap az M4-29 munkalap el\u0151tt, att\u00f3l balra j\u00f6n l\u00e9tre.<\/li>\n<li>Illessz\u00fck be a V\u00e1g\u00f3lap tartalm\u00e1t az A1 cell\u00e1ba a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>N\u00f6velj\u00fck meg az oszlopok sz\u00e9less\u00e9g\u00e9t a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, U)<\/em> paranccsal, \u00edgy minden oszlop tartalma l\u00e1that\u00f3 lesz (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_2_Tablazat2.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"2. \u00e1bra (opens in a new tab)\">2. \u00e1bra<\/a>)!<\/li>\n<li>\u00dcss\u00fck le az <em>F12<\/em> funkci\u00f3billenty\u0171t! A k\u00e9perny\u0151n megjelenik a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak. A f\u00f3kusz a <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151n \u00e1ll, amelyben a munkaf\u00fczet nev\u00e9t l\u00e1tjuk \u2013 ezt el is fogadhatjuk. Ha a vizsg\u00e1n megadj\u00e1k a nevet \u00e9s a mapp\u00e1t, akkor \u00e1ll\u00edtsuk be ezeket!<\/li>\n<li>L\u00e9pj\u00fcnk tov\u00e1bb a <em>Tab<\/em> seg\u00edts\u00e9g\u00e9vel a <strong>F\u00e1jl t\u00edpusa<\/strong> kombin\u00e1lt listamez\u0151re!<\/li>\n<li>Jel\u00f6lj\u00fck ki a <strong>Weblap (*.htm;*.html) <\/strong>elemet, p\u00e9ld\u00e1ul a <em>W<\/em> billenty\u0171 le\u00fct\u00e9s\u00e9vel!<\/li>\n<li>L\u00e9pj\u00fcnk tov\u00e1bb a <em>Tab<\/em> billenty\u0171vel a <strong>Ment\u00e9s<\/strong> opci\u00f3ig, amelyn\u00e9l a <strong>Teljes munkaf\u00fczet<\/strong> v\u00e1laszt\u00f3gomb van kijel\u00f6lve. Nek\u00fcnk <strong>A kijel\u00f6lt: $A$1:$C$26<\/strong> nev\u0171re van sz\u00fcks\u00e9g\u00fcnk, amellyel a kijel\u00f6lt tartom\u00e1ny ment\u00e9s\u00e9t tudjuk el\u0151\u00edrni: v\u00e1lasszuk ki a <em>Le ny\u00edlbillenty\u0171vel<\/em>!<\/li>\n<li>Megadtunk minden sz\u00fcks\u00e9ges adatot, \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel weblapk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak. A f\u00f3kusz a\u00a0<strong>V\u00e1laszt\u00e1s<\/strong> kombin\u00e1lt listamez\u0151n van, amelyben a <strong>Cellatartom\u00e1ny <\/strong>elem a kijel\u00f6lt. Az alatta elhelyezked\u0151 list\u00e1ban pedig ott tal\u00e1ljuk az <strong>=&#8217;Munka1&#8242;!$A$1:$C$26<\/strong> tartom\u00e1nyhivatkoz\u00e1st.<\/li>\n<li>Ha a k\u00f6zz\u00e9t\u00e9telt k\u00f6vet\u0151en azonnal meg akarjuk jelen\u00edteni a weboldalt egy b\u00f6ng\u00e9sz\u0151ben, akkor keress\u00fck meg <strong>A weblap megnyit\u00e1sa a b\u00f6ng\u00e9sz\u0151vel<\/strong> <em>(Alt+W)<\/em> jel\u00f6l\u0151n\u00e9gyzetet, \u00e9s kapcsoljuk be. Mi is ezt tessz\u00fck, hogy l\u00e1ssuk, bemutathassuk az eredm\u00e9nyt.<\/li>\n<li>\u00dcss\u00fck le az <em>Enter<\/em> billenty\u0171t vagy v\u00e1lasszuk ki a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> <em>(Alt+K)<\/em> gombot!<\/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-2c21a53 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c21a53\" 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-a041e24\" data-id=\"a041e24\" 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-d1f6252 elementor-widget elementor-widget-text-editor\" data-id=\"d1f6252\" 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 b\u00f6ng\u00e9sz\u0151ben, vagy el\u0151tte r\u00e1k\u00e9rdez a Windows, hogy melyik b\u00f6ng\u00e9sz\u0151 alkalmaz\u00e1ssal akarjuk azt megnyitni. Ut\u00f3bbi esetben \u2013 ha m\u00e1s b\u00f6ng\u00e9sz\u0151 nincs telep\u00edtve \u2013, a Microsoft Edge b\u00f6ng\u00e9sz\u0151t k\u00edn\u00e1lja fel, amit egy Enter 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-5665b01 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5665b01\" 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-9cb290a\" data-id=\"9cb290a\" 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-2cfac44 elementor-widget elementor-widget-text-editor\" data-id=\"2cfac44\" 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=\"37\">\n<li>A k\u00e9sz weblapot mutatja a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_3_HTML.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"3. \u00e1bra (opens in a new tab)\">3. \u00e1bra<\/a>. Z\u00e1rjuk be a b\u00f6ng\u00e9sz\u0151 ablak\u00e1t az <em>Alt+F4<\/em> billenty\u0171kombin\u00e1ci\u00f3val, majd t\u00e9rj\u00fcnk vissza az M4-29 munkalaphoz!<\/li>\n<li>A K1 cell\u00e1ban a 8000 m feletti cs\u00facsok sz\u00e1m\u00e1t kell megjelen\u00edten\u00fcnk. Felt\u00e9teles darabsz\u00e1ml\u00e1l\u00e1sra van sz\u00fcks\u00e9g\u00fcnk, amire a DARABTELI f\u00fcggv\u00e9ny a megold\u00e1s. A\u00a0m\u00e9terben megadott magass\u00e1gokat a D2:D26 tartom\u00e1nyban tal\u00e1ljuk, a felt\u00e9tel pedig ez lesz: &#8222;&gt;8000&#8221;. A K1 cell\u00e1ba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=DARABTELI(D2:D26;&#8221;&gt;8000&#8243;)<\/strong>. Eredm\u00e9ny\u00fcl 13-at kell kapnunk.<\/li>\n<li>A csoportos\u00edtott oszlopdiagramon \u00e1br\u00e1zolni k\u00edv\u00e1nt adatokat egy k\u00fcl\u00f6n t\u00e1bl\u00e1zatban kell r\u00f6gz\u00edten\u00fcnk, amely 3 \u00fcres sort is tartalmaz. K\u00e9sz\u00edts\u00fck el ezt a t\u00e1bl\u00e1zatot! G\u00e9pelj\u00fck be a K39 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Kiszerel\u00e9s<\/li>\n<li>G\u00e9pelj\u00fck be a J40:L40 cell\u00e1kba a k\u00f6vetkez\u0151ket: Term\u00e9k, 100, 200<\/li>\n<li>G\u00e9pelj\u00fck be a J41:L41 cell\u00e1kba a k\u00f6vetkez\u0151ket: A, 1, 2<\/li>\n<li>G\u00e9pelj\u00fck be a J45:L45 cell\u00e1kba a k\u00f6vetkez\u0151ket: B, 1, 2<\/li>\n<li>G\u00e9pelj\u00fck be a J46:L46 cell\u00e1kba a k\u00f6vetkez\u0151ket: C, 1, 1<\/li>\n<li>G\u00e9pelj\u00fck be a J47:L47 cell\u00e1kba a k\u00f6vetkez\u0151ket: D, 1, 2<\/li>\n<li>G\u00e9pelj\u00fck be a J48 cell\u00e1ba a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00d6sszesen<\/li>\n<li>Rejts\u00fck el az \u00fcresen hagyott sorokat! Az <em>F5<\/em> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki a 42:44 sorokat!<\/li>\n<li>Adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Elrejt\u00e9s \u00e9s felfed\u00e9s \/ Sorok elrejt\u00e9se <\/strong><em>(Alt+\u0150, FF, D, S)<\/em> parancsot!<\/li>\n<li>\u00d6sszegezz\u00fck az oszlopokat! Jel\u00f6lj\u00fck ki a K48:L48 tartom\u00e1nyt!<\/li>\n<li>A K48 cell\u00e1ba g\u00e9pelj\u00fck be az <strong>=SZUM(K41:K47)<\/strong> k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-930e381 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"930e381\" 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-8795b85\" data-id=\"8795b85\" 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-aee1092 elementor-widget elementor-widget-text-editor\" data-id=\"aee1092\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Ha pontosan akarunk elj\u00e1rni, akkor a k\u00e9pletben kiz\u00e1r\u00f3lag az \u00e9rt\u00e9ket tartalmaz\u00f3 cell\u00e1kra szabadna hivatkozunk, kihagyva az elrejtett sorok cell\u00e1it: <strong>=SZUM(K41;K45:K47)<\/strong>. Mivel ebben a feladatban a rejtett soroknak nincs tov\u00e1bbi funkci\u00f3ja, \u00edgy nem k\u00f6vet\u00fcnk el hib\u00e1t az <strong>=SZUM(K41:K47)<\/strong> k\u00e9plettel sem.<\/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-40be8b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"40be8b2\" 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-fd4cc70\" data-id=\"fd4cc70\" 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-b772c13 elementor-widget elementor-widget-text-editor\" data-id=\"b772c13\" 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 az A, C, D term\u00e9kek adatair\u00f3l. Az \u00e1br\u00e1zol\u00e1shoz sz\u00fcks\u00e9g\u00fcnk van az oszlopc\u00edmk\u00e9ket tartalmaz\u00f3 J40:L40 tartom\u00e1nyra is. A K40:L40 cell\u00e1kban azonban nem sz\u00f6vegek, hanem sz\u00e1mok vannak. Egy diagram k\u00e9sz\u00edt\u00e9se el\u0151tt mindig meg kell gy\u0151z\u0151dn\u00fcnk arr\u00f3l, hogy a diagram kateg\u00f3riatengely\u00e9n megjelen\u00edteni k\u00edv\u00e1nt \u00e9rt\u00e9kek adatt\u00edpusa igazodik-e a kiv\u00e1lasztott diagramhoz. A K40:L40 numerikus \u00e9rt\u00e9kei megzavarj\u00e1k az Excelt, nem az x tengelyen \u00e1br\u00e1zoland\u00f3 feliratoknak, hanem az y tengelyen \u00e1br\u00e1zoland\u00f3 \u00e9rt\u00e9keknek tekinti azokat. 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 \u2013 a form\u00e1z\u00e1s azonban nem oldja meg a probl\u00e9m\u00e1t, mivel az Excel \u00edgy is sz\u00e1mk\u00e9nt fogja \u00e9rtelmezni a cell\u00e1k tartalm\u00e1t. Ehelyett valamilyen karakterrel eg\u00e9sz\u00edts\u00fck ki a sz\u00e1mokat vagy h\u00edvjuk seg\u00edts\u00e9g\u00fcl a SZ\u00d6VEG f\u00fcggv\u00e9nyt. Mi ez ut\u00f3bbi, eleg\u00e1nsabb m\u00f3dszerrel szoktunk \u00e9lni ilyen probl\u00e9ma eset\u00e9n, ahogy tessz\u00fck, javasoljuk ezt most 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-fd239b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd239b1\" 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-a59f320\" data-id=\"a59f320\" 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-a73a1e2 elementor-widget elementor-widget-text-editor\" data-id=\"a73a1e2\" 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=\"50\">\n<li>A K40 cell\u00e1ban cser\u00e9lj\u00fck le az \u00e9rt\u00e9ket a k\u00f6vetkez\u0151 k\u00e9pletre: <strong>=SZ\u00d6VEG(100;&#8221;0&#8243;)<\/strong><\/li>\n<li>Az L40 cell\u00e1ban cser\u00e9lj\u00fck le az \u00e9rt\u00e9ket a k\u00f6vetkez\u0151 k\u00e9pletre: <strong>=SZ\u00d6VEG(200;&#8221;0&#8243;)<\/strong><\/li>\n<li>Csoportos\u00edtott oszlopdiagramot kell l\u00e9trehoznunk a munkalapon az A, C, D term\u00e9kek adatainak felhaszn\u00e1l\u00e1s\u00e1val. Ezeket a J41:L41, valamint a J46:L47 tartom\u00e1nyban tal\u00e1ljuk. Sz\u00fcks\u00e9g\u00fcnk van m\u00e9g az el\u0151bb el\u0151k\u00e9sz\u00edtett J40:L40 tartom\u00e1ny c\u00edmk\u00e9ire is. L\u00e1thatjuk, hogy az \u00e1br\u00e1zolni k\u00edv\u00e1nt adatokat tartalmaz\u00f3 cell\u00e1k nem szomsz\u00e9dosak, \u00edgy az <em>F5<\/em> funkci\u00f3billenty\u0171t h\u00edvjuk seg\u00edts\u00e9g\u00fcl, megadva az el\u0151bb felsorolt tartom\u00e1nyhivatkoz\u00e1sokat: J40:L41;J46:L47<\/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-f263810 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f263810\" 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-513a317\" data-id=\"513a317\" 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-df1b67f elementor-widget elementor-widget-text-editor\" data-id=\"df1b67f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Amikor a diagramon megjelen\u00edtend\u0151 \u00e9rt\u00e9kek k\u00f6r\u00e9t meghat\u00e1rozzuk, \u00e1t kell gondolnunk, mely tartom\u00e1nyt kell kijel\u00f6ln\u00fcnk a diagram l\u00e9trehoz\u00e1sa el\u0151tt. T\u00f6bbnyire nem csak az \u00e9rt\u00e9keket, hanem az oszlopok, illetve sorok c\u00edmk\u00e9it is l\u00e1ttatni akarjuk a diagramon, \u00edgy ezeket is ki kell jel\u00f6ln\u00fcnk. Egyszer\u0171 esetben ez \u00e1ltal\u00e1ban a teljes t\u00e1bl\u00e1zat kijel\u00f6l\u00e9s\u00e9t jelenti.<br \/>Igen \u00e1m, de mi a helyzet akkor, mint a mostani feladatban is, ha ki kell hagynunk egy vagy t\u00f6bb sort \u00e9s\/vagy oszlopot \u2013 eset\u00fcnkben a 42:45 sorokat?<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve a J40:L41;J46:L47 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcletet, akkor l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek egy folytonos t\u00e9glalapot mint\u00e1znak.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0b1db82 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b1db82\" 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-45bf868\" data-id=\"45bf868\" 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-4285666 elementor-widget elementor-widget-text-editor\" data-id=\"4285666\" 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=\"53\">\n<li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Oszlop- \u00e9s s\u00e1vdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, \u00da)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a <strong>Csoportos\u00edtott oszlop <\/strong>kiv\u00e1laszt\u00e1s\u00e1hoz! A munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9n megjelenik a kijel\u00f6lt diagram.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1f9ff68 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f9ff68\" 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-e7bd281\" data-id=\"e7bd281\" 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-8ef4714 elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"8ef4714\" 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-9f479e5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9f479e5\" 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-ab5c241\" data-id=\"ab5c241\" 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-bb600a0 elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"bb600a0\" 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-774dd4f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"774dd4f\" 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-a6e7cd9\" data-id=\"a6e7cd9\" 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-44129d2 elementor-widget elementor-widget-text-editor\" data-id=\"44129d2\" 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=\"54\">\n<li>A diagram eltakarhatja a t\u00e1bl\u00e1zatot, ami nagyon zavar\u00f3. Ha sz\u00fcks\u00e9gesnek l\u00e1tjuk, helyezz\u00fck \u00e1t p\u00e9ld\u00e1ul az A30 cell\u00e1ba: \u00fcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd l\u00e9ptess\u00fck az akt\u00edv cell\u00e1t az A30 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6c1c97f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c1c97f\" 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-b239fea\" data-id=\"b239fea\" 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-434dd29 elementor-widget elementor-widget-global elementor-global-16948 elementor-widget-text-editor\" data-id=\"434dd29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> Ha feladatunk egy diagram besz\u00far\u00e1sa az aktu\u00e1lis munkalapra, akkor az t\u00f6bbnyire eltakarja a t\u00e1bl\u00e1zatot. Ez\u00e9rt c\u00e9lszer\u0171 sz\u00e1m\u00e1ra m\u00e1sik helyet keresni, p\u00e9ld\u00e1ul a t\u00e1bl\u00e1zat alatt: a <em>Ctrl+X<\/em> le\u00fct\u00e9s\u00e9vel helyezz\u00fck a V\u00e1g\u00f3lapra a diagramot, majd a visszakapott akt\u00edv cell\u00e1t mozgassuk a diagram bal fels\u0151 sark\u00e1nak helyet ad\u00f3 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t! A diagram kijel\u00f6lt \u00e1llapotban marad.<br \/>Persze, ha a vizsg\u00e1n ezt nem k\u00e9rik, vagy kifejezetten tiltj\u00e1k, akkor hagyjuk ki ezt a l\u00e9p\u00e9st.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c6361ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6361ef\" 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-cbb1024\" data-id=\"cbb1024\" 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-91909a8 elementor-widget elementor-widget-text-editor\" data-id=\"91909a8\" 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=\"55\">\n<li>A feladat le\u00edr\u00e1s\u00e1b\u00f3l kider\u00fcl, hogy az x tengelyen a kiszerel\u00e9si egys\u00e9geknek (100 \u00e9s 200) kell megjelenni\u00fck. Az \u00e1ltalunk elk\u00e9sz\u00edtett diagramon viszont pont ford\u00edtva siker\u00fclt az adatokat \u00e1br\u00e1zolni, vagyis az x tengelyen a term\u00e9kek (A, C \u00e9s D) l\u00e1that\u00f3k. Semmi baj, lehet\u0151s\u00e9g\u00fcnk van az oszlopok\/sorok cser\u00e9j\u00e9re! Adjuk ki a <strong>Diagramtervez\u00e9s \/ Sor\/oszlop v\u00e1lt\u00e1sa <\/strong><em>(Alt+JC, S)<\/em> parancsot!<\/li>\n<li>A kiszerel\u00e9si egys\u00e9geket f\u00e9lk\u00f6v\u00e9r st\u00edlussal kell ell\u00e1tnunk: adjuk ki a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> parancsot!<\/li>\n<li>A <strong>Diagramelemek<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151ben keress\u00fck meg \u00e9s v\u00e1lasszuk ki a <strong>V\u00edzszintes (Kateg\u00f3ria) tengely<\/strong> elemet!<\/li>\n<li>A f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz adjuk ki a <strong>Kezd\u0151lap \/ F\u00e9lk\u00f6v\u00e9r <\/strong><em>(Alt+\u0150, 1)<\/em> parancsot!<\/li>\n<li>A diagram c\u00edm\u00e9nek t\u00f6rl\u00e9s\u00e9hez adjuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ Nincs <\/strong><em>(Alt+JC, D, C, N)<\/em> parancsot!<\/li>\n<li>A diagram v\u00edzszintes \u00e9s f\u00fcgg\u0151leges vezet\u0151r\u00e1csokat tartalmazhat. Diagramunkon csak v\u00edzszintes f\u0151 vezet\u0151r\u00e1csok tal\u00e1lhat\u00f3k, ezek t\u00f6rl\u00e9s\u00e9hez adjuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ R\u00e1csvonalak \/ Els\u0151dleges v\u00edzszintes f\u0151 vezet\u0151r\u00e1cs <\/strong><em>(Alt+JC, D, R, Z)<\/em> parancsot! A parancsot tartalmaz\u00f3 men\u00fcn v\u00e9gigl\u00e9pkedve ellen\u0151rizhetj\u00fck, hogy mely vezet\u0151r\u00e1csok vannak be- illetve kikapcsolva. A k\u00e9sz t\u00e1bl\u00e1zatot \u00e9s a diagramot l\u00e1thatjuk az <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_1_TablazatDiagram.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"1. \u00e1br\u00e1n (opens in a new tab)\">1. \u00e1br\u00e1n<\/a>.<\/li>\n<li>Utols\u00f3 feladatunk az A1:E26 tartom\u00e1ny\u00e1nak kinyomtat\u00e1sa. A tartom\u00e1ny kijel\u00f6l\u00e9s\u00e9hez h\u00edvjuk seg\u00edts\u00e9g\u00fcl az <em>F5<\/em> funkci\u00f3billenty\u0171t, mivel \u00edgy nem csak az akt\u00edv cell\u00e1t kaphatjuk vissza, hanem a diagram kijel\u00f6lt \u00e1llapot\u00e1t is megsz\u00fcntethetj\u00fck!<\/li>\n<li>Jel\u00f6lj\u00fck meg nyomtat\u00e1si ter\u00fcletnek a tartom\u00e1nyt a <strong>Lapelrendez\u00e9s \/ Nyomtat\u00e1si ter\u00fclet \/ Nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se <\/strong><em>(Alt+P, I, K)<\/em> paranccsal!<\/li>\n<li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> <em>(Alt+P, O)<\/em> parancsot!<\/li>\n<li>Az <strong>Oldal<\/strong> f\u00fcl\u00f6n v\u00e1lasszuk ki az <strong>\u00c1ll\u00f3 T\u00e1jol\u00e1st <\/strong><em>(Alt+L)<\/em>, a <strong>Nagy\u00edt\u00e1s<\/strong> r\u00e9szben a <strong>Legyen <\/strong><em>(Alt+N) <\/em>v\u00e1laszt\u00f3gombot!<\/li>\n<li>\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-d6c05e9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d6c05e9\" 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-83b17df\" data-id=\"83b17df\" 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-79c490c elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"79c490c\" 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-f6fd753 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f6fd753\" 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-1f3192c\" data-id=\"1f3192c\" 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-5e2d4e8 elementor-widget elementor-widget-text-editor\" data-id=\"5e2d4e8\" 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=\"66\">\n<li>Adjuk ki a <strong>F\u00e1jl \/ Export\u00e1l\u00e1s<\/strong> parancsot, \u00e9s keress\u00fck meg a <strong>PDF\/XPS l\u00e9trehoz\u00e1sa<\/strong> <em>(Alt+F, E, A) <\/em>gombot!<\/li>\n<li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel PDF vagy XPS form\u00e1tumban<\/strong> p\u00e1rbesz\u00e9dablak, amelynek <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben l\u00e1tjuk a munkaf\u00fczet nev\u00e9t, amit el is fogadhatunk.<\/li>\n<li>Ments\u00fcnk a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> <em>(Alt+K)<\/em> gombot v\u00e1lasztva!<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-107851d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"107851d\" 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-4b6d0c9\" data-id=\"4b6d0c9\" 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-4875253 elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"4875253\" 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-91e55e9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"91e55e9\" 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-897f06f\" data-id=\"897f06f\" 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-b3ee777 elementor-widget elementor-widget-text-editor\" data-id=\"b3ee777\" 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 class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_4_PDF.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"4. \u00e1bra (opens in a new tab)\">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-f2f9ed9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f2f9ed9\" 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-b395bae\" data-id=\"b395bae\" 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-df10aac elementor-widget elementor-widget-text-editor\" data-id=\"df10aac\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A feladat megold\u00e1sa sor\u00e1n 3 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet, egy HTML weblapot \u00e9s egy PDF dokumentumot (<a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/235-K-ECDLM04S6-Vizsgafeladat29_Megoldas1_5_Fajlok.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"5. \u00e1bra (opens in a new tab)\">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-45f954f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45f954f\" 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-dd18dc7\" data-id=\"dd18dc7\" 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-1959c03 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"1959c03\" 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-feab253 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"feab253\" 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-c3e1397\" data-id=\"c3e1397\" 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-d731baa elementor-widget elementor-widget-text-editor\" data-id=\"d731baa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 j\u00falius 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<\/b><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aa9f57a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aa9f57a\" 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-2fda9a9\" data-id=\"2fda9a9\" 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-9cb6eae elementor-widget elementor-widget-shortcode\" data-id=\"9cb6eae\" 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--5633 \"        data-post-id=\"5633\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-5633\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-5633\">                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-8a6d055 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a6d055\" 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-7a7baec\" data-id=\"7a7baec\" 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-5315b1e 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=\"5315b1e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0Friss\u00edtve: 2022 j\u00falius 31. Mir\u0151l sz\u00f3l ez a cikk?Ebben a l\u00e1t\u00e1ss\u00e9r\u00fcltek sz\u00e1m\u00e1ra k\u00e9sz\u00fclt Microsoft Excel oktat\u00f3anyagban az ECDL T\u00e1bl\u00e1zatkezel\u00e9s modulhoz kiadott Vizsgap\u00e9ldat\u00e1r 29. 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=5633\">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-5633","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/5633","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=5633"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/5633\/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=5633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}