Jordan adds a new column to the sales data in his Excel work…

Jordan adds a new column to the sales data in his Excel worksheet but notices the PivotTable Fields list still shows only the columns that were present when he created the PivotTable. What step must Jordan take to update the PivotTable to include the new column?

In the table below, if I want to place a red circle in every…

In the table below, if I want to place a red circle in every cell containing a value less than 300, a green circle in every cell containing a value greater than or equal to 600, and a yellow circle in the remaining cells, which of the following should I use?

The Dollar Shack sells two different types of party supplies…

The Dollar Shack sells two different types of party supplies – balloons and hats – in six different colors. The table below shows the number of units that were sold this quarter by type and color. For each color, you would like to know what percent of the units sold were balloons and what percent were hats. You want to type a formula in cell G4 that you can copy the formula to the right and down to cell H9 in order to calculate the appropriate values for each color and item type. What formula should you type in cell G4?