2.1 Introduction to Microsoft Excel

Microsoft Excel is a spreadsheet application used to store, organize, calculate, analyze, and present data. It is widely used in businesses, offices, educational institutions, finance departments, and personal work for tasks such as maintaining records, preparing reports, calculating expenses, managing sales data, and creating lists.

What You Will Learn

• Understand the purpose and uses of Microsoft Excel.
• Understand workbooks and worksheets.
• Identify rows, columns, cells, and ranges.
• Enter different types of data into a worksheet.
• Navigate through an Excel worksheet.
• Create, save, and open Excel workbooks.
• Understand basic Excel terminology.

What is Microsoft Excel?

Microsoft Excel is a spreadsheet program that organizes information in a grid made up of rows and columns. Each intersection of a row and column forms a cell. Data can be entered into these cells and then calculated, formatted, sorted, filtered, or analyzed.

Understanding a Workbook

An Excel file is commonly referred to as a workbook. A workbook can contain one or more worksheets. Each worksheet can be used to store a different set of related information.

For example, a company workbook could contain separate worksheets for employees, sales, expenses, and monthly reports.

Understanding a Worksheet

A worksheet is the individual spreadsheet area where data is entered and managed. It contains rows and columns that create a large number of cells.

Rows and Columns

• Rows: Horizontal lines of cells identified by numbers such as 1, 2, 3, and so on.
• Columns: Vertical lines of cells identified by letters such as A, B, C, and so on.

Understanding Cells

A cell is the basic unit used to store information in Excel. Each cell has a unique cell reference based on its column letter and row number.

For example, A1 represents the cell located at column A and row 1. Similarly, C5 represents the cell located at column C and row 5.

Cell Range

A range is a group of selected cells. For example, A1:A10 represents cells from A1 through A10, while A1:C10 represents a rectangular range covering columns A through C and rows 1 through 10.

Types of Data in Excel

Excel can store different types of information, including:

• Text: Names, addresses, product descriptions, and other words.
• Numbers: Quantities, prices, marks, salaries, and other numerical values.
• Dates: Dates such as 01/01/2026.
• Times: Values representing time.
• Formulas: Expressions used to perform calculations.

Excel Interface

• Ribbon: Contains commands organized into different tabs.
• Name Box: Displays the reference of the selected cell.
• Formula Bar: Displays or allows editing of the contents of the selected cell.
• Worksheet Area: Main area where data is entered.
• Sheet Tabs: Used to move between worksheets.
• Status Bar: Displays information about the selected cells and workbook.
• Scroll Bars: Used to move horizontally and vertically through the worksheet.

Creating a New Workbook

A new Excel workbook can be created by opening Microsoft Excel and selecting a blank workbook. Users can also use the keyboard shortcut Ctrl + N to create a new workbook.

Saving a Workbook

A workbook should be saved regularly to prevent loss of work. The Ctrl + S shortcut can be used to save changes. When saving a new workbook, the user selects a location, enters a suitable file name, and saves the file.

Practical Activity

1. Open Microsoft Excel.
2. Create a new blank workbook.
3. Enter the heading Student Information.
4. Enter the following column headings: Student Name, Class, Roll Number, Subject, and Marks.
5. Enter information for at least five students.
6. Save the workbook as Student Information.
7. Close and reopen the workbook.

Learning Outcome

After completing this section, learners will be able to understand Excel workbooks, worksheets, rows, columns, cells, and ranges, as well as create, save, open, and navigate basic Excel workbooks.