Technology - Spread sheets


Active Cell – This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.

Ascending Decimals – Function that allows the user to increase decimals places of a number typed in a cell.

AutoSum – Function that automatically adds selected cells.

Cell – This is the place where information is held in a spreadsheet.

Cell Address – Use this to know the exact location of a specific cell. Noting the intersection of the column and row forms it. The last cell address on a worksheet is IV65,536.

Column – In a spreadsheet, these are the vertical spaces. Columns are headed with letters. There are a total of 256 columns on one worksheet. The last column is IV.

Descending Decimals - Function that allows the user to decrease decimals places of a number typed in a cell.

Dollar Symbol – Function that changed the contents of a cell to currency. Adds a dollar sign and decimal places

Equation – A mathematical equation typed into a cell.

Entry/Formula Bar – The toolbar on the Microsoft Excel window that shows the text or equations assigned to cells

Merge and Center – Function allowing the user to select a number of cells to create one large cell with the information centered within the large cell.

Microsoft Excel – A spreadsheet application tool that analyzes data in a table format using formulas.

Name box – Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.

Percent – Function that allows the user to change the value of a cell to a percent.

Row – In a spreadsheet, the row is the horizontal group of cells. Rows are named with numbers, i.e.1, 2, 3. There are a total of 65,536 rows on a worksheet.

Sheet tabs – Labels located at the bottom of the workbook window indicating the worksheets.

Spreadsheet – A document that is used to crunch numbers and formulas.

Sort – In a database, this function puts the records into a specific order.

Workbook – An Excel document which contains three worksheets by default but can have more than three.

Worksheet – A single sheet contained in an Excel workbook.