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