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

Create a named range for cells a18 c20 named membership

31/10/2020 Client: papadok01 Deadline: 7 Days

Office 2010 – myitlab:grader – Instructions Exploring Series! Excel Ch. 02 - EOC Project

Buff and Tuff Gym

Project Description: In this project, you will create a worksheet that calculates membership costs for Buff and Tuff Gym. You will create functions that determine costs based on a condition, lookup membership rates and fees, and calculate monthly payments. You will also create functions that summarize your data.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel workbook named Exploring_e02_Grader_EOC.xlsx. 0 2 In the Circular Referencing Warning message box, click OK, and then close the Help window that opens automatically. Assign the name Membership to the range A18:C20. 5 3 In cell B2, enter a function that will return the value of today's date. 4 4 In cell C5, create a VLOOKUP function that returns the membership cost that corresponds with the membership type entered in cell B5. The function will look for an exact match in the range named Membership, and return the membership cost from the second column. 10 5 Copy the VLOOKUP function down to cells C6:C13. 3 6 In cell E5, enter an IF function that will calculate the annual total. If the client has a Locker (D5) is "Yes", then add the Cost (C5) to the Locker Fee (B22). Otherwise, the function will return the Cost only. Ensure that B22 is entered as an absolute reference. 10 7 Copy the IF function down to cells E6:E13. 3 8 In cell G5, enter a formula that will multiply the Annual Total (E5) by Years (F5) to calculate Total Due. Copy the formula down to cells G6:G13. 7 9 In Cell H5, create a VLOOKUP function that returns the down payment that corresponds with the membership type entered in cell B5. The function will look for an exact match in the range named Membership, and return the down payment from the third column. 10 10 Copy the VLOOKUP function down to cells H6:H13. 3 11 The formula in cell I5 is incorrect, and contains a circular reference. Edit the formula so that is calculates the difference between Total Due and Down Payment. Copy the formula down to cells I6:I13. 7 12 In cell J5, enter a function to calculate a monthly payment for the client. The function will refer to the annual interest rate (B23) divided by B24, a loan term (F5) multiplied by B24, and the balance due (I5). Refer to B23 and B24 as mixed cell references (B$23 and B$24). Refer to I5 as a negative value (-I5) so that your result returns a positive number. 10 13 Copy the payment function down to cells J6:J13. 4 14 In cell H18, enter a function that counts the number of entries in the range A5:A13. 4 15 In cell H19, enter a function that finds the lowest value in the range J5:J13. 4 16 In cell H20, enter a function that finds the average value in the range J5:J13. 4 17 In cell H21, enter a function that finds the highest value in the range J5:J13. 4 18 In cell H22, enter a function that finds the median value in the range J5:J13. 4 19 Format the range H19:H22 with the Accounting format. 4 20 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100

Updated on: 3/4/2010 1 E_CH02_EXPV1_EOC _Instructions.docx

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:

Quality Homework Helper
Buy Coursework Help
Instant Assignments
Essay Writing Help
Finance Homework Help
Financial Hub
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

Hey, I can write about your given topic according to the provided requirements. I have a few more questions to ask as if there is any specific instructions or deadline issue. I have already completed more than 250 academic papers, articles, and technical articles. I can provide you samples. I believe my capabilities would be perfect for your project. I can finish this job within the necessary interval. I have four years of experience in this field. If you want to give me the project I had be very happy to discuss this further and get started for you as soon as possible.

$55 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
Finance Homework Help

ONLINE

Finance Homework Help

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

$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

Spss bivariate correlation interpretation - Imc planning process steps - And the moon be still as bright - Business and finance - Week 4 quiz questions - Cow eye dissection steps - Dispatches from pluto discussion questions - Equilibrium constant keq worksheet answers - Discussion Board - Build your own sten gun - The biology of osmosis jones questions answer key - Week 2 - Sales of cool man air conditioners have grown - Bouncing ball experiment lab report - Environmental management plan template free - Maurice turnor gardner llp - Art response - Careersinpsychology org careersinpsychology org impact media - How much does a pistachio weigh - Aldershot farnham and district - East coast medical centre - Do My Assignment - Project 1: Explore Networking in the Cloud ( Steps 1 trough 4, are already completed) - Craggy range sophia 2006 - Hershey chase experiment ppt - Electric field due to infinite line charge using gauss law - How to decode a matrix message - Contract process flow chart - Writing Content Creation: Navigating the Academic Landscape - The party line rachel rafelman - Social q app kmart - How to create a cost benefit analysis in excel - The mask you live in essay - Butl_ Learnign Feamework - Bt margin loan interest rate - Post its notes on a marriage sparknotes - Western arms shotgun serial numbers - Diploma of project management assessment answers - Todd marinovich 30 for 30 netflix - Alkanoic acid general formula - Vivekananda quotes on fear - Philippe cousteau jr net worth - 3 pages with strong reference Page - Dulux weathershield colours australia - Soc 120 week 4 discussion 2 - Entry notice form 9 - 12 week speed and agility program - Avista oxide 1kg jet black cement colouring - Borderlands 2 caustic caverns ever blow bubbles - Sony ericsson marketing strategy - Contribution margin per machine hour - Palm beach state college physical therapy - Bismillahi wa ala barakatillah - Kleenheat wa road trip - +91-8306951337 kala jadu specialist astrologer IN Bokaro - Labeling exercise 13 1 specimen collection devices and containers - Employee engagement definition shrm - Saini v all saints haque centre - Max oxidation state of mn - Pink floyd brick in the wall - 2 year old child observation report - Healthcare Financial Management and Decision Making - Seven areas of learning - Call of cthulhu 7th edition occupations - A nurse recalls insulin has an effect on which of the following groups of electrolytes? - Adjusted trial balance problems solutions - Bf3 react with ammonia - Week II Case study paper - Bus 308 week 3 assignment - Athenaze 3rd edition pdf - Horizontal and vertical sensitivity of oscilloscope - Instruments of darkness macbeth - How to calculate standard cell potential - Mann kendall test stata - Constant comparative method of data analysis - Course name: Info tech import in Strat Plan - Pac resources case study answers - Which of the following accounts appear on the balance sheet - Japan - Chocolate nirvana accounting answers - Writing a paragraph - Telstra international day pass business - Investment advisors inc is a brokerage firm - Neopentyl bromide undergoes dehydrohalogenation - Persuasive assay - Persuasive speech topics for high school - Appointment in samarra pdf - Franklin purchases 40 percent of johnson company - X treme vitamin company is considering two investments - 51 laird drive altona meadows - Microeconomics - Australian financial accounting 7e - Business Assignment 1 - First stage allocation in activity based costing - Informative speech proposal - Fill out study guide- nursing definitions - Mini Research Paper - International market research ppt - Abcd method of writing objectives - Student handouts word search