Choose one of the following Excel applications

Subject:Electrical EngineeringPrice: Bought3

Share With

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.