Return to the Product Mix worksheet. Benicio wants to provide a visual way to compare the scenarios. Use the Scenario Manager as follows to create a PivotTable that compares the profit per unit in each scenario as follows:
a. Create a Scenario PivotTable report using the profit per unit sold (range B17:F17) as the result cells.
b. Remove the Filter field from the PivotTable.
c. Change the number format of the value fields to Currency with 2 decimal places and the $ symbol.

To create a pivot table, select the columns to pivot and click on the insert option, click on the pivot table option and select the data columns for the pivot, verify the table range, select the location for the pivot and click ok. To format a column, select the columns and click the number option on the home tab, select the currency option and click on the number of decimal places

Explanation:

Microsoft Excel is a great tool for data analysis and visualization. It has several mathematical, engineering, statistical, and graphical tools for working with data.

A pivot-table is an essential tool for describing and comparing data of different types.

JackelineCasarez JackelineCasarez · Answer 2 · 2021-12-06T17:23:19+01:00

The steps to follow in order to produce a Pivot table would be as mentioned below:

Opting the columns for a pivot table.
Now, make a click on the insert option.
This click is followed by opting for the pivot table and the data columns that are available in it.
After this, the verification of the range of the table is made and then, the location for the pivot table has opted.
After this, the column is formatted and the number option is selected followed by the currency option, and the quantity of decimal places.
A Pivot table allows one to establish a comparison between data of distinct categories(graphic, statistical, mathematical) and elaborate them.

Learn more about 'Pivot Table' here:

brainly.com/question/13298479