Text is also known as __labels____________. .Numbers are also known as values________________________. .The purpose of excel is to compile data, ___perform calculations_______________________ and create___graphs and charts___________. .Calculations are performed using formulas___________________ and _______functions__________. .Mathematical expressions that you create or enter are _____formula___________ .Mathematical expressions that are already available in excel are _function__________________. .Formulas that contain cell references______________________ produces results that will change if thedata in those cells change. (Example: =A1+B1) .Predefined formulas are already built in Excel______________. .Clicking on the arrow next to the Auto sum button will display other common Functionsused in Excel including these (fill in the function name)
calculates the total in a range of cells sum button 
calculates the average in a range of cells average button
 displays the highest value in a range of cells max button
  displays the smallest value in a range of cells min button
  .Name two types of cell references used to create formulas and describe each:
1. relative- adjust to new location when copied.
2. absolute-does not change when moved or copied.
.What symbol must be used to make a cell reference into an absolute cell reference
the dollar sign, the F4 key on the keyboard can be used as a shortcut.