Question

Marcel wants to highlight the data of the lowest-performing products to share at a board meeting. In order to have Excel calculate the lowest 10% of products, he should use ________. conditional formatting COUNTIF IF/THEN sparklines

Answer 1

Marcel should use conditional formatting in Excel to highlight the data of the lowest-performing products. This would allow for a visual emphasis of the bottom 10% of products based on their performance data, using a formula that involves the COUNTIF function.

Step-by-step explanation:

To highlight the data of the lowest-performing products, Marcel should use conditional formatting in Excel. This feature allows users to set rules for how cells are formatted based on the cell's content. For instance, to identify the bottom 10% of products, he could use a conditional formatting rule that compares the performance data of products and formats only those that fall into the lowest 10% with a specific color or style.

Marcel would typically follow these steps:

Select the range that contains the product data.

Go to the 'Home' tab, click on 'Conditional Formatting' and then choose 'New Rule'.

Select 'Use a formula to determine which cells to format'.

Enter the formula using the COUNTIF function to calculate the threshold for the lowest 10% based on the performance data.

1. Set the desired format for the lowest 10% of cells, and then click 'OK' to apply.

By using conditional formatting and the COUNTIF function, Marcel can visually emphasize the data that are most relevant for discussion at the board meeting.