Formulas and Functions in Excel

The formula used to do additions

• SUMIF

• SUMIFS

• SUM

• SUBTOTAL

Average Concept

• The sum of the numbers divided by how many numbers are in the list

• The value that occurs the most

• The sum of the number divided by 100

• The value in the middle of a data set. Meaning that 50% of data points are under the average and the other 50% are over the average.

Use the COUNT function to get

• Use the COUNT function to count the number of selected characters (numeric or alphanumeric)

• Use the COUNT function to count the number of alphanumeric characters.

• Use the COUNT function to count the number of numeric characters.

• Use the COUNT function to make an addition (the total of all numeric characters selected)

True or False. The minimum and maximum value can be identified organizing the data from largest to smallest or vice versa, and enabling the option min and max in the Sum function.

• True

• False

False or True. Organizing the data of a column from the Largest to the Smallest is the faster way to now the minimum and maximum value of the column.

• True

• False

It is the quickest and more practical functionality to do an interactive summary of data in Excel.

• Filters

• Pivot Table

• Count Function

• Sum (Addition) Function