Subject:MS ExcelPrice:25.99 Bought3
Excel Chapter 3 Mid-Level 1 - Airports
Start Excel. Download and open the file named Exp19_Excel_Ch03_ML1_Airports.xlsx. Grader has automatically added your last name to the beginning of the filename.
You want to create a clustered column chart to depict the passenger counts at the six airports over several years.
You want to customize the column chart with a chart title, display the years as a data series, enlarge the chart to be easier to read, and apply a chart style.
The value axis takes up a lot of space for the numbers. You will adjust the value axis to simplify it.
You want to focus on the 2016 data series by adding data labels.
Applying a fill color to the chart area will make the chart visually appealing.
A best practice is to add Alt Text to a chart for accessibility compliance.
When you change the workbook theme, Excel applies that theme to the chart styles.
You want to create a bar chart to display passenger counts for only one year.
You want to customize the bar chart.
Modifying the axes will improve readability of the bar chart.
You will format a data point so that it stands out and then add gridlines to enhance readability in the bar chart.
A line chart effectively shows trends over time for the passenger counts at the different airports.
You want to customize the line chart.
Sparklines provide a simple visualization to represent data in a worksheet.
You want to customize the sparklines to point out high and low points.
On the Questions worksheet, type the answer to the first question in cell A2. Enter only the airport code.
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.
Set page formats for the Passenger worksheet.
Save and close Exp19_Excel_Ch03_ML1_Airports.xlsx. Exit Excel. Submit the file as directed.