Excel 2019 In Practice Ch 4 Independent Project 4 5

  1. Open the BoydAir-04.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it.
  2. 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.
  3. Rename the sheet tab Stats.
  4. The worksheet includes the Boyd Air Flight Statistics.
  5. Select cell A4 and format the data as an Excel table using Green, Table Style Medium 21.
  6. Copy the Stats sheet to the end and name the copy PM Flights.
  7. 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).Departure label in row 4 displays filter iconFigure 4-106 Filter results for Departure Time field
  8. Select the Stats worksheet, select cells I5:I32, and set conditional formatting to use 3 Flags from the Icon Sets.
  9. 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).The red flag is not used in the Sort dialog boxFigure 4-107 Custom sort for the 3 Flags icon set
  10. Select the Stats worksheet, select cells A4:I32, and use the Quick Analysis tool to create a PivotTable to display average of capacity by origin (Figure 4-108).The ScreenTip displays Average of Capacity by OriginFigure 4-108 PivotTable suggestions from the Quick Analysis tool
  11. Rename the sheet PivotTable&Chart.
  12. Select cell B3 in the PivotTable and use Field Settings to set a Number Format of Percentage with two decimal places. Edit the Custom Name to display Average Capacity.
  13. Add the Passengers field to the PivotTable Values area with a sum calculation. Edit the field settings to display # of Passengers as the custom name. Set the number format to Number with zero decimals and a thousand’s separator.
  14. Use White, Pivot Style Light 8 for the PivotTable and show banded rows and columns.
  15. Add a 3-D Pie PivotChart to the sheet and position the chart object to start in cell E3. Size the chart to reach cell N22.
  16. Select the legend in the chart and change the font size to 11 from the Home tab.
  17. Show Data Labels on the chart positioned at the Inside End. Select a data label and format all labels from the Home tab as bold and 10 pt.
  18. Select cell A1 and save and close the workbook (Figure 4-109).
  19. Upload and save your project file.
  20. Submit project for grading.

Excel 4-5 completed

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount