What happens to the rows that do not meet the filter criteria when applying a filter in Excel?
They are highlighted with a different colour.
They remain visible in the worksheet.
They are hidden from view temporarily.
They are deleted from the worksheet