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: 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: Vertical arrangement of cells on a spreadsheet. Row: Horizontal arrangement of cells on a spreadsheet. For more information, see Cells, columns, and rows. |
Cell: A data field in the intersection of a row and a column. 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: 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. |
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. |
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. |
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. |