Advanced Functions

What are used in higher-level operations such as conditional and comparison equations. 

• If Statements
• Advanced Spreadsheets
• Advanced Functions
• Advanced Charts

How many functions are we learning about in this class?

• 2
• 3
• 4
• 5

This function can be written to carry out an action and is a conditional operator. 

• If Statements
• List Functions
• Count Functions
• Lookup Functions

What functions are used to calculate a period of time. 

• Date Function
• If Statements
• List Functions
• Count Functions

Returns the current date. 

• Date Function
• Now Function
• Date360 Function
• List Function

Calculates the difference in days between 2 dates

• Date360
• Now
• Date Function
• Count Function

Function used to compare a cell value to a group of cells in two column vectors

• VLookup Function
• List Function
• Lookup Functions
• Count Functions

Used when there are more than two columns in a spreadsheet (looking up information in a table) 

• VLookup Function
• Lookup Function
• Array
• List Function

A function that is used to assist in organizing information, control content and filter content. 

• Lookup
• Count 
• List
• If Statements

A validated list that limits data entry to specific choices programmed into the function. 

• Validated 
• Non-validated 
• List 
• Count