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

WOrLd fAmOUs aStROlogEr+91-9924492424 LoVe vAshikArAn sPEciALisT Baba Ji - What does the union operator do - Human resource management robert mathis 13th edition - Discussion Question - Dva request form d904 - Mango bite price per candy - Tableau problem homework to be done in Tableau format - Hp 3par storage architecture - A number that is whole but not counting - Schedules of reinforcement quizlet - A class is selling magazines as a fundraiser - Edge triggered flip flop circuit diagram - Netsuite business development representative - Canoe companies manufacturing accounting system - Calculate the freezing point of the solution - Swansea ac uk email - Homework for lab 3 force and motion - Ashworth preschool and kindergarten - Kelly clarkson breakaway meaning - Fifty six percent of all american workers - Sap business objects 4.2 sp5 administrator guide - Icanhascheezburger com is a website founded as a repository for - Cultural care plan template - Nursing - Problem 1 7a analyzing transactions and preparing financial statements - Life doesn't frighten me poem - What do gorillas sleep on in fruit orchards - Managing organizational change 3rd edition - Sloppy joe clothing kmart - JCCMI- Phil Week 4 Dis 1 - Presentation Work - Accounting movie summary and analysis - George bowman carriage driving - What is a concept analysis nursing paper - The gate theory of pain - Bcd adder to seven segment display - Uses of double displacement reaction - Nursing care plan for fracture patient - Research Project - Maxine hong kingston tongue tied - A natural history of human thinking - 2 student responses from slides given not a paper - Surface area of a cylinder sector - 700 word discussion – What were the approaches and inquiries for the discourse framework on eParticipation and simulation exercise as conceptualized by the authors? - Library administrator job description - Motion picture costumers 705 - Titration for acetic acid in vinegar lab - Pub 8 - Gilani Mobility - Medicare levy variation declaration - Under variable costing fixed manufacturing overhead is - Zzzz best case study answers - Dr david mccarey rheumatology - The eye of the storm movie - +61 3 8372 2367 - Ccna ospf lab packet tracer - Define marketing myopia give three examples in the sport industry - Aussie globe consultancy rockdale - A child of hitler alfons heck pdf - Group dynamics for teams daniel levi pdf - How to cut gyprock - Stitch fix target customer - The crucible act 1 film analysis worksheet answers - Hundred thousandths decimal place - Altex inc manufactures two products car wheels and truck wheels - Glo bus year 6 decisions answers 2018 - Harry connick jr branford marsalis - Toasts for deceased person - Cause/effect essay - Broadway leisure caravans wrexham - Disneyland outline - Informational interview paper sample - Invictus movie scenes - Speech on donate blood save lives - Killing us softly 4 free online - Www ucmp berkeley education explorations tours fossil index html - Larry weissman literary agent - How to write a legal memorandum - Wsq competency framework - Three informal channels of communication - Worcester combi boiler wiring diagram - Kulai preschool aboriginal corporation - Scorecard and dashboard formulation - Spanish explorer costume ideas - Yaesu cross band repeat - The mind is an enchanting thing by marianne moore - Amp gauge wiring diagram - What project management software did arnold palmer utilize? - 20 hand signals in basketball with description - Community teaching plan teaching experience paper - Econ 102 psu exam 1 - Klb biology form 1 pdf - A haunting on dice road wikipedia - Alvin toffler perspective on the evolution of technology - Oswego outbreak case study answers - Mira spanish textbook answers - HR - According to renaissance philosophy commoners often represent - Literary devices used by shakespeare - Essay