Excel Vocabulary

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

•         Table or Spreadsheet– Tool for organizing information into rows, columns, and cells.

•         Tab – is a spreadsheet rename tabs/spreadsheets

•         Cell – One box in a table or spreadsheet to enter data or formulas

•         Rows  - are numbered

•         Columns –are lettered

•         Data – Information, text, numbers

•         Formula FX =  math operation

•         Workbook – An Excel file consisting of many spreadsheets

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

•         Charts & Graphs - are visual representations of worksheet data.

Format -Appearance

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

Commands

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