excel project and need support to help me learn.
Requirements: ONE DAY
New Perspectives Excel 2019 | Module 2: End of Module Project 1
First Mittagong Community Bank
Formatting Workbook Text and Data
Open the file NP_EX19_EOM2-1_FirstLastName_1.xlsx, available for download from the SAM website.
Save the file as NP_EX19_EOM2-1_FirstLastName_2.xlsx by changing the “1” to a “2”.
If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
With the file NP_EX19_EOM2-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
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.
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 the range A2:D2. Apply the FM Subheading cell style to the merged cell.
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). (Hint: For International users, use the U.S. based format d-mmm-yy.)
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.
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.
In the range B7:B18, apply the Percentage number format with two decimal places, then copy this format to the range D7:D18.
In the range C7:C18, apply the Number number format, then increase the decimals to show three decimal places.
Change the background color of the range A7:D9 to Green, Accent 6, Lighter 80% (10th column, 2nd row of the Theme Colors palette).
Copy the formatting of the range A7:D9, then paste the formatting in the range A13:D15.
In the range A6:D18, add a border around all cells using the All Borders option.
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.
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.
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 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).
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
Final Figure 1: Mortgage Worksheet
Final Figure 2: Money Market Worksheet
This question has already been tackled by one of our writers and a good grade recorded. You can equally get high grades by simply making your order for this or any other school assignment that you may have.
Every Student Buys Essays from us, here is why!
Pressed for time to complete assignments or when you feel like you cannot write, you can purchase an
essay on our website. Some students also want model papers to use as samples when revising or
writing. There are also students who approach our essay writing service to beat deadlines. We handle
every type of homework, assignment, and academic writing tasks. You can buy college essays and other
assignments here. At a glance, here are some reasons students prefer our website.
100% Original Essays and Papers
You can be sure that you are getting a paper that is custom written based on your instructions. We do
not sell papers that are pre-written. Instead, we write every essay from scratch. When you say “write my
essay,” we respond by giving you a paper that is 100% original and free of any plagiarism. The essays you
purchase from us have never been sold anywhere.
Flexible & Affordable Prices
It does not cost a fortune to get academic writing help on our website. If you have a question from class,
place an order, get a discount, and get cheap essay writing services. What you see as the price is what
you pay for. There are no any hidden charges. If you need urgent papers, they might cost a little more,
but the price is worth the quality you get in the end. Hire a professional academic writer beginning from
$13 a page.
Anonymity, Privacy, and Confidentiality
No one will ever know that you purchased an essay or assignment from our website. The essays you buy
from us are written by experts. Your data is only used to coordinate the essay writing services you get.
No one can access your personal information and data. Go ahead and order an essay from our website.
It is safe, secure, and convenient.