Application: Spreadsheet

Spreadsheet and sheets

Spreadsheet: A file created or edited in MyOffice Spreadsheet. A spreadsheet contains at least one sheet.

Sheet: A part of a spreadsheet document that occupies a separate tab and has a unique name.

For more information, see Sheets.

Workspace

Workspace: The spreadsheet work area where all actions performed by user take place.

By default, the workspace consists of 10 columns and 20 rows. If required, the number of rows and columns in the workspace can be increased.

Column and row

Column: Vertical arrangement of cells on a spreadsheet.

Row: Horizontal arrangement of cells on a spreadsheet.

For more information, see Cells, columns, and rows.

Cells

Cell: A data field in the intersection of a row and a column.

Аctive cell: A spreadsheet cell that is currently selected and being edited. When a cell is active, it appears with a thick border around it and is highlighted.

For more information, see Cells, columns, and rows.

Cell range

Cell range: A group of adjacent cells in a spreadsheet. A cell range is selected manually.

Cell ranges can be used as a formula reference, that is, to calculate the sum of values in the selected range. A cell range can consist of one of the following:

A part of the row or column

The entire row or column

All rows and columns

Multiple adjacent cells from the adjacent rows and columns

For more information, see Cells, columns, and rows.

Formulas and functions

Formula: An expression which calculates the value in a cell. Formulas start with an equal sign (=) and can contain functions, values, cell references, and operators. Formulas can be entered directly in the active cell or in the Formula bar.

Function: A predefined formula in MyOffice Spreadsheet.

MyOffice Spreadsheet uses functions and formulas to perform all types of calculations.

For more information, see Formulas and functions.

Operands

Operand: A value that a formula uses for the calculation.

MyOffice Spreadsheet uses the following operands:

Constant: Numbers, dates, and text strings.

Reference: A link to a cell or a cell range that provides its value(s) for calculation.

Function: A predefined formula in MyOffice Spreadsheet.

Operators

Operator: An arithmetic operator or a group of arithmetic operators that state the action to perform with the operands.

Some examples include: a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*). A formula does not necessarily contain operators.

For more information, see Calculation operators.

Was this helpful?
Yes
No
Previous
About