Mark the steps as checked when you complete them.

Open the BoydAir$-04.$xIsx start file. If the workbook opens in Protected View, click the Enable Editing button

so you can modify it$.$

The file will be renamed automatically to include your name. Change the project file name if directed to do so by

your instructor, and save it$.$

Rename the sheet tab Stats.

The worksheet includes the Boyd Air Flight statistics.

Select cell A$4$ and format the data as an Excel table using Green, Table Style Medium $21.$

Copy the Stats sheet to the end and name the copy PM Flights.

Select the PM Flights sheet, and use a Greater Than filter to display flights with a departure time after $12$:$00$ PM

$($Figure $4-106).$

Figure $4-106$ Filter results for Departure Time field

Select the Stats worksheet, select cells $15$:$132,$ and set conditional formatting to use $3$ Flags from the Icon Sets.

Build a two$-$level Custom Sort for the Capacity column to sort by icon. Show the green flag at the top, followed

by the yellow flag. The red flag will default to the bottom $($Figure $4-107).$