Home Videos Exercises MCQ Q&A
Lesson 2 of 5 – Excel Features
25%

Features of Excel

MS Excel is one of the most popular spreadsheet programs developed by Microsoft. It is widely used for data management and calculations.

Header and Footer

We can add header and footer at the top and bottom of the worksheet.

Find and Replace

Helps to find data and replace it quickly.

Data Filtering

Used to display selected data only.

Password Protection

Protects data from unauthorized access.

Data Sorting

Arrange data in ascending or descending order.

Built-in Formulas

Provides formulas like SUM, AVERAGE, MIN, MAX.

Real-time Calculation

Automatically updates results when data changes.

Charts

Create graphs like bar, pie, column charts.


🧠 Quiz

Which feature protects Excel file?