Excel+Study+Guide


 * __ Study Guide for Excel __**
 * __ Review Formulas for: __**

**Adding** =SUM(cell range)
 * Subtracting ** =Cell1-Cell2
 * Multiplying ** =Cell 1*Cell2
 * Dividing ** =Cell1/Cel2
 * Mean ** =AVERAGE(CellRange)
 * Median ** =MEDIAN (CellRANGE)
 * Mode ** =MODE(CellRange)


 * //__ TERMS __//**


 * __ Formula: __** mathematical function that contains cell addresses and mathematical operators
 * __ Cell Address: __** the name of a cell; contains both the column and row reference
 * Active cell: ** Location in the worksheet that will display typed data and will be affected by a command; the cell you are currently using
 * __ Row: __** horizontal reference in a spreadsheet; represented by numbers
 * __ Column: __** vertical reference in a spreadsheet; represented by letters
 * __ Cell: __** intersection of a row and column
 * __ Workbook: __** a file containing multiple spreadsheets
 * __ Worksheet: __** single **spreadsheet** that contains cells organized by rows and columns
 * __ Autosum: __** a function used to ADD a set of values in a column or row
 * __ Average: __** a function that identifies the numeric average of a set of values in a column or a row; MEAN
 * __ Autofit: __** to resize a column or row so that it fits the data contained in a cell; determines the best width for a column or the best height for a row based on its contents
 * __ Merge & Center __** : to make one cell our of several highlighted cells and then center the content of the cells
 * __ Chart Title: __** title or name of a chart usually identifying what the data depicts; most often found at the center top of chart area
 * __ Data Label: __** value or name assigned to individual data points
 * __ Mean: __** average of a set of data
 * __ Median: __** middle number in a set of data when the data is arranged in numerical order
 * __ Mode: __** the number that occurs the most
 * __ Sheets Tab: __** tabs that appear at the BOTTOM of the workbook window, which displays the name of each worksheet

**Know how to write formulas, insert charts, etc. There will be an application portion, for example, creating a chart using given data and/or using formulas with given data.