A | B |
accounting number format | Causes 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 handle | The 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 bar | As 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 view | Allows you to create or modify a worksheet while viewing what it will look like once it’s printed. |
legend | Identifies the items on the vertical axis on a column chart. |
order of operations | First do what is in the Parenthesis; then the Exponents; then Multiplication and Division; then Adding and Subtracting. |
gridlines | Will not print, but show the outline of each cell within a worksheet. |
worksheets | When you go on excel on the bottom left there will be sheet 1 sheet 2 and sheet 3 those are called _______________. |
currency format | Causes 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 sign | Will assign a dollar sign to appear immediately to the left of the first digit with no spaces. |
merge & Center | Allows 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 function | Determines the lowest number in the range of cells. You can enter it using either of the methods used to enter these functions. |
fixed dollar sign | When using this button to assign the accounting number format, Excel displays this. It appears immediately to the left of the first digit. |
active cell | In 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 number | It’s the dollar sign that is in front of the number. |
sheet tab | Tabs that bring you to a different sheet in the document. |
average function | Sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. |
workbook | The whole page is your workbook, because it is where all of your worksheets are stored. |
title | Is the first line in the Excel spreadsheet. It is the most prominent heading in your sheet. |
comma style format | Inserts a comma every three spots in a number to the left of the decimal point. |
best fit | The width of the column will be increased or decreased so the widest entry will fit in the column. |
cell | The basic unit of a worksheet into which you enter data. |
embedded chart | A chart inserted into a worksheet. |