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

1
When you save an Excel workbook as a template, how is the folder location determined?
A)Excel automatically sets it to the preset Templates folder.
B)Excel automatically lists all template folders on the computer.
C)You navigate to the preset Excel Templates folder.
D)You navigate to the Windows Templates folder.
2
Which of the following statements is the best definition of an Excel template?
A)It is a model workbook.
B)It is a summary workbook.
C)It is a custom workbook.
D)It is an installed workbook.
3
Which of the following reasons is true for activating worksheet protection in an Excel template?
A)To test formula accuracy
B)To prevent accidental deletion of labels
C)To provide sample data
D)To hide the worksheet's purpose
4
If you prefer to edit an original Excel sample template, which of the following task must be completed first?
A)Navigate to the folder where it is stored
B)Remove the file name extension
C)Change the workbook properties
D)Display a thumbnail image
5
Which of the following statements about macro-enabled Excel templates is true?
A)Macros must include keyboard shortcuts instead of form controls.
B)Macros are recorded as they are in any Excel workbook.
C)Macros are recorded using ActiveX programming language instead of Visual Basic for Applications.
D)Macros are edited in the Project window instead of the Code window.
6
Which of the following statements identifies the difference between using an Excel template as the basis for a new workbook and using an existing workbook?
A)The template includes labels, and the existing workbook includes values.
B)The template is named, and the existing workbook is not.
C)The existing workbook opens with blank cells, and the template includes sample data.
D)The template opens as a copy of itself, and the workbook opens as it is currently saved.
7
Which of the following features is available as part of the Protect Sheet command for an Excel workbook?
A)Renaming the sheet.
B)Setting a password.
C)Setting a thumbnail image.
D)Defining a custom property.
8
When protecting an Excel workbook, which of following elements are affected?
A)Windows and Layout
B)Structure and Windows
C)Structure and Worksheet
D)Windows and Worksheet
9
Which of the following statements about Excel workbook protection is true?
A)Workbook protection can be applied to a single worksheet.
B)Workbook protection requires a password.
C)Both worksheet and workbook protection can be applied to a workbook.
D)Workbook protection is set for multiple worksheets individually.
10
If an Excel template has worksheet protection, which of the following sizing button(s) are available?
A)Minimize/Maximize and Restore Down
B)Minimize/Maximize
C)Restore Down
D)Restore Down and Reset







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 17 Quiz