Module3 Project -Part 2: IMPORTANT NOTE: Before you begin Module 3 Project -Part 2 you are REQUIRED to review my feedback from theModule 3 Project – Part 1. If you made any mistakes and points were deducted,you will need to fix these mistakes following the feedback provided. It is important that thework you completed in Module 3 Project – Part 1 is updated to reflect theinstructor feedback provided before beginning Module 3 Project – Part 2! If you do notupdate your work, you will lose a majority of the activities points! If you donot understand my feedback or you cannot find your mistakes, reach out to me!
For Module 3 Project -Part 2, you will continue with the second part of the module. You will readpages (EX 3-39 ~ Adding a Clustered Column Chart to the WorkbookSection through EX 3-60 ~ Summary Section) and you will learn how toperform basic workbook tasks using Excel. General activities you will performas you progress through Module 3 Project – Part 2 will be:
- creating a clustered column chart
- changing the worksheet view
- answering what-if questions
- using goal seek
- using Smart Lookup
TIPTIME:The finished workbook should include 4 worksheets.
NOTE 1: Work through “To Preview and Print theWorksheet” section but DO NOT PRINT.
NOTE 2: When you get to EX 3-55 (“What-If Analysis” section),you will create a copy of the Six-Month Financial Projection worksheet(right-click, select Move or Copy.., select the Six-Month FinancialProjection worksheet, check the Create a copy box, click OK). You willmove the copied worksheet to the end and you will rename it What-If Analysis.You will then complete the What-If Analysis steps (3-55 through 3-56) usingthis copied worksheet and you will save the workbook as required. HINT: Operating Income = $3,042,257.75
NOTE3: When you get to EX3-56 (“Goal Seeking” section), you will create a copy of the What-IfAnalysis worksheet (right-click, select Move or Copy.., select the What-IfAnalysis worksheet, check the Create a copy box, click OK). You will movethe copied worksheet to the end and you will rename it Goal Seek. You willthen complete the Goal Seek steps (3-56 through 3-58) using this copiedworksheet and you will save the workbook as required. HINT: Operating Income = $3,500,000.00 AND SiteRental = 4.14%
NOTE 4: Update the author (use your name) and title(use ‘Student’) in the document properties.
NOTE 5: Reorder worksheets (1) Six-Month FinancialProjection, (2) What-If Analysis, (3) Goal Seek, (4) Expense Chart Sheet
Once you complete allsteps of Module 3 (EX 3-39 ~ Adding a Clustered Column Chart to the WorkbookSection through EX 3-60 ~ Summary Section), you will upload your assignment asa Microsoft Excel workbook using the following namingprotocol: LastnameFirstnameMod3PT2.xlsx
NEED ASSIGNMENT HELP?
We guarantee plagiarism-free and AI-free writing services. Every assignment is crafted with originality, precision, and care to meet your academic needs.
Ready to get started? Place your order directly on this post!
Let us help you achieve excellence—authentic work, every time.


Leave a Reply