Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need detailed steps please. Thank you Survey Questions Calculated Fields ID Return Workshops Speakers Facilities Meals School Prior Conferences Survey001 will not return 4-Very

I need detailed steps please. Thank you

image text in transcribed

Survey Questions Calculated Fields
ID Return Workshops Speakers Facilities Meals School Prior Conferences
Survey001 will not return 4-Very Satisfied 3-Satisfied 3-Satisfied 3-Satisfied Online 0
Survey002 will not return 1-Very Dissatisfied 2-Dissatisfied 2-Dissatisfied 4-Very Satisfied Online 2
Survey003 will return 1-Very Dissatisfied 4-Very Satisfied 4-Very Satisfied 3-Satisfied Public #N/A
Survey004 will return 4-Very Satisfied 1-Very Dissatisfied 1-Very Dissatisfied 3-Satisfied Public 3+
Survey005 will return 4-Very Satisfied 4-Very Satisfied 4-Very Satisfied 3-Satisfied Private 1
Survey006 will return 2-Dissatisfied 4-Very Satisfied 4-Very Satisfied 2-Dissatisfied Private 2
Survey007 will return 3-Satisfied 4-Very Satisfied 4-Very Satisfied 3-Satisfied Private 2
8. In the Survey Results worksheet, create a PivotChart, placing it in cell A4 of the PivotTables worksheet, and then do the following to analyze what factors might have contributed to a person decided against returning to next year's conference: a. Name the PivotTable as workshop pivot. b. Place the Workshops field in the Columns area, the Return field in the Rows area, and the ID field in the Values area. 9. Make the following changes to the PivotChart: a. Move the chart to the Report worksheet to cover the range E7:117. b. Change the chart type to the 100% Stacked Column chart. c. Remove the chart legend and field buttons from the chart. d. Add the chart title Workshop Satisfaction to the chart. e. Display the table associated with this chart by clicking the Data Tables check box in the Chart Elements menu. Verify that data table rows are arranged from top to bottom in the order Very Satisfied, Satisfied, Dissatisfied, and Very Dissatisfied

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

Database In Depth Relational Theory For Practitioners

Authors: C.J. Date

1st Edition

0596100124, 978-0596100124

More Books

Students also viewed these Databases questions

Question

What are the steps in the development of a database system?

Answered: 1 week ago

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago