Microsoft Excel 2021365 - Beginner to Advanced - Splitting or Combining Cell Data Using Flash Fill

The video tutorial introduces various methods for splitting data in Excel, focusing on the Flash Fill utility. Flash Fill, introduced in Excel 2013, simplifies data manipulation by automatically filling in data patterns. The tutorial demonstrates how to use Flash Fill to split and combine data, highlighting its ease of use compared to traditional text functions. It also covers different ways to invoke Flash Fill and addresses potential issues, such as handling blank columns. The tutorial concludes with practical examples of using Flash Fill in sales worksheets.

What is the main advantage of using Flash Fill over other methods in Excel?

• It is faster and easier.

• It is more accurate.

• It provides more options.

• It is the only method available.

Which of the following is NOT a method to invoke Flash Fill?

• Typing the first entry and clicking a special menu.

• Using the keyboard shortcut Control E.

• Typing the first entry and pressing Enter.

• Using the Flash Fill button in the Data Tools group.

What is the first step in using Flash Fill to split names into first and last names?

• Type the full name in the first cell.

• Type the first name in the first cell.

• Use the Flash Fill button immediately.

• Type the last name in the first cell.

How can you add new columns in Excel before using Flash Fill?

• Use Control Alt Plus.

• Use Control Alt Minus.

• Use Control Shift Plus.

• Use Control Shift Minus.

What happens when you use Flash Fill on data with brackets, like 'Kensington'?

• An error occurs.

• The brackets are removed.

• The brackets are included.

• The data is not filled.

What is a limitation of Flash Fill when combining data?

• It requires a blank column.

• It struggles with blank columns between data.

• It only works with text data.

• It cannot handle numbers.

What should you do if Flash Fill doesn't work due to a blank column?

• Use a different worksheet.

• Delete the blank column.

• Use text functions or text to columns.

• Restart Excel.