USA: +1(669)289-8683 
Sign in
I need someone to do the below assignments, they are pretty easy i was
able to do majority of them in anywhere between 10-30 minutes not
having a clue about what i was doing. Attached is a PDF of the book. If
you are able to do these and get a good grade i have 2 more projects
that i would like done if you are willing.
There are data files that go with each of these assignments so a good
chunk of it is already setup for you.
Below is a dropbox link to the book in PDF format…
https://www.dropbox.com/s/2eyf12hgbv3jmx5/New%20Perspectives%20on%20Microsoft%20Excel%202010%20Comprehensive
Here is a dropbox link to the data files…
https://www.dropbox.com/sh/24hij3u0lff4o0h/HA9YTlylIs
Due the night of November 12th… PST
Tutorial 10, Case Problem 2, pgs 609-610
In step 5, cells B5 and B4 are reversed. B5 should be the row input
cell and B4 should be the column input cell.
DUE NOVEMBER 17TH
Tutorial 11, Sessions 11.1, 11.2 and 11.3, pgs 613-674
Page 637: Steps 1-4 on the bottom of the “To connect to an Access data
source” section may not work correctly if you are in the classroom or
another networked location. If not, use the following steps instead:
1. Click New Data Source in the Choose Data Source dialog box.
2. Verify that the Use the Query Wizard to create/edit
queries check box is checked, and then click the OK button. The Create
New Data Source dialog box opens.
3. In the Create New Data Source dialog box enter the following:
1) Give a Name = Horizons
2) Select a Driver = Microsoft Access Driver (.mdb, .accdb)
3) Click Connect button
4) Click Select button
4. Navigate to the Horizons database on your USB, and then click
the Horizons.accdb file in the Database Name box and click OK.
5. Click OK three more times.
6. Screen should look like Figure 11-19 on page 638.
7. Continue with Step 1 at the bottom of page 638.
DUE NOVEMBER 24TH
Submit To Be Scored:
Appendix C, Bright Light Case Problem
The Bright Light Case Problem is not in your textbook. Complete this
Case problem using the instructions listed below.
Documentation
Mortgage
Analysis
Mortgage
| Mortgage Analysis | |
| Loan Amount | $250,000 |
| Interest Rate | 5.50% |
| Years | 30 |
| Term (Months) | 360 |
| Monthly Payment | ($1,419.47) |
| Total | ($511,010.10) |
Self-Check And Submit:
Appendix C – Integrating Excel with other Office Applications,
pgs EX C21 – EX C27 only
Complete only the small section towards the end of Appendix C that begins with “Integrating Excel with other Office Applications”. Do not complete the rest of Appendix C on Creating a Shared Workbook. Submit the Memo Destination Word document and the Income Statement Source workbook
Submit To Be Scored:
Appendix C, Bright Light Case Problem
The Bright Light Case Problem is not in your textbook. Complete this Case problem using the instructions listed below.
Begin and Submit to the Final Project Dropbox when complete:
Final Project – Tutorial 8, Case Problem 4, pgs 482-485
This project will comprise 20% of your grade. Please do not wait to begin this project until the last minute. It is a comprehensive assignment and will take a fair amount of time to complete. Double check your final product to make sure it is professional looking and error-free before turning it in. You will submit the following documents from the Alia’s Senior Living workbook: Documentation sheet, Invoice, Invoice formulas and Product Pricing and Shipping sheet.
In step 4o, the best solution for the shipping cost is an IF Function with a nested vlookup (the IF checks if the subtotal is >=200 and thevlookup references the shipping cost table).
Bright Light Case Problem
Data files needed for this Case Problem:
Usage.xlsx and Request x
Problem: Peter Skinner is writing a letter to the state government to report on the shelter and meal programs used at Bright Light. He has data in an Excel workbook and needs to incorporate the data into the letter he is composing in Word. Because the report will also include projections for the upcoming year, which he might modify, Peter wants to create a link between the information in the Excel workbook and the Word document. He also wants to embed in the Word document a chart that he has created in his workbook. He asked you to help link the two files.
Complete the following:
1. Open the Usage workbook located in the Appendix C misc folder, and then save it as Bright Usage.
2. In the Documentation sheet, enter the date and your name, and then switch to the Shelter Usage worksheet.
3. Open the Request document located in the Appendix C misc folder, and then save it as Bright Request.
4. Return to the Bright Usage workbook, and then copy the range A2:G9 in the Shelter Usage workbook.
5. Return to the Bright Request document, and then paste the selected range as a link below the first paragraph of Peter’s letter.
6. Peter discovered that the number of client days in the domestic abuse shelter in December 2010 was actually 75, not 72. Make this change in the Bright Usage workbook, and then verify that the Bright Request document is automatically updated.
7. Copy the Projected Usage chart from the Shelter Usage worksheet, and then embed the chart below the second paragraph in Peter’s letter (do not link the chart).
8. Edit the embedded chart, changing the background color of the plot area from yellow to white.
9. Save and close the Bright Request and Bright Usage files. Print and submit the finished workbook to your instructor.
January 25, 2012
Ann Magee
Assistant Financial Administrator
State Dept. of Social Services
1 East Central Ave.
Atlanta, PA 66601
Dear Ms. Magee:
Thank you for your inquiries about The Bright Light. I am enclosing a complete usage report for 2010. As the following summary table indicates, we have seen increased use of the shelter in the second half of the year. Even if we take into account our severe winter, the shelter is being used at a greater rate than in any previous year.
Our analyst has projected shelter usage for the next two fiscal years. Based on those projections, The Bright Light will need to start expanding its space within the next two years, or we will have to start sending people to other facilities. Currently, the closest facility is located 30 miles away in the town of Three Points. For many of our clients, this would not be a practical alternative.
I hope this material helps you in organizing budget priorities for the next state budget. Please let me know if you need any more information.
Regards,
Peter Skinner
Financial Director
The Bright Light
D
ocumentation
B
right Light
A
uthor
Projected
usage on shelter and meals program
Shelter Usage
The
Usage Figures for
2
0
1
0*
Single Rooms (
5
) 11
8
1
10
10
4
10
6
10
3
C
ommon Room 1 (15 max)
41
9
7
2
9
Client Days
13750
13750
13750
13750
13750
13750
13750
14,
13750
13750
Projected Usage
Client Days 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 10371
38 11311 11787 12142 12617 13246 13875 14104 14545 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 13750 13750 13750 13750 13750 13750 13750 13750 13750 Year
Total Client Days
Projected
1
2
3
4
5
6
7
8
9
10
A
B
C
D
Dec
Nov
Oct
110
112
448
434
Common Room 2 (15 max)
432
436
412
Domestic Abuse Shelter (3)
87
81
Total Client Days
1070
1052
* Figures represent total occupancy for each month.
