Sorting Filtering Data Flashcards
(6 cards)
1
Q
Term: Primary Field
A
📘 Description: The main column used to sort data.
🧮 Example: Sort by “Last Name”.
2
Q
Term: Secondary Field
A
📘 Description: Used when there are ties in the primary field.
🧮 Example: Sort by “Last Name”, then “First Name”.
3
Q
Order: Ascending
A
Description: A to Z, or smallest to largest.
4
Q
Order: Descending
A
Description: Z to A, or largest to smallest.
5
Q
Term: Multiple Criteria
A
📘 Description: Filter based on several conditions.
🧮 Example: “Region = South” AND “Sales > 5000”
6
Q
Term: Complex Criterion
A
Description: Combines conditions with AND/OR logic.
🧮 Example: (Region = “East” OR “West”) AND (Sales > 1000)