Spreadsheet: A document that a user works with in MyOffice Spreadsheet. Sheet: A section of a document that has a table structure. You can switch between sheets using tabs. Each sheet has a unique name, which is displayed on its corresponding tab. For a detailed description of working with sheets, please refer to the Sheets section. |
Columns: Vertically arranged groups of cells on a sheet. Rows: Horizontally arranged groups of cells on a sheet. For a detailed description of working with columns and rows, please refer to the Cells, Columns, and Rows section. |
Cell: A data field in the intersection of a row and a column. Active cell: A spreadsheet cell that is currently selected and being edited. The active cell is always framed. For a detailed description of working with cells, please refer to the Cells, Columns, and Rows section. |
Cell range: A manually selected group of cells that are adjacent to each other in a table. You can use cell ranges for calculations, for example, in sum or multiplication formulas. The range may include: •A part of the row or column •The entire row or column •All rows and columns •Multiple cells from adjacent columns and rows For a detailed description of working with cell ranges, please refer to the Cells, Columns, and Rows section. |
Formula: Any expression in a cell that starts with an “=” sign. Formulas can contain functions, values, cell addresses, names, and operators. Formulas are used to conduct complex calculations in spreadsheets. You can enter and edit formulas in the active cell, in the Formula bar, or in the Function Wizard window. Function: A preset formula in MyOffice Spreadsheet. Simple formula: A formula containing a single function. Complex formula: A formula containing a function as an argument, or a formula consisting of several functions linked by operands. Nested function: A function that is an argument to another function or formula. With the help of functions and formulas, you can perform calculations of any complexity. For a detailed description of working with formulas and functions, please refer to Formulas and Functions section. |
Operands: The elements over which calculations are performed. MyOffice Spreadsheet uses the following operands: •Constants: Numbers, dates, and text strings that are present directly in the formula. •References: Elements that specify the cell or cell range from which the formula retrieves data for calculations. •Functions. |
Operators define the actions that are performed on operands during calculations. Operators are a sign or a combination of signs. For example, “+” is an arithmetic addition operator. Also, operators may not be present in the formula. For more information, please refer to Calculation operators section. |