Ask Question
Computers & TechnologyComputers & Technology
19 September, 08:13

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

+4
Answers (1)
  1. 19 September, 09:32
    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?
Get 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 & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
What kind of approach should you follow to create a website that a visually challenged person as well as a person with normal vision can use with ease?
Answers (1)
Is the os portion that manages resources and interacts directly with computer hardware?
Answers (1)
You need to design an online login form in which users have to type their name and password to log into an application. The password can be a combination of numbers and letters.
Answers (1)
Which is the correct process for selecting nonconsecutive worksheets in a workbook? A. Click the sheet tab for the first sheet you want to select and then hold down the Shift key while selecting the other sheets. B.
Answers (1)
Design a program that will receive a valid time in the 12-hour format (e. g. 11:05 PM) and convert it to its equivalent 24-hour format (e. g. 2305). Assume 0000 in 24-hour format is 12:00AM in 12-hour format.
Answers (1)
New Questions in Computers & Technology
Which of these is NOT a form of precipitation? A. hail B. rain C. snow D. cirrus
Answers (2)
Can you use iMessage on the iPod without wifi? Thx
Answers (2)
New cars come with an onboard computer that controls anti-lock brakes, air bag deployment, fuel injection, etc. the software is known as
Answers (1)
In dealing with facial recognition technology, what term describes the rate at which imposters are recognized as legitimate users?
Answers (1)
A user is complaining about sluggish performance on her Linux system, and the technician suspects a running process is consuming excessive processor resources.
Answers (1)
Home » Computers & Technology » 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
Sign Up Forgot Password?