Prepare a doughnut chart showing total liabilities, total common stock, and total retained earnings as components of total liabilities plus stockholders' equity. Hint: Highlight the data set and open the Insert tab. Click on the Pie icon in the Charts group and click on Doughnut.

Display a percentage label in each section of your chart. Hint: Right$-$click inside the doughnut, select Format data labels, select Percentage. Deselect Value if necessary.

List the formula for the chart data range. Hint: Click inside the chart. Open the Chart Design tab and click Select Data. The formula is in the Chart data range field.

List the percentage amount $($or combination of percentage amounts$)$ on the doughnut chart that reflect the stockholders' equity proportion.

Stockholders' equity proportion:

$\%$

$6.$ List the larger percentage: the total liabilities proportion or the total equity proportion of the pie chart.

$\%$

List the percentage amount $($or combination of percentage amounts$)$ on the doughnut chart that reflect the total assets proportion.

Total assets proportion

$\%$

List the dollar amount of total assets.

Total assets: $

A$)$

Cambridge

DA$2-3$ Preparing Basic Data Visualization in Excel Using a Doughnut Chart

The Excel file associated with this exercise indudes total liabilities, common stock, and retained earnings balances as of December $31$ for Monona inc. We will prepare data visualizations focusing on how these amounts relate to one another and how the relations can be expressed through proportions.

Required

Save the Excel file DA$2-3$

Prepare a doughnut chart showing total liabilities, total common stock, and total retained earnings as components of total liabilities plus stockholders' equity. Hint: Highlight the data set and open the Insert tab. Click on the Pie icon in the Charts group and click on Doughnut.

Display a percentage label in each section of your chart. Hint: Right$-$click inside the doughnut, select Format dato labels, select Percentoge. Deselect Value if necessary

Lst the formula for the chart data range. Hint: Click inside the chart. Open the Chart Design tab and click Select Data. The formula is in the Chart data range field.

List the percentage amount $($or combination of percentage amounts$)$ on the doughnut chart that reflect the stockholders' equity proportion.

List the larger percentage: the total liabilities proportion or the total equity proportion of the pie chart.

List the percentage amount $($or combination of percentage amounts$)$ on the doughnut chart that reflect the total assets proportion.

List the dollar amount of total assets.

 

Answer rating: 100% (QA)

To create the doughnut chart and answer the questions based on the provided information Ill guide you through the steps and calculations However pleas... View the full answer