How can we help you?

Product:

Application:

A list of functions supported by MyOffice Spreadsheet is available in Appendix A.

To insert a function in a cell, you can use the tools of the cell itself, the formula bar, or the Insert function pane.

To insert a function using the cell or Formula bar tools, follow these steps:

1.Select the cell in which you want to insert a function.

2.In the Formula bar or in the cell, type the equal sign ().

3.Start typing the name of the function to display a list of available functions.

4.Select the function you want to use from the list using the mouse or the keyboard keys:

•Select the desired function in the list by left-clicking.

•Select the desired function in the list using the ↓ and ↑ keyboard keys and press .

5.If necessary, you can read the description of the function. To do this, click the button to the right of the function name in the tooltip.

You can move the tooltip with the description of the function by holding the left mouse button down.

6.Enter the arguments of the function.

If in Microsoft Windows, in the Customize Format window, "." is selected in the Decimal symbol field, then in the MyOffice Spreadsheet application, use "," instead of ";" as the separator of values in functions.

7.To finish inserting a function, click the button in the Formula Bar or press . To cancel inserting a function, click the button in the Formula bar or press .

To insert a function using the pane, follow these steps:

1.Select the cell in which you want to insert a function.

2.Expand the Insert function pane in one of the following ways:

•In the menu, select .

•In the Formula bar, click .

•On the Toolbar, in the section, click . In the insert pane that appears, click .

•On the Sidebar, click .

•Press +.

3.Find the required function in one of the following ways:

•Enter part of the function name/the whole name in the search field. Below is a list of functions that meet the search conditions.

•Select the group that the function belongs to. For example, the function is part of the group.

•Find the function in one of the following groups:

o Contains all functions supported by the MyOffice Spreadsheet.

o Contains the last 10 functions inserted by the user.

o Contains a defined list of 10 frequently used functions.

4.Select the required function.

5.If necessary, check out the function summary at the bottom of the Insert function pane.

6.To insert a function into a cell, do one of the following:

•Click .

•Select the function by double-clicking.

•Press .

7.Enter the arguments of the function.

8.To finish inserting a function, click the button in the Formula Bar or press . To cancel inserting a function, click the button in the Formula bar or press .

9.To close the Insert function pane, do one of the following:

•In the menu, select .

•In the Formula bar, click .

•On the Toolbar, in the section, click . In the insert pane that appears, click .

•On the Sidebar, click .

•Click in the upper part of the Insert function pane.

•Press +.

When working with numeric data, you often need to carry out typical operations on it and output the result in a separate cell, for example, to calculate the sum or display the average value for selected columns or rows. For this purpose, it is convenient to use the Autosum operation. The operation allows you to use five popular data processing functions: SUM, MIN, MAX, AVERAGE, COUNT.

Autosum recognizes the cell range with numeric data and substitutes it into the function. The cells selected before the operation will determine where the result of the calculation will be output and what range of data will be used. For example, to calculate the sum for a column, you can:

•Select an empty cell below the column. The result will be inserted into this cell.

•Select the entire column. The result will be inserted into the empty cell under the column closest to the range.

•Select a cell range if you want to use only part of the cells in the calculation. The result will be inserted into the empty cell under the column closest to the range.

It is important to take into account the following:

•If the range contains several cells with the results of the same function, only such cells will be automatically included in the range. This is convenient when any subtotals have already been calculated in the column, and the final total will be their sum.

•If an empty cell next to an area with numbers is selected, all numbers after the nearest cell with text, an empty cell, or a cell with the same function will automatically be included in the range:

•If a cell range, column or row is selected, the function will include all data after the cell with the same function:

To insert a function using the Autosum operation, follow the steps below:

1.Select an empty cell next to the data, a column, row, or cell range.

2.Run the Autosum operation in one of the following ways:

•Click section of the Toolbar The SUM function will be used. If you want to use another function, click the arrow to the right of the button and select the desired function from the drop-down list.

•In the menu, click Autosum.

•Press Alt+=.

When you select an operation from the Command menu, Quick Actions box, or by using a keyboard shortcut, only the SUM function can be used.

3.If necessary, edit the function arguments or add additional ones to them.

4.To finish inserting a function, click the button in the Formula Bar or press . To cancel inserting a function, click the button in the Formula bar or press .

Only visible cells of the range are included in the calculation. The maximum possible number of arguments when using Autosum is 255.

Was this helpful?

Yes

No