| A | B |
|---|
| Legend | Explainsitems in the chart. |
| Active Cell | The cell sorrounded by a heavy border, and where data can be entered. |
| Best Fit | Column width will be increased or decreased so the widest entry will fit in the column. |
| Worksheet | Electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations |
| Gridlines | Vertical and Horizontal lines. |
| Workbook | File that contains one or more worksheets that you can use to organize various kinds of related information. |
| Title | is the first line in the Excel spreadsheet. It is the most prominent heading in your sheet. |
| Average Function | Sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. |
| Merge & Center | Instructs Excel to combining two or more cells and center the contents of the cell. |
| Cell | The basic unit of a worksheet into which you enter data. |
| Formula Bar | Section in MS Excel and other spreadsheet applications that shows the contents of the current cell and allows you to create and view formulas. |
| Page Layout View | Allows you to create or modify a worksheet while viewing what it will look like once it’s printed. |
| MIN Function | Determines the lowest number in the range of cells. |
| Floating Dollar Sign | Appears immediately to the left of the first digit with no spaces. |
| Comma Style Format | inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. |
| Accounting Number | Designed for numbers with currency symbols, aligns currency symbols to the left in each cell, and displays zero values with a hyphen |
| Fixed Dollar Sign | added to the far left in the cell, often with spaces in between it and the first digit. |
| 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. |
| Embedded Chart | The chart containing the Excel sheet information. |
| Order of Operations | Excel follows PEMDAS by calculating operations enclosed in parentheses first, exponential calculations next, then multiplication and division (whichever comes first) and lastly, addition and subtraction (whichever comes first). |
| Max Function | Displays the highest value in a range. |
| Currency Number Format | Currency symbol appears right next to the first digit in the cell. |
| Accounting Number Format | Numbers that are displayed with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredth place). Aligns the currency symbols and decimal points of numbers in a column. |
| Function | A pre-written formula that is built into Excel. |
| Floating dollar sgn | appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cells dialog box. |
| Cell style | A defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. |
