Excel Advance (Logical Functions)

A boolean logic operator that at least one item must be true for the statement to be true.

• NOT

• OR

• AND

A boolean operator that switches a True to a False and a False to a True.

• AND

• OR

• NOT

A boolean operator which all items must be true for the statement to be true

• AND

• OR

• NOT

A specific format required to use a function its name and order of arguments.

• Result

• Algorithm

• Arguments

• Syntax

Used by the function to calculate the result.

• Syntax

• Arguments

• Result

• Algorithm

A step-by-step procedure for accomplishing some end task.

• Arguments

• Result

• Syntax

• Algorithm

The value calculated by the function.

• Result

• Syntax

• Algorithm

• Arguments

A FUNCTION that determines the number of cells in a range that contain numbers

• MIN()

• MAX()

• COUNT()

• AVERAGE()

A FUNCTION that calculates the arithmetic mean of a list of values

• SUM()

• MAX()

• MIN()

• AVERAGE()

A FUNCTION that returns the largest number of a range of values

• MAX()

• MIN()

• AVERAGE()

• IF()