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

Ebook marketing digital udacity - Assessment extension form curtin - Which statement concerning educational programs in health informatics is correct? - One page, MLA Format - Order 2122386: International relations - Discussion 200 word - Review the corresponding data set and use it to answer questions and complete an exploratory data analysis. You will use R and Excel to complete the assignment. - Famous creative thinkers presentation - Information literacy lesson 2 exam - Political science research methods questions - Dnv os f101 spreadsheet - Biol1020 textbook - How to answer sociology essay questions - What is the difference between do and due - Lección 4 estructura 4.2 practicar verbos - Which of the following statements is true of external recruiting - Economics - Pr 6 1a fifo perpetual inventory - The correct order of presentation in a classified balance sheet - Definition needed asap now - My flamboyant grandson theme - Art appreciation and criticism - Rsa its history its methodology and where it is used - Single phase pole mounted distribution transformer - Apn role in health promotion - Theory practice gap in nursing example - Dominant ideology in the united states - Road trip homecoming theme - A variable that inadvertently causes an experimental result is - HCS 214 Week 5 Newsletter - Urinary System - How to protect your company from being salted by union - Corey corey and callanan decision making model - Http www calstatela edu library guides 3asa pdf - Communicating effectively 11th edition pdf - Inuit toys and games - Principles of incident response and disaster recovery 2nd edition - Is 33550336 a perfect number - Fundamental methods of mathematical economics 4th edition solutions pdf - Ridgeline mountain outfitters - I chop some parsley billy collins analysis - Tom seymour pwc salary - Racial Diversity in the Classroom - Https ereader chegg com - Band booster class java - Eth 321 week 1 alternative dispute resolution - Local lion boone north carolina - 150 -200 paragraph - Similarities between scm crm and erp - Research Paper - Bunsen burner flame types - 4x4 camping show perth - Basic crisis intervention skills - Real estate retouching services - Ema gmp inspection findings - Jean kilbourne killing us softly 4 - Discussion Reponses (#2) - Cuddra hall st austell - Process recording social work - Acceptance angle and numerical aperture - S2 magic monitor download - Airbus a350 vs boeing 787 battle for the skies - Refer to table 3-23. the farmer has a comparative advantage in the production of - Bell computers purchases integrated chips at $350 per chip - Finance Unit 8 - Domestic violence in sports statistics - Cism job practice areas - 10/2 - Culture and providing care to patients who do not speak english - Class centre frequency table - Tutor Account On Sale - Two types of prewriting penn foster - Info Gov - Biology - Healthy People 2020- APA FORMAT - Five marketing flows in the marketing channel - Noel carroll the philosophy of horror pdf - 2 Paragraph argument ::: Argue for or against: the ancient Japanese peoples were not isolated. Cite a couple of pieces of evidence from the course materials for the week. - Case Study - British universities and colleges sport - Polaris and victory motorcycles case study - Due process and crime control models - Fulham wing royal brompton - Accounting excel project - For a population containing n 902 - Old darby whiskey price - A monkey in silk is a monkey no less - What is a phase in metallurgy - Blister in the sun notes - Initiating the Project-Problem set 4 - Order # 9581 - Current devices of respiratory physiotherapy - Distinguished achievers list 2009 - Virtual lab natural selection table answers - Legal and moral dilemmas in first aid pdhpe - Discussion 1 - Performance Appraisal System Contributions - Desmos graphing trig functions - Qs 6 6 bank reconciliation lo p3 - Orleanna quotes poisonwood bible - Briefing Cade for Legal - Mcis sau