= Sum (A1 : A4) Funciton name Funciton arguments Equal Sign First Cell Last Cell Figure . Function Syntax Chapter . Open the spreadsheet which was created in Illustration . .
Delete all the formula in Total column. . Use SUM function to add all the marks of each student. .
Save the changes and close the file Self Practice: . . . Using Function Wizard method A function can inserted using Function Wizard in Calc.
Function Wizard is a dialog box provides the step-by-step procedure to insert a function. Function wizard can be invoked by clicking the Function Wizard icon on the Formula bar (or) Insert → Function (or) Ctrl + F2. Refer Figure . Function category drop down list box: Function Wizard has two tabs viz.
Functions and Shortcuts. In Functions Tab, the list of categories is available in Category drop down list box. In Calc, the functions are categorized into types. They are, .
Database . Date and Time . Financial . Information .
Logical . Mathematical . Array . Statistical .
Spreadsheet . Text . Add-in List of Functions Function Name with arguments Short description about the Function Function Category List box Figure . Function wizard Chapter If you select any particular category, the Functions list box shows the functions which belongs to the selected category.
If “All” is selected under category all functions in calc is displayed in alphabetical order. Refer Figure . Selected Category List of Functions Figure . Function wizard – Function Category list box Function Description When you select a function, the function wizard shows the function name, syntax and a small description about the function on the right side of the dialog box.
Refer Figure . Inserting a function using Function Wizard: (with Cell Reference) The following steps explains to insert POWER( ) function in a cell. About POWER ( ) function: POWER ( ) is a function which is used to calculate power of an exponent value of a number. This function is categorized as a Mathematical function.