Java Games: Flashcards, matching, concentration, and word search.

Excel Vocabulary

AB
accounting number formatCauses cells to display with two decimal places and a fixed dollar sign that is always left-aligned within the cell, regardless of column width.
fill handleThe small black square located in the lower-right corner of the heavy border around the active cell. Can be used to drag and drop/copy cells. allows you to copy and paste a formula from one cell into many cells.
formula barAs you type, excel displays what you type on a bar at the top of the page. You can make this larger by clicking the expand button to the right of the this. It is placed next to the name box.
page layout viewAllows you to create or modify a worksheet while viewing what it will look like once it’s printed.
legendIdentifies the items on the vertical axis on a column chart.
order of operationsFirst do what is in the Parenthesis; then the Exponents; then Multiplication and Division; then Adding and Subtracting.
gridlinesWill not print, but show the outline of each cell within a worksheet.
worksheetsWhen you go on excel on the bottom left there will be sheet 1 sheet 2 and sheet 3 those are called _______________.
currency formatCauses cells to display with two decimal places and a floating dollar sign that is always next to the number, regardless of column width.
floating dollar signWill assign a dollar sign to appear immediately to the left of the first digit with no spaces.
merge & CenterAllows you to center titles evenly above your data by merging a number of cells into one and then centering the title in this one cell.
minimum functionDetermines the lowest number in the range of cells. You can enter it using either of the methods used to enter these functions.
fixed dollar signWhen using this button to assign the accounting number format, Excel displays this. It appears immediately to the left of the first digit.
active cellIn an Excel worksheet, the ___________ is the cell with the black border. Data can only be entered into this. Even if more than one cell is selected, there is still only one. Use the mouse pointer or the arrow keys to change the location of this.
accounting numberIt’s the dollar sign that is in front of the number.
sheet tabTabs that bring you to a different sheet in the document.
average functionSums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.
workbookThe whole page is your workbook, because it is where all of your worksheets are stored.
titleIs the first line in the Excel spreadsheet. It is the most prominent heading in your sheet.
comma style formatInserts a comma every three spots in a number to the left of the decimal point.
best fitThe width of the column will be increased or decreased so the widest entry will fit in the column.
cellThe basic unit of a worksheet into which you enter data.
embedded chartA chart inserted into a worksheet.



This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities