info 2100 // Chapter 5 - SIMBook consolidating and linking data and inserting objects
identifier
a character such as an exclamation point that marks or signifies a component of an external reference is called a(n):
3D reference formula
a formula containing a reference that identifies the sheet name and the cell location
external reference
a formula is in a dependent workbook and refers to cells in a source workbook
external reference formula
a formula that links a dependent workbook to a source workbook
hyperlink
a line of text in a cell or an object in a worksheet
category
a row or column label
do not automatically update
a static consolidation shows calculated values that:
dependent workbook
a workbook that contains data cells from another workbook
hyperlink function
acts as a jump term or a shortcut to another location in the workbook, on the computer, or in the cloud
SmartArt graphic
an illustration such as a matrix, a cycle diagram, an organization chart, or a process chart
screenshot
an image of data on the screen inserted as a picture object in a worksheet
hyperlink
click on this text string or object and your pointer will jump to another location
consolidated worksheet
combines data from multiple worksheets using a mathematical or statistical function
Encrypt with Password command
enables you to assign a password to a workbook
source worksheet
existing worksheet containing a range included in a consolidation worksheet
screen clipping
feature of the Screenshot button that allows you to select a portion of a window
in the cloud
for workbooks to be linked, they must all be accessible over a network, on the same computer, or:
SmartArt
high-quality illustrations which often include text
by position
how are labels and values in the same position on all worksheets read through consolidation?
a file or from online sources
how can pictures be inserted in a worksheet?
point to build an external reference formula
how can you link workbooks using operators?
all sheets in the group
how do the edit and format commands affect grouped worksheets?
marking a worksheet as final
how do you assign a simple level of security to a workbook?
choose the Create links to source data option in the Consolidate dialog box
how do you build a dynamic data consolidation?
when a picture object is selected
how do you enable Picture Tools Format tab to display commands for changing the appearance of an image?
when a SmartArt graphic is selected
how do you enable SmartArt Tools Design and Format tabs?
press Shift or Ctrl
how do you group non/contiguous sheets?
ungroup sheets when finished editing
how do you guard against applying a command in error to to the group?
Illustrations group on the Insert tab
how do you insert 3D models in a worksheet?
building a formula that refers to another workbook
how do you link workbooks other than the Consolidate command?
build an external reference formula by typing the complete path and file name, the sheet name, cell addresses, and all identifiers
how do you link workbooks when the source workbook is not open?
use the Consolidate command on the Data tab when all workbooks are open
how do you link workbooks?
select an illustration object
how do you open a related contextual tools tab?
clicking Enable Editing in the security message bar
how do you remove the Mark as Final setting?
by category
how does Excel consolidate data when labels and values are not in the same position on all worksheets?
in the same order as the first sheet listed in the Consolidate dialog box
how does Excel display consolidated sheet labels?
static or dynamic
how does consolidation by category operate?
Excel outline
how does dynamic data consolidation format results?
dependent workbook
if a workbook refers to data in another workbook, it is a:
create a dynamic consolidation
if the data on your source worksheets might be edited after you have created your consolidation, you should:
group the worksheets
if you wish to make formatting changes to identical worksheets in a workbook, simply do this before applying the changes:
consolidation by category
in Excel, this refers to a consolidation based on row or column labels
not all commands are available
in group sheets, are all commands accessible?
consolidate button
located in the Data tab in the Data Tools group
a picture object
one you place a screenshot in a worksheet, it becomes:
SmartArt
organization charts, matrices, pyramids, bulleted lists, and other similar diagrams available within Office applications are called:
static data consolidation
places a non-changing result in the consolidation sheet; if the source data is edited, the consolidated sheet is not updated
dynamic data consoldiation
places formulas in the consolidation worksheet; if the source data is edited, the consolidated sheet is automatically updated
selection handles
points on the frame of a graphic used to resize it
dependent workbook
refers to data in another workbook
object hyperlink
shortcut assigned to an image, a SmartArt graphic, or another object
consolidate
summarize data from multiple worksheets
source workbook
supplies data to another workbook
Insert
the Link button is located on this tab:
security message
the Mark as Final command results in a(n):
Ctrl+K
the keyboard shortcut to insert a hyperlink is:
linking workbooks
the process of referring to data in another workbook
bounding frame
the rectangle that surrounding a SmartArt graphic is called a(n):
layout
to create a consolidated worksheet by position, both documents must have the same:
edit anyway
to edit an Excel worksheet that is marked as final and therefore should not be edited, click:
cell hyperlink
underlined text in the colour specified by the document theme
apply formats, enter formulas, or enter data
what can you do in grouped sheets?
SmartArt graphic
what consists of several smaller shapes, each of which can be formatted separately?
Icons button
what displays thumbnails of common symbols for use in a worksheet?
descriptive text, they are not linked to worksheet data
what do SmartArt graphics contain?
name of workbook, sheet name, cell addresses, and identifiers
what does an external reference include?
label cells on the source worksheets
what does the consolidate by category command include?
Excel Trust Centre
what includes security options for workbooks with links?
Mark as Final command
what is a reminder that the work is complete and should not be edited?
Link button
what is located in the Links groups on the Insert tab?
type the password
what must you do before the workbook can be opened if you encrypted a workbook with a password?
it is grayed out on the Ribbon
when a command is not available, how does the function display in Excel?
Protect Workbook button [File tab, Info pane]
where can you find the Mark as Final and Encrypt with Password commands?
labels match
you can build a data consolidation by category as long as the:
