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, click editor_changes_next_icon 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 fx_accept_icon in the Formula bar or press Enter. Or click fx_reject_icon 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 t_more. On the displayed insert pane, click t_insert_formulas Formulas.

On the Sidebar, click editor_formula_icon.

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 Paste or press Enter.

7.Enter the function arguments.

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

 

To cancel function searching by name, click clear_icon.

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 editor_formula_icon on the Sidebar once again.

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