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

Six resilience layers ecp

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

Grader - Instructions Excel 2016 Project


EX16_XL_CH02_GRADER_CAP_AS - Gym Management 1.9

Project Description:

You are a sales representative at the local fitness center, Health & Fitness Gym. Your manager expects each representative to track weekly new membership data, so you created a spreadsheet to store data. Membership costs are based on membership type. Clients can rent a locker for an additional annual fee. You are required to collect a down payment based on membership type, determine the balance, and then calculate the monthly payment based on a standard interest rate. In addition, you calculate general statistics to summarize for your manager. Spot-check results to make sure you created formulas and functions correctly.


Steps to Perform:

Step


Instructions


Points Possible


1


Open the downloaded file exploring_e02_grader_a1.xlsx.


0


2


Insert a vertical lookup function in cell C5 to display the basic annual membership cost for the first client.


10


3


Insert a function in cell B2 to display the current date.


5


4


Use an IF function in cell E5 to calculate the annual total amount, which is the sum of the basic cost and locker fees for those who rent a locker. For people who do not rent a locker, the annual cost is only the cost shown in column C. The Locker column displays Yes for clients who rent a locker and No for those who don’t.


10


5


In cell G5, enter a formula to calculate the total amount due for the first client based on the annual total and the number of years in the contract. Copy the three formulas in columns C, G, and E down their respective columns.


5


6


Insert a vertical lookup function in cell H5 to display the amount of down payment for the first client based on the membership type.


10


7


Insert a formula in cell I5 to calculate the balance due on the membership. Copy the formulas in columns H and I for the rest of the clients.


5


8


Insert the PMT function in cell J5 to calculate the first client’s monthly payment, using appropriate relative and absolute cell references. Copy the formula down the column.


15


9


Calculate totals for Annual Total, Total Due, Down Payment, Balance, and Monthly Payment on row 14.


10


10


Insert the appropriate functions in the Summary Statistics section of the worksheet: cells H18:H22. Format the payments with Accounting number format.


10


11


Format the other column headings on rows 4 and 17 to match the fill color in the range E17:H17. Wrap text for the column headings.


10


12


Set 0.3'' left and right margins and ensure that the page prints on only one page.


5


13


Insert a footer with your name on the left side, the date code in the center, and the file name on the right side.


5


14


Save and close the workbook. Submit the file as directed.


0


Total Points


100



Created On: 07/05/2019 1 EX16_XL_CH02_GRADER_CAP_AS - Gym Management 1.9

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:

Best Coursework Help
Homework Guru
University Coursework Help
Writer Writer Name Offer Chat
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.

$110 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.

$112 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$112 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

Bus Cont Plan&Disas Recov Plan - Henry's daughters - Reflection about bread and pastry - Capstone Research Companion - Anatomy of Illness paper, 6 pages, APA, more than 4 professional peer reviewed article references - Essay - Conjunct or disjunct melody - The futile search for stability guided reading answers - Uts library journal articles - Lead and manage team effectiveness - Principle of effective communication - Soft rains will come summary - Practical connection assignment - How much does it cost to make empanadas - Master 35 impact wrench for sale - Create a political party project - Policy, Legal, Ethics and Cmplc - COMPUTER - Writeanessayfor.me: What kind of service to expect? - A large cable company reports the following - I hate running case study answers - Write a response - 0737179697 MAMA SHANANI ABORTION CLINIC IN MOUNT FRERE - Legal en - Corrie ten boom forgiveness - A paper on case study: Brewing up controversy - Does the internet make you smarter or dumber carr - Paradigm Analysis Paper - Policy Implementation - Rectangle with semi circles at each end - Assessment 2: Patient Care Plan - English-Romantic novels - Sample constitution self help group kenya - +91-8890675453 love marriage problem solution IN Bathda - Www static practicefusion com login - CT1 Essay - The grizzly bear who lost his grrr - Discussion board - Northern tile distributors thomastown - Banking vocabulary words with meaning - Nursing - Letza simple anatomy lessons - Minth group wiki - Interactive reader unit 1 the anglo saxon and medieval periods - Wiki wireshark sample captures - Calculus - Week 3 - Assignment: Examine Quasi-Experimental Research Methods - Acceptance and commitment therapy handouts - Brunswick car park london - Harmony mister doob - Principal-Agent Problem - Sample soap note for wellness visit - Autozone case study - Test - Gluten free pain au chocolat tesco - Spanish homework help - Aviation security identity card - Autonomic nervous system lecture - Evaporation and intermolecular forces lab conclusion - Syslog ng peer verify - Throw overboard crossword clue - Transition to the Nursing profession - What element makes protein different from carbohydrate and fat - What's an irrational number - Amanda 828 - Battles in the desert & other stories - Cost of goods manufactured and sold formula - Chinese knots and their meanings - Swot analysis of ferrero rocher - Flipkart ebay merger case study - Iom reports 2010 future nursing leading change advancing health - Home work IBM - Three in 1 assignment - Lame v3 99.3 for windows exe - An introduction to film analysis pdf - 6 Discussions due in 36 hours - Probability and set theory answers - Empress eudoxia john chrysostom - Inorganic contaminants present in a sample of water lab report - Unit III Scholarly Activity - Advantages and disadvantages of atomic models - I need help with answering a Discussion question. - From cruelty to goodness by philip hallie - Equine digestive system worksheet - Benchmark literacy lesson plan template - Personal beliefs about the origins of the universe cwv 101 - Kentucky nurse practice act - What is the message of jasper jones - 3 Lecture Questions 500-700 Words Per Question - Lrt kelana jaya fare - Cleft chin dominant or recessive - Scientific method with spongebob variables and constants answers part 1 - Two discussions - Precautions - What was the fingerprint generated with your kleopatra certificate - Implement financial management approaches - Mitel 5312 ip phone instructions - Mgp10 rafter span tables - 22.1 data gathering techniques homework answers - Delphi company has developed a new product