3. TERCERA UNIDAD: El verbo
3.5. Las formas finitas
Now that you are an expert on getting around in Excel, you’re ready to start entering data. There are two basic types of information you can enter in a cell:
• Labels: Any type of text or information not used in any calculations.
• Values: Any type of numerical data: numbers, percentages, fractions, currencies, dates, or times, usually used in formulas or calculations.
This lesson focuses on labels. Labels are used for worksheet headings and make your worksheets easy to read and understand. Labels usually contain text, but can also consist of numerical information not used in any calculations, such as serial numbers and dates. Excel treats information beginning with a letter as a label and automatically left-aligns it inside the cell.
1
1..
If necessary, open the workbook named Lesson 1B and save it asIncome and Expenses.
If you do not know where your practice files are located, ask your instructor for assistance.
2
2..
Click cell A1 to make it the active cell.This is where you want to add a title for your worksheet. Don’t worry if the cell already contains text—anything you type will replace the old cell contents.
3
3..
Type Income and Expenses.If you make a mistake while you’re typing a cell entry you can press the <Backspace> key to delete any characters, one at a time.
Figure 1-22
Entering text labels in a worksheet. Formula bar Labels Cancel and Enter buttons Figure 1-22
Chapter One: The Fundamentals
35
Quick Reference
To Confirm a Cell Entry:
• Click the Enter button on the Formula bar.
Or…
• Press either the <Enter>
or <Tab> key. Or…
• Press any of the arrow keys on keyboard.
To Cancel a Cell Entry:
Click the Cancel button on the Formula bar. Or…
Press the <Esc> key.
To Enter a Label: 1. Select the cell you want
to contain the label.
2. Type the label – Excel will
recognize it as a label if it begins with a letter. Type an ' (apostrophe) if your label begins with a number.
3. Confirm the entry.
Notice as you start typing, that the text appears in both the cell and in the formula bar. Also, look at the formula bar—three new buttons have appeared: the Cancel button (the red X), the Enter button (the green check mark), and the Edit Formula button (the = sign), as shown in Figure 1-22. You can click the Enter button when you’ve finished typing to confirm the cell entry or the Cancel button to cancel the entry and return the cell to its previous state.
4
4..
Click the Enter button on the Formula bar (see Figure 1-22 if you can’t find it).Clicking the Enter button on the Formula bar confirms the cell entry. There are several other, more efficient methods for entering and confirming data; we’ll take a look at these methods in the next steps. Notice the text label is too large to fit in the current cell and the text spills into the empty adjacent cells to the right. Excel will use adjacent cells to display labels that are too long to fit in a single cell, so long as they are empty. If the adjacent cells aren’t empty, Excel truncates the text—everything’s still there, but you just can’t see all of it!
Next, you need to add some labels to make the worksheet more meaningful.
5
5..
Click cell A7 to make it the active cell.The series of numbers located directly to the right of the current cell are the basic monthly expenses for North Shore Travel. Go ahead and enter the labels for the expenses.
6
6..
Type Advertising and press the <Enter> key.Excel confirms your entry and moves down to the next cell, A8. You can also complete an entry by pressing any of the arrow keys, <Tab>, or as you’ve already learned, by clicking the Enter button on the formula toolbar. Notice the label Advertising doesn’t quite fit into the cell. Add the remaining expense labels.
7
7..
Type Office and press <Enter>.The cell pointer moves down to the next cell, A9. This row contains the monthly payroll expenses.
8
8..
Type Payroll but don’t press <Enter> this time.You decide you would rather use the label “Salary” instead of “Payroll” so cancel the change and return the cell to its empty state.
9
9..
Click the Cancel button on the Formula bar.The Payroll label does not disappear, but will disappear once you begin typing in the cell. Go on to the next step to enter the new correct label, for this cell and the remaining labels.
1
100..
Type Salary and press <Enter>, type Rent and press <Enter>, and then type Totals and press <Enter>.NOTE: Excel normally treats any information beginning with a letter as a label and
any information beginning with a number as a value. If you want to create a label that starts with a number, type an ' (apostrophe) before typing the number to prevent Excel from recognizing it as a value.
Congratulations! You’ve finished entering the expense labels for the worksheet, making it much easier to read and understand. Compare your worksheet with the one in Figure 1-22, and then go on to the next lesson to enter some values into the worksheet.
Enter button
Other Ways to Enter:
Press the <Enter> key. Press the <Tab> key. Press any of the arrow
keys.
Cancel button
Other Ways to Cancel: