Introduction to MS Excel
MS Excel is a powerful spreadsheet application used to store, calculate, analyze and present data. This chapter introduces Excel, spreadsheets, workbooks, worksheets, rows, columns, cells and real office uses.
Spreadsheet
Organize data in rows, columns and cells.
Calculations
Perform totals, averages, percentages and formulas.
Reports
Create fee records, attendance sheets and business summaries.
Data Analysis
Sort, filter and understand information faster.
After This Chapter, You Will Be Able To
This chapter prepares you to begin practical spreadsheet work.
Understand Excel
Know what MS Excel is and why it is used.
Know Spreadsheet
Understand workbook, worksheet, rows, columns and cells.
Cell Address
Identify cell addresses such as A1, B5 and C10.
Office Uses
Connect Excel with real records, reports and calculations.
What is MS Excel?
MS Excel is a spreadsheet program used to manage data and perform calculations.
1 Easy Explanation
MS Excel is used to enter information in rows and columns. It can calculate totals, manage records, create charts, prepare reports and analyze data for office, business and education work.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Course | Fee | Status |
| 2 | Amit | MS Office | 5000 | Paid |
| 3 | Priya | Excel | 4000 | Due |
| 4 | Rahul | Word | 3000 | Paid |
Workbook, Worksheet, Row, Column and Cell
These are the basic building blocks of Excel.
| Term | Meaning | Simple Example |
|---|---|---|
| Workbook | An Excel file that contains one or more worksheets | fee-record.xlsx |
| Worksheet | A single sheet inside a workbook | Sheet1, January, Students |
| Row | Horizontal line of cells, shown by numbers | Row 1, Row 2, Row 3 |
| Column | Vertical line of cells, shown by letters | Column A, B, C |
| Cell | Box where row and column meet | A1, B2, C5 |
| Cell Address | The unique name of a cell | A1 means Column A and Row 1 |
Where is MS Excel Used?
Excel is used in almost every office, business and institute.
Attendance
Maintain student, staff or employee attendance records.
Fee Records
Track fee received, pending amount and payment status.
Stock Records
Maintain inventory, stock quantity and reorder information.
Reports
Create sales, performance, marksheet and monthly reports.
Schedules
Prepare class timetable, duty chart and work planning sheets.
Calculations
Calculate totals, averages, percentages and balances.
Filtering
Find specific data from large lists quickly.
Charts
Convert data into visual charts for better understanding.
What Can We Enter in Excel?
Excel can store different types of data in cells.
Text Data
Names, course names, city, status, remarks and descriptions.
Number Data
Fees, marks, quantity, salary, sales and totals.
Date Data
Admission date, payment date, due date and schedule date.
Formula
Formula starts with equal sign and performs calculation.
Percentage
Used for marks, discount, profit, progress and attendance.
Currency
Used for money-related records like fees, salary and bills.
Example: Fee Record in Excel
Excel converts plain records into organized data sheets.
Plain Record
Excel-Style Record
| Name | Course | Fee | Paid | Balance |
|---|---|---|---|---|
| Amit | MS Office | 5000 | 3000 | 2000 |
| Priya | Excel | 4000 | 4000 | 0 |
| Rahul | Word | 3000 | 1500 | 1500 |
| Total Balance | 3500 | |||
Understand Cell Address
Click buttons to see how a cell address is formed.
Cell Address
A cell address is made using a column letter and row number. Example: A1.
Create Your First Excel Record Sheet
Complete these steps inside MS Excel.
Office Task: Student Fee Record
Mistakes Students Should Avoid
Good Excel habits begin from the first sheet.
Wrong Habits
- Typing all records in one cell.
- Leaving blank headings.
- Using unclear sheet names like Sheet1 only.
- Mixing text and numbers incorrectly.
- Not adjusting column width.
- Saving file with unclear name like Book1.
Correct Habits
- Use separate cells for separate data.
- Give clear column headings.
- Rename sheets meaningfully.
- Enter numbers as numbers, not text.
- Adjust column width for readability.
- Save file with a meaningful name.
Quick Quiz
Select the correct answers and check your score.
1. MS Excel is mainly used for:
2. An Excel file is commonly called a:
3. A worksheet is:
4. Rows are shown by:
5. Columns are shown by:
6. A cell is formed when:
7. The cell address A1 means:
8. Which of these is a practical use of Excel?
9. A formula in Excel usually starts with:
10. Which is a good Excel habit?
Remember These Points
Revise these before moving to Chapter 14.
MS Excel
A spreadsheet application used for data, calculations, reports and analysis.
Workbook
An Excel file that contains one or more worksheets.
Worksheet
A sheet inside a workbook where data is entered.
Rows & Columns
Rows are horizontal and numbered. Columns are vertical and lettered.
Cell Address
A cell address is made using column letter and row number, such as A1.
Next Step
Now learn Excel interface, workbook, worksheet and navigation.