|
Spreadsheet - ClarisWorks 4
Use a spreadsheet document or frame to organize text and numbers into rows
and columns. Spreadsheets are particularly useful for entering numbers that
you want to organize and analyze, either for financial accounting or for general
information. You can also use a spreadsheet to present text in a table. A spreadsheet
frame is especially useful for creating tables in word processing and draw documents.
Here are the key concepts you need to know about spreadsheets
- 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).
- 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.
- Formulas are not actual values like text or numbers. Instead, formulas are
a set of instructions that ClarisWorks 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.
- 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.
- 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
the highlighted area below,
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).
Types of data you can enter
You can enter numbers, text, or formulas into your spreadsheet. Each type of
data has a distinct purpose and advantage.
Select cells
To start entering data into your spreadsheet, you first need to select one
or more cells to work with. The cell that you can enter data into is called
the current cell. You see a heavy border around the current cell, and the cell's
contents (if any) appear in the entry bar.
You can select a single cell, a cell range, an entire row or column, or the
entire spreadsheet.
- To select single cell : Click the cell. Or, Choose Go To Cell from
the Options menu, type a cell address, and click OK. This cell becomes the
current cell.
- To select a range of cells : Click the first cell in the range and
drag to the last cell in the range. Or, click the first cell and Shift-click
the last cell. The upper-left cell becomes the current cell.
- To select a row or column : Click the row heading or column heading.
The first cell in the row or column becomes the current cell.
- To select the entire spreadsheet : Click the box in the upper-left
corner where the row and column headings intersect. Or, choose Select All
from the Edit menu. Cell A1 becomes the current cell.
Enter data into cells
To enter data into a cell:
- Select a cell in the spreadsheet. This cell becomes the current cell.
- 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").
- Confirm the entry.
To cancel what you typed and restore the original contents of the cell, click
the Cancel (X) button.
|
