click below
click below
Normal Size Small Size show me how
Excel Vocab
| Term | Definition |
|---|---|
| Spreadsheet | a spreadsheet application is a computer program such as Excel |
| Workbook | an Excel file that contains one or more worksheets |
| Worksheet | a single spreadsheet that contains cells organized by rows and columns |
| Workbook Window | opens up three worksheet files for you to work with |
| Cell | the intersection point of a vertical column and a horizontal row |
| Sheet Tab | the current worksheet that is being displayed |
| Active Worksheet | the worrksheet you are working on |
| Workspace | a group of workbooks |
| Columns | columns run vertically in a worksheet |
| Rows | rows run horizontally in a worksheet |
| Headings | the grayish colored row containing the letters used to identify each column in the worksheet |
| Cell Reference | identifies the location a cell or group of cells in the worksheet |
| Name Box | displays the cell reference of the active cell |
| Formula Bar | displays the data or formula stored in the active cell |
| Relative Reference | when a function is copied and pasted to other cells, the cell references in the formula or function changed to reflect the function's new location |
| Absolute Reference | when a function is copied and pasted to other cells, the cell references in the formula or function does not change when a formula or function is copied to other cells |
| Mixed Reference | a combination of relative and absolute cell references |
| Active Cell | the current cell or the cell that is in focus |
| Enter Data | click on cell and input data |
| Range | A range is a group or block of cells in a worksheet that have been selected or highlighted |
| Gridlines | the lightly colored horizontal and vertical lines that appear around cells in a worksheet |
| $B$7:$A$9 is an absolute reference. T/F | T |
| In order to change our data in our chart, we must delete everything and make a new chart with new data. T/F | F |
| We can only view one sheet at a time in our spreadsheet. T/F | F |
| There are only 4 types of charts to choose from in Excel. T/F | F |
| We can change the chart type without deleting the original chart and making a new one. T/F | T |
| We can round up all our numbers to certain decimal places without manually changing our numbers. T/F | T |
| If our data fits in two pages, we can shrink the size of our data so that it only prints out in one page. T/F | T |
| Excel can only do simple equations such as addition, subtraction, multiplication, and division. T/F | F |
| We can change our cell size in order to fit all the data into one cell. T/F | T |
| We can insert columns in between our data, but it will change the formulas that we put in because of the additional column. T/F | F |