Order from us for quality, customized work in due time of your choice.
Instructions
In this assignment you will use and apply the following features of Excel (in addition to what you learned in previous module): Date function, formatting text and use of the Painter, Indent within a cell, Relative and Absolute cell reference in formulas, the IF statement, Sparklines, and a clustered column chart.
As you work on this assignment, it is important to follow the steps outlined below. You will be referencing instructions from the textbook as well as additional ones listed below:
Download Eight-Year Financial Projection Instructions.
After reading the instructions, follow steps 1 through 13. When saving the file, add your last name in the filename given in the instructions.
Based on the data in the completed worksheet, design a clustered column chart. Be sure to include chart title, show legends and appropriate axis titles. Move the chart to a new sheet labeled Clustered Chart.
Do steps 14 and 15.
When saving the file, add your last name in the filename given in the instructions.
In addition in the Word document and explain two more Goal Seeking scenarios that can be done using the 8-year financial data.
Save the Word document as Lastname-Mod2.
Submit the two Excel files and the one Word file here.
Order from us for quality, customized work in due time of your choice.