;

What's New in the Microsoft Office
2019 Certiport Certifications?


Did you prepare for the Microsoft Office 2016 Certification Exams but now want to take the 2019 Certification Exams? We’re here to help! Check below to see what objectives Certiport has added to and removed from each of their exams. If you’re worried about your readiness for the 2019 exams, check out our Practice Tests and Courses that will help you learn and prepare.

Excel 2019 New and Removed Domains

Quick Snapshot

Removed Domains
  • 1.1.1: Create a blank document
  • 1.1.2: Create a blank document using a template
  • 1.1.3: Open a PDF in Word for editing
  • 1.1.1: Create a workbook
  • 1.1.3: Add a worksheet to an existing workbook
  • 1.1.4: Copy and move a worksheet
  • 1.3.1: Change worksheet tab color
  • 1.3.2: Rename a worksheet
  • 1.3.3: Change worksheet order
  • 1.3.6: Change workbook themes
  • 1.4.1: Hide or unhide worksheets
  • 1.4.2: Hide or unhide columns and rows
  • 1.4.7: Change magnification by using zoom tools
  • 2.1.1: Replace data
  • 2.1.2: Cut, copy, or paste data
  • 2.3.2: Outline data
  • 2.3.3: Insert subtotals
  • 3.3.3: Change sort order
  • 3.3.4: Remove duplicate records
  • 4.2.2: Perform logical operations by using the SUMIF function
  • 4.2.3: Perform logical operations by using the AVERAGEIF function
  • 4.2.4: Perform statistical operations by using the COUNTIF function
  • 5.1.4: Analyze data by using Quick Analysis
  • 5.2.1: Resize charts
  • 5.3.1: Insert text boxes and shapes
  • 5.3.2: Insert images
  • 5.3.3: Modify object properties

Excel 2019 New Domains:

1.4.3: Freeze worksheet rows and columns

The Freeze Panes tool lets you keep certain rows and columns always visible as you move throughout the worksheet. You can freeze just the top row and just the first column, or you can use the Freeze Panels tool to free more than that. When using the Freeze Panes tool, every row above and every column to the left of your selection will be frozen.


2.2.8: Clear cell formatting

You can use the Clear tool in the Editing group on the Home tab to clear cell formatting and contents. Clear Formats leaves behind content, comments, and hyperlinks but removes formatting; Clear Contents leaves behind formats, comments, and hyperlinks but removes content; Clear Comments only removes comments attached to the cell; Clear Hyperlinks removes the hyperlink but leaves behind the content and formatting, including the underline and color; Remove Hyperlink removes the hyperlink and hyperlink formatting.


2.3.1: Define a named range

Defining a named range makes formulas much easier to understand and maintain because you can use the name in a formula instead of using a reference. You can define a name for a single cell, range of cells, function, constant, or table. You can define a name by using the Name Box in the upper-left corner of the workspace, the Define Name button, or the Name Manager.


2.3.2: Name a table

The Freeze Panes tool lets you keep certain rows and columns always visible as you move throughout the worksheet. You can freeze just the top row and just the first column, or you can use the Freeze Panels tool to free more than that. When using the Freeze Panes tool, every row above and every column to the left of your selection will be frozen.


2.4.3: Remove conditional formatting

You can remove conditional formatting from the same menu where you apply it. You can remove the rules for the conditional formatting for the selected cells, the entire sheet, the table, or the PivotTable.


GMetrix Can Help


GMetrix offers practice tests that allow you to check your readiness for the Excel 2019 official certification exam. If you don’t feel ready for the practice tests, we also host Excel 2019 courses from trusted partners that will teach you the ins and outs of the new and previous domains.


Excel 2019 Practice Tests
Excel 2019 Course
Microsoft Office 2019 Full Suite
GMetrix interface
Your Content Host
GMetrix is the ultimate study platform
Are you a company who has made learning material for a certification? Host it here!
Email us at [email protected]
© Copyright 2021, GMetrix LLC   Privacy Policy  /  Return Policy