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

In "MyOffice Spreadsheet", you can enter a function directly into a cell, in the Formula bar, or using the Insert function panel.

To enter a function in a cell or using the Formula bar, follow these steps:

1. Select the cell in which you want to enter 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.

Click the function.

Select the function using the ↓ and ↑ buttons and press Enter.

5. If necessary, press the editor_changes_next_icon button on the right of the Function tooltip box to display quick information on the function.

The Function tooltip box can be moved by holding down the left mouse button.

 

formula_hint

6.Enter the function arguments.

7.To finish, click the fx_accept_icon button in the Formula bar or press Enter. Or click the fx_reject_icon button in the Formula bar to cancel.

 

To enter a function using the Insert function panel, follow these steps:

1.Select a cell in which you want to enter a function.

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

On the Insert menu, select Formulas.

On the Toolbar, select the Insert section and click the t_more button. On the displayed insert panel, click the t_insert_formulas (Formulas) button.

On the Sidebar, click the editor_formula_icon button.

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

4.Select the function you want to use from the list.

5.If necessary, read the function's description in the lower part of the Insert function panel.

6.To paste the function into the cell, click the Paste button or press Enter.

7.Enter the function arguments.

8.To finish, click the fx_accept_icon button in the Formula bar or press Enter. Or click the fx_reject_icon button in the Formula bar to cancel.

 

To cancel function searching by name, click the clear_icon button.

To close the Insert function panel, click the fp_header_back_icon button in the upper-left corner of the Insert function panel. Or click the editor_formula_icon button on the Sidebar once again.

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