InstructionsExam EnvironmentExam Interface and ControlsThe exam panel provides access to the project task(s).

To filter theProfitsworksheet to display only the flavors with aTotal Profitthat isAbove Average, follow these steps:

Step 1: Access the Profits Worksheet

Click on theProfitsworksheet tab at the bottom of the Excel window.

Step 2: Apply the Above Average Filter

Look at theTotal Profitheader (CellG3). If you don't see a small drop-down arrow next to it, go to theDatatab and clickFilter.

Click theFilter Drop-down Arrowin theTotal Profitheader cell.

Hover your mouse overNumber Filtersin the menu that appears.

From the side menu, selectAbove Average.

Step 3: Verify the Results

Excel will automatically calculate the average of all values in the "Total Profit" column and hide any rows that fall below that number.

You will notice the row numbers on the left are now blue, indicating a filter is active.