Manipulate worksheet data

Open the SummarizeValues workbook in Excel, and then perform the following tasks:

Combine the IF and RAND functions into formulas in cells $H3$:$H27$ that display

TRUE if the value is less than $0\mathrm{.}3$ and FALSE otherwise.

Use AutoCalculate to find the SUM, AVERAGE, and COUNT of cells G$12$:G$16.$

Remove the COUNT summary from the status bar and add the MINIMUM

summary,

Create a SUBTOTAL formula that finds the average of the values in cells G$3$:G$27.$

Create an AGGREGATE formula that finds the maximum of values in cells G$3$:G$27.$

Create an advanced filter that finds the unique values in cells F$3$:F$27.$