Chapter 5 Quiz
Which of the following is not true when typing text in a shape?
Selecting one shape selects all shapes in the SmartArt graphic
If values are edited in source worksheets used in a static data consolidation, which of the following commands will update the results?
Consolidate command
Which data consolidation method is used when data in multiple worksheets is arranged differently but has the same row and column labels?
Consolidation by category
Which of the following is used to select nonadjacent sheets?
Ctrl
Which of the following keyboard shortcuts switches to the next open workbook?
Ctrl+F6
Which of the following is the keyboard shortcut for inserting a hyperlink?
Ctrl+K
Which of the following cannot be performed when worksheets are grouped?
Insert a graphic
Where is the Take a Screenshot command located?
Insert tab, Illustrations group
Which of the following includes data that is referenced in a dependent workbook?
source workbook
Which of the following is not an example of SmartArt objects?
text effects
Which of the following is an example of an external reference with all of its identifiers?
='[WorkbookName]WorksheetName'!CellRange
Which of the following statements about SmartArt graphics is not true?
A SmartArt graphic is linked to worksheet data
Which command links workbooks?
Consolidate
Which of the following is the first step to insert a screenshot clipping in a worksheet?
Click the sheet tab where the screenshot will be inserted
Which of the following statements about data consolidation by category is true?
Data Consolidation by category can be either static or dynamic
Which of the following is not a procedure to prepare a consolidation worksheet?
Delete formulas that will be used on the consolidated worksheet
Which of the following is not true when consolidating by category?
Each item is expanded
Which of the following is not true after inserting a SmartArt graphic?
Each shape must be sized to fit the content
Which dialog box is used to update links in a workbook?
Edit Links dialog box
Which of the following tab and group options format a hyperlink?
Home tab, Font group
Which of the following is true of a SmartArt graphic's position in a worksheet?
It rests on an invisible, transparent layer in the worksheet
Which of the following is the process of referring to data in another workbook?
Linking
Which of the following commands sets a read-only file property?
Mark as Final
Which of the following makes it easier to take screenshots?
Open only two windows
Which of the following is not a function listed in the Consolidate dialog box?
PMT
When a screenshot graphic object is selected, which of the following context-sensitive tabs display?
Picture Tools, Format tab
When you place a screenshot in a worksheet, what type of object is it?
Picture object
To select part of a window for a screenshot, which of the following options should you select from the Illustrations group?
Screen Clipping
Which of the following is a picture of a full or partial computer screen inserted as an object in a worksheet?
Screenshot
Which of the following groups all sheets in a workbook?
Right-click any sheet tab and choose Select All Sheets
Which of the following ungroups all sheets in a workbook?
Right-click any sheet tab and choose Ungroup Sheets
Which of the following is used to select adjacent sheets?
Shift
Which of the following is a text-focused illustration that can be placed in Excel worksheets?
SmartArt graphic
When creating a cell hyperlink, which of the following is not true when selecting a Place in this Document option?
The Cell Reference and Defined Names groups cannot be expanded
Which of the following statements is not true about using the SmartArt Tools tabs?
The SmartArt Tools tabs do not include an option to change to a different image
Which of the following does not occur when you open a read-only file?
The worksheet requires a password
Which of the following is not true when creating object hyperlinks?
Underlined text displays below the hyperlink
Which of the following statements is not true about screenshots?
When capturing screen shots of online data, you do not need permission from the author or owner to use the image
Which of the following does not occur after a dynamic consolidation is created?
Worksheets are automatically grouped
Which of the following displays after the file name in the title bar when worksheets are grouped?
[Group]
When linking workbooks using a formula, what type of link is created?
a link to the source workbook
How does Excel display a sheet that is being used in a dynamic consolidation?
as an outline
Which of the following is not a component of a SmartArt graphic?
cell style
Which of the following summarizes data from multiple sheets with a mathematical or statistical function?
consolidated worksheet
Which of the following is a separate summary sheet in a workbook?
consolidation worksheet
Which of the following includes or refers to data from another workbook?
dependent workbook
Which of the following should you use when data on a source worksheet might be edited after you have created the consolidation worksheet?
dynamic data consolidation
Which of the following can you do immediately after you create a dynamic consolidation?
expand each outline item
Which of the following commands can you apply to grouped sheets that are not identical?
header or footer command
Which of the following is a character such as an exclamation point that marks or signifies a component of the reference?
identifier
