User Account

All Pages

About specialized functions

Assignment Help Basic Computer Science
Reference no: EM13840260

Specialized Functions

Project Description:
In the following project, you will use Excel to perform calculations regarding rental properties. You will create a basic search, utilize database functions, and create an amortization table

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions

1 Download and open the file named exploring_e07_grader_h1.xlsx, and then save the file as e07c2Apartment_LastFirst, replacing LastFirst with your name.

2 Insert functions in the Pet Deposit column of the Summary worksheet to calculate the required pet deposit for each unit. If the unit has two or more bedrooms and was remodeled after 2008 the deposit is $125, if not it is $75.

3 Enter nested functions in the Recommendation column to indicate Need to remodel if the apartment is unoccupied and was last remodeled before 2005. For all other apartments, display No change.

4 Type 101 in cell B2.

5 Insert a nested lookup function in cell E2 that will look up the rental price in column D using the apartment number referenced in cell

B2.

6 Click the Database worksheet and enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled.

7 Perform an advanced filter based on the criteria range. Filter the existing database in place.

8 In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel.

9 In cell C8, enter a database function to calculate the total lost rent for the month.

10 Enter a database function to calculate the year of the oldest remodel in cell C9.

11 Click the Loan worksheet and enter 3/20/2015 in cell B7.

12 Insert a formula in cell E2 to calculate the loan amount based on the loan parameters in the input area.

13 Insert a formula in cell E3 to calculate the total number of periods.

14 Insert a formula in cell E4 to calculate the periodic monthly rate.

15 Insert a function in cell E5 to calculate the monthly payment. Ensure that the function returns a positive value.

16 In cell E6, insert a function to calculate the total interest paid on the loan. Ensure that the function returns a positive value.

17 Complete the loan amortization table for the first five payments only. In cell A11, enter 1. In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. Use the DATE function to complete the Payment Date column and financial functions for the Interest Paid and Principal Payment columns. In cell F11, enter =C11-E11. In cell C12, create a relative reference to cell F11. Note: Be sure to only complete the table through row 15.

18 Create a footer with the sheet name code in the center, and the file name code on the right side of each worksheet.

19 Save the file making sure the worksheets are in the following order: Summary, Database, and Loan. Close Excel. Submit the file as directed. 

 

 

 


Attachment:- exploring_e07_grader_a1_1.xlsx


Attachment:- exploring_e07_grader_h1_1.xlsx

Reference no: EM13840260

Questions Cloud

Explain the effects of globalization : effects of globalization
Write a report on nissan motors with eight references : Write a 2000 word report on Nissan motors with 8 references. and presentation on power point slides to speak for 15 mins and individual reflection report on 1500 word this is your own analysis and reflection upon your part in the processes.
What characteristics are more plant-like : Hypothesize why a fungus would use spores as a mechanism for reproduction. How might the environment affect a fungus reproducing sexually or asexually? What characteristics are more plant-like? Animal-like?
Why is it so difficult for couples to talk about sex : Why is it so difficult for couples to talk about sex? What about parents and their children? What would make it easier for people to have meaningful conversations about sex (e.g., times, places, resources, etc.)?
About specialized functions : Specialized Functions
Required to conduct-report and present the investigation : You are required to conduct, report and present the investigation - Can validation and verification methods be found that tie in with the requirements definition process
Write report which compare financial position of two company : Write a report which compares and contrasts the financial position/performance of the two companies. The report should conclude by judging whether these stocks satisfy Lincoln's investment criteria.
What feature of the dna helix provides access : What feature of the DNA helix provides access to "reading" by a protein molecule? Why?
Characteristics of dry chin-tuck swallowing vibrations : Write one page summary of the given article- Characteristics of Dry Chin-Tuck Swallowing Vibrations and Sounds

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Make an instance of romannumerals

Make an instance of RomanNumerals and invoke the method toRoman(int n). Enter a number in the Arabic notation and it will convert it to a Roman numeral. For example 17 will be converted to XVII.You will notice a test suite that we provide with the..

  Takes non-negative integer

Then implement function drawLevy() so it takes non-negative integer n as input and draws the levy curve Ln using instructions obtained from function levy(). Don't forget doc strings and comments.

  Best practices for internetnetwork security

As you are exploring different ideas for your paper, note the research paper will require you to submit 8-10 double-spaced, typed pages with a minimum of 10 references regarding the topic: Best practices for internet/network security.

  A positive integer and a subprogram

The factorial of a positive integer N, denoted by N!, is defined by the following: N! = 1 * 2 * ..... * N (Note: 0! = 1) Using module and/or functions, create a recursive program to compute N!. The user should input a positive integer and a subprogra..

  How fast can a telephone channel carry data

If a telephone channel's signal-to-noise ratio is 1000, how fast can a telephone channel carry data?

  How to motivate the employees to accept the change

You began a group project where you had to rebuild/expand your company's information and communications technology infrastructure and information system.

  Convert the following two''s complement to decimal numbers

Convert the following two's complement representations to decimal numbers (assume 5 bit numbers). a. 11101 b. 01111 c. 10011

  Course about communication

Explain how applying what you have learned in this course about communication, collaboration, problem solving skills, ethics and organizational citizenship can help you be a successful citizen of your organization. Be sure to discuss each one o..

  Describing use of request for information

Describe in scholarly detail how you would utilize RFI (Request For Information) procedures to recognize potential vendors in the acquisition process, and RFQ.

  Proposal for implementation of information technology

Investigate and present a proposal for the implementation of an Information Technology (IT) system for a small (4-user) business section (for example, Human Resources) of an organization of your choice (real or fictitious).

  Explains how hackers can hide their own ip address

Explains how hackers can hide their own IP address when attacking other computers, and how administrators can thwart this type of cracking

  What is the future of human-computer interactions

What makes today's technological environment a Digital World? What is the future of human-computer interactions

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd