How can we help?

You can also find more resources in our Help Center.

20 terms

Excel Vocabulary

STUDY
PLAY
Microsoft Excel
a spreadsheet application tool that analyzes data in a table format using formulas
Spreadsheet
a document that is used to crunch number and formulas
Column
Vertical spaces headed with letters. There a total of 256 and the last one is IV.
Row
Horizontal group of cells named with numbers; there a total of 65536 of them
Cell
the place where information is held in a spreadsheet
Active Cell
the cell in the spreadsheet where information will be placed; the cell that has been selected.
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.
Cell address
Tells you the exact location of a specific cell noating the intersection of the column and row that forms it
Work Book
An excel document that contains 3 worksheets by default but can have more than 3
Worksheet
A single sheet contained in an excel workbook
Sheet Tabs
Labels located at the bottom of the workbook window indicating the worksheets
Ascending decimals
a function that allows the user to increase decimal places of a number typed in a cell
Descending decimals
a function that allows the user to decrease decimal places of a number typed in a cell
Autosum
a function that automatically adds selected cells
Dollar symbol
a function that changes the contents of a cell to currency and adds a dollar sign and 2 decimal places
Equation
a mathmatical formula typed into a cell
Entry/formula bar
the tool bar that shows the text or eqaution assigned to cells
Percent sign
a function that allows the user to change the value of the cell to a percent by multiplying it by 100
Merge and center
a function allowing the user to select a number of cells to create one large cell with the information centered within the large cell
Sort
a function that puts records in specific order