Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I updated Clear Pictures. kindly explain a little bit as well. Task 2 Working with Files in Microsoft team Step 1: Open google sheet, create
I updated Clear Pictures. kindly explain a little bit as well.
Task 2 Working with Files in Microsoft team Step 1: Open google sheet, create Excel document titled Units Sell. In the Units Sell create the following 7 columns in the list: OrderDate. Region. Item, Unit, Unit Cost and Total The formula will be used are (Cell N. Cell G. Cell O, and Cell Q) a. Count the Item (the frequency represented in Cell N) The formula will be used: H=COUNTIF (A2:A44, G2) b. Total of each uint sell Total I==SUMIF($A$2:$A$44,G2,$C$2:$C$44)| c. % Freq M=(J2/$J$7)*100 Step 2: Create a bar chart that looks like the one below. Include the chart you make and the date for the chart on the page you print. This page should include the two data sets and the two charts. Print preview to make sure it all prints on one page. Trem Typ Frequency Total Pencil 13 172.861 Binder 15 36.071 Pen 5 55.951 Pen Se 7 Desk 5251 TOTAL 873.271 4 | Frea 4.1305 4.1305 6.407 9.5492 60.119 83.391 ##### Chart Title 16 14 12 10 8 Ite Deck Desk Pencil 5 Binder 6 Pencil Pen Binder Binder 10 Pencil 11 Pen Set 12 Binder 13 Binder 14 Pen Set 15 Pencil 16 Pen Set 17 Pencil 18 Pencil 19 Pencil 20 Binder 21 Binder 22 Pencil 23 Pencil 24 Binder 25 Pen Set 26 Binder 27 Pen 28 Pen Set 29 Binder 30 Pencil 31 Binder 32 Binder 33 Pen Set 34 Pen 35 Pen Set 36 Binder 37 Pencil 38 Pen 39 Desk 40 Binder 41 Pencil 42 Pencil 43 Binder 44 Pen 1234se 7 8 9mmBB% 8a% Units Unit Co. Total 2 125.00 250.00 5 125.00 625.00 7 1.29 9.03 11 4.99 54.89 14 1.29 18.06 27 19.99 539.73 28 8.99 251.72 28 4.99 139.72 36 4.99 179.64 42 23.95 46 8.99 413.54 50 19.99 999.50 50 4.99 249.50 53 1.29 68.37 55 12.49 686.95 66 1.99 131.34 67 1.29 86.43 75 1.99 14.9.25 80 8.99 719.20 87 15.00 ##### 90 4.99 449.10 90 4.99 449.10 94 19.99 ##### 96 4.99 473.04 4 4.99 19.96 15 19.99 299.85 16 15.99 255.84 29 1.99 57.71 35 4.99 174.65 60 4.99 299.40 60 8.99 539.40 62 4.99 309.38 64 8.99 575.36 74 15.99 1,183.26 81 19.99 1,619.13 95 1.99 189.05 96 4.99 479.04 3 275.00 825.00 7 19.99 139.93 32 1.99 63.68 56 2.99 167.44 57 19.99 1.139.43 76 1.99 151.24 2 Page O Pen Binder Pen Pen Set Desk N H Ttem Typ Frequency Pencil 13 Binder 15 Pen 5 Pen Se 7 Desk 1 TOTAL J Total 172.861 36.071 55.951 83.391 5251 873.271 M 7. Freq. 4.1305 4.1305 6.407 9.5492 60.119 mmmmmm Chart Title 16 14 12 10 Penda Binder Pen Pen Set DeskStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started