Understanding the basic terminology used in Excel is crucial for navigating and utilizing the software effectively. This section will introduce you to the key terms and concepts that form the foundation of Excel.

• Definition: A file in Excel that contains one or more worksheets.
• Example: When you open Excel, a new workbook is created by default, typically named "Book1".

• Definition: A single sheet within a workbook where you can enter and manipulate data.
• Example: By default, a new workbook contains one worksheet named "Sheet1".

• Definition: The intersection of a row and a column in a worksheet. Each cell can hold data such as text, numbers, or formulas.
• Example: Cell A1 is located at the intersection of column A and row 1.

• Definition: A selection of two or more cells. Ranges can be contiguous (adjacent) or non-contiguous.
• Example: A contiguous range could be A1:A10, while a non-contiguous range could be A1:A5, C1:C5.

• Definition: A vertical series of cells in a worksheet, identified by letters (A, B, C, etc.).
• Example: Column A is the first column in a worksheet.

• Definition: A horizontal series of cells in a worksheet, identified by numbers (1, 2, 3, etc.).
• Example: Row 1 is the first row in a worksheet.

• Definition: An expression that calculates the value of a cell. Formulas begin with an equal sign (=).
• Example: =A1+B1 adds the values in cells A1 and B1.

• Definition: A predefined formula that performs calculations using specific values, called arguments, in a particular order.
• Example: =SUM(A1:A10) adds all the numbers in the range A1 to A10.

• Definition: The address of a cell, indicating its column and row. Cell references can be relative, absolute, or mixed.
• Example:
  • Relative: A1
  • Absolute: $A$1
  • Mixed: A$1 or $A1

• Definition: The toolbar at the top of the Excel window that contains tabs and commands for performing various tasks.
• Example: The "Home" tab on the Ribbon includes commands for formatting text, numbers, and cells.

• Definition: The bar located above the worksheet where you can enter or edit data, formulas, and functions.
• Example: When you click on a cell, its contents are displayed in the Formula Bar.

• Definition: The box to the left of the Formula Bar that displays the cell reference or the name of the selected cell or range.
• Example: If cell A1 is selected, the Name Box will display "A1".

• Definition: The lines that separate cells, rows, and columns in a worksheet, making it easier to view and organize data.
• Example: Gridlines are visible by default but can be hidden through the "View" tab on the Ribbon.

• Definition: A feature that allows you to quickly fill cells with repetitive or sequential data.
• Example: Dragging the fill handle (a small square at the bottom-right corner of a selected cell) to fill adjacent cells with a series of numbers or dates.

• Definition: The process of changing the appearance of a cell or range of cells, including font, color, borders, and number formats.
• Example: Applying bold text, changing the background color, or formatting numbers as currency.

• Explanation: This formula adds the values in cells B1 and B2 and displays the result in cell B3.

• Explanation: This function adds the values in cells C1, C2, and C3 and displays the result in cell C4.

1. Open a new workbook.
2. In cell A1, type "Name".
3. In cell B1, type "Age".
4. In cell A2, type "John".
5. In cell B2, type "25".
6. Bold the text in cells A1 and B1.
7. Change the background color of cells A1 and B1 to light gray.

1. In cell C1, type "10".
2. In cell C2, type "20".
3. In cell C3, create a formula to add the values in cells C1 and C2.

In this section, you have learned the basic terminology used in Excel, including key concepts such as workbooks, worksheets, cells, ranges, and formulas. Understanding these terms is essential for navigating and using Excel effectively. In the next section, we will delve into creating and saving workbooks, building on the foundational knowledge you have gained here.