A | B |
Spreadsheet | A grid-like structure of rows and columns that contain data. |
Row | Start with numbers; are horizontal (across) |
Column | Begin with letters; are vertical (up & down) |
Cell | Intersection of a row and column |
Cell Address | Letter and number that identify a cell's location |
Workbook | A file that contains worksheets. |
Worksheet | A page in a workbook; another name for a spreadsheet |
Sheet Tab | Bottom of the file; help you to move from worksheet to worksheet. |
Active Cell | The cell you are working in; outlined in black. |
Excel | Microsoft's spreadsheet program |
Name box | ‐ the location below the ribbon where the active cell address appears |
Formula bar‐ | the location below the ribbon where the contents of the active cell appear |
Number format‐ | the description of the number formatting within a cell such as General, Accounting, Currency, etc. |
Sheet‐ | short for ‘worksheet’ / the area made up of cells where data and calculations are entered |
Workbook‐ | a collection of worksheets |
Text wrap‐ | a cell format that changes cell contents from one line to more than one line/ results in a narrower cel |
Fill handle‐ | a “+” that appears at the bottom, right‐hand corner of a cell that carries a formula or other contents of a cell down or across a range of cells |
Formula‐ | a calculation entered into a cell/ always begins with an = |
Chart‐ | a graphical representation of data |
Column chart – | what was typically referred to as a “bar graph” /consists of vertical bars and is used to compare and contrast data/ contains more than one set of data |
Bar chart‐ | a chart consisting of horizontal bars/ also used to compare and contrast data/ contains more than one set of data |
Pie chart‐ | a round chart that typically displays percentages or parts of a whole/ contains one set of data |
Line chart‐ | a chart displaying data in the form of a line with markers placed at specified intervals/ useful in showing trends over time/ contains more than one set of data |