What is an Electronic Spreadsheet? Explain the features and functions of Microsoft Excel.

An Electronic Spreadsheet is a computer application that organizes data in rows and columns (cells) for calculation, analysis, and visualization. It replaces manual paper-based ledgers and calculation sheets.

Microsoft Excel is the most widely used spreadsheet application, developed by Microsoft as part of the MS Office suite.

Features of Microsoft Excel:

1. Cell-based data entry — Data is organized in cells identified by column letter and row number (e.g., A1, B2)
2. Formulas and Functions — Built-in mathematical, statistical, logical, and text functions
3. Charts and Graphs — Visual representation of data using bar, line, pie, and other chart types
4. Data Sorting and Filtering — Arrange data in ascending/descending order and filter by criteria
5. Conditional Formatting — Automatically format cells based on their values
6. Pivot Tables — Summarize and analyze large datasets dynamically
7. Data Validation — Restrict the type of data that can be entered in cells

Common Excel Functions:

Function	Syntax	Purpose
SUM	=SUM(A1:A10)	Adds all values in a range
AVERAGE	=AVERAGE(A1:A10)	Calculates the mean
COUNT	=COUNT(A1:A10)	Counts numeric cells
MAX / MIN	=MAX(A1:A10)	Finds largest/smallest value
IF	=IF(A1>50,"Pass","Fail")	Conditional logic
VLOOKUP	=VLOOKUP(value, range, col, FALSE)	Vertical lookup
CONCATENATE	=CONCATENATE(A1," ",B1)	Joins text strings