Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help solving , step by step. Calibri (Body - A A Wrap Test General Ittle lililo 298 Pite BTU- A Merge & Center inst IH

help solving , step by step.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Calibri (Body - A A Wrap Test General Ittle lililo 298 Pite BTU- A Merge & Center inst IH $ % 9 Conditional Format Formatting Table Styles Dell F21 x fe H 1 Responsibility Accounting and Performance Evaluation 7. Un bel for key performance indicates 4 Thaus Solar Company has data for the four divisions for the year, and wants the results for the three pecified key performance indicator (KP 5 Return on investment BRON Antrovertti 6 Division Operating Income Average Total Assets Net Sales Profit Margin Ratie 2 East 5 1650,000.00 12,700,250.00 26,700,000.00 North O 000.00 4,300 000 00 5.76000000 9 South 264,050.00 1,015,290.00 369,870 00 10 West 2.260.000.00 33.240.000,00 9,300,000.00 11 Use the blue shaded areason the INTERANSWERS tab for inputs 2 ALWAYS se cell references and formulas where appropriate to receive all credit. If you copy paste from the instruction tab you will be marked wrong 10 15 Requirements 1 Create an Excel table from the data 7 Rename the table as Soler KPI h. Select another tables for thetable 59 2 Use table arithmetic for the formulas (rounded to three decimal places for 90 Pront Marpin Ratio 21 b. Aset Turnover Ratio 22 Return on investment (ROU 23 Calibri (Body) == = a. Av V v BIU Paste F21 X fx D E A B 3 14 Is Requirements 16 1 Create an Excel table from the data. 17 a. Rename the table as Solar_KPI. 18 b. Select another table style for the table. 19 2 Use table arithmetic for the formulas (rounded to three decimal places) for DO a. Profit Margin Ratio 21 b. Asset Turnover Ratio 22 C. Return on Investment (ROI) 23 24 25 Excel Skills 26 1 Excel tables 27 a. Create an Excel table 28 b. Change the name of an Excel table. 29 c. Change the style of the table. 30 d. Create a calculated column. 31 2 Use the Excel function ROUND to round your answers to three decimal places. 32 33 34 Excel Hints An Excel table will allow you to create the formula once and have it automatically replicate down there 36 1 To create a table from the data: 37 a. Place the cursor anywhere in the data. 38 b. Use CTRL-T to convert data to a table. Confirm the data range for the table. 39 (Alternatively, you can use Insert > Table to create a table.) 40 c. The default table format appears as 41 42 Divan Operating IncomArTotal Arte Net Sales Profit Margin RatAsset Turnoverat East 1,580,000.00 12.000.750.00 25 900 000.00 43 North 650 000.00 4,875 000.00 6337.500.00 44 South 275 050.00 995090.00 855 270.00 West 2.300 000.00 13,800.000.00 45 9.200.000,00 46 Click anywhere in the table to cause the Table Tools Design Tab to appear. 2 Rename the table as Solar_KPI. With the Table Tools Design Tab showing the table name will be 48 Hints 35 32 3 22 30 An Excel table willow you to create the formula once and have it automatically replicate down the row of the table An Deceableheader row.com of God formules 1 To create a table from the 2 Place the crawbere in the data Use CTRL-Toconvert data to a table Confirm the data for the table Alternatively, you can use inertito create the The table format appears as 43 44 45 45 ENG 2 Gick anywhere in the table to cow the Table Tools Design Tab to appear Rename the table as solar K. With the Table Tools Design Tab showing the table name will be on the le-hand side You must contiguous characters for tablenameno File Home 17 43 41 so 51 Table Mane Sca 53 14 4 56 57 58 59 60 with the Table Tosses Tale showing click on the Table Styles drop down to the table style Table Styles is on the right hand side of the tab Create formas rounded to the decimal places In the Profit Marine cell for the East Division, enter the formula by entering the goals, then click in the Operating incomecell for at add a dion then click on the Sed fort and click the interkey Derating income A Total Assets Net Sales Profit Margin Hate 2,580.000.00 12,000 780.00 25,800,000.00 Corting incomall 650.000.00 4.875,000.00 6337,500.00 375050.00 995,000.00 355 270.00 2,800,000.00 23,800,000.00 9,200,000.00 62 25 46 2 Click here in the the folo Design Tutto per Romanethalasso XP Winthee Too Design showing them will be on the let hindi tumhaften 47 File H 19 3 34 35 1 56 57 18 59 60 61 2 1 with the Table Tosli Desprabowing dick on the table drop down to select another table style. Table Styles on the right hand side of the Cateformed to the decimal pice to the Profit Marple Rated for the best Division, ent the formula by entering the equals then dick in the Operating incomecell fastada division then click in the Net Salmafor ne dick the Doing Income Are Told Assets Me Sales Dron Marina 1,580,000.00 12.000, 750.00 25.900,000.00 Original 650.000.00 4.875,000.00 8.337 500.00 225.050.00 995,000.00 855 220.00 2,000,000.00 13.300,000.00 9,200,000.00 5 6 OS ARTA D Pe Mesa Ansel. Turi Lol 1.000.000 2002. GOD 50 Singer 255.000 2.100,000.00 10.000.00 299.00.00 Bamine theme Operating income vienet Salell Thabolismerte, refers to win a table That i the Profit Maria Rutie for the fathe Operating income for fast, died by the sales for nad of cell reference, the formula is using tablertence Notion when you pre the enter key, the formula aplicated down the column Traund the formulari de ROUND Runction to the equation OUND Operating income Sale-3) When you update the formula thechimical replicated down the column 70 1 31 33 19 Calibri (Body - A A Wrap Test General Ittle lililo 298 Pite BTU- A Merge & Center inst IH $ % 9 Conditional Format Formatting Table Styles Dell F21 x fe H 1 Responsibility Accounting and Performance Evaluation 7. Un bel for key performance indicates 4 Thaus Solar Company has data for the four divisions for the year, and wants the results for the three pecified key performance indicator (KP 5 Return on investment BRON Antrovertti 6 Division Operating Income Average Total Assets Net Sales Profit Margin Ratie 2 East 5 1650,000.00 12,700,250.00 26,700,000.00 North O 000.00 4,300 000 00 5.76000000 9 South 264,050.00 1,015,290.00 369,870 00 10 West 2.260.000.00 33.240.000,00 9,300,000.00 11 Use the blue shaded areason the INTERANSWERS tab for inputs 2 ALWAYS se cell references and formulas where appropriate to receive all credit. If you copy paste from the instruction tab you will be marked wrong 10 15 Requirements 1 Create an Excel table from the data 7 Rename the table as Soler KPI h. Select another tables for thetable 59 2 Use table arithmetic for the formulas (rounded to three decimal places for 90 Pront Marpin Ratio 21 b. Aset Turnover Ratio 22 Return on investment (ROU 23 Calibri (Body) == = a. Av V v BIU Paste F21 X fx D E A B 3 14 Is Requirements 16 1 Create an Excel table from the data. 17 a. Rename the table as Solar_KPI. 18 b. Select another table style for the table. 19 2 Use table arithmetic for the formulas (rounded to three decimal places) for DO a. Profit Margin Ratio 21 b. Asset Turnover Ratio 22 C. Return on Investment (ROI) 23 24 25 Excel Skills 26 1 Excel tables 27 a. Create an Excel table 28 b. Change the name of an Excel table. 29 c. Change the style of the table. 30 d. Create a calculated column. 31 2 Use the Excel function ROUND to round your answers to three decimal places. 32 33 34 Excel Hints An Excel table will allow you to create the formula once and have it automatically replicate down there 36 1 To create a table from the data: 37 a. Place the cursor anywhere in the data. 38 b. Use CTRL-T to convert data to a table. Confirm the data range for the table. 39 (Alternatively, you can use Insert > Table to create a table.) 40 c. The default table format appears as 41 42 Divan Operating IncomArTotal Arte Net Sales Profit Margin RatAsset Turnoverat East 1,580,000.00 12.000.750.00 25 900 000.00 43 North 650 000.00 4,875 000.00 6337.500.00 44 South 275 050.00 995090.00 855 270.00 West 2.300 000.00 13,800.000.00 45 9.200.000,00 46 Click anywhere in the table to cause the Table Tools Design Tab to appear. 2 Rename the table as Solar_KPI. With the Table Tools Design Tab showing the table name will be 48 Hints 35 32 3 22 30 An Excel table willow you to create the formula once and have it automatically replicate down the row of the table An Deceableheader row.com of God formules 1 To create a table from the 2 Place the crawbere in the data Use CTRL-Toconvert data to a table Confirm the data for the table Alternatively, you can use inertito create the The table format appears as 43 44 45 45 ENG 2 Gick anywhere in the table to cow the Table Tools Design Tab to appear Rename the table as solar K. With the Table Tools Design Tab showing the table name will be on the le-hand side You must contiguous characters for tablenameno File Home 17 43 41 so 51 Table Mane Sca 53 14 4 56 57 58 59 60 with the Table Tosses Tale showing click on the Table Styles drop down to the table style Table Styles is on the right hand side of the tab Create formas rounded to the decimal places In the Profit Marine cell for the East Division, enter the formula by entering the goals, then click in the Operating incomecell for at add a dion then click on the Sed fort and click the interkey Derating income A Total Assets Net Sales Profit Margin Hate 2,580.000.00 12,000 780.00 25,800,000.00 Corting incomall 650.000.00 4.875,000.00 6337,500.00 375050.00 995,000.00 355 270.00 2,800,000.00 23,800,000.00 9,200,000.00 62 25 46 2 Click here in the the folo Design Tutto per Romanethalasso XP Winthee Too Design showing them will be on the let hindi tumhaften 47 File H 19 3 34 35 1 56 57 18 59 60 61 2 1 with the Table Tosli Desprabowing dick on the table drop down to select another table style. Table Styles on the right hand side of the Cateformed to the decimal pice to the Profit Marple Rated for the best Division, ent the formula by entering the equals then dick in the Operating incomecell fastada division then click in the Net Salmafor ne dick the Doing Income Are Told Assets Me Sales Dron Marina 1,580,000.00 12.000, 750.00 25.900,000.00 Original 650.000.00 4.875,000.00 8.337 500.00 225.050.00 995,000.00 855 220.00 2,000,000.00 13.300,000.00 9,200,000.00 5 6 OS ARTA D Pe Mesa Ansel. Turi Lol 1.000.000 2002. GOD 50 Singer 255.000 2.100,000.00 10.000.00 299.00.00 Bamine theme Operating income vienet Salell Thabolismerte, refers to win a table That i the Profit Maria Rutie for the fathe Operating income for fast, died by the sales for nad of cell reference, the formula is using tablertence Notion when you pre the enter key, the formula aplicated down the column Traund the formulari de ROUND Runction to the equation OUND Operating income Sale-3) When you update the formula thechimical replicated down the column 70 1 31 33 19

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions