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

Balancing chemical equations using linear algebra - California gold rush worksheets - For anyone - Discussion - Class One: Part One - Lm358 laser driver circuit - Mitosis and meiosis test answer key - Case study - Scd2 implementation in datastage parallel jobs - Constipation soap note - How using edi facilitates electronic transactions - History Essay - Baseball speech attention getter - Caloric content of food labpaq answers - Santa fe grill mexican restaurant case study - Words to santa lucia - 967 which country code - Outside influences that affect self esteem come from __________ - ETCM DISCUSSION-4 - Myvisiononline login co uk - Why are decomposers important to an ecosystem - Southwest airlines case analysis - Haribo nederland b v - In 500 words or more, consider this statement: For cloud computing to become multi-jurisdictional, it must be separated from politics. - The chief disadvantage of the shortest processing time rule is - How to identify a research gap - Devry coll 148 - Assignment 2 analysis on food security - Grade 5 words to spell - Hands on quadrilateral activities - Ass1 - Looking out looking in chapter 11 - Https course apexlearning com public cpop - When was the compass invented in europe - Jb hi fi inspection camera - Solutions for domestic violence essay - The handsomest drowned man in the world plot - Ntcp diamond model project management - Switchport nonegotiate best practice - Two essays about innovation company - Fort street girls high school - Fry brothers heating and air conditioning inc - The strategic target of a best cost provider is - How to identify cations - Energy saving tips for hotels - Block diagram of computer system - History of forensic botany - Gartnavel hearing aid clinic - How to find the efficiency of an inclined plane - Preparing a buret for titration - A gas contained in a piston cylinder assembly undergoes - Todoroski air sciences abn - Dunkin donuts balance sheet - Three levels of analysis in organizational behavior - Benchmark - Nursing Process: Approach to Care - Technology and social change - Early exit bilingual program - Aussie pooch mobile case study answers - By the bomb's early light - Assignment HW4 - Canterbury high school ottawa - Lifespan development textbook 5th edition - Tameside refuse collection days - Deep space composition - Kane and abel shake it like a dog clean - Pomegranate poem meaning - Child family and community 7th edition by janet gonzalez mena - Reasoning that sounds plausible but is flawed - Frozen french fries near me - Www imedidata com http www imedidata com - Bachelor of arts flinders - Social blade will tennyson - Dr seuss wacky wednesday pdf - Prentice hall literature review and assess answers - 139 viewgrand drive berwick - Cold contact cover letter template - Journal Article Review - Silver nitrate and magnesium chloride - Fugates of troublesome creek - MA DIS - 8 - Energy skate park simulation answers - Urgent - The breakfast club letter to principal - Human resource - Pqr and sqr form a linear pair - Rapid prototyping an alternative instructional design strategy - Pelican paper inc and timberland forest - Delinquency - Reflection film - Business and administrative communication 11th edition pdf - + 91[^^=^9414601882 tAntrik bAbA vAshikArAn IN HYDERABAD - Mail fatima edu ph log in - Potentiometer physics lab - Security through obscurity examples - 716 glades drive robina - Literary analysis outline graphic organizer - Refractive index matching and clear emulsions - Research Question - 1/4 5/8 pair coil bunnings - Push pull legs advanced workout