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 independent project 6 4

04/01/2021 Client: saad24vbs Deadline: 14 Days

-


D4


A


1 Boyd


2 James 3


Douglas


Jonathan


4 B-;,y;; ---- 'j;~;;--7 5 Douglas Jonathan : 6 Lynfield Patti :


7 McFarland Donna I I a Olander Ann ie :


I 9 Vonbank MaryAnne I 10 Woods ___ Samantha J 11


12


C


Boyd


D G


Lynfi eld Mcfa rlane Ola nder Vonbank Woods


Pam Donna Annie Mar-iAnnESamantha


Boyd jJames


Douglas Jonathan


Lynfield Patti


McFarlanc Donna


Olander Annie Vonban~ MaryAnm Woods .Samantha


1m ccn1i·I


Function Argument;; X


CONCA,


Text1 b <chnicion,!D4 [i!liu) - "Boyd' Teid2 I'-'-·,_· ______ _.:.:§,.,.J Ti:!rl3 f1echnicianslEAj ~ "Jame 5·


Teict4 !ii) nl


Ci;inu1h:nirto-a li~t or n1nge cf 1o1. strinQ~.


Tcxt:3 : tcxt1,terl2, ... arc: 1 to 2.54 text ~tring5 or ranges to be joined to .A single text s1.ri n c.


Formu la result c= 5oltd. Janies


