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.

07/11/2020 Client: papadok01 Deadline: 7 Days

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter 2: Homework Project 1

Formulas and Functions

Project Description: In the following project, you will perform preliminary work on the gym worksheet. You will then calculate cost, annual total, and total due. You will also determine the down payment and balance of gym membership. Your last steps will be to calculate the monthly payment and finalized the workbook.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Download and open the file named exploring_e02_grader_h1.xlsx, and then save the file as exploring_e02_grader_h1_LastFirst. Click OK in the message regarding the circular reference. 0 2 Create a named range for cells A18:C20 named Membership. 5 3 Insert a function to enter the current date in cell B2. 5 4 In cell C5 insert a function to display the basic annual membership cost of the first client. 5 5 Insert a function in cell E5 to calculate total amount. The function should add the cost of membership plus, if applicable, the locker fee. The locker column displays Yes for clients that rent lockers. 7 6 In cell G5 calculate the total due based on the annual total and years of membership in column F. 5 7 Copy the three formulas down their respective columns. 5 8 Insert a function in cell H5 to display the amount of down payment for the first client. 5 9 Locate and correct the circular reference for the balance in cell I5. The balance should be calculated as the difference between total due and the down payment. 7 10 Copy the two formulas down their respective columns. 5 11 Insert a function in cell J5 to calculate the first client’s monthly payment. Use appropriate relative and absolute cell references as needed. 6 12 Copy the formula down the column. 5 13 Insert a function in cell G14 to total the column. 5 14 Fill the function in cell G14 across the range H14:J14 to add additional totals. 5 15 Insert functions in cells H18:H22 to calculate basic summary information. 7 16 Format the payments in cells H19:H22 with Accounting Number Format. 5 17 Format the column headings on row 4 and 17 to match the fill color in the range E17:H17. 6 18 Format the cells G5:J5 and G14:J14 with Accounting Number Format. Use zero decimal places for whole numbers. 6 19 Apply Comma Style to the range G6:J13. Use zero decimal places for whole numbers. 6 20 Save the file and close Excel. Submit the file as directed. 0 Total Points 100

Updated: 01/07/2013 1 E_CH02_EXPV1_H1_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:

Essay Writing Help
Top Grade Essay
Buy Coursework Help
Quality Homework Helper
Peter O.
A+GRADE HELPER
Writer Writer Name Offer Chat
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.)

$187 Chat With Writer
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.

$187 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

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

$187 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

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

$187 Chat With Writer
Peter O.

ONLINE

Peter O.

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

$180 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

Greetings! I’m very much interested to work on this project. I have read the details properly. I am a Professional Writer with over 5 years of experience, therefore, I can easily do this job. I will also provide you with TURNITIN PLAGIARISM REPORT. You can message me to discuss the detail. Why me? My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks!

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

Hris cost benefit value analysis - Bcf mount gambier jobs - Electrical installation specification example - Exercises - Marble density kg m3 - How do you calculate girth of a package - How old was aragorn when he died - Philippe starck kettle cost - Hive empire pty ltd - Thermochemistry the heat of reaction lab report answers - Fisher exact test calculator 5x2 - Short Essay - Lab homework - Complete portfolio formula - Black flanked rock wallaby habitat - Grito de dolores speech - Lack of social or emotional reciprocity - Fill out study guide- nursing definitions - A normal population has a mean of - Wall street movie blue star - Control and simulation labview - Program development life cycle definition - Wendell berry the pleasures of eating summary - Hurricane katrina latitude and longitude - Bargaining mix in negotiation - Ursa major stargate 626 - Nurse practitioner cover letter pdf - 87 1/2 percent as a fraction - Headpiece filled with straw alas - Popped secret the mysterious origin of corn answer sheet - Nursing paper - Dharma and the heroic - Simon decision making model ppt - Easa exams in abu dhabi - Executive Program Practical Connection Assignment on Information Governance - Ammonium hydroxide reacts with hydrochloric acid - 0.99 dollars in pounds - Management Finance - Denzel brooks opens a web consulting business called venture consultants - Edit My Paper Narrative Paper - Masters in biostatistics uq - Hobbes and Locke as liberal thinkers - Capsim - Excel chapter 7 grader project homework - Truth in sentencing debate - I yearn for true gender equality japanese copypasta - A crane has a cable with a breaking strain - Population and sample quiz - Assignment of 2nd sem operations management - Steering rack gaiter split - Light bulb input energy - Thickness of antireflection coating formula - Who is the parent company of tylenol - Refer to the lincolnville school district bus data - COURSE: NURS-6050N-66/NURS-6050C-66-Policy & Advocacy Ashley Krebs, PhD, RN, CHSE - The journey of one buddhist nun sparknotes - 500 words essay - Los arrecifes de coral son unas plantas de intensos colores. cierto falso - Which of the following is a primary disadvantage of viral marketing? - Nike product life cycle stage - 2 short paras 150 each - Pestel analysis of kfc - “ KEY WORD” (350-500 words) - Construction expert - Four consecutive odd integers whose sum is 56 - Discussion - How far is 1 million steps - Datamining - Dbt skills training manual - Activity 5 - Din en 13017 1 - Cognitive habitual affective decision making - Aastra 610d master reset - In the upward sloping segment of the aggregate supply curve - Introduction to law and the legal system 10th edition - Core skills for work developmental framework - Discussion 1 - Gold coast junior rugby league - Goldilocks and the three bears musical script - Moctezuma and cortes guiding questions document a answers - Market myopia definition - How to pronounce conga - Intercept cs cold sore prevention system shoppers drug mart - David christopher orthopedic surgeon case study - Week 2 discussion law enforcement - Joint venture agreement letter - Abn amro bank chicago - Lodgement reference number nab - No-no boy essay 9AM - Case study - APA assignment - Panchromatic in a sentence - Introduction to Proof and Problem Solving - Norman crisologo and max eigenmann son - Triage assessment form for crisis intervention - Dance definition in art - Flower synonyms in sanskrit - A four sided figure is called - Pink think lynn peril essay - Customer interviews