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

11/170 bowen terrace new farm - Simple circular flow model economics - Human cheek cell experiment - Hills home hub 600 - Examples of business rules and requirements - Energy and Circular Motion Exercises - Crane matten business ethics - How do you speak pig latin - Bio and information technology - Is copper pipe a pure substance - Fbi cover letter internship - Who is the most intelligent person you know - Sleep journal and reflection report - Bodega dreams full text pdf - Liver cake recipe for dogs - C purlin floor joist span tables - Evidence based practice picot question - Wiki wireshark sample captures - Fixed wireless nbn equipment - Ethical issues do not resuscitate orders - What 7 coins make 20 cents - Prospective fault current definition - Widgets r us uses a variety - The bean trees full book pdf free - Let's go muttsu go - Hi macs adhesive chart - External equity in hrm - Calcium nitride ionic formula - Discussion - College assesment quiz - Chemical equation for sodium thiosulphate and hydrochloric acid - COVID-19 Environmental Impact Report - Api healthcare shift select providence holy cross - Mil dtl 24308 glenair - Dulux natural white exterior - Flip slide and turn - Patrick the human resources manager at acme company - INFORMATICS PORTFOLIO - Work - Appositional and interstitial growth occurs in two different directions - Perryfields high school website - Health Care Model Infographic - Mini hacksaw powered by beam engine ppt - Food and nutrition a level syllabus - Week 8 discussion project management - Boeing 7e7 case study excel - Fate and free will macbeth - Piper warrior ii v speeds - Records management plan template - Juniper design ltd of manchester england is a company - Rev thinks the beatles are death metal - Solar system model to scale - Na+ and o2 formula - Jahangir son of sultan suleiman - Chartered institute of loss adjusters cila - Desiree's baby reading thinking guide answers - How have electronic media and their convergence transformed journalism - A charge nurse on the pediatric unit is making assignments - Constitution Amendments - Sociology unit 2 test - Claudette nevins cause of death - Iec 61010 2 030 - Ato agent fast key codes - Tinks chainsaws and mowers - Vendor Management - The happiness project journal - Web Exercise - How Ethical Are You? - Ib french ab initio written assignment sample - Research - Brent yessin - Lyn dines hair salon labrador - In fusion cloning protocol - Ap physics 2 electrostatics - Writing Assignment - Intermediate accounting 11th edition nikolai bazley jones - Mcdonalds station observation checklist - Cost structure refers to the relative proportion of - Identity and Access Management - Ansi aiha asse z10 2012 - Computer beep codes and their meaning - Strategic Marketing - Poems about julius caesar's death - How do you calculate grain bin capacity - Gcu template - Title of the organization - Color code white personality - How does 10 4 help you solve 30 4 - Are you sexist quiz pbs - What is the definition of heritage snhu - Marketing - Fm modulation and demodulation matlab code - Experiment 6 freezing points graphing of data - Thomas fogarty winery wedding cost - Formal charge of mn in mno4- - Revision strategies for writing snhu - Understanding and using english grammar 4th edition answer key pdf - Defects in metal forming process pdf - Glass menagerie test questions - Australian tax office darwin - Carrier concentration of n type semiconductor