Shelly Cashman Excel 365/2021 | Module 3: End of Module Project 1 | Help in Homework |

24 / 7 Live Support
[e-mail]
[phone]
[phone]
Seven Summits Group
CREATE AN ORDER AND INVENTORY PROJECTION
GETTING STARTED
• Save the file SC_EX365_2021_EOM3-1_FirstLastName_1.xlsx as SC_EX365_2021_EOM3-1_FirstLastName_2.xlsx
o Edit the file name by changing “1” to “2”.
o If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.
• With the file SC_EX365_2021_EOM3-1_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.
o If cell B6 does not display your name, delete the file and download a new copy.
PROJECT STEPS
1. Eugene Park is a senior consultant for the Seven Summits Group, a consulting firm in Denver, Colorado. He is working with HardyFit Tools, a manufacturer of hand tools, to improve their business operations. He has created a workbook projecting the company's orders and inventory, and asks for your help in completing and formatting the projections.
Go to the Orders worksheet. Rename the Orders worksheet to use Orders and Inventory as the worksheet name.
2. Unfreeze the top 2 rows of the worksheet, and then middle-align the contents of the merged cell A1.
3. Cut the contents of cell K2 and paste them in cell A2. In cell B2, insert a formula that uses the NOW function to display today's date.
4. Merge and center the range A3:A9. Rotate the text up to 90 degrees in the merged cell, and then change the width of column A to 5.00.
5. Copy the formatting from the range B5:K5 and apply it to the range B7:K7.
6. In cell B8, decrease the indent by one level. Copy the values in the range C26:G26, and then paste only the values in the range C8:G8. Delete row 26 to remove the repeated data.
7. Use Goal Seek to set cell C11 to the value of 300 by changing cell C7.
8. In cell H4, insert a Line sparkline based on the data in the range C4:G4. Fill the range H5:H9 without formatting based on the contents of cell H4. Change the color of the sparklines in the range H4:H9 to Gold, Accent 6, Darker 25% (10th column, 5th row of the Sparkline Theme Colors gallery). Add markers for each month, and then change the marker color to Green, Accent 4, Darker 50% (8th column, 6th row of the Sparkline Theme Colors gallery).
9. Copy the formula in cell K4 and then paste the formula and number formatting in the range K5:K8.