GETTING STARTED
 Save the file SC_EX365_2021_EOM3-1_FirstLastName_1.xlsx as
SC_EX365_2021_EOM3-1_FirstLastName_2.xlsx
 Edit the file name by changing “1” to “2”.
 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.
 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.
10. Cashman Excel 365/2021 | Module 3: End of Module Project 1 10. In cell C12, insert a formula that divides the total orders for August (cell C9) by
11. the total number of orders (cell I9). Use an absolute reference to cell I9, and
12. then copy the formula to the range D12:G12.
13. In cell H15, insert a Column sparkline based on the data in the range C15:G15.
    Display the High Point and Low Point in the sparkline, and then fill the range
    H16:H23 without formatting based on the sparkling in cell H15.
14. Copy the formula in cell I15 and then paste only the formula in the range
    I16:I23.
15. Change the chart in the range J10:O23 to a Pie chart. Enter Average Orders
    per Month as the chart title. Add data labels to the outside end of each slice.