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 in the lower part of the Workspace.

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.

Rows and columns

Row: Horizontal arrangement of cells on a spreadsheet.

Column: Vertical arrangement of cells on a spreadsheet.

For more information, see Rows and columns.

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.

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:

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

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