This tutorial is copyrighted by the Department of Computer Science at The University of Rhode Island. It may be freely copied and used providing that acknowledgement is given to the URI Dept. of Computer Science and that it is not used for profit. Questions should be sent to Dr. Fay-Wolfe (wolfe@cs.uri.edu).

Microsoft Excel is an electronic spreadsheet program.

You might of heard the terms "spreadsheet" and "worksheet". People generally use them interchangebly. To remain consistent with Microsoft and other publishers the term

Most of the Excel screen is devoted to the display of the workbook. The workbook consists of grids and columns. The intersection of a row and column is a rectangular area called a

The workbook is made up of cells.There is a cell at the intersection of each row and column.A cell can contain a value, a formula, or a text entry. A text entry is used to label or explain the contents of the workbook. A value entry can either be a constant or the value of a formula. The value of a formula will change when the components (

The Excel worksheet contains 16,384 rows that extend down the worksheet, numbered 1 through 16384.

The Excel worksheet contains 256 columns that extend across the worksheet, lettered A through Z, AA through AZ, BA through BZ, and continuing to IA through IZ.

The Excel worksheet can contain as many as 256 sheets, labeled Sheet1 through Sheet256. The initial number of sheets in a workbook,which can be changed by the user is 16.

You will learn about Excel's toolbars and entering information into a workbook in the next part of the tutorial.

Main Menu |

Throughout the tutorial you will have two windows active; a window displaying the tutorial and a window displaying an Excel workbook. Let's begin.

Find and Open Excel 97.

Resize and position then window displaying the tutorial next to the blank Excel workbook.

Excel displays a new workbook when it is opened. In a new workbook all the cells are empty. A cell is active when the border is highlighted in blue. When you enter information, the information is stored in the active cell. Let's learn how to enter information into a workbook.

Click on the Excel window, select a cell by clicking on it, and enter:

Observe the following:

Observe that your text is displayed in two areas. Text is displayed in the active cell within the workbook and it is also displayed in the

Next to the formula bar are the

Within the Excel window, click in the formula bar to display the

The

If you want to edit the text you entered into a cell, you click the formula bar, type your changes and click on the

The

Within the Excel window, click in the formula bar and change the text:

Click on the

Click on the

Entering constant values is the same as entering text, except that constant values are right-justified by default. You will learn how to change this default when you learn other formatting changes.

All formulas in Excel must begin with an equal sign (=). When a formula is entered into a cell, the formula itself is displayed in the formula bar when that cell is highlighted, and the result of the formula is displayed in the actual cell. When you are typing in formulas, do not type spaces; Excel will delete them.

Within the Excel window, select cell A2 and enter the constant value 12. (Remeber to click the

Within the Excel window, select cell A3 and enter the constant value 15.

Within the Excel window, select cell A4 and click on the formula bar.

Within the formula bar, enter an equal sign followed by

Observe:

Click on the

Your worksheet should look as follows:

Excel displays the result of the formula in cell A4.

Within the Excel window, select cell A3 and change the number 15 to the number 40, and enter the edit.

The formula value should have changed in cell A4 to the number 52.

Now that you know how to enter information into an Excel workbook it is time to create a simple workbook.

Next Topic: Creating a Workbook |

Main Menu |