| A | B |
|---|
| =Sheet2!D10 | Inserts the value in D10 of Sheet2. |
| =Sheet2!D10+Sheet3!D11 | Adds the values in D10 of Sheet 2 and D11 of Sheet3. |
| =SUM(Sheet2:Sheet4!D10) | Adds the values in cell D10 on Sheet2, Sheet3, and Sheet4. |
| =SUM(Sheet2!D10:D11) | Adds the values in D10 and D11 of Sheet2. |
| =Sheet3!D10+Sheet3!D11 | Adds the values in D10 and D11 of Sheet3. |
| Three-dimensional | These references are forumla references that incorporate data from worksheets in an active worksheet. |
| Workbook | A collection of worksheets. |
| Sheet tabs | This identifies worksheets within a workbook at the bottom of a workbook window |
| Active Sheet | The sheet of a workbook that appears on the screen. |
| Link | This transfers data from one worksheet to another. |
| workbook | is a collection of worksheets |
| Sheet tabs | identify worksheets within a workbook at the bottom of a workbook window |
| active sheet | A sheet of a workbook that appears on the screen |
| 3-d | formulas created to the same cell or range in multiple worksheets |
| Arrange | Allows you to view multiple workbooks at the same time. |
| Hiding worksheets permanetly removes it from the workbook. | False |
| You can insert a worksheet in a workbook as needed to accommodate your data. | True |
| When you create a reference to a cell in another worksheet the location where the data will be used is the source. | False |
| A worksheet range is a group of adjacent worksheets | True |
| In addition to printing an active worksheet or selected areas of an active worksheet, you can also print an entire workbook, selected worksheets, or selected areas of workbooks. | True |
