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.

Accepted Answer

When you save a workbook as a template in Microsoft Excel, it is automatically saved to the default location of the Custom Office Templates folder, which is located at c:/Users/Username/My Documents/CustomOfficeTemplates. This ensures that the template is easily accessible and can be used to create new workbooks without having to search for the template in other folders. Option A is incorrect because saving the template in the same folder as the workbook can lead to confusion and make it difficult to locate the template in the future. Option C is incorrect because it saves the template to the Desktop, which is not the default location for templates. Option D is incorrect because it saves the template to the My Documents folder, which is also not the default location for templates.

Question 2

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

Accepted Answer

Yes, a macro can be assigned to multiple objects in a worksheet, such as buttons, shapes, or even specific cells through the use of event handlers. This allows for greater functionality and automation in a worksheet.

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

Accepted Answer

A template is a predefined document structure that defines basic document settings such as font, margins, and available styles. It provides a starting point for creating a document with a particular format or layout.

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

Accepted Answer

A cell style is a collection of formatting attributes, such as font size and color, background color, border style, and alignment, that can be applied to a single cell or a range of cells. Cell styles are based on the currently selected theme in Excel and provide a consistent appearance within a worksheet. Templates and layouts are different concepts, while forms refer to data entry tools.

Question 5

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

Accepted Answer

Microsoft does not provide passwords to unlock protected worksheets. The only way to access the worksheet is to use a password recovery tool or recreate the worksheet from scratch.

Question 6

A subprocedure is created using the ________.
A)Visual Basic Editor
B)Visual Basic Creator
C)Procedure Editor
D)Procedure Creator

Accepted Answer

A subprocedure in Visual Basic is created using the Visual Basic Editor, which is an integrated development environment for creating and editing Visual Basic programs. The Visual Basic Editor provides tools for creating and modifying code, debugging programs, and testing applications.

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

Accepted Answer

The answer of To make it easier to run a...

Question 8

An image can be used as a worksheet background.

Accepted Answer

It is possible to use an image as a background for a worksheet in some programs, such as Microsoft Excel. It can help add visual interest or branding to a worksheet.

Question 9

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

Accepted Answer

This is true, you can choose which cells to lock or unlock when protecting a worksheet in Excel.

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

Accepted Answer

A theme is a pre-defined set of colors, fonts, and effects that can be applied to a workbook or presentation to give it a professional and consistent look. A form is a layout used to collect and organize data in a workbook. A template is a pre-designed document used as a starting point for a new document, while a style is a defined set of formatting characteristics, such as font size and color, used to format individual cells or ranges of cells in a workbook.

Question 11

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

Accepted Answer

The answer of After a macro has been added to...

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

Accepted Answer

The answer of The datestamp object,which was written in the...

Question 13

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

Accepted Answer

The answer of When creating a new workbook,you can select...

Question 14

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

Accepted Answer

The answer of When creating a new workbook,any templates that...

Question 15

You use the Macro ________ to capture your commands,keystrokes,and mouse clicks.
A)Register
B)Recorder
C)Documenter
D)Tracker

Accepted Answer

The Macro Recorder is used to capture commands, keystrokes, and mouse clicks. It allows the user to automate repetitive tasks by recording a series of actions and then playing them back later. The other options are not related to the task of capturing and automating commands.

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

Accepted Answer

The correct syntax to bold a specific cell using VBA is to use the "range" object followed by the cell reference, and then set the "Font.Bold" property to "True" to indicate that the font should be bolded. Therefore, the correct code would be "range("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

Accepted Answer

To automate the task of clearing existing values and displaying instructions for users to enter specific data, a macro is the best choice. A macro is a set of instructions or commands that can be recorded and played back as needed, so it can be designed to perform specific tasks automatically.

Question 18

To protect a worksheet,you click Format in the ________ group.
A)Cells
B)Worksheet
C)Workbook
D)Editing

Accepted Answer

Clicking on the "Format" option in the "Cells" group of the "Home" tab allows you to protect the worksheet by selecting "Protect Sheet" from the drop-down menu. This option opens the "Protect Sheet" dialog box where you can specify the options for protecting the worksheet, such as allowing or disallowing certain actions, entering a password for protection, etc.

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

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

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

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

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.

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

A subprocedure is created using the ________.

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

An image can be used as a worksheet background.

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

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

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

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

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

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

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

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

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

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