Microsoft Excel 2021365 - Beginner to Advanced - Flash Fill

The video tutorial introduces Flash Fill, a feature in Excel 2013 that simplifies data manipulation tasks. It demonstrates how to use Flash Fill to split names, create email addresses, extract order numbers, and split product names into components. The tutorial highlights the ease and efficiency of using Flash Fill compared to traditional methods like formulas or text-to-columns.

What year was Flash Fill introduced in Excel?

• 2013

• 2019

• 2010

• 2016

Which tool can be used to split full names into first and last names in Excel?

• Text to Columns

• Pivot Table

• Conditional Formatting

• VLOOKUP

What is the keyboard shortcut to invoke Flash Fill?

• Ctrl + E

• Ctrl + D

• Ctrl + F

• Ctrl + G

What is a requirement for using Flash Fill to generate email addresses?

• All emails must be different

• All emails must have the same domain

• All emails must be in uppercase

• All emails must be in lowercase

Which part of an order number can Flash Fill extract?

• The last three characters

• The entire order number

• The middle three characters

• The first three characters

What can Flash Fill do with product details in Excel?

• Delete them

• Highlight them

• Merge them into one column

• Separate them into different columns

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

• Using the Flash Fill button on the Data ribbon

• Pressing Ctrl + E

• Typing the pattern and pressing Enter

• Using the Insert tab