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

Excel 2016 in practice ch 6 independent project 6 6

16/11/2021 Client: muhammad11 Deadline: 2 Day

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

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.
Open the ClemensonImaging-06 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
Determine the net present value of a new equipment purchase.
Click the Financials sheet tab and select cell H5.
Use NPV with a Rate argument of 4.25%.
Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.
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.
Use TRANSPOSE and CONCAT to display technician names.
Click the Technicians sheet tab. The names are in rows.
Select cells A4:A10, seven rows in one column.
Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.
Press Ctrl+Shift+Enter to complete the array formula.
Repeat the TRANSPOSE task for the first names in cells B4:B10.
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
Copy the formula in cell D4 to cells D5:D10.
Click the Summary sheet tab, select cell A5, and create a 3D reference to cell D4 on the Technicians sheet.
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
Use SUMIFS to total number of patients by procedure and technician.
Click the Summary sheet tab and select cell C5.
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.
Select cell A5 for the Criteria2 argument (Figure 6-112).
Copy the formula in cell C5 to cells C6:C11 and preserve the borders.
Use SUMIFS to total number of patients by category and location in cells C14:C15.
Look for and correct format inconsistencies.
Calculate procedure times.
Click the Times sheet tab and select cell F6.
Build a formula to subtract the start time from the end time and multiply those results by 24. The result is shown in hours.
Copy the formula to row 41.
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).
Save and close the workbook (Figure 6-114).
Upload and save your project file.
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:

Smart Tutor
Instant Assignment Writer
Homework Master
Top Quality Assignments
Assignments Hut
Coursework Helper
Writer Writer Name Offer Chat
Smart Tutor

ONLINE

Smart Tutor

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$26 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$47 Chat With Writer
Homework Master

ONLINE

Homework Master

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$31 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$49 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$23 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

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

Commutative identity associative distributive properties - Discussion(NCM) - 13th documentary questions - American hospitality academy world campus - Key Success Factors portion of an industry analysis report that will be provided - Philosophy - Comparison of irp ppp and ife theories - Creating Visio Data Models and Designs Using Visio - Psc1515 quiz - Employment Discrimination - 8-4 Project Part Two: Presentation - 39.50 dollars in pounds - Swot analysis of biotech industry - 36 balmoral road leura - How to make an appendix in powerpoint - Two drivers tom and jerry - Cinemax oberon mall kochi ticket rate - Leadership Empowerment & Self-Leadership Analysis - RM-RESEARCH-10 - Clark ford watches prices in oman - On making an agreeable marriage critical reading answers - Annual revenue analysis worksheet excel - Specific purpose statement for informative speech example - 6 iberis place woodvale - Discrete time fourier transform examples - Unilever unifies globally with enhanced erp - Team leadership model ldr 300 - ORGANIZATIONAL BEHAVIOR - Which one of the following statements about forecasting is false - Template for taking notes - Database system and file system - Sap theme designer tcode - An increase in the price of gasoline will - Photosynthesis using light to make food chapter 7 - Mother of the groom poem - Limiting reactant sodium bicarbonate acetic acid - Lecture Reflection --- due in 12 hours - Lutz jesco middle east - Cpa taxation exam structure - Multiple choice comprehensive problem on relevant costs - Creative problem-solving and decision-making skills action plan - Mitosis vs meiosis video - The piano lesson themes essay - Maya angelou quotes christmas lights - Iso 14001 audit checklist - Comprehensive international business plan - Dorothea orem self care deficit theory powerpoint - Haymes deep brunswick green - Reiki licensing commission - Haro flightline sport sixty sixty one - Describe the major threats in doing business in global markets - Tennis serve preparation phase - Differences between booker t washington and web dubois essay - How to make a tows matrix - Two main arguments against scientism - Long run average total cost - Which of the following is a capital budgeting decision - What is the ph of a 0.10 m naoh solution - Netapp fas2020 power consumption - Introduction to search and rescue - Pyxis medstation es system station tutorial assessment for nursing answers - 4s week 11 assignment IA - DiscussionB week 2, 5, 6 - The ultimate gift questions and answers - Maslow's hierarchy needs - Critical Thinking Final - Define design class diagram - MLK - Student success in college doing what works 3rd edition - Ethics in Criminal Justice Research - How to neutralize chemical equations - My year of meats sparknotes - Frankston special development school - A Doll's House - Tutorial 8 sam project 1a answers - Induction problems with solutions - Extended metaphor poem ideas - Magnetic field from two wires mastering physics solutions - Warner company's year end unadjusted - Hazard community technical college - Samovar and porter definition of culture - Career connection values and strategy paper str 581 - Social work role play scripts - RESIDENCY PRESENTATION - Descriptive statistics and data visualization - Us and them questions and answers - Making art portfolio lesson plan - A risky asset can have a ____ beta. - Assignment Statistics - Ethical lens inventory blind spot - Membership form format in word - Rectangular tray using sheet metal - Holap advantages and disadvantages - You ve just joined the investment banking firm of dewey - Separation of the components of a mixture lab report answers - Color vowel chart cards - Proxies and 10Q reports (KELLOGG & GENERAL MILLS) - Guarded by birds evelyn araluen - Chapter 10 arbitrage pricing theory - Your mom knows nike shirt meaning