Question 1

When you lock a workbook you control the ability users have to make changes to the file.

Accepted Answer

The answer of When you lock a workbook you control...

Question 2

If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.

Accepted Answer

The validation rule will be based on an Excel logical formula, not "logistical."

Question 3

To open the Data Validation dialog box click the Data tab on the Ribbon and then click Authentication in the Data Tools group

Accepted Answer

To open the Data Validation dialog box, click the Data tab on the Ribbon and then click Data Validation in the Data Tools group, not Authentication.

Question 4

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet.

Accepted Answer

This statement is true. You can assign a macro to a button and place it directly on the worksheet to run the macro.

Question 5

When Excel creates a macro button the Assign Macro dialog box opens with the button's default name showing.

Accepted Answer

This is true. When creating a macro button, Excel will open the Assign Macro dialog box with the button's default name visible.

Question 6

A range name is more descriptive than a(n)cell reference .

Accepted Answer

A range name provides a label or description to a group of cells, making it easier to refer to them in formulas or functions, whereas a cell reference simply refers to a specific cell by its location in the spreadsheet. Thus, range names are generally considered more descriptive than cell references.

Question 7

Applications typically include an interface to assist the user in using the system ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

Accepted Answer

Applications can include interfaces with special buttons, customized commands, menus, and functions to assist users, making all of the options correct.

Question 8

The Name box lists all of the names currently defined in the workbook including Excel table names.

Accepted Answer

The answer of The Name box lists all of the...

Question 9

After the first character in a range name which of the following is acceptable?

Accepted Answer

Periods are acceptable within a range name after the first character, unlike hyphens or spaces which are not allowed.

Question 10

You use the Rules tab in the Data Validation dialog box to enter the validation rules for an active cell.

Accepted Answer

The Data Validation dialog box does not have a "Rules" tab; validation rules are set using the "Settings" tab.

Question 11

Every cell in a workbook has a(n)sealed property that determines whether or not changes can be made to that cell.

Accepted Answer

Cells in a workbook do not have a "sealed" property. Instead, cells can be locked or unlocked, and the worksheet can be protected to prevent changes to locked cells.

Question 12

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names.

Accepted Answer

This is true, as Excel doesn't allow blanks or parentheses in defined names.

Question 13

By default the locked property is turned off for each cell when you protect a workbook.

Accepted Answer

By default, the locked property is turned on for each cell in Excel, but it only takes effect when the worksheet is protected.

Question 14

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created.

Accepted Answer

The answer of A digital certificate confirms that the macro...

Question 15

Range names must begin with ____.

Accepted Answer

Range names in Excel must begin with either a letter or the underscore character. They cannot start with a number or most special characters.

Question 16

Which of the following is a valid function name?

Accepted Answer

The answer of Which of the following is a valid...

Question 17

Range names can be up to ____ characters.

Accepted Answer

Range names in Excel can be up to 255 characters long.

Question 18

The default is to protect only the windows used to display a workbook.

Accepted Answer

By default, Excel's protection features can be applied to the entire workbook, individual worksheets, or specific elements within worksheets, not just the windows used to display a workbook.

Question 19

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.

Accepted Answer

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.

Question 20

If you want to return to the Visual Basic Editor you can select one of the macros in the VBE dialog box and click the Edit button again.

Accepted Answer

The answer of If you want to return to the...

Quiz 8: Excel: Developing an Excel Application

When you lock a workbook you control the ability users have to make changes to the file.

If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.

To open the Data Validation dialog box click the Data tab on the Ribbon and then click Authentication in the Data Tools group

One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet.

When Excel creates a macro button the Assign Macro dialog box opens with the button's default name showing.

A range name is more descriptive than a(n)cell reference .

Applications typically include an interface to assist the user in using the system ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.

The Name box lists all of the names currently defined in the workbook including Excel table names.

After the first character in a range name which of the following is acceptable?

You use the Rules tab in the Data Validation dialog box to enter the validation rules for an active cell.

Every cell in a workbook has a(n)sealed property that determines whether or not changes can be made to that cell.

Any blanks or parentheses in row or column labels are changed to underscore characters in defined names.

By default the locked property is turned off for each cell when you protect a workbook.

A digital certificate confirms that the macro created by the signer has not been altered since the digital certificate was created.

Range names must begin with ____.

Which of the following is a valid function name?

Range names can be up to ____ characters.

The default is to protect only the windows used to display a workbook.

The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code.

If you want to return to the Visual Basic Editor you can select one of the macros in the VBE dialog box and click the Edit button again.