1. Education The Education table contains information about the median annual in

1. Education
The Education table contains information about the median annual income and 2018 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemployment.
1.1
Construct a clustered column chart to examine the median annual earnings for each level of education.
a. Select the range for each education level (B3:B10) and the values for median income (C3:C10) before inserting the chart.
b. Format the chart with the title “Education and Income” at the top.
c. Show each education level on the horizontal axis. Note: if you have selected the education levels and income data before inserting the chart, this will likely already be the case.
d. Do not display a legend.
e. Show data labels on the top of each of the “columns” of the graph.
f. Place the top left corner of the chart over the specified range of the worksheet.
1.2
Construct a clustered column chart to examine the unemployment rate for each level of education.
a. Select the range for each education level (B3:B10) and the values for the unemployment rate (D3:D10) before inserting the chart.
b. Format the chart with the title “Education and Unemployment” at the top.
c. Display each education level on the horizontal axis. Note: if you have selected the education levels and unemployment data before inserting the chart, this will likely already be the case.
d. Do not show the legend.
e. Show data labels on the top of each of the “columns” of the graph.
f. Place the top left corner of the chart over the specified range of the worksheet.
2. Apple
The “Apple Revenue” table details the revenue for Apple in each quarter from 2014-2018.
2.1
Construct a stacked column chart to compare the revenue totals for each year.
a. Select the range for the years, the four quarters, and the sales data in each of the quarters (B3:G7)
b. Do not include the total revenue range in the chart (B8:G8).
c. Format the chart with the title “Apple Revenue by Quarter”.
d. Use the year as the horizontal axis. Note: this will likely already be the case if you have selected the correct range before inserting the chart.
e. Display the quarterly revenues “stacked” in each column.
f. Add a legend that depicts each quarter.
g. Place the top left of the chart over the specified range in the worksheet.
3. PC Shipments
The growth in Worldwide PC shipments was driven by demand created by the Windows 10 refresh in the business market. The table on the PC Shipments worksheet details shipments from several PC manufacturers (in thousands) to PC retailers and customers in the second quarters of 2018 and 2019.
3.1
Construct a pie chart to compare the shipment totals for each company (and “Others”) in the second quarter of 2019.
a. Select the range for each company (B3:B8) and the 2019 sales data (C3:C8) before inserting the chart.
b. Format the chart with the title “PC Shipments 2Q 2019”.
c. Display a legend that depicts each company. Note: this will likely already be the case if you have selected an appropriate range before inserting the chart.
d. Include data labels with the percentage for each company on the chart.
e. Place the top left of the chart over the specified range in the worksheet.
3.2
Construct a pie chart to compare the shipment totals for each company (and “Others”) in the second quarter of 2018.
a. Select the range for each company (B3:B8) and the 2018 sales data (D3:D8) before inserting the chart.
b. Format the chart with the title “PC Shipments 2Q 2018”.
c. Display a legend that depicts each company. Note: this will likely already be the case if you have selected an appropriate range before inserting the chart.
d. Add data labels with the percentage for each company on the chart.
e. Place the top left of the chart over the specified range in the worksheet.
4. Utah Population
The population of Utah is growing rapidly. Net migration contributed 33% of Utah’s population growth since 2010. The Utah Population table details the estimated population for each county in Utah for each year from 2010 to 2019.
Complete the tasks to look for trends or patterns in the population growth in the state.
4.1
Construct a line chart to examine the “State Total” growth (row 11 of the worksheet) for the years 2010-2019.
a. Select the range for the years and the state population totals (B10:L11) before inserting the chart.
b. Format the chart with the title “Total Utah Population”.
c. Display a legend to the right of the chart.
d. Use the dates in row 10 of the worksheet as the labels for the horizontal axis. Note: this will likely already be the case if you select an appropriate range before inserting the chart.
e. Place the top left corner of the chart over the specified range in the worksheet.
4.2
Construct a line chart to compare the population growth for the years 2010-2019 in the following counties: Davis, Salt Lake, Utah, and Weber.
a. Notice the smaller data table (range B3:L7) to be used for creating this chart. Cells B4:B7 contain drop-down lists that can be used to easily change the county population data presented in the table.
b. Select this range before inserting the chart.
c. Format the chart with the title “Population in Selected Counties”.
d. Display a legend.
e. Use the dates in row 2 of the worksheet as the labels for the horizontal axis. Note: this will likely already be the case if an appropriate range is selected before inserting the chart.
f. Place the top left corner of the chart over the specified range in the worksheet.

Post navigation

Leave a Reply

Your email address will not be published.