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

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

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: ,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'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 Jlt.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•

........

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:

Engineering Mentor
Homework Tutor
Chartered Accountant
Maths Master
Write My Coursework
Top Writing Guru
Writer Writer Name Offer Chat
Engineering Mentor

ONLINE

Engineering Mentor

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$34 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$39 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$19 Chat With Writer
Maths Master

ONLINE

Maths Master

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.

$41 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$31 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

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

Hno3 is a stronger acid than hno2 - Medicare provider analysis and review - Aws iam policy validator - Re: questions - +91-8306951337 vashikaran specialist near me IN Hubballi-Dharwad - RESPONSES - Interpreting the tsi 2 - Chapter 5 it infrastructure and emerging technologies - Find your why workshop - Discussion - Nike mission statement and strategy - Chapter 10 test marketing answers - One by kathryn otoshi summary - The skeletal system lab activity answers - The beach a river of sand - Hai di lao manicure design - 12 - Solarwinds netflow configuration cisco - Develop a resource schedule in the loading chart - A computer program is - Hca430 Week 1 Dq 1 - Sjsu graduate acceptance rate - Making Consumer Choices - Marketing Management - Research Paper - Project Week 1 10/28/2020 - Mini ice plant business - Shone and parry event planning process model - Coru registration for radiographers - Roland pinch roller sensor - An independent-measures study uses ____ - Aova international ind southport - Identifying data and reliability shadow health - Which of the following statements concerning leases is true - Thesis in a speech outline - Digital notice board project - What adjustment is made for underapplied overhead - Paper - Ssop in food industry - Describe the structure of the federal reserve system - Race in america matthew desmond and mustafa emirbayer - Abercrombie and fitch marketing case study - Discussion - Disney on ice corpus christi 2017 - Media ethics issues and cases pdf - Bin collection moreton bay - Dit bolton street courses - You're a good man charlie brown lucy - Analyzing Emergency & Disaster Concepts - Properties of colloidal gold - Gram staining results and discussion - STATISTICS - Geraldo no last name questions and answers - 100 greatest movies list - 44 salisbury drive terrigal - Market penetration assignment due in 18 hours - Assignment 450 words - They say i say 3rd edition templates - Does a weak entity need a partial key - Https www internetsociety org tutorials your digital footprint matters - The three towns medical practice - Write a C# program to input 10 elements to a one-dimensional array. Search all the ‘0’s in the array, move them to the end of the array and print the array elements. - Drown junot diaz theme - Sunnow strayer - (Rok) week 11 discussion eco100 - Feast watson wood stain colour chart - Distribution channel of nike ppt - Example of variety seeking buying behavior - Which answer best describes an unsubsidized federal loan quizlet - Lysozyme purification lab report - BUS HW - M18a1 claymore mine powerpoint - Avid trf filled out - What is the primary standard used in this experiment - Window server identity - Http www uml diagrams org use case diagrams examples html - Wendy franchise owner salary - Express your answer as a chemical formula - Nmol l to ng ml converter - How long was the wall nehemiah built - Grasslin towerchron qe2 programmer instructions - Compare Global Growth, 1700-1900 (Plagiarism Checked) - Gender and women's studies critical terrain second edition - P2121 throttle/pedal position sensor/switch d circuit range/performance - CRIMINAL JUSTICE - Captive wild animal management - Public speaking course reflection essay - What is a rms customer numberwhat is a rmwhat is a rms customer numbers customer number - Magpies kidlington holiday club - When was buster keaton born - Mass of a 50 ml graduated cylinder - Arti sood economy rent a car - Music assignment - SUBMIT BACK WITHIN NEXT 6 hours - Catalina 22 owners association - Reflect on the need to improve outcomes in healthcare - How many atoms are in 0.70 mol of iron - Themes in behind the beautiful forevers - Civil law, criminal law, or both - Ibm ts1150 tape drive - Argument - Business Math (Inventory development plan)