Formula: Any expression in a cell that starts with an equal sign (=). Formulas can contain, among other things, functions, values, cell references and names, and operators.

Function: A predefined formula in MyOffice Spreadsheet that needs arguments to calculate correctly.

The cell in which the formula/function is entered is additionally highlighted on the sheet and is always visible, even if you switch to another sheet. Click the cell name or press Enter on your keyboard to quickly switch to the sheet with the formula/function if the cell with the formula/function is on another sheet.

When you enter a formula, the drop-down list of prompts displays the names:

- di (named ranges)

- fx (functions)

- tabl (tables)

The names of prompts in the drop-down list are sorted alphabetically. If the same names are displayed in the list of prompts but the elements are located on different sheets, their address (Spreadsheet/Sheet) is displayed next to those names.

Formulas and functions basics

Formulas always begin with an equal sign (=).

The equal sign can be followed by functions, constants, cell references, operators, and other elements.

All opening and closing parenthesis must be in sync.

The mandatory arguments of functions must be specified.

The constants should not contain a dollar sign ($).

Was the material useful?
Yes
No
Users found this material useful: 0 из 0