click below
click below
Normal Size Small Size show me how
IBCT Spreadsheet
Excel
| Question | Answer |
|---|---|
| Active Cell | The cell in your worksheet that has been selected. It will have bolder gridlines around it. |
| AutoFill | A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected |
| AutoSum | A function that automatically identifies and adds ranges of cells in your worksheet |
| Cell | The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.l |
| Cell Address | The name of the cell is determined by the name of the row and the column intersecting, such as A8. |
| Cell Grid | The lines on your worksheet that separate the columns and rows. |
| Column | In a worksheet, the vertical spaces with headings ,A, B, C and so on. |
| Drag | When you move the mouse while holding down the mouse button (usually the left) to select a range of cells. |
| file | A document that is stored on you computer. In Excel, a file is also known as a workbook |
| Fill Down | A feature that allows you to copy information in an active cell to another cell or range of cells selected vertically |
| Fill right | a feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally |
| Formula | a combination of numbers and symbols used to express a calculation |
| Formula bar | a command line above the worksheet where text, numbers and formulas are entered into a worksheet |
| Function | a drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet |
| label | the identifying name that reflects the information contained in a column or row in a worksheet, such as name or date. |
| Row | In a worksheet, the horizontal spaces with the headings 1,2,3 and so on |
| Sheet tabs | Tabs you see at the bottom of you workbook file, labeled sheet 1, sheet 2, |
| workbook | An excel file that contains individual worksheets. Also called a spreadsheet file |
| Worksheet | a "page" within an Excel workbook that contains columns, rows, and cells. |
| Excel | a Microsoft Office program that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. |