Ericsson MC 218 - Using Ranges

143 Sheet
• Absolute references, such as $A$2. These contain a $ sign in front of
the parts of the reference that you don’t want to change even if the
formula is moved elsewhere. So, $A$2 in cell B3 remains $A$2 when
copied to cell C3.
• You can combine the two types of reference: A$5 in A6 will become
B$5 when copied to B8.
A formula which contains a reference to its own cell, either directly or
indirectly, is called a circular reference. You can find any circular references
in the worksheet using Find on the Edit menu. You should avoid making
circular references as they produce unpredictable results.
Recalculation
Sheet automatically recalculates your worksheet every time you change part
of a calculation. You may want to turn this feature off if you are making a
large number of changes in the worksheet.
To disable automatic recalculation:
• On the Tools menu, select Preferences, and set Auto recalculation to
off. When Auto recalculation is off, a ‘+?-’ symbol will be displayed at
the right end of the input line whenever you need to recalculate
manually to update results.
To make Sheet recalculate the worksheet, select the command on the Tools
menu.
Functions
Sheet has a large number of functions, e.g. mathematical, financial and
trigonometric functions, that you can incorporate in your calculations. See the
built-in help on the MC 218 for a full list and details of syntax.
To use a function in a calculation:
• Just type it in. Alternatively, tap the function button or select Function
on the Insert menu. Choose the function you require.
A range is a rectangular block of cells. The reference for a range consists of
the cell references of the top left and bottom right corners of the block,
separated by a colon, e.g. B2:C6. You can use ranges to define areas of the
worksheet for applying formatting, creating graphs, or include range
references in formulae, e.g. =SUM(B2:C6).
To select a range:
• Highlight all the cells you want to be a part of your range.
To use a range in a formula:
• Highlight the range to be inserted while entering the formula. For
example, type ‘=SUM’ then drag the highlight to cover the appropriate
range, type a ‘,’ and press Enter.
Naming ranges
You can name a range.
USING RANGES