{"id":146,"date":"2025-08-13T10:30:07","date_gmt":"2025-08-13T10:30:07","guid":{"rendered":"https:\/\/www.foqhawi.com\/?p=146"},"modified":"2025-08-13T19:15:25","modified_gmt":"2025-08-13T19:15:25","slug":"intermediat-microsoft-office-excel-2021","status":"publish","type":"post","link":"https:\/\/www.foqhawi.com\/?p=146","title":{"rendered":"Intermediat Microsoft Office Excel 2021"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"146\" class=\"elementor elementor-146\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6009186 e-flex e-con-boxed e-con e-parent\" data-id=\"6009186\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c5b0e0e elementor-widget elementor-widget-text-editor\" data-id=\"c5b0e0e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h3>Preparing for an Exam<\/h3><p>This exam validates the skills needed to be proficient in Excel 2021.<\/p><h3>Audience Profile<\/h3><p>The Core-level Microsoft Office Excel 2021 User should be able to navigate Microsoft Office Excel 2021 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2021. The core-level user should be able to use Microsoft Office Excel 2021 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:<\/p><ul><li>\u00a0 \u00a0 \u00a0 Accountants<br \/>\u2022 \u00a0 \u00a0 \u00a0 Clerical, Office professionals<br \/>\u2022 \u00a0 \u00a0 \u00a0 Consultants<br \/>\u2022 \u00a0 \u00a0 \u00a0 Executives\/Managers<br \/>\u2022 \u00a0 \u00a0 \u00a0 Help desk personnel<br \/>\u2022 \u00a0 \u00a0 \u00a0 Instructors\/Trainers<br \/>\u2022 \u00a0 \u00a0 \u00a0 Program\/Project Managers<br \/>\u2022 \u00a0 \u00a0 \u00a0 Sales<br \/>\u2022 \u00a0 \u00a0 \u00a0 Students<br \/>\u2022 \u00a0 \u00a0 \u00a0 Other members of the general population<br \/><br \/>Tasks that might be undertaken or work products created by members of the Microsoft Excel 2021 Core-level User Target Audience might include, but would not be limited to:<br \/><br \/>\u2022 \u00a0 \u00a0 \u00a0 Charting<br \/>\u2022 \u00a0 \u00a0 \u00a0 Create analytical, financial, etc. reports<br \/>\u2022 \u00a0 \u00a0 \u00a0 Data entry<br \/>\u2022 \u00a0 \u00a0 \u00a0 Family budget<br \/>\u2022 \u00a0 \u00a0 \u00a0 Format numerical (financial, statistical, etc.) reports<br \/>\u2022 \u00a0 \u00a0 \u00a0 Forms<br \/>\u2022 \u00a0 \u00a0 \u00a0 Graphing<br \/>\u2022 \u00a0 \u00a0 \u00a0 Process data<br \/>\u2022 \u00a0 \u00a0 \u00a0 Reporting<br \/>\u2022 \u00a0 \u00a0 \u00a0 Technical support<br \/>\u2022 \u00a0 \u00a0 \u00a0 Trending<\/li><\/ul><p>\u00a0<\/p><table><tbody><tr><td>\u00a0<\/td><\/tr><\/tbody><\/table><h2><a href=\"http:\/\/www.microsoft.com\/learning\/en\/us\/exam.aspx?ID=77-882#tab2\">Skills Measured<\/a><\/h2><p>Skills Being Measured This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam.<\/p><p><br \/>The information after \u201cThis objective may include but is not limited to\u201d is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.<\/p><p><strong>Excel 2021 Setup &amp; Printing Issues<\/strong><\/p><p>\u00a0<\/p><ul><li>Worksheet Margins<\/li><li>Worksheet Orientation<\/li><li>Worksheet Page Size<\/li><li>Headers and Footers<\/li><li>Header and Footer Fields<\/li><li>Scaling Your Worksheet to Fit a Page(S)<\/li><li>Visually Checking Your Calculations<\/li><li>Displaying Gridlines When Printing<\/li><li>Printing Titles on Every Page<\/li><li>Printing Row and Column Headings<\/li><li>Spell Checking<\/li><li>Previewing a Worksheet<\/li><li>Viewing Workbooks Side By Side<\/li><li>Zooming the View<\/li><li>Printing Options<\/li><li>Setting the Number of Copies to Print<\/li><li>Selecting a Printer<\/li><li>Selecting Individual Worksheets or the Entire Workbook<\/li><li>Selecting Which Pages to Print<\/li><li>Single or Double Sided Printing<\/li><li>Collation Options<\/li><li>Page Orientation<\/li><li>Paper Size<\/li><li>Margins<\/li><li>Scaling<\/li><li>Printing<\/li><\/ul><p><strong>Excel 2021 Functions and Formulas<\/strong><\/p><ul><li>Getting Help with Functions<\/li><li>Nested Functions<\/li><li>Consolidating Data Using a 3-D Reference Sum Function<\/li><li>Mixed References within Formulas<\/li><\/ul><p><strong>Excel 2021 Time &amp; Date Functions<\/strong><\/p><ul><li>Inserting the Current Time and Date<\/li><li>Today Function<\/li><li>Now Function<\/li><li>Day Function<\/li><li>Month Function<\/li><li>Year Function<\/li><\/ul><p><strong>Excel 2021 Mathematical Functions<\/strong><\/p><ul><li>Round Function<\/li><li>Rounddown Function<\/li><li>Roundup Function<\/li><\/ul><p><strong>Excel 2021 Logical Functions<\/strong><\/p><ul><li>If Function<\/li><li>And Function<\/li><li>Or Function<\/li><\/ul><p><strong>Excel 2021 Mathematical Functions<\/strong><\/p><ul><li>Sumif Function<\/li><\/ul><p><strong>Excel 2021 Statistical Functions<\/strong><\/p><ul><li>Count Function<\/li><li>Counta Function<\/li><li>Countif Function<\/li><li>Countblank Function<\/li><li>Rank Function<\/li><\/ul><p><strong>Excel 2021 Text Functions<\/strong><\/p><ul><li>Left Function<\/li><li>Right Function<\/li><li>Mid Function<\/li><li>Trim Function<\/li><li>Concatenate Function<\/li><\/ul><p><strong>Excel 2021 Financial Functions<\/strong><\/p><ul><li>Fv Function<\/li><li>Pv Function<\/li><li>Npv Function<\/li><li>Rate Function<\/li><li>Pmt Function<\/li><\/ul><p><strong>Excel 2021 Lookup Functions<\/strong><\/p><ul><li>Vlookup Function<\/li><li>Hlookup Function<\/li><\/ul><p><strong>Excel 2021 Database Functions<\/strong><\/p><ul><li>Dsum Function<\/li><li>Dmin Function<\/li><li>Dmax Function<\/li><li>Dcount Function<\/li><li>Daverage Function<\/li><\/ul><p><strong>Excel 2021 Named Ranges<\/strong><\/p><ul><li>Naming Cell Ranges<\/li><li>Removing a Named Range<\/li><li>Named Cell Ranges and Functions<\/li><\/ul><p><strong>Excel 2021 Cell Formatting<\/strong><\/p><ul><li>Applying Styles to a Range<\/li><li>Conditional Formatting<\/li><li>Custom Number Formats<\/li><\/ul><p><strong>Manipulating Worksheets within Excel 2021<\/strong><\/p><ul><li>Copying or Moving Worksheets between Workbooks<\/li><li>Splitting a Window<\/li><li>Hiding Rows<\/li><li>Hiding Columns<\/li><li>Hiding Worksheets<\/li><li>Un-Hiding Rows<\/li><li>Un-Hiding Columns<\/li><li>Un-Hiding Worksheets<\/li><\/ul><p><strong>Excel 2021 Templates<\/strong><\/p><ul><li>Using Templates<\/li><li>Creating Excel Templates<\/li><li>Editing Excel Templates<\/li><\/ul><p><strong>Paste Special Options within Excel 2021<\/strong><\/p><ul><li>Using Paste Special to Add, Subtract, Multiply &amp; Divide<\/li><li>Using Paste Special \u2018Values\u2019<\/li><li>Using Paste Special Transpose Option<\/li><\/ul><p>\u00a0<\/p><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Preparing for an Exam This exam validates the skills needed to be proficient in Excel 2021. Audience Profile The Core-level Microsoft Office Excel 2021 User should be able to navigate Microsoft Office Excel 2021 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":148,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-146","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cources"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Intermediat Microsoft Office Excel 2021 - Foqhawi Academy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.foqhawi.com\/?p=146\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intermediat Microsoft Office Excel 2021 - Foqhawi Academy\" \/>\n<meta property=\"og:description\" content=\"Preparing for an Exam This exam validates the skills needed to be proficient in Excel 2021. Audience Profile The Core-level Microsoft Office Excel 2021 User should be able to navigate Microsoft Office Excel 2021 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.foqhawi.com\/?p=146\" \/>\n<meta property=\"og:site_name\" content=\"Foqhawi Academy\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-13T10:30:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-13T19:15:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"705\" \/>\n\t<meta property=\"og:image:height\" content=\"397\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.foqhawi.com\/?p=146\",\"url\":\"http:\/\/www.foqhawi.com\/?p=146\",\"name\":\"Intermediat Microsoft Office Excel 2021 - Foqhawi Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.foqhawi.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.foqhawi.com\/?p=146#primaryimage\"},\"image\":{\"@id\":\"http:\/\/www.foqhawi.com\/?p=146#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg\",\"datePublished\":\"2025-08-13T10:30:07+00:00\",\"dateModified\":\"2025-08-13T19:15:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.foqhawi.com\/#\/schema\/person\/5e925aa9a4949c95676a83081cd7ea3d\"},\"breadcrumb\":{\"@id\":\"http:\/\/www.foqhawi.com\/?p=146#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.foqhawi.com\/?p=146\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.foqhawi.com\/?p=146#primaryimage\",\"url\":\"https:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg\",\"contentUrl\":\"https:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg\",\"width\":705,\"height\":397},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.foqhawi.com\/?p=146#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.foqhawi.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intermediat Microsoft Office Excel 2021\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.foqhawi.com\/#website\",\"url\":\"https:\/\/www.foqhawi.com\/\",\"name\":\"Foqhawi Academy\",\"description\":\"Foqhawi For Training And Cosultation\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.foqhawi.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.foqhawi.com\/#\/schema\/person\/5e925aa9a4949c95676a83081cd7ea3d\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.foqhawi.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7321f685b5a02ab92339e707c4e0b3482f0b674f02504ccc07932b38e37217a5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7321f685b5a02ab92339e707c4e0b3482f0b674f02504ccc07932b38e37217a5?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/foqhawi.com\"],\"url\":\"https:\/\/www.foqhawi.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intermediat Microsoft Office Excel 2021 - Foqhawi Academy","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.foqhawi.com\/?p=146","og_locale":"en_US","og_type":"article","og_title":"Intermediat Microsoft Office Excel 2021 - Foqhawi Academy","og_description":"Preparing for an Exam This exam validates the skills needed to be proficient in Excel 2021. Audience Profile The Core-level Microsoft Office Excel 2021 User should be able to navigate Microsoft Office Excel 2021 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of [&hellip;]","og_url":"http:\/\/www.foqhawi.com\/?p=146","og_site_name":"Foqhawi Academy","article_published_time":"2025-08-13T10:30:07+00:00","article_modified_time":"2025-08-13T19:15:25+00:00","og_image":[{"width":705,"height":397,"url":"http:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.foqhawi.com\/?p=146","url":"http:\/\/www.foqhawi.com\/?p=146","name":"Intermediat Microsoft Office Excel 2021 - Foqhawi Academy","isPartOf":{"@id":"https:\/\/www.foqhawi.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.foqhawi.com\/?p=146#primaryimage"},"image":{"@id":"http:\/\/www.foqhawi.com\/?p=146#primaryimage"},"thumbnailUrl":"https:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg","datePublished":"2025-08-13T10:30:07+00:00","dateModified":"2025-08-13T19:15:25+00:00","author":{"@id":"https:\/\/www.foqhawi.com\/#\/schema\/person\/5e925aa9a4949c95676a83081cd7ea3d"},"breadcrumb":{"@id":"http:\/\/www.foqhawi.com\/?p=146#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.foqhawi.com\/?p=146"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.foqhawi.com\/?p=146#primaryimage","url":"https:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg","contentUrl":"https:\/\/www.foqhawi.com\/wp-content\/uploads\/2025\/08\/intermediat2021.jpg","width":705,"height":397},{"@type":"BreadcrumbList","@id":"http:\/\/www.foqhawi.com\/?p=146#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.foqhawi.com\/"},{"@type":"ListItem","position":2,"name":"Intermediat Microsoft Office Excel 2021"}]},{"@type":"WebSite","@id":"https:\/\/www.foqhawi.com\/#website","url":"https:\/\/www.foqhawi.com\/","name":"Foqhawi Academy","description":"Foqhawi For Training And Cosultation","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.foqhawi.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.foqhawi.com\/#\/schema\/person\/5e925aa9a4949c95676a83081cd7ea3d","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.foqhawi.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7321f685b5a02ab92339e707c4e0b3482f0b674f02504ccc07932b38e37217a5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7321f685b5a02ab92339e707c4e0b3482f0b674f02504ccc07932b38e37217a5?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/foqhawi.com"],"url":"https:\/\/www.foqhawi.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146"}],"version-history":[{"count":6,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions"}],"predecessor-version":[{"id":154,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions\/154"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=\/wp\/v2\/media\/148"}],"wp:attachment":[{"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foqhawi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}