Perform statistical analyses integrated in relevant application software Use nested formulas and functions in a worksheet.
Order Instructions
CO4: Perform statistical analyses integrated in relevant application software Use nested formulas and functions in a worksheet.
CO5: Build a customized Access database with queries, forms and reports.
The scenario:
Note, for WK7 Assignment, upload the MS Excel document with the formulas and functions separately and place the complete MS Excel results (you are to hide all of the address fields and processing fee column and place your MS Excel results in your MS Word Document) in your final MS Word document.
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
For this assignment, you will need the following files:
New blank Excel workbook
Facilities_Data
Educational_Report
You 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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
