5. Which feature of Excel should
be used to find the bottom 10
items of a list?
Top /Bottom rules
O charts
O XY/Scatter charts
Answers
Answer:
Top/bottom rules I think sommen
Answer:
Select the numbers in the Sales column (C2:C13)
On the Ribbon's Home tab, click Conditional Formatting, then click
New Rule
Click Use a Formula to Determine Which Cells to Format
In the formula box, enter the LARGE formula,
=C2>=LARGE($C$2:$C$13,3)
Click the Format button.
Select formatting options (light green fill),
click OK
Click OK

Bottom X Values
In the video's second example, the lowest numbers in the list will be highlighted.
This time, the conditional formatting formula will refer to a worksheet cell (E2), to create a flexible rule.

This formula uses the SMALL function, which is similar to LARGE, but returns the nth smallest number.
Follow these steps to apply the conditional formatting:
Select the numbers in the Sales column (C2:C13)
On the Ribbon's Home tab, click Conditional Formatting, then click
New Rule
Click Use a Formula to Determine Which Cells to Format
In the formula box, enter the SMALL formula,
=C2<=SMALL($C$2:$C$13,$E$2)
Click the Format button.
Select formatting options (light orange fill),
click OK
Click OK