CGS 2060 Lecture 9: CGS 9

21 views2 pages
15 Feb 2017
Worksheet group
A collection of two or more SELECTED worksheets. function: to make edits, overall
input to all at the same time without having to go into each one individually.
3D reference
a reference to the same cell in all or some of the worksheets in a workbook.
Summary Worksheet
Uses 3D references to summarize data.
External reference
a reference to cells or ranges in a worksheet from another workbook.
destination file
also called dependent file, the workbook that receives data from another workbook.
Arrange all button
displays all of the open workbooks in a title configuration within the program window.
Switch windows button
lists each open workbook so you can change which workbook is active.
an excel file that saves information about all of the currently opened workbooks, such as
their locations, window sizes, zoom level, and other settings.
Source file
when two or more workbooks are linked, THIS is a workbook that contains data to be
used in the destination file.
connection between files that allow data to be transferred from one file to the other.
divides open workbooks evenly on the screen
divides open workbooks into horizontal bands
divides open workbooks into vertical bands
layers open workbooks on the screen
indicates the file to which the link points
identifies the type of each source file.
specifies the way values are updated from the source file.
"A" update
indicates the link is updates automatically when you open the workbook or when both
the source and destination
find more resources at
find more resources at
Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Notes+

Unlimited access to class notes and textbook notes.

YearlyBest Value
75% OFF
$8 USD/m
$30 USD/m
You will be charged $96 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.