Functions in LibreOffice Calc Spreadsheet


Function

Functions are predefined formulas, with the help of which you can do complicated complex calculations. There are hundreds of functions list in Calc spreadsheet, with the help of which you can do a lot of engineering calculations, statistical calculations, financial calculations and text related calculations. Functions can be used as formula or to form complex formulas with other functions and Operators. You can Open Function Wizard by using shortcut key Ctrl+F2 or Go to Insert Menu>>Function

The Function Wizard –

The Function Wizard is a tool that helps us first to find the function we want through the library and secondly to introduce the arguments Step-by-Step and with the correct syntax.

1)) Select the cell that will contain the formula and the result will appear.

2)) click the f(x) button on the formula bar to open the function Wizard.

3)) select a category of functions to shorten the list, then scroll down through the named functions and select any one function by double-clicking on it. When you select a function its Description appears on the right-hand of the dialog. Double Clicking on the function name from the list or click Next.

4)) The Wizard now displays an area to the right where you can enter arguments manually by typing them inside the text boxes. Alternatively you can click the Shrink button to shrink the wizard so you can select cells from the spreadsheet using the mouse. Press Ok to exit the wizard.

There are following function Categories available in function Wizard-

  • Text Function
  •  Math Function
  • Date and Time Function
  • Database Function
  • Statistical Function
  • Logical Function

Post a Comment

0 Comments