Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ayout References Mailings Review View Help t can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Grader
ayout References Mailings Review View Help t can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Grader - Instructions Excel 2016 Project Points Step Instructions Possible 25 Create a 2-D Line chart that compares the stagnant profits to the estimated profits for each of 9 Include the year labels in the chart data. Position the chart to fit within the shaded area of G9:N20. Make the following changes: Apply Style 13 to the chart Move the Legend to the bottom Add a primary vertical axis title of Annual Profits Edit the Chart Title to read Estimated and Stagnant Profit Trajectories 26 Change the fill color of all uncertain variables (B10 and H4:N4) to Green, Accent 6. 27 Change the fill color of all input variables (B2:B3 and B6) to Orange, Accent 2. 28 Change the fill color of all decision variables (B7 and E8) to Blue, Accent 5 N Insert a comment into the output cell of H7 that reads: Output - Total additional profits earned post renovation. Must be > than total cost of loan. Be sure to include the period at the end and remove any name or initials that may appear at the start of the comment. 30 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as 0 directed. Total Points 100 Focus W T X 20% X C F5 F6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started