Home / Expert Answers / Computer Science / please-send-the-step-by-step-please-read-the-question-nbsp-thank-you-a-20-lael-also-wants-to-su-pa519

(Solved): Please. Send the step by step. Please read the question  Thank you a. 20. Lael also wants to su ...



Please. Send the step by step. Please read the question  Thank you

a.
20. Lael also wants to summarize membership data for all organizations using a PivotChart
to help determine which groups a
Final Figure 2: Academic Groups Worksheet
B
C
D
1 Group Name
Type Activities Office
2 Computing Club
Academic Field Public
3
Final Figure 3: Academic Pivottable Worksheet
Group Name
1 Activities
2 Field
3
4
5
6 Professional
7
Astronomy Society
Comput
Final Figure 4: All Groups Worksheet
2022
2021
5
13
Group Name
Type Activities Office
Accounting and Finance Forum Academic P
Final Figure 5: All Groups PivotTable Worksheet
G
H
Activities
Educational
Field
1 Office
Private
2
3 Row Labels
2021 Members
Final Figure 6: Activities PivotTable Worksheet
G
How Labels
2021 Membership 2022 Membership 2023 Member
92
140
179
22
Edwion
a. 20. Lael also wants to summarize membership data for all organizations using a PivotChart to help determine which groups are showing the most interest from students. Switch to the Activities PivotTable worksheet. Based on the PivotTable on the Activities PivotTable worksheet, insert a PivotChart using the Clustered Column chart type and format it as follows: Resize and reposition the PivotChart so that the upper-left corner is located within cell F3 and the lower-right corner is located within cell 019. b. Add the chart title Membership by Type to the PivotChart using the Above Chart option. Filter the PivotChart so that only the membership data for groups with educational, field, and fraternal activities in each type of group displays in the chart. (This filter may be automatically applied when you create the table.) C. Final Figure 2: Academic Groups Worksheet B C D 1 Group Name Type Activities Office 2 Computing Club Academic Field Public 3 Astronomy Society Academic Field Private 4 Humanities and English Club Academic Professional None 5 Environmental Management Club Academic Service Private 6 Communication Studies Club Academic Professional Public 7 Nursing Club Academic Service Private 8 History Club Academic Professional None 9 Psychology Association for Students Academic Professional Private 10 Investigative Forensics Club Academic Field Public 11 Accounting and Finance Forum Academic Professional None 12 13 Largest Academic Club, 2023 14 Computing Club 15 16 2023 membership in large groups: 17 417 E F G 2021 2022 2023 54 81 93 37 51 76 47 54 64 45 44 52 30 32 51 44 47 41 48 40 40 29 26 23 6 8 10 5 6 5 Academic Groups Academic Pivo + Final Figure 3: Academic Pivottable Worksheet Group Name 1 Activities 2 Field 3 4 5 6 Professional 7 Astronomy Society Computing Club Investigative Forensics Club 158 183 D 2021 Membership 2022 Membership 2023 Membership 97 140 179 37 51 76 54 51 93 6 8 10 159 5 6 5 30 32 51 48 40 40 47 54 29 26 22 91 93 45 44 52 44 47 41 345 389 455 Accounting and Finance Forum Communication Studies Club History Club Humanities and English Club Psychology Association for Students 9 10 11 12 Service 13 Environmental Management Club Nursing Club 15 Grand Total Academic Pivot Table All Groups A Groups Pivot Table Final Figure 4: All Groups Worksheet 2022 2021 5 13 Group Name Type Activities Office Accounting and Finance Forum Academic Professional None Alpha Chi Omega Greek Fraternal Private Alpha Phu Greek Fraternal Private Alpha Phi Alpha Greek Fraternal Private Arab Students Association Cultural Educational Private Astronomy Society Academic Field Private Badminton Club Recreational Field None Black Students Association Cultural Educational Private Broomstick Ball Recreational Field None Camping and Excursion Club Recreational Field Public Chi Omega Greek Fraternal Private College Democrats Cultural Political Private College Republicans Cultural Political Private Communication Studies Club Academic Professional Public Computing Club Academic Field Public Delta Delta Delta Greek Fraternal Private Democratic Socialists at Valerian Cultural Political None Environmental Management Club Academic Service Private Frisbee Golf Association Recreational Field None Ollel Cultural Educational Public History Club Academic Professional None Humanities and English Club Academic Professional None International Students at Valerian Cultural Educational Public Investigative Forensics Club Academic Field Public Kappa Delta Greek Fraternal Private Latinx Students at Valerian Cultural Educational Private LGBTQI" Students Association Cultural Educational Private Libertarian Valerians Cultural Political None Nursing Club Academic Service Private Pi Beta 2 Greek Fraternal Private Pickup Field Hockey Recreational Field Private Psychology Association for Students Academic Professional Private Recreational Rock Climbers Recreational Field None Running Club Recreational Field None Sailing Club Recreational Field Private Sigma Nu Sree Fraternal Drivate Sigma Sigma Sigma Greek Fraternal Private Take A Hike Recreational Field Tau Kappa Epsilon Greek Fraternal Private ultramarathoners Fellowship Recreational Field File Nene 6 4 37 28 35 34 14 27 7 16 30 54 37 53 45 19 28 45 2023 6 5 12 13 49 61 6 3 51 76 36 47 35 33 41 38 17 14 30 36 10 10 21 25 32 51 81 93 46 62 74 61 44 52 21 19 24 27 40 40 54 64 3 16 8 10 67 62 25 22 23 52 73 47 33 46 46 47 26 23 49 4 38 ??????Bn subn? ?????? sus 3 6 52 26 39 ????????????A8 26 29 12 46 25 19 55 45 Final Figure 5: All Groups PivotTable Worksheet G H Activities Educational Field 1 Office Private 2 3 Row Labels 2021 Membership 2022 Membership 2023 Membership 4 Greek 306 133 5 Alpha Chi Omega 13 12 13 6 Alpha P 49 61 7 Algoha Phi Alpha 6 6 6 8 Chi Omega 27 30 36 Delta Delta Delta 37 46 62 10 Kappa Delta 52 07 62 11 P. Beta - 26 33 46 12 Sigma Nu 15 12 14 13 Sigma Sigma Sigma 51 54 64 14 Tau Kappa Epsilon 25 24 19 15 Grand Total 306 333 383 16 Academic Prvot Table All Groups All Groups Pivot Table 9 Fraternal Political Professional Service . Final Figure 6: Activities PivotTable Worksheet G How Labels 2021 Membership 2022 Membership 2023 Member 92 140 179 22 Edwional 122 120 Membership by Type 5 6 2 ramal 333 29 10 so 1042 951 10 Grand Total 1 13 1 15 16 . 15 AR Alt Potable


We have an Answer from Expert

View Expert Answer

Expert Answer


First Select the Pivot Table Click on Insert Tab Select Pivot Chart --- a) Move & resize the chart to set

We have an Answer from Expert

Buy This Answer $2

Place Order

We Provide Services Across The Globe