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
Statistical
Functions:
- 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.
