Using The Function In Excel 3

Using The Function In Excel 3

• 1.
  Using the Function in Excel COMPUTER LITERACY FORM 1
• 2.
  Function A function is a predefined formula that performs a common or complex calculation.
• 3.
  A function consistsof two components: the function name and, in most cases, an argument list .
• 4.
  For example, theSUM function adds values or a range of cells.
• 5.
  You enter therange of cells as an argument to the function, and Excel calculates the total of the range.
• 6.
  A typical SUMfunction, totaling cells B5 through B10, looks like this. =SUM(B5:B10)
• 7.
  =SUM(B5:B10)function name argument list
• 8.
  Excel’s AutoSum feature offers a shortcut for entering SUM functions to total ranges of cells.
• 9.
  When you clickthe AutoSum button on the Standard toolbar, Excel totals cells directly above or to the left of the cell containing the function.
• 10.
  Using Basic StatisticalFunctions Excel offers hundreds of functions, many of which are very specific to certain tasks or to people in certain occupations.
• 11.
  There are acouple of functions that you use all of the time and many that you will never have reason to use.
• 12.
  Excel’s basic andmost frequently used functions are shown in the following table.
• 13.
  =SUM(B5:B10) Example Totalsthe numeric arguments. Meaning Sum Function
• 14.
  =AVERAGE(B5:B10) Example Computesthe average (arithmetic mean) of the numeric arguments. Meaning Average Function
• 15.
  =COUNT(B5:B10) Example Withinthe argument list, counts only the cells that contain numbers. Meaning Count Function
• 16.
  =MIN(B5:B10) Example Returnsthe smallest number within the arguments. Meaning Min Function
• 17.
  =MAX(B5:B10) Example Returnsthe largest number within the arguments. Meaning Max Function