Using an Excel worksheet - Basic terminology

Using an Excel worksheet - Basic terminology
Step 1 - Launch Excel - Automatically a workbook opens. An Excel workbook is made of several sheets. Unless you have changed the default setting you will have three sheets.

Step 2 - Changing the name of the worksheets - Each sheet is a full spreadsheet. Having a workbook with multiple sheets allows you to easily establish relationships from one sheet to another.
The name of the sheet may be changed. Double-click the name of the sheet in the tab at the bottom, and type the new name.

Step 3 - Inserting additional worksheets - If you need additional worksheets, go to the Insert menu and select Worksheet. It will be placed before the selected sheet. You may also insert a worksheet by right-clicking on the name of the sheet in the tab and selecting Insert... (Macintosh users, Hold down the Ctrl key while clicking. If you want more information on this see a module about teaching your Mac to right-click.)
As you can see from the graphic above, renaming the worksheet can also be accomplished by right-clicking the tab containing sheet names.

Step 4 - Cells - Rectangles in a spreadsheet are called a cell. Cells are designated by the column and row in which it is located. By default, the top left cell, A1, is highlighted.

Step 3 - Inserting additional worksheets - If you need additional worksheets, go to the Insert menu and select Worksheet. It will be placed before the selected sheet.
You may also insert a worksheet by right-clicking on the name of the sheet in the tab and selecting Insert... (Macintosh users, Hold down the Ctrl key while clicking. If you want more information on this see a module about teaching your Mac to right-click.) Try the following ways to move from cell to cell:

Hit the Return/Enter key to move down to the row below
Hold down the Shift key, then hit the Return/Enter key to move up to the row above
Hit the Tab key to move over to the column to the right
Hold down the Shift key, hit the Tab key to move back to the column to the left
Move the cursor to any cell and click there
Use the arrow keys to move up, down, left, or right.

Step 5 - Recognizing cursor styles - There are four common cursor styles used in Excel

Step 6 - Entering data - Move to the cell where you want to enter data and enter words or numbers. If data is already in the cell it will be replaced without having to cut or delete the previous data.
Using an Excel worksheet - Entering and Editing Data

Step 1 - Cell data - Things that can be entered into a cell:
numbers
words
equations, formulas or functions
fill color
images (although they are actually on top of a cell, not in it)

Step 2 - Entering data - Move to the cell where you want to enter data and enter words or numbers. If data is already in the cell it will be replaced without you having to cut or delete the previous data. A review is available on how to move from cell to cell.

Step 3 - Format data - Once information has been entered into a cell, you might want to change something about the way the information is displayed. To do that, make sure the cell you want to format is selected and go to the Format menu. Select Cells... The number I entered repeats infinitely, but I only need 2 decimal places
You can bring up the Format Cells dialog box by right-clicking on the cell you want to format. (Macintosh users, remember that is Ctrl + click). From the following pop-up box select Format Cells...

Step 4 - Using formatting buttons - There are several toolbar buttons which allow one-click formatting. To illustrate I entered the same number in four cells, with the formatting I plan to use for each cell.

With cell A1 selected I clicked once on the Currency button
In cell B1 I selected the Percent button
I selected the Increase Decimal button for cell C1
The Decrease Decimal button was used to format cell D1
These four actions produced the following result:
As you can see, the Percent button simply multiples by 100 and attaches the % sign. Care must be exercised in using this button properly.

Step 5 - Other formatting options - The Format toolbar includes several formatting options which can be applied to information entered into a cell.
If you need a review of these options, go back to the Formatting toolbar module.

Step 6 - Editing entered data - If incorrect information has been entered into a cell, one easy way to edit that is to click on the cell and enter the correct information. You do not need to highlight or delete. Typing replaces whatever is in the cell.
If you do not want to replace the data, but simply need to correct some part of it, move your cursor into the Formula bar
When your cursor turns into an I-Beam, click and edit within the formula bar.

Step 7 - Review cursor styles - There are four common cursor styles used in Excel. Become familiar with each style.
Website:www.internet4classrooms.com