POP QUIZ!Quiz: Intermediate Sheets Functions | Question 4Note: Make sure to put your answer in all capital letters (e.g. AVERAGE). Use functions from Google Sheets Functions 2023What would you use to highlight all cells that are above the average value in the column?

To highlight all cells that are above the average value in the column, you can use the "CONDITIONAL FORMATTING" function in Google Sheets. Here are the steps to do it:

1. Select the range of cells in the column that you want to apply the conditional formatting to.
2. Go to the "Format" menu at the top of the Google Sheets interface.
3. Click on "Conditional formatting" and a sidebar will appear on the right side of the screen.
4. In the sidebar, under the "Format cells if" section, select "Greater than" from the drop-down menu.
5. In the input box next to "Greater than", enter the formula "=AVERAGE(A:A)" (replace "A:A" with the actual range of the column you are working with).
6. Choose the formatting style you want to apply to the cells that meet the condition (e.g., background color, font color, etc.).
7. Click on the "Done" button to apply the conditional formatting.

By following these steps, all cells in the selected range that are above the average value in the column will be highlighted according to the formatting style you chose.