Deck 44: Templates, styles, and Macros: Hands-On-Exercise Videos

Question 1

When you save a workbook as a template,it is automatically saved to the:

A)same folder as the workbook.
B)c :/Users\Username\My Documents\CustomOfficeTemplates folder.
C)Desktop.
D)c : /Users\Username\My Documents folder.

Answer 1

B

Question 2

A macro can be assigned to more than one object in a worksheet.

Answer 2

True

Question 3

A ________ is a predefined document structure that defines basic document settings,such as font,margins,and available styles.

A)template
B)style
C)theme
D)pattern

Answer 3

A

Question 4

A cell ________ is a collection of format settings such as font and fill colors,borders,and alignment that is based on the currently selected theme to provide a consistent appearance within a worksheet.

A)form
B)layout
C)style
D)template

Question 5

If you forget the password to a protected worksheet,you can contact Microsoft to get a replacement password to unprotect it.

Question 6

A subprocedure is created using the ________.

A)Visual Basic Editor
B)Visual Basic Creator
C)Procedure Editor
D)Procedure Creator

Question 7

To make it easier to run a macro,you can assign the macro to ________.

A)the Ribbon
B)a menu
C)the Quick Access toolbar
D)a button

Question 8

An image can be used as a worksheet background.

Question 9

A protected worksheet can consist of both locked and unlocked cells.

Question 10

A ________ is a predefined set of colors,fonts,lines,and special effects that look good together and can be applied to a workbook.

A)form
B)theme
C)template
D)style

Question 11

After a macro has been added to a template,you should click Save to save the template with the macro.

Question 12

The datestamp object,which was written in the hands-on exercise,is an example of a(n)________.

A)subprocedure
B)custom function
C)argument
D)parameter

Question 13

When creating a new workbook,you can select a style from the gallery to give your workbook a consistent look.

Question 14

When creating a new workbook,any templates that you create can be displayed by clicking Personal in the New panel.

Question 15

You use the Macro ________ to capture your commands,keystrokes,and mouse clicks.

A)Register
B)Recorder
C)Documenter
D)Tracker

Question 16

The VBA code to bold the contents of cell H7 is ________.

A)range("H7").Font = Bold
B)cell("H7").Font = Bold
C)range("H7").Font.Bold = True
D)cell("H7").Font.Bold = True

Question 17

To automate the task of clear existing values and displaying instructions for users to enter specific data,you would create a(n)________.

A)event
B)procedure
C)argument
D)macro

Question 18

To protect a worksheet,you click Format in the ________ group.

A)Cells
B)Worksheet
C)Workbook
D)Editing