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. |