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

Insert functions in cells h18:h22 to calculate basic summary information.

04/11/2020 Client: arwaabdullah Deadline: 7 Days

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:

Top Grade Essay
Essay Writing Help
Coursework Help Online
Finance Homework Help
Instant Assignments
Financial Hub
Writer Writer Name Offer Chat
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$62 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$55 Chat With Writer
Finance Homework Help

ONLINE

Finance Homework Help

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$55 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

Good day dear client, I am a full-time freelance writer with years of experience. My strongest strengths are strong dedication to duty, reliability, quality and excellence. I am going to do an outstanding job for you, kindly PM me and let us commence. Thank you so much in anticipation of your positive response. Thank you very much.

$55 Chat With Writer
Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

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

Ford transit towing capacity chart - Therapy - Death Penalty in America 2 - South grange medical centre - Family united network luton - Classic knitwear and guardian a perfect fit break even analysis - Anna ikea online sales agent - Best angle for solar panels in winter - Epic hero chart for beowulf - Ionic bonding questions and answers - Articles of confederation constitution compare contrast - What factors led to the great depression - Prepare a classified balance sheet as of december 31 2018 - Behavioural adaptations of a platypus - 2 year old observation paper - Character Evolution Instructions - Retained earnings are occasionally restricted - Adjectives in a poem - Spectrum sunglass company simulation - Bromide detox symptoms iodine - Jeux - Unit 3 IP DSDD - Australian knitting mills ltd v grant - Boston college student services - Icd 10 code for mucus plug - A workbook for aphasia - Sand dune regeneration advantages and disadvantages - Taxation of individuals and business entities solutions - Give me liberty 5th edition volume 2 - London breed poem - Adams water cartage bendigo - Strategic Plan Reflection - Www us cert gov cas tips - NURS-6050N-66/NURS-6050C-66-Policy & Advocacy - Exodus 20 verse 4 - Ccna ospf lab packet tracer - Business analytics statement of purpose - Seminar Reaction Paper - Seeing and writing 4th edition pdf - Difference between cpk and ppk ppt - List the steps for developing a workplace sustainability policy - Ford motor company 10k - Unsw library subject guides - Consumer Behavior - Help - Physical Security - Yitang zhang new hampshire - Examples of conventional symbols - Discussion board - Igcse biology end of chapter answers chapter 13 - A pitfall to avoid in pursuing a differentiation strategy is - Planning a wedding using project management - History question - Physical Geography Lab - Discussion - Pillow method definition - Jetblue airways corporation 2009 case study solution - Outpatient surgery encounters are coded as - What is a market domain in business - Netapp vsc compatibility matrix - Concept synthesis paper - Blank map of egypt to label - How to identify a research gap - How much does ttma pay - Introduction to combinatorics and graph theory - Quiz - Sjkcareers - This is our story chapter summary - Infinite campus u 46 - Nueces county republican primary sample ballot - 100 pair telephone cable color code - Wireless router projects - Bt newgate street london - Ole miss management information systems - Week 7 assignment - Which form of salvation is emphasized in the new testament - Foxy bingo denise van outen - The electron dot structure for ascl3 - Setting of bernice bobs her hair - 1z0 067 latest dumps - A song of guns germs and steel - Silverdale medical practice swinton - Abbots cross medical centre - Preschool pragmatic language checklist - Qdx f px - Melanie hicks liberty university - 50 strategies for teaching english language learners pdf - Fiji eating disorder study - BLC SHARP ESSAY - Time is of the essence construction contract - Swing time discussion questions - Machine Learning - Convert gray code to decimal - Char siu bao pronunciation - What constitutes meaningful compensation for an organ donor - Cpt code for omni glaucoma procedure - Health behavior - Microsoft access reserved words - WEEK 6 Discussion Prompt 2 Pharmacology - A loss for words lou ann walker chapter summaries - Mid market rent edinburgh