explain the various components of the communication process and it's ultimate purpose

Excel's Pivot Table Report provides an excellent way to summarize data for two or more variables simultaneously. The goal of this Excel Graded Tutorial is to familiarize you with Excel's Pivottable feature and learn about its uses. You will learn how to use Pivot Tables by developing a crossbulation of region, quality rating, and meal price for 300 restaurants and then answering questions about the data. The data for this problem is located on the Datasheet in columns A through of the Excel Online file below. An empty Pivot Table is provided on the 'Pivot" sheet. Click on the Pivot' tab to select the Pivot Table sheet. Inside the Plvot Table area right dick and select Show Field List, The Pivottable task pane should now be displayed on the right side of the spreadsheet. In the field ist you should see Restaurant Region, Quality Rating and Meal Price (B. Construct a spreadsheet to answer the following questions. X Open spreadsheet Questions 1. What are the sales totals for each region? To answer this question proceed as follow. First click on Region in the Field List and then drag it to the rows bar in the vitae pane. You will see the four regions enter the PlvotTable Next, drag Hal Prin (s) into the values bore of the Plyettable pane. The second column in the Pivot Table should now be Sum of Moal Price (s). What are the total sales for each Region and the Grand Total Total Sales D Last $ North $ South 5 West $ Grand Tots 2. What are the sales totais for each Quality Ratio Tower this question proceed as follow. First, dick on Region the cowbox of the Power answer Question 1) and then drag it back into the field it Neddrag Quality Rating from the held at into the rows or of the team where the for tin v tinh South West Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question proceed as follows. First, dick on Region in the rows box of the Pivot Table (where it was used to answer Question 1) and then drag it back into the Field Ust. Next, drag Quality Rating from the Field Ust Into the rows box of the Pivot Table bane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good 5 2. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent staurants in the Westonowe question proceed as follows. Drag Quality rating from the rows box to the color on the table and Then des Region from the fields into the cows how the Intersection of West and excellent in the Pivottable provides the one totale for Excelentes the wist Region Total sales forticellent restaurants in the West are 4. What is the average meal price for the entire region and Very Goodmeals the region to the art on Toneris quition proceed to select maneric values in the Pivot Tables from westion above. Ne is the kind of bleemiddel of Meal Price wild Setting. In Value Field Settings et Average then dick OK, in the value of now read Avera of Prices Average meal price in the East Region in the nearest Avenge mest price for Very Good meals in East regions to the nearest Question 1 Total Sales East North South West Grand Total Question 2 Total Sales Excellent Good Very Good Restaurant Region We 2 West South * West 6 5 West 6 South 7 South North 9 Won 11 10 West 11 West 33 12 West 14 13 West 15 14 North 16 15 East 17 16 West 10 17 EN 19 18 East 30 19 West 1 20 W 22 21. Sot 22 North 22 North 24 Wed 2 E 26 North 23 I North 28 North 29 North Quality Rating - Meal Prion (5) Excel Excelent 38 Excelent 36 Good 12 Very Good 36 Very Good 41 Excelent 20 Very Good 51 VeryGood 12 Good 49 Very Good 42 Very Good Good 25 Excent 54 Excellent Excellent 29 Excellent 10 Good 21 Gond Good 16 Very Good 54 Very Good 15 Excellent 16 Excellent 37 Very Good 0 Vury Good 12 Good 21 Good Good Question 3 Total Sales Excellent West) Question 4 Average Mest Price (East) Average Meal Price (Very Good East A pats pivott Excel's Pivot Table Report provides an excellent way to summarize data for two or more variables simultaneously. The goal of this Excel Graded Tutorial is to familiarize you with Excel's Pivottable feature and learn about its uses. You will learn how to use Pivot Tables by developing a crossbulation of region, quality rating, and meal price for 300 restaurants and then answering questions about the data. The data for this problem is located on the Datasheet in columns A through of the Excel Online file below. An empty Pivot Table is provided on the 'Pivot" sheet. Click on the Pivot' tab to select the Pivot Table sheet. Inside the Plvot Table area right dick and select Show Field List, The Pivottable task pane should now be displayed on the right side of the spreadsheet. In the field ist you should see Restaurant Region, Quality Rating and Meal Price (B. Construct a spreadsheet to answer the following questions. X Open spreadsheet Questions 1. What are the sales totals for each region? To answer this question proceed as follow. First click on Region in the Field List and then drag it to the rows bar in the vitae pane. You will see the four regions enter the PlvotTable Next, drag Hal Prin (s) into the values bore of the Plyettable pane. The second column in the Pivot Table should now be Sum of Moal Price (s). What are the total sales for each Region and the Grand Total Total Sales D Last $ North $ South 5 West $ Grand Tots 2. What are the sales totais for each Quality Ratio Tower this question proceed as follow. First, dick on Region the cowbox of the Power answer Question 1) and then drag it back into the field it Neddrag Quality Rating from the held at into the rows or of the team where the for tin v tinh South West Grand Total $ 2. What are the sales totals for each Quality Rating? To answer this question proceed as follows. First, dick on Region in the rows box of the Pivot Table (where it was used to answer Question 1) and then drag it back into the Field Ust. Next, drag Quality Rating from the Field Ust Into the rows box of the Pivot Table bane. What are the total sales for each Quality Rating? Total Sales Excellent $ Good $ Very Good 5 2. What is the sales total for a particular combination of Region and Quality Rating? For example, what is the sales total for Excellent staurants in the Westonowe question proceed as follows. Drag Quality rating from the rows box to the color on the table and Then des Region from the fields into the cows how the Intersection of West and excellent in the Pivottable provides the one totale for Excelentes the wist Region Total sales forticellent restaurants in the West are 4. What is the average meal price for the entire region and Very Goodmeals the region to the art on Toneris quition proceed to select maneric values in the Pivot Tables from westion above. Ne is the kind of bleemiddel of Meal Price wild Setting. In Value Field Settings et Average then dick OK, in the value of now read Avera of Prices Average meal price in the East Region in the nearest Avenge mest price for Very Good meals in East regions to the nearest Question 1 Total Sales East North South West Grand Total Question 2 Total Sales Excellent Good Very Good Restaurant Region We 2 West South * West 6 5 West 6 South 7 South North 9 Won 11 10 West 11 West 33 12 West 14 13 West 15 14 North 16 15 East 17 16 West 10 17 EN 19 18 East 30 19 West 1 20 W 22 21. Sot 22 North 22 North 24 Wed 2 E 26 North 23 I North 28 North 29 North Quality Rating - Meal Prion (5) Excel Excelent 38 Excelent 36 Good 12 Very Good 36 Very Good 41 Excelent 20 Very Good 51 VeryGood 12 Good 49 Very Good 42 Very Good Good 25 Excent 54 Excellent Excellent 29 Excellent 10 Good 21 Gond Good 16 Very Good 54 Very Good 15 Excellent 16 Excellent 37 Very Good 0 Vury Good 12 Good 21 Good Good Question 3 Total Sales Excellent West) Question 4 Average Mest Price (East) Average Meal Price (Very Good East A pats pivott