Скачать или смотреть Exp19 Excel Ch03 ML1 Airports

#Exp19_Excel_Ch03_ML1_Airports #ML1_Airports #Ch03_ML1_Airports #Airports #Ch03_ML1_Airports #Exp19_Excel_Ch03_ML1_Airports.xlsx #Airports.xlsx #ML1_Airports.xlsx #Exp19_Excel_ch13 #ch03 #exp19_excel _ML1_Airports #airports
#Exp19_Excel_Ch03_ML1_Airports #Exp19_Excel_Chapter03_ML1_Airports
#Excel_2019_Project #Excel_2022_Project #Exp19_Excel_ch03 #Exp19_Excel_Ch03_ML1_Airports
#Exp19_Excel_Ch03_ML1_Airports.xlsx


Contact Me For Your Assignments and Courses Complete Solution 100%


Direct WhatsApp Link
https://wa.me/+923281389410

WhatsApp : +923281389410

Email: [email protected]

#Exp19 Excel Ch03 ML1 Airports
#Excel Ch03 ML1 Airports
#Ch03 ML1 Airports
#Exp19_Excel_Ch03_ML1_Airports | Excel Chapter 3 Mid-Level 1 – Airports
#Exp19_Excel_Ch03_ML1_Airports | Exp19 Excel Ch03 ML1 Airports 1.2
#Exp19_Excel_Ch03_ML1_Airports | Exp19 Excel Ch03 ML1 Airports
#Exp19_Excel_Ch03_ML1_Airports | Exp19_Excel_Ch03_ML1_Airports
#Exp19_Excel_Ch03_ML1_Airports | Excel Chapter 3 Airports


#Exp19_Excel_Ch03_ML1_Airports #ML1_Airports #Ch03_ML1_Airports #Airports #Ch03_ML1_Airports #Exp19_Excel_Ch03_ML1_Airports.xlsx #Airports.xlsx #ML1_Airports.xlsx #Exp19_Excel_ch13 #ch03 #exp19_excel _ML1_Airports #airports
#Exp19_Excel_Ch03_ML1_Airports #Exp19_Excel_Chapter03_ML1_Airports
#Excel_2019_Project #Excel_2022_Project #Exp19_Excel_ch03

Exp19_Excel_Ch03_ML1_Airports

Project Description:
As an analyst for the airline industry, you track the number of passengers at the top six major U.S. airports: Atlanta (ATL), Chicago (ORD), Los Angeles (LAX), Dallas/Fort Worth (DFW), Denver (DEN), and New York (JFK). Next, you will create a bar chart to compare the passenger count for the latest year of data available and then emphasize the airport with the largest number of passenger traffic. Finally, you want to insert sparklines to visually represent trends in passengers at each airport over the 10-year period.

Steps to Perform:
Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch03_ML1_Airports.xlsx.
Use Quick Analysis to create a clustered column chart for the range A4:L10. Cut the chart and paste it in cell A15.
•Type Passengers by Top U.S. Airports as the chart title.
•Swap the data on the category axis and in the legend.
•Set a 3.5" height and 11.4" width.
•Apply the Style 7 chart style. 10
•Change the display units to Millions for the value axis.
•Edit the axis title to display Millions of Passengers.
‪@PearsonSolution‬
‪@PearsonSolution‬
‪@PearsonSolution‬
Display data labels above the columns for the 2016 data series only.
Apply the Light Gradient – Accent 2 preset gradient fill to the chart area.

Add Alt Text:
Change the workbook theme to Slice.

Create a recommended clustered bar chart for the range A5:A10 and L5:L10 and move the chart to a chart sheet named Bar Chart. 5
•Change the chart color to Colorful Palette 3.
•Enter Passengers at Top 6 U.S. Airports in 2016 as the chart title.
•Apply the Style 5 chart style.
•Change the font size to 10 for the category axis and value axis.
•Change the value axis Maximum Bound to 1.1E8.
‪@PearsonSolution‬
‪@PearsonSolution‬
‪@PearsonSolution‬
•Format the Atlanta data point with Dark Blue, Text 2 fill color.
•Add Primary Minor Vertical gridlines.
Create a line chart using the range A4:L10 in the Passenger worksheet and move the chart to a chart sheet named Line Chart.
•Set the Minimum Bound at 4.0E7 for the value axis. The Maximum Bound should change to 1.1E8 automatically.
•Set the Vertical (Value) Axis Display units to Millions. Delete the Vertical (Value) Axis Display Units Label from the upper-left corner of the chart. Add a value axis title In Millions.
•Change the font size to 10 for the value axis and category axis.
•Move the legend to the top.
•Filter the chart by deselecting the odd-numbered years.
Display the Passenger worksheet and insert Line sparklines in the range M5:M10 to illustrate the data in the range B5:L10.
‪@PearsonSolution‬
‪@PearsonSolution‬
‪@PearsonSolution‬
•Show the high and low points in each sparkline.
•Apply Black, Text 1 color to the high point marker in each sparkline

5
17 On the Questions worksheet, type the answer to the first question in cell A2. Enter only the airport code.
Answer the other questions by typing in the answers in cells A3, A4, A5, and A6. 5
18 Group the Bar Chart and Line Chart sheets and insert a footer with Exploring Series on the left side, the sheet name code in the center, and the file name code on the right on all worksheets. Group the Passenger and Questions sheets and insert a footer with the same data. Change to Normal view. 5
19 Set page formats for the Passenger worksheet.
Select Legal paper size, select Landscape orientation, set 0.3" left and right margins, and scale to fit 1 page. 6
20 Save and close Exp19_Excel_Ch03_ML1_Airports.xlsx. Exit Excel.