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

Mechanical engineering epq ideas - Safe practices for motor vehicle operations ansi asse z15 1 - Week 5 - Q & Q A4 - Hydrostatic pressure relief system - Doctrine of part performance - Overhead crane runway design - Chapter 8 questions 3 and 18 - GoLang - Clifford johnson cocoanut grove fire - Assignment 2: New Venture: Launch Plan - What are the terms of each expression - Discussion Emerging threats - Homework america history 2 - Summary of the poem ethics by linda pastan - Nordic genetic resource center - Short eassy - Devry econ 312 week 3 quiz - Barracania - Short drama script about family problems - United States department of labor case study - Diffusion osmosis lab answers - Meticulously planned movie scene crossword - Who can complete this assignment by tomorrow, Thursday, October 22, 2020 by 11:59pm? - Latin tense endings chart - Session rating scale outcome rating scale - Exigence of letter from birmingham jail - Who wrote let her go - Capstone make up work 1 - Wk 3, IOP 480: DR 1 - How to read literature like a professor chapter 3 summary - Harvard business publishing marketing simulation answers - Strategic plan part 2 swot analysis paper - Assignment 2 social control and criminal deviance bullying - 4 types of pathogens - January brings the snow poem - Jb hi fi refund time - The retained earnings statement shows - Chapter 16 accounting for income taxes - English Comp 2 WEEK 3 - Aida represents attention, interest, desire and _______. - Shazia khan citizen khan - Internment camps australia ww1 - Discussion Board - Kurt lewin's leadership styles framework - Entire class work - Strategic Management Assignment - Proj 587 week 5 case study - India pattern brown bess - Spotty-handed villainesses speech 1994 - Highfield food safety level 2 answers - Sql injection attack lab solution - 26 bream road ettalong beach - Quiz using ALEKS - 1992 tarantino crime thriller crossword - 0580 41 m j 17 ms - Interpreting the tsi 2 - CompStat and Police Profession - Week 7 - Attic needlework last chance - Subjects of civil law - How to always be imposter in among us - Reply Post - WD5 - What were the causes of the great depression - Q & Q A7 - Hozier tickets bethlehem wind creek event center november 16 - Analysis Essay 2 - Www bloomberg com quote cur usd idr - Strengths of the biological approach - Physics static electricity worksheet answers - Jane eyre discussion questions - Absolute value function transformations worksheet - 399 713 rounded to the nearest thousand - Essay - Find the Best Seeds for Growing Marijuana and CBD - Five step marketing research approach powerpoint - Social justice action project ideas - Setting event antecedent behavior consequence - Red black tree python - Strain gauge lab - Adding subtracting integers word problems - Bdawk6paper - Due today - EH Week7 DB - Housing executive phone number - Lightest element in period 3 - AC/FI A4 - Jolly phonics blending group 2 - Self assessment customer focus - Interest free banking definition - Vehicle identification number color weight and horsepower best exemplify - Brad is testing whether school is more enjoyable - Tall man lettering adalah - A _______ is often used to cut holes to install outlet boxes in old installations. - Keith's radio station 9th edition pdf - Mad about plaid case study - During a dysphoric manic episode the patient experiences mania and - Corporate level strategies of victory motorcycles - Delta airlines 10k