In Practice 365 Integrated Capstone Project 6 Part C - Word
SIMnet Word project instructions
· Excel Projects Help
In Practice 365/2024 Integrated Capstone Project 6 Part C - Word Steps to complete this project:
Mark the steps as checked when you complete them.
1.Open the PHRE-ClientLetter-ICP-6c Word document start file.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
2.Enable content in the security warning.
3.Open the InterestRates Excel-ICP-6b Excel workbook file that you created in Part B of the Integrated Capstone Project 6.
4.Copy tables from Excel and paste them into Word.
5.Return to the Excel workbook, filter the table by ListingAgentNumber so it displays only agent number 168, and copy the table (including the column headings).
6.Return to the open Word document and use Ctrl+V to paste the copied table on the blank line below the “Kallyn Duarte’s Home Listings” heading on the second page of the document.
7.Return to the Excel workbook, filter the table by ListingAgentNumber so it displays all agents other than number 168, and copy the table (including the column headings).
8.Return to the open Word document and use Ctrl+V to paste the copied table on the blank line below the “Other PHRE Home Listings” heading.
9.Format the tables in the Word document.
10.Delete the ListingAgentNumber column from each of the two tables in the Word document.
11.Select the first table.
12.Change the font size to 9 pt. and AutoFit Window to resize the width of the table.
13.Apply the Grid Table 4–Accent 3 table style and select the Header Row and Banded Rows table style options (all other options should be deselected).
14.Select the first row of the table, change the font color to Black, Text 1, and use the Table Properties dialog box to change the cell vertical alignment to Bottom (don’t change the horizontal alignment).
15.Select the second and remaining rows of the table and use the Table Properties dialog box to change the cell vertical alignment to Center (don’t change the horizontal alignment).
16.Add a space between “Date” and “Listed” ” in the first column heading and “List” and “Price” in the second column heading.
17.Select the second table and repeat steps 6c-g.
18.Edit the addresses in each table and spell out Road, Court, and Drive.
19.Delete the blank line below each of the tables.
20.Copy a chart from an Excel worksheet and paste it into Word.
21.Return to the Excel workbook and clear the filter on the ListingAgentNumber field.
22.Display the InterestRates worksheet.
23.Select and copy the chart.
24.Return to the open Word document and paste (Use Destination Theme & Embed Workbook option) the copied chart on the blank line below the “Historic 30-Year Interest Rates” heading on the second page of the document.
Center the chart horizontally.
25.Select the Series “Points” line in the chart and delete it.
26.Select the Series “Rates” Data Labels and change the font color to Green, Accent 6, Darker 50%.
27.Select the Series “Rates” line and change the line color to Green, Accent 6. Use the Format Data Series pane to apply formatting to this data series line.
28.Select the Horizontal (Category) Axis labels and change the font color to Green, Accent 6, Darker 50% and apply bold format.
29.Save the Word document and leave it open (Figure 4).
Images
Figure 4ICP 6c completed
30.Upload and save your completed PHRE-ClientLetter-ICP-6c Word document.
31.Submit project for grading.
IMPORTANT: This is Part C of a 4-part project. After completing this part, go to the project: In Practice 365/2024 Integrated Capstone Project 6 Part D.