Select the Filter and type “choc” in the search box.
Sort the data alphabetically and then visually scan down the list.
Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”.
Sort the data, then select the range of ties and sort that.
Go to Data and click Sort and add as many sorting levels as needed.
Sort by the first column, then select the second column and sort by that column.
Click Subtotals on the Data menu.
View the sum in the formula bar.
Click the AutoSum button on the Standard toolbar, then press ENTER.
Click the Paste button on the Standard toolbar.
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
Click the arrow on the Paste button on the Standard toolbar, then click Values.
Single-click the boundary to the left of the column heading.
Double-click the boundary to the right of the column heading.
Press ALT and single-click anywhere in the column.
You've entered a number wrong.
You've misspelled something.
The cell is not wide enough.
A dark wide border
A dotted border
A blinking border
None of the above