SSuite Free Office Software

Providers of Safe and Trusted Software with Pure Visual Simplicity™

Blog

Accel Spreadsheet Starter's Guide

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:

  • moving the highlight to one corner of the required range
  • holding down the shift-key (or holding down the left mouse button if you are using a mouse)
  • moving the highlight to the opposite corener or until all the required cells are highlighted either using the arrow keys if shift is depressed ot the mouse.

 

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

 

Please note:

  • * denotes multiplication
  • / denotes division
  • and every and all formula must start with an equal sign =

 

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.

.......................................................................................................

Categories: None

Post a Comment

Oops!

Oops, you forgot something.

Oops!

The words you entered did not match the given text. Please try again.

Already a member? Sign In

0 Comments