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

Jiffy lube training and development - Er diagram composite attribute - Short Essays - To make your case start with a picot question - Kuba masquerade 1909 kasai congo - Maximum power transmitted by belt drive - The big stick in the caribbean sea cartoon analysis - Statistics and criminal justice leadership - Smallest positive solution maple - Aussie hot takeaway andergrove - Nanda nursing diagnosis for lymphedema - Phet edu colorado sims physics projectilemotion - Rowlands gill medical practice - Social work cover letter - Forecasting simulation pearson gas answers - Module 1 short story - Colin davis machine company maintains a general ledger account - Wilsons prom accommodation lighthouse - Diamond mesh lath installation - The working poor invisible in america sparknotes - Ib french ab initio written assignment sample - Generator reverse vars shutdown - Briefly describe what the custodian does. - Fussell meaning in hindi - 8-4 project part two - Apple tnc case study geography - Managing Group Policy within the Microsoft Windows Environment - St thomas x ray - Composition Function- Precal - Bpw hub cap spanner - 7005 nw 73rd ave tamarac fl 33321 - How do you write 1400 in words - Ms public service commission - Memo on wastage of stationery - Akbar shah khan najeebabadi wikipedia - The lost letters of pergamum thesis - Business steratregy - Test the theory to determine cause - Virus - Long distance walkers association - Kauai community college map - Paper g320 journal 1 - 978-1-4576-3299-0 - Break even and cost volume profit analysis chapter 24 solutions - Urban remedy macro bowl costco - Multimedia poetry presentation - Statistics Quiz 2 - One page - Words beginning with vac - Why did bella sara shut down - The liabilities section of o brian's balance sheet - Homework 1 page - Bowller roofing kings langley - 26 electrons 29 neutrons 26 protons - Bsbpmg501a manage application of project integrative processes - What is cisco waas - Extron 60 604 02 - Pros and cons of amazon company - Introduction to java programming daniel liang pdf download - Cherubim and seraphim theology - 27th sunday year a - Chapter 6 business government trade relations - Data table 1 chromatogram data - Benefits of a computerised accounting system - Assignment 300 words - Course Project Milestone: Annotated Bibliography- APA FORMAT (4-7 pages) - How many syllables in the word limerick - Appian the punic wars - Occupational therapy practice framework domain and process - 85 538 little lonsdale street - The dreadful menace poem - What should a billionaire give and what should you - Erikson's ego integrity scale 0 10 - Remember the titans discussion questions - Dippin dots case study strategic management - Application to general manager - Crime/fraud detection using data mining - 90 days from september 30 2019 - Brehm v eisner case brief - Writing Assignment - Superior Goal Statement Paper 1 page single spaced. - Excel independent project 2-5 - Common Assignment Alcoholism - Acid base titration curve lab report answers - The leslie fay companies - History - Nursing care plan for homicidal ideation - Case study 3 - WEEK 5 Discussion Prompt 1 Pharmacology - Ethics case study 2 - Lifespan development by john santrock pdf - Our fear of immigrants questions and answers - Read Carefully - Pwc guide to accounting for stock based compensation - Highline financial services ltd - Berri apple juice price in sri lanka - Database system - 5 amp socket symbol - Welding industries of australia - Damaging effects of stereotyping and labelling