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

WEEK 5: INDEPENDENT PROJECT: EXCEL 2019 IN PRACTICE - CH 6 INDEPENDENT PROJECT 6-6

17/10/2020 Client: sathvik2009 Deadline: 10 Days

 


Clemenson Imaging LLC monitors increased revenue from the use of CT scan equipment. You analyze the number of patients and procedures by technician and location.


[Student Learning Outcomes 6.3, 6.4, 6.5, 6.6, 6.7]


File Needed: ClemensonImaging-06.xlsx (Available from the Start file link.)


Completed Project File Name: [your name]-ClemensonImaging-06.xlsx


Skills Covered in This Project



  • Calculate the net present value of a purchase.

  • Use TRANSPOSE to rearrange labels into a column.

  • Concatenate cells to display full names.

  • Use SUMIFS to summarize data.

  • Calculate procedure times.

  • Format times with fractions.



  1. Open the ClemensonImaging-06 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.

  2. Determine the net present value of a new equipment purchase.

    1. Click the Financials sheet tab and select cell H5.

    2. Use NPV with a Rate argument of 4.25%.

    3. Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.

    4. Edit the formula to add both costs (cells D4 and D5) at the end of the formula. The net present value is $268,921.79.



  3. Use TRANSPOSE and CONCAT to display technician names.

    1. Click the Technicians sheet tab. The names are in rows.

    2. Select cells A4:A10, seven rows in one column.

    3. Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.

    4. Press Ctrl+Shift+Enter to complete the array formula.

    5. Repeat the TRANSPOSE task for the first names in cells B4:B10.

    6. Select cell D4 and create a CONCAT formula to display the name in first name, last name order (Figure 6-111).ImagesFigure 6-111 CONCAT formula to display names

    7. Copy the formula in cell D4 to cells D5:D10.

    8. Click the Summary sheet tab, select cell A5, and create a 3D reference to cell D4 on the Technicians sheet.

    9. Copy the formula and preserve the borders.ImagesFigure 6-112 SUMIFS with absolute and relative references

      ImagesFigure 6-113 Change time format to display fractions



  4. Use SUMIFS to total number of patients by procedure and technician.

    1. Click the Summary sheet tab and select cell C5.

    2. Use the SUMIFS function with an absolute reference to cells $D$5:$D$41 on the Procedures sheet as the Sum_range argument.

      • The Criteria_range1 argument is an absolute reference to the image type column on the Procedures sheet, cells $E$5:$E$41.

      • The Criteria1 argument is a relative reference to cell B5 on the Summary sheet.

      • The Criteria_range2 argument is an absolute reference to the technician names column on the Procedures sheet.



    3. Select cell A5 for the Criteria2 argument (Figure 6-112).

    4. Copy the formula in cell C5 to cells C6:C11 and preserve the borders.



  5. Use SUMIFS to total number of patients by category and location in cells C14:C15.

  6. Look for and correct format inconsistencies.

  7. Calculate procedure times.

    1. Click the Times sheet tab and select cell F6.

    2. Build a formula to subtract the start time from the end time and multiply those results by 24. The result is shown in hours.

    3. Copy the formula to row 41.

    4. Select cells F6:F41 and open the Format Cells dialog box. On the Number tab, choose Fraction with a Type of Up to two digits (Figure 6-113).



  8. Save and close the workbook (Figure 6-114).

  9. Upload and save your project file.

  10. Submit project for grading.

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:

Custom Coursework Service
Assignments Hut
Pro Writer
Finance Homework Help
Solution Provider
Financial Hub
Writer Writer Name Offer Chat
Custom Coursework Service

ONLINE

Custom Coursework Service

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

$95 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I am 100% sure that I will meet your expectations in writing the essay . I have written over 4000 high quality plagiarism free papers and deliver within stipulated deadlines. I am familiar with a number of citation styles among them MLA, APA, APSA, Oxford, Chicago, OSCOLA, Harvard and Turabian. I believe that I am the right candidate for this project, and I guarantee quality work. I have a wide knowledge in this subject and I believe this will come a long way in giving you quality work. Thank you in advance

