What is Microsoft Excel?

Microsoft Excel is a spreadsheet application developed by Microsoft. It is used to enter, organize, calculate, analyze, and present data in a structured format.

Excel stores information in the form of rows and columns, and the intersection of a row and a column is called a cell. Each cell has a unique cell address, which can be used to enter data or create formulas.

Excel is especially useful when we need to work with a large amount of numerical or tabular data. It allows users to perform calculations using formulas and functions, organize information, and prepare useful reports.

Simple Example

Suppose a school wants to maintain students’ marks:

Instead of calculating the total manually, Excel can calculate it automatically using a formula such as:

=SUM(B2:D2)

This makes calculations faster, easier, and more organized.

Why is Microsoft Excel Used?

Microsoft Excel can be used for:

• Entering and storing data
• Organizing information
• Performing mathematical calculations
• Creating formulas and functions
• Preparing student reports
• Calculating fees
• Preparing salary and payroll sheets
• Analyzing sales data
• Sorting and filtering information
• Creating charts and reports
• Managing business and financial information

Your notes use examples such as student reports, course fee calculations, salary/payroll, sales information and financial projections, showing how Excel can be applied to practical data-management tasks.

Basic Structure of Microsoft Excel

Excel mainly works with Workbooks, Worksheets, Rows, Columns, and Cells.

1. Workbook

A Workbook is an Excel file that contains one or more worksheets.

For example:

Student_Report.xlsx

can be an Excel workbook containing worksheets such as:

• Student Marks
• Fees
• Attendance
• Result

The Excel workbook format discussed in your notes is .xlsx.

2. Worksheet

A Worksheet is the working area inside a workbook where data is entered and managed.

For example:

Workbook: Student Management
Worksheets: Marks, Fees, Attendance

3. Rows

Rows run horizontally across the worksheet.

Rows are identified using numbers:

1, 2, 3, 4, 5…

4. Columns

Columns run vertically in the worksheet.

Columns are identified using letters:

A, B, C, D, E…

5. Cell

A Cell is the intersection of a row and a column.

For example:

• Column A + Row 1 = A1
• Column B + Row 3 = B3
• Column D + Row 5 = D5

A cell is the basic location where data can be entered.

6. Cell Address

The combination of a column letter and row number is called a Cell Address.

For example:

A1

Here:

• A = Column
• 1 = Row

Therefore, A1 identifies a particular cell in the worksheet.

Data in Microsoft Excel

Excel can be used to enter different types of information into cells.

For example:

Here:

• Rahul/Priya → Text data
• 20/21 → Numerical data
• 85/92 → Numerical data

Once data is entered, Excel can be used to perform calculations and analyze it.

Formulas in Microsoft Excel

One of the important features of Excel is the ability to perform calculations using formulas.

A formula generally begins with an equal sign (=).

Example:

=B2+C2

This formula adds the values stored in cells B2 and C2.

Another example:

=SUM(B2:D2)

This calculates the total of the values from B2 to D2.

Your notes introduce formulas and functions as an important part of working with spreadsheet data.

Functions in Microsoft Excel

A Function is a predefined formula that performs a specific calculation.

Some basic functions covered in your notes are:

SUM

Used to calculate the total.

=SUM(B2:B10)

AVERAGE

Used to calculate the average.

=AVERAGE(B2:B10)

MIN

Used to find the smallest value.

=MIN(B2:B10)

MAX

Used to find the largest value.

=MAX(B2:B10)

Excel also provides an Insert Function / Function Wizard to help users select a function and provide its required arguments.