15. Benicio wants to isolate sales for each product. Insert a slicer based on the Product...

Transcribed Image Text:

15. Benicio wants to isolate sales for each product. Insert a slicer based on the Product field. Move and resize the slicer so that it covers the range F3:G12. 16. Benicio also wants to compare the sales data by country in a visual format, and then display data only for the Mini 1, the company's best-selling product. Insert a Stacked Column PivotChart based on the data in the PivotTable. Move and resize the PivotChart so that it covers the range A10:E25. 17. Change the colors of the PivotChart to Monochromatic Palette 6 to coordinate with the PivotTable. Use the slicer to display sales data for only the Mini 1 in the PivotTable and PivotChart. 18. Go to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology is planning to develop. Benicio wants to make sure the total expense per unit sold calculation does not produce a divide by zero error. Add a function to the formula for the total expense per unit sold to display the message Divide total expenses by units manufactured in case of an error. 19. Benicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and unit sales of 22,000. He wants to see how the gross profit changes if the price or unit sales are different. Under the cell labeled Virtual Assistant: Gross Profit Analysis, create a two-variable data table using the price per unit and the units sold as the row and column input cells. 20. Go to the Suppliers worksheet, where Benicio wants to determine whether subcontracting could reduce the cost of the new virtual assistant product. Run Solver to solve this problem. Set the objective as minimizing the total cost, and use the units produced values as the I 15. Benicio wants to isolate sales for each product. Insert a slicer based on the Product field. Move and resize the slicer so that it covers the range F3:G12. 16. Benicio also wants to compare the sales data by country in a visual format, and then display data only for the Mini 1, the company's best-selling product. Insert a Stacked Column PivotChart based on the data in the PivotTable. Move and resize the PivotChart so that it covers the range A10:E25. 17. Change the colors of the PivotChart to Monochromatic Palette 6 to coordinate with the PivotTable. Use the slicer to display sales data for only the Mini 1 in the PivotTable and PivotChart. 18. Go to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology is planning to develop. Benicio wants to make sure the total expense per unit sold calculation does not produce a divide by zero error. Add a function to the formula for the total expense per unit sold to display the message Divide total expenses by units manufactured in case of an error. 19. Benicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and unit sales of 22,000. He wants to see how the gross profit changes if the price or unit sales are different. Under the cell labeled Virtual Assistant: Gross Profit Analysis, create a two-variable data table using the price per unit and the units sold as the row and column input cells. 20. Go to the Suppliers worksheet, where Benicio wants to determine whether subcontracting could reduce the cost of the new virtual assistant product. Run Solver to solve this problem. Set the objective as minimizing the total cost, and use the units produced values as the I