Which are correct statements related to data sorting and filtering in spreadsheets? Place the passage here with the hot texts highlighted in yellow. Only the correct answer(s) should be highlighted in green.
A. Filtering will only work on a single column. B. The search table refers to an array of single rows or columns. C. Filtering helps you to hide unwanted data. D. Sorting hides multiple rows from the user. . E. The LOOKUP function is similar to a search command.