Homework Assignment

Independent Project 4-5
Windows   Mac
Boyd Air is monitoring flight arrival status as well as capacities. Before formatting the data as an Excel table, you will export it as a text file for use in the reservation software. You will filter the data in the table, build a PivotTable, and create a PivotChart.
[Student Learning Outcomes 4.1, 4.2, 4.3, 4.4, 4.7, 4.8]
File Needed: BoydAir-04.xlsx (Available from the Start File link.)
Completed Project File Name: [your name]-BoydAir-04.xlsx
Skills Covered in This Project

Export data as a text file.
Format data as an Excel table.
Use a number filter in a table.
Set conditional formatting with an icon set.
Filter data by cell icon.
Create and format a PivotTable.
Create and format a PivotChart.

Open the BoydAir-04.xlsx 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 A4 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 I5:I32, 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).Figure 4-107 Custom sort for the 3 Flags icon set
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).Figure 4-108 PivotTable suggestions from the Quick Analysis tool
Rename the sheet PivotTable&Chart.
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.
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.
Use White, Pivot Style Light 8 for the PivotTable and show banded rows and columns.
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.
Select the legend in the chart and change the font size to 11 from the Home tab.
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.
Select cell A1 and save and close the workbook (Figure 4-109).Figure 4-109 Excel 4-5 completed
Upload and save your project file.
Submit project for grading.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more