Match the Following - Excel Lessons 5, 6, 7 - Excel

Match the Following

Excel Lessons 5, 6, 7 - Excel

5. Sorting and Filters in Excel

Term	Answer - Meaning
Sorting	Arranges data A-Z or Z-A
Filter	Shows only specific data
Ctrl + Shift + L	Shortcut for filter
Data Tab	Where sorting & filtering are
Multi-Sort	Sort by multiple columns

🔗 Sorting and Filters in Excel

6. Finalizing Excel Worksheet

Feature	Answer - What It Does
Formatting	Makes data look nice
Protect Sheet	Locks cells from changes
Print Area	Selects part to print
Header/Footer	Adds info at top/bottom
Conditional Formatting	Colors cells based on rules

🔗 Finalizing Excel Worksheet

7. AI-Aided Formula Bar in Excel

Feature	Answer - Purpose
Formula Bar	Type and edit formulas
AutoComplete	Suggests formulas instantly
AI Predictions	Recommends best formulas
Syntax Check	Fixes formula errors
AI Settings	Turn AI features on/off

🔗 AI-Aided Formula Bar in Excel