answersLogoWhite

0


Best Answer

It is when you are using an OR condition, which in Excel can be implemented through an OR function, or in an Advanced Filter by listing the criteria on different rows.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What condition requires that only one of the selected criteria be true for a record to be displayed in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

The condition requires that all of the selected criteria be true for the record to be displayed.?

This happens when you use an AND in the condition.


What drug categories may be selected for DUE criteria?

Which of the following drug categories may be selected por DUE criteria ?


When a chart is not selected the chart tools is not displayed?

That is correct.


What is displayed around the edge of a graphic when the graphic is selected?

Sizing handles


Can AND criteria determine fields selected for a query?

Criteria determine what records can be shown, not what fields can be shown, so the AND criteria cannot be used to determine what fields to select.


What is displayed around the edge of a graphic when it is selected?

either sizing handles or selection border


What is the slide currently selected or displayed called?

It is called the current slide or active slide.


Are Contextual tools displayed only when needed for a selected area or object?

Yes, this is true.


When a graphic is selected displayed around the edge of the graphic?

graphic card size will be large


What are functions that may be displayed on the bottom toolbar in Excel when certain cells are selected?

Sum, Average, Max, Min and Count.


The files and folders stored inthe selected disk drive or folder are displayed in what pane?

Content Pane


How are all rows in a table selected?

All rows & columns in a table can be selected by using the below query Select * from table_name If you do not have any where condition in the query then all rows will be selected.