$95 Chat With Writer
Pro Writer

ONLINE

Pro Writer

Hello, I can assist you in every kind of writing. I am a professional academic/research writer and an MBA in business and finance. Please connect in chat session to further discuss the details.

$95 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!

$95 Chat With Writer
Solution Provider

ONLINE

Solution Provider

Hi.I have read your descriptions and i will provide you quality work.I am a Ph.D. writer with 5-6 years of experience. I have worked on several similar projects and can deliver quality works in a tight deadline. I am interested to hear more about the project and about the subject. If you award me the project I would be very glad to discuss this further and get started for you as soon as possible. Thanks You!

$95 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!

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

Find the value of rl for maximum power transfer - Cells alive mitosis answer key - Brothers and sisters riddle - Synthesis of aspirin from salicylic acid lab report - Balloon car ideas wheels - How do humans affect the biosphere - Khp and naoh reaction equation - Interactive reader unit 1 the anglo saxon and medieval periods - The main differences between informal and formal proposals are - Well done everyone song - 4000 essential english words 3 pdf free download - Websphere application server configuration comparison tool - Concrete mix for shed base - How to open floppy disk drive - Biography of alexander fleming in english - Managerial Accounting_Discussion4 - How to do harmonics on violin - Playstation error np 31970 0 - Creative writing george brown - What does the name christian mean - Wishaw general hospital consultants - Costco executive summary - Deliverable 7 - Vlog Presentation - Organizing function of management ppt - Personal philosophy of success essay examples - Capstone unit monash commerce - Case Study-Advanced Patho Wk2 - Cash register c++ - Examples of information systems in daily life - Yukon teacher sleeps with student - Crisis Intervention - Law & Ethics in the Business Environment - South florida virtual fusion center - Rhetorical Analysis - Why is plastic different than any other substance on earth - Banning mobile phones in school essay - Fin 571 week 5 assignment - Topic 4 DQ 1 and 2 - Module 3 Practice - Bend it like beckham summary - A monopolist always earns an economic profit - Dis11 - Numbered heads together powerpoint - Which of the following correctly describes the accounting treatment for interest payable? - Float type rain gauge - Common places mythologies of everyday life in russia - The flame test lab - Country manager international marketing simulation - Essentials of lifespan development 5th edition with connect - Robert half timesheet canada - Roach v electoral commission - Rough Draft Qualitative Research Critique and Ethical Considerations - Sea shepherd volunteer experiences - Jdpi - Characteristics of sedimentary rock - Dc network.gcu - Policy and legal_Project - Personal leadership development plan ncoa - Synthes plates and screws - Which of the following is a common pitfall that novice exporters come across? - Trevor nelson slow jams continuous mix - Health Care Laws - Steel diagrid structural system - Tomb of the unknown soldier wreath laying ceremony essay - Modish mist leave in treatment - What healthcare organizations collect uhdds data - What does bernard marx want - Ayaz meaning in quran - Electric dipole field lines - What's driving porsche case study - Are havighurst and santrock saying the same thing - Best restaurants in hoboken zagat - How to draw a roller coaster track - Differences between leadership and management - Is social business working out - Discussion - Nur601- Module 4 Discussion - Radiation pattern of a dipole antenna - Assignment - Fabric design of southeast asia - Metropolitan zoo gift shop weekly payroll - Excel 2016 capstone project ex-3 - 2015 vce methods exam 2 - Half a page - Suggest two (2) staffing strategies that organizations can utilize to maintain sustainability and minimize the impact of a significant percentage of the workforce approaching retirement age. - Financial statement analysis lessens the need for expert judgment - Flr fp form 2015 - Jayson morris room to read - Gordon’s Functional Health Patterns framework - Westan corporation uses a predetermined overhead rate - Ring size 56 in letters - Gateway cengage new account success html - Class 2 amalgam preparation - Smoke signals analysis essay - Experience history interpreting america's past 9th edition - An ophthalmoscopic eye examination involves - Top down risk assessment approach - What are quasars and pulsars - Problem 9 4 preparing an income statement - Clause 53.10 planning scheme