www.TestsTestsTests.com
Results – Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Test
10 Question Multiple Choice Quiz with Answers
Concatenate, Convert Text to Columns & Remove Duplicates Test Answer Explanations
Try the Excel Tutorial Concatenate, Convert Text to Columns & Remove Duplicates
Try Excel Concatenate, Convert Text to Columns & Remove Duplicates Excel Test again
* TRY THE NEXT TEST: Conditional Formatting in Excel
* TRY THE NEXT TUTORIAL: Conditional Formatting in Excel
* More from TestsTestsTests.com
- 1. Excel Keyboard Shortcuts
6 TUTORIALS & 7 TESTS- 1. Easy Excel Shortcuts TEST
- 2. Intermediate Excel Shortcuts TEST
- 3. Keyboard Shortcuts for Worksheets TUTORIAL
- 3. Keyboard Shortcuts for Worksheets TEST
- 4. Keyboard Shortcuts for Cell Contents TUTORIAL
- 4. Keyboard Shortcuts for Cell Contents TEST
- 5. Shortcuts for Inserting & Deleting Rows,
Columns & Cells TUTORIAL - 5. Shortcuts for Inserting & Deleting Rows,
Columns & Cells TEST - 6. Keyboard Shortcuts for Formatting Numbers TUTORIAL
- 6. Keyboard Shortcuts for Formatting Numbers TEST
- 7. Keyboard Shortcuts for Formulas TUTORIAL
- 7. Keyboard Shortcuts for Formulas TEST
- 8. 30 second Shortcuts Video Part 1 TUTORIAL
- 2. Getting Started in Excel
6 TUTORIALS & 7 TESTS- 1. Excel Basics TUTORIAL
- 1. Excel Basics TEST
- 2. Using the File Tab TUTORIAL
- 2. Using the File Tab TEST
- 3. The Views in Excel TUTORIAL
- 3. The Views in Excel TEST
- 4. Moving Around the Worksheet TUTORIAL
- 4. Moving Around the Worksheet TEST
- 5. Using the Ribbon Excel TUTORIAL
- 5. Using the Ribbon Excel TEST
- 6. Customizing the Quick Access Toolbar TUTORIAL
- 6. Customizing the Quick Access Toolbar TEST
- 7. The Excel Screen TEST
- 3. Entering Data in Excel
4 TUTORIALS & 4 TESTS - 4. Formulas & Functions
8 TUTORIALS & 8 TESTS- 1. Excel Formula Basics TUTORIAL
- 1. Excel Formula Basics TEST
- 2. Copying Formulas & using Relative &
Absolute Cell References TUTORIAL - 2. Copying Formulas & using Relative &
Absolute Cell References TEST - 3. Excel Formatting Numbers Basics TUTORIAL
- 3. Excel Formatting Numbers Basics TEST
- 4. Understanding Functions TUTORIAL
- 4. Understanding Functions TEST
- 5. Using IF, SUMIF and COUNTIF TUTORIAL
- 5. Using IF, SUMIF and COUNTIF TEST
- 6. Nested IFs, SUMIFs & COUNTIFs
in Functions TUTORIAL - 6. Nested IFs, SUMIFs & COUNTIFs
in Functions TEST - 7. Using Nested Functions TUTORIAL
- 7. Using Nested Functions TEST
- 8. Using Financial Functions Excel TEST
- 8. Using Financial Functions Excel TUTORIAL
- 5. Excel Worksheets
4 TUTORIALS & 4 TESTS- 1. Excel Basic Worksheet Formatting TUTORIAL
- 1. Excel Basic Worksheet Formatting TEST
- 2. Advanced Worksheet Formatting TUTORIAL
- 2. Advanced Worksheet Formatting TEST
- 3. Protecting Worksheets Excel TUTORIAL
- 3. Protecting Worksheets Excel TEST
- 4. Working with Multiple Worksheets TUTORIAL
- 4. Working with Multiple Worksheets TEST
- 6. Excel Charts
1 TUTORIAL & 1 TEST - 7. Printing Excel Worksheets
2 TUTORIALS & 2 TESTS - 8. Macros in Excel
1 TUTORIAL & TEST - 9. Working with Data in Excel
10 TUTORIALS & 10 TESTS- 1. Sort and Filter Data in Excel TUTORIAL
- 1. Sort and Filter Data in Excel TEST
- 2. Concatenate Function, Convert Text to Columns & Remove Duplicates TUTORIAL
- 2. Concatenate Function, Convert Text to Columns & Remove Duplicates TEST
- 3. Conditional Formatting Excel TUTORIAL
- 3. Conditional Formatting Excel TEST
- 4. Using Data Outline Tools TUTORIAL
- 4. Using Data Outline Tools TEST
- 5. What-If Analysis Excel TUTORIAL
- 5. What-If Analysis Excel TEST
- 6. Using Data Validation Tools TUTORIAL
- 6. Using Data Validation Tools TEST
- 7. VLOOKUP & INDEX-MATCH TUTORIAL
Using Formulas to Look Up Data - 7. VLOOKUP & INDEX-MATCH TEST
Using Formulas to Look Up Data - 8. Formulas to Manipulate & Clean Data TUTORIAL
- 8. Formulas to Manipulate & Clean Data TEST
- 9. Data Forms Excel TUTORIAL
- 9. Data Forms Excel TEST
- 10. Pivot Tables Excel TUTORIAL
- 10. Pivot Tables Excel TEST
- 10. Images & Graphical Elements
1 TUTORIAL & 1 TEST - 11. More Microsoft Excel
- Excel Tutorials & Tests Index Page
- Excel Tutorials Index Page
- Excel Tests Index Page
- Microsoft Office Index Page
- EXCEL 2016 INDEX – TUTORIALS & TESTS
- Excel 2016 Articles
- 1. Learn Excel Basics – Excel 2016
7 TUTORIALS & 7 TESTS- 1. What’s New in Excel 2016? TUTORIAL
- 1. What’s New in Excel 2016? TEST
- 2. Parts of the Excel Screen TUTORIAL
- 2. Parts of the Excel Screen TEST
- 3. Navigating Workbooks & Sheets TUTORIAL
- 3. Navigating Workbooks & Sheets TEST
- 4. The File Tab & Backstage View TUTORIAL
- 4. The File Tab & Backstage View TEST
- 5. Making Excel View Types Work for You TUTORIAL
- 5. Making Excel View Types Work for You TEST
- 6. Mastering the Ribbon & QAT (Quick Access Toolbar) TUTORIAL
- 6. Mastering the Ribbon & QAT (Quick Access Toolbar) TEST
- 7. Window and Zoom Options in Excel 2016 TEST
- 7. Window and Zoom Options in Excel 2016 TUTORIAL
- 2. Data Entry & Formatting – Excel 2016
5 TUTORIALS & 5 TESTS- 1. Adding Text & Numbers to a Worksheet TUTORIAL – Excel 2016
- 1. Adding Text & Numbers to a Worksheet TEST – Excel 2016
- 2. Formatting Text & Numbers TUTORIAL – Excel 2016
- 2. Formatting Text & Numbers TEST – Excel 2016
- 3. Aligning Cell Content TUTORIAL – Excel 2016
- 3. Aligning Cell Content TEST – Excel 2016
- 4. Customizing Number & Text Formats TUTORIAL – Excel 2016
- 4. Customizing Number & Text Formats TEST – Excel 2016
- 5. How to Add Excel Borders & Shading to Cells TUTORIAL – Excel 2016
- 5. How to Add Excel Borders & Shading to Cells TEST – Excel 2016
- 3. Excel Formulas & Functions 2016
3 TESTS - 4. Excel Data Analysis ToolPak
1 TUTORIAL & 1 TEST
