Content Based Standards

Competency Based Standards

Intermediate Functions

• Inserting functions from the menu
  
• Inserting function form the formula bar
  
• Typing functions directly into cells
  
• 
  
• The SUM() function with different ranges
  
• The SLOPE() function
  
• The LINEST() function
  
• Using the FORECAST() function
  
• How to use the CORREL() function Interpolation
  
• The Intercept() function
  
• The Intersect()Function
  
• 
  
• The LOG() function
  
• The LOG10() function
  
• The LN() function
  
• 
  
• The EXP() function
  
• The POWER() function
• 
  
• The ROMAN()function
  
• The EVEN() function
  
• The ODD() function
  
• The MOD() function
  
• The SIGN() function
  
• The TRUNC() function
  
• 
  
• The PRODUCT() function
  
• The QUOTIENT() function
  
• 
  
• The LCM function
  
• The GCD function
  
• 
  
• The LOWER() function
  
• The UPPER() function
  
• 
  
• The VAUE() function
  

Trigonometic Functions

• Trigonometric functions index
  
• Using constants such as Pi
  
• The RADIANS() function
  
• The DEGREES() function
  
• The SIN() function
  
• The COS() function
  
• The TAN() function

Statistics Functions

• The AVERAGE() function
  
• The MEDIAN() function
  
• The MODE() function
  
• The PERMUT()function
  
• The COMBIN() Function
• The STDEV() function
  
• The PERCENTILE() function
  
• The RANK() function
  
• The PERCENTRANK() function
  
• The NORMDIST() function
  
• The FREQUENCY() function
• 
  
• The RSQ() function
  
• The PEARSON() function
  
• The TREND() function
  
• The GROWTH() function
  
• Linear regression Line of least squares fit

Date & Time Functions

• Time stamping
  
• Date stamping
  
• 
  
• The NOW() function
  
• The TODAY() function
  
• 
  
• The TIME() function
  
• The TIMEVALUE() function
  
• The HOUR() function
  
• The MINUTE() function
  
• The SECOND() function
  
• 
  
• The DAY() function
  
• The MONTH() function
  
• The YEAR() function
  
• The YEARFRAC() function
  
• 
  
• The WEEKDAY() function
  
• The WEEKNUM() function
  
• The WORKDAY() function
  
• The NETWORKDAYS() function
  
• 
  
• The DATEVALUE() function
  
• The DATE() function
  
• 
  
• The DAYS360 funvtion
  
• The EOMONTH() funvtion
  
• The EDATE function

Logical Functions

• The TRUE function
  
• The FALSE function
• 
  
• The AND function
  
• The OR function
  
• The NOT function
  
• 
  
• The IF function
  
• Nested IF functions
  
• The IFERROR() function