60.1K
Verified Solution
Link Copied!
When creating an Advanced Filter in your spreadsheet, how does Excel read the data when it is applied?
It reads each row from left to right with an And statement.
It reads each column from top to bottom with an Or statement before the next column.
It reads from left to right with an And statement, then an Or statement when you move down to the next row.
It reads from left to right with an Or statement, then an And statement when you move down to the next row.
Answer & Explanation
Solved by verified expert
