|Posted on March 23, 2013 at 6:55 AM|
The following information will help you get started in using Accel spreadsheet in no-time, and all other spreadsheets in general.
Let us start with the navigation keys; to move the active cell highlight around, simply use the arrow keys on the right-hand side of your keyboard. For faster movement of pages up and down, you may use the PgDn and PgUp keys. This moves the spreadsheet one screen up or down.
You may also use Shift + PgDn and Shift + PgUp keys to move the screen one page up or one page down. Toggling the PgUp or PgDn keys, keeps the screen moving by one screen length.
To move the active highlight to the first column of any page, just press on the Home button. By pressing the Ctrl + Home button, the active cell highlight moves to the first row and column in any workbook e.g. - A1.
Cell ranges are entered as A1:B5 in the formula edit box.
The cell range can be selected by:
Entering data into a spreadsheet:
Each cell in the spreadsheet may have data entered into it. This is simply done by moving the active cell highlight to the cell and typing in one of four types of value: a number, text, formula, or function. The data is only inserted into the cell once you press Enter or move to another cell.
To resize any row height or column width, you only need to move the mouse cursor onto the header borders, and then simply hold and drag the edges to where-ever you need it to be. On the bottom of the screen inside the statusbar, you will see the measured distance in millimeters and inches of the size of the cell. This will also help you in creating very accurate table sizes, if you need this feature.
In spreadsheets the idea is NOT to do the calculation yourself. You want the computer to do it. You also do NOT want to have to change formulas every time that the data they use changes. For example, if a student's mark changes you do not want to have to find and change all the formulae where that mark is used. The formula must be written out referring to the cells in which the data can be found and is typed into the cell where you want the answer to appear. The formula is, therfore: =(B5+C5+D5+E5+2*F5)/6
When formulas are used, the old BODMAS rule applies. Values inside Brackets are calculated first, the Of, Division and Multiplications, the Addition and Subtraction.
All formulae are preceded by an equal sign = in most major spreadsheets including our own, to indicate that this a formula and must cause a calculation to be done. If the equal sign = is omitted, the spreadsheet will decide that this is just some text and will display it in the cell.