Spreadsheets and sheets

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

Sheet: A table-type page in a spreadsheet with a unique name specified in a sheet tab.

For more information, see Sheets.

Workspace

Workspace: The spreadsheet work area. All actions performed by user are performed within the Workspace.

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.

Rows and columns

A sheet consists of rows and columns.

Row: Horizontal arrangement of cells on a spreadsheet.

Column: Vertical arrangement of cells on a spreadsheet.

Each row and column is assigned a header. As a rule, the headers of rows consist of numbers, and the headers of columns consist of the Latin alphabet letters.

For more information, see Rows and columns

Cells

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

Column and row headers form a cell address. For example: F12, N3, H185 etc. This cell reference style is called A1 and is used in MyOffice Spreadsheet by default. MyOffice Spreadsheet also uses the R1C1 cell reference style where both row and column headers are numbers.

To change the cell reference style, select View > R1C1 Reference Style.

А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.

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, i.e. to calculate the sum of values in the selected range. A cell range can consist of one of the following:

All rows and columns.

The entire row or column.

Multiple adjacent cells in a single row or a column.

Multiple adjacent cells from the adjacent rows and columns.

If the range is named, users can insert the range name to a formula.

Naming the ranges is only possible in the desktop version of MyOffice applications. This feature will be available for use in the next web versions of the application.

For more information, see Cell ranges.

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.

Pivot tables

A pivot table is a data processing tool allowing to summarize and analyze the information.

In the current version of the application you can only view, update and delete pivot tables created using the desktop version of MyOffice application or other third-party editors. Creating and editing pivot tables in the web version of MyOffice application is under development and will be available in the further versions of the application.

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