BITM 215 EXAM 2 QUESTIONS & ANSWERS
consolidated worksheet - Answer -combines data from multiple worksheets using a
mathematical or statistical function
A static data consolidation - Answer -places a non-changing result in the consolidation
sheet. If the source data is edited, the consolidated sheet is not updated.
The Consolidate button is located - Answer -on the Data tab in the Data Tools group.
A dynamic data consolidation places - Answer -formulas in the consolidation
worksheet. If the source data is edited, the consolidated sheet is automatically updated.
Press Shift or Ctrl to - Answer -group contiguous or noncontiguous sheets.
Linking workbooks is - Answer -the process of referring to data in another workbook.
A dependent workbook refers - Answer -to data in another workbook.
A source workbook - Answer -supplies data to another workbook.
An external reference formula is - Answer -in a dependent workbook and refers to cells
in a source workbook.
An external reference includes the name of the workbook, the sheet name, cell
addresses, and - Answer -Identifiers
A SmartArt graphic is - Answer -an illustration such as a matrix, a cycle diagram, an
organization chart, or a process chart.
A screenshot is - Answer -an image of data on the screen inserted as a picture object
in a worksheet.
A hyperlink is - Answer -a line of text in a cell or an object in a worksheet.
Remove the Mark as Final setting by clicking - Answer -Enable Editing in the security
message bar.
To edit an Excel worksheet that is marked as final and therefore should not be edited,
click: - Answer -Edit anyway
To create a consolidated worksheet by position, both documents must have the same -
Answer -layout
, If you wish to make formatting changes to identical worksheets in a workbook, simply do
this before applying the changes. - Answer -group the worksheets
A static consolidation shows calculated values that: - Answer -do not automatically
update
If the data on your source worksheets might be edited after you have created your
consolidation, you should: - Answer -create a dynamic consolidation
You can build a data consolidation by category as long as the - Answer -Labels match
For workbooks to be linked, they must all be accessible over a network, on the same
computer, or - Answer -in the cloud
A character such as an exclamation point that marks or signifies a component of an
external reference is called a(n): - Answer -identifier
If a workbook refers to data in another workbook, it is a - Answer -Dependent
Workbook
Organization charts, matrices, pyramids, bulleted lists, and other similar diagrams
available within Office applications are called: - Answer -SmartArt
The rectangle that surrounds a SmartArt graphic is called a(n) - Answer -Bounding
frame.
The keyboard shortcut to insert a hyperlink is: - Answer -Ctrl+K
Once you place a screenshot in a worksheet, it becomes - Answer -a picture object
The Link button is located on this tab - Answer -Insert
The Mark as Final command results in a(n) - Answer -security message
Database functions are used with - Answer -list or table-type data.
A nested function is a - Answer -function within another function.
A forecast error is the - Answer -deviation or difference between actual values and
predicted or forecasted values.
The mean absolute deviation (MAD) is a - Answer -statistical measure of how spread
out a group of values is from the average.
A standard deviation measures - Answer -how broadly values vary from the mean
(average) value, a common statistical calculation.
consolidated worksheet - Answer -combines data from multiple worksheets using a
mathematical or statistical function
A static data consolidation - Answer -places a non-changing result in the consolidation
sheet. If the source data is edited, the consolidated sheet is not updated.
The Consolidate button is located - Answer -on the Data tab in the Data Tools group.
A dynamic data consolidation places - Answer -formulas in the consolidation
worksheet. If the source data is edited, the consolidated sheet is automatically updated.
Press Shift or Ctrl to - Answer -group contiguous or noncontiguous sheets.
Linking workbooks is - Answer -the process of referring to data in another workbook.
A dependent workbook refers - Answer -to data in another workbook.
A source workbook - Answer -supplies data to another workbook.
An external reference formula is - Answer -in a dependent workbook and refers to cells
in a source workbook.
An external reference includes the name of the workbook, the sheet name, cell
addresses, and - Answer -Identifiers
A SmartArt graphic is - Answer -an illustration such as a matrix, a cycle diagram, an
organization chart, or a process chart.
A screenshot is - Answer -an image of data on the screen inserted as a picture object
in a worksheet.
A hyperlink is - Answer -a line of text in a cell or an object in a worksheet.
Remove the Mark as Final setting by clicking - Answer -Enable Editing in the security
message bar.
To edit an Excel worksheet that is marked as final and therefore should not be edited,
click: - Answer -Edit anyway
To create a consolidated worksheet by position, both documents must have the same -
Answer -layout
, If you wish to make formatting changes to identical worksheets in a workbook, simply do
this before applying the changes. - Answer -group the worksheets
A static consolidation shows calculated values that: - Answer -do not automatically
update
If the data on your source worksheets might be edited after you have created your
consolidation, you should: - Answer -create a dynamic consolidation
You can build a data consolidation by category as long as the - Answer -Labels match
For workbooks to be linked, they must all be accessible over a network, on the same
computer, or - Answer -in the cloud
A character such as an exclamation point that marks or signifies a component of an
external reference is called a(n): - Answer -identifier
If a workbook refers to data in another workbook, it is a - Answer -Dependent
Workbook
Organization charts, matrices, pyramids, bulleted lists, and other similar diagrams
available within Office applications are called: - Answer -SmartArt
The rectangle that surrounds a SmartArt graphic is called a(n) - Answer -Bounding
frame.
The keyboard shortcut to insert a hyperlink is: - Answer -Ctrl+K
Once you place a screenshot in a worksheet, it becomes - Answer -a picture object
The Link button is located on this tab - Answer -Insert
The Mark as Final command results in a(n) - Answer -security message
Database functions are used with - Answer -list or table-type data.
A nested function is a - Answer -function within another function.
A forecast error is the - Answer -deviation or difference between actual values and
predicted or forecasted values.
The mean absolute deviation (MAD) is a - Answer -statistical measure of how spread
out a group of values is from the average.
A standard deviation measures - Answer -how broadly values vary from the mean
(average) value, a common statistical calculation.
