Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

In cell g5, calculate the total due based on the annual total and years of membership in column f.

15/12/2020 Client: saad24vbs Deadline: 2 Day

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter 2: Homework Project 1


Formulas and Functions


Project Description: In the following project, you will perform preliminary work on the gym worksheet. You will then calculate cost, annual total, and total due. You will also determine the down payment and balance of gym membership. Your last steps will be to calculate the monthly payment and finalized the workbook.


Instructions: For the purpose of grading the project you are required to perform the following tasks: Rule 1: If an object is selected and a new tab appears, it is 95% in that new tab. Rule 2: If you are ever confused, right click on the selected item. Formulas: + = Addition - = Subtraction * = Multiplication / = Division Step Instructions Points Possible 1 Download and open the file named exploring_e02_grader_h1.xlsx. Click OK in the message regarding the circular reference. In File, use the SAVE AS function to save the document in Computer / Z Drive as Excel Chapter 2 Capstone. 0 2 Create a range name for cells A18:C20 named Membership. Select the columns A through J and autofit them. To do this, move the curser in-between two of the selected columns, and double click when the curser is a vertical line with an arrow sticking out from both sides. This will autofit ALL selected columns. 5 3 Insert the TODAY function to enter the current date in cell B2. 5 4 In cell C5, insert the VLOOKUP function to display the basic annual membership cost of the first client. Because of the range name being Membership for the table, absolute references will not be required in regards to the table_array. Simply use Membership as the table_array, and it should select the preassigned range to that name. 5 5 Insert the IF function in cell E5 to calculate total amount. The function should add the cost of membership plus, if applicable, the locker fee. Logical_Test – This will test to see whether or not the client has a locker. If the client has a locker, the cell, D5, will say Yes. This row needs to test whether or not the Locker column has “Yes” in its cell. Value_if_True – This is the equation for if the Logical_Test is true. Meaning, the price of the locker added to the cost of the membership. Value_if_False – This is the equation for if the Logical_Test is false. Meaning, the cost of the membership WITHOUT the locker fee. Be sure to go through each equation within the function, and check to see if absolute reference are necessary. Look at each cell reference and ask whether or not that cell changes as you copy the formula, or if it stays the same. If it stays the same, ABSOLUTE REFERENCES will be needed. 7 6 In cell G5, enter a formula to multiply the annual total and years of membership to calculate the total due in column F. 5 7 Copy the three formulas down their respective columns. 5 8 Insert the VLOOKUP function in cell H5 to display the amount of down payment for the first client. 5 9 Locate and correct the circular reference for the balance in cell I5. A circular reference is when an equation refers to the cell it is in, which will void the equation. Be sure the equation calculates the difference between total due and the down payment. 7 10 Copy the two formulas down their respective columns. 5 11 Insert the PMT function in cell J5 to calculate the first client’s monthly payment. Rate – Objective This is the interest rate the payments will be appropriated. For This Assignment In this instance, it is found in cell B23 as the interest rate for the payments divided by the payment plan, being that it’s monthly, will be 12, located in B24. Nper – Objective This is the total number of payments for the loan, meaning what type of payment plan the loan is on. For This Assignment In this instance, it is a monthly plan, meaning that the payments will be 12 in total. This is located in cell B24. But, the payments can also go over multiple years, located in column F. To find the true total number of payments, multiply B24 by F5. Use the cell reference rather than the physical number. Pv – Objective This is the current amount due toward the loan. For This Assignment In this instance, it is located in I5, being that the current balance for each member is what each member owes. Because this number is a debt, it should be a negative number. Use appropriate absolute references as needed, being that absolute references are for cells that do not change. Fv and Type are rarely used, and will be clearly directed if ever needed. 6 12 Copy the formula down the column. 5 13 Insert the SUM function in cell G14 to total the column. 5 14 Fill the function in cell G14 across the range H14:J14 to add additional totals. 5 15 Insert functions in cells H18:H22 to calculate basic summary information. Be sure the correct information is selected for each individual function. COUNTA MIN AVERAGE MAX MEDIAN 7 16 Format the payments in cells H19:H22 with Accounting Number Format. 5 17 Select cell E17 and select Format Painter in Home / Clipboard. This will copy the formatting of the selected cells into another range of cells. Now format the column headings on row 4 and 17 to match the fill color in the range E17:H17 using format painter. 6 18 Format the cells G5:J5 and G14:J14 with Accounting Number Format. Use zero decimal places for whole numbers. 6 19 Apply Comma Style to the range G6:J13. Use zero decimal places for whole numbers. 6 20 Save the file and close Excel. Submit the file as directed. 0 Total Points 100


