Which of the following statements is true about advanced filtering?Group of answer choicesIf you change the criteria, the output does not automatically updateOnce you have changed the criteria, you must never reapply that filter or it will cause your computer to crash. If you change the criteria, the output automatically updates as you type.None of the answers are correct

Because of the change, the immediate consequence for output is that yGroup of answer choicesthe impact is indeterminateremains unchangedincreasesdecreases

When entering criteria in the criteria range, criteria that conjunct with either/or  should be entered on _________.Group of answer choicesDifferent rowsSame rowSame columnAll of the answers are correct

Which of the following are not used for filtering in a Recommendation Engine?

You select the AND operator in "Filtering a Table by Form". Choose the correct statement.Group of answer choicesYou cannot use AND to filter table in AccessThe records will be included in the results only if all the criteria are metThe records will be included in the results only if both criteria are exceeded.The records will be included in the results if at least one criterion is met

What can be reasonably deduced from the following two statements:(1) If foo is true, then bar is true(2) bar is falseGroup of answer choicesfoo is truebar is truenothingfoo is false