15 terms

Excel Vocab

An Excel document which contains three worksheets by default but can have more than three
A single sheet contained in an Excel workbook
In a spreadsheet, these are the vertical spaces. Columns are headed with letters. There are a total of 256 columns on one worksheet.
In a spreadsheet the row is the horizontal group of cells. Rows are named with numbers, i.e. 1, 2, 3. There are total of 35,536 rows on a worksheet.
This is the place where information is held in a spreadsheet.
cell adress
Named using the letter and number where the column and row intersect.
active cell
This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.
sheet tabs
Labels located at the bottom of the workbook window indicating the worksheets.
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.
Function that automatically adds selected cells.
dollar symbol
Function that changes the contents of a cell to currency, adding a dollar sign and decimal places.
A mathematical formula typed into a cell.
entry bar
The toolbar on the Microsoft Excel window that shows the text or formulas.
A function that allows the user to change the value of a cell to a percent.
In a database this function puts the records into a specific order.