Updated: 01/07/2013 1 E_CH02_EXPV1_H1_Instructions.docx


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
Best Coursework Help
Homework Guru
University Coursework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$40 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$37 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$37 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Yo yo ma necessary edges - Culture and psychology matsumoto 5th edition pdf - Work breakdown structure app - Bino the elephant theme song - Do platyhelminthes have appendages - Labrador west health centre - Prince inside the purple reign - Cayenne fruit 40000 stu benefits - Does mass mean weight - Problem 12 9a wileyplus - Data modeling fundamentals a practical guide for it professionals pdf - Oz talk home bundle add-on - Statement of Purpose needed - Tatachilla foundation shiraz 2000 - Roye kennel uses tenant days as its measure of activity - Sunsuper intent to claim form - The necklace worksheets pdf - Mcgraw hill financial accounting chapter 8 answers - Human communication process - Brogden v metropolitan railway - Stronghold crusader hd tips - Display the help document insert wordart - Nursing care plan acute appendicitis - Trevor noah owns tomi lahren - Nad on physical exam - Medication teaching plan - Derivative words in english - Wasi 2 sample report - Writing Help - Research paper 3 - Best free cuckold sites - Verdict instigator portable bluetooth speaker - Busi 201 Article Review - Case study 3 assignment IFS(USE AS A GUIDE) - QUIZ - English - Discussion(NCM) - Skullcandy earphones made in which country - Is graffiti art or vandalism argument essay - El tio deaf boy - James and the giant peach glow worm - Risk and Resilience Value Article - Capella iguide home - Bill nye biodiversity worksheet - 70 perchloric acid molarity - Quehaceres cotidianos - Contemporary Public Health Issue - Banana box corporation has sales of - Testout power supply lab - Dr takai hoover and hsu associates - Principles of computer security comptia security+ and beyond 3rd edition pdf - Why don t microorganisms in cultures exhibit constant exponential growth - APA assignment - Neil mercer exploratory talk - Discussion question - dot coms business plans - Rinehart bunky cause of death - Sooner okie irrigation and drainage - South east wales centre for teacher education and training - A guide to taking a patient's history - Ionic and covalent bonding answers - How does hajj express the beliefs of islam - Advanced Business Statistics - Amex hungary case study answers - Ciena 6500 dc power requirements - Crazy Time Online от Evolution Gaming - Car parts word search - Combining form for pulse - Hodgson's ethical decision making framework - Introduction to risk management and insurance dorfman pdf - Process financial transactions and extract interim reports pdf - Three ionisation stages of arsenic acid - PCI Compliance - Excel: Short-Term Finance - Polynomial addition using linked list in data structure - Accounts google com signoutoptions hl en&continue https www google com - Cross a waltzing brown mouse - Chapter 1 constitutional law - Qualatex balloon instruction sheets - Architecture definition document example - Annual housing statistics bulletin - 400 - In the production cost report the total - Snell's equity 33rd edition - Industrial Control System Cyber Security - Security architecture 3 - Discussion Board: Clinical Based Decision-making Model - University of warwick insite - Create your own country assignment - Hangman game code in assembly language - Lenscrafters operational management challenges - Hairy angler fish facts - Miniature version of a document - Summarize the theories of victimization - Managing Organizational Cultural Change and Sustainability - Criminal Justice - Wawa no cidal movie - Nsls online leadership training day answers - Marketing excellence nike case study solution - Track software case study - A limitation of gestalt therapy is that it