Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello I just need make a review for my work, and I think I did something wrong with the chart, can someone help? Project Description:

Hello I just need make a review for my work, and I think I did something wrong with the chart, can someone help?

image text in transcribedimage text in transcribed

Project Description: You work for a design firm that uses many of the software applications in the Adobe Creative Suite, especially Photoshop, Illustrator, InDesign, and Dreamweaver. Your boss has asked you to evaluate whether it would be worthwhile to upgrade the software to the latest version. In addition to reviewing any new or revised features, you also want to provide an analysis on any improvements in product efficiency and performance. You have the data, now you just need to analyze it. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open TIA_Ch4_Start and save as TIA_Ch4_LastFirst. Type Current Average in cell F1, and type New Average in cell J1. In cell F2, use the AVERAGE function to compute the average of the range C2:E2. In cell J2, use the AVERAGE function to compute the average of the range G2:12. Select cell F2, then drag the Fill Handle to cell F13. Select cell J2, then drag the Fill Handle to cell J13. Select the cells in C2:J13, then format the cell contents with Number format with one decimal Select cell A2, and Merge and Center across cells A2:A5. Then adjust the orientation of the text to Rotate Text Up (90 degrees) (In Excel 2016 apply Rotate Text Up). Middle Align cell contents and Bold text. Use Format Painter to copy these formats to cell A6 and cell A10. Select range A2:J5, then apply Thick Box Border (In Excel 2016, apply Thick Outside Borders). Repeat with ranges A6:19 and A10:J13. Select range F1:F13, then apply Thick Box Border (In Excel 2016, apply Thick Outside Borders). Repeat with range J1:J13. Select J2:J13. Create a Conditional Format using the Less Than rule. In the Format cells that are LESS THAN box, enter =F2 (be sure to enter this as a relative reference). Set up the rule to format the cells with the fill color Green, Accent 6, Lighter 60% (tenth column, third row) and the font color Green, Accent 6, Darker 50%. Create a Clustered Bar Chart using ranges B1:B13, F1:F13, J1:J13. Modify the Clustered Bar Chart with a title Benchmark Comparison: New and Current Versions of CS Software and add a title to the Horizontal Axis that reads Seconds. Position and resize chart so it fits A16:J34. Save and close the workbook, and submit for grading Filct Home Insert Draw P age Layout Formulas Data Review Vir Help: Pruer Pivot Share Comments > B K L M N O P Q - 27.9 C Current Trial 12.9 32.2 10.0 18.9 32.2 72.0 324 8.3 Illustrator Photoshop D E F G H I Current Current New Trial New Trial New Trial Trial 2 Trial3 Current Average New Average 16.6 13.2 14.21 17.7 18.3 17.8 329 32.8 8.2 10.9 8.3 11.1 12.9 113 13.2 16.3 15.5 15.0 276 20.8 22.4 8.1 10.8 37.5 40.6 19.1 37.2 78. 1 72.3 24.0 27.0 26.1 25.7 20.8 15.5 16.11 16.5 19.7 11.5 10.7 10.81 12.5 19.3 21.6 19.1 20.5 12.4 14.5 14.3 21.6 20.8 17.0 18.3 20.9 34.3 16.6 38.0 14.0 14.1 14.2 11.8 12.8 116 4.2 7.6 7.0 6.0 2.1.8 Straighten image with Ruler Tool Straighten image with Ruler Tool and crop Add single image as layer Add 3 imeres as layers Make modifications of stroke width Add arrowhead to existine path Joiri Paths Create 3-point perspective grid Scale, crop, and rotate image Format headline to span 3 columns Create 3-column paragraph Change gap between images 74.1 12.0 18.2 18.5 13.3 10.2 20.7 InDesign 20.5 19.0 33.0 10.3 Benchmark Comparison: New and Current Versions of CS Software 1 50 100 150 20.0 Seconds Sheet1 +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-12 With Study Guide And Working Papers

Authors: Jeffrey Slater

13th Edition

0133866300, 9780133866308

More Books

Students also viewed these Accounting questions

Question

Describe the importance of global talent management.

Answered: 1 week ago

Question

Summarize the environment of recruitment.

Answered: 1 week ago