click below
click below
Normal Size Small Size show me how
AR ADV SS UNIT 5
Arkansas Advanced Spreadsheets Unit 5-Managing Multiple Worksheets and Workbooks
| Question | Answer |
|---|---|
| 3-D reference | The same cell or range in multiple worksheets in the same workbook |
| Custom template | A workbook template you can create that is ready to run with the formulas for all calculations included as well as formatting |
| Default template | A template that creates the blank Book1 workbook that originally opens. The default template contains no text or formulas. |
| Destination file | The workbook that receives the data when two files are linked |
| External reference | A reference to a cell or range in a worksheet in another workbook |
| HTML | A language that is used to create web pages |
| Hyperlink | A link in a file to information within that file or another file that, when clicked, switches to the file or portion of the file referenced by the link |
| Link | A connection between the files that allows data to be transferred from one file to the other |
| Source file | The workbook that contains the data when two files are linked |
| Template | A workbook that you can open with labels, formats and formulas already built into it from which you create new workbooks |
| Worksheet group | A collection of two or more selected worksheets in which everything you do to the active worksheet also affects the other worksheets in the group |
| Workspace | A file that saves information about all of the currently opened workbooks, such as their locations, window size, zoom magnifications, and other settings |