1. Each column is labeled with a letter at the top.
Each row is labeled with a number at the left. The intersection of a row and
column is called a cell. Each cell has a unique address, which consists of
the column letter and row number (for example, D3).
2.You enter a cell's contents using the entry bar at
the top of the spreadsheet. You can enter text, numbers, or formulas into
cells.
3.Formulas are not actual values like text or
numbers. Instead, formulas are a set of instructions that the spreadsheet
program follows to produce a value for a cell. You see a cell's formula in the
entry bar. The formula's result appears as the actual value in the spreadsheet
cell.
4.The spreadsheet always has one current (active)
cell, and that cell has a heavy border. The contents of current cell, if any,
appear in the entry bar.
5.A block of adjacent cells is called a cell range.
You identify a cell range by the addresses of the upper-left and lower-right
cells in the block.
|
In this spreadsheet, the upper-left cell is
B2 and the lower-right cell is C3. You type cell ranges using the
upper-left and lower-right cell addresses separated by two periods
(for example, B2. .C3).
|
You can enter data into a cell. at any time.
1.Select a cell in the spreadsheet. This cell
becomes the current cell.
2.Type the data in the entry bar. You can type up to
255 characters. The data scrolls to the right if you type more than can fit on
the screen.
To enter negative numbers, type a minus sign
(hyphen) and then type the number (for example, -128). To enter numbers as
text, type an equal sign and then type the numbers within quotation marks
(for example, =1994").
3.Confirm the entry.
To cancel what you typed and restore the original
contents of the cell, click the Cancel (X) button. - Tip If you select a
cell ran9Q. first, you can press Tab to enter data just within the selected
cells. When you're at the last column of the selection, pressing Tab moves
you to the first cell in the next row down. If you're entering data using
the numeric keypad, pressing Enter on the numeric keypad tabs you to the
next cell, providing quick, professional data entry.
If a text entry is too long to fit in a cell, the
text overlaps adjacent cells (depending on the text alignment) that are empty.
If the adjacent cells contain data, only part of the entry is visible.
If a numeric entry is too long to fit in a cell,
the number appears in~scientific notation or, if the cell is too small, you
see number signs (####).
After you've entered data into a cell, you can go
back and change it at any time.
1. Select the cell containing the data you want to
change. The cell's value or formula appears.
2. Make your changes in the entry bar.
If you can't see the data in the entry bar, click
in the data and use the arrow keys to move the insertion point where you
need it. Note - The way the arrow keys work depends on the spreadsheet
settings in the Preferences dialog box. If you've set the arrow keys to
always move you to another cell, you can still move the insertion point by
holding down the Option key while pressing an arrow key.
3. Confirm your changes by clicking the Accept (~)
button or by pressing Tab or Return. If you want to cancel the changes, click
the Cancel (X) button.
