Assignment InstructionsThe scenario:The Prime National Properties Group is considering selling some of its educational facilities. The facilities have been tracked in an Access database. Shelly Williams, the President of the company, has asked you to prepare a report. Import the Access data in the file Facilities_Data as a table into Excel. Using the PMT function, calculate the monthly payments the company could expect. The company would charge an 8% rate over 10 years. The result should be a positive number. Mr. Williams also asked you to calculate an extra processing fee for monthly loan payments using the IF function. If a monthly loan payment is less than $6000, the company would charge a processing fee of $150; otherwise, there would be no processing fee. Filter the rows to display only those facilities where there is a $0 processing fee. Hide all of the address fields and the processing fee column. Save the Excel file as Lastname_Firstname_Educational_FacilitiesFor this assignment, you will need the following files: New blank Excel workbook Facilities_Data Educational_ReportYou will save your files as: Lastname_Firstname_Educational_Facilities Lastname_Firstname_Educational_Report Open the Word document Educational_Report, and then save the file as Lastname_Firstname_Educational_Report Add a cover page of your choice, and then complete the content controls on the cover page. In the report, format headings as Level 1 or Level 2, and then insert a table of contents on a new page. In the worksheet, hide all of the address fields and the processing fee column paste the Excel data into the Word document. Add an appropriate heading formatted as Level 1, and then update the table of contents. In each file, insert the your name as a field in the footer
by Classy Writers | Jun 9, 2020 | Education
Assignment InstructionsThe scenario:The Prime National Properties Group is considering selling some of its educational facilities. The facilities…
A professional Academic Services Provider
Superb Writers Classic Essays Prioritizes Quality, Accountability, Professionalism, and Timely Delivery
At Superb Writers, we have qualified experts including writers providing quality papers at all times. The company seeks to aid learners all through the education process while easing their journey. Customer satisfaction is our emblem, and as the name suggests, our customers have a SUPERB experience with us. We purpose to help learners comprehend their classwork and homework to attain high grades. Our writers, editors, managers, customer service personnel are friendly; hence, providing a conducive environment to interact with you; the client. We offer guidance across various tasks including essay wring, article writing, thesis proposals, dissertations, coursework, and project management among others.Our Core Values
1. Professionalism: Our staff are highly trained to accommodate every personality. We handle our clients respectfully, understanding the fact that we are here because of you.
2. High-Quality: As typified by our name, we provide quality services as desired by our clients.
3. Confidentiality We safeguard what we share with our clients; hence, information shared remains confidential.
Assurances
4. Quality Assurance: Our qualified writers are clustered as per their expertise and tasks matched with the respective fields. Moreover, we have the current software to check paper quality; thus, delivering error free products.
5. Money Back Policy: As a client-oriented service, we offer 100% refund for the following: if we received a double payment from you; if you placed similar orders twice (or more) and paid for all of them; the writer has not been assigned; you asked to cancel the order within 20 minutes after placing it; an e-Check payment has been sent (the Dispute Manager will contact you accordingly). Other cases involve a comprehensive investigation by the Dispute Department and feedback given within 24 hours. We value our customers; therefore, the process will be fair, fast, and precise.
5 .Free Revisions: You can request for revisions at no additional cost. However, this does not entail complete change of the initial order instructions and if it is not past ten days upon your approval.
6. 24/7 Customer Support: Our support team is always available to help when needed.
Process of Placing an Order
NOTE: If you have any question, always contact our support team before the commencement of your project. ALL THE BEST”:
Recent Comments