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
0 Comments