Highlight the data in column B, the 2nd column next to year column., the Revenue ($m) data. Then create a Column Chart illustrating the Revenue ($m) data. Year Revenue ($ million) IVA ($ million) Establishments (Units) Enterprises (Units) Employment (Units) Wages ($ million) Corporate profits ($ billion) 2002 19429.1 11352.6 16633.0 15452.0 349652.0 10095.2 1124.9 2003 19200.9 11385.2 16638.0 15413.0 395140.0 10086.6 1279.5 2004 19787.6 12425.6 16932.0 15686.0 403789.0 11088.0 1520.9 2005 20294.5 12541.8 16835.0 15649.0 394396.0 11162.6 1703.0 2006 21337.1 13678.0 19024.0 17841.0 397106.0 11687.3 1827.9 2007 21578.0 14071.1 24087.0 22741.0 404551.0 12266.9 1657.8 2008 21953.0 12777.7 23113.0 21907.0 446480.0 11543.4 1363.7 2009 21737.9 12508.1 22827.0 21598.0 449850.0 11430.2 1459.8 2010 20628.1 13236.7 22578.0 21368.0 412348.0 11881.0 1798.8 2011 21082.2 13314.9 22817.0 21619.0 422687.0 12200.7 1844.6 2012 22140.3 14792.9 24514.0 23280.0 454038.0 13202.2 1997.4 2013 21923.1 13748.2 24656.0 23413.0 442853.0 12272.4 1976.1 2014 22605.0 14571.2 24676.0 23449.0 453950.0 12962.2 2045.9 2015 22737.7 14646.0 24377.0 23123.0 468178.0 13281.4 1969.4 2016 24781.8 15400.8 25060.0 23781.0 474398.0 13526.5 1914.2 2017 23695.8 15508.0 28748.0 27329.0 485429.0 13852.4 1963.3 2018 25675.2 15931.3 31834.0 30078.0 483075.0 13861.7 2033.7 2019 23809.7 15533.4 33132.0 31324.0 465249.0 13864.4 2004.7 2020 24038.4 14989.3 34801.0 32886.0 450401.0 13662.6 1869.2 2021 25378.0 15736.2 36458.0 34454.0 470934.0 14389.3 2071.5 2022 25906.8 16369.0 37765.0 35738.0 481664.0 14741.5 2125.2 2023 26326.5 16682.3 39008.0 36984.0 491176.0 15046.0 2141.8 2024 26688.8 16954.4 40292.0 38250.0 499615.0 15314.9 2151.2 2025 27087.7 17342.8 41656.0 39538.0 508624.0 15604.5 2185.4 2026 27467.3 17713.4 43100.0 40915.0 517804.0 15895.5 2207.0 2027 27877.2 18027.6 44487.0 42259.0 527231.0 16198.1 2239.1 Use the Excel formula to calculate the Average for each column of data within the sheet. Add this information to the bottom of each column. Use Excel to calculate the Sum for each column of data within the sheet. Add this information below the row of Averages for each column. Change the name of this Tab to Revenue Growth.

Highlight the data in column B, the 2nd column next to year column., the Revenue ($m) data. Then create a Column Chart illustrating the Revenue ($m) data. Year Revenue ($ million) IVA ($ million) Establishments (Units) Enterprises (Units) Employment (Units) Wages ($ million) Corporate profits ($ billion) 2002 19429.1 11352.6 16633.0 15452.0 349652.0 10095.2 1124.9 2003 19200.9 11385.2 16638.0 15413.0 395140.0 10086.6 1279.5 2004 19787.6 12425.6 16932.0 15686.0 403789.0 11088.0 1520.9 2005 20294.5 12541.8 16835.0 15649.0 394396.0 11162.6 1703.0 2006 21337.1 13678.0 19024.0 17841.0 397106.0 11687.3 1827.9 2007 21578.0 14071.1 24087.0 22741.0 404551.0 12266.9 1657.8 2008 21953.0 12777.7 23113.0 21907.0 446480.0 11543.4 1363.7 2009 21737.9 12508.1 22827.0 21598.0 449850.0 11430.2 1459.8 2010 20628.1 13236.7 22578.0 21368.0 412348.0 11881.0 1798.8 2011 21082.2 13314.9 22817.0 21619.0 422687.0 12200.7 1844.6 2012 22140.3 14792.9 24514.0 23280.0 454038.0 13202.2 1997.4 2013 21923.1 13748.2 24656.0 23413.0 442853.0 12272.4 1976.1 2014 22605.0 14571.2 24676.0 23449.0 453950.0 12962.2 2045.9 2015 22737.7 14646.0 24377.0 23123.0 468178.0 13281.4 1969.4 2016 24781.8 15400.8 25060.0 23781.0 474398.0 13526.5 1914.2 2017 23695.8 15508.0 28748.0 27329.0 485429.0 13852.4 1963.3 2018 25675.2 15931.3 31834.0 30078.0 483075.0 13861.7 2033.7 2019 23809.7 15533.4 33132.0 31324.0 465249.0 13864.4 2004.7 2020 24038.4 14989.3 34801.0 32886.0 450401.0 13662.6 1869.2 2021 25378.0 15736.2 36458.0 34454.0 470934.0 14389.3 2071.5 2022 25906.8 16369.0 37765.0 35738.0 481664.0 14741.5 2125.2 2023 26326.5 16682.3 39008.0 36984.0 491176.0 15046.0 2141.8 2024 26688.8 16954.4 40292.0 38250.0 499615.0 15314.9 2151.2 2025 27087.7 17342.8 41656.0 39538.0 508624.0 15604.5 2185.4 2026 27467.3 17713.4 43100.0 40915.0 517804.0 15895.5 2207.0 2027 27877.2 18027.6 44487.0 42259.0 527231.0 16198.1 2239.1 Use the Excel formula to calculate the Average for each column of data within the sheet. Add this information to the bottom of each column. Use Excel to calculate the Sum for each column of data within the sheet. Add this information below the row of Averages for each column. Change the name of this Tab to Revenue Growth.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 9BE

