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 |