New Perspectives Excel 2019 | Module 2: End of Module Project 1 #newperspectives #module2 #eom1
If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
[ Ссылка ]
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
1. "Titus Allison is a loan officer with First Mittagong Community Bank. Titus is adding formatting to the workbook he uses to track interest rates to increase its usability.
Change the theme of the workbook to Office."
Change the workbook theme.
2. Switch to the Mortgage worksheet, then format the headings. Merge and center the range A1:D1. Apply the FM Heading cell style to the merged cell.
Merge and center a range.
Apply a cell style.
3. Merge and center the range A2:D2. Apply the FM Subheading cell style to the merged cell.
Apply a cell style.
Merge and center a range.
4. Format the effective date information. For the range A4:B4, apply the Note cell style. For cell A4, apply italic to the text and align right. For cell B4, change the date format to day-month-year (e.g., 21-Nov-21).
Apply a cell style.
Change the font style.
Change the number format.
Align cell content horizontally.
5. Format the mortgage rate table. For the headings in A6:D6, center and bold the text, then change the font color to Blue-Gray, Text 2 (4th column, 1st row of the Theme Colors palette). Merge and center the range A7:A9.
Align cell content horizontally.
Change the font style.
Change the font color.
Merge and center a range.
6. Copy the formatting of the merged cell in the range A7:A9, then paste the formatting in the range A10:A18 to create three more merged cells.
Copy and paste formatting.
7. In the range B7:B18, apply the Percentage number format with two decimal places, then copy this format to the range D7:D18.
Copy and paste formatting.
Change the number format.
8. In the range C7:C18, apply the Number number format, then increase the decimals to show three decimal places.
Change the number format.
Update the number of decimal places.
9. Change the background color of the range A7:D9 to Green, Accent 6, Lighter 80% (10th column, 2nd row of the Theme Colors palette).
Change the fill color of a range.
10. Copy the formatting of the range A7:D9, then paste the formatting in the range A13:D15.
Copy and paste formatting.
11. In the range A6:D18, add a border around all cells using the All Borders option.
Add a border to a cell/range.
12. Switch to the Money Market worksheet. For the range A1:D1, merge and center the contents and apply the custom cell style FM Heading. For the range A2:D2, merge and center the contents and apply the custom style FM Subheading.
Merge and center a range.
Merge and center a range.
Apply a cell style.
Apply a cell style.
13. Copy the content and formatting from the range A4:B4 in the Mortgage worksheet, then paste them on the range A4:B4 in the Money Market worksheet.
Copy and paste formatting.
14. To format the money market rate table, for the range B7:B11, apply the Currency number format with two decimal places, then repeat for the range C7:C10. For the range D7:D11, apply the Percentage number format with two decimal places.
Change the number format.
Update the number of decimal places.
Change the number format.
Update the number of decimal places.
Change the number format.
Update the number of decimal places.
15. Change the tab color of the Mortgage worksheet to Purple (10th column of the Standard Colors palette). Change the tab color of the Money Market worksheet to Dark Red (1st column of the Standard Colors palette).
Change the color of a worksheet tab.
Change the color of a worksheet tab.
new perspectives excel 2019 module 2 end of module project 1,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 | module 7: end of module project 1,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 module 3 end of module project 1,module 1: end of module project 1,new perspectives excel 2019
