Next, Excel needs to know what it will use as ... and use Ctrl+V to copy the list where you want Table 2 to be. Select and ...

Create a table ... left of the excel worksheet. An Insert Function dialog box will appear. Inside the dialog box in the section, Select a Category, select Engineering from the list box.