Site MapHelpFeedbackLesson 12 Quiz
Lesson 12 Quiz
(See related pages)

1
Which of the following statements correctly identifies when consolidation by position is possible in an Excel workbook?
A)Common data is in the same location on each sheet.
B)Data has the same row and column labels in different orders.
C)Common data is named in a unique scenario.
D)All labels and values are named with the same range name.
2
Which of the following statements about a summary Excel worksheet is true when a referenced value is changed after static consolidation?
A)The value updates.
B)The Edit Links dialog box opens.
C)Nothing is changed.
D)An error message appears.
3
Which of the following tasks would enable you to see an Excel shape's complete name in the Name Box?
A)Edit the name in the Selection and Visibility pane
B)Edit the name in the formula bar
C)Resize the Name Box
D)Collapse the Name Box
4
In an open Excel workbook, which of the following circumstances indicate that the worksheet is protected?
A)The sheets are hidden.
B)There is no Close button in the title bar.
C)The links are broken.
D)Many commands are grayed.
5
Which of the following terms describes an Excel workbook with an external reference formula?
A)Dependent workbook
B)External workbook
C)Path workbook
D)Source workbook
6
Which of the following statements explain why Excel displays a security message when you open a workbook that has an external reference formula?
A)Automatic updates are disabled.
B)All links are broken.
C)All formulas have been hidden.
D)All data has been deleted.
7
Which of the following results occurs when if you delete an external reference formula in a dependent Excel workbook?
A)The original link is maintained.
B)The cell contents are deleted.
C)The formula recalculates to zero.
D)The formula is converted to a value.
8
Which of the following are categories of shapes available in an Excel worksheet?
A)2-D Format, 3-D Format, and Bevel
B)Comments, Callouts, and Proportioned
C)Callouts, Stars and Banners, and Basic Shapes
D)Boxes, Bars, and Columns
9
Which of the following measurement units is used to rotate an image in an Excel worksheet?
A)Points
B)Pixels
C)Degrees
D)Spaces
10
Which of the following statements describes a difference between using an external reference and using the Consolidate command in an Excel worksheet?
A)The Consolidate command must use one of the available functions.
B)An external reference is limited to multiplication and division.
C)The Consolidate command is limited to addition and subtraction.
D)An external reference is temporary until the workbook is saved.





To learn more about the book this website supports, please visit its Information Center.
(c)2011 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.


Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 12 Quiz