Excel – Spreadsheet, graphing software that can perform mathematical functions.

Table or Spreadsheet– Tool for organizing information into rows, columns, and cells on a grid for manipulating calculations (math operations, sorting).

Workbook – An Excel file consisting of many spreadsheets is called a workbook.

Cell – One box in a table or spreadsheet is referred to as a cell. You can enter data or formulas into cells.

Rows  - are numbered 1, 2, 3 etc.

Columns –are lettered A, B, C etc.

Data – Information, text, numbers

Formula FX =  Formula toolbar for math operations toolbar

Decrease Decimal: Decreases one decimal place at a time. Values are rounded when decimals are decreased.

Charts & Graphs - are visual representations of worksheet data.

Analyze – examine in detail for purpose of explanation

Determine – Cause something to occur, result

Explain – describe in detail relevant facts, cause, give reason

Refer – point out, mention, comment

Format –Appearance, style, color

Borders – Frame of table or spreadsheet Lines

Graph or ChartWizard - A visual representation of data

Commonly Used Mathematical Formulas

1.    AutoSum = Addition =Sum(B3:B10) Example

2.    Average – Math Formula, [Some of all numbers divided by the number of numbers], Excel =AVERAGE(B4:B6)

3.    = Represents Formula NOT DATA in cell when using EXCEL

4.    Black Crosshair + gives the command to copy formula

Commands

Þ      Sort – Ascending (A-Z) or descending (Z-A) alphabetical order.

 v  Resize Symbol v  Resize Symbol Math Words Describe Data Graph Pictures:

·       More, Most, Greatest, Highest

·       Less, Least, lesser, few

·       Than measure compare word

·       Large, great, Maximum

·       Small, Slight,

·       Even the same