Ask Question
28 July, 04:51

Data can be filtered in the AutoFilter dialog box if they meet which of these? Check all that apply.

two criteria based on a "when" comparison

one criterion based on a "when" comparison

two criteria based on an "and" comparison

one criterion based on an "and" comparison

two criteria based on an "or" comparison

one criterion based on an "or" comparison

+5
Answers (1)
  1. 28 July, 06:31
    0
    Data can be filtered in the AutoFilter dialog box if they meet all the apply.

    two criteria based on a "when" comparison one criterion based on a "when" comparison two criteria based on an "and" comparison one criterion based on an "and" comparison two criteria based on an "or" comparison one criterion based on an "or" comparison

    Explanation:

    Based on end user usage the auto file dial box meets the requirements. All combinations will work on to do auto filer in the selected data or whole data.

    If end user using the MS-excel on the current work sheet. "When" is used for with one or two criteria with some logical operations. Mostly one criteria based is used.

    "AND" logical operator is used to more the one criteria or single criteria. Same way "OR" also it has can be used with one or two criteria.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Data can be filtered in the AutoFilter dialog box if they meet which of these? Check all that apply. two criteria based on a "when" ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers