|
Getting Started
To launch the program, click on the
program icon on the desktop or go to Start→Programs
[Start→All
Programs under Windows* XP*], and run the
StatPlus 2007→StatPlus
2007 command.
After the loading is competed, you will see the program's main window.
Fig 1.
When the program is loaded, you will see a
screen similar to the one above. The buttons in the main menu give a user access
to the various functions available in StatPlus. For example, to save a document,
run the File→Save
command. Toolbars run the most frequently used StatPlus commands and procedures.
The Task Pane at the right side of the window provides the user with
basic functions for starting work in StatPlus and gives access to the properties
of diagrams and pictures.
All information can be stored in hundreds or even thousands
of cells. To help with the careful organization of your data, here is an
overview of different methods of using a worksheet. To activate a cell, either
press the arrow keys (↓, →, ↑, ←), or left-click on the necessary cell.
Keyboard Commands | Keys | Cursor moves... |
|---|
| ↓,→,↑,← | To the next cell in
the selected direction | Ctrl+Alt+↓,Ctrl+Alt+→,Ctrl+Alt+↑,Ctrl+Alt+←
(up to 3.4.9 - only Ctrl) | To the next cell in
the selected direction (while keeping current screen position) | | Enter | To the next cell in the
same direction | | Shift+Enter | To the next cell in
the opposite direction | | Home | To
the A column of the current row | | End | To the last column of
the current row* | | Page Up | One
page upwards | | Page Down | One
page downwards | | Ctrl+Home | To the A1 cell | | Ctrl+End | To the last cell* | | Ctrl+↓ | To the last row of
the current column* | | Ctrl+→ | To the last column of
the current row* | | Ctrl+↑ | To the first row of
the current column | | Ctrl+← | To the first column of
the current row* | | Ctrl+Page Up |
Go to the previous worksheet | | Ctrl+Page Down | Go to the next worksheet |
* - depends on how many rows/columns are active Entering Data
StatPlus allows the following types of data for a cell: Text values (e.g. words "Total","Active") Numeric values (e.g.
numbers "15000","135700.77") - please note that such a cell value
must be either a whole number or a decimal number. Date and time values (e.g. "1.02.2005","12:01:33 PM")
Links to local files or to internet pages (e.g. "http://www.analystsoft.com","sales@analystsoft.com"> Graphics, diagrams, objects.
Every data type has
its own properties.
Run the Format→Cells... command to change properties (or simply use Format... command
in the worksheet context menu).
After entering information, it is
necessary to save it on a disk. This both protects information and allows using
it afterwards. Run the File→Save
command or click the "Save" button in
the Standard toolbar. If you want to change the filename, use File→Save
as.....
Editing Data
In case of mistyping information, you can
always change the value of a cell. You can perform the following actions with a
sheet:
·
Select a range of cells
·
Clear and delete cells
·
Copying data from one cell to another
·
Insert new rows and columns
·
Fill out a range of cells
Selecting cells
Some functions of the program do not work with individual
cells, but do work with cell ranges.
To select a cell range with a mouse - Highlight the first cell
of the range Holding left mouse button, pointer to select other cells
for the range
To select a range of cells with the keyboard -
move to the first cell in the range, and then, holding
the “shift” button, use the arrow keys.
To select an entire worksheet - run the Edit→Select All
command or press
Ctrl+A.
| Selecting rows and columns with the mouse | | To select
an entire column, click on the Column Header |  | | To select
an entire row, click on the Row Header |  |
To select cells using the Name box, click on the
Name box, type cell references, and then press Enter.
Example: a range of cells - A2:B3 |
 | To select
an entire worksheet, click on the cell located
to the left
from the A column and
the top column in the 1st row |  |
Clearing and deleting cells
To delete cell contents, click on a cell and press
the Del key or click on the "Clear" button ( ).
This clears both the contents and the formatting options, but cell alignment and
the borders remain unchanged. To clear both options and content, run the
Clear→All command in the worksheet context menu.
 Copying data from one cell to another
If you wish to copy a range of cells,
select necessary cells and run the Edit→Copy command or press Ctrl+C.
To paste cells into a new location, run the Edit→Paste command or press
Ctrl+V.
Note: StatPlus supports almost all of the Microsoft* Excel* hotkeys.
Adding new columns and rows
If you wish to add a row or a column to the document, go
to the last cell, and the program will automatically add a row/column. If it is
necessary to add several rows/columns, run the Edit→Rows/Columns→Count...
command.
Range Filling
To fill range with | Text | Select cell range, so the text
appears in the first cell:
 Run Fill... in context menu 
 | | Numbers |
Select a cell range, so the first number of the progression appears in
the first cell: 
Run Fill... in context menu
The window in which you can select fill parameters will appear:
Enter progression parameters and press OK 
|
Closing StatPlus
To exit the program, run the
File→Exit command or click "close box" in the main window.
Note:
It is a good idea to do the following before exiting the
program:
·
Save the document to a disk using an
easy-to-remember filename
·
Print (if necessary) the document by running
the File→Print command
·
Make a backup copy of the document after
closing the program.
|
