2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on...

Transcribed Image Text:

2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson - this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product. b. Sum of Orders by Product and by Customer this wvill show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer - this will show us which salesperson is dealing with which customer Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales. B Order Date Order Amount Salesperson ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland $30.00 Manufacturing Directly, Inc. Johnson, Larry Levies by Lee, LLC Christen, Bill 1 Customer Product 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/4/2015 $55.00 $60.00 2. 41 A $55.00 $65.00 Built Tough, Inc. Lars, Sam 12/4/2015 12/4/2015 12/5/2016 10 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/6/2015 12/6/2015 12/6/2015 12/6/2015 12/6/2015 20 12/11/2015 21 12/12/2015 22 12/13/2015 23 12/14/2015 24 12/14/2015 25 12/14/2015 26 12/14/2015 27 12/18/2015 $60.00 $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. B 8. B 6. Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. 11 12 13 $75.00 Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 A 14 15 Lenny's Shop, LLC Owen, Rob 16 $50.00 Levies by Lee, LLC Christen, Bill 17 $60.00 Jobs for Less, Inc. Owen, Rob $30.00 ABC Works, Inc. Smith, Roland 18 B. $30.00 Manufacturing Directly, Inc. Johnson, Larry Lars, Sam 19 $65.00 Built Tough, Inc. $60.00 Jobs for Less, Inc. Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Lars, Sam $45.00 $50.00 $55.00 Little Engineers, Inc. Repairs by Larry, LLC Erics, Rebecca $50.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 Manufacturing Directly, Inc. Johnson, Larry $60.00 Product Sales Questions AI g birectly, Inc. Johnson, Larry 27 12/18/2015 28 12/19/2015 29 12/20/2015 30 12/21/2015 31 12/21/2015 32 12/21/2015 33 12/21/2015 34 12/25/2015 35 12/26/2015 36 12/27/2015 37 12/28/2015 38 12/29/2015 39 12/30/2015 40 12/31/2015 $45.00 Manufacturing Directly, Inc. Johnson, Larry $40.00 $60.00 $30.00 $25.00 Built Tough, Inc. Lars, Sam Built Tough, Inc. Bandwagon, Inc. Afternoon Too, Inc. Johnson, Larry Afternoon T00, Inc. Johnson, Larry Lars, Sam B Owen, Rob A $75.00 $45.00 $75.00 $25.00 ABC Works, Inc. Smith, Roland Little Engineers, Inc. Jobs for Less, Inc. Johnson, Larry Jobs for Less, Inc. Johnson, Larry Little Engineers, Inc. Built Tough, Inc. Lars, Sam $25.00 $30.00 $75.00 Lars, Sam B. Lars, Sam ABC Works, Inc. Smith, Roland $40.00 $50.00 $1,950.00 ABC Works, Inc. Smith, Roland 41 Product Sales Questions A, B. A, B. 2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson - this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product. b. Sum of Orders by Product and by Customer this wvill show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer - this will show us which salesperson is dealing with which customer Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales. B Order Date Order Amount Salesperson ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland $30.00 Manufacturing Directly, Inc. Johnson, Larry Levies by Lee, LLC Christen, Bill 1 Customer Product 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/4/2015 $55.00 $60.00 2. 41 A $55.00 $65.00 Built Tough, Inc. Lars, Sam 12/4/2015 12/4/2015 12/5/2016 10 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/6/2015 12/6/2015 12/6/2015 12/6/2015 12/6/2015 20 12/11/2015 21 12/12/2015 22 12/13/2015 23 12/14/2015 24 12/14/2015 25 12/14/2015 26 12/14/2015 27 12/18/2015 $60.00 $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. B 8. B 6. Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. 11 12 13 $75.00 Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 A 14 15 Lenny's Shop, LLC Owen, Rob 16 $50.00 Levies by Lee, LLC Christen, Bill 17 $60.00 Jobs for Less, Inc. Owen, Rob $30.00 ABC Works, Inc. Smith, Roland 18 B. $30.00 Manufacturing Directly, Inc. Johnson, Larry Lars, Sam 19 $65.00 Built Tough, Inc. $60.00 Jobs for Less, Inc. Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Lars, Sam $45.00 $50.00 $55.00 Little Engineers, Inc. Repairs by Larry, LLC Erics, Rebecca $50.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 Manufacturing Directly, Inc. Johnson, Larry $60.00 Product Sales Questions AI g birectly, Inc. Johnson, Larry 27 12/18/2015 28 12/19/2015 29 12/20/2015 30 12/21/2015 31 12/21/2015 32 12/21/2015 33 12/21/2015 34 12/25/2015 35 12/26/2015 36 12/27/2015 37 12/28/2015 38 12/29/2015 39 12/30/2015 40 12/31/2015 $45.00 Manufacturing Directly, Inc. Johnson, Larry $40.00 $60.00 $30.00 $25.00 Built Tough, Inc. Lars, Sam Built Tough, Inc. Bandwagon, Inc. Afternoon Too, Inc. Johnson, Larry Afternoon T00, Inc. Johnson, Larry Lars, Sam B Owen, Rob A $75.00 $45.00 $75.00 $25.00 ABC Works, Inc. Smith, Roland Little Engineers, Inc. Jobs for Less, Inc. Johnson, Larry Jobs for Less, Inc. Johnson, Larry Little Engineers, Inc. Built Tough, Inc. Lars, Sam $25.00 $30.00 $75.00 Lars, Sam B. Lars, Sam ABC Works, Inc. Smith, Roland $40.00 $50.00 $1,950.00 ABC Works, Inc. Smith, Roland 41 Product Sales Questions A, B. A, B. 2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson - this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product. b. Sum of Orders by Product and by Customer this wvill show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer - this will show us which salesperson is dealing with which customer Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales. B Order Date Order Amount Salesperson ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland $30.00 Manufacturing Directly, Inc. Johnson, Larry Levies by Lee, LLC Christen, Bill 1 Customer Product 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/4/2015 $55.00 $60.00 2. 41 A $55.00 $65.00 Built Tough, Inc. Lars, Sam 12/4/2015 12/4/2015 12/5/2016 10 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/6/2015 12/6/2015 12/6/2015 12/6/2015 12/6/2015 20 12/11/2015 21 12/12/2015 22 12/13/2015 23 12/14/2015 24 12/14/2015 25 12/14/2015 26 12/14/2015 27 12/18/2015 $60.00 $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. B 8. B 6. Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. 11 12 13 $75.00 Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 A 14 15 Lenny's Shop, LLC Owen, Rob 16 $50.00 Levies by Lee, LLC Christen, Bill 17 $60.00 Jobs for Less, Inc. Owen, Rob $30.00 ABC Works, Inc. Smith, Roland 18 B. $30.00 Manufacturing Directly, Inc. Johnson, Larry Lars, Sam 19 $65.00 Built Tough, Inc. $60.00 Jobs for Less, Inc. Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Lars, Sam $45.00 $50.00 $55.00 Little Engineers, Inc. Repairs by Larry, LLC Erics, Rebecca $50.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 Manufacturing Directly, Inc. Johnson, Larry $60.00 Product Sales Questions AI g birectly, Inc. Johnson, Larry 27 12/18/2015 28 12/19/2015 29 12/20/2015 30 12/21/2015 31 12/21/2015 32 12/21/2015 33 12/21/2015 34 12/25/2015 35 12/26/2015 36 12/27/2015 37 12/28/2015 38 12/29/2015 39 12/30/2015 40 12/31/2015 $45.00 Manufacturing Directly, Inc. Johnson, Larry $40.00 $60.00 $30.00 $25.00 Built Tough, Inc. Lars, Sam Built Tough, Inc. Bandwagon, Inc. Afternoon Too, Inc. Johnson, Larry Afternoon T00, Inc. Johnson, Larry Lars, Sam B Owen, Rob A $75.00 $45.00 $75.00 $25.00 ABC Works, Inc. Smith, Roland Little Engineers, Inc. Jobs for Less, Inc. Johnson, Larry Jobs for Less, Inc. Johnson, Larry Little Engineers, Inc. Built Tough, Inc. Lars, Sam $25.00 $30.00 $75.00 Lars, Sam B. Lars, Sam ABC Works, Inc. Smith, Roland $40.00 $50.00 $1,950.00 ABC Works, Inc. Smith, Roland 41 Product Sales Questions A, B. A, B. 2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson - this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product. b. Sum of Orders by Product and by Customer this wvill show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer - this will show us which salesperson is dealing with which customer Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales. B Order Date Order Amount Salesperson ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland $30.00 Manufacturing Directly, Inc. Johnson, Larry Levies by Lee, LLC Christen, Bill 1 Customer Product 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/4/2015 $55.00 $60.00 2. 41 A $55.00 $65.00 Built Tough, Inc. Lars, Sam 12/4/2015 12/4/2015 12/5/2016 10 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/6/2015 12/6/2015 12/6/2015 12/6/2015 12/6/2015 20 12/11/2015 21 12/12/2015 22 12/13/2015 23 12/14/2015 24 12/14/2015 25 12/14/2015 26 12/14/2015 27 12/18/2015 $60.00 $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. B 8. B 6. Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. 11 12 13 $75.00 Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 A 14 15 Lenny's Shop, LLC Owen, Rob 16 $50.00 Levies by Lee, LLC Christen, Bill 17 $60.00 Jobs for Less, Inc. Owen, Rob $30.00 ABC Works, Inc. Smith, Roland 18 B. $30.00 Manufacturing Directly, Inc. Johnson, Larry Lars, Sam 19 $65.00 Built Tough, Inc. $60.00 Jobs for Less, Inc. Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Lars, Sam $45.00 $50.00 $55.00 Little Engineers, Inc. Repairs by Larry, LLC Erics, Rebecca $50.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 Manufacturing Directly, Inc. Johnson, Larry $60.00 Product Sales Questions AI g birectly, Inc. Johnson, Larry 27 12/18/2015 28 12/19/2015 29 12/20/2015 30 12/21/2015 31 12/21/2015 32 12/21/2015 33 12/21/2015 34 12/25/2015 35 12/26/2015 36 12/27/2015 37 12/28/2015 38 12/29/2015 39 12/30/2015 40 12/31/2015 $45.00 Manufacturing Directly, Inc. Johnson, Larry $40.00 $60.00 $30.00 $25.00 Built Tough, Inc. Lars, Sam Built Tough, Inc. Bandwagon, Inc. Afternoon Too, Inc. Johnson, Larry Afternoon T00, Inc. Johnson, Larry Lars, Sam B Owen, Rob A $75.00 $45.00 $75.00 $25.00 ABC Works, Inc. Smith, Roland Little Engineers, Inc. Jobs for Less, Inc. Johnson, Larry Jobs for Less, Inc. Johnson, Larry Little Engineers, Inc. Built Tough, Inc. Lars, Sam $25.00 $30.00 $75.00 Lars, Sam B. Lars, Sam ABC Works, Inc. Smith, Roland $40.00 $50.00 $1,950.00 ABC Works, Inc. Smith, Roland 41 Product Sales Questions A, B. A, B. 2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson - this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product. b. Sum of Orders by Product and by Customer this wvill show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer - this will show us which salesperson is dealing with which customer Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales. B Order Date Order Amount Salesperson ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland $30.00 Manufacturing Directly, Inc. Johnson, Larry Levies by Lee, LLC Christen, Bill 1 Customer Product 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/4/2015 $55.00 $60.00 2. 41 A $55.00 $65.00 Built Tough, Inc. Lars, Sam 12/4/2015 12/4/2015 12/5/2016 10 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/6/2015 12/6/2015 12/6/2015 12/6/2015 12/6/2015 20 12/11/2015 21 12/12/2015 22 12/13/2015 23 12/14/2015 24 12/14/2015 25 12/14/2015 26 12/14/2015 27 12/18/2015 $60.00 $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. B 8. B 6. Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. 11 12 13 $75.00 Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 A 14 15 Lenny's Shop, LLC Owen, Rob 16 $50.00 Levies by Lee, LLC Christen, Bill 17 $60.00 Jobs for Less, Inc. Owen, Rob $30.00 ABC Works, Inc. Smith, Roland 18 B. $30.00 Manufacturing Directly, Inc. Johnson, Larry Lars, Sam 19 $65.00 Built Tough, Inc. $60.00 Jobs for Less, Inc. Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Lars, Sam $45.00 $50.00 $55.00 Little Engineers, Inc. Repairs by Larry, LLC Erics, Rebecca $50.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 Manufacturing Directly, Inc. Johnson, Larry $60.00 Product Sales Questions AI g birectly, Inc. Johnson, Larry 27 12/18/2015 28 12/19/2015 29 12/20/2015 30 12/21/2015 31 12/21/2015 32 12/21/2015 33 12/21/2015 34 12/25/2015 35 12/26/2015 36 12/27/2015 37 12/28/2015 38 12/29/2015 39 12/30/2015 40 12/31/2015 $45.00 Manufacturing Directly, Inc. Johnson, Larry $40.00 $60.00 $30.00 $25.00 Built Tough, Inc. Lars, Sam Built Tough, Inc. Bandwagon, Inc. Afternoon Too, Inc. Johnson, Larry Afternoon T00, Inc. Johnson, Larry Lars, Sam B Owen, Rob A $75.00 $45.00 $75.00 $25.00 ABC Works, Inc. Smith, Roland Little Engineers, Inc. Jobs for Less, Inc. Johnson, Larry Jobs for Less, Inc. Johnson, Larry Little Engineers, Inc. Built Tough, Inc. Lars, Sam $25.00 $30.00 $75.00 Lars, Sam B. Lars, Sam ABC Works, Inc. Smith, Roland $40.00 $50.00 $1,950.00 ABC Works, Inc. Smith, Roland 41 Product Sales Questions A, B. A, B. 2. Create the following Pivot tables depicting the following information (Hint: Each will be shown on their own worksheet): a. Sum of Orders by Product and by Salesperson - this will show us which product we are selling more of and who is selling each product more/less. Be sure to SORT the data in descending order to show the highest sales by salesperson under each product. b. Sum of Orders by Product and by Customer this wvill show us which product is being sold to which customer and the amount of the sales. Be sure to SORT the data in descending order to show the highest sales by customer under each product. c. Salesperson by Customer - this will show us which salesperson is dealing with which customer Be sure to SORT the data in descending order to show the highest sales by customer to ensure we see the customers in order of most sales. B Order Date Order Amount Salesperson ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland $30.00 Manufacturing Directly, Inc. Johnson, Larry Levies by Lee, LLC Christen, Bill 1 Customer Product 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/4/2015 $55.00 $60.00 2. 41 A $55.00 $65.00 Built Tough, Inc. Lars, Sam 12/4/2015 12/4/2015 12/5/2016 10 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/5/2016 12/6/2015 12/6/2015 12/6/2015 12/6/2015 12/6/2015 20 12/11/2015 21 12/12/2015 22 12/13/2015 23 12/14/2015 24 12/14/2015 25 12/14/2015 26 12/14/2015 27 12/18/2015 $60.00 $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. B 8. B 6. Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 $50.00 ABC Works, Inc. Smith, Roland ABC Works, Inc. Smith, Roland Built Tough, Inc. 11 12 13 $75.00 Lars, Sam $60.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 A 14 15 Lenny's Shop, LLC Owen, Rob 16 $50.00 Levies by Lee, LLC Christen, Bill 17 $60.00 Jobs for Less, Inc. Owen, Rob $30.00 ABC Works, Inc. Smith, Roland 18 B. $30.00 Manufacturing Directly, Inc. Johnson, Larry Lars, Sam 19 $65.00 Built Tough, Inc. $60.00 Jobs for Less, Inc. Johnson, Larry Engine Repair, LLC Erics, Rebecca Engine Repair, LLC Erics, Rebecca Lars, Sam $45.00 $50.00 $55.00 Little Engineers, Inc. Repairs by Larry, LLC Erics, Rebecca $50.00 Manufacturing Directly, Inc. Johnson, Larry $45.00 Manufacturing Directly, Inc. Johnson, Larry $60.00 Product Sales Questions AI g birectly, Inc. Johnson, Larry 27 12/18/2015 28 12/19/2015 29 12/20/2015 30 12/21/2015 31 12/21/2015 32 12/21/2015 33 12/21/2015 34 12/25/2015 35 12/26/2015 36 12/27/2015 37 12/28/2015 38 12/29/2015 39 12/30/2015 40 12/31/2015 $45.00 Manufacturing Directly, Inc. Johnson, Larry $40.00 $60.00 $30.00 $25.00 Built Tough, Inc. Lars, Sam Built Tough, Inc. Bandwagon, Inc. Afternoon Too, Inc. Johnson, Larry Afternoon T00, Inc. Johnson, Larry Lars, Sam B Owen, Rob A $75.00 $45.00 $75.00 $25.00 ABC Works, Inc. Smith, Roland Little Engineers, Inc. Jobs for Less, Inc. Johnson, Larry Jobs for Less, Inc. Johnson, Larry Little Engineers, Inc. Built Tough, Inc. Lars, Sam $25.00 $30.00 $75.00 Lars, Sam B. Lars, Sam ABC Works, Inc. Smith, Roland $40.00 $50.00 $1,950.00 ABC Works, Inc. Smith, Roland 41 Product Sales Questions A, B. A, B.

Answer rating: 100% (QA)

As we cannot provide pivot table here I am providing the most possible answers here 1 Small Builders INC Sales Report for the Month of December 2015 D... View the full answer