Which of the following statement does not hold true foe filtering data in Excel(1) You can view inly selective records useing the filtering feature.(2)The row does not meet the filter condition are delete(3)The row that does not meet the filte condition are hidden(4) You can specify more than one criterion for a column when useing filters
Answers
Answered by
3
Answer:
Which of the following statement does not hold true foe filtering data in Excel(1) You can view inly selective records useing the filtering feature.(2)The row does not meet the filter condition are delete(3)The row that does not meet the filte condition are hidden(4) You can specify more than one criterion for a column when useing filters
Answered by
0
Answer:
Formulas in the Advanced Filter criteria
The formula must evaluate to either TRUE or FALSE.The criteria range should include a minimum of 2 cells: formula cell and heading cell.The heading cell in the formula-based criteria should be blank, or has a heading different from any of the list range headings.
Similar questions