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.

:you areto design the controller for alight that functions both as an ordinary light and also as a motion activated light and alarm. a.if the manual switch s is on, then the light l is on. b.besides the manual switch, there is a motion detector, m1, which activatesthis light.c.if motion is detected but the light is on anyway because s is on, only then a secondoutput a, an alarm, is turned on. d.the disable switch, d, disables the motion activated light and alarmbut leaves manual control operation of the light using switch s.(i)read the problem statement and clearly identify the inputs and outputs for the circuit you are designing. (ii)create the truth table for this system; include the light, alarm, switch, disable, and the motion sensor.(iii)draw a schematic of this system.