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

Kathy schwalbe project management pdf - Pro forma statements in healthcare - Ethics in the classroom - Discussion needed by 3pm Sat - DP Short Answer 2 - Nursing - Occupational ergonomics a practical approach pdf - Hw - Discussion post! 250 words . needed by tonight based on youtube videos attached! 1030 PM EST - Http faculty washington edu herronjc softwarefolder allelea1 html - Identify learning styles and generational characteristics - Are psychopaths more likely to exhibit criminal behavior - Research paper - Www readthemessages org index php facebook reader - Interactive reader unit 1 the anglo saxon and medieval periods - Is macconkey agar chemically defined - The performance management revolution harvard business review - M&l manufacturing case study solution - Discuss as a command word - Corrupt political machines and social disorganization - Week 8 Crisis intervention - Martha medeiros nobel prize poem in hindi - Factors to consider when developing an website - Which of the following correctly describes the accounting for indirect labor costs? - Westwood spelling test b - Choosing a mixed methods design creswell - Case Study - Exponential form to rectangular form - How does alton towers meet customers needs - Chinese zodiac php source code - Confessions of a heartbreaker epub - Law Enforcement and Transparency - How to open skyui - Qualitative analysis lab procedure - Cryptocurrency Paper - Resonus corporation case study solutions - What are the four common uses of comparative data - Performance criteria unit of competency - Capstone Research Companion - Systems understanding aid 9th edition - Sources of recruitment in hrm ppt - Counseling Question - Talking to my daughter about the economy epub - Phar mor case study solution - Communication and cooperation skills - A financial advisor has recommended two possible - My it lab excel answers - Introduction to Ethics (250 words) - Concepts and theories in nursing - Mtaa super fund usi - Organizational dissidence in audit firms is created when - DP 4 - Voluntary statement - Schneider electric circuit breaker application guide - Discussion 9 ERM - Research paper bh - Qad ee user guide - Vision learning com library module - Clinical robotic surgery association - Mt baw baw in summer - Most scientists who use dna microarrays obtain them - How to write a field report for geography - MGTU 301 Paper #2 - Dramatic techniques in hamlet - Human resources proposal template - Discovering human sexuality 3rd edition pdf - Personality development assignment - Norton turn off notifications - Audience benefits and the you view chapter 2 - Hcf fit and free travel insurance - St george netball association - Kfc issues in india - Https www youtube com watch v vt1pwfnh5pc - Sherrod inc reported pretax accounting income - Lab Activity: Relational Databases - Prithee what wouldst thou - Air force honor code - Mass Media Effects - 16 career clusters description - Nola pender model - Lesson 2 discussion CAM - Identify a bad listening practice course hero - How to describe music - The raven annabel lee - Essays guru only - Ica diploma in aml - Double staggered piquet list - Change management simulation - Business case analysis - Siemens magnet technology oxford - Intended only for brilliant answers - Charlemagne had the most profound influence on which continent - Hickory company manufactures two products - Wgu root cause analysis paper - Angle of impact calculator - A merchandising company that sells directly to consumers is a - Febreze breathe happy campaign - Pap smear soap note - Costco wholesale corporation financial statement analysis b solution - Discussion