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.