Just hit Enter and Excel completes the data input for you.

4 Flash Fill Done

They also showed some data analysis capabilities.  Highlight the data table.  Note the Quick Analysis icon in the lower right hand corner.

5 Quick Analysis 1

Left click on the icon and you see the Quick Analysis choices.

6 Quick Analysis 2

Let’s choose the Data Bars option.  Excel superimposes a data bar chart over the numbers data.  This is a useful way to display the number chart.

7 Quick Analysis 3