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

-
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

Comments

Post a Comment

Popular posts from this blog

Index Class V - Excel - ICT

-
Excel Revision Worksheet - Table of Contents Table of Contents Std :- V Excel - Revision Worksheet Sr.No Name Link 1 Introduction To Excel Open 2 Formatting Cells Open 3 Working With Formulas Open 4 Functions In Excel Open 5 Sorting And Filters In Excel Worksheet Open 6 Finalizing Excel Worksheet Open 7 AI Aided Formula Bar In Excel Open L. 5,6,7 Match the Following - Excel Open ...
Read more

Interactive Worksheet - Excel-V True or False- Quiz

-
Excel Quiz - True or False Excel Quiz - True or False Answer each question by selecting True or False from the dropdown. Click submit to check your answers and see your marks. 1. Excel is a spreadsheet application developed by Microsoft. Select an answer True False 2. Excel files use the .docx extension. Select an answer True False 3. The main component of Excel is the worksheet. Select an answer True False 4. Each cell in Excel can contain only text data. ...
Read more

Interactive Worksheet - Excel-V Fill-in-the-Blanks Quiz

-
Excel Quiz - Fill in the Blanks Excel Quiz - Fill in the Blanks Fill in the blanks by selecting the correct option from the dropdown. Click submit to check your answers. 1. Excel is used primarily for __________ management and data analysis. Select an answer spreadsheet document presentation 2. The intersection of a row and column in Excel is called a __________. Select an answer cell box sheet 3. Each Excel workbook can contain multiple __________. Select an answer sheets cells columns ...
Read more