ge 5 of 16 2486 words English (United States) 11. Benicio might want to fiter the Product Detalls data in the range 14:Mio, so ne asks you to format it as a table. Format the range 14:M16 as a table using Light Gray, Table Style Medium 14 to match the Sales table. 12. To make it easier to refer to the data, assign the table name Details to the table in the range 14:M16 to make it easy to refer to the data. (Hint: Rename the table, not the range.) 13. Benicio wants to examine the January, 2022 sales by country and channel. Create a Pivot Table based on the Sales table as follows: 15. a. b. C. d. 14. Format the PivotTable as follows to make it easier for Benicio and others to interpret: Apply the Currency number format with 0 decimal places and the $ symbol to the Sum of Amount values. a. b. C. d. e. On a new worksheet, insert a PivotTable based on the data in the Sales table, and use January Pivot as the name of the worksheet. Display the Channel Type values as column headings. Display the Location values as row headings. Sum the Amount values Benicio wants to isolate sales for each product. Insert a slicer as follows to filter the PivotTable: a. Use Sales (000s) as the custom name of the Sum of Amount field. In cell A4, use Country to identify the row headings. In cell B3, use Channel to identify the column headings. Change the PivotTable style to White, Pivot Style Medium 14 to coordinate with the tables on the Current Sales worksheet. 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 calac data by country in a vicual format and then Accessibility: Investigate b. Focus PR I

"o format it as a Awtric Format the range JA Mi6at a table using Light Gray, Table Style Medien id to mateth the siales table 12. To make if caver te refer to the data, assign she tatse fame Details for the tabie in the range H4M16 tit make is easy to retel to the datim (Hint Rename the table, not the range-1 1) Benicio wants to examine the lanuaryi 2022 dates br country and itannel. Create in Wotifale Bated on the soles table as folibws use danuary Pivot ds the name of the workahect b. Daplay the Channel Typet values as colurnt heading c. Duptiry the Location valoes as rew headingl. a. isuris the Amount values 14. Formist ithe Protfabie as folloms to make it easier for beniog and othem to interpest: 1. Aeply the Currency nurrite format with decmal places and the & symboll to the Sum of Amownt valuet E. Ure 5 ales (000s) as the cutcen nathe of the Sorm of Amount field C. faceel A4, ure Country to ihentify the row headingh d. Io cell B3, use Channel to identif the colunt headinga. 15 Change the PrvecToble style to White, Pirot Style Mediam 14 to cogrinate with the rables of the Current Stales workshect Pivostable a. Insert a dicer based on the Prodact Field b. Nove and resice the sicer sa that it covers the range filttiz. d. In cell B3, use Channel to identify the column headings. e. Change the PivotTable style to White, Pivot Style Medium 14 to coordinate with the tables on the Current Sales worksheet. 15. Benicio wants to isolate sales for each product. Insert a slicer as follows to filter the PivotTable: a. Insert a slicer based on the Product field. b. 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. Create a PivotChart as follows: a. Insert a Stacked Column PivotChart based on the data in the PivotTable. b. Move and resize the PivotChart so that it covers the range A10:E25. 17. Format and filter the PivotChart as follows to meet Benicio's requests: a. Change the colors of the PivotChart to Monochromatic Palette 6 to coordinate with the PivotTable. b. 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 in cell B17 does not produce a divide by zero error. Modify the formula in cell B17 as follows: a. Add the IFERROR function to the formula in cell B17. b. Use "Divide total expenses by units manufactured" as the message to display in case of an error. 19. Benicio has aiready 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. Create a two-variable data table as follows to calculate gross profit as the price and unit sales change: a. For the range D4:K9, create a two-variable data table using the price per unit (cell B6) as the Row input cell. b. Use the units sold (cell B5) as the Column input cell