Excel

calculates the simple average of a set of numbers

• SUM

• AVERAGE

• MIN

• MAX

counts the number of cells in a range of cells that contain numbers

• AVERAGE

• MIN

• COUNT

• MAX

show a result based on a criteria being met, and a different result if the criteria is not met TRUE? FALSE?

• IF Function

• Median

• Mode

• Vlookup

combines blocks of text

• adding

• copying

• text wrap

• concatenate

error which occurs when the cell reference is not valid

• ####

• #REF!

• #NUM!

error which occurs when a misspelling has occurred in a function name

• ####

• #REF!

• NAME?

• NUM!

error which occurs when the column is not wide enough to display the contents of a cell

• ####

• #REF!

• #NAME?

• #NUM!

Can be used to locate values in a table or range of cells

• Text Wrapping

• VLOOKUP or HLOOKUP

• SUM and AUTOSUM

• CONCATENATE

table which can be rearranged (pivoted) to analyze data in a variety of ways

• Pivot table

• Pivot chart

• Pie Chart

• Line Chart

tool which can be used to display only data which meets certain criteria

• Merging

• Concatenate

• Sorting