Site MapHelpFeedbackLesson 17 - Consolidating and Linking Workbooks
Lesson 17 - Consolidating and Linking Workbooks
(See related pages)

1
Which command allows you to determine who can read, edit, and print a workbook?
A)Set Properties
B)Encrypt Document
C)Restrict Permission
D)Inspect Document
2
Which symbol, when clicked, displays the details in an outline?
A)+
B)-
C)*
D)~
3
When consolidating by category, what option must be selected in the Consolidate dialog box?
A)Create links to source data
B)Top row and Left column
C)Use all references
D)Update values
4
Which of the following workbook files obtains data from other workbooks?
A)Dependent
B)Sample
C)Source
D)Summary
5
If you are the administrator, what is an option for editing a document with restricted access?
A)You can change the permission.
B)You can break the links.
C)You can rename the workbook.
D)You can cut and copy the workbook.
6
Which of the following statements about a path is incorrect?
A)A path is an identifier.
B)A path specifies the file location on the drive.
C)A path precedes the filename.
D)A path hides the drive letter.
7
Which of the following attributes applies to linked workbooks?
A)They are the same size.
B)They depend on one another.
C)They are located in the same folder.
D)They are signed by one worker.
8
What happens if you open a workbook with restricted access?
A)The sheets are hidden.
B)The security message panel opens.
C)The links are broken.
D)The formulas are deleted.
9
How does a reference to a range appear in the Consolidate dialog box?
A)SheetName!B3:D7
B)SheetName!B3!:D7!
C)SheetName!$B$3:$D$7
D)SheetName$B3$:D7
10
What term describes the workbook with an external reference formula?
A)Dependent workbook
B)External workbook
C)Path workbook
D)Source workbook





To learn more about the book this website supports, please visit its Information Center.
(c)2008 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


PASOnline Learning Center

Home > Excel > Lesson 17 Quiz