Solution for Portland State University Moving to A New Apartment Budget Worksheet: Excel homework solution

Homeworkslaves.net: Complete Homework Solutions.

Portland State University Moving to A New Apartment Budget Worksheet Homework Assignment Solution

Question:

I’m working on a Excel exercise and need support.
Now you’re ready to try developing your own spreadsheet from scratch. For this project, it may
be helpful to draft out your design on paper and run it by your instructor before you begin your
work in Excel.
Project Setting: You have just moved into a new apartment and will be furnishing it with new
furniture. Your kitchen has a stove, oven, and refrigerator; and your apartment complex has a
laundry room. You will need to furnish your kitchen/dining area, living room, and bedroom.
You have a total budget of $5,000 dollars. Using shopping sites located on the internet, find
items you would like to purchase for each of your rooms.
Spreadsheet Requirements: For this project, you must create a sheet for each room. In each
sheet, you need to make a table with the following information for each item you are
purchasing: item name, description, website, number of items, cost per item, and total cost.
Each table should have at least 10 items. The table should be sorted by item name and needs to
include a total row that shows the total number of items for each room and the total spent.
When you have completed the sheets for the rooms, create a summary sheet that shows the
total spent in each room (use a 3-D formula for this!), the grand total for all the rooms, how
much money you have left, and an IF statement that shows if you spent too much or not. You
will be borrowing the entire $5,000 and will be paying it off over a period of 5 years. You are
borrowing at an annual interest rate of 3%. Write a formula to calculate what your monthly
payment will be. In addition, make a pie chart that shows how much money you spent in each
room.
Things to remember:
• Create sheets that are easy to read and understand. Use appropriate fonts,
styles, alignment, and format to highlight key pieces of data.
• Appropriate titles and headings must be used in all sheets.
• All dollar amounts should include two decimal places.
• Name your spreadsheet tabs.
• Use functions and cell addresses in all calculations. When using the PMT
function, remember to convert to a monthly interest rate.
• Pie charts need appropriate titles, legends, and data labels. “

 

This question was answered privately by a Homeworkslaves.net Expert tutor. You can view an excerpt of the delivery – if the student availed it.

You need to be a registered member to do so. However, we advice students to ask their own questions by filling out the form provided. This ensures that there is 100% originality and 0% plagiarism in Portland State University Moving to A New Apartment Budget Worksheet submissions.

Homeworkslaves-How-it-works

Post your homework for free.
Enjoy 10% lifetime discounts
It's That Convenient. START HERE.

Question Posting Form - Project Integrated
  • Basic Details
  • Additional Details
  • Files & Attachments
  • FINISH

Basic Homework Details

Select assignment type here.
Provide a befitting title for your homework assignment.
Enter detailed instructions for handling this assignment.

About Homeworkslaves.net

Homeworkslaves.net is not about homework and slavery. It is a platform where students drop their assignment burdens, hire the best tutors and homework writers, and score better grades.

Here, if you have Homework, Assignments, Essays, Term Papers, Theses, Online Tests, Quizzes, e.t.c; Consider them Done!! Find Homework Masters Willing to Take on Your Burden, Slave for it, and Deliver A+’es, all at an affordable cost.

We have helped more than 100,000 students with their study needs. Our assignment and homework help services are utilized by over 100 students every day. This is closely linked to these guarantees.

  1. Privacy policy.
  2. Our Mission.
  3. 100% Confidentiality
  4. 100% Refunds

Learn more about us here.

Recently Posted Questions

PROJECT TITLE

Some of Our Best Tutors

    • $19.00/hr
    • Experience: 9 years
    • Engineering & Architecture
    • +1
    • $25.00/hr
    • Experience: 7 years
    • Professional Academic Research and Writing with 0% Plagiarism.
    • +1
    • $12.00/hr
    • Experience: 5 years
    • Capstone Proficiency
    • Professional Academic Research and Writing with 0% Plagiarism.
    • $12.00/hr
    • Experience: 12 years
    • Data Analysis
    • Professional Academic Research and Writing with 0% Plagiarism.
    • $10.00/hr
    • Experience: 11 years
    • Professional Academic Research and Writing with 0% Plagiarism.
    • +1
    • $10.00/hr
    • Experience: 2 years
    • Professional Academic Research and Writing with 0% Plagiarism.
    • +1
    • $20.00/hr
    • Experience: 6 years
    • Data Analysis
    • Financial Analysis
    • +2
    • $2.00/hr
    • Experience: 3 years
    • Capstone Proficiency
    • $10.00/hr
    • Experience: 3 years
    • Professional Academic Research and Writing with 0% Plagiarism.
    • +1
    • $22.00/hr
    • Experience: 6 years
    • Engineering & Architecture
    • +1

Reviews of Homeworkslaves.net

This is what other students think about us.

Very Supportive

Rated 5 out of 5
November 1, 2020

I hired a very supportive writer here.= and she delivered high-quality work. I will be coming back.

Donstudent

Subscribe to the Homeworkslaves.net Newsletter for more on {subject}

We do not send you unnecessary emails and you are covered by our privacy policy.

[newsletter_signup_form id=1]


Content Tags: , , , ,

Academic Writing-Excel experts-Excel homework help-homework solutions-past questions-Portland State University Moving to A New Apartment Budget Worksheet homework answers

Post to Get 10% OFF now and on 

ALL QUESTIONS

you post, FOR LIFE

Hire the best tutor for this assignment here on Homeworkslaves.net at a student-friendly cost today, and always.

10% OFF

Get This Assignment Done NOW

Happy Indepndence day

Homeworkslaves.net Juneteenth
en_USEnglish
Receive Question Notifications on your Browser Would you like to receive notifications on important question updates? No Yes, Notify Me