Excel+Formulas

Excel Vocabulary
( **A4:A10)** The number located within the parentheses indicated the **range**, or selected cells) that you want to have calculated by your formula.
 * Column** run up and down the sheet and are labeled by letter
 * Rows** run across the sheet and are labeled by number
 * Function** a built in formula in Excel. They always start with an equal sign. there are over 200 built in functions in Excel !
 * (colon)** the colon in Excel means "t//hrough//"
 * , (comma)** the comma in Excel means "//and//"
 * / (slash)** the slash in Excel means "//divided by"//
 * (**asterisk)** the asterisk in Excel means //''multiply by"//

Common functions of Excel
FORMULAS =SUM (A4;A10) Adds all values in the cells indicated in the range =AVERAGE (A4:A10 ) Instructs Excel to calculate the mean average of the values in the range =MIN (A4:A10) Instructs Excel to find the minimum value of the values in the range =MAX(A4:A10) Instructs Excel to find the maximum value of the values in the range =(B4/$B$10)*100 Excel Formula for **PERCENTAGES** where the absolute value cell (in this case,$B$10, represents the cell that holds the total number. To find the percentage, you take the smaller portion ( in this case, one cell, B4) and divide it by the larger total amount. This will provide you with a decimal. To convert the decimal to a whole number percent it is necessary to multiply ( using the *) by 100. In the formula for percentages, think of the cell without $ as the variable, meaning that that cell name can change if you want to apply to a series of cells. The **ABSOLUTE** VALUE indicated by $, **__ABSOLUTELY__** does not change.

[|How to find a percentage in Excel]
- This is a good worksheet to practice that also shows worksheets and explains formulas