See similar textbooks

Related questions

Question

Highlight the data in column B, the 2nd column next to year column., the Revenue ($m) data. Then create a Column Chart illustrating the Revenue ($m) data.

Year	Revenue ($ million)	IVA ($ million)	Establishments (Units)	Enterprises (Units)	Employment (Units)	Wages ($ million)	Corporate profits ($ billion)
2002	19429.1	11352.6	16633.0	15452.0	349652.0	10095.2	1124.9
2003	19200.9	11385.2	16638.0	15413.0	395140.0	10086.6	1279.5
2004	19787.6	12425.6	16932.0	15686.0	403789.0	11088.0	1520.9
2005	20294.5	12541.8	16835.0	15649.0	394396.0	11162.6	1703.0
2006	21337.1	13678.0	19024.0	17841.0	397106.0	11687.3	1827.9
2007	21578.0	14071.1	24087.0	22741.0	404551.0	12266.9	1657.8
2008	21953.0	12777.7	23113.0	21907.0	446480.0	11543.4	1363.7
2009	21737.9	12508.1	22827.0	21598.0	449850.0	11430.2	1459.8
2010	20628.1	13236.7	22578.0	21368.0	412348.0	11881.0	1798.8
2011	21082.2	13314.9	22817.0	21619.0	422687.0	12200.7	1844.6
2012	22140.3	14792.9	24514.0	23280.0	454038.0	13202.2	1997.4
2013	21923.1	13748.2	24656.0	23413.0	442853.0	12272.4	1976.1
2014	22605.0	14571.2	24676.0	23449.0	453950.0	12962.2	2045.9
2015	22737.7	14646.0	24377.0	23123.0	468178.0	13281.4	1969.4
2016	24781.8	15400.8	25060.0	23781.0	474398.0	13526.5	1914.2
2017	23695.8	15508.0	28748.0	27329.0	485429.0	13852.4	1963.3
2018	25675.2	15931.3	31834.0	30078.0	483075.0	13861.7	2033.7
2019	23809.7	15533.4	33132.0	31324.0	465249.0	13864.4	2004.7
2020	24038.4	14989.3	34801.0	32886.0	450401.0	13662.6	1869.2
2021	25378.0	15736.2	36458.0	34454.0	470934.0	14389.3	2071.5
2022	25906.8	16369.0	37765.0	35738.0	481664.0	14741.5	2125.2
2023	26326.5	16682.3	39008.0	36984.0	491176.0	15046.0	2141.8
2024	26688.8	16954.4	40292.0	38250.0	499615.0	15314.9	2151.2
2025	27087.7	17342.8	41656.0	39538.0	508624.0	15604.5	2185.4
2026	27467.3	17713.4	43100.0	40915.0	517804.0	15895.5	2207.0
2027	27877.2	18027.6	44487.0	42259.0	527231.0	16198.1	2239.1

Use the Excel formula to calculate the Average for each column of data within the sheet.
Add this information to the bottom of each column.
Use Excel to calculate the Sum for each column of data within the sheet.
Add this information below the row of Averages for each column.
Change the name of this Tab to Revenue Growth.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.