Top 10 Functions - Excel - vh

_________________ is a function that joins text together

• Concatenate

• Sum

• Sumif

• Count

_____________ is the function that adds up the cells in a range based on a criteria

• Sum

• Sumif

• Count

• Countif

________________ is a function that counts the number of cells containing numbers in a range.

• Count

• Countif

• Sum

• Sumif

______________ is the function that counts the number of cells that are not blank.

• Count

• Counta

• Sum

• Sumif

________ is the function that has a logical test and returns a statement based on whether it is true or false

• Countif

• If

• Sumif

• Sum

______________ is a function that counts the number of cells that are blank in a range

• Countblank

• Count

• Counta

• None of these

________________ is a function that will find the average of a range

• Sum

• Average

• Count

• Countif

_________ is the function that will allow us to find information from a chart based on the criteria

• VLookup

• Lookup

• None of These

• Count

A _____________ _________ is an interactive way to quickly summarize large amounts of data.

• Pivot Table

• Sum

• Sumif

• Count

________ ____________ ____________ is a function that will allow you to create a drop down list of data to choose from.

• Drop Down List

• None of these

• List

• List down