Excel applications

by


 Choose one of the following Excel applications.

  • Gradebook calculations
  • Budget
  • Database search
  • Database cleanup

 Choose one of the following functions from the list below. Math & Trig          

 Functions:

  • AVERAGE
  • POWER
  • SQRT
  • SUM
  • SUMIF

Lookup & Referance Functions:

  • LOOKUP
  • HLOOKUP
  • VLOOKUP

StatisticalFunctions:

  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • Describe how the function works within the application you chose  and the process to implement the function in an Excel spreadsheet.  There are many different functions to choose from, so this should not be  a problem.
  • List the sources you used to support your function  characteristics description. If it is a YouTube video or an article from  the Internet, ensure that you include the link to the source.