H c la o a tbi i [unction .___o_K___.! [ ~


USING MICROSOFT EXCEL 2016 Independent Project 6 6


Step 1: Download start file


Excel 2016 Chapter 6 Exploring the Function Library Last Updated: 12/27/17 Page 1


INDEPENDENT PROJECT 6-6 Clemenson Imaging LLC analyzes increased revenue from the purchase and use of CT scan equipment. You determine the number of patients and procedures by technician and location and transpose technician names.


Skills Covered in This Project • Calculate the net present value of a


purchase. • Concatenate cells to display names. • Use SUMIFS to summarize data.


• Use TRANSPOSE to rearrange labels into a column.


• 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. a. Click the Financials sheet tab and select cell H5. b. Use NPV with a Rate argument of 4.25%. For the Value1 argument, select cells D7:D13. This is the


same as entering each value argument separately. c. Edit the formula to add both investment costs (cells D4 and D5) at the end of the formula.


3. Use TRANSPOSE to arrange technician names. a. Click the Technicians sheet tab. The


names are in rows. b. Select cells A4:A10, seven rows in one


column. c. Select TRANSPOSE from the Lookup &


Reference category and select cells A1:G1 for the Array argument.


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


e. Repeat the TRANSPOSE task to place the first names in cells B4:B10.


f. Select cells A4:B10 and copy them to the Clipboard.


g. Select cell D4, click the arrow with the Paste button [Home tab, Clipboard group], and choose Values (Figure 6-110).


4. Use CONCAT to display technician names. IMPORTANT: The CONCAT function is new for the 2016 version of Excel. If you are using Excel 2013, use the CONCATENATE function instead.


a. Click the Summary sheet tab. b. Select cell A5 and use CONCAT


with cell D4 on the Technicians sheet as the Text1 argument.


c. The Text2 argument is a comma and a space.


d. The Text3 argument is cell E4 on the Technicians sheet (Figure 6-111).


e. Copy the formula to display the remaining names and preserve the borders.


6-110 Transposed and copied data


6-111 CONCAT with 3D references


-


Functi on Arguments X


SUMIFS


Sum_range I Procedures !SDS5:SDS41 I~ ! {" Patients ";4;5;1;6;5;3;4;1;3;2;6;2; 3;1... "


Criteria_range1 I Procedures !S ES5:SES41 [~ ] fl nage Type·;· Dexascan·;· cr Scan·; .. .


cmena1 I ·mri· [pii] ~=====~ :riteria_range2 I Procedures !SAS5:SAS41 [~ )


-m·1-


r rechni cian·;· s onna M::Farland·;· Ma1


Criteria2 IL' _bo_,_y_d* _______ ~[ .. ~=~! ..,


Add s tt-e cell s specified by a given set of conditi ons or crite ria.


Criteria2: is the cond iti on or criteria in the fo rm of a number, expre ss ion, or text that defines w hich cells wi ll be added ,


Formula result=


Hele on thi s function


Format Cells


Number Al ignment


£ategory:


General Number Cu rrency Accountino Date Time P, rCt!!nta ,


Scientific Text Special Custom


Font


Sample


1/4


Jype:


Border


U to on• d1 1t 114


Fill


Up to two digit, (21/2.5) Up to three d igits (312.1943) As halVes (1/2) As quarte rs (2/4) As eighths (418) As sixteenths 18/1 6)


,___o_K_...,! I Can cel


? X


Protection


"


OK Cancel


USING MICROSOFT EXCEL 2016 Independent Project 6 6


Step 3: Grade my Project


Step 2: Upload & Save


Excel 2016 Chapter 6 Exploring the Function Library Last Updated: 12/27/17 Page 2


5. Use SUMIFS to total number of patients by procedure and technician. a. Click the Procedures tab and name cells A5:F41 as Data. b. Click the Summary sheet tab and select cell C5. c. Use SUMIFS with an absolute reference to cells D5:D41 on the Procedures sheet for the


Sum_range. Since the range name includes the column label, you must include the label in each CriteriaN range.


d. The first criteria range is an absolute reference to the image type column on the Procedures sheet. Its corresponding criteria is mri.


e. The second criteria range is an absolute reference to the technician names column on the Procedures sheet.


f. Type *boyd* for the Criteria2 argument. This string means that any character(s) can precede or follow “boyd” (Figure 6-112).


6. Copy and edit the SUMIFS formula or start a new formula to complete data in cells C6:C11.


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


8. Look for and correct format inconsistencies.


9. Calculate procedure times. a. Click the Times sheet tab and


select cell F6. b. Build a formula to subtract the


start time from the end time and multiply those results by 24. The result is shown in hours.


c. Copy the formula to row 41. d. Select cells F6:F41 and open


the Format Cells dialog box. On the Number tab, choose Fraction with a Type of Up to one digit (Figure 6-113).


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


11. Upload and save your project file.


12. Submit project for grading.


6-112 Wildcard characters in the argument


6-113 Time results formatted with fractions


-


Clemenson Imaging


Time Durati on for Procedures i Hours


I',;_., ~ lmHeT,po S1alt E'IICI


CUJ2.< Gr<ca1 a.·, ~ :n 9:lSAM 9:M"M C'JJZJ' ,11,:..ntaKoc Cl'S<.:n lDOF\11 =PM am.a "'"''"'"" """ lQ:l.,;..Wll 1 1:'.!,0Ji.Mi = Gr,;_;n i!a•t '= '""'"" !llXl -"MJ J.Cm ..... = Gm,n ilay 220/'M .usPM = M-nmwo.:: !.\aa=:n = ll11l-= U : ntaK<>: ,u .. =- .us .... = A<1n~<>n ,.,.,. SOOAM 10:MAM C!OQ;l f<;)Jl'a'O.O A1\m,,")''l)l',f 12DPM 3'-Gi'M C!El c;,-.,...a;., - - ._ .... 31JOF\II -4:.Gi'M C'.ll5' f<;)Jlla'O.O i:1.1~-rn...:;o,~.rz.....,, lDIJ"M =i'M


=· ,U..:. n·ta.wo.: -.,,..,,.,,.,..,,,, ll.SO ""' 1,Gi'M a!Bl M-.nt.awo: ..,. l(l.;lSAM. 1120.AM Cl.Oil llliDll.'~ Daa=:n = ll11JAM co;;; """'"'"" !.\aa=:n lllXIAM ll:41.QM C!ll=I Gir..-..fl 3.y O'S-e..n 2;1SIIM 3:'.?ll'"' rum f<;)Jl'<t\>11 Cl' SG.11 =F\,11 S1Xli'.,. C!lll'S Gr..:.113.y """ S,:JJAM 111JOA_M cum: ,u ,:ntoNO< l,UO Sl1JOJ.M ll.2D.O ... C'.IIEl ~" ITS<= -41Xli'M .i.:30i?M QllS4 ~"'_;z:"" Cl'SG.11 SOOSIM 9.>I.SAM C'.IIEl' f<;)mar<>n '""" llilli'M 2'.llll'M QO!!O Gr...:.n ~ ·, ,., .. 2;:l$1P;U =" ... Cll!!3 U : ntONO< " ~- . . , lDll""' l:4SPM C'.096 ,-..,llil~O:"t '""" 10:lSAM i=.o ... Cll!!9 A"n~= ~ .n llJ:D.t.M l l:20A.M rum G:r"" S.•t ~ Jl SlJOAM SZJJl._1,1


= f<;>llla:OJI 0 ':oG; n 21JO,,U 3:'.?lll'M C'.laS G,,;_;n a.·, O:SQ.tl 3jJQ,-.. 3.>t.Si'M run M·:.ntowo.: Aft..•-.~1,:p:iri!N 41J(J,,U 4:.Gl'M C'.ll.4 Jl<l=<HI ==,.-;r:mN 3.>t.Sl'M _;j)QyM


aJ.17 Gr.::.n :by ,. __ . lllXJi..C..U l l:2QA_\I


ruzo lot.:ntONO< '=-·~, l21JOF\II l:MPM CUZ3 A~•·~~• g==·~~, -41J(Jft< =p- Olli Gr.can a.·, I\Ull 10:1.>AM 11:MA_M C'.ll9 /,llll:O,VO,: ,,.,. gro,... 1:u s-


-U-4 3/J.


1 1/J. 1 1 3/4


l/2


l '" 21' l lj :&


1 3 :t 3:&


21':0


1 11 '4 1h


l/3 l ll-' l l/2 3 1 'lh


l l/l 1 3/4


2 1/2 2 .,,~


3:t


11 "


21.!


11 1 3:,.


3,:,.


12 :,.


- l l/2


3/4 1 1/4 1 ]14


Clemenson Imaging. LLC Purchase and Training Cost Analysi•


........


<UIIID


Clemenson Imaging


Second Quarter Summary


Techni:ian


Boyd, Jam es


Douglas, Jon athan


Procedure


MRI


CT Scan


# of Patients


4


13


.lYTifield. Patti .. .... ...... . Angiography .. ..................... . ..2 MCfarl and, Donn a ....... Angiography .. 0


q_l;inder, Annie MRI


Vo nbank.. MaryAnne ... MRI ............... .. .. .. .. ............... 2


Woods, Sam antha CT Scan 1


.... Patient Category Locati>n


Scheduled Ap? eto n.


Wa lk·ln Green Bay


JI of Patients


22


17


USING MICROSOFT EXCEL 2016 Independent Project 6 6


6-114 Completed worksheets for Excel 6-6


Excel 2016 Chapter 6 Exploring the Function Library Last Updated: 12/27/17 Page 3


Independent Project 6-6

Skills Covered in This Project

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:

University Coursework Help
Top Essay Tutor
Homework Guru
Quick Mentor
Coursework Assignment Help
A+GRADE HELPER
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

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

$232 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$235 Chat With Writer
Homework Guru

ONLINE

Homework Guru

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

$232 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

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!

$225 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment 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!

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

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

Pattison sign group heath springs sc - Master of teaching primary wsu - Nottingham university malaysia jobs - Rod tip top size chart - Basic algebra cheat sheet - Human Resource - What is the difference between assessment and development centers? - Taxation of individuals and business entities solutions - Monash exam timetable release - Importance of holy orders - As data overflows online researchers grapple with ethics - Linux server market share 2012 - Ccna 4 chapter 1 hierarchical network design - Single electron transistor applications - PSY-838 Wk 6 DQ2 - Swot analysis activity for students - Chapter 13 capital structure and leverage - 6700 kj to calories - Advanced Financial Accounting - Comprehensive Consolidation Method - Mcdonalds cost leadership strategy case study - 4 ways an organism can become a fossil - Jacob and esau slideshow - Order # 11058 - Blue oyster cult scaruffi - To create change transformational leaders ______________ - Health Screenings and Prevention Assignment - Unit circle clockwise and counterclockwise - Avk wafer check valve - Clinton institute training - Speech of joseph mccarthy wheeling west virginia february 9 1950 - Discussion - Obstacles to implementing standardized terminologies within ehrs - RUA Patho - Rime of the ancient mariner study guide pdf - Soap note example nurse practitioner - Annie hall box office - Experiment 1 heart valves and pumps - How are interlocking spurs formed - Lubricants inc produces a special kind - Rationalism - Literature - Classroom activity sheet nature versus nurture analyzing twin studies answers - Internet Marketing - 4 h's and 4 t's of cardiac arrest - Syndetic and asyndetic listing - The sql command that allows a user to permanently save data changes is _____. - Pizza hut income statement - Persuasive techniques in writing - The international marketing environment - Advantages and disadvantages of market penetration ansoff matrix - Lopeswrite grand canyon university - Jeannette walls the glass castle quotes - How to present appetizers attractively - How to write a private investigation report - Cybersecurity - Creating a professional profile - Simnet office 2016 integrated applications project 3 - The hill reaction photosynthesis - Problem 2 2a part level submission - Bernzomatic st2200t butane micro torch manual - Describe the relationships and differences between hackers and viruses - Closed loop position control system experiment - Renew student id unsw - BE - Journal Analysis 4 - Calculation of mean median mode of grouped and ungrouped data - Meiosis results in what - In 508 bce, who instituted the first athenian democracy by establishing a council of five hundred? - Persuasive Speech Outline and Speech - Christleton high school teachers - Creating and Communicating a Security Strategy - Gary yukl leadership in organizations 8th edition - X 2 2x 19 0 - Stock symbol for abercrombie and fitch - Why is it important that specific tissues respond to insulin - Research paper - GLOB/STR (U5_RPL) - Physical trade barrier example - What is the perth metro area - Hard knocks 811 north motorcycle club - Discussion - What is alton towers mission statement - The 7c's of effective communication - Zappos promo code november 2018 - We yevgeny zamyatin cliff notes - Eco 110 discussion question answer - Act 3 scene 2 macbeth summary - Uniform civil procedure rules 36.7 - Indiana iu plagiarism test answers - The strategic target of a best cost provider is - Trimalchio's Dinner Party Response Paper - Global Cities Form - Weapon handling test sa80 - Paco 500 - 106 in lbs to ft lbs - Ed eats a slide - Step 3 candidate website - Market research - 399 713 rounded to the nearest thousand - Cisco total output drops incrementing - Legal environment of business 3rd edition melvin - Mississippi trial 1955 summary